public FavoriteModel DeleteFavorite(FavoriteModel item) { FavoriteModel dbEntry = context.Favorites.FirstOrDefault(i => i.FavoritesID == item.FavoritesID); context.Remove(dbEntry); context.SaveChanges(); return(dbEntry); }
public int SaveFavorite(FavoriteModel item) { int temp = this.Items.Where(i => i.Username == item.Username).Where(i => i.ItemID == item.ItemID).Count(); //if((context.Favorites.FromSqlRaw("Select Username, ItemID FROM dbo.Favorites WHERE username = '******' AND itemId = '" + item.ItemID + "'")).Count() > 0) //{ //} if (temp > 0) { if (item.ItemID == null || item.Username == null) { return(2); } return(0); } else { context.Add(item); context.SaveChanges(); return(1); } }