private IEnumerable <StockPrice> GetStockPriceList() { var cse = new CompanyStockExchange { CompanyId = 1, StockExchangeCode = "BSE" }; return(new List <StockPrice> { new StockPrice { Id = 1, CurrentPrice = 100, Date = new DateTime().ToShortDateString(), Time = new DateTime().ToShortTimeString(), CompanyStockExchange = cse }, new StockPrice { Id = 2, CurrentPrice = 101, Date = new DateTime().ToShortDateString(), Time = new DateTime().AddMinutes(1).ToShortTimeString(), CompanyStockExchange = cse } }); }
public async Task <bool> AddCompany(AddCompanyModel model) { var sectorInfo = _db.Sectors.Where(s => s.SectorID == model.SectorID).FirstOrDefault(); Company company = new Company { CompanyName = model.CompanyName, TurnOver = model.TurnOver, CEO = model.CEO, BoardOfDirectors = model.BoardOfDirectors, SectorID = model.SectorID, Sector = sectorInfo, WriteUp = model.WriteUp, stockCodes = null, Active = model.Active }; await using var transaction = await _db.Database.BeginTransactionAsync(); try { _db.Companies.Add(company); List <CompanyStockExchange> iecse = new List <CompanyStockExchange>(); foreach (string exchangeShortName in model.Exchanges) { var ex = _db.StockExchanges.Where(e => e.shortName == exchangeShortName).FirstOrDefault(); //var cid = _db.Companies.Where(c => c.CompanyName == model.CompanyName).FirstOrDefault().CompanyID; CompanyStockExchange cse = new CompanyStockExchange { Company = company, StockExchangeID = ex.StockExchangeID, StockExchange = ex }; iecse.Add(cse); } _db.companyStockExchanges.AddRange(iecse); _db.SaveChanges(); await transaction.CommitAsync(); return(true); } catch (Exception err) { Console.WriteLine(err); await transaction.RollbackAsync(); return(false); } }