public IEnumerable <PayDoc> GetPayDocs() { using (SqlConnection cnn = new SqlConnection(sqlConnect)) { cnn.Open(); DataTable payDocs = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM dbo.PayDocs", cnn); adapter.Fill(payDocs); foreach (DataRow row in payDocs.Rows) { PayDoc payDoc = null; try { payDoc = new PayDoc(row["client"].ToString(), Convert.ToDateTime(row["date"]), row["number"].ToString(), Convert.ToDouble(row["sum"])); } catch (Exception ex) { Console.WriteLine(ex.Message); Console.ReadKey(); System.Environment.Exit(1); } yield return(payDoc); } } }
public IEnumerable <PayDoc> GetPayDocs() { string[] csv = File.ReadAllLines(payDocsPath); for (int i = 1; i < csv.Length; i++) { PayDoc payDoc = null; try { string[] data = csv[i].Split(';'); payDoc = new PayDoc(data[0], DateTime.Parse(data[1]), data[2], Double.Parse(data[3], CultureInfo.InvariantCulture)); } catch (Exception ex) { Console.WriteLine(ex.Message); Console.ReadKey(); System.Environment.Exit(1); } yield return(payDoc); } }