void PopulateArray(clsDataConnection DB)
{
Int32 Index = 0;
Int32 RecordCount = 0;
Int32 SearchOrderId = 0;
RecordCount = DB.Count;
mOrdersList = new List <clsOrders>();
//While there are records
while (Index < RecordCount)
{
//Create a blank order
clsOrders Orders = new clsOrders();
//Read in fields from current record and assign to tblOrder object attributes
Orders.OrderId = Convert.ToInt32(DB.DataTable.Rows[Index]["OrderId"]);
SearchOrderId = Convert.ToInt32(DB.DataTable.Rows[Index]["OrderId"]);
Orders.DispatchedStatus = Convert.ToBoolean(DB.DataTable.Rows[Index]["DispatchedStatus"]);
Orders.DeliveryAddress = Convert.ToString(DB.DataTable.Rows[Index]["DeliveryAddress"]);
Orders.OrderDate = Convert.ToDateTime(DB.DataTable.Rows[Index]["OrderDate"]);
clsDataConnection DBO = new clsDataConnection();
DBO.AddParameter("@OrderId", SearchOrderId);
DBO.Execute("sproc_tblOrderline_Filter_By_OrderId");
Orders.ItemId = Convert.ToInt32(DBO.DataTable.Rows[0]["ItemId"]);
Orders.Quantity = Convert.ToInt32(DBO.DataTable.Rows[0]["Quantity"]);
Orders.ProductCode = Convert.ToString(DBO.DataTable.Rows[0]["ProductCode"]);
Orders.UnitPrice = Convert.ToDouble(DBO.DataTable.Rows[0]["UnitPrice"]);
mOrdersList.Add(Orders);
Index++;
}
}
