namespace ComplianceDAL.Query.AdapterConfig;

public static class AdapterConfigQB
{
    public const string GET_ADAPTER_CONFIG = @"
        SELECT
            a.ADAPTERCONFIGID AS AdapterConfigId,
            a.GSPCONFIGID     AS GSPConfigId,
            g.GSPNAME         AS GSPName,
            a.FRAMEWORK       AS Framework,
            a.GSTIN           AS GSTIN,
            a.AUTHURL         AS AuthURL,
            a.BASEURL         AS BaseURL,
            a.CLIENTIDAPI     AS ClientIdAPI,
            a.CLIENTSECRET    AS ClientSecret,
            a.ISACTIVE        AS IsActive,
            a.CREATEDBYID     AS CreatedById,
            a.CREATEDON       AS CreatedOn,
            a.MODIFIEDBYID    AS ModifiedById,
            a.MODIFIEDON      AS ModifiedOn
        FROM MCOMPLIANCE_ADAPTER_CONFIG a
        JOIN MGSP_CONFIG g ON g.GSPCONFIGID = a.GSPCONFIGID
        WHERE a.ADAPTERCONFIGID = @AdapterConfigId
          AND a.CLIENTID        = @ClientId
          AND a.DATABASENAME    = @DatabaseName";

    // Pending: the user will follow up with the actual EINVOICEENVIRONMENT (Sandbox vs Production)
    // selection logic — for now AdapterConfigDAL defaults BaseURL/AuthURL to the Sandbox URL.
    // CLIENTID/OUID come from the caller's LoginDTO (ClientId/WorkOUId) — not hardcoded.
    // OBJECTTYPEID (MADDRESS's polymorphic discriminator for "organization unit address") stays a
    // literal — it's a fixed schema constant, not a per-tenant/session value.
    public const string GET_ADAPTER_CONFIG_BY_GSTIN = @"
        SELECT a.GSPID as GSPID,
               b.GSPNAME as GSPNAME,
               b.ASPCLIENTID as ASPCLIENTID,
               b.ASPID as ASPID,
               b.ASPSECRET as ASPSECRET,
               b.ASPSOURCE as ASPSOURCE,
               b.EINVOICESANDBOXBASEURL as EINVOICESANDBOXBASEURL,
               b.EINVOICEPRODUCTIONBASEURL as EINVOICEPRODUCTIONBASEURL,
               d.GSTIN as GSTIN,
               e.EINVOICEUSERID as EINVOICEUSERID,
               e.EINVOICEPASSWORD as EINVOICEPASSWORD,

               b.EWAYSANDBOXBASEURL as EWAYSANDBOXBASEURL,
               b.EWAYPRODUCTIONBASEURL as EWAYPRODUCTIONBASEURL,
               e.EWAYUSERID as EWAYUSERID,
               e.EWAYPASSWORD as EWAYPASSWORD,

               b.GSPCLIENTID as GSPCLIENTID,
               b.GSPCLIENTSECRET as GSPCLIENTSECRET,
               e.GSTNUSERID as GSTNUSERID,
               b.SANDBOXBASEURL as GSTSANDBOXBASEURL,
               b.PRODUCTIONBASEURL as GSTPRODUCTIONBASEURL,

               b.EINVOICEENVIRONMENT as EINVOICEENVIRONMENT,
               b.EWAYENVIRONMENT as EWAYENVIRONMENT,
               b.GSTENVIRONMENT as GSTENVIRONMENT,

               b.PUBLICSEARCHURL as PUBLICSEARCHURL,
               b.PUBLICSEARCHENVIRONMENT as PUBLICSEARCHENVIRONMENT,

               f.GSTSTATECODE as STATECODE
        FROM   MCOMPLIANCE_ADAPTER_CONFIG a
               , MGSP b,
               MORGANIZATIONUNIT c,
               MADDRESS d,
               MGST e,
               MSTATE f
        WHERE  a.GSPID = b.GSPID
               AND a.CLIENTID = @ClientId
               AND c.OUID = @OUId
               AND c.OUID = d.OBJECTID
               AND d.OBJECTTYPEID = -1899999977
               AND d.GSTIN = e.GSTIN
               AND d.STATEID = f.STATEID
               AND a.gstin = @GSTIN
               AND a.framework = @Framework";

    public const string GET_ADAPTER_CONFIG_LIST = @"
        SELECT
            a.ADAPTERCONFIGID AS AdapterConfigId,
            a.GSPCONFIGID     AS GSPConfigId,
            g.GSPNAME         AS GSPName,
            a.FRAMEWORK       AS Framework,
            a.GSTIN           AS GSTIN,
            a.ISACTIVE        AS IsActive,
            a.CREATEDON       AS CreatedOn
        FROM MCOMPLIANCE_ADAPTER_CONFIG a
        JOIN MGSP_CONFIG g ON g.GSPCONFIGID = a.GSPCONFIGID
        WHERE a.CLIENTID     = @ClientId
          AND a.DATABASENAME = @DatabaseName
        ORDER BY a.GSTIN, a.FRAMEWORK";

    public const string SAVE_ADAPTER_CONFIG = @"
        INSERT INTO MCOMPLIANCE_ADAPTER_CONFIG
            (ADAPTERCONFIGID, GSPCONFIGID, FRAMEWORK, GSTIN,
             AUTHURL, BASEURL, CLIENTIDAPI, CLIENTSECRET, ISACTIVE,
             CLIENTID, DATABASENAME, CREATEDBYID, CREATEDON)
        VALUES
            (@AdapterConfigId, @GSPConfigId, @Framework, @GSTIN,
             @AuthURL, @BaseURL, @ClientIdAPI, @ClientSecret, @IsActive,
             @ClientId, @DatabaseName, @CreatedById, GETUTCDATE())";

    public const string UPDATE_ADAPTER_CONFIG = @"
        UPDATE MCOMPLIANCE_ADAPTER_CONFIG SET
            GSPCONFIGID  = @GSPConfigId,
            FRAMEWORK    = @Framework,
            GSTIN        = @GSTIN,
            AUTHURL      = @AuthURL,
            BASEURL      = @BaseURL,
            CLIENTIDAPI  = @ClientIdAPI,
            CLIENTSECRET = @ClientSecret,
            ISACTIVE     = @IsActive,
            MODIFIEDBYID = @ModifiedById,
            MODIFIEDON   = GETUTCDATE()
        WHERE ADAPTERCONFIGID = @AdapterConfigId
          AND CLIENTID        = @ClientId
          AND DATABASENAME    = @DatabaseName";
}