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();
}
