public ActionResult UpdateDelete(McCafeBistroPriceTierViewModel MBTViewModel, string command)
{
string PageAction = "";
bool result = false;
user = (UserSession)Session["User"];
if (command == "Save")
{
McCafeBistroPriceTierManager MBTManager = new McCafeBistroPriceTierManager();
result = MBTManager.UpdateMcCafeBistroPriceTier(MBTViewModel);
PageAction = "UPDATE";
}
else if (command == "Delete")
{
McCafeBistroPriceTierManager MBTManager = new McCafeBistroPriceTierManager();
result = MBTManager.DeleteMcCafeBistroPriceTier(MBTViewModel);
PageAction = "DELETE";
}
if (result)
{
TempData["SuccessMessage"] = PageAction + " successful";
new AuditLogManager().Audit(user.Username, DateTime.Now, "McCafeBistro Price Tier", PageAction, MBTViewModel.Id, MBTViewModel.Price_Tier);
}
else
{
TempData["ErrorMessage"] = PageAction + " failed";
}
return(RedirectToAction("Index"));
}
// GET: McCafeBistroPriceTier
public ActionResult Index()
{
// Validate log in and user access
UserAccessSession UASession = (UserAccessSession)Session["UserAccess"];
// TIP -> Price Tier
// Refer to UserAccessSession
if (UASession == null || !UASession.TIP)
{
return(RedirectToAction("Login", "Account"));
}
user = (UserSession)Session["User"];
Session["CurrentPage"] = new CurrentPageSession("TIP_BIS", "HOME", "LOG");
// Get all data stored in DB table
McCafeBistroPriceTierManager MBTManager = new McCafeBistroPriceTierManager();
McCafeBistroPriceTierViewModel MBTViewModel = new McCafeBistroPriceTierViewModel();
MBTViewModel.MBPTList = MBTManager.GetMBT();
if (MBTViewModel.MBPTList == null || MBTViewModel.MBPTList.Count() == 0)
{
MBTViewModel.MBPTList = new List <McCafeBistroPriceTierViewModel>();
}
// return View with ViewModel
return(View(MBTViewModel));
}
public List <McCafeBistroPriceTierViewModel> GetMBT()
{
using (CFMMCDEntities db = new CFMMCDEntities())
{
List <McCafeBistroPriceTierViewModel> MBTList = new List <McCafeBistroPriceTierViewModel>();
foreach (McCafe_Bistro_Price_Tier mbt in db.McCafe_Bistro_Price_Tier)
{
McCafeBistroPriceTierViewModel MBTViewModel = new McCafeBistroPriceTierViewModel();
MBTViewModel.Id = (mbt.Id).ToString();
MBTViewModel.Price_Tier = mbt.Price_Tier;
// Add to List
MBTList.Add(MBTViewModel);
}
return(MBTList);
}
}
public bool UpdateMcCafeBistroPriceTier(McCafeBistroPriceTierViewModel MBTViewModel)
{
using (CFMMCDEntities db = new CFMMCDEntities())
{
McCafe_Bistro_Price_Tier mbtRow = new McCafe_Bistro_Price_Tier();
mbtRow.Id = int.Parse(MBTViewModel.Id);
mbtRow.Price_Tier = MBTViewModel.Price_Tier;
try
{
if (db.McCafe_Bistro_Price_Tier.Where(o => o.Id.ToString().Equals(MBTViewModel.Id)).Any())
{
var rowToRemove = db.McCafe_Bistro_Price_Tier.Single(o => o.Id.ToString().Equals(MBTViewModel.Id));
db.McCafe_Bistro_Price_Tier.Remove(rowToRemove);
db.McCafe_Bistro_Price_Tier.Add(mbtRow);
}
else
{
db.McCafe_Bistro_Price_Tier.Add(mbtRow);
}
db.SaveChanges();
return(true);
}
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);
}
}
}
