public ActionResult SetGiaoHang(int?id, bool edit = false) { if (!id.HasValue) { if (edit == true) { return(RedirectToAction("Edit", new { id = id })); } return(RedirectToAction("Index")); } else { using (ModelEntities ctx = new ModelEntities()) { tbl_PhieuOrders itemFind = ctx.tbl_PhieuOrders.Where(p => p.PhieuOrderID == id.Value).FirstOrDefault(); itemFind.TinhTrangGiaoHang = true; ctx.SaveChanges(); if (edit == true) { return(RedirectToAction("Edit", new { id = id })); } return(RedirectToAction("Index")); } } }
public ActionResult SetDelete(int?id) { if (!id.HasValue) { return(RedirectToAction("Index")); } else { using (ModelEntities ctx = new ModelEntities()) { tbl_PhieuOrders itemFind = ctx.tbl_PhieuOrders.Where(p => p.PhieuOrderID == id.Value).FirstOrDefault(); itemFind.DaXoa = true; ctx.SaveChanges(); return(RedirectToAction("Index")); } } }
// GET: Admin/Cart/Edit public ActionResult Edit(int?id) { if (!id.HasValue) { return(RedirectToAction("Index")); } Poco_DonHang_ChiTiet chiTietDonHang = new Poco_DonHang_ChiTiet(); using (ModelEntities ctx = new ModelEntities()) { tbl_PhieuOrders phieuOder = ctx.tbl_PhieuOrders.Where(p => p.PhieuOrderID == id).ToList().FirstOrDefault(); if (phieuOder.DaXoa == true) { return(RedirectToAction("Index")); } chiTietDonHang.ThongTinDonHang = new Poco_Info_DonHang(); chiTietDonHang.ThongTinDonHang.MaDonHang = phieuOder.PhieuOrderID.ToString(); chiTietDonHang.ThongTinDonHang.NgayLapPhieu = phieuOder.NgayLapPhieu.ToString(); if (string.IsNullOrEmpty(phieuOder.SoDienThoai)) { chiTietDonHang.ThongTinDonHang.SoDienThoaiNhanHang = "Không xác định"; } else { chiTietDonHang.ThongTinDonHang.SoDienThoaiNhanHang = phieuOder.SoDienThoai; } if (string.IsNullOrEmpty(phieuOder.DiaChi)) { chiTietDonHang.ThongTinDonHang.DiaChiGiaoHang = "Không xác định"; } else { chiTietDonHang.ThongTinDonHang.DiaChiGiaoHang = phieuOder.DiaChi; } chiTietDonHang.ThongTinDonHang.TinhTrangGiaoHang = phieuOder.TinhTrangGiaoHang.Value; chiTietDonHang.ThongTinDonHang.TinhTrangThanhToan = phieuOder.TinhTrangThanhToan.Value; chiTietDonHang.ThongTinDonHang.TongSoLuong = phieuOder.TongSoLuong.ToString(); chiTietDonHang.ThongTinDonHang.TongTien = phieuOder.TongTien; chiTietDonHang.ThongTinDonHang.GioLap = phieuOder.NgayLapPhieu.ToShortTimeString(); chiTietDonHang.ThongTinDonHang.DaXoa = phieuOder.DaXoa.Value; tbl_NguoiSuDungs user = ctx.tbl_NguoiSuDungs.Where(p => p.NguoiSuDungID == phieuOder.NguoiSuDungID).FirstOrDefault(); chiTietDonHang.ThongTinKhachHang = new Poco_Info_KhachHang(); chiTietDonHang.ThongTinKhachHang.MaKhachHang = user.NguoiSuDungID.ToString(); chiTietDonHang.ThongTinKhachHang.TenKhachHang = user.TenNguoiSuDung; chiTietDonHang.ChiTietDonHang = new List <Poco_ChiTiet_Order>(); List <tbl_ChiTietOrders> listOrder = ctx.tbl_ChiTietOrders.Where(p => p.PhieuOrderID == id).ToList(); foreach (tbl_ChiTietOrders item in listOrder) { Poco_ChiTiet_Order itemAdd = new Poco_ChiTiet_Order(); var a = ctx.tbl_SanPhams.Where(p => p.SanPhamID == item.SanPhamID).FirstOrDefault(); if (a != null) { itemAdd.TenSanPham = a.TenSanPham; } itemAdd.SanPhamID = item.SanPhamID.ToString(); itemAdd.DonGia = item.DonGia; itemAdd.SoLuong = item.SoLuong; itemAdd.ThanhTien = item.ThanhTien; chiTietDonHang.ChiTietDonHang.Add(itemAdd); } return(View(chiTietDonHang)); } }
public ActionResult Checkout(tbl_NguoiSuDungs itemUser) { tbl_PhieuOrders ord = new tbl_PhieuOrders { NgayLapPhieu = DateTime.Now, NguoiSuDungID = CurrentContext.getCurrenUser().NguoiSuDungID, TongSoLuong = 0, TongTien = 0, DiaChi = null, SoDienThoai = null, TinhTrangGiaoHang = false, TinhTrangThanhToan = false, DaXoa = false }; using (ModelEntities ctx = new ModelEntities()) { decimal total = 0; int totalAmount = 0; foreach (CartItem item in CurrentContext.Cart().Items) { tbl_SanPhams pro = ctx.tbl_SanPhams.Where(p => p.SanPhamID == item.ProID).FirstOrDefault(); if (pro != null) { tbl_ChiTietOrders d = new tbl_ChiTietOrders { SanPhamID = item.ProID, SoLuong = item.Quantity, DonGia = (decimal)pro.Gia, ThanhTien = (decimal)(item.Quantity * pro.Gia) }; pro.SoLanMua += item.Quantity; pro.SoLuong -= item.Quantity; ctx.SaveChanges(); ord.tbl_ChiTietOrders.Add(d); totalAmount += d.SoLuong; total += d.ThanhTien; } } ord.TongSoLuong = totalAmount; ord.TongTien = total; ord.TinhTrangGiaoHang = false; ord.TinhTrangThanhToan = false; int curID = CurrentContext.getCurrenUser().NguoiSuDungID; var user = ctx.tbl_NguoiSuDungs.Where(p => p.NguoiSuDungID == curID).FirstOrDefault(); if (itemUser.DiaChi == null) { ord.DiaChi = user.DiaChi; } else { ord.DiaChi = itemUser.DiaChi; } if (itemUser.SoDienThoai == null) { ord.SoDienThoai = user.SoDienThoai; } else { ord.SoDienThoai = itemUser.SoDienThoai; } ctx.tbl_PhieuOrders.Add(ord); ctx.SaveChanges(); CurrentContext.Cart().Items.Clear(); return(RedirectToAction("Index", "Cart")); } }