public List <StoreYbAnalyticReq> GetRequests(StoreYbAnalyticReq requestGroup)
{
return(this.StoreYbAnalyticReqs
.Where(r => r.RunDate == requestGroup.RunDate &&
r.ValDate == requestGroup.ValDate &&
r.Slot == requestGroup.Slot &&
r.PortfolioId == requestGroup.PortfolioId)
.Select
(r => new StoreYbAnalyticReq()
{
RunDate = r.RunDate,
ValDate = r.ValDate,
CadisId = r.CadisId,
Slot = r.Slot,
YbYieldbookId = r.YbYieldbookId,
PortfolioId = r.PortfolioId,
UserBond = r.UserBond,
ParAmt = r.ParAmt,
PrepayModel = r.PrepayModel,
PricingLevel = r.PricingLevel,
OutputFile = r.OutputFile,
OutputLine = r.OutputLine,
OmittedFromSecondRun = r.OmittedFromSecondRun
})
.Distinct()
.OrderBy(r => r.CadisId)
.ToList());
}
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_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);
}
// Not sure if I can add hints to make this usable from linq to sql query
private StoreYbAnalyticReq CreateStoreYbAnalyticReq(StoreYbAnalyticReq r)
{
return(new StoreYbAnalyticReq()
{
RunDate = r.RunDate,
ValDate = r.ValDate,
CadisId = r.CadisId,
Slot = r.Slot,
YbYieldbookId = r.YbYieldbookId,
PortfolioId = r.PortfolioId,
UserBond = r.UserBond,
ParAmt = r.ParAmt,
PrepayModel = r.PrepayModel,
PricingLevel = r.PricingLevel,
OutputFile = r.OutputFile,
OutputLine = r.OutputLine,
OmittedFromSecondRun = r.OmittedFromSecondRun
});
}
