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