public void Deletemenu(int Id)
{
Menu_List Menu = _db.Menu_List.Where(x => x.ID == Id).FirstOrDefault();
_db.Menu_List.Remove(Menu);
_db.SaveChanges();
}
/// <summary>
/// for binding string nth level
/// </summary>
/// <param name="data">table Data</param>
/// <param name="menuId"></param>
/// <param name="breadCum">last breadcum</param>
/// <returns>return breducum string </returns>
public string createMenuBreadCum(List <Menu_List> data, int menuId, string breadCum)
{
var currentRecord = data.Where(x => x.ID == menuId).FirstOrDefault();
Menu_List parentRecord = null;
if (currentRecord.SubmenuID > 0)
{
parentRecord = data.Where(x => x.ID == currentRecord.SubmenuID).FirstOrDefault();
}
if (string.IsNullOrEmpty(breadCum))
{
if (parentRecord != null)
{
breadCum = string.Format("{0} >> {1}", parentRecord.MenuName, currentRecord.MenuName);
}
}
else
{
breadCum = string.Format("{0} >> {1}", parentRecord.MenuName, breadCum);
}
if (parentRecord != null)
{
if (parentRecord.SubmenuID > 0)
{
breadCum = createMenuBreadCum(data, parentRecord.ID, breadCum);
}
}
return(breadCum);
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Menu_List menu_List = await db.Menu_Lists.FindAsync(id);
db.Menu_Lists.Remove(menu_List);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "ItemId,ItemPrice,ShortDescription,LongDescription,IconImage,ItemName")] Menu_List menu_List)
{
if (ModelState.IsValid)
{
db.Entry(menu_List).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(menu_List));
}
public UserMenu getUserMenu(string Action, string controller, int userId)
{
UserMenu umenu = null;
Menu_List menu = _db.Menu_List.Where(x => x.ActionName.ToLower() == Action.ToLower() && x.ControllerName.ToLower() == controller.ToLower()).FirstOrDefault();
if (menu != null)
{
umenu = _db.UserMenus.Where(x => x.MenuID == menu.ID && x.UserID == userId).FirstOrDefault();
}
return(umenu);
}
public async Task <ActionResult> Create([Bind(Include = "ItemId,ItemPrice,ShortDescription,LongDescription,IconImage,ItemName")] Menu_List menu_List)
{
if (ModelState.IsValid)
{
db.Menu_Lists.Add(menu_List);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(menu_List));
}
public void UpdateRecord(RolesManagementMenuViewModel model)
{
Menu_List menu = _db.Menu_List.Where(x => x.ID == model.Id).FirstOrDefault();
menu.MenuName = model.MenuName;
menu.ActionName = model.ActionName;
menu.ControllerName = model.ControllerName;
menu.SubmenuID = model.SubmenuId;
//menu.CreatedBy = model.CreatedBy;
menu.Createdate = DateTime.Now;
_db.SaveChanges();
}
/// <summary>
/// For binding (Add in model) Role Table nth level
/// </summary>
/// <returns></returns>
public void ListOfnestedLoop(List <Menu_List> dbData, int SubmenuId)
{
foreach (var item in dbData.Where(x => x.SubmenuID == SubmenuId))
{
Menu_List m = new Menu_List();
m = item;
menuModel.Add(m);
var subMenuCount = dbData.Where(x => x.SubmenuID == item.ID).ToList();
if (subMenuCount.Count > 0)
{
ListOfnestedLoop(dbData, (int)item.ID);
}
}
}
// GET: Menu_List/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
//return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
id = 1;
}
Menu_List menu_List = await db.Menu_Lists.FindAsync(id);
if (menu_List == null)
{
return(HttpNotFound());
}
return(View(menu_List));
}
/// <summary>
/// insert new record in table
/// </summary>
/// <param name="model">pass all menu model</param>
/// <returns>last inserted recod ID</returns>
public int InsertRecord(RolesManagementMenuViewModel model)
{
Menu_List menu = new Menu_List();
menu.MenuName = model.MenuName;
menu.ActionName = model.ActionName;
menu.ControllerName = model.ControllerName;
menu.SubmenuID = model.SubmenuId;
menu.DisplayOrder = lastDisplayOrder(model.SubmenuId);
menu.Createdate = DateTime.Now;
menu.CreatedBy = model.CreatedBy;
menu.MenuKey = model.MenuKeyValues;
_db.Menu_List.Add(menu);
_db.SaveChanges();
return(menu.ID);
}
//
// GET: /RolesManagement/
#region Private method
/// <summary>
/// For binding Role Table 0th level
/// </summary>
/// <returns>list of menu table grouping with it's parent menu</returns>
public List <Menu_List> setOrderby()
{
List <Menu_List> list = (from i in _db.Menu_List
select i).ToList();
foreach (var item in list.Where(x => x.SubmenuID == 0))
{
Menu_List m = new Menu_List();
m = item;
menuModel.Add(m);
var subMenuCount = list.Where(x => x.SubmenuID == item.ID).ToList();
if (subMenuCount.Count > 0)
{
ListOfnestedLoop(list, (int)item.ID);
}
}
return(menuModel);
}
public ActionResult AddEditApplicationSave(FormCollection frm)
{
Menu_List objMenu;
int _hdnmenuId = 0;
if (ModelState.IsValid)
{
_hdnmenuId = Convert.ToInt32(frm["menuID"].ToString());
if (_hdnmenuId > 0)
{
objMenu = db.Menu_List.Where(o => o.menuID == _hdnmenuId).SingleOrDefault();
}
else
{
objMenu = new Menu_List();
objMenu.menuParentID = Convert.ToInt32(frm["menuParentID"].ToString());
}
objMenu.menuName = frm["menuName"].ToString();
objMenu.actionName = frm["actionName"].ToString();
objMenu.controllerName = frm["controllerName"].ToString();
if (_hdnmenuId > 0)
{
db.Entry(objMenu).State = EntityState.Modified;
db.SaveChanges();
}
else
{
db.Menu_List.Add(objMenu);
}
db.SaveChanges();
}
return(RedirectToAction("ManageApplication"));
}
public ActionResult AddEditApplication(String id, String parentid)
{
int _id = 0;
int _parentid = 0;
CreateApplicationModel mod = new CreateApplicationModel();
if (id == null)
{
_parentid = Convert.ToInt32(parentid);
}
else
{
_id = Convert.ToInt32(id);;
_parentid = Convert.ToInt32(parentid);
}
Menu_List objMenu;
int _hdMenuId = Convert.ToInt32(id);
//if (_hdMenuId > 0)
if (!String.IsNullOrWhiteSpace(id) && (id != null) && (id != "null"))
{
objMenu = db.Menu_List.Where(o => o.menuID == _hdMenuId).SingleOrDefault();
mod.menuName = objMenu.menuName;
mod.actionName = objMenu.actionName;
mod.controllerName = objMenu.controllerName;
mod.menuParentID = Convert.ToInt32(_parentid);
}
else
{
objMenu = new Menu_List();
mod.menuName = objMenu.menuName;
mod.actionName = objMenu.actionName;
mod.controllerName = objMenu.controllerName;
mod.menuParentID = Convert.ToInt32(_parentid);
}
return(View(mod));
}
