public static List <MarketSyncInfo> GetMarketsSyncTimeInfo()
{
List <MarketSyncInfo> result = new List <MarketSyncInfo>();
List <string> markets = MarketService.GetMarkets().Select(m => m.name).ToList();
using (ctaDBEntities entities = new ctaDBEntities())
{
Config cfg;
string lastSync = "";
string nextSync = "";
foreach (string marketName in markets)
{
cfg = entities.Configs.Where(c => c.ConfigName == marketName + "_LastSync").FirstOrDefault();
if (cfg != null)
{
lastSync = cfg.ConfigValue;
}
cfg = entities.Configs.Where(c => c.ConfigName == marketName + "_NextSync").FirstOrDefault();
if (cfg != null)
{
nextSync = cfg.ConfigValue;
}
result.Add(new MarketSyncInfo()
{
Market = marketName, LastSync = lastSync, NextSync = nextSync
});
}
//adding the report sync
var reportConfig_LastSync = entities.Configs.Where(c => c.ConfigName == "ReportDATA_LastSync").FirstOrDefault();
var reportConfig_NextSync = entities.Configs.Where(c => c.ConfigName == "ReportDATA_NextSync").FirstOrDefault();
result.Add(new MarketSyncInfo()
{
Market = "ReportDATA",
LastSync = reportConfig_LastSync.ConfigValue,
NextSync = reportConfig_NextSync.ConfigValue
});
}
return(result);
}
public static DateTime GetMarketCurrentLocalTime(string marketName)
{
int utcoffset = MarketService.GetMarkets().Where(m => m.name == marketName).First().utc_offset;
return(DateTime.UtcNow.AddHours(utcoffset));
}
