public InventoryRecord[] GetInventory()
{
// First, get the DataTable from the database.
InventoryDAL d = new InventoryDAL();
d.OpenConnection(ConnString);
DataTable dt = d.GetAllInventoryAsDataTable();
d.CloseConnection();
// Now make an List<T> to contain the records.
List<InventoryRecord> records = new List<InventoryRecord>();
// Copy data table into List<> of custom contracts.
DataTableReader reader = dt.CreateDataReader();
while (reader.Read())
{
InventoryRecord r = new InventoryRecord();
r.ID = (int)reader["CarID"];
r.Color = ((string)reader["Color"]);
r.Make = ((string)reader["Make"]);
r.PetName = ((string)reader["PetName"]);
records.Add(r);
}
// Transform List<T> to array of InventoryRecord types.
return (InventoryRecord[])records.ToArray();
}
private void RefreshGrid()
{
InventoryDAL dal = new InventoryDAL();
dal.OpenConnection(@"Data Source=(local)\SQLEXPRESS;" +
"Initial Catalog=AutoLot;Integrated Security=True");
DataTable theCars = dal.GetAllInventoryAsDataTable();
dal.CloseConnection();
carsGridView.DataSource = theCars;
carsGridView.DataBind();
}
static void ListInventoryAsTable(InventoryDAL invDal) {
Console.WriteLine("************* ListInventoryAsTable *********");
DataTable dt = invDal.GetAllInventoryAsDataTable();
DisplayTable(dt);
}
private static void ListInventory(InventoryDAL invDAL)
{
// Get the list of inventory.
DataTable dt = invDAL.GetAllInventoryAsDataTable();
DisplayTable(dt);
}