public static void AddTradingRecord(TradingRecord tradingRecord)//ex DataException
{
using (StockMonitorEntities _dbContext = new StockMonitorEntities())
{
_dbContext.TradingRecords.Add(tradingRecord);
_dbContext.SaveChanges();//ex DataException
}
}
public static void DeleteReservedTrading(ReservedTrading reservedTrading)//ex DataException,InvalidOperationException
{
using (StockMonitorEntities _dbContext = new StockMonitorEntities())
{
ReservedTrading trading = _dbContext.ReservedTradings.Find(reservedTrading.Id);//ex InvalidOperationException
if (trading == null)
{
throw new InvalidOperationException($"Cannot find reservedTrading[{reservedTrading.Id}]");
}
_dbContext.ReservedTradings.Remove(trading);
_dbContext.SaveChanges();//ex DataException,InvalidOperationException
}
}
public static List <TradingRecord> GetTradingRecordList(int userId)//ex InvalidOperationException
{
StockMonitorEntities _dbContext = new StockMonitorEntities();
User tradingUser = (from user in _dbContext.Users.Include("ReservedTradings")
where user.Id == userId
select user).FirstOrDefault();
if (tradingUser == null)
{
throw new InvalidOperationException($"There is no User id[{userId}]");
}
return(tradingUser.TradingRecords.Reverse().ToList());
}
public static void DeleteTradingRecord(TradingRecord tradingRecord)
{//ex DataException,InvalidOperationException
StockMonitorEntities _dbContext = new StockMonitorEntities();
TradingRecord trading = _dbContext.TradingRecords.Find(tradingRecord.Id);//ex InvalidOperationException
if (trading == null)
{
throw new InvalidOperationException($"Cannot find TradingRecord[{tradingRecord.Id}]");
}
_dbContext.TradingRecords.Remove(trading);
_dbContext.SaveChanges();//ex DataException,InvalidOperationException
}
public static void InsertReservedTrading(ReservedTrading reservedTrading)
{//ex DateException, InvalidOperationException
using (StockMonitorEntities _dbContext = new StockMonitorEntities())
{
var companyTrading = from trade in GetReservedTradingList(reservedTrading.UserId) //ex InvalidOperationException
where trade.CompanyId == reservedTrading.CompanyId
select trade;
if (companyTrading.Count() == 0)
{
_dbContext.ReservedTradings.Add(reservedTrading);
_dbContext.SaveChanges(); //ex DataException
}
else
{
throw new InvalidOperationException("One Trade reserved already with this company");
}
}
}
public static Dictionary <string, int> GetTradingRecordCountList(int userId)
{
StockMonitorEntities _dbContext = new StockMonitorEntities();
Dictionary <string, int> tradeHistory = new Dictionary <string, int>();
User tradingUser = (from user in _dbContext.Users.Include("ReservedTradings")
where user.Id == userId
select user).FirstOrDefault();
foreach (var listItem in tradingUser.WatchListItems)
{
int count = (from reservedTrading in tradingUser.TradingRecords
where reservedTrading.CompanyId == listItem.CompanyId
select reservedTrading).Count();
tradeHistory.Add(listItem.Company.Symbol, count);
}
var reservedTradingsList = tradingUser.ReservedTradings;
return(tradeHistory);
}
