public void AutoLoadReport() { subcampaign _efoSubCampaign = null; using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) { m_efoViewConfig = _efDbContext.view_configuration.FirstOrDefault(i => i.id == m_ViewConfigId); _efoSubCampaign = _efDbContext.subcampaigns.FirstOrDefault(i => i.id == m_efoViewConfig.subcampaign_id); _efDbContext.Detach(m_efoViewConfig); } lookUpEditCustomerCampaign.EditValue = _efoSubCampaign.campaign_id; for (int i = 0; i < ccbeSubcampaign.Properties.Items.Count; i++) { if (ccbeSubcampaign.Properties.Items[i].Description.Equals(_efoSubCampaign.title)) { ccbeSubcampaign.Properties.Items[i].CheckState = CheckState.Checked; break; } } cboDisplayMode.SelectedIndex = 0; this.btnLoad.PerformClick(); m_ViewConfigId = 0; }
private void barButtonItemSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //m_frmTemplateName = new TemplateName(); //m_frmTemplateName.AfterSave += new TemplateName.AfterSaveEventHandler(m_frmTemplateName_AfterSave); //m_frmTemplateName.ShowDialog(this); WaitDialog.Show("Saving template......"); export_view_report_templates _efeExportViewTemplate = new export_view_report_templates(); // used in EditorDisplayViewReportTemplate additional_data_report_templates _efeReportTemplate = new additional_data_report_templates(); // used in EditorReportTemplate view_configuration _efoViewConfiguration = new view_configuration(); // used in report configuration SaveReportEventArgs _args = GetEventArgs(); /** * if view display */ #region Logic if (ModuleType == eModuleType.Default) { _efeExportViewTemplate = m_efDbModel.export_view_report_templates.FirstOrDefault(i => i.view_config_id == ViewConfigId); if (_efeExportViewTemplate != null) { _efeExportViewTemplate.layout_config = _args.ReportTemplate; _efeExportViewTemplate.modified_on = DateTime.Now; _efeExportViewTemplate.modified_by = UserSession.CurrentUser.UserId; m_efDbModel.export_view_report_templates.ApplyCurrentValues(_efeExportViewTemplate); } else { _efeExportViewTemplate = new export_view_report_templates() { sub_campaign_id = SubCampaignId, view_config_id = ViewConfigId, layout_config = _args.ReportTemplate, created_on = DateTime.Now, created_by = UserSession.CurrentUser.UserId, modified_on = DateTime.Now, modified_by = UserSession.CurrentUser.UserId }; m_efDbModel.export_view_report_templates.AddObject(_efeExportViewTemplate); } m_efDbModel.SaveChanges(); } #endregion /** * if report template. * only update of item, no creating of new record. * creation of report template is done at the gui part of the EditorReportTemplate.cs */ #region Logic else if (ModuleType == eModuleType.ReportTemplate) { _efeReportTemplate = m_efDbModel.additional_data_report_templates.FirstOrDefault(i => i.id == ReportTemplateId); if (_efeExportViewTemplate != null) { _efeReportTemplate.layout_config = _args.ReportTemplate; _efeReportTemplate.modified_on = DateTime.Now; _efeReportTemplate.modified_by = UserSession.CurrentUser.UserId; m_efDbModel.additional_data_report_templates.ApplyCurrentValues(_efeReportTemplate); } m_efDbModel.SaveChanges(); } #endregion /** * if view configuration. * the layout is being saved to the view_configuration table. */ #region Logic else if (ModuleType == eModuleType.ViewConfiguration) { _efoViewConfiguration = m_efDbModel.view_configuration.FirstOrDefault(i => i.id == ViewConfigId); if (_efoViewConfiguration != null) { _efoViewConfiguration.report_layout_config = _args.ReportTemplate; _efeReportTemplate.modified_on = DateTime.Now; _efeReportTemplate.modified_by = UserSession.CurrentUser.UserId; m_efDbModel.view_configuration.ApplyCurrentValues(_efoViewConfiguration); } m_efDbModel.SaveChanges(); } #endregion //if (_efeExportViewTemplate != null) //{ // _efeExportViewTemplate.layout_config = _args.ReportTemplate; // _efeExportViewTemplate.modified_on = DateTime.Now; // _efeExportViewTemplate.modified_by = UserSession.CurrentUser.UserId; // m_efDbModel.export_view_report_templates.ApplyCurrentValues(_efeExportViewTemplate); //} //else //{ // _efeExportViewTemplate = new export_view_report_templates() // { // sub_campaign_id = SubCampaignId, // view_config_id = ViewConfigId, // layout_config = _args.ReportTemplate, // created_on = DateTime.Now, // created_by = UserSession.CurrentUser.UserId, // modified_on = DateTime.Now, // modified_by = UserSession.CurrentUser.UserId // }; // m_efDbModel.export_view_report_templates.AddObject(_efeExportViewTemplate); //} if (ModuleType == eModuleType.Default && AfterSave != null) AfterSave(this, new AfterSaveArgs() { efExportViewReportTemplate = _efeExportViewTemplate }); else if (ModuleType == eModuleType.ReportTemplate && AfterSave != null) AfterSave(this, new AfterSaveArgs() { efAdditionalDataReportTemplate = _efeReportTemplate }); else if (ModuleType == eModuleType.ViewConfiguration && AfterSave != null) AfterSave(this, new AfterSaveArgs() { efViewConfiguration = _efoViewConfiguration }); WaitDialog.Close(); MessageBox.Show("Active layout for visual report saved.", "Bright Manager", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); //if(!nochangenamepop){ // string name = string.Empty; // name = this.GetTemplateName(); // if (name == string.Empty) // return; // args.Name = name; //} //if (SaveReport != null) // SaveReport(this, args); }
private void btnSaveReportPerPdf_Click(object sender, EventArgs e) { WaitDialog.Show("Sending web service request ..."); List<int> _SubCampaignIds = new List<int>(); _SubCampaignIds.Add(m_SubCampaignId); using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) { m_eftConfigData = _efDbContext.view_configuration.FirstOrDefault(i => i.id == m_ViewConfigId); m_eftSubCampaign = _efDbContext.subcampaigns.FirstOrDefault(i => i.id == m_eftConfigData.subcampaign_id); m_eftCampaign = _efDbContext.campaigns.FirstOrDefault(i => i.id == m_eftSubCampaign.campaign_id); m_eftCustomer = _efDbContext.customers.FirstOrDefault(i => i.id == m_eftCampaign.customer_id); _efDbContext.Detach(m_eftConfigData); _efDbContext.Detach(m_eftSubCampaign); _efDbContext.Detach(m_eftCampaign); _efDbContext.Detach(m_eftCustomer); string _GridSortInfo = this.GetSerializedSortInfo(gridView1.SortInfo); string _ColumnsInfo = this.GetSerializedColumnsInfo(); short _CallingEnvironment = (short)(m_CallingApplication == eCallingApplication.BrightManager ? eCallingEnvironment.BrightManager_SaveAccountPerPdf : eCallingEnvironment.BrightSales_SaveAccountPerPdf); Guid _RequestId = Guid.NewGuid(); serverside_report_requests _eftRequest = new serverside_report_requests() { id = _RequestId, calling_environment = _CallingEnvironment, display_mode = (short)m_ViewType, campaign_info = string.Format("{0}>{1}>{2}", m_eftCustomer.customer_name, m_eftCampaign.campaign_name, m_eftSubCampaign.title ), sub_campaign_ids = string.Join(",", _SubCampaignIds), view_config_id = m_ViewConfigId, account_id = 0, active_filter_string = gridView1.ActiveFilterString, sort_info = _GridSortInfo, columns_info = _ColumnsInfo, requested_by = UserSession.CurrentUser.UserId, requested_on = DateTime.Now }; _efDbContext.serverside_report_requests.AddObject(_eftRequest); _efDbContext.SaveChanges(); _efDbContext.Detach(_eftRequest); ReportsUtility.CreatePdfFilesPerAccount(_RequestId.ToString()); } WaitDialog.Close(); //WaitDialog.Show("Generating PDF reports ..."); //this.GenerateReports(); //WaitDialog.Close(); }
private void GetReportPageBaseData() { m_IsEmpty = false; if (this.gridView1.DataRowCount == null || this.gridView1.DataRowCount < 1) { BrightVision.Common.UI.NotificationDialog.Information("Reports", "No data to preview."); m_IsEmpty = true; return; } using (BrightPlatformEntities _efDbModel = new BrightPlatformEntities(m_DatabaseConnection) { CommandTimeout = 0 }) { m_eftConfigData = _efDbModel.view_configuration.FirstOrDefault(i => i.id == m_ViewConfigId); m_eftSubCampaign = _efDbModel.subcampaigns.FirstOrDefault(i => i.id == m_eftConfigData.subcampaign_id); m_eftCampaign = _efDbModel.campaigns.FirstOrDefault(i => i.id == m_eftSubCampaign.campaign_id); m_eftCustomer = _efDbModel.customers.FirstOrDefault(i => i.id == m_eftCampaign.customer_id); _efDbModel.Detach(m_eftConfigData); _efDbModel.Detach(m_eftSubCampaign); _efDbModel.Detach(m_eftCampaign); _efDbModel.Detach(m_eftCustomer); _efDbModel.FIUpdateContactTitles(); /** * if send email, get data for sub_campaign_account_list and final_list. */ if (m_CallingEnvironment == eCallingEnvironment.BrightSales_SendEmail && m_AccountId > 0) { m_eftFinalList = _efDbModel.final_lists.FirstOrDefault(i => i.sub_campaign_id == m_eftSubCampaign.id); if (m_eftFinalList != null) { _efDbModel.Detach(m_eftFinalList); m_eftSubCampaignAccountList = _efDbModel.sub_campaign_account_lists.FirstOrDefault(i => i.final_list_id == m_eftFinalList.id && i.account_id == m_AccountId ); _efDbModel.Detach(m_eftSubCampaignAccountList); } } } if (m_eftConfigData == null || m_eftConfigData.report_layout_config == null) { WaitDialog.Close(); if (m_IsWebPortalCall) throw new Exception("No layout available for the selected view."); BrightVision.Common.UI.NotificationDialog.Information("Reports", "No layout available for this view."); return; } if (string.IsNullOrEmpty(m_eftConfigData.report_data_config)) { WaitDialog.Close(); if (m_IsWebPortalCall) throw new Exception("No parameter layout has been set for this report."); BrightVision.Common.UI.NotificationDialog.Information("Reports", "No parameter layout has been set for this report."); return; } m_ReportPageTemplateProperty = SerializeUtility.DeserializeFromXml<TemplateProperty>(m_eftConfigData.report_data_config); m_ReportPageDataSet = this.GetReportDataSet(m_ReportPageTemplateProperty); /** * if has sort info, then apply. */ #region Sorting Logic if (!string.IsNullOrEmpty(m_GridSortInfo)) { string sortExpression = this.GetSortExpression(gridView1); if (!string.IsNullOrEmpty(sortExpression)) { string[] _SortInfoCollection = sortExpression.Split(';'); ReportDataSet _rdsTemporary = (ReportDataSet)m_ReportPageDataSet.Clone(); DataSet _dsSortedData = new DataSet(); Dictionary<string, List<string>> _TableSortRules = new Dictionary<string, List<string>>(); /** * group all sort rules by table. */ foreach (string _SortInfo in _SortInfoCollection) { string[] _item = _SortInfo.Split('|'); string _FieldNameInfo = this.GetTableFieldName(_item[0].ToString()); if (!string.IsNullOrEmpty(_FieldNameInfo)) { string[] _val = _FieldNameInfo.Split('|'); string _TableName = _val[0]; string _FieldName = _val[1]; /** * create new table sort rule. * else, update existing table sort rule. * * format: * <column_name1>|<sort_rule1>;<column_name2>|<sort_rule2>; and so on ... * * this would later be processed by splitting the sort rules by semicolon(;), * then split by bar(|). */ string _ColumnName = m_ReportPageDataSet.Tables[_TableName].Columns[_FieldName].ColumnName; string _SortOrder = _item[1].ToString(); if (!_TableSortRules.ContainsKey(_TableName)) _TableSortRules.Add(_TableName, new List<string>()); _TableSortRules[_TableName].Add(string.Format("{0} {1}", _ColumnName, _SortOrder)); } } /** * set the sorting rules from KeyValuePair<string, List<string>> from _TableSortRules * string = table name * List<string> = sort rules */ foreach (KeyValuePair<string, List<string>> _pair in _TableSortRules) { DataTable _dtToSort = m_ReportPageDataSet.Tables[_pair.Key]; _dtToSort.DefaultView.Sort = string.Join(",", _TableSortRules[_pair.Key].ToArray()); _dsSortedData.Tables.Add(_dtToSort.DefaultView.ToTable()); } /** * copy all tables to the temporary report data set. * then overwrite the original report data set with the * temporary report dataset, since it contains the sorted * tables that the report needs. * * order of the tables, according to relationship: * 1. account * 2. accountdynamic * 3. accountstatic * 4. contact * 5. contactdynamic * 6. contactstatic * 7. clientinfo * 8. customers */ if (_dsSortedData.Tables["account"] != null) this.CopyTableRows(ref _rdsTemporary, _dsSortedData.Tables["account"].Rows, "account"); else this.CopyTableRows(ref _rdsTemporary, m_ReportPageDataSet.Tables["account"].Rows, "account"); if (_dsSortedData.Tables["accountdynamic"] != null) this.CopyTableRows(ref _rdsTemporary, _dsSortedData.Tables["accountdynamic"].Rows, "accountdynamic"); else this.CopyTableRows(ref _rdsTemporary, m_ReportPageDataSet.Tables["accountdynamic"].Rows, "accountdynamic"); if (_dsSortedData.Tables["accountstatic"] != null) this.CopyTableRows(ref _rdsTemporary, _dsSortedData.Tables["accountstatic"].Rows, "accountstatic"); else this.CopyTableRows(ref _rdsTemporary, m_ReportPageDataSet.Tables["accountstatic"].Rows, "accountstatic"); if (_dsSortedData.Tables["contact"] != null) this.CopyTableRows(ref _rdsTemporary, _dsSortedData.Tables["contact"].Rows, "contact"); else this.CopyTableRows(ref _rdsTemporary, m_ReportPageDataSet.Tables["contact"].Rows, "contact"); if (_dsSortedData.Tables["contactdynamic"] != null) this.CopyTableRows(ref _rdsTemporary, _dsSortedData.Tables["contactdynamic"].Rows, "contactdynamic"); else this.CopyTableRows(ref _rdsTemporary, m_ReportPageDataSet.Tables["contactdynamic"].Rows, "contactdynamic"); if (_dsSortedData.Tables["contactstatic"] != null) this.CopyTableRows(ref _rdsTemporary, _dsSortedData.Tables["contactstatic"].Rows, "contactstatic"); else this.CopyTableRows(ref _rdsTemporary, m_ReportPageDataSet.Tables["contactstatic"].Rows, "contactstatic"); if (_dsSortedData.Tables["clientinfo"] != null) this.CopyTableRows(ref _rdsTemporary, _dsSortedData.Tables["clientinfo"].Rows, "clientinfo"); else this.CopyTableRows(ref _rdsTemporary, m_ReportPageDataSet.Tables["clientinfo"].Rows, "clientinfo"); if (_dsSortedData.Tables["customers"] != null) this.CopyTableRows(ref _rdsTemporary, _dsSortedData.Tables["customers"].Rows, "customers"); else this.CopyTableRows(ref _rdsTemporary, m_ReportPageDataSet.Tables["customers"].Rows, "customers"); m_ReportPageDataSet = null; m_ReportPageDataSet = _rdsTemporary; } } #endregion }
private void btnShowReport_Click(object sender, EventArgs e) { WaitDialog.Show("Sending web service request ..."); List<int> _SubCampaignIds = new List<int>(); _SubCampaignIds.Add(m_SubCampaignId); using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) { _efDbContext.FIClearUserReuests(UserSession.CurrentUser.UserId); m_eftConfigData = _efDbContext.view_configuration.FirstOrDefault(i => i.id == m_ViewConfigId); m_eftSubCampaign = _efDbContext.subcampaigns.FirstOrDefault(i => i.id == m_eftConfigData.subcampaign_id); m_eftCampaign = _efDbContext.campaigns.FirstOrDefault(i => i.id == m_eftSubCampaign.campaign_id); m_eftCustomer = _efDbContext.customers.FirstOrDefault(i => i.id == m_eftCampaign.customer_id); _efDbContext.Detach(m_eftConfigData); _efDbContext.Detach(m_eftSubCampaign); _efDbContext.Detach(m_eftCampaign); _efDbContext.Detach(m_eftCustomer); Guid _RequestId = Guid.NewGuid(); string _GridSortInfo = this.GetSerializedSortInfo(gridView1.SortInfo); string _ColumnsInfo = this.GetSerializedColumnsInfo(); serverside_report_requests _eftRequest = new serverside_report_requests() { id = _RequestId, calling_environment = (short)m_CallingEnvironment, display_mode = (short)m_ViewType, //calling_environment = (short)ReportsUtility.eCallingEnvironment.BrightSales_ViewDisplay, //display_mode = (short)ReportsUtility.eDisplayMode.AccountsContacts_WithDialogData, campaign_info = string.Format("{0}>{1}>{2}", m_eftCustomer.customer_name, m_eftCampaign.campaign_name, m_eftSubCampaign.title ), sub_campaign_ids = string.Join(",", _SubCampaignIds), view_config_id = m_ViewConfigId, account_id = 0, active_filter_string = gridView1.ActiveFilterString, sort_info = _GridSortInfo, columns_info = _ColumnsInfo, requested_by = UserSession.CurrentUser.UserId, requested_on = DateTime.Now }; _efDbContext.serverside_report_requests.AddObject(_eftRequest); _efDbContext.SaveChanges(); _efDbContext.Detach(_eftRequest); ReportsUtility.SendReportRequest(_RequestId.ToString()); } WaitDialog.Close(); //WaitDialog.Show("Sending web service request ..."); //using (BrightPlatformEntities _efDbContext = new BrightPlatformEntities(UserSession.EntityConnection)) { // serverside_report_requests _eftRequest = new serverside_report_requests() { // calling_environment = (short)ReportsUtility.eCallingEnvironment.BrightSales_ViewDisplay, // display_mode = (short)ReportsUtility.eDisplayMode.AccountsContacts_WithDialogData, // campaign_info = m_CampaignInfo, // //sub_campaign_ids = string.Join(",", pSubCampaignIds), // view_config_id = m_ViewConfigId, // account_id = 0, // requested_by = UserSession.CurrentUser.UserId, // requested_on = DateTime.Now // }; // _efDbContext.serverside_report_requests.AddObject(_eftRequest); // string _RequestId = _eftRequest.id.ToString(); // _efDbContext.Detach(_eftRequest); // this.SendReportRequest(_RequestId); //} //WaitDialog.Close(); //WaitDialog.Show("Loading report preview ..."); //this.ReportPagePreview(); //WaitDialog.Close(); }
private void btnDeleteView_Click(object sender, EventArgs e) { if (MessageBox.Show("Are you sure you want to delete current selected view?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) return; tcViewConfig.SelectedTabPage = tbpgeGridConfig; tbpgeGridConfig.Image = ManagerApplication.Properties.Resources.incomplete_on_edit; tbpgeLayoutConfig.Image = ManagerApplication.Properties.Resources.incomplete_on_edit; btnEditReportTemplate.Image = ManagerApplication.Properties.Resources.view_config_incomplete; tbpgeParameterConfig.Image = ManagerApplication.Properties.Resources.incomplete_on_edit; var objSender = lookUpEditViewList; if (objSender != null) { var val = objSender.EditValue; if (val != null) { int configId = (int)val; if (configId > 0) { m_efoViewConfig = m_efDbContext.view_configuration.FirstOrDefault(x => x.id == configId); if (m_efoViewConfig != null) { m_efoViewConfig.MGC = true; m_efDbContext.SaveChanges(); } } } BindViewList(); gcAvailableColumns.DataSource = null; gcColumnView.DataSource = null; lcgLeft.Enabled = false; lcgRight.Enabled = false; tcViewConfig.Enabled = false; btnPreviewView.Enabled = false; //txtViewName.Text = ""; m_ViewName = string.Empty; MessageBox.Show("View configuration has been deleted.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnCreateBlankView_Click(object sender, EventArgs e) { if (!IsSaved) { if (MessageBox.Show("Do you want to save changes to the current view?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) btnSaveConfig_Click(null, null); else IsSaved = true; } WaitDialog.Show(ParentForm, "Loading Data Views..."); m_ConfigGrid = new ReportConfig() { Complete = false, OnEditMode = true // create new blank view is always on edit mode. }; m_ConfigLayout = new ReportConfig() { Complete = false, OnEditMode = false }; m_ConfigParameter = new ReportConfig() { Complete = false, OnEditMode = false }; m_LoadedParameters = false; m_LoadedLayout = false; m_LoadedConfig = false; // means this is not a loaded existing view config tbpgeGridConfig.Image = ManagerApplication.Properties.Resources.incomplete_on_edit; tbpgeLayoutConfig.Image = ManagerApplication.Properties.Resources.incomplete_on_edit; btnEditReportTemplate.Image = ManagerApplication.Properties.Resources.view_config_incomplete; tbpgeParameterConfig.Image = ManagerApplication.Properties.Resources.incomplete_on_edit; m_GoDefault = true; tcViewConfig.SelectedTabPage = tbpgeGridConfig; lookUpEditViewList.EditValue = null; lookUpEditViewList.Properties.ReadOnly = true; lookUpEditSubcampaign.Properties.ReadOnly = true; //lcgHeaderControls.Enabled = true; lcgLeft.Enabled = true; lcgRight.Enabled = true; tcViewConfig.Enabled = true; //txtViewName.Text = ""; BindGridAvailableColumns(); BindGridColumnsInView(); //var objSen = sender as SimpleButton; //if (objSen != null) objSen.Enabled = false; btnCreateBlankView.Enabled = false; btnCancel.Enabled = true; btnLoadView.Enabled = false; btnDeleteView.Enabled = false; btnLoadLayoutTemplateToReport.Enabled = false; //btnDuplicateView.Enabled = false; btnShowXmlViewConfig.Enabled = true; IsNewConfig = true; m_efoViewConfig = null; WaitDialog.Close(); //CreateBlankView _control = new CreateBlankView(true); //_control.AfterSave += new CreateBlankView.AfterSaveEventHandler(_control_AfterSave); //PopupDialog _dlg = new PopupDialog() { // FormBorderStyle = FormBorderStyle.FixedSingle, // MinimizeBox = false, // MaximizeBox = false, // StartPosition = FormStartPosition.CenterScreen, // Text = "New View" //}; //_dlg.Controls.Add(_control); //_dlg.ClientSize = new Size(_control.Width + 2, _control.Height + 2); //_dlg.ShowDialog(this.ParentForm); //if (!IsSaved) { // if (MessageBox.Show("Do you want to save changes to the current view?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { // btnSaveConfig_Click(null, null); // } // else { // IsSaved = true; // } //} //lookUpEditViewList.EditValue = null; //lookUpEditViewList.Properties.ReadOnly = true; //lookUpEditSubcampaign.Properties.ReadOnly = true; //WaitDialog.Show(ParentForm, "Loading Data Views..."); ////lcgHeaderControls.Enabled = true; //lcgLeft.Enabled = true; //lcgRight.Enabled = true; ////txtViewName.Text = ""; //BindGridAvailableColumns(); //BindGridColumnsInView(); //var objSen = sender as SimpleButton; //if (objSen != null) objSen.Enabled = false; //btnLoadView.Enabled = false; //btnDeleteView.Enabled = false; ////btnDuplicateView.Enabled = false; //btnShowXmlViewConfig.Enabled = true; //IsNewConfig = true; //viewConfig = null; //WaitDialog.Close(); }
private bool SaveConfiguration(bool pIsNew) { System.IO.StringWriter writer = new System.IO.StringWriter(); DataSet dsResult = null; if (dtColumnsInView.DataSet == null) { dsResult = new DataSet("view"); dsResult.Tables.Add(dtColumnsInView); } else { dsResult = dtColumnsInView.DataSet; } dsResult.WriteXml(writer, XmlWriteMode.IgnoreSchema); var xmlConfig = writer.ToString(); if (string.IsNullOrEmpty(xmlConfig) || xmlConfig.Equals("<view />")) { msgPopupRegular.Show(this.ParentForm, "Bright Manager", "No columns defined for the report."); return false; } if (m_efoViewConfig == null) { m_efoViewConfig = new view_configuration() { date_created = DateTime.Now, created_by = UserSession.CurrentUser.UserId }; } else { m_efoViewConfig.modified_by = UserSession.CurrentUser.UserId; m_efoViewConfig.date_modified = DateTime.Now; } m_efoViewConfig.xml_config = xmlConfig; m_efoViewConfig.subcampaign_id = m_iSubcampaignID; if (pIsNew) m_efoViewConfig.name = m_ViewName; try { if (IsNewConfig) m_efDbContext.view_configuration.AddObject(m_efoViewConfig); m_efDbContext.SaveChanges(); int configID = m_efoViewConfig.id; BindViewList(); lookUpEditViewList.EditValue = configID; btnDeleteView.Enabled = true; btnShowXmlViewConfig.Enabled = true; //MessageBox.Show("View configuration has been saved.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); IsNewConfig = false; IsSaved = true; m_ConfigGrid.Complete = true; tbpgeGridConfig.Image = ManagerApplication.Properties.Resources.save_ok; this.SetPreviewReport(); return true; /** * changing tab color code. */ //tcViewConfig.LookAndFeel.Style = DevExpress.LookAndFeel.LookAndFeelStyle.Flat; //tcViewConfig.LookAndFeel.UseDefaultLookAndFeel = false; //tbpgeGridReport.Appearance.Header.BackColor = Color.PaleGreen; //tbpgeGridReport.Appearance.Header.Options.UseBackColor = true; } catch { return false; } }
private void btnLoadView_Click(object sender, EventArgs e) { if (!IsSaved) { if (MessageBox.Show("Do you want to save changes to the current view?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { btnSaveConfig_Click(null, null); } else { IsSaved = true; } } WaitDialog.Show(ParentForm, "Loading data view ..."); /** * set default icons and flags first. */ m_ConfigGrid = new ReportConfig() { Complete = false, OnEditMode = false }; m_ConfigLayout = new ReportConfig() { Complete = false, OnEditMode = false }; m_ConfigParameter = new ReportConfig() { Complete = false, OnEditMode = false }; m_LoadedParameters = false; m_LoadedLayout = false; m_LoadedConfig = true; m_IsNew = false; IsNewConfig = false; tbpgeLayoutConfig.Image = ManagerApplication.Properties.Resources.incomplete_on_edit; btnEditReportTemplate.Image = ManagerApplication.Properties.Resources.view_config_incomplete; tbpgeParameterConfig.Image = ManagerApplication.Properties.Resources.incomplete_on_edit; gcAvailableColumns.DataSource = null; gcColumnView.DataSource = null; this.BindGridAvailableColumns(); this.BindGridColumnsInView(); btnShowXmlViewConfig.Enabled = true; lookUpEditSubcampaign.Properties.ReadOnly = true; lcgLeft.Enabled = true; lcgRight.Enabled = true; tcViewConfig.Enabled = true; btnDeleteView.Enabled = true; btnCancel.Enabled = true; btnLoadLayoutTemplateToReport.Enabled = true; //btnPreviewView.Enabled = true; var objSender = lookUpEditViewList; if (objSender != null) { var val = objSender.EditValue; if (val != null) { int configId = (int)val; if (configId > 0) { m_efoViewConfig = m_efDbContext.view_configuration.FirstOrDefault(x => x.id == configId); if (m_efoViewConfig != null) { this.LoadXML(m_efoViewConfig.xml_config); m_ViewName = m_efoViewConfig.name; /** * grid config. */ m_ConfigGrid.OnEditMode = true; if (!string.IsNullOrEmpty(m_efoViewConfig.xml_config)) { m_ConfigGrid.Complete = true; tbpgeGridConfig.Image = ManagerApplication.Properties.Resources.save_ok; } else tbpgeGridConfig.Image = ManagerApplication.Properties.Resources.incomplete_on_edit; /** * layout config. */ if (!string.IsNullOrEmpty(m_efoViewConfig.report_layout_config)) { m_ConfigLayout.Complete = true; tbpgeLayoutConfig.Image = ManagerApplication.Properties.Resources.save_ok; btnEditReportTemplate.Image = ManagerApplication.Properties.Resources.view_config_completed; } else { tbpgeLayoutConfig.Image = ManagerApplication.Properties.Resources.incomplete_on_edit; btnEditReportTemplate.Image = ManagerApplication.Properties.Resources.view_config_incomplete; } /** * parameter config. */ if (!string.IsNullOrEmpty(m_efoViewConfig.report_data_config)) { m_ConfigParameter.Complete = true; tbpgeParameterConfig.Image = ManagerApplication.Properties.Resources.save_ok; } else tbpgeParameterConfig.Image = ManagerApplication.Properties.Resources.incomplete_on_edit; } } } } this.SetPreviewReport(); WaitDialog.Close(); }