using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using FrameworkDAL.DTO.DrillDown;
using FrameworkDAL.DTO.Menu;
using FrameworkDAL.DTO.WebService;

namespace FrameworkDAL.DTO.Portlet
{
    public class PortletListWithReportCriteriaDTO
    {
        private int uservsportletid;
        private int uservsportletportletid;
        private string portletcode;
        private string portletname;
        private int portlettypeid;
        private string portlettypecode;
        private string portlettypename;
        private byte portlettypeismaximize;
        private byte portlettypeisresize;
        private byte portlettypeisprint;
        private byte portlettypeisexport;
        private byte portlettypeissettingsid;
        private byte portlettypeischangesettings;
        private string portleturl;
        private byte portletischangeable;
        private int portletmenuid;
        private string menucode;
        private string menuname;
        private string menutype;
        private int menureportid;
        private string reportname;
        private string reporturi;
        private int webformid;
        private string webformname;
        private string webformurl;
        private string webformtemplate;
        private byte portletismaximize;
        private byte portletisresize;
        private byte portletisprint;
        private byte portletisexport;
        private byte portletissettings;
        private byte portletischangesetting;
        private int portletsettingsid;
        private string portletpublishchannelname;
        private string portletpublishfieldname;
        private string portletsubscribechannelname;
        private string portletsubscribefieldname;
        private byte portletcharttype;
        private string portletchartxaxis;
        private string portletchartyaxis;
        private string portletchartvalue;
        private string portletxaxisdateformat;
        private string portletyaxisdateformat;
        private string portletdescription;

        // 'Analysis'/'KPI Card'/'KPI List' portlet types read these off PortletData (this DTO,
        // via PortletLoaderService's `PortletItem: item` pass-through — the actual runtime source
        // of PortletData for every dashboard-rendered portlet, NOT the single-portlet GetPortlet
        // call). BIViewId was already selected in this query's SQL but had no matching property
        // here at all -- meaning 'Analysis' portlets have never actually been able to resolve their
        // BIViewId on a real dashboard render, only in the separate admin/config preview screen's
        // own dedicated GetPortlet+BIView.Get calls. Fixed in passing while adding the KPI columns,
        // since it's the exact same missing-property gap on the exact same class.
        private int? biviewid;
        private int? kpiid;
        private int? kpilistid;
        private int? portletkpiouid;

        private int portletreportformatid;
        private string reportformatname;
        private string reportfile;
        private string portletdatasourcefilename;
        private byte portletispagenationrequired;
        private byte portletnumberofrecords;

        private int uservsportletpageid;
        private string pagecode;
        private string pagename;
        private byte portletrow;
        private byte portletcolumn;
        private Int16 uservsportletheight;
        private Int16 uservsportletwidth;
        private Int16 uservsportletslno;
        private string sourcetype;
        private int webserviceid;                            //Id
        private string webservicename;                       //Name
        private string webserviceuritemplate;
        private byte webservicemethodtype;
        private string methodtype;

        private int biztransactionclassid;
        private string biztransactionclasscode;
        private string biztransactionclassname;
        private string helpurl;



        private int formlinkmenuid; //FormLinkMenuId
        private string formlinkmenucode; //FormLinkMenuCode
        private string formlinkmenuname; //FormLinkMenuName

        private int webservicesettingid; //WebServiceSettingId
        private int webservicesettingwebserviceid; //WebServiceSettingWebServiceId
        private int webservicesettingmenuid; //WebServiceSettingMenuId
        private int webservicesettingreportid; //WebServiceSettingReportId

        private int fileid; //FileId
        private string filename; //FileName
        private string filelocation; //FileLocation

        private List<ReportCriteriaDTO> reportcriteria = new List<ReportCriteriaDTO>();

        private List<PortletReportVsFieldsDTO> reportvsfields = new List<PortletReportVsFieldsDTO>();
        private List<PortletConfigDTO> criteriaconfig = new List<PortletConfigDTO>();
        private List<MenuDetailDTO> menudetail = new List<MenuDetailDTO>();
        private List<DrillDownListDTO> drilldown = new List<DrillDownListDTO>();

        private List<WebServiceSettingDTO> webservicesetting = new List<WebServiceSettingDTO>();

        // ── Phase 3: Page-level / Dashboard-level filter tiers ──────────────
        private int pagedefaultcriteriaconfigid;
        private byte pageoverridedashboardcriteria;
        private byte portletoverridepagecriteria;
        private List<PortletConfigDTO> pagecriteriaconfig = new List<PortletConfigDTO>();
        private List<PortletConfigDTO> dashboardcriteriaconfig = new List<PortletConfigDTO>();

        public int UserVsPortletId
        {
            get { return uservsportletid; }
            set { uservsportletid = value; }
        }
        public int UserVsPortletPortletId
        {
            get { return uservsportletportletid; }
            set { uservsportletportletid = value; }
        }
        public string PortletCode
        {
            get { return portletcode; }
            set { portletcode = value; }
        }
        public string PortletName
        {
            get { return portletname; }
            set { portletname = value; }
        }
        public int PortletTypeId
        {
            get { return portlettypeid; }
            set { portlettypeid = value; }
        }

        public string PortletTypeCode
        {
            get { return portlettypecode; }
            set { portlettypecode = value; }
        }

        public string PortletTypeName
        {
            get { return portlettypename; }
            set { portlettypename = value; }
        }

        public byte PortletTypeIsMaximize
        {
            get { return portlettypeismaximize; }
            set { portlettypeismaximize = value; }
        }

        public byte PortletTypeIsResize
        {
            get { return portlettypeisresize; }
            set { portlettypeisresize = value; }
        }

        public byte PortletTypeIsPrint
        {
            get { return portlettypeisprint; }
            set { portlettypeisprint = value; }
        }

        public byte PortletTypeIsExport
        {
            get { return portlettypeisexport; }
            set { portlettypeisexport = value; }
        }

        public byte PortletTypeIsSettingsId
        {
            get { return portlettypeissettingsid; }
            set { portlettypeissettingsid = value; }
        }

        public byte PortletTypeIsChangeSettings
        {
            get { return portlettypeischangesettings; }
            set { portlettypeischangesettings = value; }
        }

        public string PortletUrl
        {
            get { return portleturl; }
            set { portleturl = value; }
        }

        public byte PortletIsChangeable
        {
            get { return portletischangeable; }
            set { portletischangeable = value; }
        }

        public int PortletMenuId
        {
            get { return portletmenuid; }
            set { portletmenuid = value; }
        }

        public string MenuCode
        {
            get { return menucode; }
            set { menucode = value; }
        }

        public string MenuName
        {
            get { return menuname; }
            set { menuname = value; }
        }

        public string MenuType
        {
            get { return menutype; }
            set { menutype = value; }
        }
        public int MenuReportId
        {
            get { return menureportid; }
            set { menureportid = value; }
        }

        public string ReportName
        {
            get { return reportname; }
            set { reportname = value; }
        }
        public string ReportUri
        {
            get { return reporturi; }
            set { reporturi = value; }
        }

        public int WebFormId
        {
            get { return webformid; }
            set { webformid = value; }
        }
        public string WebFormName
        {
            get { return webformname; }
            set { webformname = value; }
        }
        public string WebFormURL
        {
            get { return webformurl; }
            set { webformurl = value; }
        }
        public string WebFormTemplate
        {
            get { return webformtemplate; }
            set { webformtemplate = value; }
        }

        public byte PortletIsMaximize
        {
            get { return portletismaximize; }
            set { portletismaximize = value; }
        }

        public byte PortletIsResize
        {
            get { return portletisresize; }
            set { portletisresize = value; }
        }

        public byte PortletIsPrint
        {
            get { return portletisprint; }
            set { portletisprint = value; }
        }

        public byte PortletIsExport
        {
            get { return portletisexport; }
            set { portletisexport = value; }
        }

        public byte PortletIsSettings
        {
            get { return portletissettings; }
            set { portletissettings = value; }
        }

        public byte PortletIsChangeSetting
        {
            get { return portletischangesetting; }
            set { portletischangesetting = value; }
        }

        public int PortletSettingsId
        {
            get { return portletsettingsid; }
            set { portletsettingsid = value; }
        }

        public string PortletPublishChannelName
        {
            get { return portletpublishchannelname; }
            set { portletpublishchannelname = value; }
        }
        public string PortletPublishFieldName
        {
            get { return portletpublishfieldname; }
            set { portletpublishfieldname = value; }
        }
        public string PortletSubscribeChannelName
        {
            get { return portletsubscribechannelname; }
            set { portletsubscribechannelname = value; }
        }

        public string PortletSubscribeFieldName
        {
            get { return portletsubscribefieldname; }
            set { portletsubscribefieldname = value; }
        }

        public byte PortletChartType
        {
            get { return portletcharttype; }
            set { portletcharttype = value; }
        }
        public string PortletChartXAxis
        {
            get { return portletchartxaxis; }
            set { portletchartxaxis = value; }
        }
        public string PortletChartYAxis
        {
            get { return portletchartyaxis; }
            set { portletchartyaxis = value; }
        }
        public string PortletChartValue
        {
            get { return portletchartvalue; }
            set { portletchartvalue = value; }
        }
        public string PortletXaxisDateFormat
        {
            get { return portletxaxisdateformat; }
            set { portletxaxisdateformat = value; }
        }
        public string PortletYaxisDateFormat
        {
            get { return portletyaxisdateformat; }
            set { portletyaxisdateformat = value; }
        }
        public string PortletDescription
        {
            get { return portletdescription; }
            set { portletdescription = value; }
        }

        public int? BIViewId
        {
            get { return biviewid; }
            set { biviewid = value; }
        }

        public int? KPIId
        {
            get { return kpiid; }
            set { kpiid = value; }
        }

        public int? KPIListId
        {
            get { return kpilistid; }
            set { kpilistid = value; }
        }

        public int? PortletKPIOUId
        {
            get { return portletkpiouid; }
            set { portletkpiouid = value; }
        }


        public int PortletReportFormatId
        {
            get { return portletreportformatid; }
            set { portletreportformatid = value; }
        }
        public string ReportFormatName
        {
            get { return reportformatname; }
            set { reportformatname = value; }
        }
        public string ReportFile
        {
            get { return reportfile; }
            set { reportfile = value; }
        }
        public string PortletDataSourceFileName
        {
            get { return portletdatasourcefilename; }
            set { portletdatasourcefilename = value; }
        }
        public byte PortletIsPagenationRequired
        {
            get { return portletispagenationrequired; }
            set { portletispagenationrequired = value; }
        }
        public byte PortletNumberOfRecords
        {
            get { return portletnumberofrecords; }
            set { portletnumberofrecords = value; }
        }



        public int UserVsPortletPageId
        {
            get { return uservsportletpageid; }
            set { uservsportletpageid = value; }
        }

        public string PageCode
        {
            get { return pagecode; }
            set { pagecode = value; }
        }

        public string PageName
        {
            get { return pagename; }
            set { pagename = value; }
        }
        public byte PortletRow
        {
            get { return portletrow; }
            set { portletrow = value; }
        }

        public byte PortletColumn
        {
            get { return portletcolumn; }
            set { portletcolumn = value; }
        }
        public Int16 UserVsPortletHeight
        {
            get { return uservsportletheight; }
            set { uservsportletheight = value; }
        }
        public Int16 UserVsPortletWidth
        {
            get { return uservsportletwidth; }
            set { uservsportletwidth = value; }
        }
        public Int16 UserVsPortletSlNo
        {
            get { return uservsportletslno; }
            set { uservsportletslno = value; }
        }
        public string SourceType
        {
            get { return sourcetype; }
            set { sourcetype = value; }
        }
        public int WebServiceId
        {
            get { return webserviceid; }                            //Id
            set { webserviceid = value; }                            //Id
        }
        public string WebServiceName
        {
            get { return webservicename; }                          //Name
            set { webservicename = value; }                          //Name
        }
        public string WebServiceUriTemplate
        {
            get { return webserviceuritemplate; }                       //Section
            set { webserviceuritemplate = value; }                       //Section
        }
        public byte WebServiceMethodType
        {
            get { return webservicemethodtype; }                       //Section
            set { webservicemethodtype = value; }                       //Section
        }

        public string MethodType
        {
            get { return methodtype; }                       //Section
            set { methodtype = value; }                       //Section
        }


        public int BizTransactionClassId
        {
            get { return biztransactionclassid; }
            set { biztransactionclassid = value; }
        }

        public string BizTransactionClassCode
        {
            get { return biztransactionclasscode; }
            set { biztransactionclasscode = value; }
        }

        public string BizTransactionClassName
        {
            get { return biztransactionclassname; }
            set { biztransactionclassname = value; }
        }
        public string HelpUrl
        {
            get { return helpurl; }
            set { helpurl = value; }
        }




        public int FormLinkMenuId
        {
            get { return formlinkmenuid; }
            set { formlinkmenuid = value; }
        }
        public string FormLinkMenuCode
        {
            get { return formlinkmenucode; }
            set { formlinkmenucode = value; }
        }
        public string FormLinkMenuName
        {
            get { return formlinkmenuname; }
            set { formlinkmenuname = value; }
        }

        public int WebServiceSettingId
        {
            get { return webservicesettingid; }
            set { webservicesettingid = value; }
        }
        public int WebServiceSettingWebServiceId
        {
            get { return webservicesettingwebserviceid; }
            set { webservicesettingwebserviceid = value; }
        }
        public int WebServiceSettingMenuId
        {
            get { return webservicesettingmenuid; }
            set { webservicesettingmenuid = value; }
        }
        public int WebServiceSettingReportId
        {
            get { return webservicesettingreportid; }
            set { webservicesettingreportid = value; }
        }

        public int FileId
        {
            get { return fileid; }
            set { fileid = value; }
        }
        public string FileName
        {
            get { return filename; }
            set { filename = value; }
        }
        public string FileLocation
        {
            get { return filelocation; }
            set { filelocation = value; }
        }


        public List<ReportCriteriaDTO> ReportCriteriaArray
        {
            get { return reportcriteria; }
            set { reportcriteria = value; }
        }

        public List<PortletReportVsFieldsDTO> ReportVsFieldsArray
        {
            get { return reportvsfields; }
            set { reportvsfields = value; }
        }

        public List<PortletConfigDTO> CriteriaConfigArray
        {
            get { return criteriaconfig; }
            set { criteriaconfig = value; }
        }

        public List<MenuDetailDTO> MenuDetailArray
        {
            get { return menudetail; }
            set { menudetail = value; }
        }

        public List<DrillDownListDTO> DrillDownArray
        {
            get { return drilldown; }
            set { drilldown = value; }
        }

        public List<WebServiceSettingDTO> WebServiceSettingArray
        {
            get { return webservicesetting; }
            set { webservicesetting = value; }
        }

        // ── Phase 3: Page-level / Dashboard-level filter tiers ──────────────
        // Precedence (resolved in PortletDAL.GetPortletListWithCriteria, not SQL):
        //   UserVsPortlet.CriteriaConfigId (existing CriteriaConfigArray, tier 1)
        //     > Portlet.DefaultCriteriaConfigId (existing, tier 2)
        //     combined with (ANDed, unless PortletOverridePageCriteria=1): PageCriteriaConfigArray (tier 3)
        //     combined with (ANDed, unless PageOverrideDashboardCriteria=1): DashboardCriteriaConfigArray (tier 4)
        public int PageDefaultCriteriaConfigId
        {
            get { return pagedefaultcriteriaconfigid; }
            set { pagedefaultcriteriaconfigid = value; }
        }

        public byte PageOverrideDashboardCriteria
        {
            get { return pageoverridedashboardcriteria; }
            set { pageoverridedashboardcriteria = value; }
        }

        public byte PortletOverridePageCriteria
        {
            get { return portletoverridepagecriteria; }
            set { portletoverridepagecriteria = value; }
        }

        public List<PortletConfigDTO> PageCriteriaConfigArray
        {
            get { return pagecriteriaconfig; }
            set { pagecriteriaconfig = value; }
        }

        public List<PortletConfigDTO> DashboardCriteriaConfigArray
        {
            get { return dashboardcriteriaconfig; }
            set { dashboardcriteriaconfig = value; }
        }
    }
}