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