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();
}
