public async Task <List <SanPhamVM> > layDSSanPhamLoaiAD(string key)
{
List <SanPhamVM> sanPham = new List <SanPhamVM>();
IEnumerable <SanPhamLoai> sanPhamLoai = null;
using (var connection = new SqlConnection(connectionstr))
{
var p = new DynamicParameters();
p.Add("@KEYWORD", key);
p.Add("@TABLE", "SANPHAMLOAI");
sanPhamLoai = connection.Query <SanPhamLoai>("SP_GETALL", p, commandType: CommandType.StoredProcedure);
foreach (var item in sanPhamLoai)
{
SanPhamVM sp = new SanPhamVM();
sp.DonGia = item.DonGia;
sp.HinhAnh = item.HinhAnh;
sp.MaSP = item.MaSP;
sp.SoLuongTon = item.SoLuongTon;
sp.TrangThai = item.TrangThai;
sp.TenSP = item.TenSP;
sanPham.Add(sp);
}
}
return(sanPham);
}
public IActionResult Index()
{
SanPhamVM sp = new SanPhamVM();
sp.sanpham = _iSanPham.LayTatCaSanPham();
sp.thuonghieu = _iThuongHieu.LayTatCaThuongHieu();
return(View(sp));
}
public IActionResult Index(string s)
{
ViewBag.search = s;
SanPhamVM sp = new SanPhamVM();
sp.sanpham = _iSanPham.TimKiemSanPham(s);
sp.thuonghieu = _iThuongHieu.LayTatCaThuongHieu();
return(View(sp));
}
public IActionResult HienThiTheoThuongHieu(int id)
{
SanPhamVM x = new SanPhamVM();
x.sanpham = _iSanPham.LayTatCaSanPhamTheoThuongHieu(id);
x.thuonghieu = _iThuongHieu.LayTatCaThuongHieu();
return(View(x));
}
public static SanPhamVM ConvertSanPham(SANPHAM DV)
{
SanPhamVM ct = new SanPhamVM();
ct.MaSP = DV.MASP;
ct.TenSP = DV.TENSP;
ct.HinhAnh = DV.HINHANH;
ct.GiaBan = DV.GIABAN;
ct.TrangThai = DV.TRANGTHAI;
ct.MaLSP = DV.MALSP;
return(ct);
}
public async Task <IActionResult> Trangchu(int id)
{
var sanPham = await _context.Sanphams.Include(s => s.LoaiSanPham).FirstOrDefaultAsync(m => m.MaSP == id);
var sanPhamFeature = await _context.Sanphams.Include(s => s.LoaiSanPham).Where(m => m.Feature == 1).ToListAsync();
SanPhamVM spVM = new SanPhamVM()
{
Sanpham = sanPham,
ListSanPhamFeature = sanPhamFeature
};
return(View(spVM));
}
public async Task <dynamic> chiTietBinhLuanAD(int maBL)
{
ChiTietBinhLuanVM chiTietBL = new ChiTietBinhLuanVM();
using (var connection = new SqlConnection(connectionstr))
{
var result = connection.QuerySingleOrDefault <ChiTietBinhLuanVM>(" SELECT MaBL,NgayTao, DanhGia, NoiDung, SP.MaSP, TenSP," +
" SP.DonGia, SP.HinhAnh, SP.TrangThai, SP.SoLuongTon, MaKH, ND.HoTen, ND.TaiKhoan, ND.Email, ND.SoDT " +
"FROM BINHLUAN BL " +
"INNER JOIN SANPHAM_LOAI SP ON BL.MaSP = SP.MaSP " +
"INNER JOIN NGUOIDUNG ND ON BL.MaKH = ND.MaND " +
"WHERE BL.MaBL =" + maBL, commandType: CommandType.Text);
if (result == null)
{
return("Review is not exitst");
}
string queryND = "select TaiKhoan, HoTen, Email, SoDT, DiaChi from NGUOIDUNG where MaND =" + result.MaKH;
NguoiDungInforVM khachHang = connection.QuerySingleOrDefault <NguoiDungInforVM>(queryND, commandType: CommandType.Text);
chiTietBL.MaBL = result.MaBL;
chiTietBL.NoiDung = result.NoiDung;
chiTietBL.DanhGia = result.DanhGia;
chiTietBL.NgayTao = result.NgayTao;
chiTietBL.MaSP = result.MaSP;
chiTietBL.MaKH = result.MaKH;
chiTietBL.KhachHang = khachHang;
string querySP = "select MaSP, HinhAnh, TenSP, SoLuongTon, TrangThai, DonGia from SANPHAM_LOAI where MaSP ='" + result.MaSP + "'";
SanPhamVM sanPham = connection.QuerySingleOrDefault <SanPhamVM>(querySP, commandType: CommandType.Text);
chiTietBL.SanPham = sanPham;
var lstBL = connection.Query <BinhLuanHoiDap>("SELECT * FROM TRALOIBL WHERE MaBL=" + maBL, commandType: CommandType.Text);
if (lstBL != null)
{
foreach (var bl in lstBL)
{
BinhLuanHoiDap binhLuan = new BinhLuanHoiDap();
binhLuan.MaTL = bl.MaTL;
binhLuan.MaBL = bl.MaBL;
binhLuan.MaNV = bl.MaNV;
binhLuan.NgayTao = bl.NgayTao;
binhLuan.NoiDung = bl.NoiDung;
chiTietBL.dsHoiDap.Add(binhLuan);
}
}
}
return(chiTietBL);
}
