Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void Update(User entity, Address address)
- {
- using (var myConnection = new SqlConnection(ConnectionString))
- {
- using (var myCommand = myConnection.CreateCommand())
- {
- myCommand.CommandText = "UPDATE users " +
- "SET first_name = @first_name, last_name = @last_name, username = @username, access_level = @access_level, email = @email, password = @password, is_new = @is_new, is_active = @is_active " +
- "WHERE id = @id";
- myCommand.Parameters.Add("@first_name", SqlDbType.VarChar).Value = entity.FirstName;
- myCommand.Parameters.Add("@last_name", SqlDbType.VarChar).Value = entity.LastName;
- myCommand.Parameters.Add("@username", SqlDbType.VarChar).Value = entity.UserName;
- myCommand.Parameters.Add("@access_level", SqlDbType.Int).Value = entity.AccessLevel;
- myCommand.Parameters.Add("@email", SqlDbType.VarChar).Value = entity.Email;
- myCommand.Parameters.Add("@password", SqlDbType.VarChar).Value = entity.Password;
- myCommand.Parameters.Add("@is_new", SqlDbType.Bit).Value = entity.IsNew;
- myCommand.Parameters.Add("@is_active", SqlDbType.Bit).Value = entity.IsActive;
- myCommand.Parameters.Add("@id", SqlDbType.Int).Value = entity.Id;
- try
- {
- myConnection.Open();
- myCommand.ExecuteNonQuery();
- myCommand.Parameters.Clear();
- myCommand.CommandText = "UPDATE addresses " +
- "SET street1 = @street1, city = @city, state = @state, zip = @zip, country_id = @country_id " +
- "WHERE user_id = @id";
- myCommand.Parameters.Add("@street1", SqlDbType.NVarChar).Value = address.Street1;
- myCommand.Parameters.Add("@city", SqlDbType.NVarChar).Value = address.City;
- myCommand.Parameters.Add("@state", SqlDbType.NVarChar).Value = address.State;
- myCommand.Parameters.Add("@zip", SqlDbType.NVarChar).Value = address.Zip;
- myCommand.Parameters.Add("@country_id", SqlDbType.Int).Value = address.CountryId;
- myCommand.Parameters.Add("@id", SqlDbType.Int).Value = address.Id;
- myCommand.ExecuteNonQuery();
- }
- catch (Exception)
- {
- throw;
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement