public List <ChiTietDonDat> GetDataSanPham(int MaDonDatHang) { try { List <ChiTietDonDat> dsChiTietDonDat = new List <ChiTietDonDat>(); DataTable dt = dataProvider.ExecuteQuery("proc_getdata_chitietdondat_sanpham", new object[] { MaDonDatHang }, new List <string>() { "MaDonDatHang" }); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { ChiTietDonDat chiTietDonDat = new ChiTietDonDat(); chiTietDonDat.MaDonDatHang = String.IsNullOrEmpty(row["MaDonDatHang"].ToString()) ? 0 : int.Parse(row["MaDonDatHang"].ToString()); chiTietDonDat.MaSanPham = String.IsNullOrEmpty(row["MaSanPham"].ToString()) ? 0 : int.Parse(row["MaSanPham"].ToString()); chiTietDonDat.SoLuong = String.IsNullOrEmpty(row["SoLuong"].ToString()) ? 0 : int.Parse(row["SoLuong"].ToString()); chiTietDonDat.TenSanPham = String.IsNullOrEmpty(row["TenSanPham"].ToString()) ? "" : row["TenSanPham"].ToString(); chiTietDonDat.HinhAnh = String.IsNullOrEmpty(row["HinhAnh"].ToString()) ? "" : row["HinhAnh"].ToString(); chiTietDonDat.Gia = String.IsNullOrEmpty(row["Gia"].ToString()) ? 0 : float.Parse(row["Gia"].ToString()); dsChiTietDonDat.Add(chiTietDonDat); } return(dsChiTietDonDat); } return(new List <ChiTietDonDat>()); } catch (Exception ex) { return(new List <ChiTietDonDat>()); } }
//Xóa giỏ hàng public ActionResult XoaGioHang(int MaSP) { //Kiểm tra mssp SanPham sp = db.SanPhams.SingleOrDefault(n => n.MaSP == MaSP); if (sp == null) { Response.StatusCode = 404; return(null); } //Lấy giỏ hàng ra từ session List <ChiTietDonDat> lstGioHang = LayGioHang(); //Kiểm tra sp có tồn tại trong session["GioHang"] ChiTietDonDat donHang = lstGioHang.SingleOrDefault(n => n.iMaSP == MaSP); //Nếu mà tồn tại thì xóa hết if (donHang != null) { lstGioHang.RemoveAll(n => n.iMaSP == MaSP); } if (lstGioHang.Count == 0) { return(RedirectToAction("Index", "Home")); } return(RedirectToAction("Index")); }
//Thêm giỏ hàng public ActionResult ThemGioHang(int MaSP, string strUrl) { //Kiểm tra xem SanPham có tồn tại người dùng thao tác trên đường dẫn tự tạo SanPham sp = db.SanPhams.SingleOrDefault(n => n.MaSP == MaSP); if (sp == null) { Response.StatusCode = 404; return(null); } //Lấy ra session giỏ hàng List <ChiTietDonDat> lstGioHang = LayGioHang(); //Sản phẩm mua chưa đã tồn tại trong session ChiTietDonDat gioHang = lstGioHang.Find(n => n.iMaSP == MaSP); if (gioHang == null) { gioHang = new ChiTietDonDat(MaSP); lstGioHang.Add(gioHang); return(Redirect(strUrl)); } else { gioHang.iSoLuong++; return(Redirect(strUrl)); } }
public List <ChiTietDonDat> GetData() { try { List <ChiTietDonDat> dsChiTietDonDat = new List <ChiTietDonDat>(); DataTable dt = dataProvider.ExecuteQuery("Proc_ChiTietDonDat_GetData", null, null); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { ChiTietDonDat chiTietDonDat = new ChiTietDonDat(); chiTietDonDat.MaDonDatHang = String.IsNullOrEmpty(row["MaDonDatHang"].ToString()) ? 0 : int.Parse(row["MaDonDatHang"].ToString()); chiTietDonDat.MaSanPham = String.IsNullOrEmpty(row["MaSanPham"].ToString()) ? 0 : int.Parse(row["MaSanPham"].ToString()); chiTietDonDat.SoLuong = String.IsNullOrEmpty(row["SoLuong"].ToString()) ? 0 : int.Parse(row["SoLuong"].ToString()); chiTietDonDat.Gia = String.IsNullOrEmpty(row["Gia"].ToString()) ? 0 : int.Parse(row["Gia"].ToString()); dsChiTietDonDat.Add(chiTietDonDat); } return(dsChiTietDonDat); } return(new List <ChiTietDonDat>()); } catch (Exception ex) { return(new List <ChiTietDonDat>()); } }
public JsonResult ThemHoaDonSanPham(string HoTenNguoiNhan, string SoDienThoaiNguoiNhan, string DiaChiGiaoHang, string HinhThucThanhToan, string TrangThai, List <GioHangItem> cartModel) { DonDatHangModel donDatHangModel = new DonDatHangModel(); DonDatHang donDatHang = new DonDatHang(); if (Session["ADMIN_SESSION"] != null) { NhanVien nhanVien = new NhanVienModel().GetNhanVienByEmail(Session["ADMIN_SESSION"].ToString()); donDatHang.MaNV = nhanVien.MaNV; } donDatHang.HoTenNguoiNhan = HoTenNguoiNhan; donDatHang.SoDTGiaoHang = SoDienThoaiNguoiNhan; donDatHang.DiaChiNhanHang = DiaChiGiaoHang; donDatHang.HinhThucThanhToan = HinhThucThanhToan; donDatHang.TrangThaiDonSanPham = Convert.ToInt32(TrangThai); donDatHang.NgayTao = DateTime.Now; donDatHang.TrangThaiDonDichVu = 0; string MaDonHang = donDatHangModel.ThemDonDatHang(donDatHang); ChiTietDonDatModel chiTietDonDatModel = new ChiTietDonDatModel(); foreach (var item in cartModel) { ProductModel productModel = new ProductModel(); SanPham sp = productModel.GetSanPhamByMa(item.sanpham.MaSanPham); ChiTietDonDat chiTietDonDat = new ChiTietDonDat(); chiTietDonDat.MaDonDatHang = Convert.ToInt32(MaDonHang); chiTietDonDat.SoLuong = item.SoLuong; chiTietDonDat.MaSanPham = item.sanpham.MaSanPham; chiTietDonDat.Gia = sp.Gia; chiTietDonDatModel.ThemChiTietDonDat(chiTietDonDat); } donDatHangModel.CapNhatTongTien(Convert.ToInt32(MaDonHang)); string Message = "Thanh cong"; return(Json(Message, JsonRequestBehavior.AllowGet)); }
public string ThemChiTietDonDat(ChiTietDonDat chiTietDonDat) { try { string rs = ""; rs = dataProvider.ExecuteScalar("Proc_ChiTietDonDat_Insert", new object[] { chiTietDonDat.MaDonDatHang, chiTietDonDat.MaSanPham, chiTietDonDat.SoLuong, chiTietDonDat.Gia }, new List <string>() { "@MaDonDatHang", "@MaSanPham", "@SoLuong", "@Gia" }); return(rs); } catch (Exception ex) { return(""); } }
//Cập nhật giỏ hàng public ActionResult CapNhatGioHang(int MaSP, FormCollection f) { //Kiểm tra mssp SanPham sp = db.SanPhams.SingleOrDefault(n => n.MaSP == MaSP); if (sp == null) { Response.StatusCode = 404; return(null); } //Lấy giỏ hàng ra từ session List <ChiTietDonDat> lstGioHang = LayGioHang(); //Kiểm tra sp có tồn tại trong session["GioHang"] ChiTietDonDat donHang = lstGioHang.SingleOrDefault(n => n.iMaSP == MaSP); if (donHang != null) { donHang.iSoLuong = int.Parse(f["txtSoLuong"].ToString()); } return(RedirectToAction("Index")); }
public ChiTietDonDat GetChiTietDonDatByMa(int MaDonDatHang) { try { ChiTietDonDat chiTietDonDat = null; DataTable dt = dataProvider.ExecuteQuery("Proc_ChiTietDonDat_GetData", new object[] { MaDonDatHang }, new List <string>() { "MaDonDatHang" }); if (dt != null && dt.Rows.Count > 0) { var row = dt.Rows[0]; chiTietDonDat.MaDonDatHang = String.IsNullOrEmpty(row["MaDonDatHang"].ToString()) ? 0 : int.Parse(row["MaDonDatHang"].ToString()); chiTietDonDat.MaSanPham = String.IsNullOrEmpty(row["MaSanPham"].ToString()) ? 0 : int.Parse(row["MaSanPham"].ToString()); chiTietDonDat.SoLuong = String.IsNullOrEmpty(row["SoLuong"].ToString()) ? 0 : int.Parse(row["SoLuong"].ToString()); chiTietDonDat.Gia = String.IsNullOrEmpty(row["Gia"].ToString()) ? 0 : float.Parse(row["Gia"].ToString()); } return(chiTietDonDat); } catch (Exception ex) { return(null); } }
public ActionResult DatHang() { string makh = ""; string tennguoinhan = Request.Form["shipName"]; string sodienthoainhanhang = Request.Form["mobile"]; string diachi = Request.Form["address"]; DonDatHang donDatHang = new DonDatHang(); donDatHang.DiaChiNhanHang = diachi; donDatHang.SoDTGiaoHang = sodienthoainhanhang; donDatHang.HoTenNguoiNhan = tennguoinhan; donDatHang.HinhThucThanhToan = "COD"; if (Session["CART_SESSION"] != null) { if (Session["USER_SESSION"] != null) { var sdtkh = Session["USER_SESSION"].ToString(); int sdtkhnhan = Convert.ToInt32(sdtkh); Khachhang kh = new KhachHangModel().GetKhachHangBySDT(sdtkhnhan); makh = kh.MaKH.ToString(); } var cart = Session["CART_SESSION"]; var list = new List <GioHangItem>(); if (cart != null) { list = (List <GioHangItem>)cart; } if (makh != "" & makh != null) { donDatHang.MaKH = Convert.ToInt32(makh); } donDatHang.TrangThaiDonSanPham = 1; donDatHang.TrangThaiDonDichVu = 0; donDatHang.NgayTao = DateTime.Now; string madondathang = donDatHangModel.ThemDonDatHang(donDatHang); if (madondathang != null) { foreach (var item in list) { SanPham sanPham = new SanPham(); ProductModel productModel = new ProductModel(); ChiTietDonDat chiTietDonDat = new ChiTietDonDat(); chiTietDonDat.MaDonDatHang = Convert.ToInt32(madondathang); chiTietDonDat.SoLuong = item.SoLuong; chiTietDonDat.MaSanPham = item.sanpham.MaSanPham; chiTietDonDat.Gia = item.sanpham.Gia; chiTietDonDatModel.ThemChiTietDonDat(chiTietDonDat); } } donDatHangModel.CapNhatTongTien(Convert.ToInt32(madondathang)); } Session["CART_SESSION"] = null; Session["SLSP_SESSION"] = null; return(View()); }