public void Add(Strip strip)
{
StripDB stripDB = ConvertToDatalayer.convertToStripDb(strip);
var sqlQueryBuilder = new SqlQueryBuilder <StripDB>(stripDB);
ExecuteCommand(sqlQueryBuilder.GetInsertCommand());
AddStripHasAuteur(stripDB);
}
public void DeleteById(int id)
{
DeleteStripIdFromStripHasAuteur(id);
StripDB Stripdb = ConvertToDatalayer.convertToStripDb(GetById(id));
var sqlQueryBuilder = new SqlQueryBuilder <StripDB>(Stripdb);
ExecuteCommand(sqlQueryBuilder.GetDeleteCommand());
}
public void Update(Strip strip)
{
StripDB newstrip = ConvertToDatalayer.convertToStripDb(strip);
{
var command = new SqlCommand("update Strip set id = @id, Titel = @title, Nummer = @nummer, Reeks_id = @reeks, Uitgeverij_id = @uitgeverij WHERE id = @id");
command.Parameters.Add(new SqlParameter("id", newstrip.ID));
command.Parameters.Add(new SqlParameter("title", newstrip.StripTitel));
command.Parameters.Add(new SqlParameter("nummer", newstrip.StripNr));
command.Parameters.Add(new SqlParameter("reeks", newstrip.Reeks.ID));
command.Parameters.Add(new SqlParameter("uitgeverij", newstrip.Uitgeverij.ID));
ExecuteCommand(command);
//Auteurs updaten
updateAuteurStrip(newstrip);
}
}