public void DeleteById(int id)
{
ReeksDB dbreeks = ConvertToDatalayer.ConvertToReeksDb(GetById(id));
var sqlQueryBuilder = new SqlQueryBuilder <ReeksDB>(dbreeks);
ExecuteCommand(sqlQueryBuilder.GetDeleteCommand());
}
public void Add(Reeks reeks)
{
ReeksDB dbreeks = ConvertToDatalayer.ConvertToReeksDb(reeks);
var sqlQueryBuilder = new SqlQueryBuilder <ReeksDB>(dbreeks);
ExecuteCommand(sqlQueryBuilder.GetInsertCommand());
}
public void Update(Reeks Reeks)
{
{
ReeksDB newReeks = ConvertToDatalayer.ConvertToReeksDb(Reeks);
var command = new SqlCommand("update Reeks set id = @id, Name = @name WHERE id = @id");
command.Parameters.Add(new SqlParameter("id", newReeks.ID));
command.Parameters.Add(new SqlParameter("name", newReeks.Naam));
ExecuteCommand(command);
}
}
public override StripDB PopulateRecord(SqlDataReader reader)
{
return(new StripDB
{
ID = reader.GetInt32(0),
StripTitel = reader.GetString(1),
StripNr = reader.GetInt32(2),
Reeks = ConvertToDatalayer.ConvertToReeksDb(new ReeksRepository(DbFunctions.GetprojectwerkconnectionString()).GetById(reader.GetInt32(3))),
Uitgeverij = ConvertToDatalayer.ConvertToUitgeverijDb(new UitgeverijRepository(DbFunctions.GetprojectwerkconnectionString()).GetById(reader.GetInt32(4))),
Auteurs = ConvertToDatalayer.ConvertToAuteursDb(new AuteurRepository(DbFunctions.GetprojectwerkconnectionString()).GetStripAuteurs(reader.GetInt32(0)))
});
}