public void DeleteMenu(SMAM_Menu_ST menu)
{
try
{
db.Configuration.ProxyCreationEnabled = false;
db.Entry(menu).State = EntityState.Deleted;
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
//return 0;
}
}
public int DeleteMenu(SMAM_Menu_ST Menu)
{
try
{
dbUser.Timeout = System.Threading.Timeout.Infinite;
dbUser.DeleteMenu(Menu);
dbUser.Dispose();
dbUser.Abort();
return(Menu.MenuId);
}
catch (Exception ex)
{
dbUser.Dispose();
dbUser.Abort();
throw ex;
}
}
public ActionResult Menu(SMAM_Menu_ST Menu)
{
try
{
string strMessage = "";
bool _success = false;
if (Menu.MenuId > 0)
{
Menu.MenuIdSpecified = true;
Menu.ParentMenuIdSpecified = true;
Menu.MenuSeqSpecified = true;
int maxValue = dbUser.UpdateMenu(Menu);
if (maxValue > 0)
{
strMessage = "Record successfully updated.";
_success = true;
}
else
{
strMessage = "Application server error.";
}
}
else
{
Menu.ParentMenuIdSpecified = true;
Menu.MenuSeqSpecified = true;
int maxValue = dbUser.InsertMenu(Menu);
Menu.MenuId = maxValue;
if (maxValue > 0)
{
strMessage = "Record successfully saved.";
_success = true;
}
else
{
strMessage = "Application server error.";
}
}
return(Json(new { success = _success, response = strMessage }));
}
catch (Exception ex)
{
Log.LogWrite(ex.Message, "Menu Insert/Edit", ex);
return(Json(new { success = false, response = ex.Message.ToString() }));
}
}
public int InsertMenu(SMAM_Menu_ST Menu)
{
try
{
dbUser.Timeout = System.Threading.Timeout.Infinite;
int _menuId = 0;
bool specified = true;
dbUser.InsertMenu(Menu, out _menuId, out specified);
dbUser.Dispose();
dbUser.Abort();
return(_menuId);
}
catch (Exception ex)
{
dbUser.Dispose();
dbUser.Abort();
throw ex;
}
}
public int InsertMenu(SMAM_Menu_ST menu)
{
try
{
db.Configuration.ProxyCreationEnabled = false;
int maxMenuId = 0;
if (db.SMAM_Menu_ST.Count() > 0)
{
maxMenuId = db.SMAM_Menu_ST.Select(x => x.MenuId).Max();
}
maxMenuId = maxMenuId + 1;
menu.MenuId = maxMenuId;
db.SMAM_Menu_ST.Add(menu);
db.SaveChanges();
return(maxMenuId);
}
catch (Exception ex)
{
throw ex;
//return 0;
}
}
