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