// GET: Products/ByFactory
public ActionResult ByFactory(int?id, int page = 1)
{
DangTruyVan = Loai.NhaSanXuat;
if (!id.HasValue)
{
return(RedirectToAction("Index", "Home"));
}
using (ModelEntities ctx = new ModelEntities())
{
ViewBag.CatID = id;
int soPhanTu = 4;
List <tbl_SanPhams> list = ctx.tbl_SanPhams.Where(p => p.NhaSanXuatID == id && p.DaXoa == false && p.TinhTrang == true).ToList();
Poco_Product_Page item = new Poco_Product_Page();
int soTrang = PhanTrang(list.Count, soPhanTu);
item.DanhSachSanPham = list.Skip((page - 1) * soPhanTu).Take(soPhanTu).ToList();
item.SoPage = PhanTrang(list.Count, soPhanTu);
item.CurPage = page;
item.MaSanPham = id.Value;
ViewBag.Pages = item.SoPage;
ViewBag.CurPage = page;
ViewBag.NextPage = page + 1;
ViewBag.NextPage = page - 1;
if (list.FirstOrDefault() != null)
{
int LSPID = list.First().LoaiSanPhamID.Value;
item.TenLoaiSanPham = ctx.tbl_LoaiSanPhams.First(p => p.LoaiSanPhamID == LSPID).TenLoaiSanPham;
}
else
{
item.TenLoaiSanPham = string.Empty;
}
item.TenNhaSanXuat = ctx.tbl_NhaSanXuats.FirstOrDefault(p => p.NhaSanXuatID == id.Value).TenNhaSanXuat;
return(View(item));
}
}
public ActionResult SearchProduct(String name, int page = 1)
{
if (name != null)
{
using (ModelEntities ctx = new ModelEntities())
{
List <tbl_SanPhams> list = ctx.tbl_SanPhams.ToList();
var l = list.Where(p => p.TenSanPham.ToLower().Contains(name.ToLower()) ||
p.Gia.ToString().Contains(name.ToLower()) ||
p.MoTaNgan.ToLower().Contains(name.ToLower()) ||
p.NongDo.ToString().ToLower().Contains(name.ToLower()) ||
p.DungTich.ToString().ToLower().Contains(name.ToLower()) &&
p.TinhTrang == true && p.DaXoa == false
).ToList();
int soPhanTu = 4;
Poco_Product_Page item = new Poco_Product_Page();
int soTrang = PhanTrang(l.Count, soPhanTu);
item.DanhSachSanPham = l.Skip((page - 1) * soPhanTu).Take(soPhanTu).ToList();
item.SoPage = PhanTrang(l.Count, soPhanTu);
item.CurPage = page;
ViewBag.Pages = item.SoPage;
ViewBag.CurPage = page;
ViewBag.NextPage = page + 1;
ViewBag.NextPage = page - 1;
ViewBag.SearchKey = name.Trim();
return(View(item));
}
}
else//ko co name thi lay toan bo du lieu
{
using (ModelEntities ctx =
new ModelEntities())
{
List <tbl_SanPhams> list = ctx.tbl_SanPhams.Where(p => p.DaXoa == false && p.TinhTrang == true).ToList();
if (list.Count > 0)
{
ViewBag.data = list;
}
return(View(list));
}
}
}
