/**
* 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);
}