public ActionResult GetTextButtonQueryResult(string sql)
{
Ctx ctx = Session["ctx"] as Ctx;
SqlParamsIn sqlP = new SqlParamsIn();
sql = SecureEngineBridge.DecryptByClientKey(sql, ctx.GetSecureKey());
sqlP.sql = sql;
VIS.Helpers.SqlHelper help = new Helpers.SqlHelper();
return(Json(JsonConvert.SerializeObject(help.ExecuteJDataSet(sqlP)), JsonRequestBehavior.AllowGet));
}
public ActionResult GetPrintFormatDetails(int AD_Table_ID)
{
Ctx ctx = Session["ctx"] as Ctx;
FormModel model = new FormModel(ctx);
string sql = MRole.GetDefault(ctx).AddAccessSQL(
"SELECT AD_PrintFormat_ID, Name, Description,IsDefault "
+ "FROM AD_PrintFormat "
+ "WHERE AD_Table_ID= " + AD_Table_ID
+ " ORDER BY Name",
"AD_PrintFormat", MRole.SQL_NOTQUALIFIED, MRole.SQL_RO);
SqlParamsIn sqlP = new SqlParamsIn();
sqlP.sql = sql;
VIS.Helpers.SqlHelper help = new Helpers.SqlHelper();
List <JTable> result = help.ExecuteJDataSet(sqlP);
return(Json(JsonConvert.SerializeObject(result), JsonRequestBehavior.AllowGet));
}