public void limitRecentlyView(string iduser)
{
DBModel dBModel = new DBModel();
recently_viewed rv = null;
List <recently_viewed> listRV = dBModel.recently_viewed.Where(x => x.ID_ACCOUNT == iduser).OrderByDescending(c => c.DATE_VIEW.Value).ToList();
if (listRV.Count == 11)
{
rv = listRV.ElementAt(listRV.Count - 1);
}
if (rv != null)
{
dBModel.recently_viewed.Attach(rv);
dBModel.recently_viewed.Remove(rv);
dBModel.SaveChanges();
}
}
public void addRecentlyView(string iduser, string idproduct)
{
DBModel dBModel = new DBModel();
recently_viewed rv = new recently_viewed();
if (checkRecentlyView(iduser, idproduct) == true)
{
rv.ID_ACCOUNT = iduser;
rv.ID_PRODUCT = idproduct;
rv.DATE_VIEW = DateTime.Now;
dBModel.recently_viewed.Add(rv);
dBModel.SaveChanges();
}
else
{
var check = dBModel.recently_viewed.Where(x => x.ID_ACCOUNT == iduser && x.ID_PRODUCT == idproduct).SingleOrDefault();
check.DATE_VIEW = DateTime.Now;
dBModel.recently_viewed.AddOrUpdate(check);
dBModel.SaveChanges();
}
limitRecentlyView(iduser);
}
