public ActionResult DeleteConfirmed(string id) { DonHangXuat donHangXuat = db.DonHangXuats.Find(id); db.DonHangXuats.Remove(donHangXuat); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "MaDHX,MaKH,NgayXuat,GiamGia,KieuGiamGia")] DonHangXuat donHangXuat) { if (ModelState.IsValid) { db.Entry(donHangXuat).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "HoTen", donHangXuat.MaKH); return(View(donHangXuat)); }
// GET: DonHangXuats/Details/5 public ActionResult Details(string id) { NguoiDung sNguoiDung = Session["nguoiDung"] as NguoiDung; if (sNguoiDung == null || db.NguoiDungs.Where(d => d.MaND == sNguoiDung.MaND).FirstOrDefault() == null) { return(RedirectToAction("Index", "Login")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var hangDonHangXuats = db.HangDonHangXuats.Where(hangDonHangXuat => hangDonHangXuat.MaDHX == id).Include(hangDonHangNhap => hangDonHangNhap.DonHangXuat); decimal TongDonHang = 0; decimal TongChuaThue = 0; foreach (var hangDonHangXuat in hangDonHangXuats) { var KhachHang = db.KhachHangs.Where(d => d.MaKH == hangDonHangXuat.DonHangXuat.MaKH).FirstOrDefault(); var Hang = db.Hangs.Where(d => d.MaH == hangDonHangXuat.MaH).FirstOrDefault(); var MauHang = db.MauHangs.Where(d => d.MaMH == Hang.MaMH).FirstOrDefault(); hangDonHangXuat.DonHangXuat.KhachHang = KhachHang; hangDonHangXuat.Hang = Hang; hangDonHangXuat.Hang.MauHang = MauHang; TongDonHang += hangDonHangXuat.SoLuong * hangDonHangXuat.Hang.GiaBan; TongChuaThue += hangDonHangXuat.SoLuong * hangDonHangXuat.Hang.GiaBan; } if (hangDonHangXuats == null) { return(HttpNotFound()); } DonHangXuat donHangXuat = db.DonHangXuats.Where(d => d.MaDHX == id).Include(d => d.KhachHang).FirstOrDefault(); if (donHangXuat.KieuGiamGia != "" && donHangXuat.GiamGia != null) { if (donHangXuat.KieuGiamGia == "VNĐ") { TongDonHang -= decimal.Parse(donHangXuat.GiamGia); } else if (donHangXuat.KieuGiamGia == "%") { TongDonHang -= TongDonHang / 100 * decimal.Parse(donHangXuat.GiamGia); } ViewBag.GiamGia = String.Format("{0:n0}", decimal.Parse(donHangXuat.GiamGia)); ViewBag.KieuGiamGia = donHangXuat.KieuGiamGia; } ViewBag.TongDonHang = TongDonHang; ViewBag.TongChuaThue = TongChuaThue; ViewBag.MaDHX = donHangXuat.MaDHX; ViewBag.TenKH = donHangXuat.KhachHang.HoTen; ViewBag.NgayXuat = donHangXuat.NgayXuat; return(View(hangDonHangXuats)); }
// GET: DonHangXuats/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DonHangXuat donHangXuat = db.DonHangXuats.Find(id); if (donHangXuat == null) { return(HttpNotFound()); } return(View(donHangXuat)); }
// GET: DonHangXuats/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DonHangXuat donHangXuat = db.DonHangXuats.Find(id); if (donHangXuat == null) { return(HttpNotFound()); } ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "HoTen", donHangXuat.MaKH); return(View(donHangXuat)); }
public ActionResult DeleteDocument(string MaDHX) { NguoiDung sNguoiDung = Session["nguoiDung"] as NguoiDung; if (sNguoiDung == null || db.NguoiDungs.Where(d => d.MaND == sNguoiDung.MaND).FirstOrDefault() == null) { return(RedirectToAction("Index", "Login")); } DonHangXuat donHangXuat = db.DonHangXuats.Where(d => d.MaDHX == MaDHX && d.DaDuyet == false && d.DaXoa == false).FirstOrDefault(); if (donHangXuat != null) { donHangXuat.DaXoa = true; db.SaveChanges(); } var donHangXuats = db.DonHangXuats.Include(d => d.KhachHang); return(RedirectToAction("Index", new { XoaThanhCong = "Xóa đơn hàng " + MaDHX + " thành công" })); }
public ActionResult VerifyDocument(string MaDHX) { NguoiDung sNguoiDung = Session["nguoiDung"] as NguoiDung; if (sNguoiDung == null || db.NguoiDungs.Where(d => d.MaND == sNguoiDung.MaND).FirstOrDefault() == null) { return(RedirectToAction("Index", "Login")); } DonHangXuat donHangXuat = db.DonHangXuats.Where(d => d.MaDHX == MaDHX && d.DaDuyet == false && d.DaXoa == false).Include(d => d.HangDonHangXuats).FirstOrDefault(); if (donHangXuat == null) { return(RedirectToAction("Index")); } if (donHangXuat.HangDonHangXuats.Count() == 0) { return(RedirectToAction("EditDocument", new { MaDHX = MaDHX, Loi = "Đơn hàng rỗng" })); } bool khongDuHang = false; foreach (HangDonHangXuat hangDonHangXuat in donHangXuat.HangDonHangXuats) { hangDonHangXuat.Hang = db.Hangs.Where(d => d.MaH == hangDonHangXuat.MaH).FirstOrDefault(); if (hangDonHangXuat.SoLuong > hangDonHangXuat.Hang.SoLuong) { khongDuHang = true; break; } } if (khongDuHang) { return(RedirectToAction("EditDocument", new { MaDHX = MaDHX, Loi = "Không đủ số lượng để xuất" })); } foreach (HangDonHangXuat hangDonHangXuat in donHangXuat.HangDonHangXuats) { Hang hang = db.Hangs.Where(d => d.MaH == hangDonHangXuat.MaH).Include(d => d.MauHang).FirstOrDefault(); hang.SoLuong -= hangDonHangXuat.SoLuong; } donHangXuat.DaDuyet = true; db.SaveChanges(); return(RedirectToAction("Index", new { XoaThanhCong = "Duyệt đơn hàng " + MaDHX + " thành công!" })); }
public ActionResult CreateDocument([Bind(Include = "MaKH,NgayXuat,GiamGia,KieuGiamGia")] DonHangXuat donHangXuat) { if (ModelState.IsValid) { int count = db.DonHangXuats.Count() + 1; donHangXuat.MaDHX = "DHX" + count.ToString(); if (donHangXuat.KieuGiamGia == "True") { donHangXuat.KieuGiamGia = "VNĐ"; } else { donHangXuat.KieuGiamGia = "%"; } donHangXuat.DaXoa = false; db.DonHangXuats.Add(donHangXuat); db.SaveChanges(); donHangXuat.KhachHang = db.KhachHangs.Where(d => d.MaKH == donHangXuat.MaKH).FirstOrDefault(); donHangXuat.HangDonHangXuats = db.HangDonHangXuats.Where(d => d.MaDHX == donHangXuat.MaDHX).ToList(); decimal TongDonHang = 0; foreach (var hangDonHangXuat in donHangXuat.HangDonHangXuats) { hangDonHangXuat.Hang = db.Hangs.Where(d => d.MaH == hangDonHangXuat.MaH).FirstOrDefault(); hangDonHangXuat.Hang.MauHang = db.MauHangs.Where(d => d.MaMH == hangDonHangXuat.Hang.MaMH).FirstOrDefault(); TongDonHang += hangDonHangXuat.SoLuong * hangDonHangXuat.Hang.GiaBan; } if (donHangXuat.KieuGiamGia == "%" && donHangXuat.GiamGia != null) { TongDonHang -= TongDonHang / 100 * decimal.Parse(donHangXuat.GiamGia); } else if (donHangXuat.KieuGiamGia == "VNĐ" && donHangXuat.GiamGia != null) { TongDonHang -= decimal.Parse(donHangXuat.GiamGia); } ViewBag.TongDonHang = String.Format("{0:n0}", TongDonHang); ViewBag.MauHangs = db.MauHangs.ToList(); ViewBag.Hangs = db.Hangs.Where(d => d.SoLuong > 0).Include(d => d.MauHang).ToList(); return(View("Create", donHangXuat)); } ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "HoTen"); return(View("Create")); }
// GET: DonHangXuats/Delete/5 public ActionResult Delete(string id) { NguoiDung sNguoiDung = Session["nguoiDung"] as NguoiDung; if (sNguoiDung == null || db.NguoiDungs.Where(d => d.MaND == sNguoiDung.MaND).FirstOrDefault() == null) { return(RedirectToAction("Index", "Login")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DonHangXuat donHangXuat = db.DonHangXuats.Find(id); if (donHangXuat == null) { return(HttpNotFound()); } return(View(donHangXuat)); }
// GET: DonHangXuats/Edit/5 public ActionResult Edit(string id) { NguoiDung sNguoiDung = Session["nguoiDung"] as NguoiDung; if (sNguoiDung == null || db.NguoiDungs.Where(d => d.MaND == sNguoiDung.MaND).FirstOrDefault() == null) { return(RedirectToAction("Index", "Login")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DonHangXuat donHangXuat = db.DonHangXuats.Find(id); if (donHangXuat == null) { return(HttpNotFound()); } ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "HoTen", donHangXuat.MaKH); return(View(donHangXuat)); }
public ActionResult EditDocument(string MaDHX, string Loi = null) { NguoiDung sNguoiDung = Session["nguoiDung"] as NguoiDung; if (sNguoiDung == null || db.NguoiDungs.Where(d => d.MaND == sNguoiDung.MaND).FirstOrDefault() == null) { return(RedirectToAction("Index", "Login")); } DonHangXuat donHangXuat = db.DonHangXuats.Where(d => d.MaDHX == MaDHX && d.DaXoa == false && d.DaDuyet == false).FirstOrDefault(); if (donHangXuat == null) { return(RedirectToAction("Index")); } donHangXuat.KhachHang = db.KhachHangs.Where(d => d.MaKH == donHangXuat.MaKH).FirstOrDefault(); donHangXuat.HangDonHangXuats = db.HangDonHangXuats.Where(d => d.MaDHX == donHangXuat.MaDHX).ToList(); decimal TongDonHang = 0; foreach (var hangDonHangXuat in donHangXuat.HangDonHangXuats) { hangDonHangXuat.Hang = db.Hangs.Where(d => d.MaH == hangDonHangXuat.MaH).FirstOrDefault(); hangDonHangXuat.Hang.MauHang = db.MauHangs.Where(d => d.MaMH == hangDonHangXuat.Hang.MaMH).FirstOrDefault(); TongDonHang += hangDonHangXuat.SoLuong * hangDonHangXuat.Hang.GiaBan; } if (donHangXuat.KieuGiamGia == "%" && donHangXuat.GiamGia != null) { TongDonHang -= TongDonHang / 100 * decimal.Parse(donHangXuat.GiamGia); } else if (donHangXuat.KieuGiamGia == "VNĐ" && donHangXuat.GiamGia != null) { TongDonHang -= decimal.Parse(donHangXuat.GiamGia); } ViewBag.TongDonHang = String.Format("{0:n0}", TongDonHang); ViewBag.MauHangs = db.MauHangs.ToList(); ViewBag.Hangs = db.Hangs.Where(d => d.SoLuong > 0).Include(d => d.MauHang).ToList(); ViewBag.Loi = Loi; return(View("Create", donHangXuat)); }