namespace GoodBooks.PAY.PAYDAL.Query.Gateway
{
    /// <summary>
    /// SQL constants for MPAYCHECKOUTCONFIG.
    /// All queries MUST filter by TENANTID — per-tenant checkout configuration.
    /// </summary>
    public static class CheckoutConfigQB
    {
        // INDEX NOTES:
        // MPAYCHECKOUTCONFIG: PK_MPAYCHECKOUTCONFIG — clustered on CHECKOUTCONFIGID
        //   → Used by GET_CHECKOUT_CONFIG
        // MPAYCHECKOUTCONFIG: IX_MPAYCHECKOUTCONFIG_TENANTID_STATUS
        //   — (TENANTID, STATUS) INCLUDE (CONFIGNAME, ISDEFAULT)
        //   → Used by GET_CHECKOUT_CONFIG_FOR_TENANT (returns active config for the tenant)

        public const string GET_CHECKOUT_CONFIG = @"
            SELECT
                CC.CHECKOUTCONFIGID         AS CheckoutConfigId,
                CC.CONFIGNAME               AS ConfigName,
                CC.ALLOWCOD                 AS AllowCod,
                CC.ALLOWPARTIALPAY          AS AllowPartialPay,
                CC.MINPARTIALPAYAMT         AS MinPartialPayAmt,
                CC.ALLOWB2C                 AS AllowB2C,
                CC.ALLOWSAVEDINSTRUMENT     AS AllowSavedInstrument,
                CC.PAYMENTEXPIRYMINS        AS PaymentExpiryMins,
                CC.DEFAULTCURRENCY          AS DefaultCurrency,
                CC.DEFAULTGATEWAYCONFID     AS DefaultGatewayConfId,
                CC.REMARKS                  AS Remarks,
                CC.VERSION                  AS Version,
                CC.STATUS                   AS Status,
                CC.SORTORDER                AS SortOrder,
                CC.CREATEDBYID              AS CreatedById,
                CC.CREATEDON                AS CreatedOn,
                CC.MODIFIEDBYID             AS ModifiedById,
                CC.MODIFIEDON               AS ModifiedOn,
                CC.SOURCETYPE               AS SourceType,
                CC.TENANTID                 AS TenantId
            FROM MPAYCHECKOUTCONFIG CC
            WHERE CC.CHECKOUTCONFIGID = @CheckoutConfigId
              AND CC.TENANTID = @TenantId";

        public const string GET_CHECKOUT_CONFIG_FOR_TENANT = @"
            SELECT TOP 1
                CC.CHECKOUTCONFIGID         AS CheckoutConfigId,
                CC.CONFIGNAME               AS ConfigName,
                CC.ALLOWCOD                 AS AllowCod,
                CC.ALLOWPARTIALPAY          AS AllowPartialPay,
                CC.MINPARTIALPAYAMT         AS MinPartialPayAmt,
                CC.ALLOWB2C                 AS AllowB2C,
                CC.ALLOWSAVEDINSTRUMENT     AS AllowSavedInstrument,
                CC.PAYMENTEXPIRYMINS        AS PaymentExpiryMins,
                CC.DEFAULTCURRENCY          AS DefaultCurrency,
                CC.DEFAULTGATEWAYCONFID     AS DefaultGatewayConfId,
                CC.REMARKS                  AS Remarks,
                CC.VERSION                  AS Version,
                CC.STATUS                   AS Status,
                CC.SORTORDER                AS SortOrder,
                CC.CREATEDBYID              AS CreatedById,
                CC.CREATEDON                AS CreatedOn,
                CC.MODIFIEDBYID             AS ModifiedById,
                CC.MODIFIEDON               AS ModifiedOn,
                CC.SOURCETYPE               AS SourceType,
                CC.TENANTID                 AS TenantId
            FROM MPAYCHECKOUTCONFIG CC
            WHERE CC.TENANTID = @TenantId
              AND CC.STATUS = 1
            ORDER BY CC.SORTORDER";

        public const string SAVE_CHECKOUT_CONFIG = @"
            INSERT INTO MPAYCHECKOUTCONFIG (
                CHECKOUTCONFIGID,
                CONFIGNAME,
                ALLOWCOD,
                ALLOWPARTIALPAY,
                MINPARTIALPAYAMT,
                ALLOWB2C,
                ALLOWSAVEDINSTRUMENT,
                PAYMENTEXPIRYMINS,
                DEFAULTCURRENCY,
                DEFAULTGATEWAYCONFID,
                REMARKS,
                VERSION,
                STATUS,
                SORTORDER,
                CREATEDBYID,
                CREATEDON,
                MODIFIEDBYID,
                MODIFIEDON,
                SOURCETYPE,
                TENANTID
            ) VALUES (
                @CheckoutConfigId,
                @ConfigName,
                @AllowCod,
                @AllowPartialPay,
                @MinPartialPayAmt,
                @AllowB2C,
                @AllowSavedInstrument,
                @PaymentExpiryMins,
                @DefaultCurrency,
                @DefaultGatewayConfId,
                @Remarks,
                @Version,
                @Status,
                @SortOrder,
                @CreatedById,
                @CreatedOn,
                @ModifiedById,
                @ModifiedOn,
                @SourceType,
                @TenantId
            )";

        public const string UPDATE_CHECKOUT_CONFIG = @"
            UPDATE MPAYCHECKOUTCONFIG SET
                CONFIGNAME              = @ConfigName,
                ALLOWCOD                = @AllowCod,
                ALLOWPARTIALPAY         = @AllowPartialPay,
                MINPARTIALPAYAMT        = @MinPartialPayAmt,
                ALLOWB2C                = @AllowB2C,
                ALLOWSAVEDINSTRUMENT    = @AllowSavedInstrument,
                PAYMENTEXPIRYMINS       = @PaymentExpiryMins,
                DEFAULTCURRENCY         = @DefaultCurrency,
                DEFAULTGATEWAYCONFID    = @DefaultGatewayConfId,
                REMARKS                 = @Remarks,
                VERSION                 = @Version,
                STATUS                  = @Status,
                SORTORDER               = @SortOrder,
                MODIFIEDBYID            = @ModifiedById,
                MODIFIEDON              = @ModifiedOn,
                SOURCETYPE              = @SourceType
            WHERE CHECKOUTCONFIGID = @CheckoutConfigId
              AND TENANTID = @TenantId";
    }
}