public ActionResult Create(DonDatHang dondathangs) { HttpResponseMessage response = client.PostAsJsonAsync(url + @"dondathang/", dondathangs).Result; response.EnsureSuccessStatusCode(); if (response.IsSuccessStatusCode) { ViewBag.Detail = "Sucess"; } return(RedirectToAction("Index")); }
public ActionResult DatHang(KhachHang kh) { //Kiểm tra session giỏ hàng tồn tại chưa if (Session["GioHang"] == null) { return(RedirectToAction("Index", "Home")); } KhachHang khachHang = new KhachHang(); //Đổi với khác hàng không đăng nhập if (Session["TaiKhoan"] == null) { khachHang = kh; db.KhachHangs.Add(khachHang); db.SaveChanges(); } //Đổi với khác hàng đã đăng nhập else { AspNetUser thanhVien = Session["TaiKhoan"] as AspNetUser; khachHang.Email = thanhVien.Email; khachHang.TenKH = thanhVien.Name; khachHang.DiaChi = thanhVien.Address; khachHang.SoDienThoai = thanhVien.PhoneNumber; db.KhachHangs.Add(khachHang); db.SaveChanges(); } //Thêm đơn hàng DonDatHang ddh = new DonDatHang(); ddh.NgayDat = DateTime.Now; ddh.TinhTrangGiaoHang = false; ddh.DaThanhToan = false; ddh.IdKhachHang = khachHang.MaKH; db.DonDatHangs.Add(ddh); db.SaveChanges(); //Thêm chi tiết đơn đặt hàng List <ItemGioHang> lstGH = LayGioHang(); foreach (var item in lstGH) { ChiTietDonDatHang ctdh = new ChiTietDonDatHang(); ctdh.MaDDH = ddh.MaDDH; ctdh.MaSP = item.MaSP; ctdh.TenSP = item.TenSP; ctdh.SoLuong = item.SoLuong; ctdh.DonGia = item.DonGia; db.ChiTietDonDatHangs.Add(ctdh); } db.SaveChanges(); Session["GioHang"] = null; return(RedirectToAction("XemGioHang")); }
public ActionResult DuyetDon(DonDatHang ddh) { DonDatHang ddhupdate = db.dondathangs.SingleOrDefault(c => c.MaDDH == ddh.MaDDH); ddhupdate.DaGiao = ddh.DaGiao; ddhupdate.DaThanhToan = ddh.DaThanhToan; ddhupdate.NgayGiao = DateTime.Now; db.SaveChanges(); ViewBag.lstchitiet = db.chitietdondathangs.Where(c => c.MaDDH == ddh.MaDDH).ToList(); return(View(ddhupdate)); }
public ActionResult Edit([Bind(Include = "IdDDH,Dathanhtoan,Tinhtranggiaohang,Ngaydat,Ngaygiao,MaKH")] DonDatHang donDatHang) { if (ModelState.IsValid) { db.Entry(donDatHang).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaKH = new SelectList(db.Accounts, "MaKH", "TenKH", donDatHang.MaKH); return(View(donDatHang)); }
// GET: api/DonDatHangs/5 public async Task <IHttpActionResult> GetDonDatHang(int id) { DonDatHang donDatHang = await db.DonDatHangs.FindAsync(id); if (donDatHang == null) { return(NotFound()); } return(Ok(donDatHang)); }
// GET: DonDatHang/Edit/5 public async Task <ActionResult> Edit(int?id) { DonDatHang donDatHangs = null; HttpResponseMessage response = await client.GetAsync(url + @"dondathang/" + id); if (response.IsSuccessStatusCode) { donDatHangs = await response.Content.ReadAsAsync <DonDatHang>(); } return(View(donDatHangs)); }
public ActionResult ThanhToan(int tongtien, string GhiChu) { if (Session["BiKhoa"] != null) { return(RedirectToAction("LogOffs", "Account")); } //Tạo đơn đặt hàng string strID = null; strID = User.Identity.GetUserId(); DonDatHang ddh = new DonDatHang(); int slddh = db.DonDatHangs.Count(); string Maddh = "DDH0" + slddh; ddh.MaDonDatHang = Maddh; ddh.NgayLap = DateTime.Now; ddh.TongThanhTien = tongtien; ddh.MaTinhTrang = 1; ddh.UserID = strID; ddh.GhiChu = GhiChu; //Lưu đơn đặt hàng xuống DB //Tạo chi tiết đơn đặt hàng ChiTietDonDatHang ct = null; SanPham sp = null; var cart = (List <CartItem>)Session[CartSession]; int slct = 0; string Mactdh = null; int k = 1; foreach (var item in cart) { ct = new ChiTietDonDatHang(); slct = db.ChiTietDonDatHangs.Count(); slct += k; k++; Mactdh = "CTDH" + k; ct.MaChiTietDonDatHang = Mactdh; ct.SoLuong = item.soluong; ct.GiaBan = item.sanpham.GiaSanPham * ct.SoLuong; ct.MaSanPham = item.sanpham.MaSanPham; sp = db.SanPhams.Single(s => s.MaSanPham == ct.MaSanPham); sp.SoLuongTon -= ct.SoLuong; sp.SoLuongBan += ct.SoLuong; ddh.ChiTietDonDatHangs.Add(ct); } db.DonDatHangs.Add(ddh); db.SaveChanges(); Session[CartSession] = null; //--\\ return(View()); }
public bool DonDatHang_Insert(DonDatHang inp) { try { return(DonDatHang_bus.Insert(inp)); } catch (Exception ex) { throw ex; } }
public bool DonDatHang_Update(DonDatHang inp) { try { return(DonDatHang_bus.Update(inp)); } catch (Exception ex) { throw ex; } }
//Đặt hàng public ActionResult DatHang(KhachHang kh) { //Kiểm tra sp có tồn tai trong csdl hay không if (Session["GioHang"] == null) { return(RedirectToAction("Index", "Home")); } KhachHang khang = new KhachHang(); if (Session["TaiKhoan"] == null) { //Thêm khach hang vao bang khach hang dối với kh vảng lai khang = kh; db.KhachHangs.Add(khang); db.SaveChanges(); } else { //Đối với KH là thành viên ThanhVien tv = Session["TaiKhoan"] as ThanhVien; khang.TenKH = tv.HoTen; khang.DiaChi = tv.DiaChi; khang.Email = tv.Email; khang.SoDienThoai = tv.SoDienThoai; db.KhachHangs.Add(khang); db.SaveChanges(); } //Thêm đơn hàng DonDatHang ddh = new DonDatHang(); ddh.MaKH = khang.MaKH; ddh.NgayDat = DateTime.Now; ddh.TinhTrangDonHang = false; ddh.DaThanhToan = false; ddh.UuDai = 0; db.DonDatHangs.Add(ddh); db.SaveChanges(); //Thêm chi tiết đơn đặt hàng List <ItemGioHang> lst = LayGioHang(); foreach (var item in lst) { ChiTietDonDatHang ctddh = new ChiTietDonDatHang(); ctddh.MaDDH = ddh.MaDDH; ctddh.MaSP = item.MaSP; ctddh.TenSP = item.TenSP; ctddh.SoLuong = item.SoLuong; ctddh.DonGia = item.DonGia; db.ChiTietDonDatHangs.Add(ctddh); } db.SaveChanges(); Session["GioHang"] = null; return(RedirectToAction("XemGioHang")); }
public DataSet DonDatHang_GetDonHang(DonDatHang inp, string swhere) { try { return(DonDatHang_bus.GetDonHang(inp, swhere)); } catch (Exception ex) { throw ex; } }
public IHttpActionResult GetDonDatHang(int id) { DonDatHang donDatHang = db.DonDatHangs.Find(id); if (donDatHang == null) { return(NotFound()); } return(Ok(donDatHang)); }
public void luu(int mancc, int manv, DateTime ngaydat) { DonDatHang dhs = new DonDatHang(); dhs.MaNCC = mancc; dhs.MaNV = manv; dhs.NgayNhap = ngaydat; ql.DonDatHangs.InsertOnSubmit(dhs); ql.SubmitChanges(); }
public RedirectToRouteResult ThanhToan(DonDatHang dh) { if (ModelState.IsValid) { KhachHang kh = (KhachHang)Session["kh"]; dh.MaKH = kh.MaKhachHang; db.DonDatHangs.Add(dh); db.SaveChanges(); } return(RedirectToAction("DonHang", new { maDH = dh.MaDH })); }
public ActionResult Edit([Bind(Include = "MaDH,MaKH,NgayDH,NgayGH,DiaChiNhan,SDTNhan,HTGH,HTTT,TinhTrangGH,TongThanhToan")] DonDatHang donDatHang) { if (ModelState.IsValid) { db.Entry(donDatHang).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKhachHang", "TenKhachHang", donDatHang.MaKH); return(View(donDatHang)); }
public async Task <ActionResult> DuyetDonHang([Bind(Include = "MaDonDatHang,NgayDat,NgayGiao,TenKhach,DiaChi,SoDienThoai,DaHuy,TinhTrangGiaoHang,DaXoa,DaThanhToan")] DonDatHang donDatHang) { if (ModelState.IsValid) { db.Entry(donDatHang).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("ChuaGiao")); } return(View(donDatHang)); }
public ActionResult Edit([Bind(Include = "MaDDH,NgayDat,TinhTrang,MaKH,UuDai,NVGiaoHang,TinhTrangGH,TongTien")] DonDatHang donDatHang) { if (ModelState.IsValid) { db.Entry(donDatHang).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("DonHangDaDuyet", "DonDatHangs")); } ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH", donDatHang.MaKH); return(RedirectToAction("DonHangDaDuyet", "DonDatHangs")); }
public ActionResult DeleteOrder(int id) { if (Session["isAdmin"] != null && Session["isAdmin"].ToString() == "1") { DonDatHang ddh = db.DonDatHangs.Find(id); db.DonDatHangs.Remove(ddh); db.SaveChanges(); return(RedirectToAction("Index")); } TempData["myMessage"] = "Bạn cần đăng nhập bằng tài khoản Admin để xe được trang này (^_^)"; return(Redirect("~")); }
public ActionResult edit([Bind(Include = "MaDon,NgayDat,TenNguoiDat,DiaChiGiaoHang,SoDienThoai,Email,MaNV,MaKH,TrangThai")] DonDatHang donDatHang) { if (ModelState.IsValid) { db.Entry(donDatHang).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaKH = new SelectList(db.KhachHang, "MaKH", "HoTenKH", donDatHang.MaKH); ViewBag.MaNV = new SelectList(db.NhanVien, "MaNV", "HoNV", donDatHang.MaNV); return(View(donDatHang)); }
// Hien Thi Ten San Pham Theo Ma San Pham public DataTable HienThiTenSpTheoMaSp(DonDatHang dh) { var result = donDatHangDAL.sp_HienThiTenSPTheoMaSP(dh.MaSp); DataTable table = new DataTable(); table.Columns.Add("TENSP", typeof(string)); foreach (sp_HienThiTenSPTheoMaSPResult sp in result) { table.Columns.Add(sp.TENSP); } return(table); }
public ActionResult DuyetDonHang(DonDatHang ddh) { DonDatHang ddhUpdate = db.DonDatHangs.Single(x => x.MaDDH == ddh.MaDDH); ddhUpdate.DaThanhToan = ddh.DaThanhToan; ddhUpdate.TinhTrang = ddh.TinhTrang; db.SaveChanges(); GuiEmail("Xác nhận đơn hàng", "*****@*****.**", "*****@*****.**", "thangbach1995", "Don hang duoc xac nhan"); return(RedirectToAction("ChuaThanhToan")); }
public ActionResult Create([Bind(Include = "MaDDH,NgayDat,TinhTrang,MaKH,UuDai,NVGiaoHang,TinhTrangGH,TongTien")] DonDatHang donDatHang) { if (ModelState.IsValid) { db.DonDatHangs.Add(donDatHang); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH", donDatHang.MaKH); return(View(donDatHang)); }
public IHttpActionResult PostDonDatHang(DonDatHang donDatHang) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.DonDatHangs.Add(donDatHang); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = donDatHang.MaDonHang }, donDatHang)); }
// Hiển Thị Tên Nhà Cung Theo Mã Cung Câp public DataTable ShowTenCCFlowMaCC(DonDatHang dh) { var result = donDatHangDAL.sp_HienThiTenCCTheoMaCC(dh.MaCc); DataTable table = new DataTable(); table.Columns.Add("TENCC", typeof(string)); foreach (sp_HienThiTenCCTheoMaCCResult ncc in result) { table.Columns.Add(ncc.TENCC); } return(table); }
public ActionResult XoaDonHang(int id) { DonDatHang sp = data.DonDatHangs.SingleOrDefault(n => n.MaDonDatHang == id); //ViewBag.MaSanPham = sp.MaSanPham; if (sp == null) { Response.StatusCode = 404; return(null); } return(View(sp)); }
public KhachHangDTO GetCustomerByOrderId(string id) { DonDatHang order = db.DonDatHang.Where(o => o.Id == id).FirstOrDefault(); return(db.KhachHang.Where(c => c.Id == order.IdKh).Select(s => new KhachHangDTO { Id = s.Id, TenKh = s.TenKh, DiaChi = s.DiaChi, Email = s.Email, SoDienThoai = s.SoDienThoai }).FirstOrDefault()); }
public ActionResult XemGioHang(KhachHang khachhang, FormCollection f) { if (Session["Email"] == null) { return(RedirectToAction("Login", "User")); } if (Session["GioHang"] == null) { return(RedirectToAction("Index", "Home")); } KhachHang KH = (KhachHang)Session["Email"]; // thêm đơn hàng DonDatHang ddh = new DonDatHang(); //ddh.IdKH = int.Parse(KH.IdKH.ToString()); List <ItemGioHang> lstGH = LayGioHang(); ddh.IdKH = KH.IdKH; ddh.NguoiNhan = f["TenKhachHang"]; ddh.DiaChiNguoiNhan = f["DiaChi"]; ddh.SdtNguoiNhan = f["SoDienThoai"]; ddh.NgayDat = DateTime.Now; ddh.TinhTrangGiaoHang = false; ddh.DaThanhToan = false; ddh.DaHuy = false; ddh.DaXoa = false; db.DonDatHangs.Add(ddh); db.SaveChanges(); // thêm chi tiết đơn đặt hàng decimal tong = 0; decimal thanhtien = 0; foreach (var item in lstGH) { ChiTietDonDatHang ctdh = new ChiTietDonDatHang(); ctdh.IdDDH = ddh.IdDDH; ctdh.IdSanPham = item.IdSanPham; ctdh.SoLuong = (int)item.SoLuong; ctdh.DonGia = (decimal)item.DonGia; thanhtien = item.SoLuong * item.DonGia; tong += thanhtien; db.ChiTietDonDatHangs.Add(ctdh); db.SaveChanges(); } ddh.TongTien = tong; UpdateModel(ddh); db.SaveChanges(); Session["GioHang"] = null; return(View("ThongBao1")); }
public ActionResult DatHang(FormCollection f) { if(Session["TaiKhoan"] == null || Session["TaiKhoan"].ToString() == "") { return RedirectToAction("Dangky","Customer"); } if(Session["ShoppingCart"] == null) { return RedirectToAction("Index","Home"); } ViewBag.listSC = GetShoppingCart(); DonDatHang ddh = new DonDatHang(); Customer kh = (Customer)Session["TaiKhoan"]; List<ShoppingCart> listSC = GetShoppingCart(); ddh.tinhtrang = 1; ddh.idkhachhang = kh.id; ddh.ngaydathang = DateTime.Now; ddh.tongtien = (int)TongTien(); int check = db.insertDonDatHang(ddh); int id = db.getDonDatHang(ddh.idkhachhang, ddh.ngaydathang); if(check == 1) { foreach (var item in listSC) { CTDonDatHang ct = new CTDonDatHang(); ct.iddonhang = id; ct.idsanpham = item.MaSP; ct.soluong = item.SoLuong; ct.size = item.Size; int check1 = db.insertCTDonDatHang(ct); if( check1 == 1) { KhoHang kho = new KhoHang(); kho.soluong = item.SoLuong; kho.idsanpham = item.MaSP; kho.size = item.Size; db.UpdateKhoHang(kho); } } } kh.tenkh = f.Get("txtHoTen").ToString(); kh.diachikh = f.Get("txtDiaChi").ToString(); kh.email = f.Get("txtEmail").ToString(); kh.dienthoai = f.Get("txtSdt").ToString(); int updateCustomer = db.updateCustomer(kh); if (updateCustomer != 1) { return RedirectToAction("ThongTinDonHang", "ShoppingCart"); } Session["ShoppingCart"] = null; return RedirectToAction("Index","Home"); }
public ActionResult DatHang(KhachHang kh) { if (Session["GioHang"] == null) { return(RedirectToAction("Index", "Home")); } KhachHang KhachHang = new KhachHang(); if (Session["TaiKhoan"] == null) { //Them khach hàng vào bảng khách hàng KhachHang = kh; db.KhachHangs.Add(KhachHang); db.SaveChanges(); } else { // khách hàng là thành viên ThanhVien tv = Session["TaiKhoan"] as ThanhVien; KhachHang.TenKH = tv.Hoten; KhachHang.DiaChi = tv.DiaChi; KhachHang.Email = tv.Email; KhachHang.SoDienThoai = tv.SoDienThoai; db.KhachHangs.Add(KhachHang); } // thêm đơn đặt DonDatHang ddh = new DonDatHang(); ddh.MaKH = KhachHang.MaKH; ddh.NgayDat = DateTime.Now; ddh.TinhTrangGiaoHang = false; ddh.DaThanhToan = false; ddh.UuDai = 0; db.DonDatHangs.Add(ddh); db.SaveChanges(); // Lấy giỏ hàng List <ItemGioHang> lshGH = LayGioHang(); foreach (var item in lshGH) { ChiTietDonDatHang ctddh = new ChiTietDonDatHang(); ctddh.MaDDH = ddh.MaDDH; ctddh.MaSP = item.MaSP; ctddh.TenSP = item.TenSP; ctddh.SoLuong = item.SoLuong; ctddh.DonGia = item.DonGia; db.ChiTietDonDatHangs.Add(ctddh); } db.SaveChanges(); Session["GioHang"] = null; return(RedirectToAction("XemGioHang")); }
public IHttpActionResult getHoaDon(int id) //id { try { HienThiDonHang ctDonHang = new HienThiDonHang(); string diaChi = ""; DonDatHang donHang = db.DonDatHangs.FirstOrDefault(x => x.id_don_hang == id); DiaChiKhachHang dc = db.DiaChiKhachHangs.FirstOrDefault(x => x.id == donHang.id_dia_chi); TinhThanh tinh = db.TinhThanhs.FirstOrDefault(x => x.ma_tinh == dc.id_tinh); QuanHuyen quan = db.QuanHuyens.FirstOrDefault(x => x.ma_quan_huyen == dc.id_quan); XaPhuong xa = db.XaPhuongs.FirstOrDefault(x => x.ma_xa_phuong == dc.id_xa_phuong); if (donHang == null) { return(StatusCode(HttpStatusCode.NoContent)); } ctDonHang.idDonDatHang = donHang.id_don_hang; ctDonHang.trangThai = db.TinhTrangDonHangs.FirstOrDefault(x => x.id_tinh_trang == donHang.id_tinh_trang).tinh_trang_don_hang; ctDonHang.ngayLap = donHang.ngay_lap.ToShortDateString(); ctDonHang.tenNguoiNhan = db.KhachHangs.FirstOrDefault(x => x.id_khach_hang == donHang.id_khach_hang).ten_nguoi_dung; ctDonHang.soDT = "0" + donHang.so_dt_nguoi_nhan; diaChi = "" + dc.dia_chi + ", " + xa.ten + ", " + quan.ten_quan_huyen + ", " + tinh.ten; ctDonHang.diaChi = diaChi; // add danh sach san pham List <ChiTietDonHang> list = db.ChiTietDonHangs.Where(x => x.id_don_hang == id).ToList(); List <DSSanPham> lDanhSanPham = new List <DSSanPham>(); for (int i = 0; i < list.Count; i++) { DSSanPham dsp = new DSSanPham(); dsp.soLuong = list[i].so_luong; dsp.tongGia = (float)list[i].tong_tien; dsp.giaKM = (float)list[i].gia_km; //gan san pham SanPham tam = db.SanPhams.FirstOrDefault(x => x.id_san_pham == list[i].id_san_pham); SanPham sp = new SanPham(); sp.id_san_pham = tam.id_san_pham; sp.id_danh_muc = tam.id_danh_muc; sp.mo_ta = tam.mo_ta; sp.phan_tram_km = tam.phan_tram_km; sp.ten_sp = tam.ten_sp; sp.url_hinh_chinh = "http://www.3anhem.somee.com" + tam.url_hinh_chinh; sp.gia_sp = tam.gia_sp; sp.gia_km = tam.gia_km; dsp.sanPham = sp; lDanhSanPham.Add(dsp); } ctDonHang.danhSachHang = lDanhSanPham; return(Ok(ctDonHang)); }catch (Exception ex) { return(BadRequest(ex.Message)); } }
public ActionResult DaDuyet1(int MaDonDatHang = 0) { DonDatHang ddh = data.DonDatHangs.SingleOrDefault(n => n.MaDonDatHang == MaDonDatHang); if (ddh == null) { Response.StatusCode = 404; return(null); } ddh.MaTinhTrang = 3; data.SubmitChanges(); return(Redirect("QuanLyDonHangDaDyet")); }
/// <summary> /// Create a new DonDatHang object. /// </summary> /// <param name="datHang_ID">Initial value of DatHang_ID.</param> public static DonDatHang CreateDonDatHang(int datHang_ID) { DonDatHang donDatHang = new DonDatHang(); donDatHang.DatHang_ID = datHang_ID; return donDatHang; }
/// <summary> /// There are no comments for DonDatHang in the schema. /// </summary> public void AddToDonDatHang(DonDatHang donDatHang) { base.AddObject("DonDatHang", donDatHang); }