using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MMDAL.Query.TransactionType
{
    public static class TransactionTypeQB
    {
        public const string GET_TRANSACTIONTYPE = @"
SELECT
    T.TRANSACTIONTYPEID            AS TransactionTypeId,
    T.TRANSACTIONTYPECODE          AS TransactionTypeCode,
    T.TRANSACTIONTYPENAME          AS TransactionTypeName,
    T.TYPE                         AS TransactionTypeTypeName,
    T.LOCATIONTYPE                 AS TransactionTypeLocationTypeName,
    T.FORMRECEIVED                 AS TransactionTypeFormReceived,
    T.FORMISSUED                   AS TransactionTypeFormIssued,
    T.ISFORMRECEIVED               AS TransactionTypeIsFormReceived,
    T.ISFORMISSUED                 AS TransactionTypeIsFormIssued,
    T.VATCATEGORY                  AS TransactionTypeVatCategory,
    T.VATSECTION                   AS TransactionTypeVatSection,
    T.RG1CATEGORY                  AS TransactionTypeRG1CategoryName,
    T.CREDITTYPE                   AS TransactionTypeCreditTypeName,
    T.TRACKINGTYPE                 AS TransactionTypeTrackingTypeName,
    T.GSTCATEGORYID                AS GSTCategoryId,
    G.GSTCATEGORYNAME              AS GSTCategoryName,
    T.REGISTRATION                 AS TransactionTypeRegistration,

    T.SORTORDER                    AS TransactionTypeSortOrder,
    T.STATUS                       AS TransactionTypeStatus,
    T.VERSION                      AS TransactionTypeVersion,
    T.SOURCETYPE                   AS TransactionTypeSourceType,

    T.CREATEDBYID                  AS TransactionTypeCreatedById,
    UC.USERNAME                    AS TransactionTypeCreatedByName,
    T.CREATEDON                    AS TransactionTypeCreatedOn,

    T.MODIFIEDBYID                 AS TransactionTypeModifiedById,
    UM.USERNAME                    AS TransactionTypeModifiedByName,
    T.MODIFIEDON                   AS TransactionTypeModifiedOn,

    T.TENANTID                     AS TenantId,
    TN.TENANTNAME                  AS TenantName

FROM MTRANSACTIONTYPE T
LEFT JOIN MUSER UC ON T.CREATEDBYID = UC.USERID
LEFT JOIN MUSER UM ON T.MODIFIEDBYID = UM.USERID
LEFT JOIN MCLIENT TN ON T.TENANTID = TN.CLIENTID
LEFT JOIN MGSTCATEGORY G ON T.GSTCATEGORYID = G.GSTCATEGORYID
WHERE T.TRANSACTIONTYPEID = @TransactionTypeId;
";
        public const string SAVE_TRANSACTIONTYPE = @"INSERT INTO MTRANSACTIONTYPE (
                                                            TRANSACTIONTYPEID,
                                                            TRANSACTIONTYPECODE,
                                                            TRANSACTIONTYPENAME,
                                                            TYPE,
                                                            LOCATIONTYPE,
                                                            FORMRECEIVED,
                                                            FORMISSUED,
                                                            ISFORMRECEIVED,
                                                            ISFORMISSUED,
                                                            SORTORDER,
                                                            STATUS,
                                                            VERSION,
                                                            VATCATEGORY,
                                                            CREATEDBYID,
                                                            CREATEDON,
                                                            MODIFIEDBYID,
                                                            MODIFIEDON,
                                                            TRANSACTIONTYPE,
                                                            CREDITTYPE,
                                                            TRACKINGTYPE,
                                                            SOURCETYPE,
                                                            VATSECTION,
                                                            RG1CATEGORY,
                                                            GSTCATEGORYID,
                                                            REGISTRATION,
                                                            TENANTID
                                                        )
                                                        VALUES (
                                                            @TransactionTypeId,
                                                            @TransactionTypeCode,
                                                            @TransactionTypeName,
                                                            @TransactionTypeTypeName,
                                                            @TransactionTypeLocationTypeName,
                                                            @TransactionTypeFormReceived,
                                                            @TransactionTypeFormIssued,
                                                            @TransactionTypeIsFormReceived,
                                                            @TransactionTypeIsFormIssued,
                                                            @TransactionTypeSortOrder,
                                                            @TransactionTypeStatus,
                                                            @TransactionTypeVersion,
                                                            @TransactionTypeVatCategory,
                                                            @TransactionTypeCreatedById,
                                                            @TransactionTypeCreatedOn,
                                                            @TransactionTypeModifiedById,
                                                            @TransactionTypeModifiedOn,
                                                            @TransactionTypeTranscType,
                                                            @TransactionTypeCreditTypeName,
                                                            @TransactionTypeTrackingTypeName,
                                                            @TransactionTypeSourceType,
                                                            @TransactionTypeVatSection,
                                                            @TransactionTypeRG1CategoryName,
                                                            @GSTCategoryId,
                                                            @TransactionTypeRegistration,
                                                            @TenantId
                                                        );
                                                        ";
        public const string UPDATE_TRANSACTIONTYPE = @"
UPDATE MTRANSACTIONTYPE
SET
    TRANSACTIONTYPECODE    = @TransactionTypeCode,
    TRANSACTIONTYPENAME    = @TransactionTypeName,
    TYPE                   = @TransactionTypeTypeName,
    LOCATIONTYPE           = @TransactionTypeLocationTypeName,
    FORMRECEIVED           = @TransactionTypeFormReceived,
    FORMISSUED             = @TransactionTypeFormIssued,
    ISFORMRECEIVED         = @TransactionTypeIsFormReceived,
    ISFORMISSUED           = @TransactionTypeIsFormIssued,
    SORTORDER              = @TransactionTypeSortOrder,
    STATUS                 = @TransactionTypeStatus,
    VERSION                = @TransactionTypeVersion,
    VATCATEGORY            = @TransactionTypeVatCategory,
    MODIFIEDBYID           = @TransactionTypeModifiedById,
    MODIFIEDON             = @TransactionTypeModifiedOn,
    TRANSACTIONTYPE        = @TransactionTypeTranscType,
    CREDITTYPE             = @TransactionTypeCreditTypeName,
    TRACKINGTYPE           = @TransactionTypeTrackingTypeName,
    SOURCETYPE             = @TransactionTypeSourceType,
    VATSECTION             = @TransactionTypeVatSection,
    RG1CATEGORY            = @TransactionTypeRG1CategoryName,
    GSTCATEGORYID          = @GSTCategoryId,
    REGISTRATION           = @TransactionTypeRegistration,
    TENANTID               = @TenantId
WHERE TRANSACTIONTYPEID = @TransactionTypeId;";


        public const string DELETE_TRANSACTIONTYPE = @"
DELETE FROM MTRANSACTIONTYPE WHERE TRANSACTIONTYPEID = @TransactionTypeId;
";
        public const string GET_SELECTLIST_TRANSACTIONTYPE = @"SELECT
                                                                T.TRANSACTIONTYPEID   AS Id,
                                                                T.TRANSACTIONTYPECODE AS Code,
                                                                T.TRANSACTIONTYPENAME AS Name,
                                                                T.TYPE                AS Type,
                                                                T.STATUS              AS Status
                                                            FROM MTRANSACTIONTYPE T
                                                            WHERE T.STATUS = 1;";
    }
}