// GET: DetailProduct
public ActionResult DetailProduct(int product_id)
{
try
{
TblSanPhamDao _sanPhamDao = new TblSanPhamDao();
Tbl_imageDao _imageDao = new Tbl_imageDao();
List <Tbl_image> _listImageProduct = new List <Tbl_image>();
Tbl_sanpham _product = new Tbl_sanpham();
if (product_id != 0)
{
_product = _sanPhamDao.GetProductWithID(product_id);
_listImageProduct = _imageDao.GetListImage(product_id);
string _size = _product._size;
string[] _listSize = _size.Split('-');
int _first_size = Int32.Parse(_listSize.First());
int _last_size = Int32.Parse(_listSize.Last());
// đẩy dữ liệu sang FE
ViewBag._product = _product;
ViewBag._listImageProduct = _listImageProduct;
ViewBag._first_size = _first_size;
ViewBag._last_size = _last_size;
}
return(View());
}
catch
{
// chuyển sang màn hình thông báo lỗi hệ thống
return(RedirectToAction("Error", "ErrorProduct"));
}
}
public ActionResult Remove(Tbl_sanpham sanpham)
{
List <Tbl_sanpham> li = (List <Tbl_sanpham>)Session["cart"];
li.RemoveAll(x => x._masp == sanpham._masp);
Session["cart"] = li;
Session["count"] = Convert.ToInt32(Session["count"]) - 1;
return(RedirectToAction("Myorder", "AddToCart"));
//return View();
}
public Tbl_sanpham GetProductWithID(int _masp)
{
Tbl_sanpham product = new Tbl_sanpham();
try
{
if (OpenConnection() != null)
{
StringBuilder query = new StringBuilder();
query.Append("select * from tbl_sanpham s ");
if (_masp != 0)
{
query.Append(" where s.masp = @masp");
}
// Khởi tạo
SqlCommand comd = new SqlCommand(query.ToString(), conn);
comd.Prepare();
comd.Parameters.Clear();
comd.Parameters.AddWithValue("@masp", _masp);
comd.Connection = conn;
_sqlReader = comd.ExecuteReader();
while (_sqlReader.Read())
{
product._masp = (int)_sqlReader["masp"];
product._maloai = (int)_sqlReader["maloai"];
product._tensanpham = _sqlReader["tensanpham"].ToString();
var _gia_mua = _sqlReader["gia_mua"].ToString();
var _gia_ban = _sqlReader["gia_mua"].ToString();
CultureInfo cul = CultureInfo.GetCultureInfo("vi-VN"); // try with "en-US"
product._gia_mua = double.Parse(_gia_mua).ToString("#,###", cul.NumberFormat);
product._gia_ban = double.Parse(_gia_ban).ToString("#,###", cul.NumberFormat);
product._size = _sqlReader["size"].ToString();
product._soluong = (int)_sqlReader["soluong"];
product._thongtin = _sqlReader["thongtin"].ToString();
product._ngaynhaphang = (DateTime)_sqlReader["ngaynhaphang"];
product._hinhanh = _sqlReader["hinhanh"].ToString();
product.discount = (int)_sqlReader["discount"];
}
}
}
catch (SqlException e)
{
// Ném lỗi.
throw e;
}
finally
{
// Đóng kết nối với DB
CloseConnection();
}
return(product);
}
// GET: AddToCart
public ActionResult Add(Tbl_sanpham sanpham)
{
if (Session["cart"] == null)
{
List <Tbl_sanpham> li = new List <Tbl_sanpham>();
li.Add(sanpham);
Session["cart"] = li;
ViewBag.cart = li.Count();
Session["count"] = 1;
}
else
{
List <Tbl_sanpham> li = (List <Tbl_sanpham>)Session["cart"];
li.Add(sanpham);
Session["cart"] = li;
ViewBag.cart = li.Count();
Session["count"] = Convert.ToInt32(Session["count"]) + 1;
}
return(RedirectToAction("Shop", "Shop"));
}
public List <Tbl_sanpham> GetAllProductWithTyle(int _maloai, int _offset, int _limit, string _tensanpham, int _gia_min, int _gia_max, int _discount)
{
List <Tbl_sanpham> lstSanPhams = new List <Tbl_sanpham>();
try
{
if (OpenConnection() != null)
{
StringBuilder query = new StringBuilder();
query.Append("SELECT * FROM tbl_sanpham WHERE maloai = @maloai ");
// Kiểm tra user có search theo tên sản phẩm hay khong
if (!string.IsNullOrEmpty(_tensanpham))
{
query.Append(" AND tensanpham LIKE @tensanpham ESCAPE '!' ");
}
// kiểm tra user có search sản phẩm theo khoảng giá hay không
if (_gia_min != -1 && _gia_max != 0)
{
query.Append(" AND gia_ban between @gia_min AND @gia_max ");
}
// kiểm tra user có search theo khuyến mại hay không
if (_discount != 0)
{
query.Append(" AND discount < @discount ");
}
// order by theo truong maloai
query.Append(" order by maloai ");
// add limit và offset
query.Append(" OFFSET @offset ");
query.Append(" ROWS FETCH NEXT @limit ");
query.Append(" ROW ONLY;");
SqlCommand sqlCommand = new SqlCommand(query.ToString(), conn);
sqlCommand.Prepare();
sqlCommand.Parameters.AddWithValue("@maloai", _maloai);
if (!string.IsNullOrEmpty(_tensanpham))
{
sqlCommand.Parameters.AddWithValue("@tensanpham", "%" + Common.ReplaceWildCard(_tensanpham) + "%");
}
if (_gia_min != -1 && _gia_max != 0)
{
sqlCommand.Parameters.AddWithValue("@gia_min", _gia_min);
sqlCommand.Parameters.AddWithValue("@gia_max", _gia_max);
}
if (_discount != 0)
{
sqlCommand.Parameters.AddWithValue("@discount", _discount);
}
sqlCommand.Parameters.AddWithValue("@offset", _offset);
sqlCommand.Parameters.AddWithValue("@limit", _limit);
_sqlReader = sqlCommand.ExecuteReader();
while (_sqlReader.Read())
{
Tbl_sanpham tblSanPham = new Tbl_sanpham();
tblSanPham._masp = (int)_sqlReader["masp"];
tblSanPham._maloai = (int)_sqlReader["maloai"];
tblSanPham._tensanpham = _sqlReader["tensanpham"].ToString();
var _gia_mua = _sqlReader["gia_mua"].ToString();
var _gia_ban = _sqlReader["gia_mua"].ToString();
CultureInfo cul = CultureInfo.GetCultureInfo("vi-VN"); // try with "en-US"
tblSanPham._gia_mua = double.Parse(_gia_mua).ToString("#,###", cul.NumberFormat);
tblSanPham._gia_ban = double.Parse(_gia_ban).ToString("#,###", cul.NumberFormat);
tblSanPham._size = _sqlReader["size"].ToString();
tblSanPham._soluong = (int)_sqlReader["soluong"];
tblSanPham._thongtin = _sqlReader["thongtin"].ToString();
tblSanPham._ngaynhaphang = (DateTime)_sqlReader["ngaynhaphang"];
tblSanPham._hinhanh = _sqlReader["hinhanh"].ToString();
tblSanPham.discount = (int)_sqlReader["discount"];
lstSanPhams.Add(tblSanPham);
}
}
}
catch (SqlException e)
{
Console.WriteLine("TblSanPhamDao : getAllProductWithTyle " + e.StackTrace);
}
finally
{
CloseConnection();
}
return(lstSanPhams);
}
