/// <summary>
/// GetOrderLine
/// </summary>
/// <param name="ctx"></param>
/// <param name="param"></param>
/// <returns></returns>
public Dictionary <String, String> GetOrderLine(Ctx ctx, string param)
{
string[] paramValue = param.Split(',');
Dictionary <String, String> retDic = new Dictionary <string, string>();
//Assign parameter value
int id;
id = Util.GetValueOfInt(paramValue[0].ToString());
//End Assign parameter value
MOrderLine orderline = new MOrderLine(ctx, id, null);
retDic["C_Tax_ID"] = Util.GetValueOfString(orderline.GetC_Tax_ID());
retDic["PriceList"] = Util.GetValueOfString(orderline.GetPriceList());
retDic["PriceLimit"] = Util.GetValueOfString(orderline.GetPriceLimit());
retDic["PriceActual"] = Util.GetValueOfString(orderline.GetPriceActual());
retDic["PriceEntered"] = Util.GetValueOfString(orderline.GetPriceEntered());
retDic["C_Currency_ID"] = Util.GetValueOfString(orderline.GetC_Currency_ID());
retDic["Discount"] = Util.GetValueOfString(orderline.GetDiscount());
retDic["Discount"] = Util.GetValueOfString(orderline.GetDiscount());
retDic["M_Product_ID"] = Util.GetValueOfString(orderline.GetM_Product_ID());
retDic["Qty"] = Util.GetValueOfString(orderline.GetQtyEntered());
retDic["C_UOM_ID"] = Util.GetValueOfString(orderline.GetC_UOM_ID());
retDic["C_BPartner_ID"] = Util.GetValueOfString(orderline.GetC_BPartner_ID());
retDic["PlannedHours"] = Util.GetValueOfString(orderline.GetQtyOrdered());
retDic["M_AttributeSetInstance_ID"] = Util.GetValueOfString(orderline.GetM_AttributeSetInstance_ID());
retDic["QtyOrdered"] = Util.GetValueOfString(orderline.GetQtyOrdered());
retDic["QtyDelivered"] = Util.GetValueOfString(orderline.GetQtyDelivered());
retDic["QtyEntered"] = Util.GetValueOfString(orderline.GetQtyEntered());
retDic["C_Activity_ID"] = Util.GetValueOfString(orderline.GetC_Activity_ID());
retDic["C_Campaign_ID"] = Util.GetValueOfString(orderline.GetC_Campaign_ID());
retDic["C_Project_ID"] = Util.GetValueOfString(orderline.GetC_Project_ID());
retDic["C_ProjectPhase_ID"] = Util.GetValueOfString(orderline.GetC_ProjectPhase_ID());
retDic["C_ProjectTask_ID"] = Util.GetValueOfString(orderline.GetC_ProjectTask_ID());
retDic["AD_OrgTrx_ID"] = Util.GetValueOfString(orderline.GetAD_OrgTrx_ID());
retDic["User1_ID"] = Util.GetValueOfString(orderline.GetUser1_ID());
retDic["User2_ID"] = Util.GetValueOfString(orderline.GetUser2_ID());
retDic["IsReturnTrx"] = Util.GetValueOfString(orderline.GetParent().IsReturnTrx()).ToLower();
retDic["Orig_InOutLine_ID"] = Util.GetValueOfString(orderline.GetOrig_InOutLine_ID());
retDic["Orig_OrderLine_ID"] = Util.GetValueOfString(orderline.GetOrig_OrderLine_ID());
retDic["GetID"] = Util.GetValueOfString(orderline.Get_ID());
return(retDic);
}
public JsonResult GetOrderLine(string param)
{
string retError = "";
string retJSON = "";
if (Session["ctx"] != null)
{
VAdvantage.Utility.Ctx ctx = Session["ctx"] as Ctx;
string[] paramValue = param.Split(',');
Dictionary <String, String> retDic = new Dictionary <string, string>();
//Assign parameter value
int id;
id = Util.GetValueOfInt(paramValue[0].ToString());
MOrderLine orderline = new MOrderLine(ctx, id, null);
//retDic["Orig_InOutLine_ID", null);
retDic["C_Tax_ID"] = orderline.GetC_Tax_ID().ToString();
retDic["PriceList"] = orderline.GetPriceList().ToString();
retDic["PriceLimit"] = orderline.GetPriceLimit().ToString();
retDic["PriceActual"] = orderline.GetPriceActual().ToString();
retDic["PriceEntered"] = orderline.GetPriceEntered().ToString();
retDic["C_Currency_ID"] = orderline.GetC_Currency_ID().ToString();
retDic["Discount"] = orderline.GetDiscount().ToString();
retDic["Discount"] = orderline.GetDiscount().ToString();
//retlst.Add(retValue);
//retVal.Add(notReserved);
retJSON = JsonConvert.SerializeObject(retDic);
}
else
{
retError = "Session Expired";
}
return(Json(new { result = retJSON, error = retError }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Get Tax Line for Order Line
/// </summary>
/// <param name="line">line</param>
/// <param name="precision">currenct precision</param>
/// <param name="oldTax">get old tax</param>
/// <param name="trxName">transaction</param>
/// <returns>existing or new tax</returns>
public static MOrderTax Get(MOrderLine line, int precision, bool oldTax, Trx trxName)
{
MOrderTax retValue = null;
if (line == null || line.GetC_Order_ID() == 0)
{
//s_log.fine("No Order");
return(null);
}
int C_Tax_ID = line.GetC_Tax_ID();
if (oldTax && line.Is_ValueChanged("C_Tax_ID"))
{
Object old = line.Get_ValueOld("C_Tax_ID");
if (old == null)
{
//s_log.fine("No Old Tax");
return(null);
}
C_Tax_ID = int.Parse(old.ToString());
}
if (C_Tax_ID == 0)
{
s_log.Fine("No Tax");
return(null);
}
String sql = "SELECT * FROM C_OrderTax WHERE C_Order_ID=" + line.GetC_Order_ID() + " AND C_Tax_ID=" + C_Tax_ID;
DataSet ds = null;
try
{
ds = DataBase.DB.ExecuteDataset(sql, null, trxName);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
retValue = new MOrderTax(line.GetCtx(), dr, trxName);
}
ds = null;
}
catch (Exception e)
{
s_log.Log(Level.SEVERE, sql, e);
}
if (retValue != null)
{
retValue.SetPrecision(precision);
retValue.Set_TrxName(trxName);
s_log.Fine("(old=" + oldTax + ") " + retValue);
return(retValue);
}
// Create New
retValue = new MOrderTax(line.GetCtx(), 0, trxName);
retValue.Set_TrxName(trxName);
retValue.SetClientOrg(line);
retValue.SetC_Order_ID(line.GetC_Order_ID());
retValue.SetC_Tax_ID(line.GetC_Tax_ID());
retValue.SetPrecision(precision);
retValue.SetIsTaxIncluded(line.IsTaxIncluded());
s_log.Fine("(new) " + retValue);
return(retValue);
}
/// <summary>
/// Get Tax Line for Order Line
/// </summary>
/// <param name="line">line</param>
/// <param name="precision">currenct precision</param>
/// <param name="oldTax">get old tax</param>
/// <param name="trxName">transaction</param>
/// <returns>existing or new tax</returns>
public static MOrderTax Get(MOrderLine line, int precision, bool oldTax, Trx trxName)
{
MOrderTax retValue = null;
if (line == null || line.GetC_Order_ID() == 0)
{
//s_log.fine("No Order");
return(null);
}
int C_Tax_ID = line.GetC_Tax_ID();
if (oldTax && line.Is_ValueChanged("C_Tax_ID"))
{
Object old = line.Get_ValueOld("C_Tax_ID");
if (old == null)
{
//s_log.fine("No Old Tax");
return(null);
}
C_Tax_ID = int.Parse(old.ToString());
}
if (C_Tax_ID == 0)
{
s_log.Fine("No Tax");
return(null);
}
String sql = "SELECT * FROM C_OrderTax WHERE C_Order_ID=" + line.GetC_Order_ID() + " AND C_Tax_ID=" + C_Tax_ID;
DataSet ds = null;
try
{
ds = DataBase.DB.ExecuteDataset(sql, null, trxName);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
retValue = new MOrderTax(line.GetCtx(), dr, trxName);
}
ds = null;
}
catch (Exception e)
{
s_log.Log(Level.SEVERE, sql, e);
}
// JID_1303: On Order tax calculate tax according to selected pricelist. If user delete lines and change pricelist, it should check IsTaxIncluded on selected Pricelist.
bool isTaxIncluded = Util.GetValueOfString(DB.ExecuteScalar("SELECT IsTaxIncluded FROM M_PriceList WHERE M_PriceList_ID = (SELECT M_PriceList_ID FROM C_Order WHERE C_Order_ID = "
+ line.GetC_Order_ID() + ")", null, trxName)) == "Y";
if (retValue != null)
{
retValue.SetPrecision(precision);
retValue.Set_TrxName(trxName);
retValue.SetIsTaxIncluded(isTaxIncluded);
s_log.Fine("(old=" + oldTax + ") " + retValue);
return(retValue);
}
// Create New
retValue = new MOrderTax(line.GetCtx(), 0, trxName);
retValue.Set_TrxName(trxName);
retValue.SetClientOrg(line);
retValue.SetC_Order_ID(line.GetC_Order_ID());
retValue.SetC_Tax_ID(line.GetC_Tax_ID());
retValue.SetPrecision(precision);
retValue.SetIsTaxIncluded(line.IsTaxIncluded());
s_log.Fine("(new) " + retValue);
return(retValue);
}
/// <summary>
/// Get Surcharge Tax Line for Order Line
/// </summary>
/// <param name="line">line</param>
/// <param name="precision">currenct precision</param>
/// <param name="oldTax">get old tax</param>
/// <param name="trxName">transaction</param>
/// <returns>existing or new tax</returns>
public static MOrderTax GetSurcharge(MOrderLine line, int precision, bool oldTax, Trx trxName)
{
MOrderTax retValue = null;
if (line == null || line.GetC_Order_ID() == 0)
{
//s_log.fine("No Order");
return(null);
}
int C_Tax_ID = line.GetC_Tax_ID();
if (oldTax && line.Is_ValueChanged("C_Tax_ID"))
{
Object old = line.Get_ValueOld("C_Tax_ID");
if (old == null)
{
//s_log.fine("No Old Tax");
return(null);
}
C_Tax_ID = int.Parse(old.ToString());
}
// Get Surcharge Tax ID from Tax selected on Line
C_Tax_ID = Util.GetValueOfInt(DB.ExecuteScalar("SELECT Surcharge_Tax_ID FROM C_Tax WHERE C_Tax_ID = " + C_Tax_ID, null, trxName));
if (C_Tax_ID == 0)
{
s_log.Fine("No Tax");
return(null);
}
String sql = "SELECT * FROM C_OrderTax WHERE C_Order_ID=" + line.GetC_Order_ID() + " AND C_Tax_ID=" + C_Tax_ID;
DataSet ds = null;
try
{
ds = DataBase.DB.ExecuteDataset(sql, null, trxName);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
retValue = new MOrderTax(line.GetCtx(), dr, trxName);
}
ds = null;
}
}
catch (Exception e)
{
s_log.Log(Level.SEVERE, sql, e);
}
// Get IsTaxincluded from selected PriceList on header
bool isTaxIncluded = Util.GetValueOfString(DB.ExecuteScalar("SELECT IsTaxIncluded FROM M_PriceList WHERE M_PriceList_ID = (SELECT M_PriceList_ID FROM C_Order WHERE C_Order_ID = "
+ line.GetC_Order_ID() + ")", null, trxName)) == "Y";
if (retValue != null)
{
retValue.SetPrecision(precision);
retValue.SetIsTaxIncluded(isTaxIncluded);
retValue.Set_TrxName(trxName);
s_log.Fine("(old=" + oldTax + ") " + retValue);
return(retValue);
}
// Create New
retValue = new MOrderTax(line.GetCtx(), 0, trxName);
retValue.Set_TrxName(trxName);
retValue.SetClientOrg(line);
retValue.SetC_Order_ID(line.GetC_Order_ID());
retValue.SetC_Tax_ID(C_Tax_ID);
retValue.SetPrecision(precision);
retValue.SetIsTaxIncluded(isTaxIncluded);
s_log.Fine("(new) " + retValue);
return(retValue);
}
