namespace ComplianceDAL.Query.GSPConfig;

public static class GSPConfigQB
{
    public const string GET_GSP_CONFIG = @"
        SELECT
            g.GSPCONFIGID    AS GSPConfigId,
            g.GSPNAME        AS GSPName,
            g.SOURCETYPE     AS SourceType,
            CASE g.SOURCETYPE
                WHEN 1 THEN 'GSTCafe'
                WHEN 2 THEN 'MasterSuvidha'
                WHEN 3 THEN 'Capri'
                WHEN 4 THEN 'SpiceDigital'
                WHEN 5 THEN 'Direct'
                ELSE 'Unknown'
            END              AS SourceTypeName,
            g.ISACTIVE       AS IsActive,
            g.CREATEDBYID    AS CreatedById,
            g.CREATEDON      AS CreatedOn,
            g.MODIFIEDBYID   AS ModifiedById,
            g.MODIFIEDON     AS ModifiedOn
        FROM MGSP_CONFIG g
        WHERE g.GSPCONFIGID  = @GSPConfigId
          AND g.CLIENTID     = @ClientId
          AND g.DATABASENAME = @DatabaseName";

    public const string GET_GSP_CONFIG_LIST = @"
        SELECT
            g.GSPCONFIGID AS GSPConfigId,
            g.GSPNAME     AS GSPName,
            g.SOURCETYPE  AS SourceType,
            g.ISACTIVE    AS IsActive,
            g.CREATEDON   AS CreatedOn
        FROM MGSP_CONFIG g
        WHERE g.CLIENTID     = @ClientId
          AND g.DATABASENAME = @DatabaseName
        ORDER BY g.GSPNAME";

    public const string GET_GSP_CONFIG_SELECT_LIST = @"
        SELECT
            g.GSPCONFIGID AS Id,
            g.GSPNAME     AS Name
        FROM MGSP_CONFIG g
        WHERE g.CLIENTID     = @ClientId
          AND g.DATABASENAME = @DatabaseName
          AND g.ISACTIVE     = 1
        ORDER BY g.GSPNAME";

    public const string SAVE_GSP_CONFIG = @"
        INSERT INTO MGSP_CONFIG
            (GSPCONFIGID, GSPNAME, SOURCETYPE, ISACTIVE,
             CLIENTID, DATABASENAME, CREATEDBYID, CREATEDON)
        VALUES
            (@GSPConfigId, @GSPName, @SourceType, @IsActive,
             @ClientId, @DatabaseName, @CreatedById, GETUTCDATE())";

    public const string UPDATE_GSP_CONFIG = @"
        UPDATE MGSP_CONFIG SET
            GSPNAME      = @GSPName,
            SOURCETYPE   = @SourceType,
            ISACTIVE     = @IsActive,
            MODIFIEDBYID = @ModifiedById,
            MODIFIEDON   = GETUTCDATE()
        WHERE GSPCONFIGID  = @GSPConfigId
          AND CLIENTID     = @ClientId
          AND DATABASENAME = @DatabaseName";
}