public bool Add(IPODetailsDto entity) //adding an IPO { try { var IPODetail = new IPODetail { PricePerShare = entity.PricePerShare, TotalNumOfShares = entity.TotalNumOfShares, OpenDate = entity.OpenDate, OpenTime = entity.OpenTime, Remarks = entity.Remarks, // StockExchangeCompany = context.StockExchangeCompanies.Find(entity.CompanyId, entity.StockExchangeId) StockExchangeId = entity.StockExchangeId, CompanyId = entity.CompanyId }; IPODetail.Company = context.Companies.Find(entity.CompanyId); IPODetail.StockExchange = context.StockExchanges.Find(entity.StockExchangeId); context.IPODetails.Add(IPODetail); context.SaveChanges(); return(true); } catch (Exception ex) { throw ex; } }
public void CreateACompany(Company2 company2) { _context.Company2s.Add(new Company2() { Name = company2.Name, Symbol = company2.Symbol }); _context.SaveChanges(); }
public bool Add(CompanyDto entity) //adding a company { try { var company = new Company { CompanyName = entity.CompanyName, Turnover = entity.Turnover, CEO = entity.CEO, BoardOfDirectors = entity.BoardOfDirectors, Brief = entity.Brief //we are also getting stock exchange ID here }; company.Sector = context.Sectors.Find(entity.SectorId); var sector = context.Sectors.Find(entity.SectorId); context.Companies.Add(company); //ICollection<Company> a = new HashSet<Company>(); //a.Add(company); sector.Companies.Add(company); context.Sectors.Update(sector); //sector.Companies.Add(company); //company.CompanyId get this // do the below via adding object of StockExchangeCompanies // StockExchangeCompanies = context.StockExchangeCompanies.Add(company.CompanyId, company.StockExchangeId) for (int i = 0; i < entity.StockExchangeIds.Count(); i++) { var sid = entity.StockExchangeIds[i]; var sec = new StockExchangeCompany { Company = company, StockExchange = context.StockExchanges.Find(sid) }; context.StockExchangeCompanies.Add(sec); } context.SaveChanges(); return(true); } catch (Exception ex) { throw ex; } }
public UserAccount Add(UserAccount userAccount) { _context.UserAccounts.Add(userAccount); _context.SaveChanges(); return(userAccount); }
public void CreateAStockRecord(StockPrice stockPrice) { var checkValidOrNot = _context.StockPrices.Where(x => x.ComapnyId == stockPrice.ComapnyId).FirstOrDefault(); try { _context.StockPrices.Add(new StockPrice() { ComapnyId = stockPrice.ComapnyId, MaxPrice = stockPrice.MaxPrice, MinPrice = stockPrice.MinPrice, TradingDay = stockPrice.TradingDay, }); _context.SaveChanges(); } catch (Exception e) { Console.WriteLine(e.Message); } }
public bool Add(Sector entity) { context.Add(entity); var isChanged = context.SaveChanges(); if (isChanged > 0) { return(true); } return(false); }
public bool Add(StockExchangeDto entity) { try { var stockexchange = new StockExchange { StockExchangeName = entity.StockExchangeName, Brief = entity.Brief, ContactAddress = entity.ContactAddress, Remarks = entity.Remarks }; context.StockExchanges.Add(stockexchange); var x = context.SaveChanges(); if (x > 0) { return(true); } return(false); } catch (Exception ex) { return(false); } }
public bool Signup(User entity) { try { entity.Confirmed = true; //giving this by default instead of via activation links context.Users.Add(entity); int updates = context.SaveChanges(); if (updates > 0) { return(true); } return(false); } catch (Exception e) { return(false); } }
public void Setup() { context = new StockMarketContext(options); context.Sectors.AddRange(GetSectorList()); context.SaveChanges(); }
public Tuple <int, string, string> UploadExcel(string filePath) { var list = new List <StockPrice>(); FileInfo info = new FileInfo(filePath); string fileExtension = info.Extension; string excelConString = ""; //Get connection string using extension switch (fileExtension) { // If uploaded file is Excel 1997 - 2007. case ".xls": excelConString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES'"; break; //If uploaded file is Excel 2007 and above case ".xlsx": excelConString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES'"; break; } // Read data from first sheet of excel into datatable DataTable dt = new DataTable(); excelConString = string.Format(excelConString, filePath); Tuple <int, string, string> summary; using (OleDbConnection excelOledbConnection = new OleDbConnection(excelConString)) { using (OleDbCommand excelDbCommand = new OleDbCommand()) { using (OleDbDataAdapter excelDataAdapter = new OleDbDataAdapter()) { excelDbCommand.Connection = excelOledbConnection; excelOledbConnection.Open(); // Get schema from excel sheet DataTable excelSchema = excelOledbConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); // Get sheet name string sheetName = excelSchema.Rows[0]["TABLE_NAME"].ToString(); excelOledbConnection.Close(); // Read Data from First Sheet. excelOledbConnection.Open(); excelDbCommand.CommandText = "SELECT * From [" + sheetName + "]"; excelDataAdapter.SelectCommand = excelDbCommand; //Fill datatable from adapter excelDataAdapter.Fill(dt); excelOledbConnection.Close(); int count = dt.Rows.Count; string cName; string sName; foreach (DataRow r in dt.Rows) { // int i = Int32.Parse(r[1].ToString().Trim()); //You can try single() method instead of where. //StockExchangeId = context.StockExchanges.Where(s=> s.StockExchangeName == r[1].ToString().Trim()) //list.Add( // new StockPrice() // { // CompanyId = int.Parse(r[0].ToString().Trim()), // StockExchangeId = int.Parse(r[1].ToString().Trim()), // CurrentPrice = Convert.ToDouble(r[2].ToString().Trim()), // Date = r[3].ToString().Trim(), // Time = r[4].ToString().Trim() // }) ; DateTime t = (DateTime)r[3]; var sp = new StockPrice() { CompanyId = int.Parse(r[0].ToString().Trim()), StockExchangeId = int.Parse(r[1].ToString().Trim()), CurrentPrice = Convert.ToDouble(r[2].ToString().Trim()), Date = t.ToString("d").Trim(), //Date = r[3].ToString().Trim(), Time = r[4].ToString().Trim() }; sp.Company = context.Companies.Find(sp.CompanyId); sp.StockExchange = context.StockExchanges.Find(sp.StockExchangeId); list.Add(sp); // context.Add(sp); // var x= context.SaveChanges(); // Console.WriteLine(x); } cName = context.Companies.Find(list.First().CompanyId).CompanyName; sName = context.StockExchanges.Find(list.First().StockExchangeId).StockExchangeName; summary = new Tuple <int, string, string>(count, cName, sName); context.StockPrices.AddRange(list); //insert list of rows to table var x = context.SaveChanges(); Console.WriteLine(x); return(summary); //summary tuple returns no. of entries, company name and stock exchange name. } } } }
public void add(UserEntity u) { db.UserEntity.Add(u); db.SaveChanges(); }
public void addCompany(CompanyEntity c) { db.CompanyEntities.Add(c); db.SaveChanges(); }
public bool Save() { return(_context.SaveChanges() >= 0); }
public RedirectResult Buy(CustomerOrder customerOrder) { string pricestring = Request.Form["Price"].Replace(".", ","); decimal price; if (decimal.TryParse(pricestring, out price)) { customerOrder.Price = price; customerOrder.DateTimeCustomer = DateTime.Now; foreach (SellerOrder sellerOrder in db.SellerOrders.OrderBy(s => s.Price)) { if (customerOrder.Count > 0) { if (sellerOrder.Price <= customerOrder.Price) { if (sellerOrder.Count >= customerOrder.Count) { sellerOrder.Count -= customerOrder.Count; db.Orders.Add(new Order { Count = customerOrder.Count, DateTimeCompleted = customerOrder.DateTimeCustomer, DateTimeCustomer = customerOrder.DateTimeCustomer, DateTimeSeller = sellerOrder.DateTimeSeller, EmailCustomer = customerOrder.Email, EmailSeller = sellerOrder.Email, Price = sellerOrder.Price }); customerOrder.Count = 0; } else { customerOrder.Count -= sellerOrder.Count; db.Orders.Add(new Order { Count = sellerOrder.Count, DateTimeCompleted = customerOrder.DateTimeCustomer, DateTimeCustomer = customerOrder.DateTimeCustomer, DateTimeSeller = sellerOrder.DateTimeSeller, EmailCustomer = customerOrder.Email, EmailSeller = sellerOrder.Email, Price = sellerOrder.Price }); sellerOrder.Count = 0; } } } } db.SaveChanges(); db.SellerOrders.RemoveRange(db.SellerOrders.Where(s => s.Count == 0).ToList()); if (customerOrder.Count > 0) { db.CustomerOrders.Add(customerOrder); } db.SaveChanges(); } return(RedirectPermanent("/Home/Index")); }
public void addStockExchange(StockExchangeEntity s) { db.StockExchangeEntity.Add(s); db.SaveChanges(); }