/// <summary>
/// Before Save
/// </summary>
/// <param name="newRecord">new</param>
/// <returns>true</returns>
protected override bool BeforeSave(bool newRecord)
{
if (GetLine() == 0)
{
SetLine();
}
// Planned Amount - Currency Precision
Decimal plannedAmt = Decimal.Multiply(GetPlannedQty(), GetPlannedPrice());
if (Env.Scale(plannedAmt) > GetCurPrecision())
{
//plannedAmt.setScale(GetCurPrecision(), Decimal.ROUND_HALF_UP);
Decimal.Round(plannedAmt, GetCurPrecision(), MidpointRounding.AwayFromZero);
}
SetPlannedAmt(plannedAmt);
// Planned Margin
if (Is_ValueChanged("M_Product_ID") || Is_ValueChanged("M_Product_Category_ID") ||
Is_ValueChanged("PlannedQty") || Is_ValueChanged("PlannedPrice"))
{
if (GetM_Product_ID() != 0)
{
Decimal marginEach = Decimal.Subtract(GetPlannedPrice(), GetLimitPrice());
SetPlannedMarginAmt(Decimal.Multiply(marginEach, GetPlannedQty()));
}
else if (GetM_Product_Category_ID() != 0)
{
MProductCategory category = MProductCategory.Get(GetCtx(), GetM_Product_Category_ID());
Decimal marginEach = category.GetPlannedMargin();
SetPlannedMarginAmt(Decimal.Multiply(marginEach, GetPlannedQty()));
}
}
// Phase/Task
if (Is_ValueChanged("C_ProjectTask_ID") && GetC_ProjectTask_ID() != 0)
{
MProjectTask pt = new MProjectTask(GetCtx(), GetC_ProjectTask_ID(), Get_TrxName());
if (pt == null || pt.Get_ID() == 0)
{
log.Warning("Project Task Not Found - ID=" + GetC_ProjectTask_ID());
return(false);
}
else
{
SetC_ProjectPhase_ID(pt.GetC_ProjectPhase_ID());
}
}
if (Is_ValueChanged("C_ProjectPhase_ID") && GetC_ProjectPhase_ID() != 0)
{
MProjectPhase pp = new MProjectPhase(GetCtx(), GetC_ProjectPhase_ID(), Get_TrxName());
if (pp == null || pp.Get_ID() == 0)
{
log.Warning("Project Phase Not Found - " + GetC_ProjectPhase_ID());
return(false);
}
else
{
SetC_Project_ID(pp.GetC_Project_ID());
}
}
return(true);
}
/// <summary>
/// Before Save
/// </summary>
/// <param name="newRecord">new</param>
/// <returns>true</returns>
protected override bool BeforeSave(bool newRecord)
{
if (GetLine() == 0)
{
SetLine();
}
// Work done for Purchase Price and Mergin calculation
if (Env.IsModuleInstalled("VA077_") && Get_ColumnIndex("VA077_PurchasePrice") >= 0 && Util.GetValueOfDecimal(Get_Value("VA077_PurchasePrice")).Equals(0))
{
if (GetProject() != null && _parent.IsOpportunity() && Util.GetValueOfInt(_parent.Get_Value("PO_PriceList_ID")) > 0)
{
Set_Value("VA077_PurchasePrice", GetPurchasePrice());
// Calculate Purchase Amount
Decimal purchaseAmt = Decimal.Multiply(GetPlannedQty(), Util.GetValueOfDecimal(Get_Value("VA077_PurchasePrice")));
if (Env.Scale(purchaseAmt) > GetCurPrecision())
{
purchaseAmt = Decimal.Round(purchaseAmt, GetCurPrecision(), MidpointRounding.AwayFromZero);
}
Set_Value("VA077_PurchaseAmt", purchaseAmt);
}
// Calculate Margin Amount
Decimal marginEach = Decimal.Subtract(GetPlannedPrice(), Util.GetValueOfDecimal(Get_Value("VA077_PurchasePrice")));
Set_Value("VA077_MarginAmt", Decimal.Multiply(marginEach, GetPlannedQty()));
// Calculate Margin Percentage
Decimal marginPer = 0;
if (GetPlannedPrice() > 0)
{
marginPer = Decimal.Round(Decimal.Multiply(Decimal.Divide(marginEach, GetPlannedPrice())
, Env.ONEHUNDRED), GetCurPrecision(), MidpointRounding.AwayFromZero);
}
Set_Value("VA077_MarginPercent", marginPer);
}
// Planned Amount - Currency Precision
Decimal plannedAmt = Decimal.Multiply(GetPlannedQty(), GetPlannedPrice());
if (Env.Scale(plannedAmt) > GetCurPrecision())
{
//plannedAmt.setScale(GetCurPrecision(), Decimal.ROUND_HALF_UP);
Decimal.Round(plannedAmt, GetCurPrecision(), MidpointRounding.AwayFromZero);
}
SetPlannedAmt(plannedAmt);
// Planned Margin
if (Is_ValueChanged("M_Product_ID") || Is_ValueChanged("M_Product_Category_ID") ||
Is_ValueChanged("PlannedQty") || Is_ValueChanged("PlannedPrice"))
{
if (GetM_Product_ID() != 0)
{
Decimal marginEach = Decimal.Subtract(GetPlannedPrice(), GetLimitPrice());
SetPlannedMarginAmt(Decimal.Multiply(marginEach, GetPlannedQty()));
}
else if (GetM_Product_Category_ID() != 0)
{
MProductCategory category = MProductCategory.Get(GetCtx(), GetM_Product_Category_ID());
Decimal marginEach = category.GetPlannedMargin();
SetPlannedMarginAmt(Decimal.Multiply(marginEach, GetPlannedQty()));
}
}
// Phase/Task
if (Is_ValueChanged("C_ProjectTask_ID") && GetC_ProjectTask_ID() != 0)
{
MProjectTask pt = new MProjectTask(GetCtx(), GetC_ProjectTask_ID(), Get_TrxName());
if (pt == null || pt.Get_ID() == 0)
{
log.Warning("Project Task Not Found - ID=" + GetC_ProjectTask_ID());
return(false);
}
else
{
SetC_ProjectPhase_ID(pt.GetC_ProjectPhase_ID());
}
}
if (Is_ValueChanged("C_ProjectPhase_ID") && GetC_ProjectPhase_ID() != 0)
{
MProjectPhase pp = new MProjectPhase(GetCtx(), GetC_ProjectPhase_ID(), Get_TrxName());
if (pp == null || pp.Get_ID() == 0)
{
log.Warning("Project Phase Not Found - " + GetC_ProjectPhase_ID());
return(false);
}
else
{
SetC_Project_ID(pp.GetC_Project_ID());
}
}
return(true);
}
/// <summary>
/// To copy the task lines from project template Standard Task lines tab
/// </summary>
/// <param name="Task_ID">ID of tasks</param>
/// <param name="C_ProjectTask_ID">Project task ID</param>
/// <returns>No of lines created</returns>
public int CopyMTaskLinesFromProjectTask(MProjectTask fromTask, MProjectTask toTask, int To_Project_ID)
{
ValueNamePair pp = null;
int tasklinecount = 0;
StringBuilder msg = new StringBuilder();
try
{
MProjectLine[] fromLines = null;
List <MProjectLine> list = new List <MProjectLine>();
DataSet projDs = DB.ExecuteDataset(" SELECT C_ProjectLine_ID FROM C_ProjectLine WHERE " +
" C_ProjectPhase_ID =" + fromTask.GetC_ProjectPhase_ID() + " AND C_ProjectTask_ID =" + fromTask.GetC_ProjectTask_ID() +
" AND IsActive='Y' ORDER BY Line ");
if (projDs != null && projDs.Tables[0].Rows.Count > 0)
{
for (int k = 0; k < projDs.Tables[0].Rows.Count; k++)
{
list.Add(new MProjectLine(GetCtx(), Util.GetValueOfInt(projDs.Tables[0].Rows[k]["C_ProjectLine_ID"]), Get_TrxName()));
}
fromLines = new MProjectLine[list.Count];
fromLines = list.ToArray();
}
if (fromLines != null && fromLines.Length > 0)
{
for (int j = 0; j < fromLines.Length; j++)
{
MProjectLine line = new MProjectLine(GetCtx(), 0, Get_TrxName());
PO.CopyValues(fromLines[j], line, GetAD_Client_ID(), GetAD_Org_ID());
line.SetC_Project_ID(To_Project_ID);
line.SetC_ProjectTask_ID(toTask.GetC_ProjectTask_ID());
line.SetC_ProjectPhase_ID(toTask.GetC_ProjectPhase_ID());
line.SetInvoicedAmt(Env.ZERO);
line.SetInvoicedQty(Env.ZERO);
line.SetC_OrderPO_ID(0);
line.SetC_Order_ID(0);
line.SetProcessed(false);
if (line.Save())
{
tasklinecount++;
}
else
{
pp = VLogger.RetrieveError();
if (pp != null)
{
msg.Append(pp.GetName());
//if GetName is Empty then it will check GetValue
if (string.IsNullOrEmpty(msg.ToString()))
{
msg.Append(Msg.GetMsg("", pp.GetValue()));
}
}
if (string.IsNullOrEmpty(msg.ToString()))
{
msg.Append(Msg.GetMsg(GetCtx(), "VIS_LineNotSaved"));
}
else
{
msg.Append(Msg.GetMsg(GetCtx(), "VIS_LineNotSaved") + "," + msg.ToString());
}
}
}
}
}
catch (Exception ex)
{
log.Log(Level.SEVERE, "", ex);
}
//
return(tasklinecount);
}
