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