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