public static void AcknowledgePurchaseOrder(PurchaseOrderHeader header, Collection <PurchaseOrderItemSchedule> schedules) { try { EpTransaction tran = DataManager.BeginTransaction(); try { PurchaseOrderHeaderDAO.Update(tran, header); foreach (PurchaseOrderItemSchedule schedule in schedules) { PurchaseOrderItemScheduleDAO.Update(tran, schedule); } tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw (ex); } finally { tran.Dispose(); } } catch (Exception ex) { Utility.ExceptionLog(ex); throw (ex); } }
public static Collection <PurchaseOrderHeader> GetPendingAckPOList(string orderNumber, DateTime startDate, DateTime endDate, string status) { try { string whereCluase = ""; string orderCluase = ""; whereCluase = " ACKSTS = '" + POAckStatus.PendingAcknowledge + "'"; if (orderNumber != "") { whereCluase += " AND EBELN = '" + Utility.EscapeSQL(orderNumber) + "' "; } if (startDate != DateTime.MinValue) { whereCluase += " AND BEDAT >= " + Utility.GetStoredDateValue(startDate); } if (endDate != DateTime.MinValue) { whereCluase += " AND BEDAT <= " + Utility.GetStoredDateValue(endDate); } orderCluase = " EBELN asc "; return(PurchaseOrderHeaderDAO.RetrieveByQuery(whereCluase, orderCluase)); } catch (Exception ex) { Utility.ExceptionLog(ex); throw (ex); } }
/// <summary> Retrieves in this PurchaseOrderHeaderCollection object all PurchaseOrderHeaderEntity objects which are related via a relation of type 'm:n' with the passed in ProductEntity. /// All current elements in the collection are removed from the collection.</summary> /// <param name="productInstance">ProductEntity object to be used as a filter in the m:n relation</param> /// <param name="maxNumberOfItemsToReturn"> The maximum number of items to return with this retrieval query.</param> /// <param name="sortClauses">The order by specifications for the sorting of the resultset. When not specified, no sorting is applied.</param> /// <param name="prefetchPathToUse">the PrefetchPath which defines the graph of objects to fetch.</param> /// <returns>true if the retrieval succeeded, false otherwise</returns> public bool GetMultiManyToManyUsingProductCollectionViaPurchaseOrderDetail(IEntity productInstance, long maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath prefetchPathToUse) { if (!base.SuppressClearInGetMulti) { this.Clear(); } PurchaseOrderHeaderDAO dao = DAOFactory.CreatePurchaseOrderHeaderDAO(); return(dao.GetMultiUsingProductCollectionViaPurchaseOrderDetail(base.Transaction, this, maxNumberOfItemsToReturn, sortClauses, base.EntityFactoryToUse, productInstance, prefetchPathToUse)); }
/// <summary> Gets a scalar value, calculated with the aggregate and expression specified. the field index specified is the field the expression and aggregate are applied on.</summary> /// <param name="fieldIndex">Field index of field to which to apply the aggregate function and expression</param> /// <param name="expressionToExecute">The expression to execute. Can be null</param> /// <param name="aggregateToApply">Aggregate function to apply. </param> /// <param name="filter">The filter to apply to retrieve the scalar</param> /// <param name="relations">The relations to walk</param> /// <param name="groupByClause">The groupby clause to apply to retrieve the scalar</param> /// <returns>the scalar value requested</returns> public virtual object GetScalar(PurchaseOrderHeaderFieldIndex fieldIndex, IExpression expressionToExecute, AggregateFunction aggregateToApply, IPredicate filter, IRelationCollection relations, IGroupByCollection groupByClause) { EntityFields fields = new EntityFields(1); fields[0] = EntityFieldFactory.Create(fieldIndex); if ((fields[0].ExpressionToApply == null) || (expressionToExecute != null)) { fields[0].ExpressionToApply = expressionToExecute; } if ((fields[0].AggregateFunctionToApply == AggregateFunction.None) || (aggregateToApply != AggregateFunction.None)) { fields[0].AggregateFunctionToApply = aggregateToApply; } PurchaseOrderHeaderDAO dao = DAOFactory.CreatePurchaseOrderHeaderDAO(); return(dao.GetScalar(fields, base.Transaction, filter, relations, groupByClause)); }
/// <summary> Retrieves in this PurchaseOrderHeaderCollection object all PurchaseOrderHeaderEntity objects which have data in common with the specified related Entities. /// If one is omitted, that entity is not used as a filter. All current elements in the collection are removed from the collection.</summary> /// <param name="employeeInstance">EmployeeEntity instance to use as a filter for the PurchaseOrderHeaderEntity objects to return</param> /// <param name="shipMethodInstance">ShipMethodEntity instance to use as a filter for the PurchaseOrderHeaderEntity objects to return</param> /// <param name="vendorInstance">VendorEntity instance to use as a filter for the PurchaseOrderHeaderEntity objects to return</param> /// <param name="maxNumberOfItemsToReturn"> The maximum number of items to return with this retrieval query.</param> /// <param name="sortClauses">The order by specifications for the sorting of the resultset. When not specified, no sorting is applied.</param> /// <param name="filter">Extra filter to limit the resultset. Predicate expression can be null, in which case it will be ignored.</param> /// <param name="pageNumber">The page number to retrieve.</param> /// <param name="pageSize">The page size of the page to retrieve.</param> /// <returns>true if succeeded, false otherwise</returns> public virtual bool GetMultiManyToOne(IEntity employeeInstance, IEntity shipMethodInstance, IEntity vendorInstance, long maxNumberOfItemsToReturn, ISortExpression sortClauses, IPredicateExpression filter, int pageNumber, int pageSize) { bool validParameters = false; validParameters |= (employeeInstance != null); validParameters |= (shipMethodInstance != null); validParameters |= (vendorInstance != null); if (!validParameters) { return(GetMulti(filter, maxNumberOfItemsToReturn, sortClauses, null, pageNumber, pageSize)); } if (!base.SuppressClearInGetMulti) { this.Clear(); } PurchaseOrderHeaderDAO dao = DAOFactory.CreatePurchaseOrderHeaderDAO(); return(dao.GetMulti(base.Transaction, this, maxNumberOfItemsToReturn, sortClauses, base.EntityFactoryToUse, filter, employeeInstance, shipMethodInstance, vendorInstance, pageNumber, pageSize)); }
/// <summary> Retrieves Entity rows in a datatable which match the specified filter. It will always create a new connection to the database.</summary> /// <param name="selectFilter">A predicate or predicate expression which should be used as filter for the entities to retrieve.</param> /// <param name="maxNumberOfItemsToReturn"> The maximum number of items to return with this retrieval query.</param> /// <param name="sortClauses">The order by specifications for the sorting of the resultset. When not specified, no sorting is applied.</param> /// <param name="relations">The set of relations to walk to construct to total query.</param> /// <param name="pageNumber">The page number to retrieve.</param> /// <param name="pageSize">The page size of the page to retrieve.</param> /// <returns>DataTable with the rows requested.</returns> public static DataTable GetMultiAsDataTable(IPredicate selectFilter, long maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relations, int pageNumber, int pageSize) { PurchaseOrderHeaderDAO dao = DAOFactory.CreatePurchaseOrderHeaderDAO(); return(dao.GetMultiAsDataTable(maxNumberOfItemsToReturn, sortClauses, selectFilter, relations, pageNumber, pageSize)); }
/// <summary> Updates in the persistent storage all PurchaseOrderHeader entities which have data in common with the specified related Entities. If one is omitted, that entity is not used as a filter. /// Which fields are updated in those matching entities depends on which fields are <i>changed</i> in the passed in entity entityWithNewValues. The new values of these fields are read from entityWithNewValues. </summary> /// <param name="entityWithNewValues">PurchaseOrderHeaderEntity instance which holds the new values for the matching entities to update. Only changed fields are taken into account</param> /// <param name="employeeInstance">EmployeeEntity instance to use as a filter for the PurchaseOrderHeaderEntity objects to return</param> /// <param name="shipMethodInstance">ShipMethodEntity instance to use as a filter for the PurchaseOrderHeaderEntity objects to return</param> /// <param name="vendorInstance">VendorEntity instance to use as a filter for the PurchaseOrderHeaderEntity objects to return</param> /// <returns>Amount of entities affected, if the used persistent storage has rowcounting enabled.</returns> public int UpdateMultiManyToOne(PurchaseOrderHeaderEntity entityWithNewValues, IEntity employeeInstance, IEntity shipMethodInstance, IEntity vendorInstance) { PurchaseOrderHeaderDAO dao = DAOFactory.CreatePurchaseOrderHeaderDAO(); return(dao.UpdateMulti(entityWithNewValues, base.Transaction, employeeInstance, shipMethodInstance, vendorInstance)); }
/// <summary> Deletes from the persistent storage all PurchaseOrderHeader entities which have data in common with the specified related Entities. If one is omitted, that entity is not used as a filter.</summary> /// <remarks>Runs directly on the persistent storage. It will not delete entity objects from the current collection.</remarks> /// <param name="employeeInstance">EmployeeEntity instance to use as a filter for the PurchaseOrderHeaderEntity objects to return</param> /// <param name="shipMethodInstance">ShipMethodEntity instance to use as a filter for the PurchaseOrderHeaderEntity objects to return</param> /// <param name="vendorInstance">VendorEntity instance to use as a filter for the PurchaseOrderHeaderEntity objects to return</param> /// <returns>Amount of entities affected, if the used persistent storage has rowcounting enabled.</returns> public int DeleteMultiManyToOne(IEntity employeeInstance, IEntity shipMethodInstance, IEntity vendorInstance) { PurchaseOrderHeaderDAO dao = DAOFactory.CreatePurchaseOrderHeaderDAO(); return(dao.DeleteMulti(base.Transaction, employeeInstance, shipMethodInstance, vendorInstance)); }