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);
}
}
