public ActionResult Create([Bind(Include = "MaDHX,MaSP,SoLuong,isXoa")] CHITIETDONHANGXUAT cHITIETDONHANGXUAT) { if (ModelState.IsValid) { db.CHITIETDONHANGXUATs.Add(cHITIETDONHANGXUAT); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cHITIETDONHANGXUAT)); }
// GET: CHITIETDONHANGXUATs/Edit/5 public ActionResult Delete(int?id, int?MaSP) { CHITIETDONHANGXUAT cHITIETDONHANGXUAT = db.CHITIETDONHANGXUATs.Where(x => x.MaDHX == id && x.MaSP == MaSP).First(); if (cHITIETDONHANGXUAT == null) { return(HttpNotFound()); } cHITIETDONHANGXUAT.isXoa = true; db.Entry(cHITIETDONHANGXUAT).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Details", "DonHangXuats", new { id = cHITIETDONHANGXUAT.MaDHX })); }
// GET: CHITIETDONHANGXUATs/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CHITIETDONHANGXUAT cHITIETDONHANGXUAT = db.CHITIETDONHANGXUATs.Find(id); if (cHITIETDONHANGXUAT == null) { return(HttpNotFound()); } return(View(cHITIETDONHANGXUAT)); }
// GET: CHITIETDONHANGXUATs/Edit/5 public ActionResult Edit(int?id, int?MaSP) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CHITIETDONHANGXUAT cHITIETDONHANGXUAT = db.CHITIETDONHANGXUATs.Where(x => x.MaDHX == id && x.MaSP == MaSP).First(); if (cHITIETDONHANGXUAT == null) { return(HttpNotFound()); } ViewBag.TenSanPham = db.SANPHAMs.Where(x => x.isXoa == false && cHITIETDONHANGXUAT.MaSP == x.MaSP).First().TenSP; return(View(cHITIETDONHANGXUAT)); }
public ActionResult Edit([Bind(Include = "MaDHX,MaSP,SoLuong,isXoa")] CHITIETDONHANGXUAT cHITIETDONHANGXUAT) { string str = ""; if (ModelState.IsValid) { CHITIETDONHANGXUAT ct = db.CHITIETDONHANGXUATs.AsNoTracking().First(x => x.MaSP == cHITIETDONHANGXUAT.MaSP && x.MaDHX == cHITIETDONHANGXUAT.MaDHX); string sp = db.SANPHAMs.AsNoTracking().FirstOrDefault(x => x.MaSP == cHITIETDONHANGXUAT.MaSP).TenSP; str += "<b>Sản Phẩm: </b>" + sp + "</br>"; str += "<b>Số Lượng: </b>" + ct.SoLuong + " => " + cHITIETDONHANGXUAT.SoLuong + "</br>"; cHITIETDONHANGXUAT.isXoa = false; db.Entry(cHITIETDONHANGXUAT).State = EntityState.Modified; db.SaveChanges(); ghiLog.AddNewGhiLog("Sửa", Session["username"] + "", str, "Chi Tiết Đơn Hàng Xuất"); return(RedirectToAction("Details", "DonHangXuats", new { id = cHITIETDONHANGXUAT.MaDHX })); } return(View(cHITIETDONHANGXUAT)); }
public ActionResult Edit([Bind(Include = "MaDHX,MaDaiLy,MaNV,SoLuong,MaSP,TrangThai,isXoa,Tram,ThoiGian,PhuongTien")] DONHANGXUAT dONHANGXUAT) { if (ModelState.IsValid) { string str = "<b>Mã DHX: </b>" + dONHANGXUAT.MaDHX + "</br>"; DONHANGXUAT dhxCu = db.DONHANGXUATs.AsNoTracking().FirstOrDefault(x => x.MaDHX == dONHANGXUAT.MaDHX); LUUVET lv = db.LUUVETs.FirstOrDefault(x => x.MaDHX + "" == dONHANGXUAT.MaDHX + ""); bool isUpdate = false; if (dhxCu.MaNV != dONHANGXUAT.MaNV) { string nvCu = db.NHANVIENs.AsNoTracking().FirstOrDefault(x => x.MaNV == dhxCu.MaNV).Hoten; string nvMoi = db.NHANVIENs.AsNoTracking().FirstOrDefault(x => x.MaNV == dONHANGXUAT.MaNV).Hoten; str += "<b>Nhân Viên: </b>" + nvCu + " => " + nvMoi + "</br>"; isUpdate = true; lv.MaNV = int.Parse(dONHANGXUAT.MaNV + ""); } if (dhxCu.MaDaiLy != dONHANGXUAT.MaDaiLy) { string dlCu = db.DAILies.AsNoTracking().FirstOrDefault(x => x.MaDL == dhxCu.MaDaiLy).Ten; string dlMoi = db.DAILies.AsNoTracking().FirstOrDefault(x => x.MaDL == dONHANGXUAT.MaDaiLy).Ten; str += "<b>Đại Lý: </b>" + dlCu + " => " + dlMoi + "</br>"; } if (dhxCu.ThoiGian != dONHANGXUAT.ThoiGian) { str += "<b>Thời Gian: </b>" + dhxCu.ThoiGian + " => " + dONHANGXUAT.ThoiGian + "</br>"; } if (dhxCu.PhuongTien != dONHANGXUAT.PhuongTien) { str += "<b>Phương Tiện: </b>" + dhxCu.PhuongTien + " => " + dONHANGXUAT.PhuongTien + "</br>"; } if (dONHANGXUAT.Tram != lv.MaTram) { string tramCu = db.TRAMs.AsNoTracking().FirstOrDefault(x => x.MaTram == lv.MaTram).TenTram; string tramMoi = db.TRAMs.AsNoTracking().FirstOrDefault(x => x.MaTram == dONHANGXUAT.Tram).TenTram; str += "<b>Trạm: </b>" + tramCu + " => " + tramMoi + "</br>"; isUpdate = true; lv.MaTram = dONHANGXUAT.Tram; } if (isUpdate) { db.Entry(lv).State = EntityState.Modified; } dONHANGXUAT.isXoa = false; if (dONHANGXUAT.TrangThai == null) { dONHANGXUAT.TrangThai = false; } db.Entry(dONHANGXUAT).State = EntityState.Modified; db.SaveChanges(); str += "------------------</br>"; List <CHITIETDONHANGXUAT> ct = db.CHITIETDONHANGXUATs.Where(x => x.MaDHX == dONHANGXUAT.MaDHX).ToList(); List <string> maSpDelete = ct.Select(x => x.MaSP + "").ToArray().Except(dONHANGXUAT.MaSP).ToList(); foreach (string item in maSpDelete) { CHITIETDONHANGXUAT itemDelete = db.CHITIETDONHANGXUATs.Where(x => x.MaDHX == dONHANGXUAT.MaDHX && x.MaSP + "" == item).First(); if (itemDelete != null && !(bool)itemDelete.isXoa) { itemDelete.isXoa = true; db.Entry(itemDelete).State = EntityState.Modified; db.SaveChanges(); string tensp = db.SANPHAMs.AsNoTracking().FirstOrDefault(x => x.MaSP + "" == item).TenSP; str += "Sản Phẩm <b>" + tensp + "</b> Đã bị xóa.</br>"; } } string addNewstr = "--------Thêm Mới---------</br>"; string restoreSP = "--------Sửa----------</br>"; foreach (string msp in dONHANGXUAT.MaSP) { int id = int.Parse(msp); CHITIETDONHANGXUAT addNew = db.CHITIETDONHANGXUATs.FirstOrDefault(x => x.MaDHX == dONHANGXUAT.MaDHX && x.MaSP == id); string sp = db.SANPHAMs.AsNoTracking().FirstOrDefault(x => x.MaSP == id).TenSP; if (addNew == null) { addNew = new CHITIETDONHANGXUAT(); addNew.isXoa = false; addNew.MaDHX = dONHANGXUAT.MaDHX; addNew.MaSP = id; addNew.SoLuong = dONHANGXUAT.SoLuong; db.CHITIETDONHANGXUATs.Add(addNew); db.SaveChanges(); addNewstr += "<b>Sản Phẩm:</b> " + sp + "</br>"; addNewstr += "<b>Số Lượng:</b> " + dONHANGXUAT.SoLuong + "</br>"; addNewstr += "------------------</br>"; } else { if ((bool)addNew.isXoa) { addNew.isXoa = false; } addNew.SoLuong = dONHANGXUAT.SoLuong; db.Entry(addNew).State = EntityState.Modified; db.SaveChanges(); restoreSP += "<b>Sản Phẩm:</b> " + sp + "</br>"; restoreSP += "<b>Số Lượng:</b> " + addNew.SoLuong + " => " + dONHANGXUAT.SoLuong + "</br>"; } } ghiLog.AddNewGhiLog("Sửa", Session["username"] + "", str + addNewstr + restoreSP, "Đơn Hàng Xuất"); return(RedirectToAction("Index")); } ViewBag.NhanVien = db.NHANVIENs.Where(x => x.isXoa == false).ToList(); ViewBag.ListDaiLy = db.DAILies.Where(x => x.isXoa == false).ToList(); ViewBag.ListSP = db.SANPHAMs.Where(x => x.isXoa == false).ToList(); return(View(dONHANGXUAT)); }
public ActionResult Create([Bind(Include = "MaDHX,MaDaiLy,MaNV,SoLuong,MaSP,TrangThai,isXoa,Tram,ThoiGian,PhuongTien")] DONHANGXUAT dONHANGXUAT) { if (dONHANGXUAT.SoLuong == 0) { dONHANGXUAT.SoLuong = 5; } if (ModelState.IsValid) { string str = ""; string nv = db.NHANVIENs.AsNoTracking().FirstOrDefault(x => x.MaNV == dONHANGXUAT.MaNV).Hoten; string dl = db.DAILies.AsNoTracking().FirstOrDefault(x => x.MaDL == dONHANGXUAT.MaDaiLy).Ten; // Insert DONHANGXUAT dONHANGXUAT.isXoa = false; dONHANGXUAT.TrangThai = false; db.DONHANGXUATs.Add(dONHANGXUAT); db.SaveChanges(); int id = dONHANGXUAT.MaDHX; str += "<b>Mã DHX: </b> " + id + "</br>"; str += "<b>Nhân Viên: </b> " + nv + "</br>"; str += "<b>Đại Lý: </b> " + dl + "</br>"; str += "<b>Thời Gian: </b> " + dONHANGXUAT.ThoiGian + "</br>"; str += "<b>Phương Tiện: </b> " + dONHANGXUAT.PhuongTien + "</br>"; str += "------------------</br>"; // Insert CHITIETDONHANGXUAT foreach (string maSP in dONHANGXUAT.MaSP) { CHITIETDONHANGXUAT ct = new CHITIETDONHANGXUAT(); int masp = int.Parse(maSP); string sp = db.SANPHAMs.AsNoTracking().FirstOrDefault(x => x.MaSP == masp).TenSP; ct.MaDHX = id; ct.MaSP = masp; ct.SoLuong = dONHANGXUAT.SoLuong; ct.isXoa = false; db.CHITIETDONHANGXUATs.Add(ct); db.SaveChanges(); str += "<b>Sản Phẩm:</b> " + sp + "</br>"; str += "<b>Số Lượng:</b> " + dONHANGXUAT.SoLuong + "</br>"; str += "------------------</br>"; } str += "--------- Lưu Vết ---------</br>"; // Insert LuuViet LUUVET luuVet = new LUUVET(); luuVet.isXoa = false; luuVet.MaDHX = id; luuVet.MaNV = int.Parse(dONHANGXUAT.MaNV + ""); luuVet.MaTram = dONHANGXUAT.Tram; luuVet.TrangThai = false; db.LUUVETs.Add(luuVet); db.SaveChanges(); string tram = db.TRAMs.AsNoTracking().FirstOrDefault(x => x.MaTram == dONHANGXUAT.Tram).TenTram; str += "<b>Mã DHX :</b>" + id + "</br>"; str += "<b>Nhân Viên :</b>" + nv + "</br>"; str += "<b>Trạm :</b>" + tram + "</br>"; ghiLog.AddNewGhiLog("Thêm mới", Session["username"] + "", str, "Đơn Hàng Xuất"); ViewBag.NhanVien = db.NHANVIENs.Where(x => x.isXoa == false).ToList(); ViewBag.ListDaiLy = db.DAILies.Where(x => x.isXoa == false).ToList(); ViewBag.ListSP = db.SANPHAMs.Where(x => x.isXoa == false).ToList(); return(RedirectToAction("Index")); } return(View(dONHANGXUAT)); }