public List <Stock> GetAllStockByMemberID(int memId)
{
List <Stock> lStock = new List <Stock>();
try
{
StockDBContext sContext = new StockDBContext();
MyFavouriteModelContext fContext = new MyFavouriteModelContext();
List <MyFavourite> nFav = fContext.GetMyFavouritesByMemberID(memId);
foreach (MyFavourite m in nFav)
{
List <Stock> tempStockList = new List <Stock>();
tempStockList = sContext.Stocks.Where(s => s.MyFavouriteID.Equals(m.MyFavouriteID)).ToList();
foreach (Stock st in tempStockList)
{
lStock.Add(st);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
return(lStock);
}
public string ValidateLogin(string email, string password)
{
string msg = "";
Member selectedMember = null;
Member selectedMember2 = null;
try
{
StockDBContext sContext = new StockDBContext();
selectedMember = sContext.Members.FirstOrDefault(m => m.Email == email);
if (selectedMember == null)
{
msg = "Email Does not exist";
}
else
{
selectedMember2 = sContext.Members.FirstOrDefault(m => m.Email == selectedMember.Email && m.Password == password);
if (selectedMember2 == null)
{
msg = "Wrong Password";
}
}
}
catch (Exception ex)
{
Console.WriteLine("Problem validating a login");
throw ex;
}
return(msg);
}
public Member GetMemberByName(string email, string password)
{
Member selectedMember = null;
try
{
StockDBContext sContext = new StockDBContext();
selectedMember = sContext.Members.FirstOrDefault(m => m.Email == email && m.Password == password);
}
catch (Exception ex)
{
Console.WriteLine("Problem with getting member");
throw ex;
}
return(selectedMember);
}
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 Member GetMemberByID(int id)
{
Member selectedMember = null;
try
{
StockDBContext sContext = new StockDBContext();
selectedMember = sContext.Members.FirstOrDefault(m => m.MemberID == id);
}
catch (Exception ex)
{
Console.WriteLine("Problem with getting member");
throw ex;
}
return(selectedMember);
}
public Stock GetSingleStockByStockID(int stockid)
{
Stock stock;
try
{
StockDBContext sContext = new StockDBContext();
stock = sContext.Stocks.FirstOrDefault(m => m.StockID == stockid);
}
catch (Exception ex)
{
Console.WriteLine("Problem with getting single Fav");
throw ex;
}
return(stock);
}
// Get Single Fav Group
public MyFavourite GetSingleMyFavourite(int memberId, int favID)
{
MyFavourite fav;
try
{
StockDBContext sContext = new StockDBContext();
fav = sContext.MyFavouries.FirstOrDefault(m => m.MyFavouriteID == favID && m.MemberID == memberId);
}
catch (Exception ex)
{
Console.WriteLine("Problem with getting single Fav");
throw ex;
}
return(fav);
}
// Get All FAV Groups
public List <MyFavourite> GetMyFavouritesByMemberID(int memberId)
{
List <MyFavourite> favList;
try
{
StockDBContext sContext = new StockDBContext();
favList = sContext.MyFavouries.Where(m => m.MemberID == memberId).ToList();
}
catch (Exception ex)
{
Console.WriteLine("Problem with getting Fav Groups");
throw ex;
}
return(favList);
}
public List <Stock> GetAllStockByFavID(int favID)
{
List <Stock> stockInFav = new List <Stock>();
try
{
StockDBContext sContext = new StockDBContext();
stockInFav = sContext.Stocks.Where(s => s.MyFavouriteID.Equals(favID)).ToList();
}
catch (Exception ex)
{
Console.WriteLine("error in Getting all projects");
throw ex;
}
return(stockInFav);
}
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);
}
