public bool AssignShortcut(ERPMDL.mdlMyShortcut objMdlMyShortcut, string operation)
{
if (_con.State == ConnectionState.Open)
{
_con.Close();
}
_con.Open();
var transaction = _con.BeginTransaction();
var isSaved = false;
try
{
//var cmd = new SqlCommand("delete from M_CustomizeShortcut where userid = '" + objMdlMyShortcut.UserID + "'", _con, transaction);
//cmd.CommandType = CommandType.Text;
//cmd.ExecuteNonQuery();
// for (var i = 0; i <= objMdlMyShortcut.MyMenu.Rows.Count - 1; i++)
// {
var cmd = new SqlCommand();
if (operation == "Assign")
{
cmd = new SqlCommand("insert into M_CustomizeShortcut (UserID, MenuItem, Shortcut) values ('" + objMdlMyShortcut.UserID + "' ,'" + objMdlMyShortcut.MenuItem + "', '" + objMdlMyShortcut.ShortKey + "') ", _con, transaction);
}
else if(operation == "Replace")
{
cmd = new SqlCommand("update M_CustomizeShortcut set Shortcut = '" + objMdlMyShortcut.ShortKey + "' where userid = '" + objMdlMyShortcut.UserID + "' and menuitem = '" + objMdlMyShortcut.MenuItem + "'", _con, transaction);
}
else if (operation == "ReplaceAgainstShortcut")
{
cmd = new SqlCommand("update M_CustomizeShortcut set menuitem = '" + objMdlMyShortcut.MenuItem + "' where userid = '" + objMdlMyShortcut.UserID + "' and Shortcut = '" + objMdlMyShortcut.ShortKey + "'", _con, transaction);
}
else if (operation == "Delete")
{
cmd = new SqlCommand("delete from M_CustomizeShortcut where userid = '" + objMdlMyShortcut.UserID + "' and menuitem = '" + objMdlMyShortcut.MenuItem + "'", _con, transaction);
}
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
isSaved = true;
// }
transaction.Commit();
if (_con.State == ConnectionState.Open)
{
_con.Close();
}
}
catch (Exception ex)
{
transaction.Rollback();
if (_con.State == ConnectionState.Open)
{
_con.Close();
}
MessageBox.Show(ex.Message);
isSaved = false;
}
return isSaved;
}
public bool InsertMenu(ERPMDL.mdlMyMenu objMdlMyMenu)
{
if (_con.State == ConnectionState.Open)
{
_con.Close();
}
_con.Open();
var transaction = _con.BeginTransaction();
var isSaved = false;
try
{
var cmd = new SqlCommand("delete from M_CustomizeMenu where userid = '"+ objMdlMyMenu.UserID +"'", _con, transaction);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
for (var i = 0; i <= objMdlMyMenu.MyMenu.Rows.Count - 1; i++)
{
cmd = new SqlCommand("insert into M_CustomizeMenu (UserID, MenuItem) values ('" + objMdlMyMenu.UserID + "' ,'" + objMdlMyMenu.MyMenu.Rows[i][0] + "') ", _con, transaction);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
transaction.Commit();
isSaved = true;
if (_con.State == ConnectionState.Open)
{
_con.Close();
}
}
catch (Exception ex)
{
transaction.Rollback();
if (_con.State == ConnectionState.Open)
{
_con.Close();
}
MessageBox.Show(ex.Message);
isSaved = false;
}
return isSaved;
}
