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