using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace FrameworkDAL.Query.ClientDeveloper
{
    public static class ClientDeveloperQB
    {
        public const string GET_CLIENT_DEVELOPER = @"SELECT
                                                    CD.CLIENTDEVELOPERID      AS ClientDeveloperId,
                                                    CD.SLNO                   AS ClientDeveloperSlno,
                                                    CD.CLIENTAUTHTOKEN        AS ClientDeveloperClientAuthToken,
                                                    CD.ISACTIVE               AS ClientDeveloperIsActive,
                                                    CD.VALIDTILL              AS ClientDeveloperValidTill,
                                                    CD.DIGEST                 AS ClientDeveloperDigest,

                                                    -- Client
                                                    C.CLIENTID                AS ClientId,
                                                    C.CLIENTCODE              AS ClientCode,
                                                    C.CLIENTNAME              AS ClientName,

                                                    -- Developer
                                                    D.DEVELOPERID             AS DeveloperId,
                                                    D.DEVELOPERNAME           AS DeveloperName,
                                                    D.ACCESSKEYID             AS DeveloperAccessKeyId   -- assuming column name is ACCESSKEYID

                                                FROM MCLIENTDEVELOPER CD
                                                LEFT JOIN MCLIENT C
                                                    ON CD.CLIENTID = C.CLIENTID
                                                LEFT JOIN MDEVELOPER D
                                                    ON CD.DEVELOPERID = D.DEVELOPERID
                                                WHERE CD.CLIENTID = @ClientId;";

    }
}