BusinessLogic.SqlMembershipProvider.GetUser C# (CSharp) Метод

GetUser() публичный Метод

public GetUser ( object providerUserKey, bool userIsOnline ) : System.Web.Security.MembershipUser
providerUserKey object
userIsOnline bool
Результат System.Web.Security.MembershipUser
        public override MembershipUser GetUser(object providerUserKey, bool userIsOnline)
        {
            SqlConnection conn = new SqlConnection(connectionString);
            SqlCommand cmd = new SqlCommand("SELECT PKID, Username, Email, PasswordQuestion," +
                  " Comment, IsApproved, IsLockedOut, CreationDate, LastLoginDate," +
                  " LastActivityDate, LastPasswordChangedDate, LastLockedOutDate" +
                  " FROM Users WHERE PKID = @PKID", conn);

            cmd.Parameters.AddWithValue("@PKID", providerUserKey);

            MembershipUser u = null;
            SqlDataReader reader = null;

            try
            {
                conn.Open();

                reader = cmd.ExecuteReader();

                if (reader.HasRows)
                {
                    reader.Read();
                    u = GetUserFromReader(reader);

                    if (userIsOnline)
                    {
                        SqlCommand updateCmd = new SqlCommand("UPDATE Users " +
                                  "SET LastActivityDate = @LastActivityDate " +
                                  "WHERE PKID = @PKID", conn);

                        updateCmd.Parameters.AddWithValue("@LastActivityDate", DateTime.Now);
                        updateCmd.Parameters.AddWithValue("@PKID", providerUserKey);

                        updateCmd.ExecuteNonQuery();
                    }
                }

            }
            catch (SqlException e)
            {
                if (WriteExceptionsToEventLog)
                {
                    WriteToEventLog(e, "GetUser(Object, Boolean)");

                    throw new ProviderException(exceptionMessage);
                }
                else
                {
                    throw e;
                }
            }
            finally
            {
                if (reader != null) { reader.Close(); }

                conn.Close();
            }

            return u;
        }

Same methods

SqlMembershipProvider::GetUser ( string username, bool userIsOnline ) : System.Web.Security.MembershipUser