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

namespace FrameworkDAL.Query.CriteriaAttribute
{
    public static class CriteriaAttributeQB
    {
        public const string GetSelectList_CriteriaAttribute = @"
                                                              WITH PagedCriteriaAttribute AS (
		                                                      SELECT
                                                             CA.CRITERIAATTRIBUTEID AS Id,
                                                             CA.CRITERIAATTRIBUTENAME AS Name,
                                                             CA.SECTION AS section,

                                                            ROW_NUMBER() OVER (ORDER BY CA.CRITERIAATTRIBUTEID) AS RowNum
                                                        FROM MCRITERIAATTRIBUTE CA
                                                    )
                                                    SELECT
                                                        Id,
                                                        Name,
                                                        section
                                                    FROM PagedCriteriaAttribute
                                                    WHERE 
                                                          (@firstnumber = -1 AND @maxresult = -1)
                                                          OR (RowNum BETWEEN @firstnumber AND @maxresult);";
        public const string GET_CRITERIAATTRIBUTE = @"
        SELECT 
        CA.CRITERIAATTRIBUTEID AS CriteriaAttributeId,
CA.CRITERIAATTRIBUTENAME AS CriteriaAttributeName,
CA.CRITERIAATTRIBUTETYPE AS CriteriaAttributeType,
CA.SECTION AS CriteriaAttributeSection,
CA.PICKLISTID AS PicklistId,
CA.APPLICABLEVALUES AS CriteriaAttributeApplicableValues,
CA.DEFAULTVALUEINDEX AS CriteriaAttributeDefaultValueIndex,
CA.ISCONTEXTVALUE AS CriteriaAttributeIsContextValue,
CA.CONTEXTVALUEFIELDNAME AS CriteriaAttributeContextValueFieldName,
CA.ISDATARESTRICTION AS CriteriaAttributeIsDataRestriction,
CA.VARIABLEFIELD AS CriteriaAttributeVariableField,
CA.APPLICABLEOPERATION AS CriteriaAttributeApplicableOperation,
CA.DEFAULTOPERATION AS CriteriaAttributeDefaultOperation,
CA.SORTORDER AS CriteriaAttributeSortOrder,
CA.STATUS AS CriteriaAttributeStatus,
CA.VERSION AS CriteriaAttributeVersion,
CA.SOURCETYPE AS CriteriaAttributeSourceType,
CA.CREATEDBYID AS CriteriaAttributeCreatedById,
CA.CREATEDON AS CriteriaAttributeCreatedOn,
CA.MODIFIEDBYID AS CriteriaAttributeModifiedById,
CA.MODIFIEDON AS CriteriaAttributeModifiedOn,
CA.GCMTYPEID AS GcmTypeId,
CA.FILTERTYPE AS CriteriaAttributeFilterType,
CA.SECTIONID AS SectionId,
CA.SECTIONSLNO AS SectionSLNo,
CA.CRITERIADESCRIPTION AS CriteriaDescription,
CA.CRITERIAHELPID AS CriteriaHelpId
FROM 
        MCRITERIAATTRIBUTE CA
        WHERE 
        CA.CRITERIAATTRIBUTEID  = @criteriaattributeid

         ;";

        public const string SAVE_CRITERIAATTRIBUTE = @"INSERT 
                            INTO MCRITERIAATTRIBUTE (
                                 CRITERIAATTRIBUTEID,
                                 CRITERIAATTRIBUTENAME,
                                 CRITERIAATTRIBUTETYPE,
                                 SECTION,
                                 PICKLISTID,
                                 APPLICABLEVALUES,
                                 DEFAULTVALUEINDEX,
                                 ISCONTEXTVALUE,
                                 CONTEXTVALUEFIELDNAME,
                                 ISDATARESTRICTION,
                                 VARIABLEFIELD,
                                 APPLICABLEOPERATION,
                                 DEFAULTOPERATION,
                                 SORTORDER,
                                 STATUS,
                                 VERSION,
                                 SOURCETYPE,
                                 CREATEDBYID,
                                 CREATEDON,
                                 MODIFIEDBYID,
                                 MODIFIEDON,
                                 GCMTYPEID,
                                 FILTERTYPE
                            ) VALUES (
                                 @CriteriaAttributeId,
                                 @CriteriaAttributeName,
                                 @CriteriaAttributeType,
                                 @CriteriaAttributeSection,
                                 @PicklistId,
                                 @CriteriaAttributeApplicableValues,
                                 @CriteriaAttributeDefaultValueIndex,
                                 @CriteriaAttributeIsContextValue,
                                 @CriteriaAttributeContextValueFieldName,
                                 @CriteriaAttributeIsDataRestriction,
                                 @CriteriaAttributeVariableField,
                                 @CriteriaAttributeApplicableOperation,
                                 @CriteriaAttributeDefaultOperation,
                                 @CriteriaAttributeSortOrder,
                                 @CriteriaAttributeStatus,
                                 @CriteriaAttributeVersion,
                                 @CriteriaAttributeSourceType,
                                 @CriteriaAttributeCreatedById,
                                 @CriteriaAttributeCreatedOn,
                                 @CriteriaAttributeModifiedById,
                                 @CriteriaAttributeModifiedOn,
                                 @GcmTypeId,
                                 @CriteriaAttributeFilterType
                            );
                            ";

        public const string UPDATE_CRITERIAATTRIBUTE = @"UPDATE 
                            MCRITERIAATTRIBUTE SET
                            CRITERIAATTRIBUTENAME = @CriteriaAttributeName,
                            CRITERIAATTRIBUTETYPE = @CriteriaAttributeType,
                            SECTION = @CriteriaAttributeSection,
                            PICKLISTID = @PicklistId,
                            APPLICABLEVALUES = @CriteriaAttributeApplicableValues,
                            DEFAULTVALUEINDEX = @CriteriaAttributeDefaultValueIndex,
                            ISCONTEXTVALUE = @CriteriaAttributeIsContextValue,
                            CONTEXTVALUEFIELDNAME = @CriteriaAttributeContextValueFieldName,
                            ISDATARESTRICTION = @CriteriaAttributeIsDataRestriction,
                            VARIABLEFIELD = @CriteriaAttributeVariableField,
                            APPLICABLEOPERATION = @CriteriaAttributeApplicableOperation,
                            DEFAULTOPERATION = @CriteriaAttributeDefaultOperation,
                            SORTORDER = @CriteriaAttributeSortOrder,
                            STATUS = @CriteriaAttributeStatus,
                            VERSION = @CriteriaAttributeVersion,
                            SOURCETYPE = @CriteriaAttributeSourceType,
                            MODIFIEDBYID = @CriteriaAttributeModifiedById,
                            MODIFIEDON = @CriteriaAttributeModifiedOn,
                            GCMTYPEID = @GcmTypeId,
                            FILTERTYPE = @CriteriaAttributeFilterType
                            WHERE CRITERIAATTRIBUTEID = @CriteriaAttributeId;
                            ";

        public const string DELETE_CRITERIAATTRIBUTE = @"DELETE 
                            FROM MCRITERIAATTRIBUTE
                            WHERE CRITERIAATTRIBUTEID = @criteriaattributeid;
                            ";

    }
}