/// <summary>
/// get data from common model
/// </summary>
/// <param name="keyColumnName"></param>
/// <param name="tableName"></param>
/// <param name="recordID"></param>
/// <param name="pageNo"></param>
/// <param name="isBaseLangss"></param>
/// <param name="cInvoiceID"></param>
/// <param name="mProductIDs"></param>
/// <returns></returns>
public JsonResult GetInvoicesDataVCreate(string keyColumnName, string tableName, int recordID, int pageNo, string isBaseLangss, int cInvoiceID, string mProductIDs)
{
var ctx = Session["ctx"] as Ctx;
CommonModel obj = new CommonModel();
string sql = getSQlforGetInvoicesData(isBaseLangss, cInvoiceID, mProductIDs);
var stValue = obj.GetData(sql, keyColumnName, tableName, recordID, pageNo, ctx);
return(Json(JsonConvert.SerializeObject(stValue), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// get c_order_id or c_orderline_id
/// </summary>
/// <param name="keyColumnName"></param>
/// <param name="tableName"></param>
/// <param name="recordID"></param>
/// <param name="pageNo"></param>
/// <param name="forInvoicees"></param>
/// <param name="C_Ord_IDs"></param>
/// <param name="isBaseLangess"></param>
/// <param name="MProductIDss"></param>
/// <param name="DelivDates"></param>
/// <param name="adOrgIDSs"></param>
/// <returns></returns>
public JsonResult GetOrdersDataCommon(string keyColumnName, string tableName, int recordID, int pageNo, bool forInvoicees, int C_Ord_IDs, string isBaseLangess, string MProductIDss, string DelivDates, int adOrgIDSs)
{
var ctx = Session["ctx"] as Ctx;
CommonModel obj = new CommonModel();
string sql = VcreateFormSqlQry(forInvoicees, C_Ord_IDs, isBaseLangess, MProductIDss, DelivDates, adOrgIDSs);
var stValue = obj.GetData(sql, keyColumnName, tableName, recordID, pageNo, ctx);
return(Json(JsonConvert.SerializeObject(stValue), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// get c_order_id or c_orderline_id
/// </summary>
/// <param name="keyColumnName"></param>
/// <param name="tableName"></param>
/// <param name="recordID"></param>
/// <param name="pageNo"></param>
/// <param name="mInOutId"></param>
/// <param name="isBaseLanguages"></param>
/// <param name="mProductIDD"></param>
/// <returns></returns>
public JsonResult GetDataVCreateFrom(string keyColumnName, string tableName, int recordID, int pageNo, string mInOutId, string isBaseLanguages, string mProductIDD)
{
var ctx = Session["ctx"] as Ctx;
CommonModel obj = new CommonModel();
var sql = GetDataSqlQueries(mInOutId, isBaseLanguages, mProductIDD);
var stValue = obj.GetData(sql, keyColumnName, tableName, recordID, pageNo, ctx);
return(Json(JsonConvert.SerializeObject(stValue), JsonRequestBehavior.AllowGet));
}
