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