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();
}