public int AddMember(Member newMember)
{
try
{
StockDBContext sContext = new StockDBContext();
sContext.Members.Add(newMember);
sContext.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("Problem with getting selectedProject");
throw ex;
}
return(newMember.MemberID);
}
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);
}
public int AddStock(int favGroupID, string symbol)
{
Stock nStock = new Stock();
try
{
nStock.Symbol = symbol;
nStock.MyFavouriteID = favGroupID;
StockDBContext sContext = new StockDBContext();
sContext.Stocks.Add(nStock);
sContext.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("Problem with getting selectedProject");
throw ex;
}
return(nStock.StockID);
}
// 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);
}