Beispiel #1
0
        public static string getById(int id)
        {
            NpgsqlConnection connection = DBConnectionService.getFreeConnection();
            NpgsqlCommand    command    = new NpgsqlCommand(getByIdCommand, connection);

            command.Parameters.AddWithValue("@id", NpgsqlTypes.NpgsqlDbType.Integer, id);

            NpgsqlDataReader reader = command.ExecuteReader();

            string result;

            if (reader.HasRows)
            {
                reader.Read();
                result = reader.GetString(0);
            }
            else
            {
                result = null;
            }

            reader.Close();
            DBConnectionService.returnConnection(connection);

            return(result);
        }
Beispiel #2
0
        public static void updateUser(User user)
        {
            NpgsqlConnection connection = DBConnectionService.getFreeConnection();
            NpgsqlCommand    command    = new NpgsqlCommand(updateUsersCommand, connection);

            // cmd.Parameters.Add(new NpgsqlParameter("pw", tb2.Text));
            command.Parameters.AddWithValue("@id", NpgsqlTypes.NpgsqlDbType.Integer, user.id);
            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();

            if (result != 1)
            {
                throw new Exception("Error on user update");
            }

            DBConnectionService.returnConnection(connection);
        }
Beispiel #3
0
        public static string getPosts()
        {
            NpgsqlConnection connection = DBConnectionService.getFreeConnection();
            NpgsqlCommand    command    = new NpgsqlCommand(getPostsCommand, connection);
            NpgsqlDataReader reader     = command.ExecuteReader();

            reader.Read();
            string result = reader.GetString(5);

            reader.Close();

            DBConnectionService.returnConnection(connection);

            return(result);
        }
Beispiel #4
0
        public static void deleteUser(int id)
        {
            NpgsqlConnection connection = DBConnectionService.getFreeConnection();
            NpgsqlCommand    command    = new NpgsqlCommand(deleteUserCommand, connection);

            // cmd.Parameters.Add(new NpgsqlParameter("pw", tb2.Text));
            command.Parameters.AddWithValue("@id", NpgsqlTypes.NpgsqlDbType.Integer, id);

            int result = command.ExecuteNonQuery();

            if (result != 1)
            {
                throw new Exception("Error on user update");
            }

            DBConnectionService.returnConnection(connection);
        }
Beispiel #5
0
        public static string getAllUsers()
        {
            NpgsqlConnection connection = DBConnectionService.getFreeConnection();
            NpgsqlCommand    command    = new NpgsqlCommand(getAllUsersCommand, connection);
            NpgsqlDataReader reader     = command.ExecuteReader();

            string result;

            if (reader.HasRows)
            {
                reader.Read();
                result = reader.GetString(0);
            }
            else
            {
                result = "[]";
            }

            reader.Close();
            DBConnectionService.returnConnection(connection);

            return(result);
        }