/**
         *  Confirm Asset EMail Delivery
         *	@param email email sent
         *  @param AD_User_ID recipient
         *  @return asset delivery
         */
        public MAssetDelivery ConfirmDelivery(EMail email, int AD_User_ID)
        {
            SetVersionNo(GetProductVersionNo());
            MAssetDelivery ad = new MAssetDelivery(this, email, null, AD_User_ID);

            return(ad);
        }
        /*  Get Deliveries
         *  @return deliveries
         */
        public MAssetDelivery[] GetDeliveries()
        {
            List <MAssetDelivery> list = new List <MAssetDelivery>();

            String      sql = "SELECT * FROM A_Asset_Delivery WHERE A_Asset_ID=" + GetA_Asset_ID() + " ORDER BY Created DESC";
            DataTable   dt  = null;
            IDataReader idr = DB.ExecuteReader(sql, null, Get_TrxName());

            try
            {
                dt = new DataTable();
                dt.Load(idr);
                idr.Close();
                foreach (DataRow dr in dt.Rows)
                {
                    list.Add(new MAssetDelivery(GetCtx(), dr, Get_TrxName()));
                }
                dt = null;
            }
            catch (Exception e)
            {
                if (idr != null)
                {
                    idr.Close();
                }
                log.Log(Level.SEVERE, sql, e);
            }

            //
            MAssetDelivery[] retValue = new MAssetDelivery[list.Count];
            retValue = list.ToArray();
            return(retValue);
        }