public static Genre VerwerkRij(IDataRecord rij)
{
Genre type = new Genre();
type.ID = Convert.ToInt32(rij["ID"].ToString());
type.Name = rij["Name"].ToString();
return type;
}
public static void AddType(Genre newgenre)
{
try
{
DbParameter paramName = Database.AddParameter("@Name", newgenre.Name);
Database.ModifyData("INSERT INTO Genre (Name) values (@Name)", paramName);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public static void DeleteType(Genre genre)
{
try
{
DbParameter paramName = Database.AddParameter("@Name", genre.Name);
Database.ModifyData("DELETE FROM Genre WHERE Name = @Name", paramName);
}
catch (Exception e)
{
throw e;
}
}
//Genre methods
private void AddGenre()
{
Genre newGenre = new Genre();
Genres.Add(newGenre);
SelectedGenre = newGenre;
}
public static void EditGenre(Genre gen)
{
try
{
string sql = "UPDATE Genre SET Name=@name WHERE ID=@ID;";
DbParameter par1 = Database.AddParameter("@name", gen.Name);
DbParameter parID = Database.AddParameter("@ID", Convert.ToInt32(gen.ID));
Database.ModifyData(sql, par1, parID);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
}