/// <summary>
/// Get Details
/// </summary>
/// <returns>array of details</returns>
public MCommissionDetail[] GetDetails()
{
String sql = "SELECT * FROM C_CommissionDetail WHERE C_CommissionAmt_ID=@camtid";
List <MCommissionDetail> list = new List <MCommissionDetail>();
try
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@camtid", GetC_CommissionAmt_ID());
DataSet ds = DataBase.DB.ExecuteDataset(sql, param, Get_TrxName());
if (ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new MCommissionDetail(GetCtx(), dr, Get_TrxName()));
}
}
}
catch (Exception e)
{
log.Log(Level.SEVERE, sql, e);
}
// Convert
MCommissionDetail[] retValue = new MCommissionDetail[list.Count];
retValue = list.ToArray();
return(retValue);
}
/// <summary>
/// Calculate Commission
/// </summary>
public void CalculateCommission()
{
MCommissionDetail[] details = GetDetails();
Decimal convertedAmt = Env.ZERO;
Decimal actualQty = Env.ZERO;
for (int i = 0; i < details.Length; i++)
{
MCommissionDetail detail = details[i];
Decimal amt1 = detail.GetConvertedAmt();
//if (amt1 == null)
// amt1 = Env.ZERO;
convertedAmt = Decimal.Add(convertedAmt, amt1);
actualQty = Decimal.Add(actualQty, detail.GetActualQty());
}
SetConvertedAmt(convertedAmt);
SetActualQty(actualQty);
//
MCommissionLine cl = new MCommissionLine(GetCtx(), GetC_CommissionLine_ID(), Get_TrxName());
// Qty
Decimal qty = Decimal.Subtract(GetActualQty(), cl.GetQtySubtract());
if (cl.IsPositiveOnly() && Env.Signum(qty) < 0)
{
qty = Env.ZERO;
}
qty = Decimal.Multiply(qty, cl.GetQtyMultiplier());
// Amt
Decimal amt = Decimal.Subtract(GetConvertedAmt(), cl.GetAmtSubtract());
if (cl.IsPositiveOnly() && Env.Signum(amt) < 0)
{
amt = Env.ZERO;
}
amt = Decimal.Multiply(amt, cl.GetAmtMultiplier());
//
SetCommissionAmt(Decimal.Add(amt, qty));
}
public void CalculatecommissionwithNewLogic()
{
MCommissionDetail[] details = GetDetails();
if (details.Length > 0)
{
Decimal convertedAmt = Env.ZERO;
Decimal actualQty = Env.ZERO;
Decimal commCalcAmt = Env.ZERO;
Decimal TotalCommissionAmt = Env.ZERO;
for (int i = 0; i < details.Length; i++)
{
MCommissionDetail detail = details[i];
convertedAmt = Decimal.Add(convertedAmt, detail.GetConvertedAmt());
actualQty = Decimal.Add(actualQty, detail.GetActualQty());
MCommissionAmt camt = new MCommissionAmt(GetCtx(), detail.GetC_CommissionAmt_ID(), Get_TrxName());
MCommissionLine line = new MCommissionLine(GetCtx(), camt.GetC_CommissionLine_ID(), Get_TrxName());
SetConvertedAmt(convertedAmt);
SetActualQty(actualQty);
if (line.GetC_CommissionType() == "A")
{
if (line.IsPositiveOnly() && Env.Signum(detail.GetConvertedAmt()) < 0)
{
commCalcAmt = Env.ZERO;
}
if (detail.GetConvertedAmt() >= line.GetC_TargetAmount())
{
commCalcAmt = CalculateCommisionAmt(detail.GetConvertedAmt(), line.GetC_TargetPercentage());
}
else if (detail.GetConvertedAmt() < line.GetC_TargetAmount() && detail.GetConvertedAmt() >= line.GetC_ThresholdAmount())
{
commCalcAmt = CalculateCommisionAmt(detail.GetConvertedAmt(), line.GetC_ThresholdPercentage());
}
else
{
commCalcAmt = 0;
}
}
else if (line.GetC_CommissionType() == "Q")
{
if (line.IsPositiveOnly() && Env.Signum(detail.GetActualQty()) < 0)
{
actualQty = Env.ZERO;
}
if (detail.GetActualQty() >= line.GetC_TargetQuantity())
{
commCalcAmt = CalculateCommisionAmt(detail.GetConvertedAmt(), line.GetC_TargetPercentage());
}
else if (detail.GetActualQty() < line.GetC_TargetQuantity() && detail.GetActualQty() >= line.GetC_ThresholdQuantity())
{
commCalcAmt = CalculateCommisionAmt(detail.GetConvertedAmt(), line.GetC_ThresholdPercentage());
}
else
{
commCalcAmt = 0;
}
}
TotalCommissionAmt = TotalCommissionAmt + commCalcAmt;
}
SetCommissionAmt(TotalCommissionAmt);
}
}
