public static bool CreateCostElementDetail(Ctx ctx, int AD_Client_ID, int AD_Org_ID, MProduct Product, int M_ASI_ID,
MAcctSchema mas, int M_costElement_ID, string windowName, MCostDetail cd, decimal amt, decimal qty)
{
try
{
MCostElementDetail ced = new MCostElementDetail(ctx, 0, cd.Get_Trx());
ced.SetAD_Client_ID(AD_Client_ID);
ced.SetAD_Org_ID(AD_Org_ID);
ced.SetC_AcctSchema_ID(mas.GetC_AcctSchema_ID());
ced.SetM_CostElement_ID(M_costElement_ID);
ced.SetM_Product_ID(Product.GetM_Product_ID());
ced.SetM_AttributeSetInstance_ID(M_ASI_ID);
ced.SetQty(qty);
ced.SetAmt(amt);
//Refrences
ced.SetC_OrderLine_ID(cd.GetC_OrderLine_ID());
ced.SetM_InOutLine_ID(cd.GetM_InOutLine_ID());
if (windowName == "Material Receipt" || windowName == "Customer Return" || windowName == "Shipment" || windowName == "Return To Vendor")
{
// not to bind Invoiceline refernece on cost element detail
}
else
{
ced.SetC_InvoiceLine_ID(cd.GetC_InvoiceLine_ID());
}
ced.Set_Value("VAFAM_AssetDisposal_ID", cd.Get_Value("VAFAM_AssetDisposal_ID"));
ced.SetM_InventoryLine_ID(cd.GetM_InventoryLine_ID());
ced.SetM_MovementLine_ID(cd.GetM_MovementLine_ID());
ced.SetC_ProjectIssue_ID(cd.GetC_ProjectIssue_ID());
ced.SetIsSOTrx(cd.IsSOTrx());
ced.SetA_Asset_ID(cd.GetA_Asset_ID());
ced.SetM_ProductionLine_ID(cd.GetM_ProductionLine_ID());
ced.SetM_WorkOrderResourceTxnLine_ID(cd.GetM_WorkOrderResourceTxnLine_ID());
ced.SetM_WorkOrderTransactionLine_ID(cd.GetM_WorkOrderTransactionLine_ID());
if (Env.IsModuleInstalled("VAMFG_"))
{
if (ced.Get_ColumnIndex("VAMFG_M_WrkOdrRscTxnLine_ID") > -1)
{
ced.Set_Value("VAMFG_M_WrkOdrRscTxnLine_ID", cd.GetVAMFG_M_WrkOdrRscTxnLine_ID());
}
if (ced.Get_ColumnIndex("VAMFG_M_WrkOdrTrnsctionLine_ID") > -1)
{
ced.Set_Value("VAMFG_M_WrkOdrTrnsctionLine_ID", cd.GetVAMFG_M_WrkOdrTrnsctionLine_ID());
}
}
ced.SetM_Warehouse_ID(cd.GetM_Warehouse_ID());
if (!ced.Save())
{
ValueNamePair pp = VLogger.RetrieveError();
_log.Info("Error Occured during costing " + pp.ToString());
return(false);
}
}
catch (Exception ex)
{
_log.Info("Error Occured during costing " + ex.ToString());
return(false);
}
return(true);
}
/// <summary>
/// This function will create child record of Cost Queue, which will contain transaction affects
/// </summary>
/// <param name="ctx">context</param>
/// <param name="AD_Client_ID">Client ID</param>
/// <param name="AD_Org_ID">Organization ID</param>
/// <param name="M_CostQueue_ID">Cost Queue ID</param>
/// <param name="cd">Cost Detail Reference</param>
/// <param name="qty">qty</param>
/// <returns>true, when success</returns>
public static bool CreateCostQueueTransaction(Ctx ctx, int AD_Client_ID, int AD_Org_ID, int M_CostQueue_ID, MCostDetail cd, decimal qty)
{
try
{
MCostQueueTransaction ced = new MCostQueueTransaction(ctx, 0, cd.Get_Trx());
ced.SetAD_Client_ID(AD_Client_ID);
ced.SetAD_Org_ID(AD_Org_ID);
ced.SetM_CostQueue_ID(M_CostQueue_ID);
ced.SetM_Product_ID(cd.GetM_Product_ID());
ced.SetM_AttributeSetInstance_ID(cd.GetM_AttributeSetInstance_ID());
ced.SetM_Warehouse_ID(cd.GetM_Warehouse_ID());
// date and qty
ced.SetMovementQty(qty);
ced.SetMovementDate(DateTime.Now);
//Refrences
ced.SetM_InOutLine_ID(cd.GetM_InOutLine_ID());
if (ced.GetM_InOutLine_ID() > 0)
{
DataSet ds = DB.ExecuteDataset(@"SELECT M_InOut.IsSOTrx, M_InOut.IsReturnTrx FROM M_InOutLine
INNER JOIN M_InOut ON M_InOutLine.M_InOut_ID = M_InOut.M_InOut_ID
WHERE M_InOutLine.M_InOutLine_ID = " + ced.GetM_InOutLine_ID(), null, cd.Get_Trx());
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ced.SetIsSOTrx(Util.GetValueOfString(ds.Tables[0].Rows[0]["IsSOTrx"]).Equals("N") ? false : true);
ced.SetIsReturnTrx(Util.GetValueOfString(ds.Tables[0].Rows[0]["IsReturnTrx"]).Equals("N") ? false : true);
}
}
ced.SetM_InventoryLine_ID(cd.GetM_InventoryLine_ID());
if (ced.GetM_InventoryLine_ID() > 0)
{
bool isInternalUse = Util.GetValueOfString(DB.ExecuteScalar(@"SELECT M_Inventory.IsInternalUse FROM M_InventoryLine
INNER JOIN M_Inventory ON M_InventoryLine.M_Inventory_ID = M_Inventory.M_Inventory_ID
WHERE M_InventoryLine.M_InventoryLine_ID = " + ced.GetM_InventoryLine_ID(), null, cd.Get_Trx())).Equals("N") ? false : true;
ced.SetIsInternalUse(isInternalUse);
}
ced.SetM_MovementLine_ID(cd.GetM_MovementLine_ID());
ced.SetC_ProjectIssue_ID(cd.GetC_ProjectIssue_ID());
//ced.SetA_Asset_ID(cd.GetA_Asset_ID());
ced.SetM_ProductionLine_ID(cd.GetM_ProductionLine_ID());
if (Env.IsModuleInstalled("VAFAM_") && ced.Get_ColumnIndex("VAFAM_AssetDisposal_ID") > -1)
{
ced.Set_Value("VAFAM_AssetDisposal_ID", cd.Get_Value("VAFAM_AssetDisposal_ID"));
}
if (Env.IsModuleInstalled("VAMFG_"))
{
if (ced.Get_ColumnIndex("VAMFG_M_WrkOdrRscTxnLine_ID") > -1)
{
ced.Set_Value("VAMFG_M_WrkOdrRscTxnLine_ID", cd.GetVAMFG_M_WrkOdrRscTxnLine_ID());
}
if (ced.Get_ColumnIndex("VAMFG_M_WrkOdrTrnsctionLine_ID") > -1)
{
ced.Set_Value("VAMFG_M_WrkOdrTrnsctionLine_ID", cd.GetVAMFG_M_WrkOdrTrnsctionLine_ID());
}
}
if (!ced.Save())
{
ValueNamePair pp = VLogger.RetrieveError();
string error = "";
if (pp != null)
{
error = pp.GetValue();
if (String.IsNullOrEmpty(error))
{
error = pp.GetValue();
}
}
_log.Info("Costing Engine : Error Occured during saving a record on Cost Queue Transaction -> " + error);
return(false);
}
}
catch (Exception ex)
{
_log.Info("Costing Engine : Exception Occured during saving a record on Cost Queue Transaction " + ex.Message);
return(false);
}
return(true);
}