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 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 void DeleteReservedTrading(ReservedTrading reservedTrading) //ex DataException,InvalidOperationException { TradeDatabaseHelper.DeleteReservedTrading(reservedTrading); //ex DataException,InvalidOperationException }
public static void InsertReservedTrading(ReservedTrading reservedTrading) //ex DateException, InvalidOperationException { TradeDatabaseHelper.InsertReservedTrading(reservedTrading); //ex DateException, InvalidOperationException }