public List<CarRecord> GetCars(int page, int pageSize)
{
DbLayer db = new DbLayer();
db.OpenConnection(ConnectionStr);
DataTable dt = db.GetCars(page, pageSize);
db.CloseConnection();
List<CarRecord> ls = new List<CarRecord>();
DataTableReader rd = dt.CreateDataReader();
while (rd.Read())
{
ls.Add(new CarRecord {
ID = (int) rd["ID"],
Make = (string) rd["Make"],
Model = (string) rd["Model"],
Year = (int) rd["Year"],
Doors = (int) rd["Doors"],
Colours = (string) rd["Colour"],
Price = (double) rd["Price"]
});
}
return ls;
}
public void InsertCar(CarRecord r)
{
DbLayer db = new DbLayer();
db.OpenConnection(ConnectionStr);
db.InsertCar(new Car {
Make = r.Make,
Model = r.Model,
Year = r.Year,
Doors = r.Doors,
Colour = r.Colours,
Price = r.Price
});
db.CloseConnection();
}