/// <summary> /// Create line csv /// </summary> /// <param name="inf"></param> /// <returns></returns> private List <string> GetLine(Infors inf) { List <string> data = new List <string>(); data.Add(inf.Codneg); data.Add(inf.Data.ToString("dd/MM/yyyy")); data.Add(inf.Abertura.Point()); data.Add(inf.Maxima.Point()); data.Add(inf.Minima.Point()); data.Add(inf.Fechamento.Point()); data.Add(inf.Empresa); return(data); }
/// <summary> /// Read file /// </summary> /// <param name="file"></param> public IEnumerable <Infors> Series(string file) { using (StreamReader reader = new StreamReader(file)) { string ln; int counter = 0; List <Infors> infors = new List <Infors>(); while ((ln = reader.ReadLine()) != null) { counter++; // it's header, next if (counter == 1) { continue; } if (!this.Check(ln)) { continue; } Infors inf = new Infors(); //infors.Add(inf); inf.Codneg = this.Str(ln, 12, 13); inf.Empresa = this.Str(ln, 12, 28); inf.Data = this.Date(ln, 8, 3); inf.Abertura = this.Value(ln, 11, 57); inf.Maxima = this.Value(ln, 11, 70); inf.Minima = this.Value(ln, 11, 83); inf.Fechamento = this.Value(ln, 11, 109); // return line by line yield return(inf); } } }