public void MaxHalfHour_Equals31stDecemberYear9998LastHalfHour()
{
var maxHalfHour = HalfHour.MaxHalfHour;
var thirtyFirstDec9998LastHalfHour = new HalfHour(9998, 12, 31, 23, 30);
Assert.AreEqual(thirtyFirstDec9998LastHalfHour, maxHalfHour);
}
public void ToString_FormatStringNull_ReturnsIso8601Format()
{
var hour = new HalfHour(2020, 1, 20, 9, 30);
string formatted = hour.ToString((string)null);
Assert.AreEqual("2020-01-20 09:30", formatted);
}
public void MinHalfHour_Equals1stJanuaryYear1FirstHalfHour()
{
var minHalfHour = HalfHour.MinHalfHour;
var jan0001FirstHalfHour = new HalfHour(1, 1, 1, 0, 0);
Assert.AreEqual(jan0001FirstHalfHour, minHalfHour);
}
public void ToString_CustomFormatString_AsExpected()
{
var halfHour = new HalfHour(2020, 1, 20, 9, 30);
string formatted = halfHour.ToString("yyyy M d");
Assert.AreEqual("2020 1 20", formatted);
}
public void ToString_InvariantCultureFormatProvider_TextWithColonTimeSeparator()
{
var halfHour = new HalfHour(2020, 1, 20, 9, 30);
string formatted = halfHour.ToString(CultureInfo.InvariantCulture);
Assert.AreEqual("2020-01-20 09:30", formatted);
}
public void Parse_EqualsExpectedResult(HalfHourTestItem <string> testItem)
{
var halfHourFromText = HalfHour.Parse(testItem.ExpectedResult); // TODO bad use of Expected result?
var expectedHalfHour = testItem.Create();
Assert.AreEqual(expectedHalfHour, halfHourFromText);
}
private static void OffsetOperators()
{
#region offset_operators
var calYear19 = new CalendarYear(2019);
CalendarYear calYear22 = calYear19 + 3;
Console.WriteLine(calYear22);
int yearsDifference = calYear22 - calYear19;
Console.WriteLine(yearsDifference);
// The increment ++, and decrement --, operators can also be used
var halfHour = new HalfHour(2019, 8, 30, 22, 0);
Console.WriteLine();
Console.WriteLine("Incrementing Half Hour");
Console.WriteLine(halfHour);
halfHour++;
Console.WriteLine(halfHour);
halfHour++;
Console.WriteLine(halfHour);
Console.WriteLine();
Console.WriteLine("Decrementing Half Hour");
halfHour--;
Console.WriteLine(halfHour);
halfHour--;
Console.WriteLine(halfHour);
halfHour--;
Console.WriteLine(halfHour);
Console.WriteLine();
#endregion offset_operators
}
public void ToString_NullFormatStringAndFormatProvider_AsExpected()
{
var halfHour = new HalfHour(2020, 1, 20, 9, 0);
CultureInfo culture = CultureInfo.CreateSpecificCulture("en-UK");
DateTimeFormatInfo dateTimeFormat = culture.DateTimeFormat;
dateTimeFormat.TimeSeparator = ".";
string formatted = halfHour.ToString(null, dateTimeFormat);
Assert.AreEqual("2020-01-20 09.00", formatted);
}
public void ToString_FormatProviderWithDotTimeSeparator_TextWithDotTimeSeparator()
{
var halfHour = new HalfHour(2020, 1, 20, 9, 0);
CultureInfo culture = CultureInfo.CreateSpecificCulture("en-UK");
DateTimeFormatInfo dateTimeFormat = culture.DateTimeFormat;
dateTimeFormat.TimeSeparator = ".";
string formatted = halfHour.ToString(dateTimeFormat);
Assert.AreEqual("2020-01-20 09.00", formatted);
}
public void LoadHalfHoursCandle(Symbol h, string pathtofile)
{
var tableHalfHours = LoadExelSheetToTable(@"D:\DDE1.xlsx", pathtofile);
h.HalfHours = new Collection <HalfHour>();
HalfHour interval4 = new HalfHour();
foreach (DataRow p in tableHalfHours.Rows)
{
interval4.Open = Convert.ToDecimal(p["Bid"]);
interval4.Max = Convert.ToDecimal(p["High"]);
interval4.Min = Convert.ToDecimal(p["low"]);
interval4.Date = Convert.ToDateTime(p["Time"]);
}
Thread.Sleep(90000);
var table5 = LoadExelSheetToTable(@"D:\DDE1.xlsx", pathtofile);
foreach (DataRow j in table5.Rows)
{
interval4.Close = Convert.ToDecimal(j["Ask"]);
}
h.HalfHours.Add(interval4);
db.halfHours.Add(interval4);
}
public void Parse_WithInvalidText_ThrowsFormatArgumentException(string text)
{
Assert.Throws(Is.TypeOf <FormatException>(), () => HalfHour.Parse(text));
}
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;
}
}
}
