public void UpdateCategorie(CategorieModel categorie, int product, int sport)
{
try
{
conn.Open();
string insertString = @"update categorie set sport=@sport, product=@product, producttype=@type where categorie_Id=@categorie_id";
MySqlCommand cmd = new MySqlCommand(insertString, conn);
MySqlParameter sportParam = new MySqlParameter("@sport", MySqlDbType.Int32);
MySqlParameter productParam = new MySqlParameter("@product", MySqlDbType.Int32);
MySqlParameter typeParam = new MySqlParameter("@type", MySqlDbType.VarChar);
MySqlParameter IDParam = new MySqlParameter("@categorie_id", MySqlDbType.Int32);
sportParam.Value = sport;
productParam.Value = product;
typeParam.Value = categorie.type;
IDParam.Value = categorie.id;
cmd.Parameters.Add(sportParam);
cmd.Parameters.Add(productParam);
cmd.Parameters.Add(typeParam);
cmd.Parameters.Add(IDParam);
cmd.Prepare();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.Write("Updaten categorie niet gelukt: " + e);
throw e;
}
finally
{
conn.Close();
}
}
public void InsertCategorie(CategorieModel categorie, int producten)
{
try
{
conn.Open();
string insertString = @"insert into categorie (sport, product, producttype) values (@sport, @product, @type)";
MySqlCommand cmd = new MySqlCommand(insertString, conn);
MySqlParameter sportParam = new MySqlParameter("@sport", MySqlDbType.Int32);
MySqlParameter productParam = new MySqlParameter("@product", MySqlDbType.Int32);
MySqlParameter typeParam = new MySqlParameter("@type", MySqlDbType.VarChar);
sportParam.Value = categorie.sport;
productParam.Value = producten;
typeParam.Value = categorie.type;
cmd.Parameters.Add(sportParam);
cmd.Parameters.Add(productParam);
cmd.Parameters.Add(typeParam);
cmd.Prepare();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.Write("Evenement niet toegevoegd: " + e);
throw e;
}
finally
{
conn.Close();
}
}