// 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); }