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

namespace FrameworkDAL.Query.Merge
{
    public static class MergeQB
    {
        public const string GET_MERGE = @"SELECT 
                                            M.MERGEID AS MergeId,
                                            M.MERGECODE AS MergeCode,
                                            M.MERGENAME AS MergeName ,
                                            M.MODULEID AS ModuleId,
                                            M.ISCONSTRAINTBASED AS MergeIsConstraintBased,
                                            M.DATATYPE AS MergeDataType,
                                            M.LENGTH AS MergeLength,
                                            M.PREC AS MergePrec,
                                            M.SCALE AS MergeScale,
                                            M.PURPOSE AS MergePurpose,
                                            M.REMARKS AS MergeRemarks,
                                            M.INPUTTYPE AS MergeInputType,
                                            M.PICKLISTID AS PicklistId,
                                            M.SOURCEDBOBJECTID AS SourceDBObjectId,
                                            M.SOURCEDBOBJECTFIELDID AS SourceDbObjectFieldId,
                                            M.SORTORDER AS MergeSortOrder,
                                            M.STATUS AS MergeStatus,
                                            M.VERSION AS  MergeVersion,
                                            M.CREATEDBYID AS MergeCreatedById,
                                            M.CREATEDON AS MergeCreatedOn,
                                            M.MODIFIEDBYID AS MergeModifiedById,
                                            M.MODIFIEDON AS MergeModifiedOn,
                                            M.SOURCETYPE AS MergeSourceType
                                            FROM MMERGE M
                                            WHERE M.MERGEID=@mergeid;";


        public const string SAVE_MERGE = @"INSERT INTO MMERGE
                                            (
                                                MERGEID,
                                                MERGECODE,
                                                MERGENAME,
                                                MODULEID,
                                                ISCONSTRAINTBASED,
                                                DATATYPE,
                                                LENGTH,
                                                PREC,
                                                SCALE,
                                                PURPOSE,
                                                REMARKS,
                                                INPUTTYPE,
                                                PICKLISTID,
                                                SOURCEDBOBJECTID,
                                                SOURCEDBOBJECTFIELDID,
                                                SORTORDER,
                                                STATUS,
                                                VERSION,
                                                CREATEDBYID,
                                                CREATEDON,
                                                MODIFIEDBYID,
                                                MODIFIEDON,
                                                SOURCETYPE
                                            )
                                            VALUES
                                            (
                                                @MergeId,
                                                @MergeCode,
                                                @MergeName,
                                                @ModuleId,
                                                @MergeIsConstraintBased,
                                                @MergeDataType,
                                                @MergeLength,
                                                @MergePrec,
                                                @MergeScale,
                                                @MergePurpose,
                                                @MergeRemarks,
                                                @MergeInputType,
                                                @PicklistId,
                                                @SourceDBObjectId,
                                                @SourceDbObjectFieldId,
                                                @MergeSortOrder,
                                                @MergeStatus,
                                                @MergeVersion,
                                                @MergeCreatedById,
                                                @MergeCreatedOn,
                                                @MergeModifiedById,
                                                @MergeModifiedOn,
                                                @MergeSourceType
                                            );";

        public const string GET_SELECTLIST_MERGE = @"WITH PagedMerge AS (
                                                                    SELECT
                                                                        M.MERGEID AS Id,
                                                                        M.MERGECODE AS Code,
                                                                        M.MERGENAME AS Name,
                                                                        ROW_NUMBER() OVER (ORDER BY M.MERGEID) AS RowNum
                                                                    FROM MMERGE M
                                                                )
                                                                SELECT Id, Code, Name
                                                                FROM PagedMerge
                                                             WHERE 
                                                             (@firstnumber = -1 AND @maxresult = -1)
                                                             OR (RowNum BETWEEN @firstnumber AND @maxresult);";


        public const string UPDATE_MERGE = @"UPDATE MMERGE
                                            SET
                                                MERGECODE = @MergeCode,
                                                MERGENAME = @MergeName,
                                                MODULEID = @ModuleId,
                                                ISCONSTRAINTBASED = @MergeIsConstraintBased,
                                                DATATYPE = @MergeDataType,
                                                LENGTH = @MergeLength,
                                                PREC = @MergePrec,
                                                SCALE = @MergeScale,
                                                PURPOSE = @MergePurpose,
                                                REMARKS = @MergeRemarks,
                                                INPUTTYPE = @MergeInputType,
                                                PICKLISTID = @PicklistId,
                                                SOURCEDBOBJECTID = @SourceDBObjectId,
                                                SOURCEDBOBJECTFIELDID = @SourceDbObjectFieldId,
                                                SORTORDER = @MergeSortOrder,
                                                STATUS = @MergeStatus,
                                                VERSION = @MergeVersion,
                                                CREATEDBYID = @MergeCreatedById,
                                                CREATEDON = @MergeCreatedOn,
                                                MODIFIEDBYID = @MergeModifiedById,
                                                MODIFIEDON = @MergeModifiedOn,
                                                SOURCETYPE = @MergeSourceType
                                            WHERE MERGEID = @MergeId;
                                            ";

        public const string DELETE_MERGE = @"DELETE FROM MMERGE
                                            WHERE MERGEID = @MergeId;";

    }
}