public EFRepository(IDbContextFactoryService dbFactory, ILogger <EFRepository> logger, DateTimeService dateTimeService)
 {
     this.dateTimeService = dateTimeService;
     contexts             = dbFactory.CreateDbs <AppDbContext>("cds");
     foreach (AppDbContext cont in contexts)
     {
         string serverName = cont.Database.GetDbConnection().ConnectionString.Split(";")[0].Split("=")[1];
         cont.OffsetUTC = dateTimeService.GetServerOffsetUTC(serverName);
     }
     this.logger     = logger;
     TimeZoneOffsets = dateTimeService.TimeZonesOffsetUTC;
 }