public static void InsertLeg(Leg leg, Set set)
{
string query = "INSERT INTO leg (`id_leg`, `id_set`, `legNummer`, `rest`, `finish`) VALUES ('" + leg.GetId() + "', '" + set.GetId() + "', '" + leg.GetLegNummer() + "', '" + leg.GetRest() + "', '" + leg.GetFinish() + "')";
//open connection
if (OpenConnection() == true)
{
try
{
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine("Leg:" + e.Message);
Console.ReadLine();
}
//close connection
CloseConnection();
}
}
public static int Get_Finish(Leg l)
{
return(l.GetFinish());
}