using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace FrameworkDAL.DTO.Menu { public class ReportMenuLoadingFlatQueryNewDTO { #region Private Flat Section private int menuid; private string menucode; private string menuname; private string menutype; private int menunature; private int menureportid; private string reportname; private string reporturi; private int webformid; private string webformname; private string webformurl; private string webformsecondurl; private string webformtemplate; private int webserviceid; private string webservicename; private string webserviceuritemplate; private byte webservicemethodtype; private string methodtype; private int biztransactionclassid; private string seconduritemplate; private int defaultreportformatid; private string reportfile; private string reportformatname; private string portletdatasourcefilename; private string defaultreportformatreppath; private string helpurl; private int gcmtypeid; private string uriparametervalue; private int entityid; private string entitycode; private string entityname; private string entityprimerykeymembername; private int defaultreportviewid; private int analysisqueryid;//Added by Vikash For Linking Analysis private int periodtype; private string menudisplayname; private string menuobjectmodelname; #endregion #region Private Report Criteria private int reportcriteriareportid; private Int16 webservicecriteriaslno; private Int16 webservicecriteriadisplayslno; //Added by Vikash on 30 th July 2014 private int webservicecriteriaid; private string webservicecriteriadisplayname; private string webservicecriteriafieldname; private string webservicecriteriapicklistfieldname; private string webservicecriteriadependpicklistname;//WebServiceCriteriaDependPicklistName private string webservicecriteriadependfieldname;//WebServiceCriteriaDependFieldName private int webservicecriteriaattributeid; private string criteriaattributename; private byte iscompulsory; private byte isheader; private byte criteriaattributetype; private string criteriaattributetypename; private int criteriaattributepicklistid; private string criteriaattributepicklistcode; private string criteriaattributepicklistdisplayfieldname; private string criteriaattributepicklistselectionfieldname; private string criteriaattributepicklistdisplaytextbox; private string criteriaattributepicklisttitle; private string criteriaattributepicklisturi; private string criteriaattributesearchfields; private string criteriaattributeapplicablevalues; private string criteriaattributevariablefield; private string criteriaattributeapplicableoperation; private byte criteriaattributedefaultoperation; private int criteriaattributegcmtypeid; private string criteriaattributecontextvaluefieldname; private byte criteriaattributepicklistismultiselect; #endregion #region Private Report VsFields private int reportvsfieldreportid; private int reportviewfieldsid; //private int reportviewid; //private string reportviewname; private int reportvsfieldsid; private Int16 reportvsfieldsslno; private string reportvsfieldsfieldname; private byte reportvsfieldsfieldtype; private string reportvsfieldsfieldtitle; private Int16 reportvsfieldsfieldwidth; private byte reportvsfieldsisdisplay; private byte reportvsfieldsismergecolumn; private byte reportvsfieldsisgroupcolumn; private byte reportvsfieldsissubtotalcolumn; private byte reportvsfieldsisgrandtotalcolumn; private string reportvsfieldscalformat; private Int16 reportvsfieldsdisplayslno; #endregion #region Private Report Vs Formats DTO private int reportvsformatreportid; private int reportvsforamtsid;//ReportVsForamtsId private Int16 reportvsforamtsslno; //ReportVsForamtsSlNo private int reportformatid;//ReportFormatId private string reportformatdatasourcefilename;//ReportFormatDataSourceFileName private string reportformatpurpose;//ReportFormatPurpose private string reportformatreppath;//ReportFormatRepPath private string reportformatremarks;//ReportFormatRemarks #endregion #region Private Report Vies private int reportviewid; private string reportviewname; private string reportviewremarks; private int reportviewreportid; private int reportid; private byte issystemview; private byte isdefaultview; private byte reportviewtype; private byte sourcetype; private int templateid; private string templatename; private string templatelocation; private int secondtemplateid; private string secondtemplatename; private string secondtemplatelocation; private byte columnfreeze; private string pivotformat; private int pageid; private int isdatapivot; private string pagecode; private string pagename; private string pagelayout; #endregion #region Public Flat Section public int MenuId { get { return menuid; } set { menuid = value; } } public string MenuName { get { return menuname; } set { menuname = value; } } public string MenuType { get { return menutype; } set { menutype = value; } } public int MenuNature { get { return menunature; } set { menunature = 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 byte ReportViewType { get { return reportviewtype; } set { reportviewtype = 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 WebFormSecondURL { get { return webformsecondurl; } set { webformsecondurl = value; } } public string WebFormTemplate { get { return webformtemplate; } set { webformtemplate = value; } } public int WebServiceId { get { return webserviceid; } set { webserviceid = value; } } public string WebServiceName { get { return webservicename; } set { webservicename = value; } } public string WebServiceUriTemplate { get { return webserviceuritemplate; } set { webserviceuritemplate = value; } } public byte WebServiceMethodType { get { return webservicemethodtype; } set { webservicemethodtype = value; } } public string MethodType { get { return methodtype; } set { methodtype = value; } } public int BizTransactionClassId { get { return biztransactionclassid; } set { biztransactionclassid = value; } } public int DefaultReportFormatId { get { return defaultreportformatid; } set { defaultreportformatid = value; } } public string ReportFile { get { return reportfile; } set { reportfile = value; } } public string ReportFormatName { get { return reportformatname; } set { reportformatname = value; } } public string PortletDataSourceFileName { get { return portletdatasourcefilename; } set { portletdatasourcefilename = value; } } public string DefaultReportFormatRepPath { get { return defaultreportformatreppath; } set { defaultreportformatreppath = value; } } public string HelpUrl { get { return helpurl; } set { helpurl = value; } } public int GcmTypeId { get { return gcmtypeid; } set { gcmtypeid = value; } } public string URIParameterValue { get { return uriparametervalue; } set { uriparametervalue = value; } } public int EntityId { get { return entityid; } set { entityid = value; } } public string EntityCode { get { return entitycode; } set { entitycode = value; } } public string EntityName { get { return entityname; } set { entityname = value; } } public string EntityPrimeryKeyMemberName { get { return entityprimerykeymembername; } set { entityprimerykeymembername = value; } } public int DefaultReportViewId { get { return defaultreportviewid; } set { defaultreportviewid = value; } } public int AnalysisQueryId { get { return analysisqueryid; } set { analysisqueryid = value; } } #endregion #region Public Report Criteria public int ReportCriteriaReportId { get { return reportcriteriareportid; } set { reportcriteriareportid = value; } } public Int16 WebServiceCriteriaSlNo { get { return webservicecriteriaslno; } set { webservicecriteriaslno = value; } } public Int16 WebServiceCriteriaDisplaySlNo { get { return webservicecriteriadisplayslno; } set { webservicecriteriadisplayslno = value; } } public int WebServiceCriteriaId { get { return webservicecriteriaid; } set { webservicecriteriaid = value; } } public string WebServiceCriteriaDisplayName { get { return webservicecriteriadisplayname; } set { webservicecriteriadisplayname = value; } } public string WebServiceCriteriaFieldName { get { return webservicecriteriafieldname; } set { webservicecriteriafieldname = value; } } public string WebServiceCriteriaPicklistFieldName { get { return webservicecriteriapicklistfieldname; } set { webservicecriteriapicklistfieldname = value; } } public string WebServiceCriteriaDependPicklistName { get { return webservicecriteriadependpicklistname; } set { webservicecriteriadependpicklistname = value; } } public string WebServiceCriteriaDependFieldName { get { return webservicecriteriadependfieldname; } set { webservicecriteriadependfieldname = value; } } public int WebServiceCriteriaAttributeId { get { return webservicecriteriaattributeid; } set { webservicecriteriaattributeid = value; } } public string CriteriaAttributeName { get { return criteriaattributename; } set { criteriaattributename = value; } } public byte IsCompulsory { get { return iscompulsory; } set { iscompulsory = value; } } public byte IsHeader { get { return isheader; } set { isheader = value; } } public byte CriteriaAttributeType { get { return criteriaattributetype; } set { criteriaattributetype = value; } } public string CriteriaAttributeTypeName { get { return criteriaattributetypename; } set { criteriaattributetypename = value; } } public int CriteriaAttributePicklistId { get { return criteriaattributepicklistid; } set { criteriaattributepicklistid = value; } } public string CriteriaAttributePicklistCode { get { return criteriaattributepicklistcode; } set { criteriaattributepicklistcode = value; } } public string CriteriaAttributePicklistDisplayFieldName { get { return criteriaattributepicklistdisplayfieldname; } set { criteriaattributepicklistdisplayfieldname = value; } } public string CriteriaAttributePicklistSelectionFieldName { get { return criteriaattributepicklistselectionfieldname; } set { criteriaattributepicklistselectionfieldname = value; } } public string CriteriaAttributePicklistDisplayTextBox { get { return criteriaattributepicklistdisplaytextbox; } set { criteriaattributepicklistdisplaytextbox = value; } } public string CriteriaAttributePicklistTitle { get { return criteriaattributepicklisttitle; } set { criteriaattributepicklisttitle = value; } } public string CriteriaAttributePicklistURI { get { return criteriaattributepicklisturi; } set { criteriaattributepicklisturi = value; } } public string CriteriaAttributeSearchFields { get { return criteriaattributesearchfields; } set { criteriaattributesearchfields = value; } } public string CriteriaAttributeApplicableValues { get { return criteriaattributeapplicablevalues; } set { criteriaattributeapplicablevalues = value; } } public string CriteriaAttributeVariableField { get { return criteriaattributevariablefield; } set { criteriaattributevariablefield = value; } } public string CriteriaAttributeApplicableOperation { get { return criteriaattributeapplicableoperation; } set { criteriaattributeapplicableoperation = value; } } public byte CriteriaAttributeDefaultOperation { get { return criteriaattributedefaultoperation; } set { criteriaattributedefaultoperation = value; } } public int CriteriaAttributeGcmTypeId { get { return criteriaattributegcmtypeid; } set { criteriaattributegcmtypeid = value; } } public string CriteriaAttributeContextValueFieldName { get { return criteriaattributecontextvaluefieldname; } set { criteriaattributecontextvaluefieldname = value; } } public byte CriteriaAttributePicklistIsMultiSelect { get { return criteriaattributepicklistismultiselect; } set { criteriaattributepicklistismultiselect = value; } } #endregion #region Public Report Vs Fields public int ReportvsFieldReportId { get { return reportvsfieldreportid; } set { reportvsfieldreportid = value; } } public int ReportViewFieldsId { get { return reportviewfieldsid; } set { reportviewfieldsid = value; } } //public int ReportViewId //{ // get { return reportviewid; } // set { reportviewid = value; } //} //public string ReportViewName //{ // get { return reportviewname; } // set { reportviewname = value; } //} public int ReportVsFieldsId { get { return reportvsfieldsid; } set { reportvsfieldsid = value; } } public Int16 ReportVsFieldsSlNo { get { return reportvsfieldsslno; } set { reportvsfieldsslno = value; } } public string ReportVsFieldsFieldName { get { return reportvsfieldsfieldname; } set { reportvsfieldsfieldname = value; } } public string ReportVsFieldsFieldTitle { get { return reportvsfieldsfieldtitle; } set { reportvsfieldsfieldtitle = value; } } public byte ReportVsFieldsFieldType { get { return reportvsfieldsfieldtype; } set { reportvsfieldsfieldtype = value; } } public Int16 ReportVsFieldsFieldWidth { get { return reportvsfieldsfieldwidth; } set { reportvsfieldsfieldwidth = value; } } public byte ReportVsFieldsIsDisplay { get { return reportvsfieldsisdisplay; } set { reportvsfieldsisdisplay = value; } } public byte ReportVsFieldsIsMergeColumn { get { return reportvsfieldsismergecolumn; } set { reportvsfieldsismergecolumn = value; } } public byte ReportVsFieldsIsGroupColumn { get { return reportvsfieldsisgroupcolumn; } set { reportvsfieldsisgroupcolumn = value; } } public byte ReportVsFieldsIsSubtotalColumn { get { return reportvsfieldsissubtotalcolumn; } set { reportvsfieldsissubtotalcolumn = value; } } public byte ReportVsFieldsIsGrandtotalColumn { get { return reportvsfieldsisgrandtotalcolumn; } set { reportvsfieldsisgrandtotalcolumn = value; } } public string ReportVsFieldsCalFormat { get { return reportvsfieldscalformat; } set { reportvsfieldscalformat = value; } } public Int16 ReportVsFieldsDisplaySlNo { get { return reportvsfieldsdisplayslno; } set { reportvsfieldsdisplayslno = value; } } #endregion #region Public Report Vs Formats DTO public int ReportvsFormatReportId { get { return reportvsformatreportid; } set { reportvsformatreportid = value; } } public int ReportVsForamtsId { get { return reportvsforamtsid; } set { reportvsforamtsid = value; } } public Int16 ReportVsForamtsSlNo { get { return reportvsforamtsslno; } set { reportvsforamtsslno = value; } } public int ReportFormatId { get { return reportformatid; } set { reportformatid = value; } } public string ReportFormatDataSourceFileName { get { return reportformatdatasourcefilename; } set { reportformatdatasourcefilename = value; } } public string ReportFormatPurpose { get { return reportformatpurpose; } set { reportformatpurpose = value; } } public string ReportFormatRepPath { get { return reportformatreppath; } set { reportformatreppath = value; } } public string ReportFormatRemarks { get { return reportformatremarks; } set { reportformatremarks = value; } } #endregion #region Public Report View public int ReportViewReportId { get { return reportviewreportid; } set { reportviewreportid = value; } } public int ReportId { get { return reportid; } set { reportid = value; } } public int ReportViewId { get { return reportviewid; } set { reportviewid = value; } } public string ReportViewName { get { return reportviewname; } set { reportviewname = value; } } // Plain-English "what this view is for and when to use it over the others" text, authored // in the MREPORTVIEW seed migration's REMARKS column — surfaced as a tooltip in the FE // view-picker (gbreportaction.component.ts). public string ReportViewRemarks { get { return reportviewremarks; } set { reportviewremarks = value; } } public byte IsSystemView { get { return issystemview; } set { issystemview = value; } } public byte IsDefaultView { get { return isdefaultview; } set { isdefaultview = value; } } public byte SourceType { get { return sourcetype; } set { sourcetype = value; } } public int TemplateId { get { return templateid; } set { templateid = value; } } public string TemplateName { get { return templatename; } set { templatename = value; } } public string TemplateLocation { get { return templatelocation; } set { templatelocation = value; } } public int SecondTemplateId { get { return secondtemplateid; } set { secondtemplateid = value; } } public string SecondTemplateName { get { return secondtemplatename; } set { secondtemplatename = value; } } public string SecondTemplateLocation { get { return secondtemplatelocation; } set { secondtemplatelocation = value; } } public byte ColumnFreeze { get { return columnfreeze; } set { columnfreeze = value; } } public string PivotFormat { get { return pivotformat; } set { pivotformat = value; } } public int PageId { get { return pageid; } set { pageid = value; } } public int IsDataPivot { get { return isdatapivot; } set { isdatapivot = value; } } public string PageCode { get { return pagecode; } set { pagecode = value; } } public string PageName { get { return pagename; } set { pagename = value; } } public string PageLayout { get { return pagelayout; } set { pagelayout = value; } } #endregion private string criteriaattributesection; private string criteriaattributepicklistseconduri; private string picklisturlfrom; public string CriteriaAttributePicklistSecondURI { get { return criteriaattributepicklistseconduri; } set { criteriaattributepicklistseconduri = value; } } public string PicklistURLFrom { get { return picklisturlfrom; } set { picklisturlfrom = value; } } public string CriteriaAttributeSection { get { return criteriaattributesection; } set { criteriaattributesection = value; } } public string SecondURITemplate { get { return seconduritemplate; } set { seconduritemplate = value; } } public string MenuCode { get { return menucode; } set { menucode = value; } } private int uservsmenuid = -1; public int UserVsMenuId { get { return uservsmenuid; } set { uservsmenuid = value; } } public int PeriodType { get { return periodtype; } set { periodtype = value; } } public string MenuDisplayName { get { return menudisplayname; } set { menudisplayname = value; } } public string MenuObjectModelName { get { return menuobjectmodelname; } set { menuobjectmodelname = value; } } } }