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