public InventoryRecord[] GetInventory()
{
var d = new InventoryDal();
d.OpenConnection(ConnString);
var dt = d.GetAllInventoryAsDataTable();
d.CloseConnection();
var records = new List <InventoryRecord>();
var reader = dt.CreateDataReader();
while (reader.Read())
{
var r = new InventoryRecord()
{
Id = (int)reader["CarId"],
Color = ((string)reader["Color"]),
Make = ((string)reader["Make"]),
PetName = ((string)reader["PetName"])
};
records.Add(r);
}
return(records.ToArray());
}
private void RefreshGrid()
{
var dal = new InventoryDal();
dal.OpenConnection(ConnectionString);
DataTable carsDataTable = dal.GetAllInventoryAsDataTable();
dal.CloseConnection();
carsGridView.DataSource = carsDataTable;
carsGridView.DataBind();
}
private static void ListInventory(InventoryDal invDal)
{
DataTable dt = invDal.GetAllInventoryAsDataTable();
DisplayTable(dt);
}
private static void ListInventory(InventoryDal inventory)
{
var dt = inventory.GetAllInventoryAsDataTable();
DisplayTable(dt);
}