namespace GoodBooks.PAY.PAYDAL.Query.Gateway
{
    /// <summary>
    /// SQL constants for MPAYGATEWAY (DevAdmin platform catalogue).
    /// NOTE: MPAYGATEWAY queries intentionally have NO TENANTID filter —
    /// this is a platform-level catalogue managed by DevAdmin, not per-tenant data.
    /// </summary>
    public static class PayGatewayQB
    {
        // INDEX NOTES:
        // MPAYGATEWAY: IX_MPAYGATEWAY_STATUS — (STATUS) INCLUDE (PAYGATEWAYCODE, PAYGATEWAYNAME, GATEWAYTYPE, SORTORDER)
        //   → Used by GET_PAY_GATEWAY_LIST and GET_SELECT_LIST_GATEWAY
        // MPAYGATEWAY: PK_MPAYGATEWAY — clustered on PAYGATEWAYID
        //   → Used by GET_PAY_GATEWAY

        public const string GET_PAY_GATEWAY = @"
            SELECT
                G.PAYGATEWAYID        AS PayGatewayId,
                G.PAYGATEWAYCODE      AS PayGatewayCode,
                G.PAYGATEWAYNAME      AS PayGatewayName,
                G.GATEWAYTYPE         AS GatewayType,
                G.SUPPORTSUPI         AS SupportsUpi,
                G.SUPPORTSCARD        AS SupportsCard,
                G.SUPPORTSNETBANKING  AS SupportsNetBanking,
                G.SUPPORTSCOD         AS SupportsCod,
                G.SUPPORTSREFUND      AS SupportsRefund,
                G.SUPPORTSPAYOUT      AS SupportsPayout,
                G.WEBHOOKENDPOINT     AS WebhookEndpoint,
                G.LOGOURL             AS LogoUrl,
                G.REMARKS             AS Remarks,
                G.VERSION             AS Version,
                G.STATUS              AS Status,
                G.SORTORDER           AS SortOrder,
                G.CREATEDBYID         AS CreatedById,
                G.CREATEDON           AS CreatedOn,
                G.MODIFIEDBYID        AS ModifiedById,
                G.MODIFIEDON          AS ModifiedOn,
                G.SOURCETYPE          AS SourceType,
                G.TENANTID            AS TenantId
            FROM MPAYGATEWAY G
            WHERE G.PAYGATEWAYID = @PayGatewayId";

        public const string GET_PAY_GATEWAY_LIST = @"
            SELECT
                G.PAYGATEWAYID        AS PayGatewayId,
                G.PAYGATEWAYCODE      AS PayGatewayCode,
                G.PAYGATEWAYNAME      AS PayGatewayName,
                G.GATEWAYTYPE         AS GatewayType,
                G.SUPPORTSUPI         AS SupportsUpi,
                G.SUPPORTSCARD        AS SupportsCard,
                G.SUPPORTSNETBANKING  AS SupportsNetBanking,
                G.SUPPORTSCOD         AS SupportsCod,
                G.SUPPORTSREFUND      AS SupportsRefund,
                G.SUPPORTSPAYOUT      AS SupportsPayout,
                G.WEBHOOKENDPOINT     AS WebhookEndpoint,
                G.LOGOURL             AS LogoUrl,
                G.REMARKS             AS Remarks,
                G.VERSION             AS Version,
                G.STATUS              AS Status,
                G.SORTORDER           AS SortOrder,
                G.CREATEDBYID         AS CreatedById,
                G.CREATEDON           AS CreatedOn,
                G.MODIFIEDBYID        AS ModifiedById,
                G.MODIFIEDON          AS ModifiedOn,
                G.SOURCETYPE          AS SourceType,
                G.TENANTID            AS TenantId
            FROM MPAYGATEWAY G
            WHERE G.STATUS = 1
            ORDER BY G.SORTORDER, G.PAYGATEWAYNAME";

        public const string GET_SELECT_LIST_GATEWAY = @"
            SELECT
                G.PAYGATEWAYID        AS PayGatewayId,
                G.PAYGATEWAYCODE      AS PayGatewayCode,
                G.PAYGATEWAYNAME      AS PayGatewayName,
                G.GATEWAYTYPE         AS GatewayType
            FROM MPAYGATEWAY G
            WHERE G.STATUS = 1
            ORDER BY G.SORTORDER, G.PAYGATEWAYNAME";

        public const string SAVE_PAY_GATEWAY = @"
            INSERT INTO MPAYGATEWAY (
                PAYGATEWAYID,
                PAYGATEWAYCODE,
                PAYGATEWAYNAME,
                GATEWAYTYPE,
                SUPPORTSUPI,
                SUPPORTSCARD,
                SUPPORTSNETBANKING,
                SUPPORTSCOD,
                SUPPORTSREFUND,
                SUPPORTSPAYOUT,
                WEBHOOKENDPOINT,
                LOGOURL,
                REMARKS,
                VERSION,
                STATUS,
                SORTORDER,
                CREATEDBYID,
                CREATEDON,
                MODIFIEDBYID,
                MODIFIEDON,
                SOURCETYPE
            ) VALUES (
                @paygatewayid,
                @PayGatewayCode,
                @PayGatewayName,
                @GatewayType,
                @SupportsUpi,
                @SupportsCard,
                @SupportsNetBanking,
                @SupportsCod,
                @SupportsRefund,
                @SupportsPayout,
                @WebhookEndpoint,
                @LogoUrl,
                @Remarks,
                @Version,
                @Status,
                @SortOrder,
                @CreatedById,
                @CreatedOn,
                @ModifiedById,
                @ModifiedOn,
                @SourceType
            )";

        public const string UPDATE_PAY_GATEWAY = @"
            UPDATE MPAYGATEWAY SET
                PAYGATEWAYCODE      = @PayGatewayCode,
                PAYGATEWAYNAME      = @PayGatewayName,
                GATEWAYTYPE         = @GatewayType,
                SUPPORTSUPI         = @SupportsUpi,
                SUPPORTSCARD        = @SupportsCard,
                SUPPORTSNETBANKING  = @SupportsNetBanking,
                SUPPORTSCOD         = @SupportsCod,
                SUPPORTSREFUND      = @SupportsRefund,
                SUPPORTSPAYOUT      = @SupportsPayout,
                WEBHOOKENDPOINT     = @WebhookEndpoint,
                LOGOURL             = @LogoUrl,
                REMARKS             = @Remarks,
                VERSION             = @Version,
                STATUS              = @Status,
                SORTORDER           = @SortOrder,
                MODIFIEDBYID        = @ModifiedById,
                MODIFIEDON          = @ModifiedOn,
                SOURCETYPE          = @SourceType
            WHERE PAYGATEWAYID = @PayGatewayId";
    }
}