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