public Bike GetBike(int id)
{
SqlCommand command = new SqlCommand("SELECT * FROM Bikes WHERE ID=@id");
command.Parameters.AddWithValue("@id", id);
DataSet set = ExecuteQuery(command, QueryType.Query);
DataRow row = set.Tables[0].Rows[0];
string bikeDescription = (string)row["BikeDescription"];
decimal pricePerDay = (decimal)row["PricePerDay"];
Bikekind kind = (Bikekind)row["BikeKind"];
return(new Bike(pricePerDay, bikeDescription, kind, id));
}
/// <summary>
/// Gets all bikes that are in the database
/// </summary>
/// <remarks>
///
/// </remarks>
/// <returns>A list of all bikes</returns>
public List <Bike> GetAllBikes()
{
SqlCommand command = new SqlCommand("SELECT * FROM Bikes");
List <Bike> bikes = new List <Bike>();
DataSet set = ExecuteQuery(command, QueryType.Query);
foreach (DataRow row in set.Tables[0].Rows)
{
string bikeDescription = (string)row["BikeDescription"];
decimal pricePerDay = (decimal)row["PricePerDay"];
Bikekind kind = (Bikekind)row["BikeKind"];
int id = (int)row["ID"];
bikes.Add(new Bike(pricePerDay, bikeDescription, kind, id));
}
return(bikes);
}
