MySql.Data.MySqlClient.MySqlConnection.BeginTransaction C# (CSharp) Method

        public new MySqlTransaction BeginTransaction()
        {
            return BeginTransaction(IsolationLevel.RepeatableRead);
        }

        public static bool SettingsSetPassword(string password)
        {
            using (MySqlConnection mySqlCon = new MySqlConnection(LiveDocs.backend.database.Database.ConnectionString))
            {
                mySqlCon.Open();
                using (MySqlTransaction mySqlTransaction = mySqlCon.BeginTransaction())
                {
                    using (MySqlCommand mySqlCommand = mySqlCon.CreateCommand())
                    {
                        mySqlCommand.Transaction = mySqlTransaction;
                        try
                        {
                            mySqlCommand.Parameters.AddWithValue("@password", password);
                            mySqlCommand.Parameters.AddWithValue("@username", HttpContext.Current.Session["username"]);
                            mySqlCommand.Parameters.AddWithValue("@token", HttpContext.Current.Session["token"]);
                            mySqlCommand.CommandText =
                                "UPDATE Users SET Password=Password(@password) WHERE UserName=@username AND LoginToken=@token";

                            mySqlCommand.ExecuteNonQuery();
                            mySqlTransaction.Commit();
                        }
                        catch (Exception)
                        {
                            mySqlTransaction.Rollback();
                            return false;
                        }
                    }
                }
            }
            return true;
        }