/// <summary>
/// This function is used to get all the invoices in the database.
/// returns an InvoiceList which is built up by getting invoices, items then linking new LinItem objects to each invoice object.
/// </summary>
/// <param name="Invoices"></param>
/// <returns></returns>
public static InvoiceList getAllInvoices(InvoiceList Invoices)
{
clsDataAccess dataAccess = new clsDataAccess();
int Invoices_Rows = 0;
int Item_Rows = 0;
int LineItem_Rows = 0;
//Create a new DataSet for Invoices
DataSet InvoicesDS = new DataSet();
//Create a new DataSet for Items
DataSet ItemsDS = new DataSet();
//Create a new DataSet for Items
DataSet ItemLinkDS = new DataSet();
ObservableCollection <Item> tempItemCollection = new ObservableCollection <Item>();
#region Get Invoices
//get Invoices dataset
InvoicesDS = clsMainSQL.getAllInvoices(ref Invoices_Rows);
// do stuff with datasets
//add Invoices into invoices list
for (int i = 0; i < Invoices_Rows; i++)
{
Invoice nextinvoice = new Invoice(
InvoicesDS.Tables[0].Rows[i]["InvoiceNum"].ToString(),
InvoicesDS.Tables[0].Rows[i]["InvoiceDate"].ToString(),
InvoicesDS.Tables[0].Rows[i]["TotalCost"].ToString());
Invoices.addInvoice(nextinvoice);
}
#endregion Get Invoices
#region Get Items
//get Item Descriptions dataset
ItemsDS = clsMainSQL.getItems(ref Item_Rows);
// do stuff with datasets
//add items to temporary collection
for (int i = 0; i < Item_Rows; i++)
{
Item Item = new Item(
ItemsDS.Tables[0].Rows[i]["ItemCode"].ToString(),
ItemsDS.Tables[0].Rows[i]["ItemDesc"].ToString(),
ItemsDS.Tables[0].Rows[i]["Cost"].ToString());
tempItemCollection.Add(Item);
}
#endregion Get Items
#region Link Items To Invoices
//get LineItems dataset
ItemLinkDS = clsMainSQL.getLineItems(ref LineItem_Rows);
// do stuff with datasets
// Load invoices with correct number of items for the order
for (int i = 0; i < LineItem_Rows; i++)
{
var invoiceNum = ItemLinkDS.Tables[0].Rows[i]["InvoiceNum"].ToString();
var ItemCode = ItemLinkDS.Tables[0].Rows[i]["ItemCode"].ToString();
var LineItemNumber = ItemLinkDS.Tables[0].Rows[i]["LineItemNum"].ToString();
var Quantity = ItemLinkDS.Tables[0].Rows[i]["Quantity"].ToString();
//get item
Item itemToAdd = tempItemCollection.Where(x => x.ItemCode == ItemCode).FirstOrDefault();
//find the invoice from invoices and add the item to it
Invoices.InvoicesCollection.Where(x => x.InvoiceNum == invoiceNum).FirstOrDefault().addItem(itemToAdd, Int32.Parse(Quantity));
}
#endregion Link Items To Invoices
return(Invoices);
}