private void GetRequests() { short portfolio = 1; if (IncludePortfolio2) { portfolio = 2; } if (IncludePortfolio3) { portfolio = 3; } if (IncludePortfolio4) { portfolio = 4; } var param = new StoreYbAnalyticReq() { RunDate = SelectedRequestGroup.RunDate, ValDate = SelectedRequestGroup.ValDate, Slot = SelectedRequestGroup.Slot, PortfolioId = portfolio }; Requests = new ObservableCollection <StoreYbAnalyticReq>(AvDataContext.GetRequests(param)); OnPropertyChanged("Requests"); }
public void Dc_Returns_RequestGroup() { var requestGroup = AvDataContext.RequestGroup(); Assert.IsType <List <StoreYbAnalyticReq> >(requestGroup); Assert.NotEmpty(requestGroup); Assert.True(requestGroup.Count > 0); }
public DatabaseFixture() { var databaseConfigFileName = "AnalyticViewer.database.config"; var installationDirectory = @"c:\Dev\AnalyticsViewer\AvDataAccess"; var databaseConfig = System.IO.Path.Combine(installationDirectory, databaseConfigFileName); var mappingSource = XmlMappingSource.FromUrl(databaseConfig); AvDataContext = new AvDataContext("Data Source=lonbscadsqlbl01;Initial Catalog=CADIS_E2E01;Integrated Security=True", mappingSource, false, 30); }
public void Dc_Returns_DateList() { // Arrange // Act var dateList = AvDataContext.RunDateList(); // Assert Assert.NotEmpty(dateList); }
public virtual void RegisterInstances() { AppConfiguration = Container.Resolve <IAppConfiguration>(); var connectionString = AppConfiguration.DatabaseConnection; var mappingSource = XmlMappingSource.FromUrl(AppConfiguration.DatabaseConfigFilename); var timeout = AppConfiguration.DatabaseTimeout; repository = new AvDataContext(connectionString, mappingSource, false, timeout); Container.RegisterInstance <IUnitOfWork>(repository); }
public void Dc_ReturnsRequestsForYieldbookId() { // Arrange string yieldbookId = "AR4164364"; // Act var requests = AvDataContext.GetRequestsByYieldbookId(yieldbookId); // Assert Assert.IsType <List <StoreYbAnalyticReq> >(requests); Assert.NotEmpty(requests); Assert.True(requests.Count > 0); }
public void Dc_ReturnsRequestsForCadisId() { // Arrange int cadisId = 31; // Act var requests = AvDataContext.GetRequestsByCadisId(cadisId); // Assert Assert.IsType <List <StoreYbAnalyticReq> >(requests); Assert.NotEmpty(requests); Assert.True(requests.Count > 0); }
public void Dc_ReturnsRequestsForRequestGroup() { // Arrange var requestGroup = new StoreYbAnalyticReq() { RunDate = new DateTime(2018, 2, 23, 0, 30, 5), ValDate = new DateTime(2018, 2, 21), Slot = 2, PortfolioId = 1, }; // Act var requests = AvDataContext.GetRequests(requestGroup); // Assert Assert.IsType <List <StoreYbAnalyticReq> >(requests); Assert.NotEmpty(requests); Assert.True(requests.Count > 0); }
public void Dispose() { AvDataContext.Dispose(); }