public void LoadFourHoursCandle(Symbol h, string pathtofile)
{
var tableFourHour = LoadExelSheetToTable(@"D:\DDE1.xlsx", pathtofile);
h.FourHours = new Collection <FourHour>();
FourHour interval2 = new FourHour();
foreach (DataRow p in tableFourHour.Rows)
{
interval2.Open = Convert.ToDecimal(p["Bid"]);
interval2.Max = Convert.ToDecimal(p["High"]);
interval2.Min = Convert.ToDecimal(p["low"]);
interval2.Date = Convert.ToDateTime(p["Time"]);
}
Thread.Sleep(90000);
var table3 = LoadExelSheetToTable(@"D:\DDE1.xlsx", pathtofile);
foreach (DataRow j in table3.Rows)
{
interval2.Close = Convert.ToDecimal(j["Ask"]);
}
h.FourHours.Add(interval2);
db.fourHours.Add(interval2);
}
private void PlaceTableToDataTable(DataTable table, string Name)
{
if (Data.symbolNameList.Count == 0)
{
Symbol symbol1 = new Symbol();
symbol1.Name = textBoxNameSymbol.Text.ToString();;
switch (Name)
{
case "Day":
symbol1.DayStocks = new Collection <DayStock>();
foreach (DataRow t in table.Rows)
{
DayStock interval = new DayStock();
interval.Open = Convert.ToDecimal(t["Open"]);
interval.Close = Convert.ToDecimal(t["Close"]);
interval.Max = Convert.ToDecimal(t["High"]);
interval.Min = Convert.ToDecimal(t["low"]);
interval.Date = Convert.ToDateTime(t["Date"]);
symbol1.DayStocks.Add(interval);
}
db.Symbols.Add(symbol1);
db.SaveChanges();
break;
case "FourHour":
symbol1.FourHours = new Collection <FourHour>();
foreach (DataRow t in table.Rows)
{
FourHour interval = new FourHour();
interval.Open = Convert.ToDecimal(t["Open"]);
interval.Close = Convert.ToDecimal(t["Close"]);
interval.Max = Convert.ToDecimal(t["High"]);
interval.Min = Convert.ToDecimal(t["low"]);
interval.Date = Convert.ToDateTime(t["Date"]);
symbol1.FourHours.Add(interval);
}
db.Symbols.Add(symbol1);
db.SaveChanges();
break;
case "Hour":
symbol1.Hours = new Collection <Hour>();
foreach (DataRow t in table.Rows)
{
Hour interval = new Hour();
interval.Open = Convert.ToDecimal(t["Open"]);
interval.Close = Convert.ToDecimal(t["Close"]);
interval.Max = Convert.ToDecimal(t["High"]);
interval.Min = Convert.ToDecimal(t["low"]);
interval.Date = Convert.ToDateTime(t["Date"]);
symbol1.Hours.Add(interval);
}
db.Symbols.Add(symbol1);
db.SaveChanges();
break;
case "HalfHour":
symbol1.HalfHours = new Collection <HalfHour>();
foreach (DataRow t in table.Rows)
{
HalfHour interval = new HalfHour();
interval.Open = Convert.ToDecimal(t["Open"]);
interval.Close = Convert.ToDecimal(t["Close"]);
interval.Max = Convert.ToDecimal(t["High"]);
interval.Min = Convert.ToDecimal(t["low"]);
interval.Date = Convert.ToDateTime(t["Date"]);
symbol1.HalfHours.Add(interval);
}
break;
}
}
else if (Data.symbolNameList.Contains(textBoxNameSymbol.Text))
{
switch (Name)
{
case "Day":
string constring = @"Data Source = (localdb)\MSSQLLocalDB; Initial Catalog = iMarketDB; Integrated Security = True";
sqlConnection = new SqlConnection(constring);
sqlConnection.Open();
var result = from k in db.Symbols
where k.Name == textBoxNameSymbol.Text
select k;
foreach (var l in result)
{
l.DayStocks = new Collection <DayStock>();
foreach (DataRow t in table.Rows)
{
DayStock interval = new DayStock();
interval.Open = Convert.ToDecimal(t["Open"]);
interval.Close = Convert.ToDecimal(t["Close"]);
interval.Max = Convert.ToDecimal(t["High"]);
interval.Min = Convert.ToDecimal(t["low"]);
interval.Date = Convert.ToDateTime(t["Date"]);
l.DayStocks.Add(interval);
db.days.Add(interval);
}
}
sqlConnection.Close();
db.SaveChanges();
break;
case "FourHour":
string constring1 = @"Data Source = (localdb)\MSSQLLocalDB; Initial Catalog = iMarketDB; Integrated Security = True";
sqlConnection = new SqlConnection(constring1);
sqlConnection.Open();
var result1 = from k in db.Symbols
where k.Name == textBoxNameSymbol.Text
select k;
foreach (var l in result1)
{
l.FourHours = new Collection <FourHour>();
foreach (DataRow t in table.Rows)
{
FourHour interval = new FourHour();
interval.Open = Convert.ToDecimal(t["Open"]);
interval.Close = Convert.ToDecimal(t["Close"]);
interval.Max = Convert.ToDecimal(t["High"]);
interval.Min = Convert.ToDecimal(t["low"]);
interval.Date = Convert.ToDateTime(t["Date"]);
l.FourHours.Add(interval);
db.fourHours.Add(interval);
}
}
db.SaveChanges();
break;
case "Hour":
string constring2 = @"Data Source = (localdb)\MSSQLLocalDB; Initial Catalog = iMarketDB; Integrated Security = True";
sqlConnection = new SqlConnection(constring2);
sqlConnection.Open();
var result2 = from k in db.Symbols
where k.Name == textBoxNameSymbol.Text
select k;
foreach (var l in result2)
{
l.Hours = new Collection <Hour>();
foreach (DataRow t in table.Rows)
{
Hour interval = new Hour();
interval.Open = Convert.ToDecimal(t["Open"]);
interval.Close = Convert.ToDecimal(t["Close"]);
interval.Max = Convert.ToDecimal(t["High"]);
interval.Min = Convert.ToDecimal(t["low"]);
interval.Date = Convert.ToDateTime(t["Date"]);
l.Hours.Add(interval);
db.hours.Add(interval);
}
}
db.SaveChanges();
break;
case "HalfHour":
string constring3 = @"Data Source = (localdb)\MSSQLLocalDB; Initial Catalog = iMarketDB; Integrated Security = True";
sqlConnection = new SqlConnection(constring3);
sqlConnection.Open();
var result3 = from k in db.Symbols
where k.Name == textBoxNameSymbol.Text
select k;
foreach (var l in result3)
{
l.HalfHours = new Collection <HalfHour>();
foreach (DataRow t in table.Rows)
{
HalfHour interval = new HalfHour();
interval.Open = Convert.ToDecimal(t["Open"]);
interval.Close = Convert.ToDecimal(t["Close"]);
interval.Max = Convert.ToDecimal(t["High"]);
interval.Min = Convert.ToDecimal(t["low"]);
interval.Date = Convert.ToDateTime(t["Date"]);
l.HalfHours.Add(interval);
db.halfHours.Add(interval);
}
}
db.SaveChanges();
break;
}
}
else if (Data.symbolNameList.Count != 0)
{
Symbol symbol1 = new Symbol();
symbol1.Name = textBoxNameSymbol.Text;
switch (Name)
{
case "Day":
symbol1.DayStocks = new Collection <DayStock>();
foreach (DataRow t in table.Rows)
{
DayStock interval = new DayStock();
interval.Open = Convert.ToDecimal(t["Open"]);
interval.Close = Convert.ToDecimal(t["Close"]);
interval.Max = Convert.ToDecimal(t["High"]);
interval.Min = Convert.ToDecimal(t["low"]);
interval.Date = Convert.ToDateTime(t["Date"]);
symbol1.DayStocks.Add(interval);
}
db.Symbols.Add(symbol1);
db.SaveChanges();
break;
case "FourHour":
symbol1.FourHours = new Collection <FourHour>();
foreach (DataRow t in table.Rows)
{
FourHour interval = new FourHour();
interval.Open = Convert.ToDecimal(t["Open"]);
interval.Close = Convert.ToDecimal(t["Close"]);
interval.Max = Convert.ToDecimal(t["High"]);
interval.Min = Convert.ToDecimal(t["low"]);
interval.Date = Convert.ToDateTime(t["Date"]);
symbol1.FourHours.Add(interval);
}
db.Symbols.Add(symbol1);
db.SaveChanges();
break;
case "Hour":
symbol1.Hours = new Collection <Hour>();
foreach (DataRow t in table.Rows)
{
Hour interval = new Hour();
interval.Open = Convert.ToDecimal(t["Open"]);
interval.Close = Convert.ToDecimal(t["Close"]);
interval.Max = Convert.ToDecimal(t["High"]);
interval.Min = Convert.ToDecimal(t["low"]);
interval.Date = Convert.ToDateTime(t["Date"]);
symbol1.Hours.Add(interval);
}
db.Symbols.Add(symbol1);
db.SaveChanges();
break;
case "HalfHour":
symbol1.HalfHours = new Collection <HalfHour>();
foreach (DataRow t in table.Rows)
{
HalfHour interval = new HalfHour();
interval.Open = Convert.ToDecimal(t["Open"]);
interval.Close = Convert.ToDecimal(t["Close"]);
interval.Max = Convert.ToDecimal(t["High"]);
interval.Min = Convert.ToDecimal(t["low"]);
interval.Date = Convert.ToDateTime(t["Date"]);
symbol1.HalfHours.Add(interval);
}
break;
}
}
}
