namespace GB5Shared.Criteria.Query
{
    // Duplicated from FrameworkDAL.Query.Entity.EntityQB.GET_ENTITY_FOR_GENERIC for CriteriaDAL's
    // exclusive use — see GB5Shared.Criteria.DTO.EntityCacheDTO for the duplication rationale.
    public static class CriteriaEntityQB
    {
        public const string GET_ENTITY_FOR_GENERIC = @"SELECT
                                    e.ENTITYID              AS EntityId,
                                    e.ENTITYCODE            AS EntityCode,
                                    e.ENTITYNAME            AS EntityName,
                                    e.ENTITYNATURE          AS EntityType,
                                    e.IsReferal       AS IsReferal,

                                    paPoco.ASSEMBLYNAME       AS PocoAssemblyName,
                                    e.ENTITYDEFINEDIN       AS PocoClassName,

                                    paDto.ASSEMBLYNAME        AS DTOAssemblyName,
                                    eDto.ENTITYDEFINEDIN    AS DTOClassName,

                                    paPick.ASSEMBLYNAME       AS PicklistAssemblyName,
                                    ePick.ENTITYDEFINEDIN   AS PicklistClassName

                                FROM MENTITY e
                                JOIN MPROGRAMASSEMBLY paPoco
                                    ON e.ASSEMBLYID = paPoco.ASSEMBLYID

                                JOIN MENTITY eDto
                                    ON e.PocoToDTOLinkId = eDto.ENTITYID
                                JOIN MPROGRAMASSEMBLY paDto
                                    ON eDto.ASSEMBLYID = paDto.ASSEMBLYID

                                JOIN MENTITY ePick
                                    ON e.PocoToPicklistLinkId = ePick.ENTITYID
                                JOIN MPROGRAMASSEMBLY paPick
                                    ON ePick.ASSEMBLYID = paPick.ASSEMBLYID";
    }
}