public void createUser(User user)
{
NpgsqlConnection connection = DBConnectionService.getFreeConnection();
NpgsqlCommand command = new NpgsqlCommand(createUsersCommand, connection);
// cmd.Parameters.Add(new NpgsqlParameter("pw", tb2.Text));
command.Parameters.AddWithValue("@login", NpgsqlTypes.NpgsqlDbType.Text, user.login);
command.Parameters.AddWithValue("@pass", NpgsqlTypes.NpgsqlDbType.Text, user.password);
command.Parameters.AddWithValue("@nicename", NpgsqlTypes.NpgsqlDbType.Text, user.nicename);
command.Parameters.AddWithValue("@email", NpgsqlTypes.NpgsqlDbType.Text, user.email);
command.Parameters.AddWithValue("@url", NpgsqlTypes.NpgsqlDbType.Text, user.url);
command.Parameters.AddWithValue("@registered", NpgsqlTypes.NpgsqlDbType.TimestampTZ, user.registered);
command.Parameters.AddWithValue("@activation_key", NpgsqlTypes.NpgsqlDbType.Text, user.activationKey);
command.Parameters.AddWithValue("@status", NpgsqlTypes.NpgsqlDbType.Integer, user.status);
command.Parameters.AddWithValue("@display_name", NpgsqlTypes.NpgsqlDbType.Text, user.viewName);
int result = command.ExecuteNonQuery();
DBConnectionService.returnConnection(connection);
}
public static void updateUser(User user)
{
UsersRepository.Singleton.updateUser(user);
}
public static void createUser(User user)
{
UsersRepository.Singleton.createUser(user);
}