private static void timeOffsetCheck(IFlyMiningEntityDI fDb) { try { if (fDb.UserProfile2.Any(t => (t.TimeZone == null || (t.TimeZone != null && t.TimeZone == "")) && t.userIP != "::1")) { List <UserProfile2> userlist = fDb.UserProfile2.Where(t => (t.TimeZone == null || (t.TimeZone != null && t.TimeZone == "")) && t.userIP != "::1").ToList(); foreach (UserProfile2 user in userlist) { GeoData myLocation = GeoIP.GetCountryInfo(user.userIP); if (myLocation == null || myLocation.timeZone == "") { myLocation = GeoIP.GetCountryInfoCheck(user.userIP); } if (myLocation != null) { user.TimeOffset = myLocation.timeOffset; user.TimeZone = myLocation.timeZone; if (user.TimeZone.Length >= 50) { user.TimeZone = myLocation.timeZone.Substring(0, 50); } } } fDb.SaveChanges(); } } catch (Exception ex) { Logger.AddLogRecord("timeOffsetCheck " + Convert.ToString(ex)); } }