public ActionResult ChiTietDonHang(int madh) { var ctdh = new ChiTietDonHangDao().ChiTietDonHang(madh); ViewBag.ttDonHang = new DonHangDao().oneDonHang(madh); return(View(ctdh)); }
public ActionResult ChiTiet(long id) { var dao = new ChiTietDonHangDao(); var list = dao.ListChiTiet(id); return(View(list)); }
public ActionResult ChiTietAdmin(long id) { var dao = new ChiTietDonHangDao(); var list = dao.ListChiTiet(id); // Hiển thị list đơn hàng return(View(list)); }
public void populateGridDetails(int idDonHang = 1) { if (idDonHang == 0) { dataGridViewChiTietDH.DataSource = null; } else { ChiTietDonHangDao dao = new ChiTietDonHangDao(); dataGridViewChiTietDH.DataSource = dao.getDetails(idDonHang); } }
private void UC_Home_Admin_Load(object sender, EventArgs e) { ChiTietDonHangDao dao = new ChiTietDonHangDao(); labelSoldBooks.Text = dao.allBookSold().ToString(); ChiTietPhieuNhapDao cDao = new ChiTietPhieuNhapDao(); labelPurchasedBook.Text = cDao.purchasedBook().ToString(); KhachHangDao khDao = new KhachHangDao(); labelCustomer.Text = khDao.countCustomer().ToString(); }
// GET: Admin/ChiTietDonHangAD public ActionResult Index(string searchString, int page = 1, int pageSize = 10) { if (Session["User"] == null) { return(RedirectToAction("Login", "Login")); } else { var dao = new ChiTietDonHangDao(); ViewBag.SearchString = searchString; var model = dao.ListAllPaging(searchString, page, pageSize); return(View(model)); } }
private void button1_Click(object sender, EventArgs e) { if (textBoxCustomerID.Text == "" || textBoxCustomerID.Text == null) { MessageBox.Show("Hãy nhập thông tin khách hàng !"); } else { GioHangDao dao = new GioHangDao(); // thêm id khách hàng vào trong bảng GioHang dao.addIdCustomerToAllRecord(int.Parse(textBoxCustomerID.Text)); // Tạo Record trong bảng DonHang DonHang d = new DonHang(); d.MaKH = int.Parse(dao.getIdCustomer()); d.TongTien = dao.netAmount(); DonHangDao donhangDao = new DonHangDao(); var idDonHang = donhangDao.insertDonHang(d); // Tạo Record trong bảng ChiTietDonHang foreach (var item in dao.listGioHang()) { var tensach = item.BookTitle; var soluong = item.Qty; var dongia = item.Price; SachDao sachDao = new SachDao(); // Tạo 1 ChiTietDonHang và thêm các thuộc tính vào ChiTietDonHang ctdh = new ChiTietDonHang(); ctdh.MaDH = int.Parse(idDonHang); ctdh.MaSach = sachDao.getIdBookByName(tensach); ctdh.SoLuong = soluong; ctdh.DonGia = dongia; // Insert record vào ChiTietDonHang ChiTietDonHangDao ctdhDao = new ChiTietDonHangDao(); ctdhDao.insertChiTietDonHang(ctdh); // Update lại số lượng tồn của Sach sachDao.updateStock(ctdh.MaSach, (int)ctdh.SoLuong); } // Clear all clearAll(); // Xóa hết bảng GioHang dao.deleteAllCartRecord(); MessageBox.Show("Thành công !"); } }
public ActionResult Create(string TenNguoiNhan, string SDTNguoiNhan, string Email, string DiaChiNhan, string GhiChu) { var dao = new DonHangDao(); var productDao = new ProductDao(); var chitietDao = new ChiTietDonHangDao(); DonHang don = new DonHang(); var user = (UserLogin)Session[Common.CommonConstants.USER_SESSION]; don.IdUser = user.UserID; don.NgayDat = DateTime.Now; don.TrangThai = 0; don.TenNguoiNhan = TenNguoiNhan; don.SDTNguoiNhan = SDTNguoiNhan; don.Email = Email; don.DiaChiNhan = DiaChiNhan; don.GhiChu = GhiChu; don.TongTien = 0; var list = (List <CartItem>)Session[Common.CommonConstants.CartSession]; var maDonHang = dao.insert(don); if (maDonHang >= 0) { long tongtien = 0; foreach (var item in list) { ChiTietDonHang entity = new ChiTietDonHang(); entity.MaDonHang = maDonHang; entity.MaSach = item.SanPham.MaSach; entity.SoLuong = item.SoLuong; entity.DonGia = (int)item.SanPham.DonGia; entity.ThanhTien = entity.SoLuong * entity.DonGia; chitietDao.insert(entity); productDao.UpdateSoLuong(item.SoLuong, entity.MaSach); tongtien += (long)entity.ThanhTien; } dao.UpdateTongTien(tongtien, maDonHang); Session[Common.CommonConstants.CartSession] = null; string s = "Bạn đã đặt hàng thành công. Vui lòng xem chi tiết trong tài khoản cá nhân "; List <string> overList = new List <string>(); overList.Add(s); Session[Common.CommonConstants.OverSoLuong] = overList; } return(RedirectToAction("Index", "Cart")); }
public ActionResult XuatHang() { //khai Bao var sessionCart = (List <CartItem>)Session[CartSesstion];// danh sach cart var dao = new ChiTietDonHangDao(); var dao1 = new ChiTiet_HangHoaDao(); DS_XuatKho BienTam = new DS_XuatKho(); //khai bao bien tam //ma nguoi dung var lathongtin = Session[CommonConstants.MaND_SESSTION]; //lay ma quan ly tu session var mand = Convert.ToString(lathongtin); //chuyen ma thanh string var dao2 = new QuanLyKhoHangDao().TimNguoiDungTheoMa(mand); //tim ma nguoi dung trong bang quan ly kho hang int Stt = dao2.STT; //gan gia tri cho stt int maKho = dao2.MaKho; var result = ExportData(dao2); foreach (var item in sessionCart) { if (item.SoLuong > 0) { BienTam.MaHang = item.Hang_Hoa.MaHang; BienTam.NgayXuat = DateTime.Now; BienTam.SoLuong = item.SoLuong; BienTam.DonGia = item.Hang_Hoa.DonGia; BienTam.STT = Stt; var id = dao.ThemMoi(BienTam); if (id > 0) { dao1.ChinhSua(BienTam, maKho); } } } Session[CartSesstion] = null; SetAlert("Đã tạo xong Hàng Xuất Kho", "success"); return(RedirectToAction("Index", "Home")); }
public ActionResult ThanhToan(string HoTen, string SDT, string Email, string DiaChiNhan) { decimal tongtien = 0; decimal thanhtien = 0; ViewBag.userSession = Session[CommonConstant.USER_SESSION]; var listSP = new SanPhamDao().ListSP(); var gioHang = (List <GioHang>)Session[CartSession]; var ctdhDAO = new ChiTietDonHangDao(); var donHang = new DonHang(); int dem = 0; donHang.NgayBan = DateTime.Now; donHang.HoTen = HoTen; donHang.SDT = SDT; donHang.Email = Email; donHang.DiaChiNhan = DiaChiNhan; donHang.TongTien = tongtien; donHang.TrangThai = "Chờ duyệt"; if (ViewBag.userSession != null) { donHang.MaKH = ViewBag.userSession.ID; } else { } var addDH = new DonHangDao().Insert(donHang); foreach (var sp in listSP) { foreach (var item in gioHang) { if (item.SoLuong <= sp.SoLuongCon && item.MauSanPham.MaSP == sp.MaSP && item.MauSanPham.MaMau == sp.MaMau && item.MauSanPham.MaDL == sp.MaDL && item.MauSanPham.MaTT == sp.MaTT) { dem += 1; tongtien = thanhtien + item.MauSanPham.Gia * item.SoLuong; var ctdh = new ChiTietDonHang(); ctdh.MaDH = donHang.MaDH; ctdh.MaSP = item.MauSanPham.MaSP; ctdh.MaMau = item.MauSanPham.MaMau; ctdh.MaTT = item.MauSanPham.MaTT; ctdh.MaDL = item.MauSanPham.MaDL; ctdh.SoLuong = item.SoLuong; ctdhDAO.Insert(ctdh); } else { } } } if (dem > 0) { // Gửi mail string mail = System.IO.File.ReadAllText(Server.MapPath("~/Asset/client/template/DonHangMoi.html")); mail = mail.Replace("{{MaDH}}", donHang.MaDH.ToString()); mail = mail.Replace("{{HoTen}}", HoTen); mail = mail.Replace("{{SDT}}", SDT); mail = mail.Replace("{{Email}}", Email); mail = mail.Replace("{{DiaChiNhan}}", DiaChiNhan); mail = mail.Replace("{{TongTien}}", string.Format("{0:#,##}", tongtien)); var emailAdmin = ConfigurationManager.AppSettings["EmailAdmin"].ToString(); new Mail().GuiMail(Email, "Đơn hàng của bạn", mail); new Mail().GuiMail(emailAdmin, "Khách vừa đặt hàng", mail); gioHang = null; return(Redirect("/hoan-thanh")); } else { Session[CartSession] = null; var del = db.DonHangs.Where(x => x.MaDH == addDH).FirstOrDefault(); db.DonHangs.Remove(del); db.SaveChanges(); return(View("Error")); } }