/**
* Get all active interest areas
* @param ctx context
* @return interest areas
*/
public static MInterestArea[] GetAll(Ctx ctx)
{
List <MInterestArea> list = new List <MInterestArea>();
String sql = "SELECT * FROM R_InterestArea WHERE IsActive='Y'";
DataTable dt = null;
IDataReader idr = null;
try
{
idr = DataBase.DB.ExecuteReader(sql, null, null);
dt = new DataTable();
dt.Load(idr);
idr.Close();
foreach (DataRow dr in dt.Rows)
{
MInterestArea ia = new MInterestArea(ctx, dr, null);
list.Add(ia);
}
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
_log.Log(Level.SEVERE, sql, e);
}
finally { dt = null; }
MInterestArea[] retValue = new MInterestArea[list.Count];
retValue = list.ToArray();
return(retValue);
}
} // isSubscribed
/**
* After Save
* @param newRecord new
* @param success success
* @return success
*/
protected override Boolean AfterSave(Boolean newRecord, Boolean success)
{
if (success && newRecord && IsSubscribed())
{
MInterestArea ia = MInterestArea.Get(GetCtx(), GetR_InterestArea_ID());
if (ia.GetR_Source_ID() != 0)
{
String summary = "Subscribe: " + ia.GetName();
//
MSource source = MSource.Get(GetCtx(), ia.GetR_Source_ID());
MUser user = null;
if (Get_TrxName() == null)
{
user = MUser.Get(GetCtx(), GetAD_User_ID());
}
else
{
user = new MUser(GetCtx(), GetAD_User_ID(), Get_TrxName());
}
// Create Request
if (MSource.SOURCECREATETYPE_Both.Equals(source.GetSourceCreateType()) ||
MSource.SOURCECREATETYPE_Request.Equals(source.GetSourceCreateType()))
{
MRequest request = new MRequest(GetCtx(), 0, Get_TrxName());
request.SetClientOrg(this);
request.SetSummary(summary);
request.SetAD_User_ID(GetAD_User_ID());
request.SetC_BPartner_ID(user.GetC_BPartner_ID());
request.SetR_Source_ID(source.GetR_Source_ID());
request.Save();
}
// Create Lead
if (MSource.SOURCECREATETYPE_Both.Equals(source.GetSourceCreateType()) ||
MSource.SOURCECREATETYPE_Lead.Equals(source.GetSourceCreateType()))
{
MLead lead = new MLead(GetCtx(), 0, Get_TrxName());
lead.SetClientOrg(this);
lead.SetDescription(summary);
lead.SetAD_User_ID(GetAD_User_ID());
lead.SetR_InterestArea_ID(GetR_InterestArea_ID());
lead.SetC_BPartner_ID(user.GetC_BPartner_ID());
lead.SetR_Source_ID(source.GetR_Source_ID());
lead.Save();
}
}
}
return(success);
} // afterSave
/**
* Get MInterestArea from Cache
* @param ctx context
* @param R_InterestArea_ID id
* @return MInterestArea
*/
public static MInterestArea Get(Ctx ctx, int R_InterestArea_ID)
{
int key = R_InterestArea_ID;
MInterestArea retValue = (MInterestArea)_cache[key];
if (retValue != null)
{
return(retValue);
}
retValue = new MInterestArea(ctx, R_InterestArea_ID, null);
if (retValue.Get_ID() != 0)
{
_cache.Add(key, retValue);
}
return(retValue);
}
} // findClient
/// <summary>
/// Find Interest Area
/// </summary>
/// <param name="AD_Client_ID">client</param>
/// <param name="interestArea">interset Name client name</param>
/// <returns>AD_Client_ID</returns>
private int FindInterestArea(int AD_Client_ID, String interestArea)
{
if (_interests == null)
{
_interests = MInterestArea.GetAll(GetCtx());
}
for (int i = 0; i < _interests.Length; i++)
{
if (AD_Client_ID == _interests[i].GetAD_Client_ID() &&
interestArea.ToLower().Equals(_interests[i].GetValue().ToLower())) // interestArea.equalsIgnoreCase(_interests[i].GetValue()))
{
return(_interests[i].GetR_InterestArea_ID());
}
}
return(0);
} // findInterestArea