Example #1
0
        public void Equals_Given_SameOutputs_DifferentIndexes_ActivityTools_AreNotEqual()
        {
            //---------------Set up test pack-------------------
            var uniqueId = Guid.NewGuid().ToString();
            var outputs  = new List <Common.Interfaces.DB.IServiceOutputMapping>
            {
                new ServiceOutputMapping("d", "e", "f"),
                new ServiceOutputMapping("a", "b", "c")
            };
            var outputs2 = new List <Common.Interfaces.DB.IServiceOutputMapping>
            {
                new ServiceOutputMapping("a", "b", "c"),
                new ServiceOutputMapping("d", "e", "f")
            };
            var activity = new DsfOracleDatabaseActivity()
            {
                UniqueID = uniqueId, Outputs = outputs
            };
            var activity1 = new DsfOracleDatabaseActivity()
            {
                UniqueID = uniqueId, Outputs = outputs2
            };

            //---------------Assert Precondition----------------
            Assert.IsNotNull(activity);
            //---------------Execute Test ----------------------
            var @equals = activity.Equals(activity1);

            //---------------Test Result -----------------------
            Assert.IsFalse(@equals);
        }
Example #2
0
        public void Oracle_Ctor_EmptyModelItem()
        {
            //------------Setup for test--------------------------
            CustomContainer.LoadedTypes = new List <Type>()
            {
                typeof(ManageDbServiceModel)
            };
            var mockMainViewModel = new Mock <IShellViewModel>();
            var mockHelpViewModel = new Mock <IHelpWindowViewModel>();

            mockHelpViewModel.Setup(model => model.UpdateHelpText(It.IsAny <string>())).Verifiable();
            mockMainViewModel.Setup(model => model.HelpViewModel).Returns(mockHelpViewModel.Object);
            var server        = new Mock <IServer>();
            var updatemanager = new Mock <IStudioUpdateManager>();
            var queryManager  = new Mock <IQueryManager>();

            queryManager.Setup(manager => manager.FetchDbSources()).Returns(new List <IDbSource>());
            server.Setup(server1 => server1.UpdateRepository).Returns(updatemanager.Object);
            server.Setup(server1 => server1.QueryProxy).Returns(queryManager.Object);
            mockMainViewModel.Setup(model => model.ActiveServer).Returns(server.Object);

            CustomContainer.Register(mockMainViewModel.Object);
            var act = new DsfOracleDatabaseActivity();

            //------------Execute Test---------------------------
            var oracle = new OracleDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), new SynchronousAsyncWorker(), new ViewPropertyBuilder());

            //------------Assert Results-------------------------
            Assert.IsTrue(oracle.SourceRegion.IsEnabled);
            Assert.IsFalse(oracle.OutputsRegion.IsEnabled);
            Assert.IsFalse(oracle.InputArea.IsEnabled);
            Assert.IsTrue(oracle.ErrorRegion.IsEnabled);
        }
Example #3
0
        public void Equals_Given_SameInputsDifferentIndexes_ActivityTools_AreNotEqual()
        {
            //---------------Set up test pack-------------------
            var uniqueId = Guid.NewGuid().ToString();
            var inputs   = new List <Common.Interfaces.DB.IServiceInput>
            {
                new ServiceInput("Input2", "[[InputValue2]]"),
                new ServiceInput("Input1", "[[InputValue1]]")
            };
            var inputs2 = new List <Common.Interfaces.DB.IServiceInput>
            {
                new ServiceInput("Input1", "[[InputValue1]]"),
                new ServiceInput("Input2", "[[InputValue2]]")
            };
            var activity = new DsfOracleDatabaseActivity()
            {
                UniqueID = uniqueId, Inputs = inputs
            };
            var activity1 = new DsfOracleDatabaseActivity()
            {
                UniqueID = uniqueId, Inputs = inputs2
            };

            //---------------Assert Precondition----------------
            Assert.IsNotNull(activity);
            //---------------Execute Test ----------------------
            var @equals = activity.Equals(activity1);

            //---------------Test Result -----------------------
            Assert.IsFalse(@equals);
        }
Example #4
0
        public void Oracle_MethodName_ClearErrors()
        {
            //------------Setup for test--------------------------
            CustomContainer.LoadedTypes = new List <Type>()
            {
                typeof(ManageDbServiceModel)
            };
            var mockMainViewModel = new Mock <IShellViewModel>();
            var mockHelpViewModel = new Mock <IHelpWindowViewModel>();

            mockHelpViewModel.Setup(model => model.UpdateHelpText(It.IsAny <string>())).Verifiable();
            mockMainViewModel.Setup(model => model.HelpViewModel).Returns(mockHelpViewModel.Object);
            var server        = new Mock <IServer>();
            var updatemanager = new Mock <IStudioUpdateManager>();
            var queryManager  = new Mock <IQueryManager>();

            queryManager.Setup(manager => manager.FetchDbSources()).Returns(new List <IDbSource>());
            server.Setup(server1 => server1.UpdateRepository).Returns(updatemanager.Object);
            server.Setup(server1 => server1.QueryProxy).Returns(queryManager.Object);
            mockMainViewModel.Setup(model => model.ActiveServer).Returns(server.Object);

            CustomContainer.Register(mockMainViewModel.Object);
            var mod = new OracleModel();
            var act = new DsfOracleDatabaseActivity();

            var oracle = new OracleDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), new SynchronousAsyncWorker(), new ViewPropertyBuilder());

            //------------Execute Test---------------------------
            oracle.ClearValidationMemoWithNoFoundError();
            //------------Assert Results-------------------------
            Assert.IsNull(oracle.Errors);
            Assert.AreEqual(oracle.DesignValidationErrors.Count, 1);
        }
Example #5
0
        public void DataGridActivityFindMissingStrategy_GetActivityFields_Oracle_ShouldReturnResults()
        {
            //------------Setup for test--------------------------
            Dev2FindMissingStrategyFactory fac      = new Dev2FindMissingStrategyFactory();
            IFindMissingStrategy           strategy = fac.CreateFindMissingStrategy(enFindMissingType.DataGridActivity);
            var activity = new DsfOracleDatabaseActivity
            {
                Inputs = new List <IServiceInput> {
                    new ServiceInput("Input1", "[[InputValue1]]"), new ServiceInput("Input2", "[[InputValue2]]"), new ServiceInput("Input3", "[[InputValue3]]")
                },
                Outputs = new List <IServiceOutputMapping> {
                    new ServiceOutputMapping("Output1", "OutputValue1", "rec"), new ServiceOutputMapping("Output2", "OutputValue2", "rec")
                },
                OnErrorVariable = "[[err]]",
                OnErrorWorkflow = "[[errSvc]]"
            };
            //------------Execute Test---------------------------
            var fields = strategy.GetActivityFields(activity);

            //------------Assert Results-------------------------
            Assert.AreEqual(7, fields.Count);
            Assert.IsTrue(fields.Contains("[[InputValue1]]"));
            Assert.IsTrue(fields.Contains("[[InputValue2]]"));
            Assert.IsTrue(fields.Contains("[[InputValue3]]"));
            Assert.IsTrue(fields.Contains("[[rec().OutputValue1]]"));
            Assert.IsTrue(fields.Contains("[[rec().OutputValue2]]"));
            Assert.IsTrue(fields.Contains("[[err]]"));
            Assert.IsTrue(fields.Contains("[[errSvc]]"));
        }
Example #6
0
        public static DsfOracleDatabaseActivity GetDsfOracleDatabaseActivity(DsfDatabaseActivity dbActivity, DbService service, DbSource source)
        {
            var DsfOracleDatabaseActivity = new DsfOracleDatabaseActivity
            {
                ResourceID                   = dbActivity.ResourceID,
                SourceId                     = source.ResourceID,
                ProcedureName                = service.Method.ExecuteAction,
                Inputs                       = TranslateInputMappingToInputs(dbActivity.InputMapping),
                Outputs                      = TranslateOutputMappingToOutputs(dbActivity.OutputMapping),
                ToolboxFriendlyName          = dbActivity.ToolboxFriendlyName,
                IconPath                     = dbActivity.IconPath,
                ServiceName                  = dbActivity.ServiceName,
                DataTags                     = dbActivity.DataTags,
                ResultValidationRequiredTags = dbActivity.ResultValidationRequiredTags,
                ResultValidationExpression   = dbActivity.ResultValidationExpression,
                FriendlySourceName           = dbActivity.FriendlySourceName,
                EnvironmentID                = dbActivity.EnvironmentID,
                Type                     = dbActivity.Type,
                ActionName               = dbActivity.ActionName,
                RunWorkflowAsync         = dbActivity.RunWorkflowAsync,
                Category                 = dbActivity.Category,
                ServiceUri               = dbActivity.ServiceUri,
                ServiceServer            = dbActivity.ServiceServer,
                UniqueID                 = dbActivity.UniqueID,
                ParentServiceName        = dbActivity.ParentServiceName,
                ParentServiceID          = dbActivity.ParentServiceID,
                ParentWorkflowInstanceId = dbActivity.ParentWorkflowInstanceId,
                ParentInstanceID         = dbActivity.ParentInstanceID,
            };

            return(DsfOracleDatabaseActivity);
        }
Example #7
0
        public void Oracle_TestActionSetSourceAndTestClickOkHasMappings()
        {
            //------------Setup for test--------------------------
            CustomContainer.LoadedTypes = new List <Type>()
            {
                typeof(ManageDbServiceModel)
            };
            var mockMainViewModel = new Mock <IShellViewModel>();
            var mockHelpViewModel = new Mock <IHelpWindowViewModel>();

            mockHelpViewModel.Setup(model => model.UpdateHelpText(It.IsAny <string>())).Verifiable();
            mockMainViewModel.Setup(model => model.HelpViewModel).Returns(mockHelpViewModel.Object);
            var server        = new Mock <IServer>();
            var updatemanager = new Mock <IStudioUpdateManager>();
            var queryManager  = new Mock <IQueryManager>();

            queryManager.Setup(manager => manager.FetchDbSources()).Returns(new List <IDbSource>());
            server.Setup(server1 => server1.UpdateRepository).Returns(updatemanager.Object);
            server.Setup(server1 => server1.QueryProxy).Returns(queryManager.Object);
            mockMainViewModel.Setup(model => model.ActiveServer).Returns(server.Object);

            CustomContainer.Register(mockMainViewModel.Object);
            var mod = new OracleModel();
            var act = new DsfOracleDatabaseActivity();

            //------------Execute Test---------------------------
            var oracle = new OracleDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), new SynchronousAsyncWorker(), new ViewPropertyBuilder());

            oracle.ManageServiceInputViewModel = new InputViewForTest(oracle, mod);
            oracle.SourceRegion.SelectedSource = mod.Sources.First();
#pragma warning disable 4014
            oracle.TestInputCommand.Execute(null);
            oracle.ManageServiceInputViewModel.TestCommand.Execute(null);
            oracle.ManageServiceInputViewModel.IsEnabled          = true;
            oracle.ManageServiceInputViewModel.OutputArea.Outputs = new List <IServiceOutputMapping> {
                new ServiceOutputMapping("a", "b", "c"), new ServiceOutputMapping("a", "b", "c"), new ServiceOutputMapping("a", "b", "c")
            };
            oracle.ManageServiceInputViewModel.Model = new DatabaseService()
            {
                Action = new DbAction()
                {
                    Inputs = new List <IServiceInput>(), Name = "bob"
                }
            };

            oracle.ManageServiceInputViewModel.OkCommand.Execute(null);
#pragma warning restore 4014

            //------------Assert Results-------------------------
            Assert.IsTrue(oracle.SourceRegion.IsEnabled);
            Assert.IsTrue(oracle.OutputsRegion.IsEnabled);
            Assert.IsTrue(oracle.InputArea.IsEnabled);
            Assert.IsTrue(oracle.ErrorRegion.IsEnabled);
            Assert.IsFalse(oracle.ManageServiceInputViewModel.InputArea.IsEnabled);
            Assert.AreEqual(0, oracle.ManageServiceInputViewModel.Errors.Count);
        }
Example #8
0
        public void UniqueIDDifferent_EmptyOracleDatabase_Object_Is_Not_Equal()
        {
            //---------------Set up test pack-------------------
            var uniqueId       = Guid.NewGuid().ToString();
            var activity1      = new DsfOracleDatabaseActivity();
            var oracleDatabase = new DsfOracleDatabaseActivity();

            //---------------Assert Precondition----------------
            Assert.IsNotNull(activity1);
            //---------------Execute Test ----------------------
            var @equals = activity1.Equals(oracleDatabase);

            //---------------Test Result -----------------------
            Assert.IsFalse(@equals);
        }
Example #9
0
        public void Oracle_VerifyCommandTimeout()
        {
            //------------Setup for test--------------------------
            var mod = new OracleModel();
            var act = new DsfOracleDatabaseActivity();

            //------------Execute Test---------------------------
            using (var vm = new OracleDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker(), new ViewPropertyBuilder()))
            {
                vm.InputArea.CommandTimeout = 321;
                //------------Assert Results-------------------------
                var dbService = vm.ToModel();
                Assert.AreEqual(321, dbService.CommandTimeout);
            }
        }
        public void GivenIOpenNewOracleDbWorkflow()
        {
            var oracleServerActivity = new DsfOracleDatabaseActivity();
            var modelItem            = ModelItemUtils.CreateModelItem(oracleServerActivity);

            var mockInputArea              = new Mock <IGenerateInputArea>();
            var mockOutputArea             = new Mock <IGenerateOutputArea>();
            var mockDatabaseInputViewModel = new Mock <IManageDatabaseInputViewModel>();
            var mockDbServiceModel         = new Mock <IDbServiceModel>();
            var mockEnvironmentRepo        = new Mock <IServerRepository>();
            var mockEnvironmentModel       = new Mock <IServer>();

            mockEnvironmentModel.Setup(model => model.IsConnected).Returns(true);
            mockEnvironmentModel.Setup(model => model.IsLocalHost).Returns(true);
            mockEnvironmentModel.Setup(model => model.EnvironmentID).Returns(Guid.Empty);
            mockEnvironmentModel.Setup(model => model.IsLocalHostCheck()).Returns(false);
            mockEnvironmentRepo.Setup(repository => repository.ActiveServer).Returns(mockEnvironmentModel.Object);
            mockEnvironmentRepo.Setup(repository => repository.FindSingle(It.IsAny <Expression <Func <IServer, bool> > >())).Returns(mockEnvironmentModel.Object);

            _greenPointSource = new DbSourceDefinition
            {
                Name               = "GreenPoint",
                Type               = enSourceType.Oracle,
                ServerName         = "Localhost",
                UserName           = "******",
                Password           = "******",
                AuthenticationType = Runtime.ServiceModel.Data.AuthenticationType.User
            };

            var dbSources = new ObservableCollection <IDbSource> {
                _greenPointSource
            };

            mockDbServiceModel.Setup(model => model.RetrieveSources()).Returns(dbSources);

            var mockAction = new Mock <Action>(MockBehavior.Default);

            mockDatabaseInputViewModel.SetupGet(model => model.InputArea).Returns(mockInputArea.Object);
            mockDatabaseInputViewModel.SetupGet(model => model.OutputArea).Returns(mockOutputArea.Object);
            mockDatabaseInputViewModel.Setup(model => model.TestAction).Returns(mockAction.Object);
            mockDatabaseInputViewModel.Setup(model => model.OkAction).Returns(mockAction.Object);

            var oracleServerDesignerViewModel = new OracleDatabaseDesignerViewModel(modelItem, mockDbServiceModel.Object, new SynchronousAsyncWorker(), new ViewPropertyBuilder());

            oracleServerDesignerViewModel.ManageServiceInputViewModel = mockDatabaseInputViewModel.Object;

            AddScenarioContext(oracleServerDesignerViewModel, mockDatabaseInputViewModel, mockDbServiceModel);
        }
Example #11
0
        public void UniqueIDEquals_EmptyOracleDatabase_Object_Is_Equal()
        {
            //---------------Set up test pack-------------------
            var uniqueId       = Guid.NewGuid().ToString();
            var oracleDatabase = new DsfOracleDatabaseActivity()
            {
                UniqueID = uniqueId
            };
            var activity = new DsfOracleDatabaseActivity()
            {
                UniqueID = uniqueId
            };

            //---------------Assert Precondition----------------
            Assert.IsNotNull(oracleDatabase);
            //---------------Execute Test ----------------------
            var equals = oracleDatabase.Equals(activity);

            //---------------Test Result -----------------------
            Assert.IsTrue(@equals);
        }
Example #12
0
        public void Equals_Given_Same_DisplayName_IsEqual()
        {
            //---------------Set up test pack-------------------
            var uniqueId  = Guid.NewGuid().ToString();
            var activity1 = new DsfOracleDatabaseActivity()
            {
                UniqueID = uniqueId, DisplayName = "a"
            };
            var oracleDatabase = new DsfOracleDatabaseActivity()
            {
                UniqueID = uniqueId, DisplayName = "a"
            };

            //---------------Assert Precondition----------------
            Assert.IsNotNull(activity1);
            //---------------Execute Test ----------------------
            var @equals = activity1.Equals(oracleDatabase);

            //---------------Test Result -----------------------
            Assert.IsTrue(@equals);
        }
Example #13
0
        public void Equals_Given_Different_ProcedureName_Is_Not_Equal()
        {
            //---------------Set up test pack-------------------
            var uniqueId  = Guid.NewGuid().ToString();
            var activity1 = new DsfOracleDatabaseActivity()
            {
                UniqueID = uniqueId, ProcedureName = "A"
            };
            var oracleDatabase = new DsfOracleDatabaseActivity()
            {
                UniqueID = uniqueId, ProcedureName = "ass"
            };

            //---------------Assert Precondition----------------
            Assert.IsNotNull(activity1);
            //---------------Execute Test ----------------------
            var @equals = activity1.Equals(oracleDatabase);

            //---------------Test Result -----------------------
            Assert.IsFalse(@equals);
        }
        public void GivenIHaveWorkflowWithOracleDatabaseConnector(string workflowName, string activityName)
        {
            var environmentModel = _scenarioContext.Get <IServer>("server");

            environmentModel.Connect();
            CreateNewResourceModel(workflowName, environmentModel);
            CreateDBServiceModel(environmentModel);

            var dbServiceModel = _scenarioContext.Get <ManageDbServiceModel>("dbServiceModel");
            var oracleActivity = new DsfOracleDatabaseActivity {
                DisplayName = activityName
            };
            var modelItem = ModelItemUtils.CreateModelItem(oracleActivity);
            var oracleDesignerViewModel = new OracleDatabaseDesignerViewModel(modelItem, dbServiceModel, new SynchronousAsyncWorker(), new ViewPropertyBuilder());
            var serviceInputViewModel   = new ManageDatabaseServiceInputViewModel(oracleDesignerViewModel, oracleDesignerViewModel.Model);

            _commonSteps.AddActivityToActivityList(workflowName, activityName, oracleActivity);
            DebugWriterSubscribe(environmentModel);
            _scenarioContext.Add("viewModel", oracleDesignerViewModel);
            _scenarioContext.Add("parentName", workflowName);
        }
Example #15
0
        public void Equals_Given_SameOutputs_ActivityTools_AreEqual()
        {
            //---------------Set up test pack-------------------
            var uniqueId = Guid.NewGuid().ToString();
            var outputs  = new List <Common.Interfaces.DB.IServiceOutputMapping>();
            var activity = new DsfOracleDatabaseActivity()
            {
                UniqueID = uniqueId, Outputs = outputs
            };
            var activity1 = new DsfOracleDatabaseActivity()
            {
                UniqueID = uniqueId, Outputs = outputs
            };

            //---------------Assert Precondition----------------
            Assert.IsNotNull(activity);
            //---------------Execute Test ----------------------
            var @equals = activity.Equals(activity1);

            //---------------Test Result -----------------------
            Assert.IsTrue(@equals);
        }
Example #16
0
        public void Equals_Given_Different_SourceId_IsNotEqual()
        {
            //---------------Set up test pack-------------------
            var uniqueId  = Guid.NewGuid().ToString();
            var sourceId  = Guid.NewGuid();;
            var sourceId2 = Guid.NewGuid();;
            var activity1 = new DsfOracleDatabaseActivity()
            {
                UniqueID = uniqueId, SourceId = sourceId
            };
            var activity = new DsfOracleDatabaseActivity()
            {
                UniqueID = uniqueId, SourceId = sourceId2
            };

            //---------------Assert Precondition----------------
            Assert.IsNotNull(activity1);
            //---------------Execute Test ----------------------
            var @equals = activity1.Equals(activity);

            //---------------Test Result -----------------------
            Assert.IsFalse(@equals);
        }
Example #17
0
        public void Oracle_Refresh_ShouldLoadRefreshActions()
        {
            //------------Setup for test--------------------------
            CustomContainer.LoadedTypes = new List <Type>()
            {
                typeof(ManageDbServiceModel)
            };
            var mockMainViewModel = new Mock <IShellViewModel>();
            var mockHelpViewModel = new Mock <IHelpWindowViewModel>();

            mockHelpViewModel.Setup(model => model.UpdateHelpText(It.IsAny <string>())).Verifiable();
            mockMainViewModel.Setup(model => model.HelpViewModel).Returns(mockHelpViewModel.Object);
            var server        = new Mock <IServer>();
            var updatemanager = new Mock <IStudioUpdateManager>();
            var queryManager  = new Mock <IQueryManager>();

            queryManager.Setup(manager => manager.FetchDbSources()).Returns(new List <IDbSource>());
            server.Setup(server1 => server1.UpdateRepository).Returns(updatemanager.Object);
            server.Setup(server1 => server1.QueryProxy).Returns(queryManager.Object);
            mockMainViewModel.Setup(model => model.ActiveServer).Returns(server.Object);

            CustomContainer.Register(mockMainViewModel.Object);
            var mod    = new OracleModel();
            var act    = new DsfOracleDatabaseActivity();
            var oracle = new OracleDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), mod, new SynchronousAsyncWorker(), new ViewPropertyBuilder());

            oracle.ManageServiceInputViewModel = new InputViewForTest(oracle, mod);
            oracle.SourceRegion.SelectedSource = mod.Sources.First();
            oracle.ActionRegion.IsRefreshing   = false;
            //------------Execute Test---------------------------
            oracle.ActionRegion.RefreshActionsCommand.Execute(null);

            //------------Assert Results-------------------------
            Assert.IsTrue(oracle.SourceRegion.IsEnabled);
            Assert.AreEqual(1, oracle.ActionRegion.Actions.Count);
        }
Example #18
0
        public void Oracle_UpdateHelp_ShouldCallToHelpViewMode()
        {
            //------------Setup for test--------------------------


            CustomContainer.LoadedTypes = new List <Type>()
            {
                typeof(ManageDbServiceModel)
            };
            var mockMainViewModel = new Mock <IShellViewModel>();
            var mockHelpViewModel = new Mock <IHelpWindowViewModel>();

            mockHelpViewModel.Setup(model => model.UpdateHelpText(It.IsAny <string>())).Verifiable();
            mockMainViewModel.Setup(model => model.HelpViewModel).Returns(mockHelpViewModel.Object);
            var server        = new Mock <IServer>();
            var updatemanager = new Mock <IStudioUpdateManager>();
            var queryManager  = new Mock <IQueryManager>();

            queryManager.Setup(manager => manager.FetchDbSources()).Returns(new List <IDbSource>());
            server.Setup(server1 => server1.UpdateRepository).Returns(updatemanager.Object);
            server.Setup(server1 => server1.QueryProxy).Returns(queryManager.Object);
            mockMainViewModel.Setup(model => model.ActiveServer).Returns(server.Object);

            CustomContainer.Register(mockMainViewModel.Object);

            var mod = new OracleModel();

            mod.HasRecError = true;
            var act    = new DsfOracleDatabaseActivity();
            var oracle = new OracleDatabaseDesignerViewModel(ModelItemUtils.CreateModelItem(act), new SynchronousAsyncWorker(), new ViewPropertyBuilder());

            //------------Execute Test---------------------------
            oracle.UpdateHelpDescriptor("help");
            //------------Assert Results-------------------------
            mockHelpViewModel.Verify(model => model.UpdateHelpText(It.IsAny <string>()), Times.Once());
        }
        public void GivenIOpenWolf()
        {
            var sourceId = Guid.NewGuid();
            var inputs   = new List <IServiceInput> {
                new ServiceInput("Prefix", "[[Prefix]]")
            };
            var outputs = new List <IServiceOutputMapping>
            {
                new ServiceOutputMapping("CountryID", "CountryID", "dbo_Pr_CitiesGetCountries"),
                new ServiceOutputMapping("Description", "Description", "dbo_Pr_CitiesGetCountries")
            };
            var oracleServerActivity = new DsfOracleDatabaseActivity
            {
                SourceId      = sourceId,
                ProcedureName = "dbo.Pr_CitiesGetCountries",
                Inputs        = inputs,
                Outputs       = outputs
            };
            var modelItem = ModelItemUtils.CreateModelItem(oracleServerActivity);
            var mockDatabaseInputViewModel = new Mock <IManageDatabaseInputViewModel>();
            var mockDbServiceModel         = new Mock <IDbServiceModel>();
            var mockEnvironmentRepo        = new Mock <IServerRepository>();
            var mockEnvironmentModel       = new Mock <IServer>();

            mockEnvironmentModel.Setup(model => model.IsConnected).Returns(true);
            mockEnvironmentModel.Setup(model => model.IsLocalHost).Returns(true);
            mockEnvironmentModel.Setup(model => model.EnvironmentID).Returns(Guid.Empty);
            mockEnvironmentModel.Setup(model => model.IsLocalHostCheck()).Returns(false);
            mockEnvironmentRepo.Setup(repository => repository.ActiveServer).Returns(mockEnvironmentModel.Object);
            mockEnvironmentRepo.Setup(repository => repository.FindSingle(It.IsAny <Expression <Func <IServer, bool> > >())).Returns(mockEnvironmentModel.Object);

            _greenPointSource = new DbSourceDefinition
            {
                Name = "GreenPoint",
                Type = enSourceType.Oracle
            };

            _testingDbSource = new DbSourceDefinition
            {
                Name = "testingDBSrc",
                Type = enSourceType.Oracle,
                Id   = sourceId
            };

            _importOrderAction = new DbAction
            {
                Name   = "dbo.ImportOrder",
                Inputs = new List <IServiceInput> {
                    new ServiceInput("ProductId", "")
                }
            };

            _getCountriesAction = new DbAction {
                Name = "dbo.Pr_CitiesGetCountries"
            };
            _getCountriesAction.Inputs = inputs;
            var dbSources = new ObservableCollection <IDbSource> {
                _testingDbSource, _greenPointSource
            };

            mockDbServiceModel.Setup(model => model.RetrieveSources()).Returns(dbSources);
            mockDbServiceModel.Setup(model => model.GetActions(It.IsAny <IDbSource>())).Returns(new List <IDbAction> {
                _getCountriesAction, _importOrderAction
            });
            mockDatabaseInputViewModel.SetupAllProperties();
            var oracleDatabaseDesignerViewModel = new OracleDatabaseDesignerViewModel(modelItem, mockDbServiceModel.Object, new SynchronousAsyncWorker(), new ViewPropertyBuilder());

            ScenarioContext.Current.Add("viewModel", oracleDatabaseDesignerViewModel);
            ScenarioContext.Current.Add("mockDatabaseInputViewModel", mockDatabaseInputViewModel);
            ScenarioContext.Current.Add("mockDbServiceModel", mockDbServiceModel);
        }