BlogEngine.Core.Providers.DbMembershipProvider.GetUser C# (CSharp) Method

DbMembershipProvider Class Documentation Show file Open project: rasmuskl/ReSharperCourse

GetUser() public method

Gets information from the data source for a user. Provides an option to update the last-activity date/time stamp for the user.

public GetUser ( string username, bool userIsOnline ) : System.Web.Security.MembershipUser
username	string	The name of the user to get information for.
userIsOnline	bool	true to update the last-activity date/time stamp for the user; false to return user information without updating the last-activity date/time stamp for the user.
return	System.Web.Security.MembershipUser

        public override MembershipUser GetUser(string username, bool userIsOnline)
        {
            MembershipUser user = null;

            using (var conn = this.CreateConnection())
            {
                if (conn.HasConnection)
                {
                    using (var cmd = conn.CreateTextCommand(string.Format("SELECT username, EmailAddress, lastLoginTime FROM {0}Users WHERE BlogID = {1}blogid AND UserName = {1}name", this.tablePrefix, this.parmPrefix)))
                    {
                        cmd.Parameters.Add(conn.CreateParameter(FormatParamName("blogid"), Blog.CurrentInstance.Id.ToString()));
                        cmd.Parameters.Add(conn.CreateParameter(FormatParamName("name"), username));

                        using (var rdr = cmd.ExecuteReader())
                        {
                            if (rdr.Read())
                            {
                                user = this.GetMembershipUser(username, rdr.GetString(1), rdr.GetDateTime(2));
                            }
                        }
                    }
                }
            }

            return user;
        }