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