public string Save(AddMenuModel aModel)
{
try
{
string msg = "";
const string query = @"INSERT INTO tbl_TREE_MAIN (DepartmentName, MainMenuName, SubMenuName, MenuSerialNo) VALUES (@DepartmentName, @MainMenuName, @SubMenuName, @MenuSerialNo)";
Con.Open();
var cmd = new SqlCommand(query, Con);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@DepartmentName", aModel.DepartmentName);
cmd.Parameters.AddWithValue("@MainMenuName", aModel.MainMenuName);
cmd.Parameters.AddWithValue("@SubMenuName", aModel.SubMenuName);
cmd.Parameters.AddWithValue("@MenuSerialNo", aModel.SubMenuSlNo);
cmd.Parameters.AddWithValue("@ControllerName", aModel.ControllerName ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("@ViewName", aModel.ViewName ?? (object)DBNull.Value);
int rtn = cmd.ExecuteNonQuery();
msg = rtn == 1 ? "Saved Success" : "Saved Failed";
Con.Close();
return(msg);
}
catch (Exception exception)
{
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
return(exception.ToString());
}
}
public async Task <IActionResult> AddMenu()
{
AddMenuModel viewModel = new AddMenuModel();
viewModel.ParentMenus = await _DbContext.NavigationMenu.ToListAsync();
return(View(viewModel));
}
public JsonResult Add(AddMenuModel model)
{
JsonResult json = new JsonResult();
if (string.IsNullOrEmpty(model.menuName))
{
return(Json(new { success = false, msg = "菜单名称不为空" }, "text/json"));
}
if (string.IsNullOrEmpty(model.menuUrl))
{
return(Json(new { success = false, msg = "菜单Url不为空" }, "text/json"));
}
Menu mMenu = db.Menu.Where(m => m.menuName == model.menuName).FirstOrDefault();
if (mMenu != null)
{
return(Json(new { success = false, msg = "该菜单已经存在，请更换菜单名称" }, "text/json"));
}
using (TransactionScope scope = new TransactionScope())
{
try
{
Menu menu = new Menu
{
menuName = model.menuName,
menuUrl = model.menuUrl,
menuNote = model.menuNote,
parentMenuId = model.menuId
};
db.Menu.Add(menu);
if (db.SaveChanges() > 0)
{
json.Data = new { success = true, msg = "添加成功！" };
}
else
{
json.Data = new { success = false, msg = "添加失败！" };
}
}
catch (DbEntityValidationException ex)
{
throw;
}
scope.Complete();
}
return(json);
}
public async Task <IActionResult> AddMenu(AddMenuModel model)
{
if (ModelState.IsValid)
{
var result = await _DbContext.NavigationMenu.Where(e => e.Name == model.Name& e.ActionName == model.ActionName && e.ControllerName == e.ControllerName).ToListAsync();
if (result.Count() != 0)
{
return(RedirectToAction("ViewMenu", new { status = "Menu Already exists" }));
}
else
{
NavigationMenu menu = new NavigationMenu
{
Id = new Guid(),
Name = model.Name,
ActionName = model.ActionName,
Area = model.Area,
ControllerName = model.ControllerName,
DisplayOrder = model.DisplayOrder,
ExternalUrl = model.ExternalUrl,
IsExternal = model.IsExternal,
ParentMenuId = model.ParentMenuId,
Permitted = model.Permitted,
Visible = model.Visible
};
await _DbContext.NavigationMenu.AddAsync(menu);
_DbContext.SaveChangesAsync().Wait();
}
}
return(RedirectToAction("ViewMenu", new { status = "Added Succesfully" }));
}
public JsonResult Save(AddMenuModel aModel)
{
string msg = _gateway.Save(aModel);
return(Json(msg, JsonRequestBehavior.AllowGet));
}
