namespace ComplianceDAL.Query.GSTRegistration;

public static class GSTRegistrationQB
{
    public const string GET_GST_REGISTRATION = @"
        SELECT
            r.GSTREGISTRATIONID   AS GSTRegistrationId,
            r.GSTIN               AS GSTIN,
            r.LEGALNAME           AS LegalName,
            r.TRADENAME           AS TradeName,
            r.STATECODE           AS StateCode,
            r.STATENAME           AS StateName,
            r.REGISTRATIONTYPE    AS RegistrationType,
            r.OUID                AS OUId,
            r.OUNAME              AS OUName,
            r.ISACTIVE            AS IsActive,
            r.CREATEDBYID         AS CreatedById,
            r.CREATEDON           AS CreatedOn,
            r.MODIFIEDBYID        AS ModifiedById,
            r.MODIFIEDON          AS ModifiedOn
        FROM MGST_REGISTRATION r
        WHERE r.GSTREGISTRATIONID = @GSTRegistrationId
          AND r.CLIENTID          = @ClientId
          AND r.DATABASENAME      = @DatabaseName";

    public const string GET_GST_REGISTRATION_LIST = @"
        SELECT
            r.GSTREGISTRATIONID   AS GSTRegistrationId,
            r.GSTIN               AS GSTIN,
            r.LEGALNAME           AS LegalName,
            r.STATECODE           AS StateCode,
            r.REGISTRATIONTYPE    AS RegistrationType,
            r.OUID                AS OUId,
            r.OUNAME              AS OUName,
            r.ISACTIVE            AS IsActive,
            r.CREATEDBYID         AS CreatedById,
            r.CREATEDON           AS CreatedOn
        FROM MGST_REGISTRATION r
        WHERE r.CLIENTID     = @ClientId
          AND r.DATABASENAME = @DatabaseName
        ORDER BY r.LEGALNAME";

    public const string GET_GST_REGISTRATION_SELECT_LIST = @"
        SELECT
            r.GSTREGISTRATIONID AS Id,
            r.GSTIN + ' - ' + r.LEGALNAME AS Name
        FROM MGST_REGISTRATION r
        WHERE r.CLIENTID     = @ClientId
          AND r.DATABASENAME = @DatabaseName
          AND r.ISACTIVE     = 1
        ORDER BY r.LEGALNAME";

    public const string SAVE_GST_REGISTRATION = @"
        INSERT INTO MGST_REGISTRATION
            (GSTREGISTRATIONID, GSTIN, LEGALNAME, TRADENAME, STATECODE, STATENAME,
             REGISTRATIONTYPE, OUID, OUNAME, ISACTIVE,
             CLIENTID, DATABASENAME, CREATEDBYID, CREATEDON)
        VALUES
            (@GSTRegistrationId, @GSTIN, @LegalName, @TradeName, @StateCode, @StateName,
             @RegistrationType, @OUId, @OUName, @IsActive,
             @ClientId, @DatabaseName, @CreatedById, GETUTCDATE())";

    public const string UPDATE_GST_REGISTRATION = @"
        UPDATE MGST_REGISTRATION SET
            GSTIN            = @GSTIN,
            LEGALNAME        = @LegalName,
            TRADENAME        = @TradeName,
            STATECODE        = @StateCode,
            STATENAME        = @StateName,
            REGISTRATIONTYPE = @RegistrationType,
            OUID             = @OUId,
            OUNAME           = @OUName,
            ISACTIVE         = @IsActive,
            MODIFIEDBYID     = @ModifiedById,
            MODIFIEDON       = GETUTCDATE()
        WHERE GSTREGISTRATIONID = @GSTRegistrationId
          AND CLIENTID          = @ClientId
          AND DATABASENAME      = @DatabaseName";

    public const string DELETE_GST_REGISTRATION = @"
        UPDATE MGST_REGISTRATION SET
            ISACTIVE     = 0,
            MODIFIEDBYID = @ModifiedById,
            MODIFIEDON   = GETUTCDATE()
        WHERE GSTREGISTRATIONID = @GSTRegistrationId
          AND CLIENTID          = @ClientId
          AND DATABASENAME      = @DatabaseName";

    public const string COUNT_GST_REGISTRATION_LIST = @"
        SELECT COUNT(1)
        FROM MGST_REGISTRATION r
        WHERE r.CLIENTID     = @ClientId
          AND r.DATABASENAME = @DatabaseName";
}