/// <summary> /// Writes user's data into database. /// </summary> /// <param name="user"></param> /// <returns></returns> public static bool RegisterUser(RegisterUserModel user) { SqlConnection connection = new SqlConnection(DataConnections.OwnerUAconnectionString); connection.Open(); // giving all user data needed for registration SqlCommand registerUserCommand = new SqlCommand("dbo.Users_RegisterUser", connection); registerUserCommand.CommandType = System.Data.CommandType.StoredProcedure; registerUserCommand.Parameters.AddWithValue("@FirstName", user.FirstName); registerUserCommand.Parameters.AddWithValue("@LastName", user.LastName); registerUserCommand.Parameters.AddWithValue("@Phone", user.Phone); registerUserCommand.Parameters.AddWithValue("@Email", user.Email); registerUserCommand.Parameters.AddWithValue("@Hash", BCryptHashing.HashPassword(user.Password)); // executing stored procedure, saving number of rows it affected int rowsAffected = registerUserCommand.ExecuteNonQuery(); connection.Close(); // operation was successful if data was written into database return(rowsAffected > 0); }