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);
}
