public static void EditGenre(Genre genre, String naam)
{
String sql = "UPDATE Genre Set Name=@naam WHERE ID=@Genre";
DbParameter par1 = Database.AddParameter("@Genre", genre._ID);
DbParameter par2 = Database.AddParameter("@naam", naam);
if (par2.Value == null) par2.Value = DBNull.Value;
Database.ModifyData(sql, par1, par2);
}
public static void DeleteGenre(Genre genre) {
String sql = "DELETE FROM Genre WHERE ID = @Genre";
DbParameter par1 = Database.AddParameter("@Genre", genre._ID);
if (par1.Value == null) par1.Value = DBNull.Value;
Database.ModifyData(sql, par1);
}
public static Genre getById(string GenreID)
{
Genre genre = new Genre();
String sSQL = "SELECT * FROM Genre WHERE ID = @ID";
DbParameter par1 = Database.AddParameter("@ID", GenreID);
if (par1.Value == null) par1.Value = DBNull.Value;
DbDataReader reader = Database.GetData(sSQL, par1);
while (reader.Read())
{
genre.ID = reader["ID"].ToString();
genre.Name = reader["Name"].ToString();
}
return genre;
}
//string IDataErrorInfo.Error
//{
// get { return "Model not valid"; }
//}
//string IDataErrorInfo.this[string columnName]
//{
// get
// {
// try
// {
// object value = this.GetType().GetProperty(columnName).GetValue(this);
// Validator.ValidateProperty(value, new ValidationContext(this, null, null)
// {
// MemberName = columnName
// });
// }
// catch (ValidationException ex)
// {
// return ex.Message;
// }
// return String.Empty;
// }
//}
#endregion
public static ObservableCollection<Genre> getAll()
{
ObservableCollection<Genre> lijst = new ObservableCollection<Genre>();
String sSQL = "SELECT * FROM Genre";
DbDataReader reader = Database.GetData(sSQL);
while (reader.Read())
{
Genre aNew = new Genre();
aNew.ID = reader["ID"].ToString();
aNew.Name = reader["Name"].ToString();
lijst.Add(aNew);
}
return lijst;
}
public static void DeleteBandGenre(Band band, Genre genre)
{
String sql = "DELETE FROM BandGenre WHERE BandId = @Band AND GenreId = @Genre";
DbParameter par1 = Database.AddParameter("@Band", band.ID);
DbParameter par2 = Database.AddParameter("@Genre", genre.ID);
if (par1.Value == null) par1.Value = DBNull.Value;
Database.ModifyData(sql, par1, par2);
}
public static void NewBandGenre(Band band, Genre genre)
{
String sql = "INSERT INTO BandGenre (BandId, GenreId) VALUES(@Band, @Genre)";
DbParameter par1 = Database.AddParameter("@Band", band.ID);
DbParameter par2 = Database.AddParameter("@Genre", genre.ID);
if (par1.Value == null) par1.Value = DBNull.Value;
Database.ModifyData(sql, par1, par2);
}