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

namespace FrameworkDAL.Query.EntityMember
{
    public class EntityMemberQB
    {
        public const string GET_ENTITYMEMBER = @"SELECT
                                                EM.ENTITYMEMBERID                 AS EntityMemberId,
                                                EM.ENTITYID                       AS EntityMemberEntityId,
                                                EM.SLNO                           AS EntityMemberSlNo,
                                                EM.MEMBERNAME                     AS EntityMemberMemberName,
                                                EM.DATATYPE                       AS EntityMemberDataType,
                                                EM.PARTICULARS                    AS EntityMemberParticulars,
                                                EM.ISPERSIST                      AS EntityMemberIsPersist,
                                                EM.INPUTTYPE                      AS EntityMemberInputType,
                                                EM.ISPRIMARY                      AS EntityMemberIsPrimary,
                                                EM.ISLOGICAL                      AS EntityMemberIsLogical,
                                                EM.ISCRITERIA                     AS EntityMemberIsCriteria,
                                                EM.ISSELECTLIST                   AS EntityMemberIsSelectList,
                                                EM.ISUSERIDENTIFYING              AS EntityMemberIsUseridentifying,
                                                EM.ISDATARESTRICTIONCRITERIA      AS EntityMemberIsDataRestrictionCriteria,
                                                EM.SECTION                        AS EntityMemberSection,
                                                EM.DBFIELDID                      AS EntityMemberDbFieldId,
                                                EM.ISINDEXED                      AS EntityMemberIsIndexed,
                                                EM.ISVERSIONING                   AS EntityMemberIsVersioning,
                                                EM.OBJECTTYPEID                   AS EntityMemberObjectTypeId,
                                                EM.ISIDENTITY                     AS EntityMemberIsIdentity,
                                                EM.ISSETREQUIRED                  AS EntityMemberIsSetRequired,
                                                EM.ISCHECK                        AS EntityMemberIsCheck,
                                                EM.ISFORMULAFORCODE               AS EntityMemberIsFormulaForCode,
                                                EM.ISFORMULABASEDFIELD            AS EntityMemberIsFormulaBasedField,
                                                EM.CODEFORMULAID                  AS EntityMemberCodeFormulaId,
                                                EM.ISCODEFIELD                    AS EntityMemberIsCodeField,
                                                EM.ISCODECATEGORY                 AS EntityMemberIsCodeCategory,
                                                EM.ISEXPANDREQ                    AS EntityMemberIsExpandReq,
                                                EM.ENUMVALUES                     AS EntityMemberEnumValues,
                                                EM.CRITERIAFIELDNAME              AS CriteriaFieldName,
                                                EM.CRITERIAATTRIBUTEID            AS CriteriaAttributeId,
                                                EM.ISICEFIELD                     AS EntityMemberIsIceField,
                                                EM.SAMPLEDATA                     AS EntityMemberSampleData,
                                                EM.ISUNIQUEKEY                    AS EntityMemberIsUniquekey,
                                                EM.ISCOMMENTREQUIRED              AS entitymemberiscommnetrequired
                                            FROM MENTITYMEMBERS EM
                                            WHERE ENTITYMEMBERID = @entitymemberid;";

        public const string SAVE_ENTITYMEMBER = @"INSERT INTO MENTITYMEMBERS
                                                (
                                                    ENTITYMEMBERID,
                                                    ENTITYID,
                                                    SLNO,
                                                    MEMBERNAME,
                                                    DATATYPE,
                                                    PARTICULARS,
                                                    ISPERSIST,
                                                    INPUTTYPE,
                                                    ISPRIMARY,
                                                    ISLOGICAL,
                                                    ISCRITERIA,
                                                    ISSELECTLIST,
                                                    ISUSERIDENTIFYING,
                                                    ISDATARESTRICTIONCRITERIA,
                                                    SECTION,
                                                    DBFIELDID,
                                                    ISINDEXED,
                                                    OBJECTTYPEID,
                                                    ISVERSIONING,
                                                    ISIDENTITY,
                                                    ISSETREQUIRED,
                                                    ISCHECK,
                                                    ISFORMULAFORCODE,
                                                    ISFORMULABASEDFIELD,
                                                    CODEFORMULAID,
                                                    ISCODEFIELD,
                                                    ISCODECATEGORY,
                                                    ISEXPANDREQ,
                                                    ENUMVALUES,
                                                    CRITERIAFIELDNAME,
                                                    CRITERIAATTRIBUTEID,
                                                    ISICEFIELD,
                                                    SAMPLEDATA,
                                                    ISUNIQUEKEY,
                                                    ISCOMMENTREQUIRED
                                                )
                                                VALUES
                                                (
                                                    @EntityMemberId,    
                                                    @EntityMemberEntityId,
                                                    @EntityMemberSlNo,
                                                    @EntityMemberMemberName,
                                                    @EntityMemberDataType,
                                                    @EntityMemberParticulars,
                                                    @EntityMemberIsPersist,
                                                    @EntityMemberInputType,
                                                    @EntityMemberIsPrimary,
                                                    @EntityMemberIsLogical,
                                                    @EntityMemberIsCriteria,
                                                    @EntityMemberIsSelectList,
                                                    @EntityMemberIsUseridentifying,
                                                    @EntityMemberIsDataRestrictionCriteria,
                                                    @EntityMemberSection,
                                                    @EntityMemberDbOjectFieldId,
                                                    @EntityMemberIsIndexed,
                                                    @EntityMemberObjectTypeId,
                                                    @EntityMemberIsVersioning,
                                                    @EntityMemberIsIdentity,
                                                    @EntityMemberIsSetRequired,
                                                    @EntityMemberIsCheck,
                                                    @EntityMemberIsFormulaForCode,
                                                    @EntityMemberIsFormulaBasedField,
                                                    @EntityMemberCodeFormulaId,
                                                    @EntityMemberIsCodeField,
                                                    @EntityMemberIsCodeCategory,
                                                    @EntityMemberIsExpandReq,
                                                    @EntityMemberEnumValues,
                                                    @EntityMemberCriteriaFieldName,
                                                    @CriteriaAttributeId,
                                                    @EntityMemberIsIceField,
                                                    @EntityMemberSampleData,
                                                    @EntityMemberIsUniquekey,
                                                    @EntityMemberIsCommnetRequired
                                                );";

        public const string UPDATE_ENTITYMEMBER = @"UPDATE MENTITYMEMBERS
                                                    SET
                                                        ENTITYID                      = @EntityMemberEntityId,
                                                        SLNO                          = @EntityMemberSlNo,
                                                        MEMBERNAME                    = @EntityMemberMemberName,
                                                        DATATYPE                      = @EntityMemberDataType,
                                                        PARTICULARS                   = @EntityMemberParticulars,
                                                        ISPERSIST                     = @EntityMemberIsPersist,
                                                        INPUTTYPE                     = @EntityMemberInputType,
                                                        ISPRIMARY                     = @EntityMemberIsPrimary,
                                                        ISLOGICAL                     = @EntityMemberIsLogical,
                                                        ISCRITERIA                    = @EntityMemberIsCriteria,
                                                        ISSELECTLIST                  = @EntityMemberIsSelectList,
                                                        ISUSERIDENTIFYING             = @EntityMemberIsUseridentifying,
                                                        ISDATARESTRICTIONCRITERIA     = @EntityMemberIsDataRestrictionCriteria,
                                                        SECTION                       = @EntityMemberSection,
                                                        DBFIELDID                     = @EntityMemberDbOjectFieldId,
                                                        ISINDEXED                     = @EntityMemberIsIndexed,
                                                        OBJECTTYPEID                  = @EntityMemberObjectTypeId,
                                                        ISVERSIONING                  = @EntityMemberIsVersioning,
                                                        ISIDENTITY                    = @EntityMemberIsIdentity,
                                                        ISSETREQUIRED                 = @EntityMemberIsSetRequired,
                                                        ISCHECK                       = @EntityMemberIsCheck,
                                                        ISFORMULAFORCODE              = @EntityMemberIsFormulaForCode,
                                                        ISFORMULABASEDFIELD           = @EntityMemberIsFormulaBasedField,
                                                        CODEFORMULAID                 = @EntityMemberCodeFormulaId,
                                                        ISCODEFIELD                   = @EntityMemberIsCodeField,
                                                        ISCODECATEGORY                = @EntityMemberIsCodeCategory,
                                                        ISEXPANDREQ                   = @EntityMemberIsExpandReq,
                                                        ENUMVALUES                    = @EntityMemberEnumValues,
                                                        CRITERIAFIELDNAME             = @EntityMemberCriteriaFieldName,
                                                        CRITERIAATTRIBUTEID           = @CriteriaAttributeId,
                                                        ISICEFIELD                    = @EntityMemberIsIceField,
                                                        SAMPLEDATA                    = @EntityMemberSampleData,
                                                        ISUNIQUEKEY                   = @EntityMemberIsUniquekey,
                                                        ISCOMMENTREQUIRED             = @EntityMemberIsCommnetRequired
                                                    WHERE ENTITYMEMBERID = @EntityMemberId;";

        public const string DELETE_ENTITYMEMBER = @"DELETE FROM MENTITYMEMBERS
                                                    WHERE ENTITYMEMBERID = @entitymemberid;";


        public const string GET_SELECTLIST_ENTITYMEMBER = @"SELECT
                                                            EM.ENTITYMEMBERID   AS Id,
                                                            EM.MEMBERNAME       AS MemberName,
                                                            EM.DATATYPE         AS DataType,
                                                            CAST(EM.DATATYPE AS INT) AS TempDataType
                                                        FROM MENTITYMEMBERS EM
                                                        WHERE EM.ENTITYID = @EntityId
                                                        ORDER BY EM.MEMBERNAME;";
        }
}