public bool add(StockExchangeCompanies entity) { try { context.StockExchangeCompanies.Add(entity); int updates = context.SaveChanges(); if (updates > 0) { return(true); } return(false); } catch (Exception) { return(false); } }
public bool add(IPODetails entity) { try { context.IPODetails.Add(entity); int updates = context.SaveChanges(); if (updates > 0) { return(true); } return(false); } catch (Exception) { return(false); } }
public bool Add(StockPriceDto entity) { try { var stockprice = new StockPrice { CurrentPrice = entity.CurrentPrice //Company = context.Companies.Find(entity.CompanyId), //StockExchange = context.StockExchanges.Find(entity.StockExchangeCode) }; context.StockPrice.Add(stockprice); context.SaveChanges(); return(true); } catch (Exception ex) { throw ex; } }
public void 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); 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(); foreach (DataRow r in dt.Rows) { list.Add( new StockPrice() { //CompanyId = int.Parse(r[0].ToString().Trim()), //StockExchangeId = int.Parse(r[1].ToString().Trim()), CurrentPrice = Convert.ToDecimal(r[2].ToString().Trim()), Date = r[3].ToString().Trim(), Time = r[4].ToString().Trim() }); } context.StockPrice.AddRange(list); //insert list of rows to table context.SaveChanges(); } } } }
public void Setup() { context = new AdminContextDB(options); context.StockPrice.AddRange(GetStockPriceList()); context.SaveChanges(); }