public static IList<AdditionalAgreement> GetActiveAgreementsForDeliveryPoint(IUnitOfWork uow, DeliveryPoint deliveryPoint)
 {
     AdditionalAgreement agreementAlias = null;
     var queryResult = uow.Session.QueryOver<AdditionalAgreement>(() => agreementAlias)
         .Where(() => agreementAlias.DeliveryPoint.Id == deliveryPoint.Id)
         .Where(() => !agreementAlias.IsCancelled)
         .List();
     return queryResult;
 }
Exemplo n.º 2
0
        public static int GetBottlesAtDeliveryPoint(IUnitOfWork UoW, DeliveryPoint deliveryPoint, DateTime? before = null)
        {
            BottlesMovementOperation operationAlias = null;
            BottlesBalanceQueryResult result = null;
            var queryResult = UoW.Session.QueryOver<BottlesMovementOperation>(() => operationAlias)
                .Where(() => operationAlias.DeliveryPoint.Id == deliveryPoint.Id);
            if (before.HasValue)
                queryResult.Where(() => operationAlias.OperationTime < before);

            var bottles =  queryResult.SelectList(list => list
                    .SelectSum(()=>operationAlias.Delivered).WithAlias(()=>result.Delivered)
                    .SelectSum(()=>operationAlias.Returned).WithAlias(()=>result.Returned)
                )
                .TransformUsing(Transformers.AliasToBean<BottlesBalanceQueryResult>()).List<BottlesBalanceQueryResult>()
                .FirstOrDefault()?.BottlesDebt ?? 0;
            return bottles;
        }
 public static IList<Equipment> GetEquipmentAtDeliveryPoint(IUnitOfWork uow, DeliveryPoint deliveryPoint)
 {
     return GetEquipmentAtDeliveryPointQuery(deliveryPoint.Counterparty, deliveryPoint)
         .GetExecutableQueryOver(uow.Session)
         .List();
 }
        public static QueryOver<Equipment> GetEquipmentAtDeliveryPointQuery(Counterparty client, DeliveryPoint deliveryPoint)
        {
            Equipment equipmentAlias=null;
            CounterpartyMovementOperation operationAlias = null;
            CounterpartyMovementOperation subsequentOperationAlias = null;

            var subsequentOperationsSubquery = QueryOver.Of<CounterpartyMovementOperation> (() => subsequentOperationAlias)
                .Where (() => operationAlias.Id < subsequentOperationAlias.Id && operationAlias.Equipment == subsequentOperationAlias.Equipment)
                .Select (op=>op.Id);

            var availableEquipmentIDsSubquery = QueryOver.Of<CounterpartyMovementOperation>(() => operationAlias)
                .WithSubquery.WhereNotExists(subsequentOperationsSubquery)
                .Where (() => operationAlias.IncomingCounterparty.Id == client.Id);
            if (deliveryPoint != null)
                availableEquipmentIDsSubquery
                    .Where(() => operationAlias.IncomingDeliveryPoint.Id == deliveryPoint.Id);
            availableEquipmentIDsSubquery
                .Select(op=>op.Equipment.Id);
            return QueryOver.Of<Equipment> (() => equipmentAlias).WithSubquery.WhereProperty (() => equipmentAlias.Id).In (availableEquipmentIDsSubquery);
        }
 public virtual void CreateOperation(Counterparty counterpartySrc, DeliveryPoint pointSrc, Counterparty counterpartyDst, DeliveryPoint pointDst, DateTime time)
 {
     WarehouseMovementOperation = null;
     CounterpartyMovementOperation = new CounterpartyMovementOperation
         {
             IncomingCounterparty = counterpartyDst,
             IncomingDeliveryPoint = pointDst,
             WriteoffCounterparty = counterpartySrc,
             WriteoffDeliveryPoint = pointSrc,
             Amount = Amount,
             OperationTime = time,
             Nomenclature = Nomenclature,
             Equipment = Equipment
         };
 }
Exemplo n.º 6
0
 public static DeliveryPoint Create(Counterparty counterparty)
 {
     var point = new DeliveryPoint ();
     point.Counterparty = counterparty;
     counterparty.DeliveryPoints.Add(point);
     return point;
 }