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