public int DeleteFavouriteGroup(int id) { int favDeleted = -1; try { StockDBContext sContext = new StockDBContext(); MyFavourite deletedFav = sContext.MyFavouries.FirstOrDefault(f => f.MyFavouriteID == id); sContext.MyFavouries.Remove(deletedFav); favDeleted = sContext.SaveChanges(); } catch (Exception ex) { throw ex; } return(favDeleted); }
// Add Fav Group to Member public int AddFavouriteGroup(int memberId, string favName) { MyFavourite mFav = new MyFavourite(); mFav.MemberID = memberId; mFav.MyFavouriteName = favName; try { StockDBContext sContext = new StockDBContext(); sContext.MyFavouries.Add(mFav); sContext.SaveChanges(); } catch (Exception ex) { Console.WriteLine("Problem with adding FavouriteGroup"); throw ex; } return(mFav.MyFavouriteID); }