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