//Lấy chi tiết sản phẩm
public ActionResult ProductDetail(string productID)
{
shopeeEntities3 db = new shopeeEntities3();
HANGHOA product = db.HANGHOAs.Where(x => x.MAHANGHOA == productID).SingleOrDefault();
return(View(product));
}
public ActionResult search(string search)
{
shopeeEntities3 db = new shopeeEntities3();
List <HANGHOA> pList = db.HANGHOAs.Where(x => x.TENHANGHOA.Contains(search)).Take(12).ToList();
return(View(pList));
}
public ActionResult Categories()
{
shopeeEntities3 db = new shopeeEntities3();
List <DANHMUC> cList = db.DANHMUCs.Take(6).ToList();
return(PartialView("_Categories", cList));
}
public ActionResult Index()
{
shopeeEntities3 db = new shopeeEntities3();
List <HANGHOA> pList = db.HANGHOAs.Take(12).ToList();
return(View(pList));
}
//Recent Post
public ActionResult RecentPost()
{
shopeeEntities3 db = new shopeeEntities3();
List <HANGHOA> pList = (from HH in db.HANGHOAs
orderby HH.NGAYDANG descending
select HH).Take(3).ToList();
return(PartialView("_RecentPost", pList));
}
public ActionResult OnSale()
{
shopeeEntities3 db = new shopeeEntities3();
List <HANGHOA> pList = (from HH in db.HANGHOAs
orderby HH.GIATHANH
select HH).Take(3).ToList();
return(PartialView("_OnSale", pList));
}
//Hot Item
public ActionResult HotItem()
{
shopeeEntities3 db = new shopeeEntities3();
List <HANGHOA> pList = (from HH in db.HANGHOAs
orderby HH.DANHGIA_HANGHOA descending
select HH).Take(6).ToList();
return(PartialView("_HotItem", pList));
}
//Best Seller
public ActionResult BestSeller()
{
shopeeEntities3 db = new shopeeEntities3();
List <HANGHOA> pList = (from HH in db.HANGHOAs
orderby HH.SOLUONGDABAN descending
select HH).Take(3).ToList();
return(PartialView("_BestSeller", pList));
}
public ActionResult Shop(string productID)
{
shopeeEntities3 db = new shopeeEntities3();
string shopID = (from HH in db.HANGHOAs where HH.MAHANGHOA == productID select HH.MAGIANHANG).SingleOrDefault().ToString();
List <HANGHOA> pList = (from H in db.HANGHOAs where H.MAGIANHANG == shopID select H).ToList();
return(View(pList));
}
public ActionResult CategoryItem(string categoryID)
{
shopeeEntities3 db = new shopeeEntities3();
List <HANGHOA> pList = (from HH in db.HANGHOAs
join DM in db.DANHMUCs on HH.LOAIHANGHOA equals DM.MALOAI
where DM.MALOAI == categoryID
select HH).ToList();
return(View(pList));
}
public ActionResult Login(TAIKHOANDANGNHAP account)
{
shopeeEntities3 db = new shopeeEntities3();
TAIKHOANDANGNHAP acc = (from TK in db.TAIKHOANDANGNHAPs where (TK.TENDANGNHAP == account.TENDANGNHAP && TK.MATKHAU == account.MATKHAU) select TK).SingleOrDefault();
if (acc != null)
{
Session["account"] = acc;
}
else //nếu không có tài khoản
{
return(Redirect("/Login"));
}
return(Redirect("/"));
}
