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