public void XoaCTDH(string madh, string madv) { CTDONHANG ctdh = new CTDONHANG(); ctdh = qltg.CTDONHANGs.Where(t => t.MaDH == madh && t.MaDV == madv).FirstOrDefault(); qltg.CTDONHANGs.DeleteOnSubmit(ctdh); qltg.SubmitChanges(); }
public void SuaCTDH(int sl, string madh, string madv, float thanhtien) { CTDONHANG ctdh = new CTDONHANG(); ctdh = qltg.CTDONHANGs.Where(t => t.MaDH == madh && t.MaDV == madv).FirstOrDefault(); ctdh.SoLuong = sl; ctdh.ThanhTien = thanhtien; qltg.SubmitChanges(); }
public void themchitietdonhang(int soluong, string mahd, string madv, float thanhtien) { CTDONHANG ctdh = new CTDONHANG(); ctdh.SoLuong = soluong; ctdh.MaDH = mahd; ctdh.MaDV = madv; ctdh.ThanhTien = thanhtien; qltg.CTDONHANGs.InsertOnSubmit(ctdh); qltg.SubmitChanges(); }
public int Delete(CTDONHANG model) { CTDONHANG dbEntry = context.CTDONHANGs.Find(model.ID_CTDH); if (dbEntry == null) { return(0); } context.CTDONHANGs.Remove(dbEntry); context.SaveChanges(); return(1); }
public ActionResult Delete(CTDONHANG pr) { CTDONHANG cTDONHANG = new CTDONHANG(); cTDONHANG = db.CTDONHANGs.Find(pr.IDDONHANG); if (cTDONHANG != null) { db.CTDONHANGs.Remove(pr); db.SaveChanges(); } return(RedirectToAction("List")); }
public int Insert(CTDONHANG model) { CTDONHANG dbEntry = context.CTDONHANGs.Find(model.ID_CTDH); if (dbEntry != null) { return(0); } context.CTDONHANGs.Add(model); context.SaveChanges(); return(1); }
public ActionResult Edit(CTDONHANG pr) { CTDONHANG cTDONHANG = new CTDONHANG(); cTDONHANG = db.CTDONHANGs.Find(pr.IDDONHANG); if (cTDONHANG != null) { cTDONHANG.IDMAY = pr.IDMAY; cTDONHANG.DONGIA = pr.DONGIA; cTDONHANG.SOLUONG = pr.SOLUONG; } return(RedirectToAction("List")); }
public ActionResult Edit(int id, CTDONHANG model) { try { model.ID_CTDH = id; var result = new CTDONHANGFunction.CTDonHangFunction().Update(model); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult InsertData() { string name = Request.Form["billing_last_name"]; string street = Request.Form["billing_address_1"]; string apartment = Request.Form["billing_address_2"]; string city = Request.Form["billing_city"]; string email = Request.Form["billing_email"]; int phone = Int32.Parse(Request.Form["billing_phone"]); ShoppingCart cart = (ShoppingCart)Session["cart"]; List <Item> lst = new List <Item>(); if (cart != null) { lst = cart.lst; if (db.KHACHHANGs.Where(q => q.TENKH == name && q.SDT == phone && q.EMAIL == email).FirstOrDefault() == null) { KHACHHANG khachhang = new KHACHHANG(); khachhang.TENKH = name; khachhang.DIACHI = street + " - " + apartment + " - " + city; khachhang.EMAIL = email; khachhang.SDT = phone; db.KHACHHANGs.Add(khachhang); db.SaveChanges(); } DONHANG donHang = new DONHANG(); var x = db.KHACHHANGs.Where(q => q.TENKH == name && q.SDT == phone && q.EMAIL == email).FirstOrDefault(); donHang.IDKH = x.IDKH; donHang.NGAYLAP = DateTime.Today; donHang.TRANGTHAI = "chưa được xử lý"; db.DONHANGs.Add(donHang); db.SaveChanges(); // var y = db.DonHangs.Where(q => q.IDKH == x.IDKH && q.NgayLap == DateTime.Today && q.TrangThai == "Chua du?c x? lý").FirstOrDefault(); foreach (var item in lst) { CTDONHANG cTDonHang = new CTDONHANG(); cTDonHang.IDDONHANG = donHang.IDDONHANG; cTDonHang.IDMAY = item.id; cTDonHang.SOLUONG = item.amount; cTDonHang.DONGIA = (int)item.price; db.CTDONHANGs.Add(cTDonHang); db.SaveChanges(); } cart.lst = null; } return(RedirectToAction("Index")); }
public int Update(CTDONHANG model) { CTDONHANG dbEntry = context.CTDONHANGs.Find(model.ID_CTDH); if (dbEntry == null) { return(0); } dbEntry.ID_DH = model.ID_DH; dbEntry.ID_SP = model.ID_SP; dbEntry.soluong = model.soluong; dbEntry.dongia = model.dongia; context.SaveChanges(); return(1); }
public ActionResult ThanhToan([Bind(Include = "MADH,TENKH,DIACHI,DIENTHOAI,EMAIL,TRANGTHAI,NGAYTAO,GHICHU")] DONHANG donhang, string tenkh, string diachi, string sdt, string email, string ghichu, bool trangthai) { donhang.TENKH = tenkh; donhang.DIACHI = diachi; donhang.DIENTHOAI = sdt; donhang.EMAIL = email; donhang.TRANGTHAI = trangthai; donhang.NGAYTAO = DateTime.Now; donhang.GHICHU = ghichu; var cart = (Cart)Session[CartSession]; decimal tong = 0; try { if (cart != null) { if (ModelState.IsValid) { db.DONHANGs.Add(donhang); db.SaveChanges(); var ID = (from x in db.DONHANGs orderby x.MADH descending select x.MADH).Take(1).Single(); foreach (var item in cart.Lines) { var CTDonHang = new CTDONHANG(); CTDonHang.MASP = item.SANPHAM.MASP; CTDonHang.MADH = ID; CTDonHang.GIA = item.SANPHAM.GIA - item.SANPHAM.GIAMGIA * item.SANPHAM.GIA / 100; CTDonHang.SL = item.Quantity; db.CTDONHANGs.Add(CTDonHang); tong += (item.SANPHAM.GIA - item.SANPHAM.GIAMGIA * item.SANPHAM.GIA / 100).GetValueOrDefault(0) * item.Quantity; db.SaveChanges(); } } } } catch (DbEntityValidationException ex) { var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage); var fullErrorMessages = string.Join(";", errorMessages); var exceptionMessages = string.Concat(ex.Message, "The validation errors are: ", fullErrorMessages); throw new DbEntityValidationException(exceptionMessages, ex.EntityValidationErrors); } return(RedirectToAction("Index", "Home")); }
public ActionResult Edit(int id) { if (Session["us"] == null) { return(RedirectToAction("Login", "MayAnh")); } else { CTDONHANG pr = new CTDONHANG(); pr = db.CTDONHANGs.Find(id); List <DONHANG> cateDonHang = db.DONHANGs.ToList(); SelectList cateListDonHang = new SelectList(cateDonHang, "IDDONHANG", "IDDONHANG"); ViewBag.IDDONHANG = cateListDonHang; List <MAYANH> cate = db.MAYANHs.ToList(); SelectList cateList = new SelectList(cate, "IDMAY", "TENMAY"); ViewBag.IDMAY = cateList; return(View(pr)); } }
public ActionResult DatHang() { //Kiểm tra đăng đăng nhập if (Session["TaiKhoan"] == null || Session["TaiKhoan"].ToString() == "") { return(RedirectToAction("DangNhap", "User")); } //Kiểm tra giỏ hàng if (Session["GioHang"] == null) { RedirectToAction("Index", "NongSan"); } //Thêm đơn hàng DONHANG dh = new DONHANG(); KHACHHANG kh = (KHACHHANG)Session["TaiKhoan"]; List <GioHang> gh = LayGioHang(); dh.MaKhachHang = kh.MaKhachHang; dh.NgayDat = DateTime.Now; db.DONHANGs.Add(dh); db.SaveChanges(); //Thêm chi tiết đơn hàng foreach (var item in gh) { CTDONHANG ctDH = new CTDONHANG(); //NONGSAN ns = new NONGSAN(); ctDH.MaHoaDon = dh.MaHoaDon; ctDH.MaNongSan = item.idMaQua; ctDH.SoLuong = item.iSoLuong; ctDH.DonGia = (int)item.iDonGia; db.CTDONHANGs.Add(ctDH); //db.NONGSANs.Add(ns); } db.SaveChanges(); return(RedirectToAction("Index", "NongSan")); }
public ActionResult ThanhToan([Bind(Include = "MADH,TENKH,DIACHI,DIENTHOAI,EMAIL,TRANGTHAI,NGAYTAO,GHICHU")] DONHANG donhang, string tenkh, string diachi, string sdt, string email, string ghichu, string trangthai) { donhang.TENKH = tenkh; donhang.DIACHI = diachi; donhang.DIENTHOAI = sdt; donhang.EMAIL = email; donhang.NGAYTAO = DateTime.Now; donhang.GHICHU = ghichu; if (trangthai == "0") { donhang.TRANGTHAI = false; } else { donhang.TRANGTHAI = true; } var cart = (Cart)Session[CartSession]; decimal tong = 0; try { if (cart != null) { db.DONHANGs.Add(donhang); db.SaveChanges(); var ID = (from x in db.DONHANGs orderby x.MADH descending select x.MADH).Take(1).Single(); foreach (var item in cart.Lines) { var CTDonHang = new CTDONHANG(); CTDonHang.MASP = item.SANPHAM.MASP; CTDonHang.MADH = ID; CTDonHang.GIA = item.SANPHAM.GIA - item.SANPHAM.GIAMGIA * item.SANPHAM.GIA / 100; CTDonHang.SL = item.Quantity; db.CTDONHANGs.Add(CTDonHang); tong += (item.SANPHAM.GIA - item.SANPHAM.GIAMGIA * item.SANPHAM.GIA / 100).GetValueOrDefault(0) * item.Quantity; SANPHAM sp = db.SANPHAMs.SingleOrDefault(n => n.MASP == CTDonHang.MASP); int sl1 = (int)sp.SOLUONG; int sl2 = item.Quantity; int conlai = sl1 - sl2; sp.SOLUONG = conlai; db.Entry(sp).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } } catch (DbEntityValidationException ex) { var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage); var fullErrorMessages = string.Join(";", errorMessages); var exceptionMessages = string.Concat(ex.Message, "The validation errors are: ", fullErrorMessages); throw new DbEntityValidationException(exceptionMessages, ex.EntityValidationErrors); } cart = null; Session[CartSession] = cart; return(RedirectToAction("ThanhCong")); }
public ActionResult Create(CTDONHANG pr) { db.CTDONHANGs.Add(pr); db.SaveChanges(); return(RedirectToAction("List")); }
public ActionResult GioHang(FormCollection frm, DONDATHANG donhang) { int x = 0; string danggiao = "Đang giao"; if (Session["Email"] == null && Session["username"] == null) { return(RedirectToAction("LoginSSO", "Account")); } else { if (Session["username"] != null) { x = int.Parse(Session["makh"].ToString()); } else { x = int.Parse(Session["MaKH"].ToString()); } var user = db.KHACHHANGs.FirstOrDefault(n => n.MaKH == x); if (user.DiaChiKH == null || user.DienThoaiKH == null) { user = db.KHACHHANGs.Find(x); { user.DienThoaiKH = frm["dienthoainhanhang"]; user.DiaChiKH = frm["diachinhanhang"]; }; if (Session["username"] != null) { db.Entry(user); donhang.MaKH = int.Parse(Session["makh"].ToString()); donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString()); donhang.TriGia = decimal.Parse(Session["TongTien"].ToString()); donhang.TrangThai = danggiao; donhang.TenNguoiNhan = frm["tennguoinhan"]; donhang.DienThoaiNhan = frm["dienthoainhanhang"]; donhang.DiaChiNhan = frm["diachinhanhang"]; donhang.EmailNhanHang = frm["email"]; db.DONDATHANGs.Add(donhang); db.SaveChanges(); List <SanPhamGH> listSP = LayGioHang(); foreach (var item in listSP) { CTDONHANG ctdh = new CTDONHANG(); ctdh.SoDH = donhang.SoDH; ctdh.MaSP = item.MaSP; ctdh.SoLuong = item.SoLuongMua; ctdh.DonGia = (decimal)item.DonGia; db.CTDONHANGs.Add(ctdh); SANPHAM sp = db.SANPHAMs.Find(ctdh.MaSP); sp.SoLuong--; db.Entry(sp).State = EntityState.Modified; db.SaveChanges(); } foreach (var item in listSP) { SANPHAM sp = db.SANPHAMs.Find(item.MaSP); if (sp.YeuThich == null) { sp.YeuThich = 1; db.Entry(sp).State = EntityState.Modified; db.SaveChanges(); } else { sp.YeuThich += item.SoLuongMua; db.Entry(sp).State = EntityState.Modified; db.SaveChanges(); } } Session["GioHang"] = null; return(RedirectToAction("ThanhToanThanhCong", "GioHang")); } else { db.Entry(user); donhang.MaKH = int.Parse(Session["MaKH"].ToString()); donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString()); donhang.TriGia = decimal.Parse(Session["TongTien"].ToString()); donhang.TrangThai = danggiao; donhang.TenNguoiNhan = frm["tennguoinhan"]; donhang.DienThoaiNhan = frm["dienthoainhanhang"]; donhang.DiaChiNhan = frm["diachinhanhang"]; donhang.EmailNhanHang = frm["email"]; db.DONDATHANGs.Add(donhang); db.SaveChanges(); List <SanPhamGH> listSP = LayGioHang(); foreach (var item in listSP) { CTDONHANG ctdh = new CTDONHANG(); ctdh.SoDH = donhang.SoDH; ctdh.MaSP = item.MaSP; ctdh.SoLuong = item.SoLuongMua; ctdh.DonGia = (decimal)item.DonGia; db.CTDONHANGs.Add(ctdh); SANPHAM sp = db.SANPHAMs.Find(ctdh.MaSP); sp.SoLuong--; db.Entry(sp).State = EntityState.Modified; db.SaveChanges(); } foreach (var item in listSP) { SANPHAM sp = db.SANPHAMs.Find(item.MaSP); if (sp.YeuThich == null) { sp.YeuThich = 1; db.Entry(sp).State = EntityState.Modified; db.SaveChanges(); } else { sp.YeuThich += item.SoLuongMua; db.Entry(sp).State = EntityState.Modified; db.SaveChanges(); } } Session["GioHang"] = null; return(RedirectToAction("ThanhToanThanhCong", "GioHang")); } } else { if (Session["username"] != null) { donhang.MaKH = int.Parse(Session["makh"].ToString()); donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString()); donhang.TriGia = decimal.Parse(Session["TongTien"].ToString()); donhang.TrangThai = danggiao; donhang.TenNguoiNhan = frm["tennguoinhan"]; donhang.DienThoaiNhan = frm["dienthoainhanhang"]; donhang.DiaChiNhan = frm["diachinhanhang"]; donhang.EmailNhanHang = frm["email"]; db.DONDATHANGs.Add(donhang); db.SaveChanges(); List <SanPhamGH> listSP = LayGioHang(); foreach (var item in listSP) { CTDONHANG ctdh = new CTDONHANG(); ctdh.SoDH = donhang.SoDH; ctdh.MaSP = item.MaSP; ctdh.SoLuong = item.SoLuongMua; ctdh.DonGia = (decimal)item.DonGia; db.CTDONHANGs.Add(ctdh); SANPHAM sp = db.SANPHAMs.Find(ctdh.MaSP); sp.SoLuong--; db.Entry(sp).State = EntityState.Modified; db.SaveChanges(); } foreach (var item in listSP) { SANPHAM sp = db.SANPHAMs.Find(item.MaSP); if (sp.YeuThich == null) { sp.YeuThich = 1; db.Entry(sp).State = EntityState.Modified; db.SaveChanges(); } else { sp.YeuThich += item.SoLuongMua; db.Entry(sp).State = EntityState.Modified; db.SaveChanges(); } } Session["Madh"] = donhang.SoDH; return(RedirectToAction("ThanhToanThanhCong", "GioHang")); } else { donhang.MaKH = int.Parse(Session["MaKH"].ToString()); donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString()); donhang.TriGia = decimal.Parse(Session["TongTien"].ToString()); donhang.TrangThai = danggiao; donhang.TenNguoiNhan = frm["tennguoinhan"]; donhang.DienThoaiNhan = frm["dienthoainhanhang"]; donhang.DiaChiNhan = frm["diachinhanhang"]; donhang.EmailNhanHang = frm["email"]; db.DONDATHANGs.Add(donhang); db.SaveChanges(); List <SanPhamGH> listSP = LayGioHang(); foreach (var item in listSP) { CTDONHANG ctdh = new CTDONHANG(); ctdh.SoDH = donhang.SoDH; ctdh.MaSP = item.MaSP; ctdh.SoLuong = item.SoLuongMua; ctdh.DonGia = (decimal)item.DonGia; db.CTDONHANGs.Add(ctdh); SANPHAM sp = db.SANPHAMs.Find(ctdh.MaSP); sp.SoLuong--; db.Entry(sp).State = EntityState.Modified; db.SaveChanges(); } foreach (var item in listSP) { SANPHAM sp = db.SANPHAMs.Find(item.MaSP); if (sp.YeuThich == null) { sp.YeuThich = 1; db.Entry(sp).State = EntityState.Modified; db.SaveChanges(); } else { sp.YeuThich += item.SoLuongMua; db.Entry(sp).State = EntityState.Modified; db.SaveChanges(); } } Session["Madh"] = donhang.SoDH; return(RedirectToAction("ThanhToanThanhCong", "GioHang")); } } } }
public ActionResult GioHang(FormCollection frm, DONDATHANG donhang) { if (Session["makh"] == null) { return(RedirectToAction("Index", "SSO")); } else { int x = int.Parse(Session["makh"].ToString()); var user = db.Users.FirstOrDefault(n => n.MaKH == x); if (user.DiaChi == null || user.DienThoaiKH == null) { user = db.Users.Find(x); { user.DienThoaiKH = frm["dienthoainhanhang"]; user.DiaChi = frm["diachinhanhang"]; }; db.Entry(user); bool am = false; donhang.MaKH = int.Parse(Session["makh"].ToString()); donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString()); //donhang.NgayGiaoHang = DateTime.Parse(frm["ngaynhanhang"].ToString()); donhang.TriGia = decimal.Parse(Session["TongTien"].ToString()); donhang.TrangThai = am; donhang.TenNguoiNhan = frm["tennguoinhan"]; donhang.DienThoaiNhan = int.Parse(frm["dienthoainhanhang"]); donhang.DiaChiNhan = frm["diachinhanhang"]; db.DONDATHANGs.Add(donhang); db.SaveChanges(); List <SamPhamGH> listSP = LayGioHang(); foreach (var item in listSP) { CTDONHANG ctdh = new CTDONHANG(); ctdh.SoDH = donhang.SoHD; ctdh.MaSP = item.BookId; ctdh.SoLuong = item.SoLuongMua; ctdh.DonGia = (decimal)item.Price; db.CTDONHANGs.Add(ctdh); db.SaveChanges(); } Session["GioHang"] = null; return(RedirectToAction("ThanhToanThanhCong", "GioHang")); } else { bool a = false; donhang.MaKH = int.Parse(Session["makh"].ToString()); donhang.NgayDH = DateTime.Parse(DateTime.Now.ToString()); //donhang.NgayGiaoHang = DateTime.Parse(frm["ngaynhanhang"].ToString()); donhang.TriGia = decimal.Parse(Session["TongTien"].ToString()); donhang.TrangThai = a; donhang.TenNguoiNhan = frm["tennguoinhan"]; donhang.DienThoaiNhan = int.Parse(frm["dienthoainhanhang"]); donhang.DiaChiNhan = frm["diachinhanhang"]; db.DONDATHANGs.Add(donhang); db.SaveChanges(); List <SamPhamGH> listSP = LayGioHang(); foreach (var item in listSP) { CTDONHANG ctdh = new CTDONHANG(); ctdh.SoDH = donhang.SoHD; ctdh.MaSP = item.BookId; ctdh.SoLuong = item.SoLuongMua; ctdh.DonGia = (decimal)item.Price; db.CTDONHANGs.Add(ctdh); db.SaveChanges(); } Session["Madh"] = donhang.SoHD; return(RedirectToAction("ThanhToanThanhCong", "GioHang")); } } }
public CTDONHANG FindEntity(int ID_CTDH) { CTDONHANG dbEntry = context.CTDONHANGs.Find(ID_CTDH); return(dbEntry); }
public ActionResult Payment(string name, string mobileadd, string diachiadd, string dateout) { // A var order = new DONHANG(); order.ngaylap = DateTime.Now; order.hotenkh = name; order.diachigiaohang = diachiadd; order.phone = mobileadd; DateTime?date = null; DateTime temp; if (DateTime.TryParse(dateout, out temp)) { if (temp != null) { date = temp; } } if (date != null) { order.ngaynhanhang = date.Value; } // B //nếu login if (SessionPersister.UserName != null) { order.ngaynhanhang = DateTime.Now; order.ID_TK = SessionPersister.UserName.ID_TK; var account = new TAIKHOANFunction.TaiKhoanFunction().FindEntity(order.ID_TK.Value); order.hotenkh = account.tentk; order.diachigiaohang = account.diachi; order.phone = account.phone; } try { var id = new DONHANGFunction.DonHangFunction().Insert(order); var cart = (Cart)Session["CartSession"]; var detailDao = new CTDONHANGFunction.CTDonHangFunction(); foreach (var item in cart.Lines) { var orderDetail = new CTDONHANG(); orderDetail.ID_SP = item.Sanpham.ID_SP; orderDetail.ID_DH = id; orderDetail.soluong = item.Quantity; orderDetail.dongia = (item.Sanpham.giabd * item.Quantity); detailDao.Insert(orderDetail); } Session["CartSession"] = null; } catch (Exception ex) { //ghi log return(RedirectToAction("Loi")); // action Loi ở đâu? } return(RedirectToAction("MuaHangThanhCong", "Cart")); }