// Added by Bharat on 30 Jan 2018 to Get Inco Term
public int GetIncoTerm(Ctx ctx, string fields)
{
string[] paramValue = fields.Split(',');
bool isSOTrx = false;
int incoTerm_ID = 0, referenceID = 0;
string tableName = "", refColumn = "", qry = "";
isSOTrx = Util.GetValueOfBool(paramValue[0]);
tableName = Util.GetValueOfString(paramValue[1]);
refColumn = Util.GetValueOfString(paramValue[2]);
referenceID = Util.GetValueOfInt(paramValue[3]);
if (tableName == "C_Order")
{
if (referenceID > 0)
{
MOrder ord = new MOrder(ctx, referenceID, null);
incoTerm_ID = ord.GetC_IncoTerm_ID();
}
}
else if (tableName == "C_Invoice")
{
if (isSOTrx && referenceID > 0)
{
MOrder ord = new MOrder(ctx, referenceID, null);
incoTerm_ID = ord.GetC_IncoTerm_ID();
}
else if (!isSOTrx && referenceID > 0 && refColumn == "C_Order_ID")
{
MOrder ord = new MOrder(ctx, referenceID, null);
incoTerm_ID = ord.GetC_IncoTerm_ID();
}
else if (!isSOTrx && referenceID > 0 && refColumn == "M_InOut_ID")
{
MInOut inOut = new MInOut(ctx, referenceID, null);
incoTerm_ID = inOut.GetC_IncoTerm_ID();
}
}
else if (tableName == "M_InOut")
{
if (isSOTrx && referenceID > 0)
{
MOrder ord = new MOrder(ctx, referenceID, null);
incoTerm_ID = ord.GetC_IncoTerm_ID();
}
else if (!isSOTrx && referenceID > 0 && refColumn == "C_Order_ID")
{
MOrder ord = new MOrder(ctx, referenceID, null);
incoTerm_ID = ord.GetC_IncoTerm_ID();
}
else if (!isSOTrx && referenceID > 0 && refColumn == "C_Invoice_ID")
{
MInvoice inv = new MInvoice(ctx, referenceID, null);
incoTerm_ID = inv.GetC_IncoTerm_ID();
}
}
return(incoTerm_ID);
}