public ActionResult DanhSachNhapHang() { //khai Bao var sessionCart = (List <CartItem>)Session[NhapHangSesstion];// danh sach cart var lathongtin = Session[CommonConstants.NhaCCSesstion]; var mand = Convert.ToInt32(lathongtin); var Ncc = new NhaCungCapDao().ViewDentail(mand); var donhang = new DonHangDao().DonHangMoiTao(); var dao = new ChiTiet_DonHangDao(); ChiTietDonHang BienTam = new ChiTietDonHang(); BienTam.MaNhaCungCap = Ncc.MaNhaCungCap; BienTam.MaDonHang = donhang[0].MaDonHang; foreach (var item in sessionCart) { if (item.SoLuong > 0) { BienTam.LoaiHangHoa = item.Hang_Hoa.LoaiHang.TenLoaiHang; BienTam.TenHang = item.Hang_Hoa.TenHang; BienTam.SoLuong = item.SoLuong; BienTam.Gia = item.Hang_Hoa.DonGia; var id = dao.Add(BienTam); } } var result = ExportData(Ncc, donhang); Session[NhapHangSesstion] = null; return(RedirectToAction("Index", "Cart1")); }
public ActionResult GetInforDetailOrder(string idDH) { var order = new DonHangDao().GetDonHang(idDH); var listCT_DonHang = new DonHangDao().getListCTDH(idDH); var customer = new CustomerModel(); decimal phiShip = 0; decimal tong = 0; foreach (var item in listCT_DonHang) { tong += item.SOLUONG * item.THANHTIEN; } if (tong < 300000) { phiShip = 30000; } if (order != null) { var cusdetail = new CustomerDao().ViewDetail(order.MAKHACHHANG); var pttt = new OrdersDao().GetPhuongThucThanhToan(order.MAPHUONGTHUCTHANHTOAN); customer.MAKH = cusdetail.MAKHACHHANG; customer.TENKH = cusdetail.TENKHACHHANG; customer.DIACHI = cusdetail.DIACHI; customer.DIENTHOAI = cusdetail.DIENTHOAI; customer.EMAIL = cusdetail.EMAIL; customer.NgayTaoDon = order.NGAYLAP; customer.PhuongThucThanhToan = pttt.TENPHUONGTHUCTHANHTOAN; customer.Ship = phiShip; } return(Json(customer, JsonRequestBehavior.AllowGet)); }
public ActionResult ThemMoi(DonHang quyenhan) { if (quyenhan.TenDonHang != null) { if (quyenhan.NgayGiao > DateTime.Now) { var dao = new DonHangDao(); quyenhan.NgayTao = DateTime.Now; var id = dao.ThemMoi(quyenhan); if (id) { // SetAlert("Thêm quyền thành công", "success"); return(RedirectToAction("NhaCungcap", "Cart1")); } else { return(RedirectToAction("ThemMoi", "DonHang")); } } else { //SetAlert("Thêm quyền thành công", "success"); return(RedirectToAction("ThemMoi", "DonHang")); } } return(RedirectToAction("ThemMoi", "DonHang")); }
public List <DonHang> Result() { var dao = new DonHangDao(); var list = dao.LayDS(); return(list); }
// GET: DonHangs public ActionResult Index(int page = 1, int pageSize = 11) { var dao = new DonHangDao(); var model = dao.ListAllPaging(page, pageSize); return(View(model)); }
public ActionResult DonHang(long id) { var dao = new DonHangDao(); var list = dao.DonHangOfUser(id); // Hiển thị list đơn hàng return(View(list)); }
// GET: Admin/CTDH public ActionResult Index(int page = 1, int pageSize = 11) { var dao = new DonHangDao(); var model = dao.ListAllPaging2(page, pageSize); //var chiTietDonHang = db.ChiTietDonHang.Include(c => c.DonHang).Include(c => c.SanPham); return(View(model)); }
public ActionResult Edit(int id) { var dao = new DonHangDao(); var quyenhan = dao.ViewDentail(id); SetViewBag(quyenhan.MaKhachSan); return(View(quyenhan)); }
// GET: Admin/DonHang public ActionResult DanhSachDonHang(string searchString, int page = 1, int pageSize = 10) { var dao = new DonHangDao(); var model = dao.LayTatCaDS(searchString, page, pageSize); ViewBag.SearchString = searchString; return(View(model)); }
public JsonResult JsonListDHTheoTrangThai(string tt, int page = 1, int pageSize = 10) { var dh = new DonHangDao().ListDHTheoTrangThai(tt, page, pageSize); return(Json(new { status = true })); }
public JsonResult CapNhat(int madh, string tt) { var dh = new DonHangDao().CapNhat(madh, tt); return(Json(new { status = true })); }
public ActionResult ListDonHang(string tt, int page = 1, int pageSize = 10) { if (tt == null) { var listdh = new DonHangDao().ListDonHang(page, pageSize); return(View(listdh)); } else { var dh = new DonHangDao().ListDHTheoTrangThai(tt, page, pageSize); return(View(dh)); } }
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 GetListDH(string id) { var donhang = new DonHangDao().GetDonHang(id); var listCT_DonHang = new DonHangDao().getListCTDH(id); var model = new List <DonHangModel>(); decimal total = 0; foreach (var item in listCT_DonHang) { var product = new SanPhamDao().getProduct(item.MASANPHAM); var img = new SanPhamDao().getListImages(item.MASANPHAM); model.Add(new DonHangModel() { idDonHang = id, idProduct = item.MASANPHAM, idCustomer = donhang.MAKHACHHANG, soluong = item.SOLUONG, thanhtien = item.THANHTIEN, nameProduct = product.TENSANPHAM, linkImage = img[0].LINKHINHANH, }); total += (item.THANHTIEN * item.SOLUONG); } int status = 4; var ship = 0; if (donhang != null) { status = (int)donhang.TRANGTHAI; if (total < 300000) { total += 30000; ship = 30000; } } var oModel = new { model = model, total = total, status = status, ship = ship }; return(Json(oModel, JsonRequestBehavior.AllowGet)); }
// GET: User public ActionResult Index() { var user = Session[OnlineShop.Common.CommonConstants.USER_SESSION]; if (user != null) { var dao = new DonHangDao(); var list = dao.DonHangOfUser(((UserLogin)user).UserID); // Hiển thị list đơn hàng ViewBag.UserId = ((UserLogin)user).UserID; return(View(list)); } else { return(RedirectToAction("Login", "Login")); } }
public ActionResult Edit(DonHang qh) { if (ModelState.IsValid) { var dao = new DonHangDao(); var result = dao.Edit(qh); if (result) { // SetAlert("Cập nhật thành công", "success"); return(RedirectToAction("DanhSachDonHang", "DonHang")); } else { ModelState.AddModelError("", "Cập nhật thất bại"); } } return(View("DanhSachDonHang")); }
public void displayChart() { var cnv = new Bunifu.DataViz.Canvas(); var dataPoint = new Bunifu.DataViz.DataPoint(Bunifu.DataViz.BunifuDataViz._type.Bunifu_splineArea); DonHangDao dao = new DonHangDao(); int jan = dao.month_amount(1); int feb = dao.month_amount(2); int mar = dao.month_amount(3); int apr = dao.month_amount(4); int may = dao.month_amount(5); int jun = dao.month_amount(6); int jul = dao.month_amount(7); int aug = dao.month_amount(8); int sep = dao.month_amount(9); int oct = dao.month_amount(10); int nov = dao.month_amount(11); int dec = dao.month_amount(12); dataPoint.addLabely("Jan", jan.ToString()); dataPoint.addLabely("Feb", feb.ToString()); dataPoint.addLabely("Mar", mar.ToString()); dataPoint.addLabely("Apr", apr.ToString()); dataPoint.addLabely("May", may.ToString()); dataPoint.addLabely("Jun", jun.ToString()); dataPoint.addLabely("Jul", jul.ToString()); dataPoint.addLabely("Aug", aug.ToString()); dataPoint.addLabely("Sep", sep.ToString()); dataPoint.addLabely("Oct", oct.ToString()); dataPoint.addLabely("Nov", nov.ToString()); dataPoint.addLabely("Dec", dec.ToString()); cnv.addData(dataPoint); bunifuDataViz1.colorSet.Add(Color.Red); bunifuDataViz1.Render(cnv); }
public ActionResult GetDoanhThuTheoThang() { var list = new List <DoanhThuViewModel>(); decimal doanhthu, tongnhap, loinhuan; var nam = DateTime.Now.Year; for (int j = 2019; j <= nam; j++) { for (int i = 1; i <= 12; i++) { tongnhap = new NhapHangDao().TongNhap(i, j); doanhthu = new DonHangDao().DoanhThuTheoThang(i, j); loinhuan = doanhthu - tongnhap; if (doanhthu != 0) { list.Add(new DoanhThuViewModel { Thang = i, Nam = j, TongNhap = tongnhap, DoanhThu = doanhthu, LoiNhuan = loinhuan }); } } } return(Json(list, JsonRequestBehavior.AllowGet)); }
// GET: Admin/DonH public ActionResult Index() { var data = new DonHangDao().donHang_TH(); return(View(data)); }
public void populateGridInfo() { DonHangDao dao = new DonHangDao(); dataGridViewDonHang.DataSource = dao.getInfo(); }
public ActionResult ChoTH() { var data = new DonHangDao().donHang_CTH(); return(View(data)); }
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")); } }