public static void vernieuwContactInfo(Contact info)
{
SqlConnection connection = DALConnection.GetConnectionByName("Writer");
//update user info, creating the query
string sqlQuery = "UPDATE ContactInfo SET PersoonId = @PersoonId, Straat = @Straat, Huisnummer = @Huisnummer, Huisnummertoevoeging = @Huisnummertoevoeging, Plaats = @Plaats, Postcode = @Postcode, Email = @Email, Telefoon = @Telefoon WHERE ContactInfoId = @ContactInfoId";
SqlCommand command = new SqlCommand(sqlQuery, connection);
//replace parameters by values
command.Parameters.AddWithValue("PersoonId", info.Persoonid);
command.Parameters.AddWithValue("Straat", info.Straat);
command.Parameters.AddWithValue("Huisnummer", info.Huisnummer);
command.Parameters.AddWithValue("Huisnummertoevoeging", info.Huisnummertoevoeging);
command.Parameters.AddWithValue("Plaats", info.Plaats);
command.Parameters.AddWithValue("Postcode", info.Postcode);
command.Parameters.AddWithValue("Email", info.Email);
command.Parameters.AddWithValue("Telefoon", info.Telefoon);
command.Parameters.AddWithValue("ContactInfoId", info.Id);
command.ExecuteNonQuery();
//close connection
DALConnection.CloseSqlConnection(connection);
}