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 <PurchaseOrderItemSchedule> GetPurchaseOrderScheduleItems(string orderNumber, string ItemSequenceNo)
 {
     try
     {
         string whereCluase = "";
         string orderCluase = "";
         whereCluase = " EBELN = '" + Utility.EscapeSQL(orderNumber) + "' AND EBELP='" + Utility.EscapeSQL(ItemSequenceNo) + "' ";
         orderCluase = " ETENR asc ";
         return(PurchaseOrderItemScheduleDAO.RetrieveByQuery(whereCluase, orderCluase));
     }
     catch (Exception ex)
     {
         Utility.ExceptionLog(ex);
         throw (ex);
     }
 }