namespace GB5Shared.Criteria.Query
{
    public static class EntityCriteriaQB
    {
        // Mirrors WebServiceCriteriaQB.GET_WEBSERVICE_CRITERIA exactly, filtered by
        // ENTITYTYPE instead of WEBSERVICEID.
        public const string GET_ENTITY_CRITERIA = @"SELECT
                        A.ENTITYCRITERIAID AS EntityCriteriaId,
                        A.ENTITYTYPE AS EntityType,
                        A.SLNO AS EntityCriteriaSlNo,

                        A.CRITERIAATTRIBUTEID AS CriteriaAttributeId,
                        C.CRITERIAATTRIBUTENAME AS CriteriaAttributeName,
                        C.APPLICABLEOPERATION AS CriteriaAttributeApplicableOperation,
                        C.VARIABLEFIELD AS CriteriaAttributeVariableField,
                        C.CRITERIAATTRIBUTETYPE AS CriteriaAttributeType,
                        C.APPLICABLEVALUES AS CriteriaAttributeApplicableValues,

                        A.ISCOMPULSORY AS EntityCriteriaIsCompulsory,
                        A.ISHEADER AS EntityCriteriaIsHeader,
                        A.DISPLAYNAME AS EntityCriteriaDisplayName,
                        A.FIELDNAME AS EntityCriteriaFieldName,
                        A.PICKLISTFIELDNAME AS EntityCriteriaPicklistFieldName,
                        A.QUERYCRITERIAFIELDNAME AS EntityCriteriaQueryCriteriaFieldName,
                        A.SLNO AS EntityCriteriaDisplaySlNo,
                        A.DEPENDPICKLISTNAME AS EntityCriteriaDependPicklistName,
                        A.DEPENDFIELDNAME AS EntityCriteriaDependFieldName,

                        A.CREATEDBYID AS EntityCriteriaCreatedById,
                        A.CREATEDON AS EntityCriteriaCreatedOn,
                        A.MODIFIEDBYID AS EntityCriteriaModifiedById,
                        A.MODIFIEDON AS EntityCriteriaModifiedOn,

                        A.SORTORDER AS EntityCriteriaSortOrder,
                        A.STATUS AS EntityCriteriaStatus,
                        A.VERSION AS EntityCriteriaVersion,
                        A.SOURCETYPE AS EntityCriteriaSourceType
                    FROM MENTITYCRITERIA A
                    LEFT JOIN MCRITERIAATTRIBUTE C ON A.CRITERIAATTRIBUTEID = C.CRITERIAATTRIBUTEID
                    WHERE
                    A.ENTITYTYPE = @entitytype
                    ORDER BY A.SLNO;";
    }
}