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