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

namespace FrameworkDAL.Query.Entity
{
    public static class EntityQB
    {
        public const string GetSelectList_Entity = @"
                                                  WITH PagedEntity AS (
		                                          SELECT
                                                 ME.ENTITYID AS Id,
                                                 ME.ENTITYCODE AS Code,
                                                 ME.ENTITYNAME AS Name,
                                                 ME.POCOTODTOLINKID AS PocoToDTOLinkId,

                                                ROW_NUMBER() OVER (ORDER BY ME.ENTITYID) AS RowNum
                                            FROM MENTITY ME
                                        )
                                        SELECT
                                            Id,
                                            Code,
                                            Name,
                                            PocoToDTOLinkId
                                        FROM PagedEntity
                                        WHERE 
                                             (@firstnumber = -1 AND @maxresult = -1)
                                             OR (RowNum BETWEEN @firstnumber AND @maxresult);";

        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";

        // MENTITY is global metadata (no TENANTID column) — a lookup by EntityId
        // is the same for every tenant.
        public const string GET_ENTITY_BY_ID = @"SELECT
                                    ME.ENTITYID   AS Id,
                                    ME.ENTITYCODE AS Code,
                                    ME.ENTITYNAME AS Name
                                FROM MENTITY ME
                                WHERE ME.ENTITYID = @EntityId;";

    }
}