Пример #1
0
        public void UpdateAccount(SqlAccountData account)
        {
            using (var con = new MySqlConnection(_connectionString))
                using (var cmd = new MySqlCommand())
                {
                    con.Open();

                    cmd.Connection  = con;
                    cmd.CommandText = "UPDATE accounts " +
                                      "SET password = @password, " +
                                      "email = @email, " +
                                      "is_admin = @is_admin, " +
                                      "is_guest = @is_guest, " +
                                      "is_email_confirmed = @is_email_confirmed " +
                                      "WHERE account_id = @account_id";
                    cmd.Parameters.AddWithValue("@password", account.Password);
                    cmd.Parameters.AddWithValue("@email", account.Email);
                    cmd.Parameters.AddWithValue("@is_admin", account.IsAdmin ? 1 : 0);
                    cmd.Parameters.AddWithValue("@is_guest", account.IsGuest ? 1 : 0);
                    cmd.Parameters.AddWithValue("@is_email_confirmed", account.IsEmailConfirmed ? 1 : 0);
                    cmd.Parameters.AddWithValue("@account_id", account.AccountId);

                    cmd.ExecuteNonQuery();
                }
        }
Пример #2
0
        private SqlAccountData ReadAccountData(MySqlDataReader reader, MySqlCommand cmd)
        {
            SqlAccountData account = null;

            // Read primary account data
            while (reader.Read())
            {
                account = new SqlAccountData
                {
                    AccountId        = reader.GetInt32("account_id"),
                    Email            = reader["email"] as string,
                    Password         = reader["password"] as string,
                    IsAdmin          = reader["is_admin"] as bool? ?? false,
                    IsGuest          = reader["is_guest"] as bool? ?? false,
                    IsEmailConfirmed = reader["is_email_confirmed"] as bool? ?? false,
                    Properties       = new Dictionary <string, string>(),
                    Token            = reader["token"] as string
                }
            }
            ;

            if (account == null)
            {
                return(null);
            }

            // Read account values
            reader.Close();

            cmd.CommandText = "SELECT * FROM account_properties WHERE account_id = @account_id";
            cmd.Parameters.Clear();
            cmd.Parameters.AddWithValue("@account_id", account.AccountId);
            reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                var key   = reader["prop_key"] as string ?? "";
                var value = reader["prop_val"] as string ?? "";

                if (string.IsNullOrEmpty(key))
                {
                    continue;
                }

                account.Properties[key] = value;
            }

            return(account);
        }
    }
Пример #3
0
        public void SavePasswordResetCode(SqlAccountData account, string code)
        {
            using (var con = new MySqlConnection(_connectionString))
                using (var cmd = new MySqlCommand())
                {
                    con.Open();

                    cmd.Connection  = con;
                    cmd.CommandText = "INSERT INTO password_reset_codes (email, code) " +
                                      "VALUES(@email, @code) " +
                                      "ON DUPLICATE KEY UPDATE code = @code";

                    cmd.Parameters.AddWithValue("@email", account.Email);
                    cmd.Parameters.AddWithValue("@code", code);
                    cmd.ExecuteNonQuery();
                }
        }
Пример #4
0
        public void InsertToken(SqlAccountData account, string token)
        {
            using (var con = new MySqlConnection(_connectionString))
                using (var cmd = new MySqlCommand())
                {
                    con.Open();

                    cmd.Connection  = con;
                    cmd.CommandText = "UPDATE accounts " +
                                      "SET token = @token " +
                                      "WHERE account_id = @account_id";
                    cmd.Parameters.AddWithValue("@token", token);
                    cmd.Parameters.AddWithValue("@account_id", account.AccountId);

                    account.Token = token;

                    cmd.ExecuteNonQuery();
                }
        }
Пример #5
0
        public void InsertNewAccount(SqlAccountData account)
        {
            using (var con = new MySqlConnection(_connectionString))
                using (var cmd = new MySqlCommand())
                {
                    con.Open();

                    cmd.Connection  = con;
                    cmd.CommandText = "INSERT INTO accounts " +
                                      "SET email = @email, " +
                                      "password = @password, " +
                                      "is_admin = @is_admin, " +
                                      "is_guest = @is_guest, " +
                                      "is_email_confirmed = @is_email_confirmed ";

                    cmd.Parameters.AddWithValue("@password", account.Password);
                    cmd.Parameters.AddWithValue("@email", account.Email);
                    cmd.Parameters.AddWithValue("@is_admin", account.IsAdmin ? 1 : 0);
                    cmd.Parameters.AddWithValue("@is_guest", account.IsGuest ? 1 : 0);
                    cmd.Parameters.AddWithValue("@is_email_confirmed", account.IsEmailConfirmed ? 1 : 0);
                    cmd.ExecuteNonQuery();
                    account.AccountId = (int)cmd.LastInsertedId;
                }
        }