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