public ActionResult Payment(DONHANG model) { //model. = DateTime.Now; try { context.DONHANGs.Add(model); context.SaveChanges(); var cart = (Cart)Session["CartSession"]; foreach (var item in cart.Lines) { CHITIETDONHANG obj = new CHITIETDONHANG(); obj.MaDH = model.MaDH; obj.MaThuoc = item.Thuoc.MaThuoc; //obj.= item.Sanpham.GiaSP; obj.SoLuong = item.Quantity; context.CHITIETDONHANGs.Add(obj); context.SaveChanges(); } cart.Clear(); Session["CartSession"] = cart; } catch (Exception ex) { //ghi log return(RedirectToAction("/Loi")); } return(View("Complete")); }
//Lưu đơn đặt hàng (Lấy từ Session[kh]) public ActionResult LuuDDH() { List <GioHang> lstGiohang = Laygiohang(); DONHANG dh = new DONHANG(); KHACHHANG kh = (KHACHHANG)Session["kh"]; dh.MADH = Capma_tudong("DH"); dh.NGAYLAP = DateTime.Now; dh.TONGTIEN = (int)TongTien(); dh.TINHTRANG = false; dh.MAKH = kh.MAKH; data.DONHANGs.InsertOnSubmit(dh); data.SubmitChanges(); foreach (var item in lstGiohang) { CTDH ct = new CTDH(); ct.MADH = Capma_tudong("DH"); ct.MASP = item.masp; ct.SOLUONG = item.soluong; data.CTDHs.InsertOnSubmit(ct); data.SubmitChanges(); } Update_ma("DH"); Session["GioHang"] = null; return(RedirectToAction("DatThanhCong", "_Home")); }
public ActionResult Create(DONHANG model) { ValidateBill(model); if (ModelState.IsValid) { using (var scope = new TransactionScope()) { model.NGAYTAODONHANG = DateTime.Now; db.DONHANGs.Add(model); db.SaveChanges(); foreach (var item in ShoppingCart) { db.CHITIETDONHANGs.Add(new CHITIETDONHANG { MADONHANG = model.MADONHANG, MASANPHAM = item.SANPHAM.MASP, GIATIENBAN = item.SANPHAM.GIABAN, SOLUONG = item.SOLUONG }); } db.SaveChanges(); scope.Complete(); Session["ShoppingCart"] = null; return(RedirectToAction("Index2", "SANPHAMs")); } } GetShoppingCart(); ViewBag.Cart = ShoppingCart; return(View(model)); }
public async Task <ActionResult> ChiTietDonHang(DONHANG model, int ID) { DONHANG obj = null; using (var client = new HttpClient()) { //gọi api thêm đơn hàng client.BaseAddress = new Uri("https://localhost:44366/api/"); var responseTask = await client.GetAsync("donhang/getdonhang/" + ID.ToString()); if (responseTask.IsSuccessStatusCode) { obj = await responseTask.Content.ReadAsAsync <DONHANG>(); } else { obj = null; } ModelState.AddModelError(string.Empty, "Server error. Please contact administrator."); } obj.TinhTrang = model.TinhTrang; using (var client = new HttpClient()) { client.BaseAddress = new Uri("https://localhost:44366/api/"); var putTask = await client.PutAsJsonAsync <DONHANG>("donhang/updatedonhang", obj); if (!putTask.IsSuccessStatusCode) { ModelState.AddModelError(string.Empty, "Server error. Please contact administrator."); } } return(RedirectToAction("DonHang")); }
public string getDonHangbyMaDH(int id)//DONHANG getDonHangbyMaDH(int id) { DONHANG dh = db.DONHANGs.FirstOrDefault(x => x.MaDH == id); dh.CTDHs.Clear(); return(new JavaScriptSerializer().Serialize(dh));// dh; }
private void fmXemHangHoa_Load(object sender, EventArgs e) { try { DONHANG dh = (from a in db.DONHANGs where a.MADH == madon select a).Single(); mahang.Text = dh.MAHANG; noidung.Text = dh.HANG.NOIDUNG; chieucao.Text = dh.HANG.CAO.ToString(); chieudai.Text = dh.HANG.DAI.ToString(); chieurong.Text = dh.HANG.RONG.ToString(); trongluong.Text = dh.HANG.TRONGLUONG.ToString(); madonhang.Text = dh.MADH; nhanvien.Text = dh.NHANVIEN.TEN; ngaygui.Text = String.Format("{0:MM/dd/yyyy}", dh.NGAYGUI); ttdh.Text = dh.TTHD; ttp.Text = dh.PHIGH.TTPHI; cmtng.Text = dh.NGUOIGUI.CMND; tenng.Text = dh.NGUOIGUI.HOTEN; dcng.Text = dh.NGUOIGUI.DIACHI; sdtng.Text = dh.NGUOIGUI.SDT; cmtnn.Text = dh.NGUOINHAN.CMND; tennn.Text = dh.NGUOINHAN.HOTEN; dcnn.Text = dh.NGUOINHAN.DIACHI; sdtnn.Text = dh.NGUOINHAN.SDT; } catch (Exception er) { log.Error(er); XtraMessageBox.Show("Không xem được thông tin!", "Lỗi!"); } }
public void deleteDH(long ID) { DONHANG dh = db.DONHANGs.Find(ID); db.DONHANGs.Remove(dh); db.SaveChanges(); }
public ActionResult Payment(string shipName, string mobile, string address, string email) { var order = new DONHANG(); order.NGAYDAT = DateTime.Now; order.DIACHI = address; order.HOTEN = shipName; order.DIENTHOAI = mobile; order.EMAIL = email; try { var id = new FHoaDon().Insert(order); var cart = (List <CartItem>)Session[CartSession]; var detailDao = new FChiTietHD(); decimal total = 0; foreach (var item in cart) { var orderDetail = new CHITIETDONHANG(); orderDetail.MASACH = item.SACH.MASACH; orderDetail.MADONHANG = id; orderDetail.DONGIA = item.SACH.GIABAN; orderDetail.SOLUONG = item.Quantity; detailDao.Insert(orderDetail); total += (item.SACH.GIABAN.GetValueOrDefault(0) * item.Quantity); } } catch (Exception ex) { //ghi log return(RedirectToAction("Failed"));; } return(RedirectToAction("Success")); }
public JsonResult Book(int id, string ship, int soluong) { SANPHAM sanphams = _connect.SANPHAMs.SingleOrDefault(p => p.ID == id); if (sanphams.SOLUONGDAT == null) { sanphams.SOLUONGDAT = soluong; } else { sanphams.SOLUONGDAT = sanphams.SOLUONGDAT + soluong; } JavaScriptSerializer serialzer = new JavaScriptSerializer(); SHIP sp = serialzer.Deserialize <SHIP>(ship); _connect.SHIPs.Add(sp); _connect.SaveChanges(); var arrlast = _connect.SHIPs.Select(p => p).OrderByDescending(p => p.ID).ToArray(); var last = arrlast[0]; DONHANG donhang = new DONHANG(); donhang.IDSHIP = (long)last.ID; donhang.IDSP = id.ToString() + "x" + soluong.ToString(); donhang.NGAYDAT = DateTime.Now; donhang.TONGTIEN = ((Int32)sanphams.GIA - (Int32)(sanphams.GIA * sanphams.SALE / 100)) * soluong; _connect.DONHANGs.Add(donhang); _connect.SaveChanges(); return(Json(new { status = true }, JsonRequestBehavior.AllowGet)); }
public ActionResult DatHang(FormCollection collection) { KHACHHANG kh = (KHACHHANG)Session["TAIKHOAN"]; DONHANG dh = new DONHANG(); List <GioHang> gh = LayGioHang(); dh.MAKH = kh.MAKH; dh.NGAYDAT = DateTime.Now; dh.DATHANHTOAN = Convert.ToString(0); data.DONHANGs.InsertOnSubmit(dh); data.SubmitChanges(); foreach (var item in gh) { CHITIETDONHANG ctdh = new CHITIETDONHANG(); ctdh.MADH = dh.MADH; ctdh.MATRANH = item.iMATRANH; ctdh.SOLUONG = item.iSOLUONG; ctdh.DONGIA = (decimal)item.dTHANHTIEN; data.CHITIETDONHANGs.InsertOnSubmit(ctdh); } data.SubmitChanges(); Session["GioHang"] = null; return(RedirectToAction("XacNhanDonHang", "GioHang")); }
public ActionResult DatHang(FormCollection collection) { //thêm đơn hàng DONHANG dh = new DONHANG(); KHACHHANG kh = (KHACHHANG)Session["TaiKhoan1"]; List <GioHangModels> gh = LayGioHang(); dh.MaKH = kh.MaKH; dh.NgayDat = DateTime.Now; var NgayGiao = String.Format("{0:MM/dd/yyyy}", collection["NgayGiao"]); dh.NgayGiao = DateTime.Parse(NgayGiao); dh.TinhTrangGiaoHang = false; dh.DaThanhToan = false; db.DONHANGs.Add(dh); db.SaveChanges(); //thêm chi tiết đơn hàng foreach (var item in gh) { CHITIETDONHANG ctdh = new CHITIETDONHANG(); ctdh.MaDonHang = dh.MaDonHang; ctdh.MASACHCT = item.iMaSach; ctdh.Soluong = item.iSoLuong; ctdh.DonGia = (float)item.dDongia; db.CHITIETDONHANGs.Add(ctdh); } db.SaveChanges(); Session["GioHang"] = null; return(RedirectToAction("XacNhanDonHang", "GioHang")); }
// Phương thức thêm một đơn hàng public static void AddBill(CusInfoViewModel model, int idKhachHang) { // lấy ra id lớn nhất BANDONGHOEntities db = new BANDONGHOEntities(); DONHANG don = (from dh in db.DONHANGs orderby dh.MADH descending select dh).Take(1).SingleOrDefault(); int id = don == null ? 0:don.MADH; id += 1; // tạo mới đơn hàng DONHANG donhang = new DONHANG { MADH = id, MAKH = idKhachHang, DIACHIGIAO = model.DiaChiGiao, SDT = model.Sdt, MOTA = model.MoTa, TONGTIEN = model.cart.TotalMoney(), TRANGTHAI = "0", NGAYDAT = DateTime.Now, NGAYGIAO = DateTime.Now.AddDays(7) }; db.DONHANGs.Attach(donhang); db.DONHANGs.Add(donhang); db.SaveChanges(); // thêm danh sách chi tiết đơn hàng AddListDetailBill(model.cart, id); }
public string CreateId() { string idcreated = ""; //lấy mã số đơn hàng cuối cùng trong bảng DONHANG lastitem = db.DONHANGs.ToList().Last(); if (lastitem != null) { //tien hanh tach chuoi de lay 3 so cuoi cung string lastitemid = lastitem.MA.ToString(); string idfigure = lastitemid.Substring(1); int figure = int.Parse(idfigure); figure++; if (figure <= 99) // co 2 chu so { idcreated = "A0" + figure; } else { idcreated = "A" + figure; } } else { idcreated = "A001"; } return(idcreated); }
public ActionResult CheckOut(FormCollection collection) { // Thêm đơn hàng DONHANG dh = new DONHANG(); NGUOIDUNG kh = (NGUOIDUNG)Session["TaiKhoan"]; List <ShopCart> sc = GetShopCart(); dh.IDNguoiDung = kh.IDNguoiDung; dh.NgayDatHang = DateTime.Now; var ngaygiao = String.Format("{0:mm/dd/yyy}", collection["NgayGiaoHang"]); dh.NgayGiaoHang = DateTime.Parse(ngaygiao); dh.TrangThai = false; db.DONHANGs.Add(dh); db.SaveChanges(); //thêm chi tiết đơn hàng foreach (var item in sc) { CHITIETDONHANG ctdh = new CHITIETDONHANG(); ctdh.MaDH = dh.MaDH; ctdh.MaSP = item.iMaSP; ctdh.SoLuong = item.iSoLuong; ctdh.TongTien = (decimal)item.dThanhTien; db.CHITIETDONHANGs.Add(ctdh); } db.SaveChanges(); Session["ShopCart"] = null; return(RedirectToAction("ConfirmOrder", "ShopCart")); }
public RedirectToRouteResult UpdateState(DONHANG newStateDH) { try { var check = db.DONHANGs.Where(dh => dh.ID_DONHANG == newStateDH.ID_DONHANG).FirstOrDefault(); check.ID_TRANGTHAI = newStateDH.ID_TRANGTHAI; db.SaveChanges(); int idComplete = db.TRANGTHAIDONHANGs.Where(tt => tt.TEN_TRANGTHAI == "Hoàn thành").FirstOrDefault().ID_TRANGTHAI; if (newStateDH.ID_TRANGTHAI == idComplete) { HOADON newHD = new HOADON(); newHD.ID_TTKH = check.ID_TTKH; newHD.ID_TRANGTHAI = newStateDH.ID_TRANGTHAI; newHD.TONGTIEN = 0; newHD.ID_DONHANG = check.ID_DONHANG; db.HOADONs.Add(newHD); db.SaveChanges(); AutoConvertBill(newStateDH.ID_DONHANG); } // Check if id == hoàn thành thì chuyển thành hóa đơn return(RedirectToRoute(new { controller = "Order", action = "DanhSachDonHang", id = 0 })); } catch (Exception) { return(RedirectToRoute(new { controller = "Order", action = "DanhSachDonHang", id = 0 })); } }
void UpdateTrangThai(string trangThai, string message) { try { int id = Convert.ToInt32(dataGV_DonHang.CurrentRow.Cells[0].Value); DateTime ngayDat = Convert.ToDateTime(dataGV_DonHang.CurrentRow.Cells[4].Value); DONHANG dh = new DONHANG { ID = id, TrangThai = trangThai, NgayDat = ngayDat }; int kq = _donHangDao.Update(dh); if (kq == 1) { MessageBox.Show(message, "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Cập Nhật Trạng Thái Thất Bại", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch { MessageBox.Show("Đường Truyền Bị Lỗi Rồi Đại Vương Ơi", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public DONHANG GetDVByMa(int pMa) { DONHANG result = new DONHANG(); result = context.DONHANGs.FirstOrDefault(m => m.MaHD == pMa); return(result); }
public ActionResult Create([Bind(Include = "DN_ID,TTDH_ID,KH_ID,HTTT_ID,DN_NGALAPDON,DN_GHICHU,DN_SL,DN_SDT,DN_DIACHI,DN_MATHE,DN_CHUTHE,DN_NGAYCAP,DN_EMAIL")] DONHANG dONHANG) { string KH_ID = Request["KH_ID"]; string result = db.Database.SqlQuery <string>("select KH_ID from KhachHang where KH_ID='" + KH_ID + "'").FirstOrDefault(); if (result != null) { if (ModelState.IsValid) { dONHANG.NV_ID = Session["NV_ID"].ToString(); dONHANG.DN_ID = db.autottang("DonHang", "DN_ID", db.DONHANGs.Count()); db.DONHANGs.Add(dONHANG); db.SaveChanges(); return(RedirectToAction("Index")); } } else { ModelState.AddModelError("KH_ID", "Khách hàng không tồn tại"); } ViewBag.HTTT_ID = new SelectList(db.HINHTHUCTHANHTOANs, "HTTT_ID", "HTTT_TEN", dONHANG.HTTT_ID); ViewBag.KH_ID = new SelectList(db.KHACHHANGs, "KH_ID", "KH_TEN", dONHANG.KH_ID); ViewBag.TTDH_ID = new SelectList(db.TRANGTHAIDONHANGs, "TTDH_ID", "TTDH_TEN", dONHANG.TTDH_ID); return(View(dONHANG)); }
public bool SuaDonHang(DONHANG donhang) { try { MyDBContext context = new MyDBContext(); DONHANG DH = context.DONHANGs.Find(donhang.MaDH); if (DH == null) { return(false); } //DH.MaKH = donhang.MaKH; //DH.NgayLap = donhang.NgayLap; DH.TrangThai = donhang.TrangThai; DH.TongTien = donhang.TongTien; //DH.GhiChu = donhang.GhiChu; DH.HoTen = donhang.HoTen; DH.Email = donhang.Email; DH.Diachi = donhang.Diachi; //DH.SDT = donhang.SDT; context.SaveChanges(); return(true); } catch { return(false); } }
//CHỨC NĂNG BUTTOM private void btDaGiaoHang_Click(object sender, EventArgs e) { if (ChonShipper.SelectedItem == null) { XtraMessageBox.Show("Vui lòng chọn Shipper!", "Lỗi!"); } else { try { DONHANG dh = (from a in db.DONHANGs where a.MADH == madh select a).Single(); SHIPPER sp = (from a in db.SHIPPERs where a.MAPT == dh.PHIGH.MAPT && a.TEN == ChonShipper.Text select a).Single(); XtraMessageBox.Show("Chuyển đơn hàng cho " + sp.TEN + " thành công!", "Thông báo"); dh.TTHD = "Đang giao hàng"; dh.PHIGH.MASHIPPER = sp.MASHIPPER; db.SubmitChanges(); fmXemChiTietDonHang_Load(sender, e); } catch (Exception) { throw; } } }
public ActionResult ExportDonHang(int id) { DONHANG donHang = data.DONHANGs.Where(n => n.mahd == id).SingleOrDefault(); KHACHHANG kh = data.KHACHHANGs.Where(n => n.makh == donHang.makh).SingleOrDefault(); List <CHITIETDONHANG> ctdh = data.CHITIETDONHANGs.Where(n => n.mahd == donHang.mahd).ToList(); decimal tong = 0; DataSetDonHang db = new DataSetDonHang(); for (int i = 0; i < ctdh.Count; i++) { SANPHAM sp = data.SANPHAMs.Where(n => n.masanpham == ctdh[i].masp).Single(); db.DataTable1.AddDataTable1Row(donHang.mahd, kh.hoten, sp.masanpham, sp.tensanpham, String.Format("{0:0,0}", ctdh[i].thanhtien / ctdh[i].soluong) + " VNĐ", (int)ctdh[i].soluong, String.Format("{0:0,0}", ctdh[i].thanhtien) + " VNĐ", kh.sdt, kh.email, kh.diachi); tong += (decimal)ctdh[i].thanhtien; } ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/CrystalReports"), "ReportDonHang.rpt")); db.DataTable2.AddDataTable2Row(String.Format("{0:0,0}", tong) + " VNĐ"); rd.SetDataSource(db); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", "DonHang.pdf")); }
public ActionResult DatHang(FormCollection col) { DONHANG dh = new DONHANG(); KHACHHANG kh = (KHACHHANG)Session["TaiKhoan"]; List <GIOHANG> gh = LayGioHang(); dh.MAKH = kh.MAKH; dh.NGAYDAT = DateTime.Now; var ngaygiao = String.Format("{0:MM/dd/yyyy}", col["NgayGiao"]); dh.NGAYGIAO = DateTime.Parse(ngaygiao); dh.TINHTRANGGIAOHANG = "Chưa giao hàng"; dh.TINHTRANGTHANHTOAN = "Chưa thanh toán"; db.DONHANGs.InsertOnSubmit(dh); db.SubmitChanges(); foreach (var item in gh) { CHITIETDONHANG ctdh = new CHITIETDONHANG(); ctdh.MADH = dh.MADH; ctdh.MAHOA = item.mahoa; ctdh.SOLUONG = item.soluong; ctdh.DONGIA = (int)item.dongia; db.CHITIETDONHANGs.InsertOnSubmit(ctdh); } db.SubmitChanges(); Session["GioHang"] = null; return(RedirectToAction("XacNhan", "GioHang")); }
public void insertTHONGKE(DONHANG dh) { List <CHITIETDONHANG> lstCTDH = new DonHangDAO().GetCTDH(dh.ID); foreach (CHITIETDONHANG c in lstCTDH) { THONGKE tk = new THONGKE(); tk.NGAY = (DateTime)dh.NGAYDAT; tk.SANPHAM_ID = c.SANPHAM_ID; List <XUATHANG> lstXH = new XuatHangDAO().GetXuatHang(c.ID); foreach (XUATHANG x in lstXH) { if (!CheckExitsThongke(tk.SANPHAM_ID, tk.NGAY)) { tk.SOLUONGBAN = c.SOLUONG; tk.DOANHTHU = c.SOLUONG * c.DONGIA; tk.LOINHUAN = (x.GIABAN - x.GIANHAP) * x.SOLUONGXUAT; cn.Post <THONGKE>("api/THONGKE/", tk); } else { tk.SOLUONGBAN += c.SOLUONG; tk.DOANHTHU += c.SOLUONG * c.DONGIA; tk.LOINHUAN += (x.GIABAN - x.GIANHAP) * x.SOLUONGXUAT; cn.Put <THONGKE>("api/THONGKE/", tk); } } } }
public ActionResult DatHang(FormCollection collection) { DONHANG dh = new DONHANG(); KHACHHANG kh = (KHACHHANG)Session["Email"]; List <Giohang> gh = LayGioHang(); dh.MaKH = kh.MaKH; dh.NgayLap = DateTime.Now; var NgayGiao = String.Format("{0:MM/dd/yyyy}", collection["NgayGiao"]); dh.NgayGiao = DateTime.Parse(NgayGiao); dh.DaThanhToan = false; dh.ThanhTien = TongTien(); data.DONHANGs.InsertOnSubmit(dh); data.SubmitChanges(); foreach (var item in gh) { CHITIETDONHANG ctdh = new CHITIETDONHANG(); ctdh.MaDH = dh.MaDH; ctdh.MaSP = item.sMaSP; ctdh.Soluong = item.sSoLuong; ctdh.DonGia = (int)item.sDonGia; ctdh.TongCong = ctdh.Soluong * ctdh.DonGia; data.CHITIETDONHANGs.InsertOnSubmit(ctdh); } data.SubmitChanges(); Session["GioHang"] = null; return(RedirectToAction("XacNhanDonHang", "GioHang")); }
protected void btnDatHang_Click(object sender, EventArgs e) { if (Session["GioHang"] != null) { DataTable dtGioHang = (DataTable)Session["GioHang"]; if (Page.IsValid) { KHACHHANG KHACHHANG = new KHACHHANG { HOTEN = txtHoTen.Text, SDT = txtSDT.Text, EMAIL = txtEmail.Text, DIACHI = txtDiaChi.Text, }; DataTable ThongTinKH = DAO.getTable("SELECT * FROM dbo.KHACHHANG WHERE EMAIL='" + txtEmail.Text + "'"); if (ThongTinKH.Rows.Count > 0) { } else { bool result = DAO.InsertKHACHHANG(KHACHHANG); } DataTable dtKhacHang = DAO.getTable("SELECT * FROM dbo.KHACHHANG WHERE EMAIL='" + txtEmail.Text + "'"); string MaKH = dtKhacHang.Rows[0]["MAKH"].ToString(); DateTime NgayDat = DateTime.Now; int MaDH = RanDom(); DONHANG DONHANG = new DONHANG { NGAYDAT = NgayDat, MAKH = MaKH, MADONHANG = MaDH }; bool result1 = DAO.InsertDONHANG(DONHANG); //DataTable dtDonHang = DAO.getTable("SELECT * FROM dbo.DONHANG WHERE MAKH='" + MaKH + "' AND NGAYDATHANG='" + NgayDat + "'"); //string MaDonHang = dtDonHang.Rows[0]["MADONHANG"].ToString(); if (dtGioHang.Rows.Count > 0) { for (int i = 0; i < dtGioHang.Rows.Count; i++) { DataTable dtSanPham = DAO.getTable("SELECT * FROM dbo.SANPHAM WHERE MASP='" + dtGioHang.Rows[i]["MaSanPham"].ToString() + "'"); int SoLuongSP = (int)dtSanPham.Rows[0]["SOLUONG"] - (int)dtGioHang.Rows[i]["SoLuong"]; CHITIETDONHANG CHITIETDONHANG = new CHITIETDONHANG { MADONHANG = MaDH, MASP = dtGioHang.Rows[i]["MaSanPham"].ToString(), SOLUONG = (int)dtGioHang.Rows[i]["SoLuong"] }; DAO.InsertCHITIETDONHANG(CHITIETDONHANG); DAO.UpDate("UPDATE dbo.SANPHAM SET SOLUONG = " + SoLuongSP + ""); } } Session["GioHang"] = null; Response.Write("<script>alert('Đặt hàng thành công. Đơn hàng của bạn đã đực giao cho bộ phận kĩ thuật vui lòng chờ cuộc gọi từ chúng tôi. Cảm ơn!!');</script>"); //Response.Redirect("TrangBanHang.aspx?modul=SanPham&modul1=DanhSachSanPham"); } } }
public int Create(DONHANG order) { connect.SendPostRequest <DONHANG>(order, "api/DONHANG/"); db.DONHANG = connect.DeserializeObject <List <DONHANG> >("api/DONHANG/"); int id = db.DONHANG.Max(x => x.ID); return(id); }
public void XoaDonHang(string madh) { DONHANG dh = new DONHANG(); dh = qltg.DONHANGs.Where(t => t.MaDH == madh).FirstOrDefault(); qltg.DONHANGs.DeleteOnSubmit(dh); qltg.SubmitChanges(); }
public ActionResult Add(DONHANG model) { var DonHang = db.DONHANGs.Find(model.MaDonHang); db.DONHANGs.Add(model); db.SaveChanges(); return(RedirectToAction("Index")); }
public void add(DONHANGModel news_dh) { Mapper.CreateMap <DONHANGModel, DONHANG>(); DONHANG _news_dh = Mapper.Map <DONHANGModel, DONHANG>(news_dh); db.DONHANGs.Add(_news_dh); db.SaveChanges(); }
public ActionResult DeleteConfirmed(int id) { DONHANG dONHANG = db.DONHANGs.Find(id); db.DONHANGs.Remove(dONHANG); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult AddressAndPayment(FormCollection values) { var donHang = new DONHANG(); var ctDonHang = new CHITIETDONHANG(); TryUpdateModel(ctDonHang); TryUpdateModel(donHang); try { donHang.MaTK = Request.Cookies["MaTK"]["MaTK"]; donHang.MaDH = (db.LaySoLuongDonHang() + 1).ToString(); donHang.UserName = values["UserName"]; donHang.NgayDatHang = DateTime.Now; donHang.MaTT = "TT01"; string thanhPho = values["ThanhPho"]; string quan = values["Quan"]; string phuong = values["Phuong"]; string diaChi = values["DiaChi"]; donHang.DiaChi = diaChi + " " + phuong + " " + quan + " " + thanhPho; donHang.Email = values["Email"]; donHang.MaHTTT = "TT"; donHang.MaTK = null; donHang.SDT = values["SDT"]; donHang.TenNguoiNhan = values["Ten"]; donHang.TongTien = Decimal.Parse(values["TongTien"]); ctDonHang.DonGia = Decimal.Parse(values["DonGia"]); ctDonHang.MaDH = donHang.MaDH; ctDonHang.MaSP = donHang.MaDH; db.DONHANGs.Add(donHang); db.SaveChanges(); var cart = ShoppingCart.GetCart(this.HttpContext); cart.TaoDonHang(donHang); return RedirectToAction("Complete", new { id = donHang.MaDH }); //} } catch (System.Exception ex) { return View(donHang); } }
public string TaoDonHang(DONHANG donHang) { decimal TongTien = 0; var cartItems = GetCartItems(); foreach (var item in cartItems) { var ctDonHang = new CHITIETDONHANG { MaSP = item.MaSP, MaDH = donHang.MaDH, DonGia = item.SanPham.GiaBan, SoLuong = item.Count }; TongTien += (item.Count * item.SanPham.GiaBan) ?? 0; db.CHITIETDONHANGs.Add(ctDonHang); } donHang.TongTien = TongTien; db.SaveChanges(); EmptyCart(); return donHang.MaDH; }