public ActionResult ThemGioHang(long idSach) { var db = new HoaDonDAO(); if (Session["TaiKhoan"] == null) { return(RedirectToAction("Index", "Login")); } else { KhachHang kh = Session["TaiKhoan"] as KhachHang; HoaDon hd = db.FindHD(kh.IdKhachHang); var CTHDDAO = new CTHDDAO(); if (hd == null) { HoaDon newHD = db.InsertHD(kh.IdKhachHang, DateTime.Today, "Chưa Thanh Toán", "Chưa Giao Hàng"); CTHDDAO.InsertCTHD(newHD.IdHoaDon, idSach); Session["ListCTHD"] = CTHDDAO.GetList(newHD.IdHoaDon); ViewBag.Them = "Thêm vào giỏ hàng thành công"; return(View("Index")); } else { int pb = 0; int rs; foreach (var item in CTHDDAO.GetList(hd.IdHoaDon)) { if (item.IdSach == idSach) { rs = CTHDDAO.UpdateCTHD(hd.IdHoaDon, idSach); if (rs == 1) { ViewBag.SL = "Sách bạn muốn thêm giỏ hàng đã đạt giới hạn"; Session["ListCTHD"] = CTHDDAO.GetList(hd.IdHoaDon); return(View("Index")); } else if (rs == 2) { ViewBag.SL = "Sách tồn kho không đáp ứng được nhu cầu của bạn"; Session["ListCTHD"] = CTHDDAO.GetList(hd.IdHoaDon); return(View("Index")); } else { pb = 1; break; } } } if (pb == 0) { CTHDDAO.InsertCTHD(hd.IdHoaDon, idSach); } Session["ListCTHD"] = CTHDDAO.GetList(hd.IdHoaDon); ViewBag.Them = "Thêm vào giỏ hàng thành công"; return(View("Index")); } } }
public ActionResult DeleteCTHD(long idCTHD) { CTHDDAO db = new CTHDDAO(); db.DeleteCTHD(idCTHD); ViewBag.GioHang = "Xóa thành công"; Session["ListCTHD"] = db.GetList(idHD); return(View("Index")); }
public ActionResult UpdateSL(long idCTHD, int sl) { CTHDDAO db = new CTHDDAO(); int rs = db.UpdateCTHD_GioHang(idCTHD, sl); if (rs == 1) { ViewBag.GioHang = "Số lượng chỉ <= 3"; } else if (rs == 2) { ViewBag.GioHang = "Số lượng tồn kho không đủ cho nhu cầu của bạn"; } else { ViewBag.GioHang = "Cập nhật thành công"; } Session["ListCTHD"] = db.GetList(idHD); return(View("Index")); }
// GET: GioHang public ActionResult Index() { if (Session["TaiKhoan"] == null) { return(RedirectToAction("Index", "Login")); } else { var db = new HoaDonDAO(); KhachHang kh = Session["TaiKhoan"] as KhachHang; HoaDon hd = db.FindHD(kh.IdKhachHang); var CTHDDAO = new CTHDDAO(); if (hd != null) { idHD = hd.IdHoaDon; Session["ListCTHD"] = CTHDDAO.GetList(hd.IdHoaDon); } return(View("Index")); } }
// GET: CTHDHome public ActionResult Index(long?idHD) { if (Session["TaiKhoan"] == null) { return(View("../Login/Index")); } else { if (idHD == null) { return(View("../Home/Index")); } var cthd = new CTHDDAO(); var db = new ToyContext(); Session["HDHome"] = db.HoaDon.Find(idHD); long id = Convert.ToInt64(idHD); Session["ListCTHDHome"] = cthd.GetList(id); return(View("Index")); } }
public ActionResult ChiTietHoaDon(long idHD) { var tk = Session["TaiKhoan"] as KhachHang; if (tk == null) { return(View("../Login/Index")); } else { if (tk.LoaiTK != "Admin") { return(View("../Home/Index")); } else { var cthd = new CTHDDAO(); Session["IdHD"] = idHD.ToString(); Session["ListCTHoaDon"] = cthd.GetList(idHD); return(RedirectToAction("Index", "CTHD", new { area = "Admin" })); } } }
public ActionResult XuatExcel(long idHD) { var tk = Session["TaiKhoan"] as KhachHang; if (tk == null) { return(View("../Login/Index")); } else { if (tk.LoaiTK != "Admin") { return(View("../Home/Index")); } else { var db = new ToyContext(); var cthd = new CTHDDAO(); var list = cthd.GetList(idHD); try { string path = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook wb = excel.Workbooks.Add(XlSheetType.xlWorksheet); Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)excel.ActiveSheet; excel.Visible = false; int index = 2; int process = list.Count; ws.Cells[1, 1] = "Mã Sách"; ws.Cells[1, 2] = "Tên Sách"; ws.Cells[1, 3] = "Đơn Giá"; ws.Cells[1, 4] = "Số Lượng"; ws.Cells[1, 5] = "Thành Tiền"; double TongTien = 0; foreach (var sinhVien in list) { idHD = sinhVien.IdHoaDon; ws.Cells[index, 1] = sinhVien.IdSach; ws.Cells[index, 2] = sinhVien.Sach.Ten; ws.Cells[index, 3] = sinhVien.Sach.Gia; ws.Cells[index, 4] = sinhVien.SoLuong; ws.Cells[index, 5] = sinhVien.ThanhTien; TongTien = TongTien + sinhVien.ThanhTien; index += 1; } ws.Cells[index, 4] = "Tổng Tiền"; ws.Cells[index, 5] = TongTien; ws.SaveAs(@path + "/HoaDonAdmin" + idHD + ".xlsx", XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing, true, false, XlSaveAsAccessMode.xlNoChange, XlSaveConflictResolution.xlLocalSessionChanges, Type.Missing, Type.Missing); excel.Quit(); } catch (Exception ex) { } return(RedirectToAction("Reset", "HoaDon", new { area = "Admin" })); } } }