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

namespace FrameworkDAL.Query.Picklist
{
    public static class PicklistQB
    {
        public const string GET_PICKLIST = @" 
                                        SELECT 
                                            -- Parent: PicklistDTO fields
                                            PL.PICKLISTID                    AS PicklistId,
                                            PL.PICKLISTCODE                 AS PicklistCode,
                                            PL.PICKLISTNAME                 AS PicklistName,
                                            PL.PICKLISTTITLE                AS PicklistTitle,
                                            PL.ISMULTISELECT                AS PicklistIsMultiselect,
                                            PL.PICKLISTURI                  AS PicklistUri,
                                            PL.DISPLAYFIELDTEXTBOX          AS PicklistDisplayFieldTextBox,
                                            PL.REMARKS                      AS PicklistRemarks,
                                            PL.SORTORDER                    AS PicklistSortOrder,
                                            PL.STATUS                       AS PicklistStatus,
                                            PL.VERSION                      AS PicklistVersion,
                                            PL.SOURCETYPE                   AS PicklistSourceType,
                                            PL.NUMBEROFSELECTION            AS PicklistNumberOfSelection,
                                            PL.MINIMUMNUMBER                AS PicklistMinimumNumber,
                                            PL.PICKLISTWIDTH                AS PicklistWidth,
                                            PL.PICKLISTHEIGHT               AS PicklistHeight,
                                            PL.SEARCHABLEFIELDS             AS PicklistSearchableFields,
                                            PL.SEARCHFIELDS                 AS PicklistSearchFields,
                                            PL.DISPLAYFIELDNAME             AS PicklistDisplayFieldName,
                                            PL.SELECTIONFIELDNAME           AS PicklistSelectionFieldName,

                                                    -- Child: PicklistOutputDTO fields
                                                    PO.PICKLISTOUTPUTID             AS PicklistOutputId,
                                                    PO.PICKLISTID                   AS PicklistId,
                                                    PO.SLNO                         AS PicklistOutputSlNo,
                                                    PO.FIELDNAME                    AS PicklistOutputFieldName,
                                                    PO.ISVISIBLE                    AS PicklistOutputIsVisible,
                                                    PO.HEADERTEXT                   AS PicklistOutputHeaderText,
                                                    PO.FIELDSIZE                    AS PicklistOutputFieldSize,
                                                    PO.ISFREEZINGREQ                AS PicklistOutputIsFreezingReq,
                                                    PO.ISHEADERWRAPPINGREQ          AS PicklistOutputIsHeaderWrappingReq,
                                                    PO.ISDATAWRAPPINGREQ            AS PicklistOutputIsDataWrappingReq

                                                FROM MPICKLIST PL
                                                LEFT JOIN MPICKLISTOUTPUT PO ON PL.PICKLISTID = PO.PICKLISTID
                                                WHERE PL.PICKLISTID = @picklistid;";


        public const string GET_SELECTLIST_PICKLIST = @"SELECT 
                                                        PICKLISTID AS Id,
                                                        PICKLISTCODE AS Code,
                                                        PICKLISTNAME AS Name,
                                                        PICKLISTURI AS Uri
                                                    FROM MPICKLIST
                                                    WHERE STATUS = 1
                                                    ORDER BY PICKLISTNAME;";
    }
}