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();
}
