public IEnumerable <TauronLogItem> GetTauronLogDataCSV(string sFileName)
{
List <TauronLogItem> result;
result = File.ReadAllLines(sFileName).Skip(1).Select(v => TauronLogItem.FromCsv(v)).ToList();
return(result);
}
public static TauronLogItem FromCsv(string csvLine)
{
string[] values = csvLine.Split(';');
TauronLogItem tauronLogItemValues = new TauronLogItem();
tauronLogItemValues.InsertTimeStamp = Convert.ToDateTime(values[0]);
tauronLogItemValues.PowerConsumption = Convert.ToDouble(values[1]);
tauronLogItemValues.PowerProduction = Convert.ToDouble(values[2]);
return(tauronLogItemValues);
}
public IEnumerable <TauronLogItem> GetTauronLogData(string sFileName)
{
List <TauronLogItem> result = new List <TauronLogItem>();
string sConnetionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}; Extended Properties='Excel 12.0; IMEX=1; HDR=YES; TypeGuessRows=0; ImportMixedTypes=Text'", sFileName);
using (OleDbConnection conn = new OleDbConnection(sConnetionString))
{
conn.Open();
using (OleDbCommand cmd = new OleDbCommand("", conn))
{
cmd.CommandText = "SELECT * FROM [Dane$]";
using (OleDbDataReader rdr = cmd.ExecuteReader())
{
DateTime LastDateTime = DateTime.Now;
while (rdr.Read())
{
TauronLogItem temp = new TauronLogItem();
temp.InsertTimeStamp = LastDateTime = parseExact24h(rdr[0].ToString(), LastDateTime);
if (!string.IsNullOrWhiteSpace(rdr[1].ToString()))
{
temp.PowerConsumption = double.Parse(rdr[1].ToString());
}
if (!string.IsNullOrWhiteSpace(rdr[2].ToString()))
{
temp.PowerProduction = double.Parse(rdr[2].ToString());
}
if (!string.IsNullOrWhiteSpace(rdr[3].ToString()))
{
temp.CurrentTemperature = double.Parse(rdr[3].ToString());
}
result.Add(temp);
}
}
}
}
return(result);
}
