private void DeleteMenuSet(string menuSetCD) { try { MenuSetMaintenanceController ctlMenuSet = new MenuSetMaintenanceController(); ctlMenuSet.DeleteMenuSet(menuSetCD); shtMenuSet.RemoveRows(shtMenuSet.ActiveRowIndex, 1); } catch (ValidateException err) { for (int i = 0; i < err.ErrorResults.Count; i++) { MessageBox.Show(err.ErrorResults[i].Message.MessageDescription); err.ErrorResults[i].FocusOnControl(); } } catch (BusinessException err) { MessageDialog.ShowBusiness(this, err.Error.Message.MessageDescription); } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); } }
private void SaveData() { try { MenuSetMaintenanceController ctlMenuSet = new MenuSetMaintenanceController(); MenuSetMaintenanceUIDM uidmMenuSet = dmcAddMenuSet.SaveData(new MenuSetMaintenanceUIDM()); ctlMenuSet.AddNewMenuSet(uidmMenuSet); this.Close(); } catch (ValidateException err) { for (int i = 0; i < err.ErrorResults.Count; i++) { MessageDialog.ShowBusiness(this, err.ErrorResults[i].Message.MessageDescription); err.ErrorResults[i].FocusOnControl(); } } catch (BusinessException err) { MessageDialog.ShowBusiness(this, err.Error.Message.MessageDescription); } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); } }
private void LoadData(string menuSetCD, string keyFilter) { try { MenuSetMaintenanceController ctlMenuSet = new MenuSetMaintenanceController(); DataTable dtMenuSub = ctlMenuSet.LoadAllMenuSubNotInMenuSet(menuSetCD); DataTable dtView = dtMenuSub.Clone(); if (keyFilter != string.Empty) { //get only the rows you want DataRow[] results = dtMenuSub.Select(string.Format("MENU_SUB_CD LIKE '%{0}%' OR MENU_SUB_NAME LIKE '%{0}%' ", keyFilter)); //populate new destination table foreach (DataRow dr in results) { dtView.ImportRow(dr); } } else { foreach (DataRow dr in dtMenuSub.Rows) { dtView.ImportRow(dr); } } shtMenuSub.DataSource = dtView; } catch (ValidateException err) { for (int i = 0; i < err.ErrorResults.Count; i++) { MessageDialog.ShowBusiness(this, err.ErrorResults[i].Message.MessageDescription); err.ErrorResults[i].FocusOnControl(); } if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } } catch (BusinessException err) { MessageDialog.ShowBusiness(this, err.Error.Message.MessageDescription); if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } } }
private void LoadMenuSetDetail() { int activeRow = shtMenuSet.ActiveRowIndex; MenuSetMaintenanceController ctlMenuSet = new MenuSetMaintenanceController(); string MenuSetCD = shtMenuSet.Cells[activeRow, (int)eColMenuSet.MENU_SET_CD].Text; DataTable dtMenuSub = ctlMenuSet.LoadMenuSubByMenuSetCD(MenuSetCD); shtMenuSub.DataSource = dtMenuSub; m_OldActiveRow = activeRow; }
private void LoadData() { try { MenuSetMaintenanceController ctlMenuSet = new MenuSetMaintenanceController(); DataTable dtMenuSet = ctlMenuSet.LoadAllMenuSet(); if (dtMenuSet != null && dtMenuSet.Rows.Count > 0) { shtMenuSet.DataSource = dtMenuSet; shtMenuSet.AddSelection(0, 0, 1, 2); string MenuSetCD = shtMenuSet.Cells[0, (int)eColMenuSet.MENU_SET_CD].Text; DataTable dtMenuSub = ctlMenuSet.LoadMenuSubByMenuSetCD(MenuSetCD); shtMenuSub.DataSource = dtMenuSub; } } catch (ValidateException err) { for (int i = 0; i < err.ErrorResults.Count; i++) { MessageBox.Show(err.ErrorResults[i].Message.MessageDescription); err.ErrorResults[i].FocusOnControl(); } if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } } catch (BusinessException err) { MessageDialog.ShowBusiness(this, err.Error.Message.MessageDescription); if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } } }
private void SaveMenuSetDesc(string menuSetCD, string menuSetDesc) { try { CommonLib.Common.CurrentDatabase.KeepConnection = true; CommonLib.Common.CurrentDatabase.BeginTransaction(); MenuSetMaintenanceController ctlMenuSet = new MenuSetMaintenanceController(); ctlMenuSet.SaveMenuSetDesc(menuSetCD, menuSetDesc); CommonLib.Common.CurrentDatabase.Commit(); } catch (ValidateException err) { for (int i = 0; i < err.ErrorResults.Count; i++) { MessageBox.Show(err.ErrorResults[i].Message.MessageDescription); err.ErrorResults[i].FocusOnControl(); } if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } shtMenuSet.Cells[shtMenuSet.ActiveRowIndex, (int)eColMenuSet.MENU_SET_NAME].Text = m_OldMenuSetDesc; } catch (BusinessException err) { MessageDialog.ShowBusiness(this, err.Error.Message.MessageDescription); if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } shtMenuSet.Cells[shtMenuSet.ActiveRowIndex, (int)eColMenuSet.MENU_SET_NAME].Text = m_OldMenuSetDesc; } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } shtMenuSet.Cells[shtMenuSet.ActiveRowIndex, (int)eColMenuSet.MENU_SET_NAME].Text = m_OldMenuSetDesc; } }
private void RemoveSubMenu(string menuSetCD, string menuSubCD) { try { MenuSetMaintenanceController ctlMenuSet = new MenuSetMaintenanceController(); ctlMenuSet.DeleteMenuSetDetail(menuSetCD, menuSubCD); shtMenuSub.RemoveRows(shtMenuSub.ActiveRowIndex, 1); } catch (ValidateException err) { for (int i = 0; i < err.ErrorResults.Count; i++) { MessageBox.Show(err.ErrorResults[i].Message.MessageDescription); err.ErrorResults[i].FocusOnControl(); } if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } } catch (BusinessException err) { MessageDialog.ShowBusiness(this, err.Error.Message.MessageDescription); if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } } }
private void UpdateDisplaySEQ(eSeqUpdate eSeqUpdate, string MenuSetCD, string MenuSubCD_UP, string MenuSubCD_DOWN, int DisplaySQ_UP, int DisplaySQ_DOWN) { try { MenuSetMaintenanceController ctlMenuSet = new MenuSetMaintenanceController(); ctlMenuSet.UpdateDisplaySEQ(MenuSetCD, MenuSubCD_UP, MenuSubCD_DOWN, DisplaySQ_UP, DisplaySQ_DOWN); } catch (ValidateException err) { for (int i = 0; i < err.ErrorResults.Count; i++) { MessageBox.Show(err.ErrorResults[i].Message.MessageDescription); err.ErrorResults[i].FocusOnControl(); } if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } } catch (BusinessException err) { MessageDialog.ShowBusiness(this, err.Error.Message.MessageDescription); if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); if (CommonLib.Common.CurrentDatabase.DBTransactionState == EVOFramework.Database.TransactionState.PROCESSING) { CommonLib.Common.CurrentDatabase.Rollback(); } } }
private void btnRegist_Click(object sender, EventArgs e) { int row = shtMenuSub.Rows.Count; //int activeRow=shtMenuSub.ActiveRowIndex; bool isRowSelected = false; for (int i = 0; i < row; i++) { if (shtMenuSub.Cells[i, (int)eColMenuSub.SEL].Text == "True") { isRowSelected = true; break; } } if (!isRowSelected) { return; } switch (ShowConfirmMessage(Messages.eConfirm.CFM9001)) { case MessageDialogResult.Cancel: return; case MessageDialogResult.No: this.Close(); return; case MessageDialogResult.Yes: break; } try { MenuSetMaintenanceController ctlMenuSet = new MenuSetMaintenanceController(); for (int i = 0; i < row; i++) { if (shtMenuSub.Cells[i, (int)eColMenuSub.SEL].Text == "True") { string MenuSubCD = shtMenuSub.Cells[i, (int)eColMenuSub.MENU_SUB_CD].Text; ctlMenuSet.AddMenuSetDetail(m_MenuSetCD, MenuSubCD); } } this.Close(); } catch (ValidateException err) { for (int i = 0; i < err.ErrorResults.Count; i++) { MessageDialog.ShowBusiness(this, err.ErrorResults[i].Message.MessageDescription); err.ErrorResults[i].FocusOnControl(); } } catch (BusinessException err) { MessageDialog.ShowBusiness(this, err.Error.Message.MessageDescription); } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); } }