public static IEnumerable <CsharpExcelTestData> LoadCsharpExcelTestData()
{
IEnumerable <CsharpExcelTestData> returnValue = null;
string contents = File.ReadAllText(@"Data/CsharpExcelTestData.csv");
// ***
// ***
// ***
returnValue = (from tbl in TestDirector.ParseCsv(contents)
select new CsharpExcelTestData()
{
Value1 = Convert.ToDecimal(tbl["Value1"]),
Value2 = Convert.ToDecimal(tbl["Value2"]),
Value3 = Convert.ToDecimal(tbl["Value3"]),
Radians = Convert.ToDecimal(tbl["Radians"]),
Degrees = Convert.ToDecimal(tbl["Degrees"]),
Mod = Convert.ToDecimal(tbl["Mod"]),
Sin = Convert.ToDecimal(tbl["Sin"]),
Asin = Convert.ToDecimal(tbl["Asin"]),
Cos = Convert.ToDecimal(tbl["Cos"]),
Acos = Convert.ToDecimal(tbl["Acos"]),
Tan = Convert.ToDecimal(tbl["Tan"])
}).ToArray();
return(returnValue);
}
public static IEnumerable <AngleTestData> LoadAngleTestData()
{
IEnumerable <AngleTestData> returnValue = null;
string contents = File.ReadAllText(@"Data/AngleTestData.csv");
// ***
// ***
// ***
returnValue = (from tbl in TestDirector.ParseCsv(contents)
select new AngleTestData()
{
Angle = Convert.ToDecimal(tbl["Angle2"]),
Radians = Convert.ToDecimal(tbl["Radians"]),
Degrees = Convert.ToDecimal(tbl["Degrees"]),
DecimalMinutes = Convert.ToDecimal(tbl["DecimalMinutes"]),
Arcminute = Convert.ToDecimal(tbl["Arcminute"]),
Arcsecond = Convert.ToDecimal(tbl["Arcsecond"]),
LongFormat = tbl["LongFormat"],
ShortFormat = tbl["ShortFormat"],
RandomNumber = Convert.ToDecimal(tbl["RandomNumber"]),
RadiansMultiplied = Convert.ToDecimal(tbl["RadiansMultiplied"]),
RadiansDivided = Convert.ToDecimal(tbl["RadiansDivided"]),
ReducedDegrees = Convert.ToDecimal(tbl["ReducedDegrees"]),
TotalMinutes = Convert.ToDecimal(tbl["TotalMinutes"]),
TotalSeconds = Convert.ToDecimal(tbl["TotalSeconds"]),
OppositeDirection = Convert.ToDecimal(tbl["OppositeDirection"])
}).ToArray();
return(returnValue);
}
public static IEnumerable <DateValueTestData> LoadDateValueTestData()
{
IEnumerable <DateValueTestData> returnValue = null;
string contents = File.ReadAllText(@"Data/DateValueTestData.csv");
// ***
// ***
// ***
returnValue = (from tbl in TestDirector.ParseCsv(contents)
select new DateValueTestData()
{
Date = DateTime.Parse(tbl["Date"]),
DateValue = Convert.ToDecimal(tbl["DateValue"])
}).ToArray();
return(returnValue);
}
public static IEnumerable <SolarCalculationsTestData> LoadSolarCalculatorTestData()
{
IEnumerable <SolarCalculationsTestData> returnValue = null;
string contents = File.ReadAllText(@"Data/SolarCalculationsTestData.csv");
// ***
// ***
// ***
returnValue = (from tbl in TestDirector.ParseCsv(contents)
select new SolarCalculationsTestData()
{
Date = DateTime.Parse(tbl["Date"]),
Time = DateTime.Parse(tbl["Time"]),
TimeZoneOffset = Convert.ToInt32(tbl["TimeZoneOffset"]),
Latitude = Convert.ToDecimal(tbl["Latitude"]),
Longitude = Convert.ToDecimal(tbl["Longitude"]),
JulianDay = Convert.ToDecimal(tbl["JulianDay"]),
JulianCentury = Convert.ToDecimal(tbl["JulianCentury"]),
GeomMeanLongSun = Convert.ToDecimal(tbl["GeomMeanLongSun"]),
GeomMeanAnomSun = Convert.ToDecimal(tbl["GeomMeanAnomSun"]),
EccentEarthOrbit = Convert.ToDecimal(tbl["EccentEarthOrbit"]),
SunEqofCtr = Convert.ToDecimal(tbl["SunEqofCtr"]),
SunTrueLong = Convert.ToDecimal(tbl["SunTrueLong"]),
SunAppLong = Convert.ToDecimal(tbl["SunAppLong"]),
MeanObliqEcliptic = Convert.ToDecimal(tbl["MeanObliqEcliptic"]),
ObliqCorr = Convert.ToDecimal(tbl["ObliqCorr"]),
SunDeclin = Convert.ToDecimal(tbl["SunDeclin"]),
Vary = Convert.ToDecimal(tbl["vary"]),
EqofTime = Convert.ToDecimal(tbl["EqofTime"]),
HaSunrise = Convert.ToDecimal(tbl["HaSunrise"]),
SolarNoon = DateTime.Parse(tbl["SolarNoon"]),
SunriseTime = DateTime.Parse(tbl["SunriseTime"]),
SunsetTime = DateTime.Parse(tbl["SunsetTime"]),
SunlightDuration = Convert.ToDouble(tbl["SunlightDuration"]),
TrueSolarTime = Convert.ToDecimal(tbl["TrueSolarTime"])
}).ToArray();
return(returnValue);
}
