public ValueMealViewModel SearchSingleValueMeal(string SearchItem) { using (CFMMCDEntities db = new CFMMCDEntities()) { CSHVMLP0 VMRow; if (db.CSHVMLP0.Where(o => o.VMLNUM.ToString().Equals(SearchItem)).Any()) { VMRow = db.CSHVMLP0.FirstOrDefault(o => o.VMLNUM.ToString().Equals(SearchItem)); } else if (db.CSHVMLP0.Where(o => o.VMLID.ToString().Equals(SearchItem)).Any()) { VMRow = db.CSHVMLP0.FirstOrDefault(o => o.VMLID.ToString().Equals(SearchItem)); } else { return(null); } ValueMealViewModel vm = new ValueMealViewModel(); vm.VMLNUM = VMRow.VMLNUM.ToString(); vm.VMLNAM = VMRow.VMLNAM.Trim(); vm.VMLPRI = VMRow.VMLPRI.ToString(); vm.VMLPRO = VMRow.VMLPRI.ToString(); vm.MenuItemList = SearchVMMenuItem(vm.VMLNUM); return(vm); } }
public ActionResult UpdateDelete(ValueMealViewModel VMViewModel, string command) { ValueMealManager VMManager = new ValueMealManager(); UserSession user = (UserSession)Session["User"]; string PageAction = ""; bool result = false; if (command == "Save") { result = VMManager.UpdateValueMeal(VMViewModel, user.Username); PageAction = "Update"; } else { result = VMManager.UpdateValueMeal(VMViewModel, user.Username); return(RedirectToAction("Index", new { id = VMViewModel.VMLNUM + VMViewModel.VMLMIC })); } if (result) { TempData["SuccessMessage"] = PageAction + " successful"; new AuditLogManager().Audit(user.Username, DateTime.Now, "Value Meal", PageAction, VMViewModel.VMLNUM, VMViewModel.VMLNAM); } else { TempData["ErrorMessage"] = PageAction + " failed"; } return(RedirectToAction("Index", new { id = VMViewModel.VMLNUM + VMViewModel.VMLMIC })); }
public ActionResult Index(ValueMealViewModel VMViewModel, string value) { ValueMealManager VMManager = new ValueMealManager(); VMViewModel = VMManager.SearchSingleValueMeal(value); VMViewModel.ValueMealList = VMManager.SearchValueMeals("ALL"); return(View(VMViewModel)); }
// GET: ValueMeal public ActionResult Index(string id) { UserAccessSession UASession = (UserAccessSession)Session["UserAccess"]; if (UASession == null || !UASession.VAM) { return(RedirectToAction("Login", "Account")); } // Set NavBar Links accordingly Session["CurrentPage"] = new CurrentPageSession("VAM", "HOME", "LOG"); ValueMealManager VMManager = new ValueMealManager(); ValueMealViewModel VMViewModel = new ValueMealViewModel(); if (id != null) { VMViewModel = VMManager.SearchSingleValueMeal(id); VMViewModel.ValueMealList = new List <ValueMeal>(); } VMViewModel.ValueMealList = VMManager.SearchValueMeals("ALL"); return(View(VMViewModel)); }
public bool UpdateValueMeal(ValueMealViewModel VMViewModel, string user) { using (CFMMCDEntities db = new CFMMCDEntities()) { if (VMViewModel.VMLNUM == null || VMViewModel.VMLNUM.Equals("")) { return(false); } // Existing foreach (var v in VMViewModel.MenuItemList) { // Delete overwritten MIMMIC entry if (!v.PreviousMIMMIC.Equals(v.MIMMIC) && db.CSHVMLP0.Where(o => o.VMLNUM.ToString().Equals(VMViewModel.VMLNUM)).Any()) { CSHVMLP0 VMRowToDelete = db.CSHVMLP0.Single(o => o.VMLID.Equals(VMViewModel.VMLNUM + v.PreviousMIMMIC)); db.CSHVMLP0.Remove(VMRowToDelete); db.SaveChanges(); } // Skip if MIMMIC is null if (v.MIMMIC == null || v.MIMMIC.Equals("")) { continue; } CSHVMLP0 VMRow = new CSHVMLP0(); VMRow.VMLID = VMViewModel.VMLNUM + v.MIMMIC; VMRow.VMLNUM = int.Parse(VMViewModel.VMLNUM); VMRow.VMLNAM = VMViewModel.VMLNAM.ToString(); VMRow.VMLMIC = int.Parse(v.MIMMIC); if (v.VMLQUA != null && !v.VMLQUA.Equals("")) { VMRow.VMLQUA = int.Parse(v.VMLQUA); } VMRow.VMLPRI = double.Parse(VMViewModel.VMLPRI); VMRow.VMLPRO = double.Parse(VMViewModel.VMLPRO); try { if (db.CSHVMLP0.Where(o => o.VMLID.Equals(VMRow.VMLID)).Any()) { CSHVMLP0 rowToDelete = db.CSHVMLP0.Single(o => o.VMLID.Equals(VMRow.VMLID)); db.CSHVMLP0.Remove(rowToDelete); VMRow.STATUS = "E"; db.CSHVMLP0.Add(VMRow); } else { VMRow.STATUS = "A"; db.CSHVMLP0.Add(VMRow); } db.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.Source); System.Diagnostics.Debug.WriteLine(e.Message); System.Diagnostics.Debug.WriteLine(e.StackTrace); System.Diagnostics.Debug.WriteLine(e.InnerException); Exception f = e.InnerException; while (f != null) { System.Diagnostics.Debug.WriteLine("INNER:"); System.Diagnostics.Debug.WriteLine(f.Message); System.Diagnostics.Debug.WriteLine(f.Source); f = f.InnerException; } System.Diagnostics.Debug.WriteLine(e.Data); return(false); } } // New if (!VMViewModel.MIMMIC[0].Equals("")) { for (int i = 0; i < VMViewModel.MIMMIC.Count(); i++) { CSHVMLP0 VMRow = new CSHVMLP0(); VMRow.VMLID = VMViewModel.VMLNUM + VMViewModel.MIMMIC[i]; VMRow.VMLNUM = int.Parse(VMViewModel.VMLNUM); VMRow.VMLNAM = VMViewModel.VMLNAM.ToString(); VMRow.VMLMIC = int.Parse(VMViewModel.MIMMIC[i]); if (VMViewModel.VMLQUA[i] != null && !VMViewModel.VMLQUA[i].Equals("")) { VMRow.VMLQUA = int.Parse(VMViewModel.VMLQUA[i]); } VMRow.VMLPRI = double.Parse(VMViewModel.VMLPRI); VMRow.VMLPRO = double.Parse(VMViewModel.VMLPRO); try { if (db.CSHVMLP0.Where(o => o.VMLID.Equals(VMRow.VMLID)).Any()) { CSHVMLP0 rowToDelete = db.CSHVMLP0.Single(o => o.VMLID.Equals(VMRow.VMLID)); db.CSHVMLP0.Remove(rowToDelete); VMRow.STATUS = "E"; db.CSHVMLP0.Add(VMRow); } else { VMRow.STATUS = "A"; db.CSHVMLP0.Add(VMRow); } db.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.Source); System.Diagnostics.Debug.WriteLine(e.Message); System.Diagnostics.Debug.WriteLine(e.StackTrace); System.Diagnostics.Debug.WriteLine(e.InnerException); Exception f = e.InnerException; while (f != null) { System.Diagnostics.Debug.WriteLine("INNER:"); System.Diagnostics.Debug.WriteLine(f.Message); System.Diagnostics.Debug.WriteLine(f.Source); f = f.InnerException; } System.Diagnostics.Debug.WriteLine(e.Data); return(false); } } } return(true); } }