public void DeleteGenre(Genre genre)
{
MySqlTransaction trans = null;
try
{
conn.Open();
trans = conn.BeginTransaction();
string insertString = @"delete from genre where genre_id=@id";
MySqlCommand cmd = new MySqlCommand(insertString, conn);
MySqlParameter idParam = new MySqlParameter("@id", MySqlDbType.Int32);
idParam.Value = genre.ID;
cmd.Parameters.Add(idParam);
cmd.Prepare();
cmd.ExecuteNonQuery();
trans.Commit();
}
catch (Exception e)
{
trans.Rollback();
Console.Write("Genre niet verwijderd: " + e);
throw e;
}
finally
{
conn.Close();
}
}
protected Genre GetGenreFromDataReader(MySqlDataReader dataReader)
{
string genreNaam = dataReader.GetString("genrenaam");
int genreId = dataReader.GetInt32("genre_id");
bool verslavend = dataReader.GetBoolean("verslavend");
Genre genre = new Genre { ID = genreId, Naam = genreNaam, Verslavend = verslavend };
return genre;
}
public ActionResult CreateGenreModelBinding(Genre genre)
{
try
{
genreDBController.InsertGenre(genre);
}
catch (Exception e)
{
ViewBag.Foutmelding = "Er is iets fout gegaan:" + e;
}
return RedirectToAction("Index", "Genre");
}
public ActionResult CreateGenreParameterBinding(String name, String verslavend)
{
bool isVerslavend = verslavend == "on";
Genre genre = new Genre { Naam = name, Verslavend = isVerslavend };
try
{
genreDBController.InsertGenre(genre);
}
catch (Exception e)
{
ViewBag.Foutmelding = "Er is iets fout gegaan:" + e;
}
return RedirectToAction("Index", "Genre");
}
public ActionResult CreateGenreOldSchool()
{
String name = Request["name"];
bool verslavend = Request["verslavend"] == "on";
Genre genre = new Genre { Naam = name, Verslavend = verslavend };
try
{
genreDBController.InsertGenre(genre);
}
catch (Exception e)
{
ViewBag.Foutmelding = "Er is iets fout gegaan:" + e;
return View();
}
return RedirectToAction("Index", "Genre");
}
public ActionResult WijzigGenre(Genre genre)
{
try
{
genreDBController.UpdateGenre(genre);
}
catch (Exception e)
{
ViewBag.FoutMelding("Er is iets fout gegaan: " + e);
}
return RedirectToAction("Index", "Genre");
}
public void UpdateGenre(Genre genre)
{
MySqlTransaction trans = null;
try
{
conn.Open();
trans = conn.BeginTransaction();
string insertString = @"update genre set genrenaam=@genrenaam, verslavend=@verslavend where genre_id=@id";
MySqlCommand cmd = new MySqlCommand(insertString, conn);
MySqlParameter genrenaamParam = new MySqlParameter("@genrenaam", MySqlDbType.VarChar);
MySqlParameter verslavendParam = new MySqlParameter("@verslavend", MySqlDbType.Bit);
MySqlParameter idParam = new MySqlParameter("@id", MySqlDbType.Int32);
genrenaamParam.Value = genre.Naam;
verslavendParam.Value = genre.Verslavend;
idParam.Value = genre.ID;
cmd.Parameters.Add(genrenaamParam);
cmd.Parameters.Add(verslavendParam);
cmd.Parameters.Add(idParam);
cmd.Prepare();
cmd.ExecuteNonQuery();
trans.Commit();
}
catch (Exception e)
{
trans.Rollback();
Console.Write("Genre niet upgedate: " + e);
throw e;
}
finally
{
conn.Close();
}
}
public void InsertGenre(Genre genre)
{
MySqlTransaction trans = null;
try
{
conn.Open();
trans = conn.BeginTransaction();
string insertString = @"insert into genre (genrenaam, verslavend)
values (@genrenaam, @verslavend)";
MySqlCommand cmd = new MySqlCommand(insertString, conn);
MySqlParameter genrenaamParam = new MySqlParameter("@genrenaam", MySqlDbType.VarChar);
MySqlParameter verslavendParam = new MySqlParameter("@verslavend", MySqlDbType.Bit);
genrenaamParam.Value = genre.Naam;
verslavendParam.Value = genre.Verslavend;
cmd.Parameters.Add(genrenaamParam);
cmd.Parameters.Add(verslavendParam);
cmd.Prepare();
cmd.ExecuteNonQuery();
trans.Commit();
}
catch (Exception e)
{
trans.Rollback();
Console.Write("Genre niet toegevoegd: " + e);
throw e;
}
finally
{
conn.Close();
}
}