/// <summary>
/// Get BP Group
/// </summary>
/// <param name="group">group</param>
public void SetBPGroup(MBPGroup group)
{
_group = group;
if (_group == null)
{
return;
}
SetC_BP_Group_ID(_group.GetC_BP_Group_ID());
if (_group.GetC_Dunning_ID() != 0)
{
SetC_Dunning_ID(_group.GetC_Dunning_ID());
}
if (_group.GetM_PriceList_ID() != 0)
{
SetM_PriceList_ID(_group.GetM_PriceList_ID());
}
if (_group.GetPO_PriceList_ID() != 0)
{
SetPO_PriceList_ID(_group.GetPO_PriceList_ID());
}
if (_group.GetM_DiscountSchema_ID() != 0)
{
SetM_DiscountSchema_ID(_group.GetM_DiscountSchema_ID());
}
if (_group.GetPO_DiscountSchema_ID() != 0)
{
SetPO_DiscountSchema_ID(_group.GetPO_DiscountSchema_ID());
}
}
/**
* Get MBPGroup from Business Partner
* @param ctx context
* @param C_BPartner_ID business partner id
* @return MBPGroup
*/
public static MBPGroup GetOfBPartner(Ctx ctx, int C_BPartner_ID)
{
MBPGroup retValue = null;
DataTable dt = null;
String sql = "SELECT * FROM C_BP_Group g "
+ "WHERE EXISTS (SELECT * FROM C_BPartner p "
+ "WHERE p.C_BPartner_ID=" + C_BPartner_ID + " AND p.C_BP_Group_ID=g.C_BP_Group_ID)";
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)
{
retValue = new MBPGroup(ctx, dr, null);
int key = retValue.GetC_BP_Group_ID();
if (retValue.Get_ID() != 0)
{
_cache.Add(key, retValue);
}
}
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
_log.Log(Level.SEVERE, sql, e);
}
finally { dt = null; }
return(retValue);
}
