public ActionResult DeleteConfirmed(int id) { tbl_Imports tbl_imports = db.tbl_Imports.Find(id); List <tbl_ImportDetail> arr = tbl_imports.tbl_ImportDetail.ToList(); foreach (var item in arr) { tbl_Items sp = db.tbl_Items.Find(item.ItemID); if (sp != null) { sp.ItemCount -= item.Qty.Value; db.Entry(sp).State = EntityState.Modified; } } foreach (var item in arr) { db.tbl_ImportDetail.Remove(item); } db.tbl_Imports.Remove(tbl_imports); db.SaveChanges(); return(RedirectToAction("Index")); }
// // GET: /Import/Details/5 public ActionResult Details(int id = 0) { tbl_Imports tbl_imports = db.tbl_Imports.Find(id); if (tbl_imports == null) { return(HttpNotFound()); } return(View(tbl_imports)); }
public ActionResult Edit(int id = 0) { tbl_Imports tbl_imports = db.tbl_Imports.Find(id); if (tbl_imports == null) { return(HttpNotFound()); } if (tbl_imports.ImportDate != null) { ViewBag.ImportDate = tbl_imports.ImportDate.Value.ToString("dd/MM/yyyy"); } ViewBag.ItemID = new SelectList(db.tbl_Items, "ItemID", "ItemName"); return(View(tbl_imports)); }
public ActionResult Edit(tbl_Imports tbl_imports) { var date = DateTime.Now; tbl_imports.ImportDate = null; string[] s = (Request.Form["datepicker"] + "").Split('/'); try { date = new DateTime(Convert.ToInt16(s[2]), Convert.ToInt16(s[1]), Convert.ToInt16(s[0])); tbl_imports.ImportDate = date; } catch (Exception e) { ModelState.AddModelError("DeliveryDate", "Ngày nhập hàng chưa đúng"); } if (ModelState.IsValid) { db.Entry(tbl_imports).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ItemID = new SelectList(db.tbl_Items, "ItemID", "ItemName"); return(View(tbl_imports)); }
public ActionResult Create(tbl_Imports tbl_imports) { var date = DateTime.Now; tbl_imports.ImportDate = null; string[] s = (Request.Form["datepicker"] + "").Split('/'); try { date = new DateTime(Convert.ToInt16(s[2]), Convert.ToInt16(s[1]), Convert.ToInt16(s[0])); tbl_imports.ImportDate = date; } catch (Exception e) { ModelState.AddModelError("DeliveryDate", "Ngày nhập hàng chưa đúng"); } if (ModelState.IsValid) { tbl_imports.ImportUser = User.Identity.Name; db.tbl_Imports.Add(tbl_imports); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbl_imports)); }