public void postBikeAndOrder(BikeAndOrder BikeAndOrder)
{
AddBikeAndOrderParametersForQuerry(
"insert into Utstyr_has_bestilling(utstyr_utstyr_id, bestilling_bestilling_id) values(@BikeAndOrder.Bike_id, @BikeAndOrder.Order_id);",
BikeAndOrder
);
}
public void UpdateBikeAndOrder(int bikeId, BikeAndOrder BikeAndOrder)
{
AddBikeAndOrderParametersForQuerry(
"update Utstyr_has_bestilling set [email protected]_id where bestilling_bestilling_id=" + bikeId.ToString() + ";",
BikeAndOrder
);
}
private void AddBikeAndOrderParametersForQuerry(string command, BikeAndOrder BikeAndOrder)
{
try
{
using (MySqlConnection conn = new MySqlConnection(ConnectionString))
{
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = command;
cmd.Parameters.AddWithValue("@BikeAndOrder.Bike_id", BikeAndOrder.Bike_id);
cmd.Parameters.AddWithValue("@BikeAndOrder.Order_id", BikeAndOrder.Order_id);
cmd.ExecuteNonQuery();
conn.Close();
}
}
catch (MySqlException e)
{
throw e;
}
}