static UserLight Load(IDataReader reader) { UserLight u = null; if (reader.Read()) { u = new UserLight(); u.m_UserID = (int)reader["UserId"]; u.m_Login = reader["Login"].ToString(); u.m_FirstName = reader["FirstName"].ToString(); u.m_LastName = reader["LastName"].ToString(); u.m_Email = reader["Email"].ToString(); u.m_IsExternal = (bool)reader["IsExternal"]; u.m_IsPending = (bool)reader["IsPending"]; u.m_IsAlertService = (u.m_Login.ToLower() == "alert" || u.m_Login.ToLower().StartsWith("alert@")); reader.Close(); using (IDataReader prefReader = DBUser.GetUserPreferences(u.m_UserID)) { if (prefReader.Read()) { u.m_TimeZoneId = (int)prefReader["TimeZoneId"]; u.m_Culture = (string)prefReader["Locale"]; u.m_LanguageId = (int)prefReader["LanguageId"]; } else { u.m_TimeZoneId = User.GetTimeZoneByBias(-TimeZone.CurrentTimeZone.GetUtcOffset(DateTime.Now).Hours); } } } return(u); }