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

namespace FrameworkDAL.Query.BIZTransactionSubClass
{
    public static class BIZTransactionSubClassQB
    {
        public const string GET_BIZTRANSACTIONSUBCLASS = @"
        SELECT 
            MB.BIZTRANSACTIONSUBCLASSID      AS BIZTransactionSubClassId,
            MB.BIZTRANSACTIONSUBCLASSCODE    AS BIZTransactionSubClassCode,
            MB.BIZTRANSACTIONSUBCLASSNAME    AS BIZTransactionSubClassName,

            -- Joined Class Table Fields
            BC.BIZTRANSACTIONCLASSID         AS BIZTransactionClassId,
            BC.BIZTRANSACTIONCLASSCODE       AS BIZTransactionClassCode,
            BC.BIZTRANSACTIONCLASSNAME       AS BIZTransactionClassName,

            MB.SORTORDER                     AS BIZTransactionSubClassSortOrder,
            MB.STATUS                        AS BIZTransactionSubClassStatus,
            MB.VERSION                       AS BIZTransactionSubClassVersion,
            MB.SOURCETYPE                    AS BIZTransactionSubClassSourceType,

            MB.CREATEDBYID                   AS BIZTransactionSubClassCreatedById,
            MB.CREATEDON                     AS BIZTransactionSubClassCreatedOn,
            MB.MODIFIEDBYID                  AS BIZTransactionSubClassModifiedById,
            MB.MODIFIEDON                    AS BIZTransactionSubClassModifiedOn,
            MB.TENANTID                      AS TenantId
        FROM
            MBIZTRANSACTIONSUBCLASS MB
        INNER JOIN
            MBIZTRANSACTIONCLASS BC ON MB.BIZTRANSACTIONCLASSID = BC.BIZTRANSACTIONCLASSID
        WHERE
            MB.BIZTRANSACTIONSUBCLASSID = @biztransactionsubclassid;";
        public const string GET_SELECTLIST_BIZTRANSACTION_SUB_CLASS = @"WITH PagedBIZTRANSACTIONSUBCLASS AS (
                                                SELECT
                                                    A.BIZTRANSACTIONSUBCLASSID AS Id,
                                                    A.BIZTRANSACTIONSUBCLASSCODE AS Code,
                                                    A.BIZTRANSACTIONSUBCLASSNAME AS Name,
                                                    ROW_NUMBER() OVER (ORDER BY A.BIZTRANSACTIONSUBCLASSID) AS RowNum
                                                FROM MBIZTRANSACTIONSUBCLASS A
                                            )
                                            SELECT Id, Code, Name
                                            FROM PagedBIZTRANSACTIONSUBCLASS
                                            WHERE 
                                             (@firstnumber = -1 AND @maxresult = -1)
                                             OR (RowNum BETWEEN @firstnumber AND @maxresult);";
        public const string SAVE_BIZTRANSACTION_SUB_CLASS = @"
        INSERT INTO MBIZTRANSACTIONSUBCLASS 
        (
            BIZTRANSACTIONSUBCLASSID,
            BIZTRANSACTIONSUBCLASSCODE,
            BIZTRANSACTIONSUBCLASSNAME,
            BIZTRANSACTIONCLASSID,
            SORTORDER,
            STATUS,
            VERSION,
            SOURCETYPE,
            CREATEDBYID,
            CREATEDON,
            MODIFIEDBYID,
            MODIFIEDON
        )
        VALUES
        (
            @BIZTransactionSubClassId,
            @BIZTransactionSubClassCode,
            @BIZTransactionSubClassName,
            @BIZTransactionClassId,
            @BIZTransactionSubClassSortOrder,
            @BIZTransactionSubClassStatus,
            @BIZTransactionSubClassVersion,
            @BIZTransactionSubClassSourceType,
            @BIZTransactionSubClassCreatedById,
            @BIZTransactionSubClassCreatedOn,
            @BIZTransactionSubClassModifiedById,
            @BIZTransactionSubClassModifiedOn
        );";
        public const string UPDATE_BIZTRANSACTION_SUB_CLASS = @"
        UPDATE MBIZTRANSACTIONSUBCLASS
        SET
            BIZTRANSACTIONSUBCLASSID = @BIZTransactionSubClassId,
            BIZTRANSACTIONSUBCLASSCODE = @BIZTransactionSubClassCode,
            BIZTRANSACTIONSUBCLASSNAME = @BIZTransactionSubClassName,
            BIZTRANSACTIONCLASSID = @BIZTransactionClassId,
            SORTORDER = @BIZTransactionSubClassSortOrder,
            STATUS = @BIZTransactionSubClassStatus,
            VERSION = @BIZTransactionSubClassVersion,
            SOURCETYPE = @BIZTransactionSubClassSourceType,
            MODIFIEDBYID = @BIZTransactionSubClassModifiedById,
            MODIFIEDON = @BIZTransactionSubClassModifiedOn
        WHERE
            BIZTRANSACTIONSUBCLASSID = @BIZTransactionSubClassId;
    ";
        public const string DELETE_BIZTRANSACTION_SUB_CLASS = @"
        DELETE FROM MBIZTRANSACTIONSUBCLASS
        WHERE BIZTRANSACTIONSUBCLASSID = @BIZTransactionSubClassId;";
    }
}