public override HiMembershipUser GetMembershipUser(int userId, string username, bool isOnline) { MembershipUser mu = string.IsNullOrEmpty(username) ? HiMembership.GetUser(userId, isOnline) : HiMembership.GetUser(username, isOnline); if (mu == null) { return(null); } HiMembershipUser user2 = null; DbCommand sqlStringCommand = null; if (!string.IsNullOrEmpty(username)) { sqlStringCommand = this.database.GetSqlStringCommand( "SELECT MobileAlias, IsAnonymous FROM aspnet_Users WHERE LoweredUserName = LOWER(@Username)"); this.database.AddInParameter(sqlStringCommand, "Username", DbType.String, username); } else { sqlStringCommand = this.database.GetSqlStringCommand( "SELECT MobilePIN, IsAnonymous, Gender, BirthDate, UserRole FROM aspnet_Users WHERE UserId = @UserId"); this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, userId); } using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand)) { if (reader.Read()) { user2 = new HiMembershipUser((bool)reader["IsAnonymous"], UserRole.SiteManager, mu); if (reader["MobilePIN"] != DBNull.Value) { user2.MobilePIN = (string)reader["MobilePIN"]; } if (reader["Gender"] != DBNull.Value) { user2.Gender = (Gender)Convert.ToInt32(reader["Gender"]); } if (reader["BirthDate"] != DBNull.Value) { user2.BirthDate = new DateTime?((DateTime)reader["BirthDate"]); } } reader.Close(); } return(user2); }
public override HiMembershipUser GetMembershipUser(int userId, string username, bool isOnline) { MembershipUser membershipUser = string.IsNullOrEmpty(username) ? HiMembership.GetUser(userId, isOnline) : HiMembership.GetUser(username, isOnline); HiMembershipUser result; if (membershipUser == null) { result = null; } else { HiMembershipUser hiMembershipUser = null; System.Data.Common.DbCommand sqlStringCommand; if (!string.IsNullOrEmpty(username)) { sqlStringCommand = this.database.GetSqlStringCommand("SELECT MobilePIN, IsAnonymous, Gender, BirthDate, UserRole FROM aspnet_Users WHERE LoweredUserName = LOWER(@Username)"); this.database.AddInParameter(sqlStringCommand, "Username", System.Data.DbType.String, username); } else { sqlStringCommand = this.database.GetSqlStringCommand("SELECT MobilePIN, IsAnonymous, Gender, BirthDate, UserRole FROM aspnet_Users WHERE UserId = @UserId"); this.database.AddInParameter(sqlStringCommand, "UserId", System.Data.DbType.Int32, userId); } using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { if (dataReader.Read()) { hiMembershipUser = new HiMembershipUser((bool)dataReader["IsAnonymous"], (UserRole)Convert.ToInt32(dataReader["UserRole"]), membershipUser); if (dataReader["MobilePIN"] != DBNull.Value) { hiMembershipUser.MobilePIN = (string)dataReader["MobilePIN"]; } if (dataReader["Gender"] != DBNull.Value) { hiMembershipUser.Gender = (Gender)Convert.ToInt32(dataReader["Gender"]); } if (dataReader["BirthDate"] != DBNull.Value) { hiMembershipUser.BirthDate = new DateTime?((DateTime)dataReader["BirthDate"]); } } dataReader.Close(); } result = hiMembershipUser; } return(result); }