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