public void SetUp()
 {
     _dbContext = Substitute.For<EfDbContext>();
     _toDoDbSet = Substitute.For<IDbSet<ToDoDto>>();
     _dbContext.ToDos = _toDoDbSet;
     _repository = new ToDoDtoRepository(_dbContext);
 }

 public ContestScore(Contest contest, IDbSet<Participant> participantList)
 {
     _contest = contest;
     ContestName = contest.Name;
     ParticipantList = participantList;
     AddParticipantScores();
 }

 private IEnumerable<IDataUpHandler> FindExecutedRevisions(IDbSet<Revision> systemRevisions, IEnumerable<IDataUpHandler> allRevisions)
 {
     return from dataRevision in allRevisions
            let revisionType = dataRevision.GetType().FullName
            where systemRevisions.Any(x => revisionType.Equals(x.Type, StringComparison.InvariantCultureIgnoreCase))
            select dataRevision;
 }

        public SqlServerStateProvider(string nameOrConnectionStr)
        {
            DbContext = new SequenceDbContext(nameOrConnectionStr);

            DbSet = DbContext.Set<SqlServerSequence>();

        }

 public SportService(IDbContext dbContext)
 {
     _dbContext = dbContext;
     _sports = dbContext.Set<Sport>();
     _sportCategories = dbContext.Set<SportCategory>();
     _sportDetails = dbContext.Set<SportDetail>();
 }

 public IeltsMaterialService(IUnitOfWork uow, Lazy<INotificationService> notificationService, Lazy<IFilesProxyAdapter> filesProxyAdapter)
 {
     _uow = uow;
     _IeltsMaterial = uow.Set<IeltsMaterial>();
     _notificationService = notificationService;
     _filesProxyAdapter = filesProxyAdapter;
 }

 public ResearchExperienceService(IUnitOfWork unitOfWork, IApplicationUserManager userManager, IMappingEngine mappingEngine)
 {
     _userManager = userManager;
     _unitOfWork = unitOfWork;
     _researchExperiences = _unitOfWork.Set<ResearchExperience>();
     _mappingEngine = mappingEngine;
 }

        public LogRepository(DbContext context)
        {
            if (context == null) throw new ArgumentNullException("context");

            _context = context;
            _logEntity = _context.Set<Log>();
        }

 public SessionRequestService(IUnitOfWork uow, Lazy<INotificationService> notificationService, ISessionService sessionService)
 {
     _sessionService = sessionService;
     _notificationService = notificationService;
     _uow = uow;
     _sessionRequest = uow.Set<SessionRequest>();
 }

 /// <summary>
 /// Constructor that takes a MySQLDatabase instance 
 /// </summary>
 /// <param name="database"></param>
 public UserRolesTableRepository(MySQLDatabase database)
 {
     _database = database;
     //_database.Set(typeof(UserRolesTable));
     this.dbSet = database.Set<UserRolesTable>();
     this.dbSetRoles = database.Set<IdentityRole>();
 }

        public ApplicationEventRepository(DbContext context)
        {
            if (context == null) throw new ArgumentNullException("context");

            _context = context;
            _logEventEntity = _context.Set<ApplicationEvent>();
        }

 public TitleService(IUnitOfWork unitOfWork, IApplicationUserManager userManager, IMappingEngine mappingEngine)
 {
     _userManager = userManager;
     _unitOfWork = unitOfWork;
     _titles = _unitOfWork.Set<Title>();
     _mappingEngine = mappingEngine;
 }

 public NotificationSettingService(IUnitOfWork uow, IUserService userService, IMessagingGatewayAdapter messagingGateway)
 {
     _uow = uow;
     _notification = uow.Set<NotificationSetting>();
     _userService = userService;
     _messagingGateway = messagingGateway;
 }

 public FakeNorthwindDbContext()
 {
     AlphabeticalListOfProducts = new FakeDbSet<AlphabeticalListOfProduct>();
     Categories = new FakeDbSet<Category>();
     CategorySalesFor1997 = new FakeDbSet<CategorySalesFor1997>();
     CurrentProductLists = new FakeDbSet<CurrentProductList>();
     Customers = new FakeDbSet<Customer>();
     CustomerAndSuppliersByCities = new FakeDbSet<CustomerAndSuppliersByCity>();
     CustomerDemographics = new FakeDbSet<CustomerDemographic>();
     Employees = new FakeDbSet<Employee>();
     Invoices = new FakeDbSet<Invoice>();
     Orders = new FakeDbSet<Order>();
     OrderDetails = new FakeDbSet<OrderDetail>();
     OrderDetailsExtendeds = new FakeDbSet<OrderDetailsExtended>();
     OrdersQries = new FakeDbSet<OrdersQry>();
     OrderSubtotals = new FakeDbSet<OrderSubtotal>();
     Products = new FakeDbSet<Product>();
     ProductsAboveAveragePrices = new FakeDbSet<ProductsAboveAveragePrice>();
     ProductSalesFor1997 = new FakeDbSet<ProductSalesFor1997>();
     ProductsByCategories = new FakeDbSet<ProductsByCategory>();
     Regions = new FakeDbSet<Region>();
     SalesByCategories = new FakeDbSet<SalesByCategory>();
     SalesTotalsByAmounts = new FakeDbSet<SalesTotalsByAmount>();
     Shippers = new FakeDbSet<Shipper>();
     SummaryOfSalesByQuarters = new FakeDbSet<SummaryOfSalesByQuarter>();
     SummaryOfSalesByYears = new FakeDbSet<SummaryOfSalesByYear>();
     Suppliers = new FakeDbSet<Supplier>();
     Sysdiagrams = new FakeDbSet<Sysdiagram>();
     Territories = new FakeDbSet<Territory>();
 }

 public InterviewService(IUnitOfWork unitOfWork, IApplicationUserManager userManager, IMappingEngine mappingEngine)
 {
     _userManager = userManager;
     _unitOfWork = unitOfWork;
     _interviews = _unitOfWork.Set<Interview>();
     _mappingEngine = mappingEngine;
 }

 public EntireEvaluationService(IUnitOfWork unitOfWork, IApplicationUserManager userManager, IMappingEngine mappingEngine)
 {
     _userManager = userManager;
     _unitOfWork = unitOfWork;
     _entireEvaluations = _unitOfWork.Set<EntireEvaluation>();
     _mappingEngine = mappingEngine;
 }

 public ReferentialTeacherService(IUnitOfWork unitOfWork, IApplicationUserManager userManager, IMappingEngine mappingEngine)
 {
     _userManager = userManager;
     _unitOfWork = unitOfWork;
     _referentialTeachers = _unitOfWork.Set<ReferentialTeacher>();
     _mappingEngine = mappingEngine;
 }

 public FakeCMSDbContext()
 {
     AuthTokens = new FakeDbSet<AuthToken>();
     Barcodes = new FakeDbSet<Barcode>();
     Catalogues = new FakeDbSet<Catalogue>();
     Clients = new FakeDbSet<Client>();
     ClientAllowScopes = new FakeDbSet<ClientAllowScope>();
     ItemAttributes = new FakeDbSet<ItemAttribute>();
     ItemMasters = new FakeDbSet<ItemMaster>();
     Members = new FakeDbSet<Member>();
     MemberInRoles = new FakeDbSet<MemberInRole>();
     MemberSpecificScopes = new FakeDbSet<MemberSpecificScope>();
     Merchandises = new FakeDbSet<Merchandise>();
     Products = new FakeDbSet<Product>();
     ProductPictures = new FakeDbSet<ProductPicture>();
     Promotions = new FakeDbSet<Promotion>();
     PurchasePrices = new FakeDbSet<PurchasePrice>();
     Restructures = new FakeDbSet<Restructure>();
     Roles = new FakeDbSet<Role>();
     RoleInScopes = new FakeDbSet<RoleInScope>();
     Scopes = new FakeDbSet<Scope>();
     SubCodes = new FakeDbSet<SubCode>();
     Suppliers = new FakeDbSet<Supplier>();
     SupplierAttributes = new FakeDbSet<SupplierAttribute>();
     Sysdiagrams = new FakeDbSet<Sysdiagram>();
 }

 public AuditLogService(IUnitOfWork unitOfWork, IApplicationUserManager userManager, IMappingEngine mappingEngine)
 {
     _userManager = userManager;
     _unitOfWork = unitOfWork;
     _logs = _unitOfWork.Set<AuditLog>();
     _mappingEngine = mappingEngine;
 }

        public AddSubReportForm(IUnitOfWork unitOfWork,
            IShowListForCities showListForCities,IShowListForDrivers showListForDrivers, IShowListForFreights showListForFreights)
            : base(unitOfWork)
        {
            _paths = unitOfWork.Set<Path>();
            _drivers = unitOfWork.Set<Driver>();
            _freights = unitOfWork.Set<Freight>();

            _showListForCities = showListForCities;
            _showListForDrivers = showListForDrivers;
            _showListForFreights = showListForFreights;
            InitializeComponent();
            _defaultControl = pathCombo;

            pathCombo.Items.Clear();
            _pathList = _paths.Where(x => x.ActiveState).ToList();
            foreach (var tmp in _pathList.Select(path => $"{path.SourceCity} - {path.DestinationCity} :[{path.Id}]"))
                pathCombo.Items.Add(tmp);

            driverCombo.Items.Clear();
            _driverList = _drivers.Where(x => x.ActiveState).ToList();
            foreach (var tmp in
                _driverList.Select(driver => $"{driver.Name} {driver.Family} - {driver.Plaque} :[{driver.Id}]"))
                driverCombo.Items.Add(tmp);

            freightCombo.Items.Clear();
            _freightList = _freights.Where(x => x.ActiveState).ToList();
            foreach (var tmp in _freightList)
                freightCombo.Items.Add($"{tmp.Name} :[{tmp.Id}]");
        }