public static UserProfile PopulateUser(SqlDataReader reader, out string UserPassword)
{
UserPassword = null;
try
{
UserPassword = Convert.ToString(reader["Password"]).Trim();
UserProfile up = new UserProfile
{
UserID = Convert.ToString(reader["UserID"]).Trim(),
Name = Convert.ToString(reader["Name"]).Trim(),
Email = Convert.ToString(reader["Email"]).Trim(),
Address = Convert.ToString(reader["Address"]).Trim(),
Birthdate = Convert.ToString(reader["birthdate"]).Trim(),
Mobile = Convert.ToString(reader["mobile"]).Trim(),
FaxNumber = Convert.ToString(reader["fax"]).Trim(),
PhoneNumber = Convert.ToString(reader["tel"]).Trim(),
PersonalNo = Convert.ToString(reader["PerNo"]).Trim(),
IdNumber = Convert.ToString(reader["id_num"]).Trim(),
NationalCode = Convert.ToString(reader["NationalCode"]).Trim(),
FatherName = Convert.ToString(reader["father"]).Trim(),
Gender = Convert.ToInt32(reader["sex"]) == 1 ? Genders.Male : Genders.Female,
IsBMIEmployee = !String.IsNullOrWhiteSpace(reader["PerNo"].ToString()),
};
if (!(reader["last_s_login_time"] is DBNull))
up.LastLoginTime = Convert.ToDateTime(reader["last_s_login_time"]);
if (!(reader["cur_login_time"] is DBNull))
up.CurrentLoginTime = Convert.ToDateTime(reader["cur_login_time"]);
return up;
}
catch
{
return null;
}
}
private static void AddRankInBlockList(string userId)
{
List<UserProfile> users;
// Read from the cache if available
if (HttpContext.Current.Cache["SSOUsersBlockList"] == null)
{
users = new List<UserProfile>();
HttpContext.Current.Cache.Insert("SSOUsersBlockList", users, null, DateTime.Now.AddMinutes(120), TimeSpan.Zero);
}
users = (List<UserProfile>)HttpContext.Current.Cache["SSOUsersBlockList"];
UserProfile blockeduser = users.FirstOrDefault(o => o.UserID.Trim().ToLower() == userId.Trim().ToLower());
if (blockeduser != null)
{
blockeduser.TotalTryToLogin += 1;
blockeduser.LastActivity = DateTime.Now;
}
else
{
UserProfile newU = new UserProfile { UserID = userId, TotalTryToLogin = 1, LastActivity = DateTime.Now };
users.Add(newU);
}
HttpContext.Current.Cache["SSOUsersBlockList"] = users;
}
