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());
}
