public bool create_hoa_don(donhangkemct donhang) { try { int s = 0; for (int i = 0; i < donhang.ctdhs.Count(); i++) { s = donhang.ctdhs[i].soluong * donhang.ctdhs[i].gia; } donhang.dh.tinhtrang = 0; donhang.dh.tongtien = s; if (this.create(donhang.dh)) { List <donhang> ds = _context.donhangs.ToList(); int id = ds[ds.Count() - 1].id; for (int i = 0; i < donhang.ctdhs.Count(); i++) { chitietdonhang ct = new chitietdonhang(); ct.iddh = ct.iddh; ct.idmon = ct.idmon; ct.soluong = ct.soluong; ct.gia = ct.gia; } } return(true); } catch (Exception) { return(false); } }
public List <chitietdonhang> getChitietdonhang(int madh) { List <chitietdonhang> chitietdonhangs = new List <chitietdonhang>(); var truyvan = (from dh in db.donhangs join ct in db.ctdhs on dh.madh equals ct.madh join sp in db.sanphams on ct.masp equals sp.masp where dh.madh == madh select new { sp.tensp, sp.hinhanh, ct.soluong, ct.gia, dh.ngaydat, dh.tongtien, dh.tttt, dh.httt }); foreach (var dulieu in truyvan) { chitietdonhang ct = new chitietdonhang(); ct.tensp = dulieu.tensp; ct.hinhanh = dulieu.hinhanh; ct.soluong = dulieu.soluong; ct.dongia = dulieu.gia; ct.thanhtien = (double)dulieu.tongtien; ct.tttt = dulieu.tttt; ct.ngaydat = dulieu.ngaydat.ToString(); ct.httt = dulieu.httt; chitietdonhangs.Add(ct); } return(chitietdonhangs); }
public ActionResult ThanhToan(FormCollection formCollection, dondathang dondathang) { var noigiao = formCollection["Item1.diachikh"]; List <GioHang> gh = LayGioHang(); dondathang.ngaydat = DateTime.Now; dondathang.noigiao = noigiao; dondathang.makh = int.Parse(Session["makh"].ToString()); dondathang.thanhtien = (decimal)TongTien(); dondathang.dathanhtoan = "no"; dondathang.tinhtranggiaohang = false; db.dondathangs.InsertOnSubmit(dondathang); db.SubmitChanges(); foreach (var item in gh) { chitietdonhang chitietdonhang = new chitietdonhang(); chitietdonhang.madh = dondathang.madh; chitietdonhang.masp = item.sMaSP; chitietdonhang.soluong = item.iSoLuong; chitietdonhang.dongia = item.iDonGia; db.chitietdonhangs.InsertOnSubmit(chitietdonhang); } db.SubmitChanges(); Session["GioHang"] = null; return(RedirectToAction("XacNhanDonHang", "GioHang")); }
public ActionResult TienHanhDatHang(string tenKH, string diachi, string sodienthoai, string ghichu) { try { List <SanPhamGioHang> listSPGH = Session["GioHang"] as List <SanPhamGioHang>;; if (listSPGH == null) { return(RedirectToAction("Purchase", "Cart")); } else { banhang objBanhang = new banhang(); int tongtien = 0; if (listSPGH != null) { foreach (var item in listSPGH) { int thanhtien = item.gia * item.soluong; tongtien = tongtien + thanhtien; } } objBanhang.tongtien = tongtien; objBanhang.tenKH = tenKH; objBanhang.diachiKH = diachi; objBanhang.dienthoaiKH = sodienthoai; objBanhang.ghichu = ghichu; objBanhang.ngaydathang = DateTime.Now; objBanhang.ngaycapnhat = DateTime.Now; objBanhang.trangthaidonhang = Convert.ToInt32(TrangThaiDonHang.DonHangmoi); try { db.banhangs.Add(objBanhang); db.SaveChanges(); foreach (var item in listSPGH) { chitietdonhang objCTDH = new chitietdonhang(); objCTDH.idsp = item.id; objCTDH.soluong = item.soluong; objCTDH.giaban = item.gia; objCTDH.iddonbanhang = objBanhang.id; try { db.chitietdonhangs.Add(objCTDH); db.SaveChanges(); } catch { } } } catch { } } return(RedirectToAction("Index", "XacNhanDonHangThanhCong")); } catch (Exception ex) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }
public ActionResult DeleteConfirmed(int id) { chitietdonhang chitietdonhang = db.chitietdonhangs.Find(id); db.chitietdonhangs.Remove(chitietdonhang); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult StepEnd() { //Nhận reqest từ trang index string phone = Request.Form["phone"]; string fullname = Request.Form["fullname"]; string email = Request.Form["email"]; string address = Request.Form["address"]; string note = Request.Form["note"]; //kiểm tra xem có customer chưa và cập nhật lại khachhang newCus = new khachhang(); var cus = db.khachhang.FirstOrDefault(p => p.sdtkh.Equals(phone)); if (cus != null) { //nếu có số điện thoại trong db rồi //cập nhật thông tin và lưu cus.hovaten = fullname; cus.email = email; cus.diachi = address; db.Entry(cus).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else { //nếu chưa có sđt trong db //thêm thông tin và lưu return(RedirectToAction("Register", "User")); } //Thêm thông tin vào order và orderdetail List <CartItem> giohang = Session["giohang"] as List <CartItem>; //thêm order mới donhang newOrder = new donhang(); int newIDOrder = db.donhang.OrderByDescending(p => p.ngaydat).FirstOrDefault().iddh; newOrder.iddh = newIDOrder; newOrder.sdtkh = phone; newOrder.ghichu = note; newOrder.ngaydat = DateTime.Now.ToString(); newOrder.trangthai = "0"; db.donhang.Add(newOrder); db.SaveChanges(); //thêm details for (int i = 0; i < giohang.Count; i++) { chitietdonhang newOrdts = new chitietdonhang(); newOrdts.iddh = newOrder.iddh; newOrdts.idta = giohang.ElementAtOrDefault(i).thucanID; newOrdts.soluong = giohang.ElementAtOrDefault(i).SoLuong; newOrdts.dongia = giohang.ElementAtOrDefault(i).ThanhTien.ToString(); db.chitietdonhang.Add(newOrdts); db.SaveChanges(); } Session["MDH"] = newOrder.iddh; Session["Phone"] = phone; //xoá sạch giỏ hàng giohang.Clear(); return(RedirectToAction("HoaDon", "ThanhToan")); }
public ActionResult Edit([Bind(Include = "id,iddonbanhang,idsp,soluong,giaban,tensanpham")] chitietdonhang chitietdonhang) { if (ModelState.IsValid) { db.Entry(chitietdonhang).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.iddonbanhang = new SelectList(db.banhangs, "id", "madonbanhang", chitietdonhang.iddonbanhang); ViewBag.idsp = new SelectList(db.sanphams, "id", "ten", chitietdonhang.idsp); return(View(chitietdonhang)); }
public ActionResult Edit([Bind(Include = "iddh,idta,soluong,dongia")] chitietdonhang chitietdonhang) { if (ModelState.IsValid) { db.Entry(chitietdonhang).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.iddh = new SelectList(db.donhang, "iddh", "sdtkh", chitietdonhang.iddh); ViewBag.idta = new SelectList(db.thucan, "idta", "tenta", chitietdonhang.idta); return(View(chitietdonhang)); }
public ActionResult Edit([Bind(Include = "machitietdonhang,masanpham,madonhang,soluongmua,dongia,tongtien,tensanpham")] chitietdonhang chitietdonhang) { if (ModelState.IsValid) { db.Entry(chitietdonhang).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.madonhang = new SelectList(db.donhang, "madonhang", "tenkhachhang", chitietdonhang.madonhang); ViewBag.masanpham = new SelectList(db.sanpham, "masanpham", "tensanpham", chitietdonhang.masanpham); return(View(chitietdonhang)); }
// GET: Admin/chitietdonhangss/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } chitietdonhang chitietdonhang = db.chitietdonhangs.Find(id); if (chitietdonhang == null) { return(HttpNotFound()); } return(View(chitietdonhang)); }
// GET: Admin/chitietdonhangss/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } chitietdonhang chitietdonhang = db.chitietdonhangs.Find(id); if (chitietdonhang == null) { return(HttpNotFound()); } ViewBag.iddonbanhang = new SelectList(db.banhangs, "id", "madonbanhang", chitietdonhang.iddonbanhang); ViewBag.idsp = new SelectList(db.sanphams, "id", "ten", chitietdonhang.idsp); return(View(chitietdonhang)); }
// GET: admin/chitietdonhangs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } chitietdonhang chitietdonhang = db.chitietdonhang.Find(id); if (chitietdonhang == null) { return(HttpNotFound()); } ViewBag.iddh = new SelectList(db.donhang, "iddh", "sdtkh", chitietdonhang.iddh); ViewBag.idta = new SelectList(db.thucan, "idta", "tenta", chitietdonhang.idta); return(View(chitietdonhang)); }
// GET: Areas/Chitietdonhangs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } chitietdonhang chitietdonhang = db.chitietdonhang.Find(id); if (chitietdonhang == null) { return(HttpNotFound()); } ViewBag.madonhang = new SelectList(db.donhang, "madonhang", "tenkhachhang", chitietdonhang.madonhang); ViewBag.masanpham = new SelectList(db.sanpham, "masanpham", "tensanpham", chitietdonhang.masanpham); return(View(chitietdonhang)); }
public bool them(int masodh, int mahang, int soluong, int gia1sp) { try { banhangDataContext context = new banhangDataContext(); chitietdonhang themvaodh = new chitietdonhang(); themvaodh.masodh = masodh; themvaodh.mahang = mahang; themvaodh.soluong = soluong; themvaodh.giadathang1sp = gia1sp; context.chitietdonhangs.InsertOnSubmit(themvaodh); context.SubmitChanges(); return(true); } catch { }; return(false); }
public ActionResult Datmua() { List <CartItem> giohang = Session["giohang"] as List <CartItem>; List <sanpham> lisp = db.sanpham.ToList(); var donhang = db.donhang.ToList(); var chitietdonhang = db.chitietdonhang.ToList(); donhang dh = new donhang(); dh.email = Request.Form["email"]; dh.diachi = Request.Form["diachi"]; dh.ghichu = Request.Form["ghichu"]; dh.ngaydathang = DateTime.Now; dh.maphuongthucthanhtoan = int.Parse(Request.Form["phuongthuc"].ToString()); dh.tenkhachhang = Request.Form["hoten"]; dh.tinhtrang = "Đang chờ"; dh.tongtienthanhtoan = Convert.ToDecimal(Request.Form["tongtienthanhtoan"]); db.donhang.Add(dh); db.SaveChanges(); for (int i = 0; i < giohang.Count; i++) { chitietdonhang ctdh = new chitietdonhang(); ctdh.madonhang = dh.madonhang; ctdh.masanpham = giohang[i].masanpham; ctdh.soluongmua = giohang[i].soluong; ctdh.tensanpham = giohang[i].tensanpham; ctdh.dongia = (decimal)giohang[i].dongia; ctdh.tongtien = (decimal)giohang[i].thanhtien; db.chitietdonhang.Add(ctdh); // sửa lại số lượng sản phẩm trong csdl sau khi đặt mua sanpham sp = db.sanpham.Find(giohang[i].masanpham); sp.soluong = sp.soluong - giohang[i].soluong; db.SaveChanges(); } for (int i = 0; i < giohang.Count; i++) { giohang.RemoveAt(i); i--; } return(RedirectToAction("Datmuathanhcong", "Home")); }