private List<SPCSInvoice> ReadInvoices(Connection connection)
{
int rowCount = connection.GetInvoiceCount();
int rowNr = 0;
List<SPCSInvoice> invoices = new List<SPCSInvoice>(rowCount);
using (TypedDataReader reader = connection.GetInvoiceReader())
{
using (SPCSConnection c = new SPCSConnection())
{
c.Open();
if (c.IsConnected)
{
SPCSInvoice invoice = null;
SPCSCustomer customer = null;
SPCSProject project = null;
int invoiceId = 0;
// For each invoice
while (reader.Read())
{
customer = new SPCSCustomer();
{
customer.CustomerName = reader.GetString(DataBase.InvoiceColumnNameCustomerName);
customer.CustomerNr = customer.GetId();
customer.CustomerReference = string.Format("{0} {1}", reader.GetString(DataBase.InvoiceColumnNameCustomerReferenceFirstName),
reader.GetString(DataBase.InvoiceColumnNameCustomerReferenceLastName));
}
project = new SPCSProject();
{
project.ProjectName = reader.GetString(DataBase.InvoiceColumnNameOurProject);
project.ProjectNr = project.GetId();
project.ProjectCustomerNr = customer.CustomerNr;
project.ProjectStartTime = DateTime.Today;
project.ProjectEndTime = DateTime.Today;
}
// Get invoice-head
invoice = new SPCSInvoice();
{
invoice.Customer = customer;
invoice.Project = project;
string date = reader.GetString(DataBase.InvoiceColumnNameDate);
if (!string.IsNullOrEmpty(date))
invoice.InvoiceDate = DateTime.Parse(date);
invoiceId = reader.GetInt(DataBase.InvoiceRowColumnNameInvoiceId);
invoice.InvoiceCustomerOrderNr = reader.GetString(DataBase.InvoiceColumnNameCustomerOrderNr);
invoice.InvoiceOurReferenceName = string.Format("{0} {1}", reader.GetString(DataBase.InvoiceColumnNameOurReferenceFirstName),
reader.GetString(DataBase.InvoiceColumnNameOurReferenceLastName));
}
// Get all invoice-rows
this.ReadInvoiceRows(connection, invoice, invoiceId);
invoices.Add(invoice);
Console.WriteLine(invoice.ToString());
this.OnProcessValueChanged(++rowNr, rowCount, ProcressAction.ReadFromDB);
}
}
}
}
return invoices;
}
