namespace PromotionExchangeDAL.Query;

public static class ExchangePartyQB
{
    public const string GET_BY_API_KEY_HASH = @"
        SELECT ENVIRONMENTCODE AS EnvironmentCode,
               DISPLAYNAME     AS DisplayName,
               APIKEYHASH      AS ApiKeyHash,
               ISACTIVE        AS IsActive,
               CREATEDBYID     AS CreatedById,
               CREATEDON       AS CreatedOn,
               MODIFIEDBYID    AS ModifiedById,
               MODIFIEDON      AS ModifiedOn
        FROM   MEXCHANGEPARTY
        WHERE  APIKEYHASH = @ApiKeyHash
        AND    ISACTIVE   = 1";

    public const string GET_BY_ENVIRONMENT_CODE = @"
        SELECT ENVIRONMENTCODE AS EnvironmentCode,
               DISPLAYNAME     AS DisplayName,
               APIKEYHASH      AS ApiKeyHash,
               ISACTIVE        AS IsActive,
               CREATEDBYID     AS CreatedById,
               CREATEDON       AS CreatedOn,
               MODIFIEDBYID    AS ModifiedById,
               MODIFIEDON      AS ModifiedOn
        FROM   MEXCHANGEPARTY
        WHERE  ENVIRONMENTCODE = @EnvironmentCode
        AND    ISACTIVE        = 1";
}