Example #1
0
 public SqlQueueFactory()
 {
     configuration = new SubscriptionManagerConfiguration();
     scriptProvider = new ScriptProvider();
     databaseConnectionFactory = DatabaseConnectionFactory.Default();
     databaseGateway = DatabaseGateway.Default();
 }
        public OrderItemCreateValidator(IDatabaseConnectionFactory databaseConnectionFactory)
        {
            this.productRepository         = RepositoryFactory.CreateProductRepository();
            this.actionRepository          = RepositoryFactory.CreateActionRepository();
            this.databaseConnectionFactory = databaseConnectionFactory;

            RuleFor(oi => oi.ProductId)
            .Cascade(CascadeMode.StopOnFirstFailure)
            .NotEmpty()
            .Must(ValidateProductId)
            .WithMessage("The product specified doesn't exist in the database");

            RuleFor(oi => oi.ActionId)
            .Cascade(CascadeMode.StopOnFirstFailure)
            .NotEmpty()
            .Must(ValidateActionId)
            .WithMessage("The action specified doesn't exist in the database");

            RuleFor(oi => oi.Amount)
            .Cascade(CascadeMode.StopOnFirstFailure)
            .NotEmpty()
            .Must(ValidateAmount)
            .WithMessage("Amount cannot be negative");

            RuleFor(oi => oi.DiscountBasic)
            .Cascade(CascadeMode.StopOnFirstFailure)
            .NotEmpty()
            .Must(ValidateDiscount)
            .WithMessage("Discount is invalid");
        }
Example #3
0
        public void TestInitialize()
        {
            this.DatabaseConnectionFactory = Substitute.For <IDatabaseConnectionFactory>();

            this.DatabaseConnectionFactory.Create()
            .Returns(new SqlConnection(TestDbConnection.LocalDb.Northwind));
        }
Example #4
0
        //Would be revisiting to modify the actual way of call method.
        public void ContactListRepositoryTest_Success()
        {
            // Arrange
            LidTypeEnum LIDType = LidTypeEnum.CustomerNbr;
            string      LID     = "";

            PaginationDemographics page = new PaginationDemographics();

            int    NameAddressID = 3301636;
            string ssn           = "3425";

            MockContactListRepository mockContactListRepository = new MockContactListRepository();
            ApiResult <GenericPaginationResponse <Demographics> > expectedResult = mockContactListRepository.GetMockData(ssn);

            IOptions <DataContext>     optionsAccessor   = Substitute.For <IOptions <DataContext> >();
            IDatabaseConnectionFactory connectionFactory = Substitute.For <IDatabaseConnectionFactory>();
            IContactListRepository     mockRepo          = Substitute.For <IContactListRepository>();
            ILoggingFacade             loggingFacade     = Substitute.For <ILoggingFacade>();

            loggingFacade.WhenForAnyArgs(x => x.LogAsync(Arg.Any <LogLevels>(), Arg.Any <string>(), Arg.Any <CancellationToken>())).DoNotCallBase();

            mockRepo.GetContactListAsync(LIDType, LID, page).ReturnsForAnyArgs(expectedResult.Result);

            // Act
            var    contactList  = mockRepo.GetContactListAsync(LIDType, LID, page).Result;
            var    actualRecord = (IList <Wp.CIS.LynkSystems.Model.Demographics>)contactList.ReturnedRecords;
            string contactInfo  = actualRecord.Where(x => x.NameAddressID == NameAddressID).FirstOrDefault().Name;


            //// Assert

            Assert.Equal(((IList <Demographics>)actualRecord).Count, 3);

            Assert.Equal(contactInfo, "Golden Corral Corporation");
        }
Example #5
0
 public ResetPassword(IDatabaseConnectionFactory databaseConnectionFactory, UserManager <User> userManager, IUserRepository userRepository)
     : base(databaseConnectionFactory)
 {
     _databaseConnectionFactory = databaseConnectionFactory ?? throw new ArgumentNullException(nameof(databaseConnectionFactory));
     _userManager    = userManager;
     _userRepository = userRepository;
 }
 public OfferSubTypeService(IDatabaseConnectionFactory databaseConnectionFactory, IConfiguration configuration
                            )
     : base(databaseConnectionFactory)
 {
     _databaseConnectionFactory = databaseConnectionFactory ?? throw new ArgumentNullException(nameof(databaseConnectionFactory));
     _configuration             = configuration;
 }
Example #7
0
        public SqlQueue(Uri uri,
                        IScriptProvider scriptProvider,
                        IDatabaseConnectionFactory databaseConnectionFactory,
                        IDatabaseGateway databaseGateway)
        {
            Guard.AgainstNull(uri, "uri");
            Guard.AgainstNull(scriptProvider, "scriptProvider");
            Guard.AgainstNull(databaseConnectionFactory, "databaseConnectionFactory");
            Guard.AgainstNull(databaseGateway, "databaseGateway");

            _scriptProvider            = scriptProvider;
            _databaseConnectionFactory = databaseConnectionFactory;
            _databaseGateway           = databaseGateway;

            _log = Log.For(this);

            Uri = uri;

            parser = new SqlUriParser(uri);

            _dataSource = new DataSource(parser.ConnectionName, new SqlDbDataParameterFactory());
            _tableName  = parser.TableName;

            BuildQueries();
        }
Example #8
0
        public SqlQueue(Uri uri,
						IScriptProvider scriptProvider,
						IDatabaseConnectionFactory databaseConnectionFactory,
						IDatabaseGateway databaseGateway)
        {
            Guard.AgainstNull(uri, "uri");
            Guard.AgainstNull(scriptProvider, "scriptProvider");
            Guard.AgainstNull(databaseConnectionFactory, "databaseConnectionFactory");
            Guard.AgainstNull(databaseGateway, "databaseGateway");

            _scriptProvider = scriptProvider;
            _databaseConnectionFactory = databaseConnectionFactory;
            _databaseGateway = databaseGateway;

            _log = Log.For(this);

            Uri = uri;

            parser = new SqlUriParser(uri);

            _dataSource = new DataSource(parser.ConnectionName, new SqlDbDataParameterFactory());
            _tableName = parser.TableName;

            BuildQueries();
        }
Example #9
0
        public override IPayDayService CreatePayDayService()
        {
            IDatabaseConnectionFactory databaseConnectionFactory = DatabaseConnectionFactoryRepository.FindOrCreateDatabaseConnectionFactory(string.Empty);
            IDatabaseConnection        databaseConnection        = databaseConnectionFactory.FindOrCreateDatabaseConnection(string.Empty);

            return(new PayDayService(databaseConnection));
        }
        public DatabaseReleaseTool(
            string databaseScriptPath,
            IFileStructurePolicy createDatabasePolicy,
            IFileStructurePolicy fileStructurePolicy,
            IOutputLogger outputLogger,
            IConnectionStringFactory connectionStringFactory,
            IDatabaseConnectionFactory databaseConnectionFactory)
        {
            if (outputLogger == null)
            {
                throw new ArgumentNullException("outputLogger");
            }

            if (string.IsNullOrEmpty(databaseScriptPath))
            {
                throw new ArgumentException(@"Cannot be null or empty.", "databaseScriptPath");
            }

            if (!Directory.Exists(databaseScriptPath))
            {
                throw new DirectoryNotFoundException(string.Format("Path: {0} does not exist.", databaseScriptPath));
            }

            _createDatabasePolicy      = createDatabasePolicy;
            _fileStructurePolicy       = fileStructurePolicy;
            _outputLogger              = outputLogger;
            _connectionStringFactory   = connectionStringFactory;
            _databaseConnectionFactory = databaseConnectionFactory;
            _databaseScriptsDirInfo    = new DirectoryInfo(databaseScriptPath);
        }
        public SiteLevelOverrideSetting(IDatabaseConnectionFactory databaseConnectionFactory, IConfiguration configuration)
            : base(databaseConnectionFactory)
        {
            _databaseConnectionFactory = databaseConnectionFactory ?? throw new ArgumentNullException(nameof(databaseConnectionFactory));

            _configuration = configuration;
        }
 public FoodChainRepository(IDatabaseConnectionFactory databaseConnectionFactory, IConfiguration configuration
                            )
     : base(databaseConnectionFactory)
 {
     _databaseConnectionFactory = databaseConnectionFactory ?? throw new ArgumentNullException(nameof(databaseConnectionFactory));
     _configuration             = configuration;
 }
 public UserTransactionInfoes(IDatabaseConnectionFactory databaseConnectionFactory, IConfiguration configuration, IPhotos photos)
     : base(databaseConnectionFactory)
 {
     _databaseConnectionFactory = databaseConnectionFactory ?? throw new ArgumentNullException(nameof(databaseConnectionFactory));
     _configuration             = configuration;
     _photos = photos;
 }
        //Would be revisiting to modify the actual way of call method.
        public void TestTransactionHistoryRepositoryTest_Success()
        {
            // Arrange
            string terminalId      = "LK429486";
            string transactionType = "Credit";

            MockTransactionHistoryRepository mockTransactionHistoryRepository          = new MockTransactionHistoryRepository();
            ApiResult <GenericPaginationResponse <TransactionHistory> > expectedResult = mockTransactionHistoryRepository.GetMockData(transactionType);
            PaginationTransactionHistory page = mockTransactionHistoryRepository.GetPagination();
            ILoggingFacade loggingFacade      = Substitute.For <ILoggingFacade>();

            loggingFacade.WhenForAnyArgs(x => x.LogAsync(Arg.Any <LogLevels>(), Arg.Any <string>(), Arg.Any <CancellationToken>())).DoNotCallBase();

            IOptions <DataContext>        optionsAccessor   = Substitute.For <IOptions <DataContext> >();
            IDatabaseConnectionFactory    connectionFactory = Substitute.For <IDatabaseConnectionFactory>();
            ITransactionHistoryRepository mockRepo          = Substitute.For <ITransactionHistoryRepository>();


            mockRepo.GetTransactionHistoryAsync(terminalId, page).ReturnsForAnyArgs(expectedResult.Result);


            // Act
            var    terminalList = mockRepo.GetTransactionHistoryAsync(terminalId, page).Result;
            var    actualRecord = (IList <TransactionHistory>)terminalList.ReturnedRecords;
            string merchInfo    = actualRecord.Where(x => x.REQ_TRAN_TYPE == transactionType).FirstOrDefault().REQ_AMT;


            //// Assert

            Assert.Equal(((IList <TransactionHistory>)actualRecord).Count, 1);

            Assert.Equal(merchInfo, "589587");
        }
Example #15
0
        //Would be revisiting to modify the actual way of call method.
        public void CaseHistoryControllerTest_Success()
        {
            // Arrange
            LidTypeEnum           LIDType = LidTypeEnum.CustomerNbr;
            string                LID     = "";
            PaginationCaseHistory page    = new PaginationCaseHistory();

            string ExtraId = null;
            int    lid     = 648988;
            int    CaseID  = 8715123;

            MockCaseHistoryRepository mockCaseHistoryRepository = new MockCaseHistoryRepository();
            ApiResult <GenericPaginationResponse <Wp.CIS.LynkSystems.Model.CaseHistory> > expectedResult = mockCaseHistoryRepository.GetMockData(lid);

            IOptions <DataContext>     optionsAccessor   = Substitute.For <IOptions <DataContext> >();
            IDatabaseConnectionFactory connectionFactory = Substitute.For <IDatabaseConnectionFactory>();

            ICaseHistoryRepository mockRepo = Substitute.For <ICaseHistoryRepository>();

            mockRepo.GetCaseHistoryInfo(LIDType, LID, ExtraId, page).ReturnsForAnyArgs(expectedResult.Result);

            // Act
            var caseHistory = mockRepo.GetCaseHistoryInfo(LIDType, "648988", ExtraId, page).Result;

            var actualRecord = (IList <Wp.CIS.LynkSystems.Model.CaseHistory>)caseHistory.ReturnedRecords;

            string caseInfo = actualRecord.Where(x => x.caseId == CaseID).FirstOrDefault().caseLevel;

            //// Assert

            Assert.Equal(((IList <Wp.CIS.LynkSystems.Model.CaseHistory>)actualRecord).Count, 6);

            Assert.Equal(caseInfo, "Customer");
        }
Example #16
0
 public InputService(
     IPackingListRepository repoPackingList,
     IQRCodeMainRepository repoQRCodeMain,
     IQRCodeDetailRepository repoQRCodeDetail,
     ITransactionMainRepo repoTransactionMain,
     ITransactionDetailRepo repoTransactionDetail,
     IMaterialMissingRepository repoMaterialMissing,
     IMaterialPurchaseRepository repoMatPurchase,
     IMaterialMissingRepository repoMatMissing,
     IMaterialViewRepository repoMaterialView,
     IRackLocationRepo repoRacklocationRepo,
     IPackingListDetailRepository repoPacKingListDetail,
     IDatabaseConnectionFactory database,
     IMapper mapper, 
     MapperConfiguration configMapper)
 {
     _configMapper = configMapper;
     _mapper = mapper;
     _repoQRCodeMain = repoQRCodeMain;
     _repoQRCodeDetail = repoQRCodeDetail;
     _repoPackingList = repoPackingList;
     _repoTransactionMain = repoTransactionMain;
     _repoTransactionDetail = repoTransactionDetail;
     _repoMaterialMissing = repoMaterialMissing;
     _repoMatMissing = repoMatMissing;
     _repoMatPurchase = repoMatPurchase;
     _repoMaterialView = repoMaterialView;
     _repoRacklocationRepo = repoRacklocationRepo;
     _repoPacKingListDetail = repoPacKingListDetail;
     _database = database;
 }
Example #17
0
        //Would be revisiting to modify the actual way of call method.
        public void MerchantListRepositoryTest_Success()
        {
            // Arrange
            int    CustomerID = 191809;
            string mid        = "191807";


            MockMerchantListRepository mockMerchantListRepository            = new MockMerchantListRepository();
            ApiResult <GenericPaginationResponse <Merchant> > expectedResult = mockMerchantListRepository.GetMockData(CustomerID);
            PaginationMerchant page = mockMerchantListRepository.GetPagination();

            IOptions <DataContext>     optionsAccessor   = Substitute.For <IOptions <DataContext> >();
            IDatabaseConnectionFactory connectionFactory = Substitute.For <IDatabaseConnectionFactory>();
            IMerchantListRepository    mockRepo          = Substitute.For <IMerchantListRepository>();
            ILoggingFacade             loggingFacade     = Substitute.For <ILoggingFacade>();

            loggingFacade.WhenForAnyArgs(x => x.LogAsync(Arg.Any <LogLevels>(), Arg.Any <string>(), Arg.Any <CancellationToken>())).DoNotCallBase();

            mockRepo.GetMerchantListAsync(CustomerID, page).ReturnsForAnyArgs(expectedResult.Result);

            // Act
            var    merchList    = mockRepo.GetMerchantListAsync(CustomerID, page).Result;
            var    actualRecord = (IList <Wp.CIS.LynkSystems.Model.Merchant>)merchList.ReturnedRecords;
            string merchInfo    = actualRecord.Where(x => x.MID == mid).FirstOrDefault().Name;


            //// Assert

            Assert.Equal(((IList <Merchant>)actualRecord).Count, 2);

            Assert.Equal(merchInfo, "ABC Corp");
        }
Example #18
0
        //Would be revisiting to modify the actual way of call method.
        public void TestTerminalListRepositoryTest_Success_Old()
        {
            // Arrange
            string terminalNbr = "589587";
            string tid         = "LK429486";


            MockTerminalListRepository          mockTerminalListRepository = new MockTerminalListRepository();
            ApiResult <ICollection <Terminal> > expectedResult             = mockTerminalListRepository.GetMockData(terminalNbr);
            ILoggingFacade loggingFacade = Substitute.For <ILoggingFacade>();

            loggingFacade.WhenForAnyArgs(x => x.LogAsync(Arg.Any <LogLevels>(), Arg.Any <string>(), Arg.Any <CancellationToken>())).DoNotCallBase();

            IOptions <DataContext>     optionsAccessor   = Substitute.For <IOptions <DataContext> >();
            IDatabaseConnectionFactory connectionFactory = Substitute.For <IDatabaseConnectionFactory>();
            ITerminalListRepository    mockRepo          = Substitute.For <ITerminalListRepository>();


            mockRepo.GetTerminalListAsync(Convert.ToInt32(terminalNbr)).ReturnsForAnyArgs(expectedResult.Result);


            // Act
            var    merchList    = mockRepo.GetTerminalListAsync(Convert.ToInt32(terminalNbr)).Result;
            var    actualRecord = (IList <Wp.CIS.LynkSystems.Model.Terminal>)merchList;
            string merchInfo    = actualRecord.Where(x => x.TerminalID == tid).FirstOrDefault().Software;


            //// Assert

            Assert.Equal(((IList <Terminal>)actualRecord).Count, 1);

            Assert.Equal(merchInfo, "LSPR3271");
        }
Example #19
0
        //Would be revisiting to modify the actual way of call method.
        public void TestTerminalListRepositoryTest_Success()
        {
            // Arrange
            int    terminalNbr = 589587;
            string tid         = "LK429486";

            MockTerminalListRepository mockTerminalListRepository            = new MockTerminalListRepository();
            ApiResult <GenericPaginationResponse <Terminal> > expectedResult = mockTerminalListRepository.GetMockData(terminalNbr);
            PaginationTerminal page = mockTerminalListRepository.GetPagination();

            IOptions <DataContext>     optionsAccessor   = Substitute.For <IOptions <DataContext> >();
            IDatabaseConnectionFactory connectionFactory = Substitute.For <IDatabaseConnectionFactory>();
            ITerminalListRepository    mockRepo          = Substitute.For <ITerminalListRepository>();


            mockRepo.GetTerminalListAsync(terminalNbr, page).ReturnsForAnyArgs(expectedResult.Result);


            // Act
            var    terminalList = mockRepo.GetTerminalListAsync(terminalNbr, page).Result;
            var    actualRecord = (IList <Wp.CIS.LynkSystems.Model.Terminal>)terminalList.ReturnedRecords;
            string merchInfo    = actualRecord.Where(x => x.TerminalID == tid).FirstOrDefault().Software;


            //// Assert

            Assert.Equal(((IList <Terminal>)actualRecord).Count, 1);

            Assert.Equal(merchInfo, "LSPR3271");
        }
 public GatewayCardWebHookTokenService(IDatabaseConnectionFactory databaseConnectionFactory, IConfiguration configuration, ILoggerManager logger)
     : base(databaseConnectionFactory)
 {
     _databaseConnectionFactory = databaseConnectionFactory ?? throw new ArgumentNullException(nameof(databaseConnectionFactory));
     _configuration             = configuration;
     _logger = logger;
 }
Example #21
0
 public BenefactorNotifications(IDatabaseConnectionFactory databaseConnectionFactory, IConfiguration configuration, IPhotos photos)
     : base(databaseConnectionFactory)
 {
     _databaseConnectionFactory = databaseConnectionFactory ?? throw new ArgumentNullException(nameof(databaseConnectionFactory));
     _configuration             = configuration;
     _photos = photos;
 }
Example #22
0
 public InvitationService(IDatabaseConnectionFactory databaseConnectionFactory
                          , IBenefactorsProgram benefactorsProgram)
     : base(databaseConnectionFactory)
 {
     _databaseConnectionFactory = databaseConnectionFactory ?? throw new ArgumentNullException(nameof(databaseConnectionFactory));
     _benefactorprogram         = benefactorsProgram;
 }
        /// <summary>
        /// Create a Generic FoundryRepository
        /// </summary>
        /// <param name="conn">Connection</param>
        /// <param name="parameterIdentified">Idetenfier parameter (@) to SqlServer (:) to Oracle</param>
        public GenericRepository(IDatabaseConnectionFactory dbConnections, char parameterIdentified = '@')
        {
            _databaseConnectionFactory = dbConnections;
            ParameterIdentified        = parameterIdentified;
            partsQryGenerator          = new PartsQryGenerator <T>(ParameterIdentified);

            identityInspector = new IdentityInspector <T>(_databaseConnectionFactory.CreateConnection());
        }
Example #24
0
 public EmailService(IGeneralSettingService setting, IDatabaseConnectionFactory databaseConnectionFactory,
                     IOptions <SendGridSettings> sendGridSettings)
     : base(databaseConnectionFactory)
 {
     _databaseConnectionFactory = databaseConnectionFactory ?? throw new ArgumentNullException(nameof(databaseConnectionFactory));
     _setting = setting;
     this._sendGridSettings = sendGridSettings;
 }
Example #25
0
        public void TestInitialize()
        {
            DatabaseConnectionFactory = Substitute.For <IDatabaseConnectionFactory>();

            DatabaseConnectionFactory
            .Create()
            .Returns(new SqlConnection(TestHook.SampleDbConnection));
        }
        public BotIntegrationTest(BotRepoIntegrationTestSetup setup)
        {
            _connectionString = new ConnectionStringsForTest().GetConnectionString(setup.DatabaseName);
            var database = new DatabaseConnection(_connectionString);

            _fakedFactory = A.Fake <IDatabaseConnectionFactory>();
            A.CallTo(() => _fakedFactory.GetDatabaseConnection(Factories.Database.Main)).Returns(database);
        }
        public SubscriptionManagementPresenter(IDatabaseGateway databaseGateway, IDatabaseConnectionFactory databaseConnectionFactory, ISubscriptionQuery subscriptionQuery)
        {
            view = new SubscriptionManagementView(this);

            this.databaseGateway = databaseGateway;
            this.databaseConnectionFactory = databaseConnectionFactory;
            this.subscriptionQuery = subscriptionQuery;
        }
        public ScheduleManagementPresenter(IScheduleQuery scheduleQuery, IDatabaseConnectionFactory databaseConnectionFactory, IDatabaseGateway databaseGateway)
        {
            view = new ScheduleManagementView(this);

            this.scheduleQuery = scheduleQuery;
            this.databaseConnectionFactory = databaseConnectionFactory;
            this.databaseGateway = databaseGateway;
        }
Example #29
0
 public PostGisDatabaseImporter(IDatabaseConnectionFactory factory, DirectoryInfo directory, IDictionary <string, IGeometryImporter> shapefileImportStrategies)
 {
     _directory = directory;
     _shapefileImportStrategies = shapefileImportStrategies;
     _connection    = factory.GetConnection(_directory);
     _files         = new Lazy <IEnumerable <FileInfo> >(() => GetShapeFiles(directory));
     _sridDirectory = _directory.EnumerateDirectories().SingleOrDefault(d => d.Name == "SridDefinition");
 }
Example #30
0
        public BaseAppService()
        {
            this.registrationMappers     = new RegistrationMappers();
            this.dtoToEntityMapper       = this.registrationMappers.Container.Resolve <IMapper>();
            this.registrationServices    = new RegistrationServices();
            this.registrationAppServices = new RegistrationAppServices();

            this.databaseConnectionFactory = this.registrationAppServices.Instance.Container.Resolve <IDatabaseConnectionFactory>();
        }
        public void TestInitialize()
        {
            this.DatabaseConnectionFactory = Substitute.For <IDatabaseConnectionFactory>();

            this.DatabaseConnectionFactory.Create().Returns
            (
                new SqlConnection(TestHook.ConnectionString)
            );
        }
 public PlanProgramAccountLinkingService(IDatabaseConnectionFactory databaseConnectionFactory, IConfiguration configuration, ILoggerManager logger,
                                         IMapper mapper)
     : base(databaseConnectionFactory)
 {
     _databaseConnectionFactory = databaseConnectionFactory ?? throw new ArgumentNullException(nameof(databaseConnectionFactory));
     _configuration             = configuration;
     _logger = logger;
     _mapper = mapper;
 }
Example #33
0
        public SqlQueue(Uri uri,
                        ISubscriptionManagerConfiguration subscriptionManagerConfiguration,
                        IScriptProvider scriptProvider,
                        IDatabaseConnectionFactory databaseConnectionFactory,
                        IDatabaseGateway databaseGateway)
        {
            Guard.AgainstNull(uri, "uri");
            Guard.AgainstNull(subscriptionManagerConfiguration, "subscriptionManagerConfiguration");
            Guard.AgainstNull(scriptProvider, "scriptProvider");
            Guard.AgainstNull(databaseConnectionFactory, "databaseConnectionFactory");
            Guard.AgainstNull(databaseGateway, "databaseGateway");

            this.subscriptionManagerConfiguration = subscriptionManagerConfiguration;
            this.scriptProvider = scriptProvider;
            this.databaseConnectionFactory = databaseConnectionFactory;
            this.databaseGateway = databaseGateway;

            if (!uri.Scheme.Equals(SCHEME, StringComparison.InvariantCultureIgnoreCase))
            {
                throw new InvalidSchemeException(SCHEME, uri.ToString());
            }

            var builder = new UriBuilder(uri);

            if (uri.LocalPath == "/" || uri.Segments.Length != 2)
            {
                throw new UriFormatException(string.Format(ESBResources.UriFormatException,
                                                           "sql://{{connection name}}/{{table name}}",
                                                           Uri));
            }

            log = Log.For(this);

            Uri = builder.Uri;

            dataSource = new DataSource(Uri.Host,
                                        new SqlServerDbDataParameterFactory(),
                                        new SqlServerContainsQueryFactory(),
                                        new SqlServerInsertQueryFactory(),
                                        new SqlServerUpdateQueryFactory(),
                                        new SqlServerDeleteQueryFactory(),
                                        new SqlServerSelectQueryFactory());

            using (databaseConnectionFactory.Create(dataSource))
            {
                var host = databaseGateway.GetScalarUsing<string>(dataSource,
                                                                  RawQuery.CreateFrom("select host_name()"));

                IsLocal = (host ?? string.Empty) == Environment.MachineName;
            }

            tableName = Uri.Segments[1];

            IsTransactional = true;

            BuildQueries();
        }
Example #34
0
 public UserStore(IDatabaseConnectionFactory databaseConnectionFactory)
 {
     _usersTable       = new UsersProvider(databaseConnectionFactory);
     _usersRolesTable  = new UserRolesProvider(databaseConnectionFactory);
     _rolesTable       = new RolesProvider(databaseConnectionFactory);
     _usersClaimsTable = new UserClaimsProvider(databaseConnectionFactory);
     _usersLoginsTable = new UserLoginsProvider(databaseConnectionFactory);
     _userTokensTable  = new UserTokensProvider(databaseConnectionFactory);
 }
 public AccountMerchantRulesDetailService(IDatabaseConnectionFactory databaseConnectionFactory, IConfiguration configuration, ILoggerManager logger,
                                          IMapper mapper)
     : base(databaseConnectionFactory)
 {
     _databaseConnectionFactory = databaseConnectionFactory ?? throw new ArgumentNullException(nameof(databaseConnectionFactory));
     _configuration             = configuration;
     _logger = logger;
     _mapper = mapper;
 }
        public SubscriptionManager(IScriptProvider scriptProvider, IDatabaseConnectionFactory databaseConnectionFactory,
                                   IDatabaseGateway databaseGateway)
        {
            Guard.AgainstNull(scriptProvider, "scriptProvider");
            Guard.AgainstNull(databaseConnectionFactory, "databaseConnectionFactory");
            Guard.AgainstNull(databaseGateway, "databaseGateway");

            this.scriptProvider = scriptProvider;
            this.databaseConnectionFactory = databaseConnectionFactory;
            this.databaseGateway = databaseGateway;
        }
        public IdempotenceService(
			IScriptProvider scriptProvider,
			IDatabaseConnectionFactory databaseConnectionFactory,
			IDatabaseGateway databaseGateway)
        {
            Guard.AgainstNull(scriptProvider, "_scriptProvider");
            Guard.AgainstNull(databaseConnectionFactory, "_databaseConnectionFactory");
            Guard.AgainstNull(databaseGateway, "_databaseGateway");

            _scriptProvider = scriptProvider;
            _databaseConnectionFactory = databaseConnectionFactory;
            _databaseGateway = databaseGateway;
        }
Example #38
0
 public SqlQueueFactory()
 {
     scriptProvider = new ScriptProvider();
     databaseConnectionFactory = DatabaseConnectionFactory.Default();
     databaseGateway = DatabaseGateway.Default();
 }
Example #39
0
        public void Start()
        {
            XmlConfigurator.Configure();

            Log.Assign(new Log4NetLog(LogManager.GetLogger(typeof (Program))));

            ConnectionStrings.Approve();

            container.RegisterSingleton("Shuttle.Core.Infrastructure", RegexPatterns.EndsWith("Factory"));
            container.RegisterSingleton("Shuttle.Core.Infrastructure", RegexPatterns.EndsWith("Mapper"));

            container.RegisterDataAccessCore();
            container.RegisterDataAccessDefaults();

            container.Register(Component.For<IDatabaseConnectionCache>().ImplementedBy<ThreadStaticDatabaseConnectionCache>());

            container.RegisterDataAccess("Shuttle.Scheduling");
            container.RegisterSingleton("Shuttle.Scheduling", RegexPatterns.EndsWith("Factory"));
            container.RegisterSingleton("Shuttle.Scheduling", RegexPatterns.EndsWith("DomainHandler"));

            DomainEvents.Assign(new DomainEventDispatcher(container));

            bus = ServiceBus
                .Create()
                .SubscriptionManager(SubscriptionManager.Default())
                .AddModule(new ActiveTimeRangeModule())
                .Start();

            container.Register(bus);

            repository = container.Resolve<IScheduleRepository>();
            databaseConnectionFactory = container.Resolve<IDatabaseConnectionFactory>();

            thread = new Thread(ProcessSchedule);

            thread.Start();
        }
Example #40
0
        public void Start()
        {
            Log.Assign(new Log4NetLog(LogManager.GetLogger(typeof (Program))));

            new ConnectionStringService().Approve();

            _container.Register(Component.For<IDatabaseConnectionCache>()
                .ImplementedBy<ThreadStaticDatabaseConnectionCache>());

            _container.Register(Component.For<IDbConnectionConfiguration>()
                .ImplementedBy<DbConnectionConfiguration>());

            _container.Register(Component.For<IDbConnectionConfigurationProvider>()
                .ImplementedBy<DbConnectionConfigurationProvider>());

            _container.Register(Component.For<IDatabaseGateway>().ImplementedBy<DatabaseGateway>());
            _container.Register(Component.For<IDatabaseConnectionFactory>().ImplementedBy<DatabaseConnectionFactory>());
            _container.Register(Component.For(typeof (IDataRepository<>)).ImplementedBy(typeof (DataRepository<>)));

            _container.Register(
                Classes
                    .FromAssemblyNamed("Shuttle.Core.Data")
                    .Pick()
                    .If(type => type.Name.EndsWith("Factory"))
                    .Configure(configurer => configurer.Named(configurer.Implementation.Name.ToLower()))
                    .WithService.Select((type, basetype) => new[] {type.InterfaceMatching(@".*Factory\Z")}));

            const string shuttleScheduling = "Shuttle.Scheduling";

            _container.Register(
                Classes
                    .FromAssemblyNamed(shuttleScheduling)
                    .BasedOn(typeof (IDataRowMapper<>))
                    .WithServiceFirstInterface());

            _container.Register(
                Classes
                    .FromAssemblyNamed(shuttleScheduling)
                    .Pick()
                    .If(type => type.Name.EndsWith("Repository"))
                    .WithServiceFirstInterface());

            _container.Register(
                Classes
                    .FromAssemblyNamed(shuttleScheduling)
                    .Pick()
                    .If(type => type.Name.EndsWith("Query"))
                    .WithServiceFirstInterface());

            _container.Register(
                Classes
                    .FromAssemblyNamed(shuttleScheduling)
                    .Pick()
                    .If(type => type.Name.EndsWith("Factory"))
                    .WithServiceFirstInterface());

            _container.Register(
                Classes
                    .FromAssemblyNamed(shuttleScheduling)
                    .Pick()
                    .If(type => type.Name.EndsWith("DomainHandler"))
                    .WithServiceFirstInterface());

            DomainEvents.Assign(new DomainEventDispatcher(_container));

            _bus = ServiceBus.Create(c => c
                .SubscriptionManager(SubscriptionManager.Default())
                .AddModule(new ActiveTimeRangeModule()))
                .Start();

            _container.Register(Component.For<IServiceBus>().Instance(_bus).LifestyleSingleton());

            _repository = _container.Resolve<IScheduleRepository>();
            _databaseConnectionFactory = _container.Resolve<IDatabaseConnectionFactory>();

            _thread = new Thread(ProcessSchedule);

            _thread.Start();
        }