public ActionResult Edit(int id)
{
ComboTransactionModel ctranVM = new ComboTransactionModel();
ComboTransaction ctran = db.ComboTransactions.Find(id);
ctranVM.ComboTransactionID = ctran.ComboTransactionID;
ctranVM.CustomerID = ctran.CustomerID;
ctranVM.Expense = ctran.Expense;
ctranVM.Income = ctran.Income;
ctranVM.IndividualTransactions = db.IndividualProductTransactions.Where(x => x.ComboTransactionID == ctran.ComboTransactionID).OrderByDescending(x => x.IndividualProductTransactionID).ToList();
ctranVM.IsPaid = ctran.IsPaid;
ctranVM.PaidDateTime = ctran.PaidDateTime;
ctranVM.TimeStamp = ctran.TimeStamp;
ctranVM.TransPortPrice = ctran.TransPortPrice;
ctranVM.UserID = ctran.UserID;
ctranVM.Weight = ctran.Weight;
ViewBag.Customers = new SelectList(db.Customers.OrderByDescending(x => x.Name), "CustomerID", "Name", ctran.CustomerID);
return View(ctranVM);
}
public ActionResult Create()
{
ComboTransactionModel ctModel = new ComboTransactionModel();
if (Session["LoginUser"] != null)
{
int userid = ((User)Session["LoginUser"]).UserID;
ctModel.TimeStamp = DateTime.Now;
ctModel.Benefit = 0;
ctModel.Expense = 0;
ctModel.Income = 0;
ctModel.IndividualTransactions = new List<IndividualProductTransaction>();
ctModel.IsPaid = false;
ctModel.PaidDateTime = null;
ctModel.TransPortPrice = 0;
ctModel.UserID = userid;
ViewBag.Customers = new SelectList(db.Customers.OrderByDescending(x => x.Name), "CustomerID", "Name", ctModel.CustomerID);
}
return View(ctModel);
}
public ActionResult Edit(ComboTransactionModel ctranVM)
{
if (ModelState.IsValid)
{
ComboTransaction ctran = db.ComboTransactions.Find(ctranVM.ComboTransactionID);
if (ctran != null)
{
ctran.Weight = ctranVM.Weight;
ctran.TransPortPrice = ctranVM.TransPortPrice;
ctran.IsPaid = ctranVM.IsPaid;
ctran.PaidDateTime = ctranVM.PaidDateTime;
ctran.Expense = 0;
ctran.Income = 0;
//update combo transaction income and expense
List<IndividualProductTransaction> individualProdTrans = db.IndividualProductTransactions.Where(x => x.ComboTransactionID == ctranVM.ComboTransactionID).ToList();
foreach (IndividualProductTransaction data in individualProdTrans)
{
ctran.Expense += data.CNYPrice.Value * data.Number;
ctran.Income += data.CNYSellPrice.Value * data.Number;
}
ctran.Benefit = ctran.Income - ctran.Expense - ctran.TransPortPrice;
db.Entry(ctran).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
ViewBag.Customers = new SelectList(db.Customers.OrderByDescending(x => x.Name), "CustomerID", "Name", ctranVM.CustomerID);
ctranVM.IndividualTransactions = db.IndividualProductTransactions.Where(x => x.ComboTransactionID == ctranVM.ComboTransactionID).OrderByDescending(x => x.IndividualProductTransactionID).ToList();
return RedirectToAction("Index");
}
