/// <summary>
/// Get Trial Products for Entity Type
/// </summary>
/// <param name="ctx">ctx</param>
/// <param name="entityType">entity type</param>
/// <returns>trial product or null</returns>
public static MProduct GetTrial(Ctx ctx, String entityType)
{
if (Util.IsEmpty(entityType))
{
_log.Warning("No Entity Type");
return(null);
}
MProduct retValue = null;
String sql = "SELECT * FROM M_Product "
+ "WHERE LicenseInfo LIKE '%" + entityType + "%' AND TrialPhaseDays > 0 AND IsActive='Y'";
//String entityTypeLike = "%" + entityType + "%";
//pstmt.setString(1, entityTypeLike);
DataSet ds = new DataSet();
try
{
ds = DB.ExecuteDataset(sql, null, null);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
retValue = new MProduct(ctx, dr, null);
}
ds = null;
}
catch (Exception e)
{
_log.Log(Level.SEVERE, sql, e);
}
if (retValue != null && retValue.GetAD_Client_ID() != ctx.GetAD_Client_ID())
{
_log.Warning("ProductClient_ID=" + retValue.GetAD_Client_ID() + " <> EnvClient_ID=" + ctx.GetAD_Client_ID());
}
if (retValue != null && retValue.GetA_Asset_Group_ID() == 0)
{
_log.Warning("Product has no Asset Group - " + retValue);
return(null);
}
if (retValue == null)
{
_log.Warning("No Product for EntityType - " + entityType);
}
return(retValue);
}
