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); } }