public ActionResult GetLikeProduct(int category)
{
TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities();
var userid = HttpContext.User.Identity.GetUserId();
if (userid != null)
{
var buyquery = from c in db.buyitemdetailtbl
where c.mid == userid
select c.pid;
List <string> buiedlist = new List <string>();
foreach (var item in buyquery)
{
buiedlist.Add(Convert.ToString(item));
}
var query = (from c in db.producttbl
where c.category == category
orderby c.score descending
select c).ToList().SkipWhile(x => buiedlist.Contains(Convert.ToString(x.pid)));
return(PartialView("_Shopping", query.Take(3)));
}
else
{
var query = from c in db.producttbl
where c.category == category
orderby c.score descending
select c;
return(PartialView("_Shopping", query.Take(3)));
}
}
public ActionResult CurrentCart(int?id)
{
var currentCart = Operation.GetCurrentCart();
var userid = HttpContext.User.Identity.GetUserId();
ProductViewModels product = new ProductViewModels();
product.PId = Convert.ToInt32(id);
TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities();
var query = from c in db.buyitemdetailtbl
where c.mid == userid && c.pid == id
select c;
if (query.Count() > 0)
{
return(PartialView("_btnBuy"));
}
foreach (var cartitem in currentCart)
{
if (cartitem.Id == id)
{
return(PartialView("_btnAdded", product));
}
}
return(PartialView("_btnAddCart", product));
}
public ActionResult View(int?id)
{
if (id != null)
{
ProductEntity pe = new ProductEntity();
var query = pe.QueryByProductId(id.ToString());
ViewBag.keyword = query.FirstOrDefault().Categories;
TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities();
string userid = HttpContext.User.Identity.GetUserId();
if (userid != null)
{
var buyquery = from c in db.buyitemdetailtbl
where c.mid == userid && c.pid == id
select c;
if (buyquery.Count() > 0)
{
ViewBag.Buy = true;
}
else
{
ViewBag.Buy = false;
}
}
else
{
ViewBag.Buy = false;
}
return(View(query));
}
return(View());
}
