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