/* 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 = DataBase.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); }
/** * 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); }
} // authenticateSubscription /// <summary> /// Authenticate Product Asset /// </summary> /// <param name="ldapUser">user</param> /// <param name="AD_User_ID">id</param> /// <param name="usr">user authentification (email, ...)</param> /// <param name="M_Product_ID">product</param> /// <param name="AD_Client_ID">client</param> /// <param name="remoteHost">remote info</param> /// <param name="remoteAddr">remote info</param> /// <returns>user with error message set if error</returns> private MLdapUser AuthenticateAsset(MLdapUser ldapUser, int AD_User_ID, String usr, int M_Product_ID, int AD_Client_ID, String remoteHost, String remoteAddr) { String error = null; String info = null; // Query 2 - Validate Asset MAsset asset = null; String sql = "SELECT * " + "FROM A_Asset " + "WHERE M_Product_ID=@param1" + " AND AD_User_ID=@param2"; // only specific user // Will have problems with multiple assets SqlParameter[] param = new SqlParameter[2]; IDataReader idr = null; try { //pstmt = DataBase.prepareStatement (sql, null); //pstmt.setInt (1, M_Product_ID); param[0] = new SqlParameter("@param1", M_Product_ID); //pstmt.setInt (2, AD_User_ID); param[1] = new SqlParameter("@param2", AD_User_ID); idr = DataBase.DB.ExecuteReader(sql, param, null); if (idr.Read()) { asset = new MAsset(GetCtx(), idr, null); } idr.Close(); } catch (Exception e) { if (idr != null) { idr.Close(); } _log.Log(Level.SEVERE, sql, e); error = "System Error (3)"; } // System Error if (error != null) { _error++; ldapUser.SetErrorString(error); return(ldapUser); } int A_Asset_ID = 0; if (asset == null) { error = "@UserNoAsset@ User="******"No Asset - " + usr + " - " + M_Product_ID; } else if (!asset.IsActive()) { A_Asset_ID = asset.GetA_Asset_ID(); error = "@UserNoAsset@ User="******"Asset not active - " + usr; } else if (!asset.IsActive(true)) { A_Asset_ID = asset.GetA_Asset_ID(); error = "@UserNoAsset@ User="******" @GuaranteeDate@=" + asset.GetGuaranteeDate(); info = "Expired - " + usr + " - GuaranteeDate=" + asset.GetGuaranteeDate(); } else { info = "Asset - " + usr; } if (error != null) // should use Language of the User { LogAccess(AD_Client_ID, AD_User_ID, 0, A_Asset_ID, info, error, remoteHost, remoteAddr); ldapUser.SetErrorString(Msg.Translate(GetCtx(), error)); return(ldapUser); } // Done OK MLdapAccess log = LogAccess(AD_Client_ID, AD_User_ID, 0, asset.GetA_Asset_ID(), info, null, remoteHost, remoteAddr); MAssetDelivery ad = new MAssetDelivery(asset, null, log.ToString(), AD_User_ID); ad.SetRemote_Host(remoteHost); ad.SetRemote_Addr(remoteAddr); ad.Save(); return(ldapUser); } // authenticateAsset