public IList <RouteListItemCashDistributionDocument> GetRouteListItemCashDistributionDocuments(IUnitOfWork uow, int incomeId)
{
RouteListItemCashDistributionDocument docAlias = null;
var query = uow.Session.QueryOver(() => docAlias)
.Where(() => docAlias.Income.Id == incomeId)
.List();
return(query);
}
public decimal GetDistributedIncomeAmount(IUnitOfWork uow, int incomeId)
{
RouteListItemCashDistributionDocument docAlias = null;
var query = uow.Session.QueryOver(() => docAlias)
.Where(() => docAlias.Income.Id == incomeId)
.Select(Projections.Sum(() => docAlias.Amount))
.SingleOrDefault <decimal>();
return(query);
}
public decimal GetDistributedAmountOnRouteList(IUnitOfWork uow, int routeListId)
{
RouteList routeListAlias = null;
RouteListItem routeListItemAlias = null;
RouteListItemCashDistributionDocument docAlias = null;
var query = uow.Session.QueryOver(() => docAlias)
.Left.JoinAlias(() => docAlias.RouteListItem, () => routeListItemAlias)
.Left.JoinAlias(() => routeListItemAlias.RouteList, () => routeListAlias)
.Where(() => routeListAlias.Id == routeListId)
.Select(Projections.Sum(() => docAlias.Amount))
.SingleOrDefault <decimal>();
return(query);
}
private void Save(IUnitOfWork uow, OrganisationCashMovementOperation operation,
RouteListItemCashDistributionDocument routeListItemCashdistributionDoc)
{
uow.Save(operation);
uow.Save(routeListItemCashdistributionDoc);
}
private void DeleteDocument(IUnitOfWork uow, RouteListItemCashDistributionDocument doc) => uow.Delete(doc);
private void DeleteOperation(IUnitOfWork uow, RouteListItemCashDistributionDocument doc)
{
uow.Delete(doc.OrganisationCashMovementOperation);
doc.OrganisationCashMovementOperation = null;
}
