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