public ActionResult view() { try { dynamic keys = XVar.Array(), pageMode = null, pageObject = null, var_params = XVar.Array(); XTempl xt; dbo_acceso_uggroups_Variables.Apply(); CommonFunctions.add_nocache_headers(); if (XVar.Pack(!(XVar)(ViewPage.processEditPageSecurity((XVar)(GlobalVars.strTableName))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } { TLayout t_layout = null; t_layout = new TLayout(new XVar("view_bootstrap_2col"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "dbo_acceso_uggroups_view"; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["viewpage"] = XVar.Array(); t_layout.containers["viewpage"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "header")); t_layout.containers["header"] = XVar.Array(); t_layout.containers["header"].Add(new XVar("name", "viewheader", "block", "viewheader", "substyle", 1)); t_layout.skins["header"] = ""; t_layout.skins["viewpage"] = ""; t_layout.blocks["top"].Add("viewpage"); t_layout.containers["fields"] = XVar.Array(); t_layout.containers["fields"].Add(new XVar("name", "viewfields", "block", "", "substyle", 1)); t_layout.skins["fields"] = ""; t_layout.blocks["top"].Add("fields"); t_layout.containers["bottombuttons"] = XVar.Array(); t_layout.containers["bottombuttons"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "buttons")); t_layout.containers["buttons"] = XVar.Array(); t_layout.containers["buttons"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "leftbuttons")); t_layout.containers["leftbuttons"] = XVar.Array(); t_layout.containers["leftbuttons"].Add(new XVar("name", "viewbuttons", "block", "viewbuttons", "substyle", 1)); t_layout.skins["leftbuttons"] = ""; t_layout.containers["buttons"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "leftbuttons_1")); t_layout.containers["leftbuttons_1"] = XVar.Array(); t_layout.containers["leftbuttons_1"].Add(new XVar("name", "rightviewbuttons", "block", "rightviewbuttons", "substyle", 1)); t_layout.skins["leftbuttons_1"] = ""; t_layout.skins["buttons"] = ""; t_layout.skins["bottombuttons"] = ""; t_layout.blocks["top"].Add("bottombuttons"); GlobalVars.page_layouts["dbo_acceso_uggroups_view"] = t_layout; } pageMode = XVar.Clone(ViewPage.readViewModeFromRequest()); xt = XVar.UnPackXTempl(new XTempl()); keys = XVar.Clone(XVar.Array()); keys.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("editid1")), "GroupID"); var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(CommonFunctions.postvalue_number(new XVar("id")), "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(keys, "keys"); var_params.InitAndSetArrayItem(pageMode, "mode"); var_params.InitAndSetArrayItem(Constants.PAGE_VIEW, "pageType"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("page")), "pageName"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem(!XVar.Equals(XVar.Pack(MVCFunctions.postvalue(new XVar("mvcPDF"))), XVar.Pack("")), "pdfMode"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("mastertable")), "masterTable"); if (pageMode == Constants.VIEW_DASHBOARD) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("table")), "dashTName"); if (XVar.Pack(MVCFunctions.postvalue(new XVar("mapRefresh")))) { var_params.InitAndSetArrayItem(true, "mapRefresh"); var_params.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("vpCoordinates")))), "vpCoordinates"); } } if (pageMode == Constants.VIEW_POPUP) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashTName")), "dashTName"); } if (XVar.Pack(var_params["masterTable"])) { var_params.InitAndSetArrayItem(ViewPage.processMasterKeys(), "masterKeysReq"); } GlobalVars.pageObject = XVar.Clone(new ViewPage((XVar)(var_params))); GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public XVar lookupsuggest() { try { dynamic LookupSQL = null, LookupSQLTable = null, LookupType = null, contextParams = XVar.Array(), data = XVar.Array(), displayFieldIndex = null, displayFieldName = null, displayedValue = null, field = null, isExistParent = null, likeConditionField = null, likeField = null, likeWheres = XVar.Array(), linkAndDisplaySame = null, linkFieldIndex = null, linkFieldName = null, lookupCipherer = null, lookupConnection = null, lookupField = null, lookupIndices = XVar.Array(), lookupOrderBy = null, lookupPSet = null, lookupQueryObj = null, lookupTable = null, lwDisplayField = null, masterTable = null, multiselect = null, pageType = null, parentCtrlsData = XVar.Array(), qResult = null, respObj = null, searchByLinkField = null, strLookupWhere = null, strUniqueOrderBy = null, table = null, value = null, values = XVar.Array(), var_response = XVar.Array(), viewContainer = null; MVCFunctions.Header("Expires", "Thu, 01 Jan 1970 00:00:01 GMT"); table = XVar.Clone(MVCFunctions.postvalue(new XVar("table"))); if (XVar.Pack(!(XVar)(CommonFunctions.checkTableName((XVar)(table))))) { MVCFunctions.Echo(new XVar(0)); return(MVCFunctions.GetBuferContentAndClearBufer()); } Assembly.GetExecutingAssembly().GetType(MVCFunctions.Concat("runnerDotNet.", MVCFunctions.Concat("", table, ""), "_Variables")).InvokeMember("Apply", BindingFlags.InvokeMethod, null, null, null); pageType = XVar.Clone(MVCFunctions.postvalue(new XVar("pageType"))); GlobalVars.strTableName = XVar.Clone(CommonFunctions.GetTableByShort((XVar)(table))); GlobalVars.cipherer = XVar.Clone(new RunnerCipherer((XVar)(GlobalVars.strTableName))); GlobalVars.gSettings = XVar.Clone(new ProjectSettings((XVar)(GlobalVars.strTableName), (XVar)(pageType), (XVar)(MVCFunctions.postvalue(new XVar("page"))))); field = XVar.Clone(MVCFunctions.postvalue(new XVar("searchField"))); if (GlobalVars.gSettings.getEntityType() == Constants.titDASHBOARD) { dynamic dashFields = XVar.Array(); dashFields = XVar.Clone(GlobalVars.gSettings.getDashboardSearchFields()); table = XVar.Clone(MVCFunctions.GoodFieldName((XVar)(dashFields[field][0]["table"]))); GlobalVars.strTableName = XVar.Clone(CommonFunctions.GetTableByShort((XVar)(table))); field = XVar.Clone(MVCFunctions.GoodFieldName((XVar)(dashFields[field][0]["field"]))); if (XVar.Pack(!(XVar)(CommonFunctions.checkTableName((XVar)(table))))) { MVCFunctions.Echo(new XVar(0)); return(MVCFunctions.GetBuferContentAndClearBufer()); } Assembly.GetExecutingAssembly().GetType(MVCFunctions.Concat("runnerDotNet.", MVCFunctions.Concat("", table, ""), "_Variables")).InvokeMember("Apply", BindingFlags.InvokeMethod, null, null, null); GlobalVars.cipherer = XVar.Clone(new RunnerCipherer((XVar)(GlobalVars.strTableName))); GlobalVars.gSettings = XVar.Clone(new ProjectSettings((XVar)(GlobalVars.strTableName), (XVar)(pageType))); } masterTable = XVar.Clone(MVCFunctions.postvalue(new XVar("masterTable"))); if ((XVar)(masterTable != XVar.Pack("")) && (XVar)(XSession.Session.KeyExists(MVCFunctions.Concat(masterTable, "_masterRecordData")))) { contextParams.InitAndSetArrayItem(XSession.Session[MVCFunctions.Concat(masterTable, "_masterRecordData")], "masterData"); } contextParams.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("data")))), "data"); RunnerContext.push((XVar)(new RunnerContextItem((XVar)(pageType), (XVar)(contextParams)))); if (GlobalVars.strTableName != "dbo.EMPLEADO") { if (XVar.Pack(!(XVar)(CommonFunctions.isLogged()))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } if ((XVar)((XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Edit")))) && (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Add"))))) && (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search"))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } } else { dynamic checkResult = null, registerFields = null; checkResult = new XVar(true); registerFields = XVar.Clone((XVar.Pack(pageType == "register") ? XVar.Pack(GlobalVars.gSettings.getPageFields()) : XVar.Pack(XVar.Array()))); if (!XVar.Equals(XVar.Pack(MVCFunctions.array_search((XVar)(field), (XVar)(registerFields))), XVar.Pack(false))) { checkResult = new XVar(false); } if (XVar.Pack(checkResult)) { if (XVar.Pack(!(XVar)(CommonFunctions.isLogged()))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } if ((XVar)((XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Edit")))) && (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Add"))))) && (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search"))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } } } isExistParent = XVar.Clone(MVCFunctions.postvalue(new XVar("isExistParent"))); searchByLinkField = XVar.Clone(MVCFunctions.postvalue(new XVar("searchByLinkField"))); parentCtrlsData = XVar.Clone(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("parentCtrlsData"))))); value = XVar.Clone(MVCFunctions.postvalue(new XVar("searchFor"))); values = XVar.Clone((XVar.Pack(MVCFunctions.postvalue(new XVar("multiselection"))) ? XVar.Pack(CommonFunctions.splitvalues((XVar)(value))) : XVar.Pack(new XVar(0, value)))); lookupField = new XVar(""); foreach (KeyValuePair <XVar, dynamic> f in GlobalVars.gSettings.getFieldsList().GetEnumerator()) { if ((XVar)(MVCFunctions.GoodFieldName((XVar)(f.Value)) == field) && (XVar)(GlobalVars.gSettings.getEditFormat((XVar)(f.Value)) == Constants.EDIT_FORMAT_LOOKUP_WIZARD)) { LookupType = XVar.Clone(GlobalVars.gSettings.getLookupType((XVar)(f.Value))); if ((XVar)(LookupType == Constants.LT_LOOKUPTABLE) || (XVar)(LookupType == Constants.LT_QUERY)) { lookupField = XVar.Clone(f.Value); break; } } } if (XVar.Pack(!(XVar)(lookupField))) { respObj = XVar.Clone(new XVar("success", false, "data", XVar.Array())); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(respObj))); MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } lookupTable = XVar.Clone(GlobalVars.gSettings.getLookupTable((XVar)(lookupField))); linkFieldName = XVar.Clone(GlobalVars.gSettings.getLinkField((XVar)(lookupField))); displayFieldName = XVar.Clone(GlobalVars.gSettings.getDisplayField((XVar)(lookupField))); linkAndDisplaySame = XVar.Clone(displayFieldName == linkFieldName); if (LookupType == Constants.LT_QUERY) { lookupConnection = XVar.Clone(GlobalVars.cman.byTable((XVar)(lookupTable))); } else { dynamic connId = null; connId = XVar.Clone(GlobalVars.gSettings.getNotProjectLookupTableConnId((XVar)(lookupField))); lookupConnection = XVar.Clone((XVar.Pack(MVCFunctions.strlen((XVar)(connId))) ? XVar.Pack(GlobalVars.cman.byId((XVar)(connId))) : XVar.Pack(GlobalVars.cman.getDefault()))); } lookupOrderBy = XVar.Clone(GlobalVars.gSettings.getLookupOrderBy((XVar)(lookupField))); if (lookupConnection.dbType == Constants.nDATABASE_MSSQLServer) { strUniqueOrderBy = XVar.Clone(lookupOrderBy); } if (LookupType == Constants.LT_QUERY) { lookupPSet = XVar.Clone(new ProjectSettings((XVar)(lookupTable), (XVar)(pageType))); lookupCipherer = XVar.Clone(new RunnerCipherer((XVar)(lookupTable))); lookupQueryObj = XVar.Clone(lookupPSet.getSQLQuery()); if (XVar.Pack(GlobalVars.gSettings.getCustomDisplay((XVar)(lookupField)))) { lookupQueryObj.AddCustomExpression((XVar)(displayFieldName), (XVar)(lookupPSet), (XVar)(GlobalVars.strTableName), (XVar)(lookupField)); } lookupQueryObj.ReplaceFieldsWithDummies((XVar)(lookupPSet.getBinaryFieldsIndices())); } else { dynamic lwLinkField = null; LookupSQLTable = new XVar("SELECT "); lwLinkField = XVar.Clone(lookupConnection.addFieldWrappers((XVar)(GlobalVars.gSettings.getLinkField((XVar)(lookupField))))); if (XVar.Pack(GlobalVars.gSettings.isLookupUnique((XVar)(lookupField)))) { LookupSQLTable = MVCFunctions.Concat(LookupSQLTable, "DISTINCT "); } LookupSQLTable = MVCFunctions.Concat(LookupSQLTable, GlobalVars.cipherer.GetLookupFieldName((XVar)(lwLinkField), (XVar)(lookupField), new XVar(null), new XVar(true))); if (lookupConnection.dbType == Constants.nDATABASE_MSSQLServer) { if ((XVar)(strUniqueOrderBy) && (XVar)(GlobalVars.gSettings.isLookupUnique((XVar)(lookupField)))) { LookupSQLTable = MVCFunctions.Concat(LookupSQLTable, ",", lookupConnection.addFieldWrappers((XVar)(strUniqueOrderBy))); } } lwDisplayField = XVar.Clone(RunnerPage.sqlFormattedDisplayField((XVar)(lookupField), (XVar)(lookupConnection), (XVar)(GlobalVars.gSettings))); if (XVar.Pack(!(XVar)(linkAndDisplaySame))) { LookupSQLTable = MVCFunctions.Concat(LookupSQLTable, ",", (XVar.Pack(lwDisplayField == lwLinkField) ? XVar.Pack(GlobalVars.cipherer.GetFieldName((XVar)(lwDisplayField), (XVar)(lookupField), new XVar(true))) : XVar.Pack(lwDisplayField))); } LookupSQLTable = MVCFunctions.Concat(LookupSQLTable, " FROM ", lookupConnection.addTableWrappers((XVar)(lookupTable)), " "); } strLookupWhere = XVar.Clone(CommonFunctions.prepareLookupWhere((XVar)(lookupField), (XVar)(GlobalVars.gSettings))); if (LookupType == Constants.LT_QUERY) { dynamic secOpt = null; secOpt = XVar.Clone(lookupPSet.getAdvancedSecurityType()); if (secOpt == Constants.ADVSECURITY_VIEW_OWN) { strLookupWhere = XVar.Clone(CommonFunctions.whereAdd((XVar)(strLookupWhere), (XVar)(CommonFunctions.SecuritySQL(new XVar("Search"), (XVar)(lookupTable))))); } } if (XVar.Pack(strLookupWhere)) { strLookupWhere = XVar.Clone(MVCFunctions.Concat(" (", strLookupWhere, ") AND ")); } if (LookupType == Constants.LT_QUERY) { if (XVar.Pack(GlobalVars.gSettings.getCustomDisplay((XVar)(lookupField)))) { likeField = XVar.Clone((XVar.Pack(searchByLinkField) ? XVar.Pack(linkFieldName) : XVar.Pack(displayFieldName))); } else { likeField = XVar.Clone(RunnerPage._getFieldSQLDecrypt((XVar)((XVar.Pack(searchByLinkField) ? XVar.Pack(linkFieldName) : XVar.Pack(displayFieldName))), (XVar)(lookupConnection), (XVar)(lookupPSet), (XVar)(GlobalVars.cipherer))); } } else { likeField = XVar.Clone(GlobalVars.cipherer.GetFieldName((XVar)(lwDisplayField), (XVar)(lookupField))); } if (XVar.Pack(searchByLinkField)) { likeConditionField = XVar.Clone((XVar.Pack(LookupType == Constants.LT_QUERY) ? XVar.Pack(linkFieldName) : XVar.Pack(lookupField))); } else { likeConditionField = XVar.Clone((XVar.Pack(LookupType == Constants.LT_QUERY) ? XVar.Pack(displayFieldName) : XVar.Pack(lookupField))); } likeWheres = XVar.Clone(XVar.Array()); foreach (KeyValuePair <XVar, dynamic> fieldValue in values.GetEnumerator()) { if (fieldValue.Value == XVar.Pack("")) { continue; } if (LookupType == Constants.LT_QUERY) { likeWheres.InitAndSetArrayItem(MVCFunctions.Concat(likeField, lookupCipherer.GetLikeClause((XVar)(likeConditionField), (XVar)(fieldValue.Value))), null); } else { likeWheres.InitAndSetArrayItem(MVCFunctions.Concat(likeField, GlobalVars.cipherer.GetLikeClause((XVar)(likeConditionField), (XVar)(fieldValue.Value))), null); } } if (XVar.Pack(!(XVar)(MVCFunctions.count(likeWheres)))) { likeWheres.InitAndSetArrayItem("1=0", null); } strLookupWhere = MVCFunctions.Concat(strLookupWhere, MVCFunctions.implode(new XVar(" OR "), (XVar)(likeWheres))); if ((XVar)(isExistParent) && (XVar)(GlobalVars.gSettings.useCategory((XVar)(lookupField)))) { dynamic parentWhereParts = XVar.Array(); parentWhereParts = XVar.Clone(XVar.Array()); foreach (KeyValuePair <XVar, dynamic> cData in GlobalVars.gSettings.getParentFieldsData((XVar)(lookupField)).GetEnumerator()) { dynamic arLookupWhere = XVar.Array(), category = null, lookupCategory = XVar.Array(); arLookupWhere = XVar.Clone(XVar.Array()); category = XVar.Clone(parentCtrlsData[cData.Value["main"]]); lookupCategory = XVar.Clone((XVar.Pack(category == XVar.Pack("")) ? XVar.Pack(XVar.Array()) : XVar.Pack(CommonFunctions.splitvalues((XVar)(category))))); foreach (KeyValuePair <XVar, dynamic> arLookupCategory in lookupCategory.GetEnumerator()) { dynamic catField = null, cvalue = null; cvalue = XVar.Clone(CommonFunctions.make_db_value((XVar)(cData.Value["main"]), (XVar)(arLookupCategory.Value))); if (XVar.Pack(lookupPSet)) { catField = XVar.Clone(RunnerPage._getFieldSQLDecrypt((XVar)(cData.Value["lookup"]), (XVar)(lookupConnection), (XVar)(lookupPSet), (XVar)(GlobalVars.cipherer))); } else { catField = XVar.Clone(lookupConnection.addFieldWrappers((XVar)(cData.Value["lookup"]))); } arLookupWhere.InitAndSetArrayItem(MVCFunctions.Concat(catField, "=", cvalue), null); } if (XVar.Pack(MVCFunctions.count(arLookupWhere))) { parentWhereParts.InitAndSetArrayItem(MVCFunctions.Concat("(", MVCFunctions.implode(new XVar(" OR "), (XVar)(arLookupWhere)), ")"), null); } } if (MVCFunctions.count(parentWhereParts) == MVCFunctions.count(GlobalVars.gSettings.getParentFieldsData((XVar)(lookupField)))) { strLookupWhere = XVar.Clone(CommonFunctions.whereAdd((XVar)(strLookupWhere), (XVar)(MVCFunctions.Concat("(", MVCFunctions.implode(new XVar(" AND "), (XVar)(parentWhereParts)), ")")))); } else { respObj = XVar.Clone(new XVar("success", false, "data", XVar.Array())); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(respObj))); MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } } if (XVar.Pack(MVCFunctions.strlen((XVar)(lookupOrderBy)))) { lookupOrderBy = XVar.Clone(lookupConnection.addFieldWrappers((XVar)(lookupOrderBy))); if (XVar.Pack(GlobalVars.gSettings.isLookupDesc((XVar)(lookupField)))) { lookupOrderBy = MVCFunctions.Concat(lookupOrderBy, " DESC"); } } if (LookupType == Constants.LT_QUERY) { LookupSQL = XVar.Clone(lookupQueryObj.buildSQL_default((XVar)(strLookupWhere))); if (XVar.Pack(MVCFunctions.strlen((XVar)(lookupOrderBy)))) { LookupSQL = MVCFunctions.Concat(LookupSQL, " ORDER BY ", lookupOrderBy); } else { LookupSQL = MVCFunctions.Concat(LookupSQL, lookupQueryObj.OrderByToSql()); } } else { LookupSQL = XVar.Clone(MVCFunctions.Concat(LookupSQLTable, " where ", strLookupWhere)); if ((XVar)(!(XVar)(GlobalVars.gSettings.isLookupUnique((XVar)(lookupField)))) || (XVar)(Constants.nDATABASE_Access != lookupConnection.dbType)) { if (XVar.Pack(lookupOrderBy)) { LookupSQL = MVCFunctions.Concat(LookupSQL, " ORDER BY ", lookupOrderBy); } } } lookupIndices = XVar.Clone(CommonFunctions.GetLookupFieldsIndexes((XVar)(GlobalVars.gSettings), (XVar)(lookupField))); linkFieldIndex = XVar.Clone(lookupIndices["linkFieldIndex"]); displayFieldIndex = XVar.Clone(lookupIndices["displayFieldIndex"]); viewContainer = XVar.Clone(new ViewControlsContainer((XVar)(GlobalVars.gSettings), new XVar(Constants.PAGE_LIST), new XVar(null))); var_response = XVar.Clone(XVar.Array()); qResult = XVar.Clone(lookupConnection.query((XVar)(LookupSQL))); multiselect = XVar.Clone(GlobalVars.gSettings.multiSelect((XVar)(lookupField))); while (XVar.Pack(data = XVar.Clone(qResult.fetchNumeric()))) { if ((XVar)(LookupType == Constants.LT_QUERY) && (XVar)(GlobalVars.gSettings.isLookupUnique((XVar)(lookupField)))) { dynamic uniqueArray = XVar.Array(); if (XVar.Pack(!(XVar)(uniqueArray as object != null))) { uniqueArray = XVar.Clone(XVar.Array()); } if (XVar.Pack(MVCFunctions.in_array((XVar)(data[displayFieldIndex]), (XVar)(uniqueArray)))) { continue; } uniqueArray.InitAndSetArrayItem(data[displayFieldIndex], null); } data.InitAndSetArrayItem(GlobalVars.cipherer.DecryptField((XVar)(lookupField), (XVar)(data[linkFieldIndex])), linkFieldIndex); if (LookupType == Constants.LT_QUERY) { data.InitAndSetArrayItem(GlobalVars.cipherer.DecryptField((XVar)(displayFieldName), (XVar)(data[displayFieldIndex])), displayFieldIndex); } displayedValue = XVar.Clone(data[displayFieldIndex]); if (XVar.Pack(MVCFunctions.in_array((XVar)(GlobalVars.gSettings.getViewFormat((XVar)(lookupField))), (XVar)(new XVar(0, Constants.FORMAT_DATE_SHORT, 1, Constants.FORMAT_DATE_LONG, 2, Constants.FORMAT_DATE_TIME))))) { dynamic ctrlData = XVar.Array(); ctrlData = XVar.Clone(XVar.Array()); ctrlData.InitAndSetArrayItem(data[linkFieldIndex], lookupField); displayedValue = XVar.Clone(viewContainer.getControl((XVar)(lookupField)).getTextValue((XVar)(ctrlData))); } var_response.InitAndSetArrayItem(data[linkFieldIndex], null); var_response.InitAndSetArrayItem(displayedValue, null); } respObj = XVar.Clone(new XVar("success", true, "data", MVCFunctions.array_slice((XVar)(var_response), new XVar(0), new XVar(40)))); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(respObj))); MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult view() { try { dynamic keys = XVar.Array(), pageMode = null, pageObject = null, var_params = XVar.Array(); XTempl xt; admin_members_Variables.Apply(); CommonFunctions.add_nocache_headers(); if (XVar.Pack(!(XVar)(ViewPage.processEditPageSecurity((XVar)(GlobalVars.strTableName))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } { TLayout t_layout = null; t_layout = new TLayout(new XVar("view_bootstrap_2col"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "admin_members_view"; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["viewpage"] = XVar.Array(); t_layout.containers["viewpage"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "header")); t_layout.containers["header"] = XVar.Array(); t_layout.containers["header"].Add(new XVar("name", "viewheader", "block", "viewheader", "substyle", 1)); t_layout.skins["header"] = ""; t_layout.skins["viewpage"] = ""; t_layout.blocks["top"].Add("viewpage"); t_layout.containers["fields"] = XVar.Array(); t_layout.containers["fields"].Add(new XVar("name", "viewfields", "block", "", "substyle", 1)); t_layout.skins["fields"] = ""; t_layout.blocks["top"].Add("fields"); t_layout.containers["bottombuttons"] = XVar.Array(); t_layout.containers["bottombuttons"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "buttons")); t_layout.containers["buttons"] = XVar.Array(); t_layout.containers["buttons"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "leftbuttons")); t_layout.containers["leftbuttons"] = XVar.Array(); t_layout.containers["leftbuttons"].Add(new XVar("name", "viewbuttons", "block", "viewbuttons", "substyle", 1)); t_layout.skins["leftbuttons"] = ""; t_layout.containers["buttons"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "leftbuttons_1")); t_layout.containers["leftbuttons_1"] = XVar.Array(); t_layout.containers["leftbuttons_1"].Add(new XVar("name", "rightviewbuttons", "block", "rightviewbuttons", "substyle", 1)); t_layout.skins["leftbuttons_1"] = ""; t_layout.skins["buttons"] = ""; t_layout.skins["bottombuttons"] = ""; t_layout.blocks["top"].Add("bottombuttons"); GlobalVars.page_layouts["admin_members_view"] = t_layout; } { TLayout t_layout = null; t_layout = new TLayout(new XVar("list_bootstrap1"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "dbo_REGISTRO_HORAS_COMPESADAS_list"; t_layout.blocks["center"] = XVar.Array(); t_layout.containers["gridcontrols"] = XVar.Array(); t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "add_delete")); t_layout.containers["add_delete"] = XVar.Array(); t_layout.containers["add_delete"].Add(new XVar("name", "add", "block", "newrecord_controls_block", "substyle", 1)); t_layout.containers["add_delete"].Add(new XVar("name", "recordcontrol", "block", "record_controls_block", "substyle", 1)); t_layout.skins["add_delete"] = ""; t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "gridinfo")); t_layout.containers["gridinfo"] = XVar.Array(); t_layout.containers["gridinfo"].Add(new XVar("name", "details_found", "block", "details_found", "substyle", 1)); t_layout.containers["gridinfo"].Add(new XVar("name", "printpanel", "block", "print_friendly", "substyle", 1)); t_layout.containers["gridinfo"].Add(new XVar("name", "bsfieldhidepanel", "block", "field_hide_panel", "substyle", 1)); t_layout.skins["gridinfo"] = ""; t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "gridinfo_sort")); t_layout.containers["gridinfo_sort"] = XVar.Array(); t_layout.containers["gridinfo_sort"].Add(new XVar("name", "reorder_records", "block", "reorder_records", "substyle", 1)); t_layout.skins["gridinfo_sort"] = ""; t_layout.skins["gridcontrols"] = ""; t_layout.blocks["center"].Add("gridcontrols"); t_layout.containers["tabs"] = XVar.Array(); t_layout.containers["tabs"].Add(new XVar("name", "bsgrid_tabs", "block", "grid_tabs", "substyle", 1)); t_layout.skins["tabs"] = ""; t_layout.blocks["center"].Add("tabs"); t_layout.containers["messagerow"] = XVar.Array(); t_layout.containers["messagerow"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "message")); t_layout.containers["message"] = XVar.Array(); t_layout.containers["message"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.skins["message"] = ""; t_layout.skins["messagerow"] = ""; t_layout.blocks["center"].Add("messagerow"); t_layout.containers["center"] = XVar.Array(); t_layout.containers["center"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "grid")); t_layout.containers["grid"] = XVar.Array(); t_layout.containers["grid"].Add(new XVar("name", "grid", "block", "grid_block", "substyle", 1)); t_layout.skins["grid"] = ""; t_layout.skins["center"] = ""; t_layout.blocks["center"].Add("center"); t_layout.containers["pagination"] = XVar.Array(); t_layout.containers["pagination"].Add(new XVar("name", "pagination", "block", "pagination_block", "substyle", 1)); t_layout.skins["pagination"] = ""; t_layout.blocks["center"].Add("pagination"); t_layout.blocks["left"] = XVar.Array(); t_layout.containers["left"] = XVar.Array(); t_layout.containers["left"].Add(new XVar("name", "searchpanel", "block", "searchPanel", "substyle", 1)); t_layout.containers["left"].Add(new XVar("name", "filterpanel", "block", "filterPanel", "substyle", 1)); t_layout.skins["left"] = ""; t_layout.blocks["left"].Add("left"); t_layout.blocks["top"] = XVar.Array(); t_layout.containers["menu"] = XVar.Array(); t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "hdr")); t_layout.containers["hdr"] = XVar.Array(); t_layout.containers["hdr"].Add(new XVar("name", "logo", "block", "logo_block", "substyle", 1)); t_layout.containers["hdr"].Add(new XVar("name", "bsnavbarcollapse", "block", "collapse_block", "substyle", 1)); t_layout.skins["hdr"] = ""; t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "menu_1")); t_layout.containers["menu_1"] = XVar.Array(); t_layout.containers["menu_1"].Add(new XVar("name", "hmenu", "block", "menu_block", "substyle", 1)); t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "more")); t_layout.containers["more"] = XVar.Array(); t_layout.containers["more"].Add(new XVar("name", "morebutton", "block", "more_list", "substyle", 1)); t_layout.containers["more"].Add(new XVar("name", "loggedas", "block", "security_block", "substyle", 1)); t_layout.skins["more"] = ""; t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "more_1")); t_layout.containers["more_1"] = XVar.Array(); t_layout.containers["more_1"].Add(new XVar("name", "search", "block", "searchform_block", "substyle", 1)); t_layout.skins["more_1"] = ""; t_layout.skins["menu_1"] = ""; t_layout.skins["menu"] = ""; t_layout.blocks["top"].Add("menu"); t_layout.blocks["topmiddle"] = XVar.Array(); t_layout.containers["breadcrumbs"] = XVar.Array(); t_layout.containers["breadcrumbs"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "bc")); t_layout.containers["bc"] = XVar.Array(); t_layout.containers["bc"].Add(new XVar("name", "breadcrumbs", "block", "breadcrumbs", "substyle", 1)); t_layout.skins["bc"] = ""; t_layout.skins["breadcrumbs"] = ""; t_layout.blocks["topmiddle"].Add("breadcrumbs"); t_layout.containers["masterinfo"] = XVar.Array(); t_layout.containers["masterinfo"].Add(new XVar("name", "masterinfo", "block", "mastertable_block", "substyle", 1)); t_layout.skins["masterinfo"] = ""; t_layout.blocks["topmiddle"].Add("masterinfo"); GlobalVars.page_layouts["dbo_REGISTRO_HORAS_COMPESADAS_list"] = t_layout; } { TLayout t_layout = null; t_layout = new TLayout(new XVar("list_bootstrap1"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "dbo_Permisos2_list"; t_layout.blocks["center"] = XVar.Array(); t_layout.containers["gridcontrols"] = XVar.Array(); t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "add_delete")); t_layout.containers["add_delete"] = XVar.Array(); t_layout.containers["add_delete"].Add(new XVar("name", "add", "block", "newrecord_controls_block", "substyle", 1)); t_layout.containers["add_delete"].Add(new XVar("name", "recordcontrol", "block", "record_controls_block", "substyle", 1)); t_layout.skins["add_delete"] = ""; t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "gridinfo")); t_layout.containers["gridinfo"] = XVar.Array(); t_layout.containers["gridinfo"].Add(new XVar("name", "details_found", "block", "details_found", "substyle", 1)); t_layout.containers["gridinfo"].Add(new XVar("name", "printpanel", "block", "print_friendly", "substyle", 1)); t_layout.containers["gridinfo"].Add(new XVar("name", "bsfieldhidepanel", "block", "field_hide_panel", "substyle", 1)); t_layout.skins["gridinfo"] = ""; t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "gridinfo_sort")); t_layout.containers["gridinfo_sort"] = XVar.Array(); t_layout.containers["gridinfo_sort"].Add(new XVar("name", "reorder_records", "block", "reorder_records", "substyle", 1)); t_layout.skins["gridinfo_sort"] = ""; t_layout.skins["gridcontrols"] = ""; t_layout.blocks["center"].Add("gridcontrols"); t_layout.containers["tabs"] = XVar.Array(); t_layout.containers["tabs"].Add(new XVar("name", "bsgrid_tabs", "block", "grid_tabs", "substyle", 1)); t_layout.skins["tabs"] = ""; t_layout.blocks["center"].Add("tabs"); t_layout.containers["messagerow"] = XVar.Array(); t_layout.containers["messagerow"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "message")); t_layout.containers["message"] = XVar.Array(); t_layout.containers["message"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.skins["message"] = ""; t_layout.skins["messagerow"] = ""; t_layout.blocks["center"].Add("messagerow"); t_layout.containers["center"] = XVar.Array(); t_layout.containers["center"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "grid")); t_layout.containers["grid"] = XVar.Array(); t_layout.containers["grid"].Add(new XVar("name", "grid", "block", "grid_block", "substyle", 1)); t_layout.skins["grid"] = ""; t_layout.skins["center"] = ""; t_layout.blocks["center"].Add("center"); t_layout.containers["pagination"] = XVar.Array(); t_layout.containers["pagination"].Add(new XVar("name", "pagination", "block", "pagination_block", "substyle", 1)); t_layout.skins["pagination"] = ""; t_layout.blocks["center"].Add("pagination"); t_layout.blocks["left"] = XVar.Array(); t_layout.containers["left"] = XVar.Array(); t_layout.containers["left"].Add(new XVar("name", "searchpanel", "block", "searchPanel", "substyle", 1)); t_layout.containers["left"].Add(new XVar("name", "filterpanel", "block", "filterPanel", "substyle", 1)); t_layout.skins["left"] = ""; t_layout.blocks["left"].Add("left"); t_layout.blocks["top"] = XVar.Array(); t_layout.containers["menu"] = XVar.Array(); t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "hdr")); t_layout.containers["hdr"] = XVar.Array(); t_layout.containers["hdr"].Add(new XVar("name", "logo", "block", "logo_block", "substyle", 1)); t_layout.containers["hdr"].Add(new XVar("name", "bsnavbarcollapse", "block", "collapse_block", "substyle", 1)); t_layout.skins["hdr"] = ""; t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "menu_1")); t_layout.containers["menu_1"] = XVar.Array(); t_layout.containers["menu_1"].Add(new XVar("name", "hmenu", "block", "menu_block", "substyle", 1)); t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "more")); t_layout.containers["more"] = XVar.Array(); t_layout.containers["more"].Add(new XVar("name", "morebutton", "block", "more_list", "substyle", 1)); t_layout.containers["more"].Add(new XVar("name", "loggedas", "block", "security_block", "substyle", 1)); t_layout.skins["more"] = ""; t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "more_1")); t_layout.containers["more_1"] = XVar.Array(); t_layout.containers["more_1"].Add(new XVar("name", "search", "block", "searchform_block", "substyle", 1)); t_layout.skins["more_1"] = ""; t_layout.skins["menu_1"] = ""; t_layout.skins["menu"] = ""; t_layout.blocks["top"].Add("menu"); t_layout.blocks["topmiddle"] = XVar.Array(); t_layout.containers["breadcrumbs"] = XVar.Array(); t_layout.containers["breadcrumbs"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "bc")); t_layout.containers["bc"] = XVar.Array(); t_layout.containers["bc"].Add(new XVar("name", "breadcrumbs", "block", "breadcrumbs", "substyle", 1)); t_layout.skins["bc"] = ""; t_layout.skins["breadcrumbs"] = ""; t_layout.blocks["topmiddle"].Add("breadcrumbs"); t_layout.containers["masterinfo"] = XVar.Array(); t_layout.containers["masterinfo"].Add(new XVar("name", "masterinfo", "block", "mastertable_block", "substyle", 1)); t_layout.skins["masterinfo"] = ""; t_layout.blocks["topmiddle"].Add("masterinfo"); GlobalVars.page_layouts["dbo_Permisos2_list"] = t_layout; } pageMode = XVar.Clone(ViewPage.readViewModeFromRequest()); xt = XVar.UnPackXTempl(new XTempl()); keys = XVar.Clone(XVar.Array()); keys.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("editid1")), "ONI"); var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(CommonFunctions.postvalue_number(new XVar("id")), "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(keys, "keys"); var_params.InitAndSetArrayItem(pageMode, "mode"); var_params.InitAndSetArrayItem(Constants.PAGE_VIEW, "pageType"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("page")), "pageName"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem(!XVar.Equals(XVar.Pack(MVCFunctions.postvalue(new XVar("mvcPDF"))), XVar.Pack("")), "pdfMode"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("mastertable")), "masterTable"); if (pageMode == Constants.VIEW_DASHBOARD) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("table")), "dashTName"); if (XVar.Pack(MVCFunctions.postvalue(new XVar("mapRefresh")))) { var_params.InitAndSetArrayItem(true, "mapRefresh"); var_params.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("vpCoordinates")))), "vpCoordinates"); } } if (pageMode == Constants.VIEW_POPUP) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashTName")), "dashTName"); } if (XVar.Pack(var_params["masterTable"])) { var_params.InitAndSetArrayItem(ViewPage.processMasterKeys(), "masterKeysReq"); } GlobalVars.pageObject = XVar.Clone(new ViewPage((XVar)(var_params))); GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public XVar autocomplete() { try { dynamic contextParams = XVar.Array(), control = null, editControls = null, field = null, isExistParent = null, masterTable = null, mode = null, pageType = null, parentCtrlsData = null, respObj = null, shortTableName = null; ProjectSettings pSet; MVCFunctions.Header("Expires", "Thu, 01 Jan 1970 00:00:01 GMT"); shortTableName = XVar.Clone(MVCFunctions.postvalue(new XVar("shortTName"))); Assembly.GetExecutingAssembly().GetType(MVCFunctions.Concat("runnerDotNet.", MVCFunctions.Concat("", shortTableName, ""), "_Variables")).InvokeMember("Apply", BindingFlags.InvokeMethod, null, null, null); field = XVar.Clone(MVCFunctions.postvalue(new XVar("field"))); if (GlobalVars.strTableName != "dbo._ABCSecurity") { if (XVar.Pack(!(XVar)(CommonFunctions.isLogged()))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } if ((XVar)((XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Edit")))) && (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Add"))))) && (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search"))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } } else { dynamic checkField = null; checkField = new XVar(true); if (field == "username") { checkField = new XVar(false); } if (field == "password") { checkField = new XVar(false); } if (XVar.Pack(checkField)) { if (XVar.Pack(!(XVar)(CommonFunctions.isLogged()))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } if ((XVar)((XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Edit")))) && (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Add"))))) && (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search"))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } } } pageType = XVar.Clone(MVCFunctions.postvalue(new XVar("pageType"))); GlobalVars.cipherer = XVar.Clone(new RunnerCipherer((XVar)(GlobalVars.strTableName))); pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(GlobalVars.strTableName), (XVar)(pageType))); editControls = XVar.Clone(new EditControlsContainer(new XVar(null), (XVar)(pSet), (XVar)(pageType), (XVar)(GlobalVars.cipherer))); control = XVar.Clone(editControls.getControl((XVar)(field))); contextParams = XVar.Clone(XVar.Array()); contextParams.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("data")))), "data"); masterTable = XVar.Clone(MVCFunctions.postvalue(new XVar("masterTable"))); if ((XVar)(masterTable != XVar.Pack("")) && (XVar)(XSession.Session.KeyExists(MVCFunctions.Concat(masterTable, "_masterRecordData")))) { dynamic masterControlsData = XVar.Array(), masterData = XVar.Array(); masterData = XVar.Clone(XSession.Session[MVCFunctions.Concat(masterTable, "_masterRecordData")]); masterControlsData = XVar.Clone(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("masterData"))))); foreach (KeyValuePair <XVar, dynamic> mValue in masterControlsData.GetEnumerator()) { masterData.InitAndSetArrayItem(mValue.Value, mValue.Key); } contextParams.InitAndSetArrayItem(masterData, "masterData"); } RunnerContext.push((XVar)(new RunnerContextItem(new XVar(Constants.CONTEXT_ROW), (XVar)(contextParams)))); parentCtrlsData = XVar.Clone(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("parentCtrlsData"))))); isExistParent = XVar.Clone(MVCFunctions.postvalue(new XVar("isExistParent"))); mode = XVar.Clone(MVCFunctions.intval((XVar)(MVCFunctions.postvalue(new XVar("mode"))))); respObj = XVar.Clone(new XVar("success", true, "data", control.getLookupContentToReload((XVar)(XVar.Equals(XVar.Pack(isExistParent), XVar.Pack("1"))), (XVar)(mode), (XVar)(parentCtrlsData)))); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(respObj))); RunnerContext.pop(); MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult print() { try { dynamic pageObject = null, strtablename = null, var_params = XVar.Array(); XTempl xt; CommonFunctions.add_nocache_headers(); dbo_HORARIOS_Variables.Apply(); if (XVar.Pack(!(XVar)(Security.processPageSecurity((XVar)(strtablename), new XVar("P"))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } { TLayout t_layout = null; t_layout = new TLayout(new XVar("print_bootstrap"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "dbo_HORARIOS_print"; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["pdf"] = XVar.Array(); t_layout.containers["pdf"].Add(new XVar("name", "printbuttons", "block", "printbuttons", "substyle", 1)); t_layout.skins["pdf"] = ""; t_layout.blocks["top"].Add("pdf"); t_layout.containers["master"] = XVar.Array(); t_layout.containers["master"].Add(new XVar("name", "masterinfo", "block", "mastertable_block", "substyle", 1)); t_layout.skins["master"] = ""; t_layout.blocks["top"].Add("master"); t_layout.containers["pageheader"] = XVar.Array(); t_layout.containers["pageheader"].Add(new XVar("name", "printheader", "block", "printheader", "substyle", 1)); t_layout.containers["pageheader"].Add(new XVar("name", "page_of_print", "block", "page_number", "substyle", 1)); t_layout.skins["pageheader"] = ""; t_layout.blocks["top"].Add("pageheader"); t_layout.containers["grid"] = XVar.Array(); t_layout.containers["grid"].Add(new XVar("name", "printgrid", "block", "grid_block", "substyle", 1)); t_layout.skins["grid"] = ""; t_layout.blocks["top"].Add("grid"); GlobalVars.page_layouts["dbo_HORARIOS_print"] = t_layout; } xt = XVar.UnPackXTempl(new XTempl()); var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(CommonFunctions.postvalue_number(new XVar("id")), "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(Constants.PAGE_PRINT, "pageType"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("page")), "pageName"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("selection")), "selection"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("all")), "allPagesMode"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("details")), "detailTables"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("records")), "splitByRecords"); var_params.InitAndSetArrayItem((XVar.Pack(MVCFunctions.postvalue(new XVar("pdfjson"))) ? XVar.Pack(Constants.PRINT_PDFJSON) : XVar.Pack(Constants.PRINT_SIMPLE)), "mode"); GlobalVars.pageObject = XVar.Clone(new PrintPage((XVar)(var_params))); GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult import() { try { dynamic id = null, pageObject = null, strtablename = null, var_params = XVar.Array(); XTempl xt; MVCFunctions.Header("Expires", "Thu, 01 Jan 1970 00:00:01 GMT"); Server.ScriptTimeout = 600; INGRESAR_PERMISO_Variables.Apply(); if (XVar.Pack(!(XVar)(Security.processPageSecurity((XVar)(strtablename), new XVar("I"))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } { TLayout t_layout = null; t_layout = new TLayout(new XVar("import_bootstrap"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "INGRESAR_PERMISO_import"; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["page"] = XVar.Array(); t_layout.containers["page"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "panel")); t_layout.containers["panel"] = XVar.Array(); t_layout.containers["panel"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "header")); t_layout.containers["header"] = XVar.Array(); t_layout.containers["header"].Add(new XVar("name", "importheader", "block", "", "substyle", 1)); t_layout.skins["header"] = ""; t_layout.containers["panel"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "body")); t_layout.containers["body"] = XVar.Array(); t_layout.containers["body"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "message")); t_layout.containers["message"] = XVar.Array(); t_layout.containers["message"].Add(new XVar("name", "errormessage", "block", "", "substyle", 1)); t_layout.skins["message"] = ""; t_layout.containers["body"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "import")); t_layout.containers["import"] = XVar.Array(); t_layout.containers["import"].Add(new XVar("name", "importheader_text", "block", "", "substyle", 1)); t_layout.containers["import"].Add(new XVar("name", "importfields", "block", "", "substyle", 1)); t_layout.containers["import"].Add(new XVar("name", "import_rawtext_control", "block", "", "substyle", 1)); t_layout.containers["import"].Add(new XVar("name", "import_preview", "block", "", "substyle", 1)); t_layout.containers["import"].Add(new XVar("name", "import_process", "block", "", "substyle", 1)); t_layout.containers["import"].Add(new XVar("name", "import_results", "block", "", "substyle", 1)); t_layout.containers["import"].Add(new XVar("name", "importbuttons", "block", "", "substyle", 1)); t_layout.skins["import"] = ""; t_layout.skins["body"] = ""; t_layout.skins["panel"] = ""; t_layout.skins["page"] = ""; t_layout.blocks["top"].Add("page"); GlobalVars.page_layouts["INGRESAR_PERMISO_import"] = t_layout; } xt = XVar.UnPackXTempl(new XTempl()); id = XVar.Clone(CommonFunctions.postvalue_number(new XVar("id"))); id = XVar.Clone((XVar.Pack(id != XVar.Pack("")) ? XVar.Pack(id) : XVar.Pack(1))); var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(id, "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("a")), "action"); var_params.InitAndSetArrayItem(Constants.PAGE_IMPORT, "pageType"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("page")), "pageName"); var_params.InitAndSetArrayItem(false, "needSearchClauseObj"); var_params.InitAndSetArrayItem(GlobalVars.strOriginalTableName, "strOriginalTableName"); if (var_params["action"] == "importPreview") { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("importType")), "importType"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("importText")), "importText"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("useXHR")), "useXHR"); } else { if (var_params["action"] == "importData") { var_params.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("importData")))), "importData"); } } GlobalVars.pageObject = XVar.Clone(new ImportPage((XVar)(var_params))); GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult list() { try { dynamic i = null, mode = null, options = XVar.Array(), pageObject = null; XTempl xt; dbo__ABCVotes_Variables.Apply(); CommonFunctions.add_nocache_headers(); CommonFunctions.InitLookupLinks(); if (XVar.Pack(!(XVar)(ListPage.processListPageSecurity((XVar)(GlobalVars.strTableName))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } if (XVar.Pack(ListPage.processSaveParams((XVar)(GlobalVars.strTableName)))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } { TLayout t_layout = null; t_layout = new TLayout(new XVar("list6"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["center"] = XVar.Array(); t_layout.containers["message"] = XVar.Array(); t_layout.containers["message"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.skins["message"] = "2"; t_layout.blocks["center"].Add("message"); t_layout.containers["grid"] = XVar.Array(); t_layout.containers["grid"].Add(new XVar("name", "grid", "block", "grid_block", "substyle", 1)); t_layout.skins["grid"] = "grid"; t_layout.blocks["center"].Add("grid"); t_layout.containers["pagination"] = XVar.Array(); t_layout.containers["pagination"].Add(new XVar("name", "pagination", "block", "pagination_block", "substyle", 1)); t_layout.skins["pagination"] = "2"; t_layout.blocks["center"].Add("pagination"); t_layout.blocks["left"] = XVar.Array(); t_layout.containers["left"] = XVar.Array(); t_layout.containers["left"].Add(new XVar("name", "searchpanel", "block", "searchPanel", "substyle", 1)); t_layout.skins["left"] = "menu"; t_layout.blocks["left"].Add("left"); t_layout.blocks["top"] = XVar.Array(); t_layout.containers["master"] = XVar.Array(); t_layout.containers["master"].Add(new XVar("name", "masterinfo", "block", "mastertable_block", "substyle", 1)); t_layout.skins["master"] = "empty"; t_layout.blocks["top"].Add("master"); t_layout.containers["toplinks"] = XVar.Array(); t_layout.containers["toplinks"].Add(new XVar("name", "loggedas", "block", "security_block", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "toplinks_advsearch", "block", "asearch_link", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "toplinks_import", "block", "import_link", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "toplinks_export", "block", "export_link", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "printpanel", "block", "print_friendly", "substyle", 1)); t_layout.skins["toplinks"] = "2"; t_layout.blocks["top"].Add("toplinks"); t_layout.containers["hmenu"] = XVar.Array(); t_layout.containers["hmenu"].Add(new XVar("name", "hmenu", "block", "menu_block", "substyle", 1)); t_layout.skins["hmenu"] = "hmenu"; t_layout.blocks["top"].Add("hmenu"); t_layout.containers["search"] = XVar.Array(); t_layout.containers["search"].Add(new XVar("name", "search", "block", "searchform_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "search_buttons", "block", "searchformbuttons_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "search_saving_buttons", "block", "searchsaving_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "details_found", "block", "details_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "page_of", "block", "pages_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "recsperpage", "block", "recordspp_block", "substyle", 1)); t_layout.skins["search"] = "1"; t_layout.blocks["top"].Add("search"); t_layout.containers["recordcontrols"] = XVar.Array(); t_layout.containers["recordcontrols"].Add(new XVar("name", "recordcontrols_new", "block", "newrecord_controls_block", "substyle", 1)); t_layout.containers["recordcontrols"].Add(new XVar("name", "recordcontrol", "block", "record_controls_block", "substyle", 1)); t_layout.skins["recordcontrols"] = "2"; t_layout.blocks["top"].Add("recordcontrols"); GlobalVars.page_layouts["dbo__ABCVotes_list"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } { TLayout t_layout = null; t_layout = new TLayout(new XVar("masterlist"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["bare"] = XVar.Array(); t_layout.containers["masterlistheader"] = XVar.Array(); t_layout.containers["masterlistheader"].Add(new XVar("name", "masterlistheader", "block", "", "substyle", 1)); t_layout.skins["masterlistheader"] = "empty"; t_layout.blocks["bare"].Add("masterlistheader"); t_layout.containers["mastergrid"] = XVar.Array(); t_layout.containers["mastergrid"].Add(new XVar("name", "masterlistgrid", "block", "", "substyle", 1)); t_layout.skins["mastergrid"] = "grid"; t_layout.blocks["bare"].Add("mastergrid"); GlobalVars.page_layouts["dbo__ABCReports_masterlist"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } { TLayout t_layout = null; t_layout = new TLayout(new XVar("masterlist"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["bare"] = XVar.Array(); t_layout.containers["masterlistheader"] = XVar.Array(); t_layout.containers["masterlistheader"].Add(new XVar("name", "masterlistheader", "block", "", "substyle", 1)); t_layout.skins["masterlistheader"] = "empty"; t_layout.blocks["bare"].Add("masterlistheader"); t_layout.containers["mastergrid"] = XVar.Array(); t_layout.containers["mastergrid"].Add(new XVar("name", "masterlistgrid", "block", "", "substyle", 1)); t_layout.skins["mastergrid"] = "grid"; t_layout.blocks["bare"].Add("mastergrid"); GlobalVars.page_layouts["ABC_Voting_Recirculated1_masterlist"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } { TLayout t_layout = null; t_layout = new TLayout(new XVar("masterlist"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["bare"] = XVar.Array(); t_layout.containers["masterlistheader"] = XVar.Array(); t_layout.containers["masterlistheader"].Add(new XVar("name", "masterlistheader", "block", "", "substyle", 1)); t_layout.skins["masterlistheader"] = "empty"; t_layout.blocks["bare"].Add("masterlistheader"); t_layout.containers["mastergrid"] = XVar.Array(); t_layout.containers["mastergrid"].Add(new XVar("name", "masterlistgrid", "block", "", "substyle", 1)); t_layout.skins["mastergrid"] = "grid"; t_layout.blocks["bare"].Add("mastergrid"); GlobalVars.page_layouts["ABC_Voting_My_Voting_masterlist"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } { TLayout t_layout = null; t_layout = new TLayout(new XVar("masterlist"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["bare"] = XVar.Array(); t_layout.containers["masterlistheader"] = XVar.Array(); t_layout.containers["masterlistheader"].Add(new XVar("name", "masterlistheader", "block", "", "substyle", 1)); t_layout.skins["masterlistheader"] = "empty"; t_layout.blocks["bare"].Add("masterlistheader"); t_layout.containers["mastergrid"] = XVar.Array(); t_layout.containers["mastergrid"].Add(new XVar("name", "masterlistgrid", "block", "", "substyle", 1)); t_layout.skins["mastergrid"] = "grid"; t_layout.blocks["bare"].Add("mastergrid"); GlobalVars.page_layouts["dbo_vwABCReportsVoteCount_masterlist"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } options = XVar.Clone(XVar.Array()); mode = XVar.Clone(ListPage.readListModeFromRequest()); if (mode == Constants.LIST_SIMPLE) { } else { if (mode == Constants.LIST_AJAX) { } else { if (mode == Constants.LIST_LOOKUP) { options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("table")), "mainTable"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("field")), "mainField"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("pageType")), "mainPageType"); options.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("data")))), "mainRecordData"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("mainRecordMasterTable")), "mainRecordMasterTable"); if (XVar.Pack(MVCFunctions.postvalue(new XVar("parentsExist")))) { options.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("parentCtrlsData")))), "parentCtrlsData"); } } else { if (mode == Constants.LIST_DETAILS) { } else { if (mode == Constants.LIST_DASHDETAILS) { } else { if (mode == Constants.LIST_DASHBOARD) { } else { if (mode == Constants.MAP_DASHBOARD) { } } } } } } } xt = XVar.UnPackXTempl(new XTempl((XVar)(mode != Constants.LIST_SIMPLE))); options.InitAndSetArrayItem(Constants.PAGE_LIST, "pageType"); options.InitAndSetArrayItem((XVar.Pack(MVCFunctions.postvalue(new XVar("id"))) ? XVar.Pack(MVCFunctions.postvalue(new XVar("id"))) : XVar.Pack(1)), "id"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("recordId")) + 0, "flyId"); options.InitAndSetArrayItem(mode, "mode"); options.InitAndSetArrayItem(xt, "xt"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("masterpagetype")), "masterPageType"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("mastertable")), "masterTable"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("masterid")), "masterId"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("firsttime")), "firstTime"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("sortby")), "sortBy"); if ((XVar)((XVar)(mode == Constants.LIST_DASHBOARD) && (XVar)(MVCFunctions.postvalue(new XVar("nodata")))) && (XVar)(MVCFunctions.strlen((XVar)(options["masterTable"])))) { options.InitAndSetArrayItem(true, "showNoData"); } if (mode != Constants.LIST_LOOKUP) { options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("table")), "dashTName"); } if (XVar.Pack(MVCFunctions.postvalue(new XVar("mapRefresh")))) { options.InitAndSetArrayItem(true, "mapRefresh"); options.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("vpCoordinates")))), "vpCoordinates"); } i = new XVar(1); while (XVar.Pack(MVCFunctions.REQUESTKeyExists(MVCFunctions.Concat("masterkey", i)))) { if (i == 1) { options.InitAndSetArrayItem(XVar.Array(), "masterKeysReq"); } options.InitAndSetArrayItem(MVCFunctions.postvalue(MVCFunctions.Concat("masterkey", i)), "masterKeysReq", i); i++; } GlobalVars.pageObject = XVar.Clone(ListPage.createListPage((XVar)(GlobalVars.strTableName), (XVar)(options))); if (XVar.Pack(GlobalVars.pageObject.processSaveSearch())) { MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } GlobalVars.gQuery.ReplaceFieldsWithDummies((XVar)(GlobalVars.pageObject.getNotListBlobFieldsIndices())); if ((XVar)((XVar)(mode != Constants.LIST_DETAILS) && (XVar)(mode != Constants.MAP_DASHBOARD)) && (XVar)(mode != Constants.LIST_DASHBOARD)) { dynamic mapSettings = XVar.Array(); } XSession.Session.Remove("message_add"); XSession.Session.Remove("message_edit"); GlobalVars.pageObject.prepareForBuildPage(); GlobalVars.pageObject.showPage(); if (mode != Constants.LIST_SIMPLE) { MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult export() { try { dynamic pageObject = null, strtablename = null, var_params = XVar.Array(); XTempl xt; dbo__ABCVotes_Variables.Apply(); MVCFunctions.Header("Expires", "Thu, 01 Jan 1970 00:00:01 GMT"); if (XVar.Pack(!(XVar)(Security.processPageSecurity((XVar)(strtablename), new XVar("P"))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } { TLayout t_layout = null; t_layout = new TLayout(new XVar("export2"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["export"] = XVar.Array(); t_layout.containers["export"].Add(new XVar("name", "exportheader", "block", "", "substyle", 2)); t_layout.containers["export"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "range")); t_layout.containers["range"] = XVar.Array(); t_layout.containers["range"].Add(new XVar("name", "exprange", "block", "range_block", "substyle", 1)); t_layout.skins["range"] = "fields"; t_layout.containers["export"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "format")); t_layout.containers["format"] = XVar.Array(); t_layout.containers["format"].Add(new XVar("name", "expformat", "block", "exportformat", "substyle", 1)); t_layout.skins["format"] = "fields"; t_layout.containers["export"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "fields")); t_layout.containers["fields"] = XVar.Array(); t_layout.containers["fields"].Add(new XVar("name", "expoutput", "block", "", "substyle", 1)); t_layout.skins["fields"] = "fields"; t_layout.containers["export"].Add(new XVar("name", "expbuttons", "block", "", "substyle", 2)); t_layout.skins["export"] = "1"; t_layout.blocks["top"].Add("export"); GlobalVars.page_layouts["dbo__ABCVotes_export"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } xt = XVar.UnPackXTempl(new XTempl()); var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("id")), "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem(Constants.PAGE_EXPORT, "pageType"); if ((XVar)(!(XVar)(GlobalVars.eventObj.exists(new XVar("ListGetRowCount")))) && (XVar)(!(XVar)(GlobalVars.eventObj.exists(new XVar("ListQuery"))))) { var_params.InitAndSetArrayItem(false, "needSearchClauseObj"); } var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("exportFields")), "selectedFields"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("type")), "exportType"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("a")), "action"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("records")), "records"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("selection")), "selection"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("delimiter")), "csvDelimiter"); if (MVCFunctions.postvalue(new XVar("txtformatting")) == "raw") { var_params.InitAndSetArrayItem(true, "useRawValues"); } var_params.InitAndSetArrayItem(ExportPage.readModeFromRequest(), "mode"); GlobalVars.pageObject = XVar.Clone(new ExportPage((XVar)(var_params))); GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult view() { try { dynamic keys = XVar.Array(), pageMode = null, pageObject = null, var_params = XVar.Array(); XTempl xt; ABC_Voting_My_Voting_Variables.Apply(); CommonFunctions.add_nocache_headers(); if (XVar.Pack(!(XVar)(ViewPage.processEditPageSecurity((XVar)(GlobalVars.strTableName))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } { TLayout t_layout = null; t_layout = new TLayout(new XVar("view2"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["all"] = XVar.Array(); t_layout.containers["all"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "main")); t_layout.containers["main"] = XVar.Array(); t_layout.containers["main"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "view")); t_layout.containers["view"] = XVar.Array(); t_layout.containers["view"].Add(new XVar("name", "viewheader", "block", "viewheader", "substyle", 2)); t_layout.containers["view"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "fields")); t_layout.containers["fields"] = XVar.Array(); t_layout.containers["fields"].Add(new XVar("name", "viewfields", "block", "", "substyle", 1)); t_layout.containers["fields"].Add(new XVar("name", "viewbuttons", "block", "viewbuttons", "substyle", 2)); t_layout.skins["fields"] = "fields"; t_layout.skins["view"] = "1"; t_layout.skins["main"] = "empty"; t_layout.containers["all"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "details")); t_layout.containers["details"] = XVar.Array(); t_layout.containers["details"].Add(new XVar("name", "viewdetails", "block", "detail_tables", "substyle", 1)); t_layout.skins["details"] = "empty"; t_layout.skins["all"] = "empty"; t_layout.blocks["top"].Add("all"); GlobalVars.page_layouts["ABC_Voting_My_Voting_view"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } { TLayout t_layout = null; t_layout = new TLayout(new XVar("list6"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["center"] = XVar.Array(); t_layout.containers["message"] = XVar.Array(); t_layout.containers["message"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.skins["message"] = "2"; t_layout.blocks["center"].Add("message"); t_layout.containers["grid"] = XVar.Array(); t_layout.containers["grid"].Add(new XVar("name", "grid", "block", "grid_block", "substyle", 1)); t_layout.skins["grid"] = "grid"; t_layout.blocks["center"].Add("grid"); t_layout.containers["pagination"] = XVar.Array(); t_layout.containers["pagination"].Add(new XVar("name", "pagination", "block", "pagination_block", "substyle", 1)); t_layout.skins["pagination"] = "2"; t_layout.blocks["center"].Add("pagination"); t_layout.blocks["left"] = XVar.Array(); t_layout.containers["left"] = XVar.Array(); t_layout.containers["left"].Add(new XVar("name", "searchpanel", "block", "searchPanel", "substyle", 1)); t_layout.skins["left"] = "menu"; t_layout.blocks["left"].Add("left"); t_layout.blocks["top"] = XVar.Array(); t_layout.containers["master"] = XVar.Array(); t_layout.containers["master"].Add(new XVar("name", "masterinfo", "block", "mastertable_block", "substyle", 1)); t_layout.skins["master"] = "empty"; t_layout.blocks["top"].Add("master"); t_layout.containers["toplinks"] = XVar.Array(); t_layout.containers["toplinks"].Add(new XVar("name", "loggedas", "block", "security_block", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "toplinks_advsearch", "block", "asearch_link", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "toplinks_import", "block", "import_link", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "toplinks_export", "block", "export_link", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "printpanel", "block", "print_friendly", "substyle", 1)); t_layout.skins["toplinks"] = "2"; t_layout.blocks["top"].Add("toplinks"); t_layout.containers["hmenu"] = XVar.Array(); t_layout.containers["hmenu"].Add(new XVar("name", "hmenu", "block", "menu_block", "substyle", 1)); t_layout.skins["hmenu"] = "hmenu"; t_layout.blocks["top"].Add("hmenu"); t_layout.containers["search"] = XVar.Array(); t_layout.containers["search"].Add(new XVar("name", "search", "block", "searchform_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "search_buttons", "block", "searchformbuttons_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "search_saving_buttons", "block", "searchsaving_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "details_found", "block", "details_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "page_of", "block", "pages_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "recsperpage", "block", "recordspp_block", "substyle", 1)); t_layout.skins["search"] = "1"; t_layout.blocks["top"].Add("search"); t_layout.containers["recordcontrols"] = XVar.Array(); t_layout.containers["recordcontrols"].Add(new XVar("name", "recordcontrols_new", "block", "newrecord_controls_block", "substyle", 1)); t_layout.containers["recordcontrols"].Add(new XVar("name", "recordcontrol", "block", "record_controls_block", "substyle", 1)); t_layout.skins["recordcontrols"] = "2"; t_layout.blocks["top"].Add("recordcontrols"); GlobalVars.page_layouts["dbo__ABCVotes_list"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } pageMode = XVar.Clone(ViewPage.readViewModeFromRequest()); xt = XVar.UnPackXTempl(new XTempl()); keys = XVar.Clone(XVar.Array()); keys.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("editid1")), "id"); keys.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("editid2")), "record"); var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("id")), "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(keys, "keys"); var_params.InitAndSetArrayItem(pageMode, "mode"); var_params.InitAndSetArrayItem(Constants.PAGE_VIEW, "pageType"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem(!XVar.Equals(XVar.Pack(MVCFunctions.postvalue(new XVar("mvcPDF"))), XVar.Pack("")), "pdfMode"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("mastertable")), "masterTable"); if (pageMode == Constants.VIEW_DASHBOARD) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("table")), "dashTName"); if (XVar.Pack(MVCFunctions.postvalue(new XVar("mapRefresh")))) { var_params.InitAndSetArrayItem(true, "mapRefresh"); var_params.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("vpCoordinates")))), "vpCoordinates"); } } if (pageMode == Constants.VIEW_POPUP) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashTName")), "dashTName"); } if (XVar.Pack(var_params["masterTable"])) { var_params.InitAndSetArrayItem(ViewPage.processMasterKeys(), "masterKeysReq"); } GlobalVars.pageObject = XVar.Clone(new ViewPage((XVar)(var_params))); GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult menu() { try { dynamic pageObject = null, var_params = XVar.Array(); XTempl xt; Security.processLogoutRequest(); if (XVar.Pack(!(XVar)(CommonFunctions.isLogged()))) { MVCFunctions.HeaderRedirect(new XVar("login")); return(MVCFunctions.GetBuferContentAndClearBufer()); } if ((XVar)(XSession.Session["MyURL"] == "") || (XVar)(!(XVar)(CommonFunctions.isLoggedAsGuest()))) { Security.saveRedirectURL(); } { TLayout t_layout = null; t_layout = new TLayout(new XVar("menu_bootstrap1"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "_menu"; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["menu"] = XVar.Array(); t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "hdr")); t_layout.containers["hdr"] = XVar.Array(); t_layout.containers["hdr"].Add(new XVar("name", "logo", "block", "logo_block", "substyle", 1)); t_layout.containers["hdr"].Add(new XVar("name", "bsnavbarcollapse", "block", "collapse_block", "substyle", 1)); t_layout.skins["hdr"] = ""; t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "menu_1")); t_layout.containers["menu_1"] = XVar.Array(); t_layout.containers["menu_1"].Add(new XVar("name", "hmenu", "block", "menu_block", "substyle", 1)); t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "login")); t_layout.containers["login"] = XVar.Array(); t_layout.containers["login"].Add(new XVar("name", "morebutton", "block", "more_list", "substyle", 1)); t_layout.containers["login"].Add(new XVar("name", "loggedas", "block", "security_block", "substyle", 1)); t_layout.skins["login"] = ""; t_layout.skins["menu_1"] = ""; t_layout.skins["menu"] = ""; t_layout.blocks["top"].Add("menu"); t_layout.containers["center"] = XVar.Array(); t_layout.containers["center"].Add(new XVar("name", "welcome", "block", "", "substyle", 1)); t_layout.skins["center"] = ""; t_layout.blocks["top"].Add("center"); GlobalVars.page_layouts["menu"] = t_layout; } GlobalVars.tableEvents.InitAndSetArrayItem(new eventclass_dbo_Permisos2(), "dbo.Permisos2"); GlobalVars.tableEvents.InitAndSetArrayItem(new eventclass_dbo_REGISTRO_HORAS_COMPESADAS(), "dbo.REGISTRO_HORAS_COMPESADAS"); GlobalVars.tableEvents.InitAndSetArrayItem(new eventclass_APROBAR_PERMISOS(), "APROBAR_PERMISOS"); GlobalVars.tableEvents.InitAndSetArrayItem(new eventclass_VISTOBUENO_JEFEINMEDIATO(), "VISTOBUENO_JEFEINMEDIATO"); GlobalVars.tableEvents.InitAndSetArrayItem(new eventclass_VISTOBUENO_JEFEDEPARTAMENTO(), "VISTOBUENO_JEFEDEPARTAMENTO"); GlobalVars.tableEvents.InitAndSetArrayItem(new eventclass_VER_PERMISOS(), "VER_PERMISOS"); GlobalVars.tableEvents.InitAndSetArrayItem(new eventclass_APROBACION_COMPESADOS_JEFEINMEDIATO(), "APROBACION_COMPESADOS_JEFEINMEDIATO"); GlobalVars.tableEvents.InitAndSetArrayItem(new eventclass_APROBACION_COMPESADOS_JEFEDEPARTAMENTO(), "APROBACION_COMPESADOS_JEFEDEPARTAMENTO"); GlobalVars.tableEvents.InitAndSetArrayItem(new eventclass_APROBAR_COMPESADOS(), "APROBAR_COMPESADOS"); GlobalVars.tableEvents.InitAndSetArrayItem(new eventclass_INGRESAR_PERMISO(), "INGRESAR PERMISO"); GlobalVars.tableEvents.InitAndSetArrayItem(new eventclass_INGRESAR_COMPESADO(), "INGRESAR_COMPESADO"); xt = XVar.UnPackXTempl(new XTempl()); var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(CommonFunctions.postvalue_number(new XVar("id")), "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(Constants.GLOBAL_PAGES, "tName"); var_params.InitAndSetArrayItem(Constants.PAGE_MENU, "pageType"); var_params.InitAndSetArrayItem(GlobalVars.isGroupSecurity, "isGroupSecurity"); var_params.InitAndSetArrayItem(false, "needSearchClauseObj"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("page")), "pageName"); GlobalVars.pageObject = XVar.Clone(new MenuPage((XVar)(var_params))); GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult edit() { try { dynamic id = null, keys = XVar.Array(), pageMode = null, pageObject = null, var_params = XVar.Array(); XTempl xt; dbo__ABCSecurity_Variables.Apply(); CommonFunctions.add_nocache_headers(); if (XVar.Pack(!(XVar)(EditPage.processEditPageSecurity((XVar)(GlobalVars.strTableName))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } EditPage.handleBrokenRequest(); { TLayout t_layout = null; t_layout = new TLayout(new XVar("edit2"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["all"] = XVar.Array(); t_layout.containers["all"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "master")); t_layout.containers["master"] = XVar.Array(); t_layout.containers["master"].Add(new XVar("name", "masterinfo", "block", "mastertable_block", "substyle", 1)); t_layout.skins["master"] = "empty"; t_layout.containers["all"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "edit")); t_layout.containers["edit"] = XVar.Array(); t_layout.containers["edit"].Add(new XVar("name", "editheader", "block", "editheader", "substyle", 2)); t_layout.containers["edit"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.containers["edit"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "fields")); t_layout.containers["fields"] = XVar.Array(); t_layout.containers["fields"].Add(new XVar("name", "editfields", "block", "", "substyle", 1)); t_layout.containers["fields"].Add(new XVar("name", "editbuttons", "block", "editbuttons", "substyle", 2)); t_layout.skins["fields"] = "fields"; t_layout.skins["edit"] = "1"; t_layout.skins["all"] = "empty"; t_layout.blocks["top"].Add("all"); GlobalVars.page_layouts["dbo__ABCSecurity_edit"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } { TLayout t_layout = null; t_layout = new TLayout(new XVar("list6"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["center"] = XVar.Array(); t_layout.containers["message"] = XVar.Array(); t_layout.containers["message"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.skins["message"] = "2"; t_layout.blocks["center"].Add("message"); t_layout.containers["grid"] = XVar.Array(); t_layout.containers["grid"].Add(new XVar("name", "grid", "block", "grid_block", "substyle", 1)); t_layout.skins["grid"] = "grid"; t_layout.blocks["center"].Add("grid"); t_layout.containers["pagination"] = XVar.Array(); t_layout.containers["pagination"].Add(new XVar("name", "pagination", "block", "pagination_block", "substyle", 1)); t_layout.skins["pagination"] = "2"; t_layout.blocks["center"].Add("pagination"); t_layout.blocks["left"] = XVar.Array(); t_layout.containers["left"] = XVar.Array(); t_layout.containers["left"].Add(new XVar("name", "searchpanel", "block", "searchPanel", "substyle", 1)); t_layout.skins["left"] = "menu"; t_layout.blocks["left"].Add("left"); t_layout.blocks["top"] = XVar.Array(); t_layout.containers["master"] = XVar.Array(); t_layout.containers["master"].Add(new XVar("name", "masterinfo", "block", "mastertable_block", "substyle", 1)); t_layout.skins["master"] = "empty"; t_layout.blocks["top"].Add("master"); t_layout.containers["toplinks"] = XVar.Array(); t_layout.containers["toplinks"].Add(new XVar("name", "loggedas", "block", "security_block", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "toplinks_advsearch", "block", "asearch_link", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "toplinks_import", "block", "import_link", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "toplinks_export", "block", "export_link", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "printpanel", "block", "print_friendly", "substyle", 1)); t_layout.skins["toplinks"] = "2"; t_layout.blocks["top"].Add("toplinks"); t_layout.containers["hmenu"] = XVar.Array(); t_layout.containers["hmenu"].Add(new XVar("name", "hmenu", "block", "menu_block", "substyle", 1)); t_layout.skins["hmenu"] = "hmenu"; t_layout.blocks["top"].Add("hmenu"); t_layout.containers["search"] = XVar.Array(); t_layout.containers["search"].Add(new XVar("name", "search", "block", "searchform_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "search_buttons", "block", "searchformbuttons_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "search_saving_buttons", "block", "searchsaving_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "details_found", "block", "details_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "page_of", "block", "pages_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "recsperpage", "block", "recordspp_block", "substyle", 1)); t_layout.skins["search"] = "1"; t_layout.blocks["top"].Add("search"); t_layout.containers["recordcontrols"] = XVar.Array(); t_layout.containers["recordcontrols"].Add(new XVar("name", "recordcontrols_new", "block", "newrecord_controls_block", "substyle", 1)); t_layout.containers["recordcontrols"].Add(new XVar("name", "recordcontrol", "block", "record_controls_block", "substyle", 1)); t_layout.skins["recordcontrols"] = "2"; t_layout.blocks["top"].Add("recordcontrols"); GlobalVars.page_layouts["dbo__ABCSecurity_list"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } pageMode = XVar.Clone(EditPage.readEditModeFromRequest()); xt = XVar.UnPackXTempl(new XTempl()); id = XVar.Clone(MVCFunctions.postvalue(new XVar("id"))); id = XVar.Clone((XVar.Pack(MVCFunctions.intval((XVar)(id)) == 0) ? XVar.Pack(1) : XVar.Pack(id))); keys = XVar.Clone(XVar.Array()); keys.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("editid1")), "ID"); var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(id, "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(keys, "keys"); var_params.InitAndSetArrayItem(pageMode, "mode"); var_params.InitAndSetArrayItem(Constants.PAGE_EDIT, "pageType"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("a")), "action"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("fields")), "selectedFields"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue((XVar)(MVCFunctions.Concat("value_captcha_", id))), "captchaValue"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("selection")), "selection"); var_params.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("rowIds")))), "rowIds"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("mastertable")), "masterTable"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("action")), "lockingAction"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("sid")), "lockingSid"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("keys")), "lockingKeys"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("startEdit")), "lockingStart"); if (pageMode == Constants.EDIT_INLINE) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("screenWidth")), "screenWidth"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("screenHeight")), "screenHeight"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("orientation")), "orientation"); } if (pageMode == Constants.EDIT_DASHBOARD) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("table")), "dashTName"); if (XVar.Pack(MVCFunctions.postvalue(new XVar("mapRefresh")))) { var_params.InitAndSetArrayItem(true, "mapRefresh"); var_params.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("vpCoordinates")))), "vpCoordinates"); } } if ((XVar)((XVar)(pageMode == Constants.EDIT_POPUP) || (XVar)(pageMode == Constants.EDIT_INLINE)) && (XVar)(MVCFunctions.postvalue(new XVar("dashTName")))) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashTName")), "dashTName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); } if (XVar.Pack(var_params["masterTable"])) { var_params.InitAndSetArrayItem(EditPage.processMasterKeys(), "masterKeysReq"); } GlobalVars.pageObject = XVar.Clone(EditPage.EditPageFactory((XVar)(var_params))); if (XVar.Pack(GlobalVars.pageObject.isLockingRequest())) { GlobalVars.pageObject.doLockingAction(); MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public XVar ug_group() { try { dynamic cbxNames = null, data = XVar.Array(), groupId = null, i = null, nonAdminTablesArr = XVar.Array(), realUsers = XVar.Array(), sql = null, state = XVar.Array(), ug_connection = null, var_error = null, wGroupTableName = null, wMemebersTableName = null; MVCFunctions.Header("Expires", "Thu, 01 Jan 1970 00:00:01 GMT"); if (XVar.Pack(!(XVar)(CommonFunctions.isLogged()))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } if (XVar.Pack(!(XVar)(CommonFunctions.IsAdmin()))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } nonAdminTablesArr = XVar.Clone(XVar.Array()); nonAdminTablesArr.InitAndSetArrayItem("dbo.DEPARTAMENTO", null); nonAdminTablesArr.InitAndSetArrayItem("dbo.EMPLEADO", null); nonAdminTablesArr.InitAndSetArrayItem("dbo.ESTADO_COMPESADO", null); nonAdminTablesArr.InitAndSetArrayItem("dbo.ESTADO_PERSONALES", null); nonAdminTablesArr.InitAndSetArrayItem("dbo.HORARIOS", null); nonAdminTablesArr.InitAndSetArrayItem("dbo.Permisos2", null); nonAdminTablesArr.InitAndSetArrayItem("dbo.PERMISOSGRUPOS", null); nonAdminTablesArr.InitAndSetArrayItem("dbo.Preferencias", null); nonAdminTablesArr.InitAndSetArrayItem("dbo.REGISTRO_HORAS_COMPESADAS", null); nonAdminTablesArr.InitAndSetArrayItem("dbo.TIPOEMPLEADO", null); nonAdminTablesArr.InitAndSetArrayItem("dbo.TIPOPERMISO", null); nonAdminTablesArr.InitAndSetArrayItem("APROBAR_PERMISOS", null); nonAdminTablesArr.InitAndSetArrayItem("VISTOBUENO_JEFEINMEDIATO", null); nonAdminTablesArr.InitAndSetArrayItem("VISTOBUENO_JEFEDEPARTAMENTO", null); nonAdminTablesArr.InitAndSetArrayItem("VER_PERMISOS", null); nonAdminTablesArr.InitAndSetArrayItem("Saldo_Horas_Empleado", null); nonAdminTablesArr.InitAndSetArrayItem("VER_COMPESADOS", null); nonAdminTablesArr.InitAndSetArrayItem("APROBACION_COMPESADOS_JEFEINMEDIATO", null); nonAdminTablesArr.InitAndSetArrayItem("APROBACION_COMPESADOS_JEFEDEPARTAMENTO", null); nonAdminTablesArr.InitAndSetArrayItem("APROBAR_COMPESADOS", null); nonAdminTablesArr.InitAndSetArrayItem("INGRESAR PERMISO", null); nonAdminTablesArr.InitAndSetArrayItem("INGRESAR_COMPESADO", null); nonAdminTablesArr.InitAndSetArrayItem("dbo.GRUPOS", null); nonAdminTablesArr.InitAndSetArrayItem("dbo.acceso_ugmembers", null); nonAdminTablesArr.InitAndSetArrayItem("Licencias_sin_goce_sueldo", null); ug_connection = XVar.Clone(GlobalVars.cman.getForUserGroups()); cbxNames = XVar.Clone(new XVar("add", new XVar("mask", "A", "rightName", "add"), "edt", new XVar("mask", "E", "rightName", "edit"), "del", new XVar("mask", "D", "rightName", "delete"), "lst", new XVar("mask", "S", "rightName", "list"), "exp", new XVar("mask", "P", "rightName", "export"), "imp", new XVar("mask", "I", "rightName", "import"), "adm", new XVar("mask", "M"))); wGroupTableName = XVar.Clone(ug_connection.addTableWrappers(new XVar("dbo.acceso_uggroups"))); switch (((XVar)MVCFunctions.postvalue(new XVar("a"))).ToString()) { case "add": sql = XVar.Clone(MVCFunctions.Concat("insert into ", wGroupTableName, " (", ug_connection.addFieldWrappers(new XVar("Label")), ")", " values (", ug_connection.prepareString((XVar)(MVCFunctions.postvalue(new XVar("name")))), ")")); ug_connection.exec((XVar)(sql)); sql = XVar.Clone(MVCFunctions.Concat("select max(", ug_connection.addFieldWrappers(new XVar("GroupID")), ") from ", wGroupTableName)); data = XVar.Clone(ug_connection.query((XVar)(sql)).fetchNumeric()); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(new XVar("success", true, "id", data[0])))); break; case "del": sql = XVar.Clone(MVCFunctions.Concat("delete from ", wGroupTableName, " where ", ug_connection.addFieldWrappers(new XVar("GroupID")), "=", CommonFunctions.postvalue_number(new XVar("id")))); ug_connection.exec((XVar)(sql)); sql = XVar.Clone(MVCFunctions.Concat("delete from ", ug_connection.addTableWrappers(new XVar("dbo.acceso_ugrights")), " where ", ug_connection.addFieldWrappers(new XVar("GroupID")), "=", CommonFunctions.postvalue_number(new XVar("id")))); ug_connection.exec((XVar)(sql)); sql = XVar.Clone(MVCFunctions.Concat("delete from ", ug_connection.addTableWrappers(new XVar("dbo.acceso_ugmembers")), " where ", ug_connection.addFieldWrappers(new XVar("GroupID")), "=", CommonFunctions.postvalue_number(new XVar("id")))); ug_connection.exec((XVar)(sql)); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(new XVar("success", true)))); break; case "rename": sql = XVar.Clone(MVCFunctions.Concat("update ", wGroupTableName, " set ", ug_connection.addFieldWrappers(new XVar("Label")), "=", ug_connection.prepareString((XVar)(MVCFunctions.postvalue(new XVar("name")))), " where ", ug_connection.addFieldWrappers(new XVar("GroupID")), "=", CommonFunctions.postvalue_number(new XVar("id")))); ug_connection.exec((XVar)(sql)); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(new XVar("success", true)))); break; case "saveRights": var_error = new XVar(""); if (XVar.Pack(MVCFunctions.postvalue(new XVar("state")))) { dynamic allRights = XVar.Array(), delGroupId = null, qResult = null, realTables = XVar.Array(), rightsRow = null, wRightsTableName = null; allRights = XVar.Clone(XVar.Array()); sql = XVar.Clone(MVCFunctions.Concat("select ", ug_connection.addFieldWrappers(new XVar("GroupID")), ", ", ug_connection.addFieldWrappers(new XVar("TableName")), ", ", ug_connection.addFieldWrappers(new XVar("AccessMask")), " from ", wGroupTableName)); qResult = XVar.Clone(ug_connection.query((XVar)(sql))); while (XVar.Pack(rightsRow = XVar.Clone(qResult.fetchNumeric()))) { allRights.InitAndSetArrayItem(rightsRow, null); } wRightsTableName = XVar.Clone(ug_connection.addTableWrappers(new XVar("dbo.acceso_ugrights"))); delGroupId = new XVar(0); state = XVar.Clone(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("state"))))); foreach (KeyValuePair <XVar, dynamic> rightValue in allRights.GetEnumerator()) { dynamic groupIDInt = null; groupIDInt = XVar.Clone((int)rightValue.Value[0]); if (groupIDInt == delGroupId) { continue; } if (XVar.Pack(!(XVar)(state.KeyExists(groupIDInt)))) { sql = XVar.Clone(MVCFunctions.Concat("delete from ", wRightsTableName, " where ", ug_connection.addFieldWrappers(new XVar("GroupID")), "=", groupIDInt)); ug_connection.exec((XVar)(sql)); } else { if (XVar.Pack(!(XVar)(state[groupIDInt].KeyExists(GetTableId((XVar)(data[1])))))) { sql = XVar.Clone(MVCFunctions.Concat("delete from ", wRightsTableName, " where ", ug_connection.addFieldWrappers(new XVar("GroupID")), "=", groupIDInt, " and ", ug_connection.addFieldWrappers(new XVar("TableName")), "=", ug_connection.prepareString((XVar)(CommonFunctions.html_special_decode((XVar)(data[1])))))); ug_connection.exec((XVar)(sql)); } } } realTables = XVar.Clone(GetRealValues()); foreach (KeyValuePair <XVar, dynamic> groupRights in state.GetEnumerator()) { foreach (KeyValuePair <XVar, dynamic> mask in groupRights.Value.GetEnumerator()) { dynamic ins = null; if (XVar.Pack(!(XVar)(realTables.KeyExists(mask.Key)))) { continue; } ins = new XVar(true); foreach (KeyValuePair <XVar, dynamic> rightValue in allRights.GetEnumerator()) { if ((XVar)(rightValue.Value[0] == groupRights.Key) && (XVar)(rightValue.Value[1] == realTables[mask.Key])) { ins = new XVar(false); if (data[2] != mask.Value) { sql = XVar.Clone(MVCFunctions.Concat("update", wRightsTableName, " set ", ug_connection.addFieldWrappers(new XVar("AccessMask")), "=", ug_connection.prepareString((XVar)(mask.Value)), " where ", ug_connection.addFieldWrappers(new XVar("GroupID")), "=", groupRights.Key, " and ", ug_connection.addFieldWrappers(new XVar("TableName")), "=", ug_connection.prepareString((XVar)(CommonFunctions.html_special_decode((XVar)(realTables[mask.Key])))))); ug_connection.exec((XVar)(sql)); } } } if (XVar.Pack(ins)) { sql = XVar.Clone(MVCFunctions.Concat("insert into ", wRightsTableName, " (", ug_connection.addFieldWrappers(new XVar("TableName")), ", ", ug_connection.addFieldWrappers(new XVar("GroupID")), ", ", ug_connection.addFieldWrappers(new XVar("AccessMask")), ") ", "values (", ug_connection.prepareString((XVar)(CommonFunctions.html_special_decode((XVar)(realTables[mask.Key])))), ", ", groupRights.Key, ", ", ug_connection.prepareString((XVar)(mask.Value)), ")")); ug_connection.exec((XVar)(sql)); } var_error = XVar.Clone(ug_connection.lastError()); } } } getJSONResult((XVar)(var_error)); break; case "saveMembership": var_error = new XVar(""); groupId = XVar.Clone(MVCFunctions.postvalue(new XVar("group"))); realUsers = XVar.Clone(GetRealValues()); wMemebersTableName = XVar.Clone(ug_connection.addTableWrappers(new XVar("dbo.acceso_ugmembers"))); i = new XVar(0); for (; i < MVCFunctions.count(realUsers); i++) { if (realUsers[i] != XSession.Session["UserID"]) { sql = XVar.Clone(MVCFunctions.Concat("delete from ", wMemebersTableName, " where ", ug_connection.addFieldWrappers(new XVar("UserName")), "=%s")); } else { sql = XVar.Clone(MVCFunctions.Concat("delete from ", wMemebersTableName, " where ", ug_connection.addFieldWrappers(new XVar("UserName")), "=%s ", "and ", ug_connection.addFieldWrappers(new XVar("GroupID")), "<>-1")); } ug_connection.exec((XVar)(MVCFunctions.mysprintf((XVar)(sql), (XVar)(new XVar(0, ug_connection.prepareString((XVar)(CommonFunctions.html_special_decode((XVar)(realUsers[i]))))))))); } if (XVar.Pack(MVCFunctions.postvalue(new XVar("state")))) { state = XVar.Clone(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("state"))))); foreach (KeyValuePair <XVar, dynamic> users in state.GetEnumerator()) { foreach (KeyValuePair <XVar, dynamic> user in users.Value.GetEnumerator()) { if (XVar.Pack(!(XVar)(realUsers.KeyExists(user.Value)))) { continue; } sql = XVar.Clone(MVCFunctions.Concat("insert into ", wMemebersTableName, " (", ug_connection.addFieldWrappers(new XVar("UserName")), ", ", ug_connection.addFieldWrappers(new XVar("GroupID")), ") values (", ug_connection.prepareString((XVar)(CommonFunctions.html_special_decode((XVar)(realUsers[user.Value])))), ", ", users.Key, ")")); ug_connection.exec((XVar)(sql)); var_error = XVar.Clone(ug_connection.lastError()); } } } getJSONResult((XVar)(var_error)); break; } return(MVCFunctions.GetBuferContentAndClearBufer()); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult add() { try { dynamic id = null, pageMode = null, pageObject = null, var_params = XVar.Array(); XTempl xt; ABC_Voting_My_Voting_Variables.Apply(); CommonFunctions.add_nocache_headers(); CommonFunctions.InitLookupLinks(); if (XVar.Pack(!(XVar)(AddPage.processAddPageSecurity((XVar)(GlobalVars.strTableName))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } AddPage.handleBrokenRequest(); { TLayout t_layout = null; t_layout = new TLayout(new XVar("add2"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["all"] = XVar.Array(); t_layout.containers["all"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "add")); t_layout.containers["add"] = XVar.Array(); t_layout.containers["add"].Add(new XVar("name", "addheader", "block", "addheader", "substyle", 2)); t_layout.containers["add"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.containers["add"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "fields")); t_layout.containers["fields"] = XVar.Array(); t_layout.containers["fields"].Add(new XVar("name", "addfields", "block", "", "substyle", 1)); t_layout.containers["fields"].Add(new XVar("name", "addbuttons", "block", "addbuttons", "substyle", 2)); t_layout.skins["fields"] = "fields"; t_layout.skins["add"] = "1"; t_layout.skins["all"] = "empty"; t_layout.blocks["top"].Add("all"); GlobalVars.page_layouts["ABC_Voting_My_Voting_add"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } { TLayout t_layout = null; t_layout = new TLayout(new XVar("list6"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["center"] = XVar.Array(); t_layout.containers["message"] = XVar.Array(); t_layout.containers["message"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.skins["message"] = "2"; t_layout.blocks["center"].Add("message"); t_layout.containers["grid"] = XVar.Array(); t_layout.containers["grid"].Add(new XVar("name", "grid", "block", "grid_block", "substyle", 1)); t_layout.skins["grid"] = "grid"; t_layout.blocks["center"].Add("grid"); t_layout.containers["pagination"] = XVar.Array(); t_layout.containers["pagination"].Add(new XVar("name", "pagination", "block", "pagination_block", "substyle", 1)); t_layout.skins["pagination"] = "2"; t_layout.blocks["center"].Add("pagination"); t_layout.blocks["left"] = XVar.Array(); t_layout.containers["left"] = XVar.Array(); t_layout.containers["left"].Add(new XVar("name", "searchpanel", "block", "searchPanel", "substyle", 1)); t_layout.skins["left"] = "menu"; t_layout.blocks["left"].Add("left"); t_layout.blocks["top"] = XVar.Array(); t_layout.skins["master"] = "empty"; t_layout.blocks["top"].Add("master"); t_layout.containers["toplinks"] = XVar.Array(); t_layout.containers["toplinks"].Add(new XVar("name", "loggedas", "block", "security_block", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "toplinks_advsearch", "block", "asearch_link", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "toplinks_import", "block", "import_link", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "toplinks_export", "block", "export_link", "substyle", 1)); t_layout.containers["toplinks"].Add(new XVar("name", "printpanel", "block", "print_friendly", "substyle", 1)); t_layout.skins["toplinks"] = "2"; t_layout.blocks["top"].Add("toplinks"); t_layout.containers["hmenu"] = XVar.Array(); t_layout.containers["hmenu"].Add(new XVar("name", "hmenu", "block", "menu_block", "substyle", 1)); t_layout.skins["hmenu"] = "hmenu"; t_layout.blocks["top"].Add("hmenu"); t_layout.containers["search"] = XVar.Array(); t_layout.containers["search"].Add(new XVar("name", "search", "block", "searchform_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "search_buttons", "block", "searchformbuttons_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "search_saving_buttons", "block", "searchsaving_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "details_found", "block", "details_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "page_of", "block", "pages_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "recsperpage", "block", "recordspp_block", "substyle", 1)); t_layout.skins["search"] = "1"; t_layout.blocks["top"].Add("search"); t_layout.containers["recordcontrols"] = XVar.Array(); t_layout.containers["recordcontrols"].Add(new XVar("name", "recordcontrols_new", "block", "newrecord_controls_block", "substyle", 1)); t_layout.containers["recordcontrols"].Add(new XVar("name", "recordcontrol", "block", "record_controls_block", "substyle", 1)); t_layout.skins["recordcontrols"] = "2"; t_layout.blocks["top"].Add("recordcontrols"); GlobalVars.page_layouts["ABC_Voting_My_Voting_list"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } pageMode = XVar.Clone(AddPage.readAddModeFromRequest()); xt = XVar.UnPackXTempl(new XTempl()); id = XVar.Clone(MVCFunctions.postvalue(new XVar("id"))); id = XVar.Clone((XVar.Pack(MVCFunctions.intval((XVar)(id)) == 0) ? XVar.Pack(1) : XVar.Pack(id))); var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(id, "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(pageMode, "mode"); var_params.InitAndSetArrayItem(Constants.PAGE_ADD, "pageType"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("a")), "action"); var_params.InitAndSetArrayItem(false, "needSearchClauseObj"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("afteradd")), "afterAdd_id"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("mastertable")), "masterTable"); if (XVar.Pack(var_params["masterTable"])) { dynamic i = null; i = new XVar(1); var_params.InitAndSetArrayItem(XVar.Array(), "masterKeysReq"); while (XVar.Pack(MVCFunctions.REQUESTKeyExists(MVCFunctions.Concat("masterkey", i)))) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(MVCFunctions.Concat("masterkey", i)), "masterKeysReq", i); i++; } } var_params.InitAndSetArrayItem(MVCFunctions.postvalue((XVar)(MVCFunctions.Concat("value_captcha_", id))), "captchaValue"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("fromDashboard")), "fromDashboard"); var_params.InitAndSetArrayItem((XVar.Pack(var_params["fromDashboard"]) ? XVar.Pack(var_params["fromDashboard"]) : XVar.Pack(MVCFunctions.postvalue(new XVar("dashTName")))), "dashTName"); if (pageMode == Constants.ADD_INLINE) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("forLookup")), "forListPageLookup"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("screenWidth")), "screenWidth"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("screenHeight")), "screenHeight"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("orientation")), "orientation"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("masterpagetype")), "masterPageType"); } if ((XVar)(pageMode == Constants.ADD_ONTHEFLY) || (XVar)((XVar)(pageMode == Constants.ADD_INLINE) && (XVar)(MVCFunctions.postvalue(new XVar("forLookup"))))) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("table")), "lookupTable"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("field")), "lookupField"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("pageType")), "lookupPageType"); if (XVar.Pack(MVCFunctions.postvalue(new XVar("parentsExist")))) { var_params.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("parentCtrlsData")))), "parentCtrlsData"); } } GlobalVars.pageObject = XVar.Clone(new AddPage((XVar)(var_params))); GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public XVar checkduplicates() { try { dynamic _connection = null, data = XVar.Array(), denyChecking = null, fieldControlType = null, fieldName = null, fieldSQL = null, hasDuplicates = null, pageType = null, qResult = null, returnJSON = null, sql = null, tableName = null, value = null, where = null; ProjectSettings pSet; tableName = XVar.Clone(MVCFunctions.postvalue(new XVar("tableName"))); pageType = XVar.Clone(MVCFunctions.postvalue(new XVar("pageType"))); fieldName = XVar.Clone(MVCFunctions.postvalue(new XVar("fieldName"))); fieldControlType = XVar.Clone(MVCFunctions.postvalue(new XVar("fieldControlType"))); value = XVar.Clone(MVCFunctions.postvalue(new XVar("value"))); if (XVar.Pack(!(XVar)(CommonFunctions.checkTableName((XVar)(tableName))))) { MVCFunctions.Echo(new XVar(0)); return(MVCFunctions.GetBuferContentAndClearBufer()); } Assembly.GetExecutingAssembly().GetType(MVCFunctions.Concat("runnerDotNet.", MVCFunctions.Concat("", tableName, ""), "_Variables")).InvokeMember("Apply", BindingFlags.InvokeMethod, null, null, null); if ((XVar)(pageType != Constants.PAGE_REGISTER) && (XVar)((XVar)(!(XVar)(CommonFunctions.isLogged())) || (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search")))))) { returnJSON = XVar.Clone(new XVar("success", false, "error", MVCFunctions.Concat("Error: You have not permissions to read the ", tableName, " table's data"))); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON))); return(MVCFunctions.GetBuferContentAndClearBufer()); } _connection = XVar.Clone(GlobalVars.cman.byTable((XVar)(GlobalVars.strTableName))); pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(GlobalVars.strTableName), (XVar)(pageType))); denyChecking = XVar.Clone(pSet.allowDuplicateValues((XVar)(fieldName))); if (XVar.Pack(denyChecking)) { returnJSON = XVar.Clone(new XVar("success", false, "error", "Duplicated values are allowed")); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON))); return(MVCFunctions.GetBuferContentAndClearBufer()); } GlobalVars.cipherer = XVar.Clone(new RunnerCipherer((XVar)(GlobalVars.strTableName), (XVar)(pSet))); if (XVar.Pack(GlobalVars.cipherer.isFieldEncrypted((XVar)(fieldName)))) { value = XVar.Clone(GlobalVars.cipherer.MakeDBValue((XVar)(fieldName), (XVar)(value), (XVar)(fieldControlType), new XVar(true))); } else { value = XVar.Clone(CommonFunctions.make_db_value((XVar)(fieldName), (XVar)(value), (XVar)(fieldControlType), new XVar(""), (XVar)(GlobalVars.strTableName))); } if (value == "null") { fieldSQL = XVar.Clone(RunnerPage._getFieldSQL((XVar)(fieldName), (XVar)(_connection), (XVar)(pSet))); } else { fieldSQL = XVar.Clone(RunnerPage._getFieldSQLDecrypt((XVar)(fieldName), (XVar)(_connection), (XVar)(pSet), (XVar)(GlobalVars.cipherer))); } where = XVar.Clone(MVCFunctions.Concat(fieldSQL, (XVar.Pack(value == "null") ? XVar.Pack(" is ") : XVar.Pack("=")), value)); sql = XVar.Clone(MVCFunctions.Concat("SELECT count(*) from ", _connection.addTableWrappers((XVar)(pSet.getOriginalTableName())), " where ", where)); qResult = XVar.Clone(_connection.query((XVar)(sql))); if ((XVar)(!(XVar)(qResult)) || (XVar)(!(XVar)(data = XVar.Clone(qResult.fetchNumeric())))) { returnJSON = XVar.Clone(new XVar("success", false, "error", "Error: Wrong SQL query")); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON))); return(MVCFunctions.GetBuferContentAndClearBufer()); } hasDuplicates = XVar.Clone((XVar.Pack(data[0]) ? XVar.Pack(true) : XVar.Pack(false))); returnJSON = XVar.Clone(new XVar("success", true, "hasDuplicates", hasDuplicates, "error", "")); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON))); return(MVCFunctions.GetBuferContentAndClearBufer()); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult view() { try { dynamic keys = XVar.Array(), pageMode = null, pageObject = null, var_params = XVar.Array(); XTempl xt; ABC_Voting_Batch_Create_Variables.Apply(); CommonFunctions.add_nocache_headers(); if (XVar.Pack(!(XVar)(ViewPage.processEditPageSecurity((XVar)(GlobalVars.strTableName))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } { TLayout t_layout = null; t_layout = new TLayout(new XVar("view2"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["all"] = XVar.Array(); t_layout.containers["all"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "main")); t_layout.containers["main"] = XVar.Array(); t_layout.containers["main"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "view")); t_layout.containers["view"] = XVar.Array(); t_layout.containers["view"].Add(new XVar("name", "viewheader", "block", "viewheader", "substyle", 2)); t_layout.containers["view"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "fields")); t_layout.containers["fields"] = XVar.Array(); t_layout.containers["fields"].Add(new XVar("name", "viewfields", "block", "", "substyle", 1)); t_layout.containers["fields"].Add(new XVar("name", "viewbuttons", "block", "viewbuttons", "substyle", 2)); t_layout.skins["fields"] = "fields"; t_layout.skins["view"] = "1"; t_layout.skins["main"] = "empty"; t_layout.skins["all"] = "empty"; t_layout.blocks["top"].Add("all"); GlobalVars.page_layouts["ABC_Voting_Batch_Create_view"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } pageMode = XVar.Clone(ViewPage.readViewModeFromRequest()); xt = XVar.UnPackXTempl(new XTempl()); keys = XVar.Clone(XVar.Array()); keys.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("editid1")), "id"); keys.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("editid2")), "record"); var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("id")), "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(keys, "keys"); var_params.InitAndSetArrayItem(pageMode, "mode"); var_params.InitAndSetArrayItem(Constants.PAGE_VIEW, "pageType"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem(!XVar.Equals(XVar.Pack(MVCFunctions.postvalue(new XVar("mvcPDF"))), XVar.Pack("")), "pdfMode"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("mastertable")), "masterTable"); if (pageMode == Constants.VIEW_DASHBOARD) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("table")), "dashTName"); if (XVar.Pack(MVCFunctions.postvalue(new XVar("mapRefresh")))) { var_params.InitAndSetArrayItem(true, "mapRefresh"); var_params.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("vpCoordinates")))), "vpCoordinates"); } } if (pageMode == Constants.VIEW_POPUP) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashTName")), "dashTName"); } if (XVar.Pack(var_params["masterTable"])) { var_params.InitAndSetArrayItem(ViewPage.processMasterKeys(), "masterKeysReq"); } GlobalVars.pageObject = XVar.Clone(new ViewPage((XVar)(var_params))); GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult export() { try { dynamic pageObject = null, strtablename = null, var_params = XVar.Array(); XTempl xt; MVCFunctions.Header("Expires", "Thu, 01 Jan 1970 00:00:01 GMT"); VISTOBUENO_JEFEDEPARTAMENTO_Variables.Apply(); if (XVar.Pack(!(XVar)(Security.processPageSecurity((XVar)(strtablename), new XVar("P"))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } { TLayout t_layout = null; t_layout = new TLayout(new XVar("export_bootstrap"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "VISTOBUENO_JEFEDEPARTAMENTO_export"; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["page"] = XVar.Array(); t_layout.containers["page"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "page_1")); t_layout.containers["page_1"] = XVar.Array(); t_layout.containers["page_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "panel")); t_layout.containers["panel"] = XVar.Array(); t_layout.containers["panel"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "header")); t_layout.containers["header"] = XVar.Array(); t_layout.containers["header"].Add(new XVar("name", "exportheader", "block", "exportheader", "substyle", 1)); t_layout.skins["header"] = ""; t_layout.containers["panel"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "body")); t_layout.containers["body"] = XVar.Array(); t_layout.containers["body"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "range")); t_layout.containers["range"] = XVar.Array(); t_layout.containers["range"].Add(new XVar("name", "bsexprange", "block", "range_block", "substyle", 1)); t_layout.skins["range"] = ""; t_layout.containers["body"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "fields")); t_layout.containers["fields"] = XVar.Array(); t_layout.containers["fields"].Add(new XVar("name", "bsexportchoosefields", "block", "choosefields", "substyle", 1)); t_layout.skins["fields"] = ""; t_layout.containers["body"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "fields_1")); t_layout.containers["fields_1"] = XVar.Array(); t_layout.containers["fields_1"].Add(new XVar("name", "bsexportformat", "block", "exportformat", "substyle", 1)); t_layout.skins["fields_1"] = ""; t_layout.containers["body"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "fields_2")); t_layout.containers["fields_2"] = XVar.Array(); t_layout.containers["fields_2"].Add(new XVar("name", "bsexpoutput", "block", "", "substyle", 1)); t_layout.skins["fields_2"] = ""; t_layout.containers["body"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "buttons")); t_layout.containers["buttons"] = XVar.Array(); t_layout.containers["buttons"].Add(new XVar("name", "bsexpbuttons", "block", "exportbuttons", "substyle", 2)); t_layout.skins["buttons"] = ""; t_layout.skins["body"] = ""; t_layout.skins["panel"] = ""; t_layout.skins["page_1"] = ""; t_layout.skins["page"] = ""; t_layout.blocks["top"].Add("page"); GlobalVars.page_layouts["VISTOBUENO_JEFEDEPARTAMENTO_export"] = t_layout; } xt = XVar.UnPackXTempl(new XTempl()); var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(CommonFunctions.postvalue_number(new XVar("id")), "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem(Constants.PAGE_EXPORT, "pageType"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("page")), "pageName"); if ((XVar)(!(XVar)(GlobalVars.eventObj.exists(new XVar("ListGetRowCount")))) && (XVar)(!(XVar)(GlobalVars.eventObj.exists(new XVar("ListQuery"))))) { var_params.InitAndSetArrayItem(false, "needSearchClauseObj"); } var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("exportFields")), "selectedFields"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("type")), "exportType"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("a")), "action"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("records")), "records"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("selection")), "selection"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("delimiter")), "csvDelimiter"); if (MVCFunctions.postvalue(new XVar("txtformatting")) == "raw") { var_params.InitAndSetArrayItem(true, "useRawValues"); } var_params.InitAndSetArrayItem(ExportPage.readModeFromRequest(), "mode"); GlobalVars.pageObject = XVar.Clone(new ExportPage((XVar)(var_params))); GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public XVar mfhandler() { try { dynamic _connection = null, field = null, fileName = null, formStamp = null, fsFileName = null, fsize = null, ftype = null, havePermission = null, iconShowed = null, isDBFile = null, isPDF = null, outputAsAttachment = null, pageType = null, pdf = null, requestAction = null, sessionFile = XVar.Array(), upload_handler = null, value = null, var_params = XVar.Array(); ProjectSettings pSet; isPDF = new XVar(false); if (XVar.Pack(isPDF)) { GlobalVars.strTableName = XVar.Clone(var_params["table"]); field = XVar.Clone(var_params["field"]); pageType = XVar.Clone(var_params["pageType"]); outputAsAttachment = new XVar(false); } else { GlobalVars.strTableName = XVar.Clone(MVCFunctions.postvalue(new XVar("table"))); field = XVar.Clone(MVCFunctions.postvalue(new XVar("field"))); pageType = XVar.Clone(MVCFunctions.postvalue(new XVar("pageType"))); outputAsAttachment = XVar.Clone(MVCFunctions.postvalue(new XVar("nodisp")) != 1); } if (GlobalVars.strTableName == XVar.Pack("")) { if (XVar.Pack(!(XVar)(isPDF))) { MVCFunctions.Echo("<p>No table name received</p>"); } return(MVCFunctions.GetBuferContentAndClearBufer()); } if (field == XVar.Pack("")) { if (XVar.Pack(!(XVar)(isPDF))) { MVCFunctions.Echo("<p>No field name received</p>"); } return(MVCFunctions.GetBuferContentAndClearBufer()); } if (XVar.Pack(!(XVar)(CommonFunctions.GetTableURL((XVar)(GlobalVars.strTableName))))) { MVCFunctions.Echo(new XVar(0)); return(MVCFunctions.GetBuferContentAndClearBufer()); } if (XVar.Pack(isPDF)) { requestAction = new XVar("GET"); } else { requestAction = XVar.Clone(MVCFunctions.postvalue("_action")); } _connection = XVar.Clone(GlobalVars.cman.byTable((XVar)(GlobalVars.strTableName))); pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(GlobalVars.strTableName), (XVar)(pageType))); if (requestAction == "POST") { if ((XVar)((XVar)((XVar)((XVar)((XVar)(pageType == Constants.PAGE_ADD) && (XVar)(!(XVar)(pSet.appearOnAddPage((XVar)(field))))) && (XVar)(!(XVar)(pSet.appearOnInlineAdd((XVar)(field))))) || (XVar)((XVar)((XVar)(pageType == Constants.PAGE_EDIT) && (XVar)(!(XVar)(pSet.appearOnEditPage((XVar)(field))))) && (XVar)(!(XVar)(pSet.appearOnInlineEdit((XVar)(field)))))) || (XVar)((XVar)(pageType == Constants.PAGE_REGISTER) && (XVar)(!(XVar)(pSet.appearOnRegisterOrSearchPage((XVar)(field), (XVar)(pageType)))))) || (XVar)((XVar)((XVar)(pageType != Constants.PAGE_ADD) && (XVar)(pageType != Constants.PAGE_EDIT)) && (XVar)(pageType != Constants.PAGE_REGISTER))) { MVCFunctions.Echo(new XVar("You have no permissions for this action")); return(MVCFunctions.GetBuferContentAndClearBufer()); } } else { if ((XVar)(!(XVar)(pSet.checkFieldPermissions((XVar)(field)))) && (XVar)((XVar)(pageType != Constants.PAGE_ADD) || (XVar)((XVar)(!(XVar)(pSet.appearOnAddPage((XVar)(field)))) && (XVar)(!(XVar)(pSet.appearOnInlineAdd((XVar)(field))))))) { MVCFunctions.Echo(new XVar("You have no permissions for this action")); return(MVCFunctions.GetBuferContentAndClearBufer()); } } if (XVar.Pack(!(XVar)(isPDF))) { CommonFunctions.add_nocache_headers(); } Assembly.GetExecutingAssembly().GetType(MVCFunctions.Concat("runnerDotNet.", MVCFunctions.Concat("", CommonFunctions.GetTableURL((XVar)(GlobalVars.strTableName)), ""), "_Variables")).InvokeMember("Apply", BindingFlags.InvokeMethod, null, null, null); if (requestAction == "POST") { havePermission = XVar.Clone((XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Add"))) || (XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Edit")))); } else { havePermission = XVar.Clone(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search"))); } if ((XVar)((XVar)(!(XVar)(CommonFunctions.isLogged())) && (XVar)(pageType != Constants.PAGE_REGISTER)) || (XVar)(!(XVar)(havePermission))) { MVCFunctions.HeaderRedirect(new XVar("login"), new XVar(""), new XVar("message=expired")); return(MVCFunctions.GetBuferContentAndClearBufer()); } upload_handler = XVar.Clone(new UploadHandler((XVar)(CommonFunctions.getOptionsForMultiUpload((XVar)(pSet), (XVar)(field))))); upload_handler.pSet = XVar.Clone(pSet); upload_handler.field = XVar.Clone(field); upload_handler.table = XVar.Clone(GlobalVars.strTableName); upload_handler.pageType = XVar.Clone(pageType); switch (((XVar)requestAction).ToString()) { case "DELETE": CommonFunctions.printMFHandlerHeaders(); formStamp = XVar.Clone(MVCFunctions.postvalue(new XVar("formStamp"))); if (formStamp != XVar.Pack("")) { upload_handler.formStamp = XVar.Clone(formStamp); upload_handler.delete(); } break; case "POST": CommonFunctions.printMFHandlerHeaders(); formStamp = XVar.Clone(MVCFunctions.postvalue(new XVar("formStamp"))); if (formStamp != XVar.Pack("")) { upload_handler.formStamp = XVar.Clone(formStamp); upload_handler.post(); } break; case "GET": default: if (XVar.Pack(isPDF)) { isDBFile = XVar.Clone(var_params.KeyExists("filename")); fileName = XVar.Clone((XVar.Pack(var_params.KeyExists("file")) ? XVar.Pack(var_params["file"]) : XVar.Pack(var_params["filename"]))); } else { isDBFile = XVar.Clone(MVCFunctions.postvalue(new XVar("filename")) != ""); fileName = XVar.Clone((XVar.Pack(MVCFunctions.postvalue(new XVar("file")) != "") ? XVar.Pack(MVCFunctions.postvalue(new XVar("file"))) : XVar.Pack(MVCFunctions.postvalue(new XVar("filename"))))); formStamp = XVar.Clone(MVCFunctions.postvalue(new XVar("fkey"))); } if (fileName == XVar.Pack("")) { MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } sessionFile = new XVar(null); fsFileName = new XVar(""); if ((XVar)((XVar)(!(XVar)(isDBFile)) && (XVar)(formStamp != XVar.Pack(""))) && (XVar)(XSession.Session[MVCFunctions.Concat("mupload_", formStamp)].KeyExists(fileName))) { sessionFile = XVar.Clone(XSession.Session[MVCFunctions.Concat("mupload_", formStamp)][fileName]["file"]); } else { dynamic i = null, keys = XVar.Array(), qResult = null, queryObj = null, strWhereClause = null, tKeys = XVar.Array(); keys = XVar.Clone(XVar.Array()); tKeys = XVar.Clone(pSet.getTableKeys()); i = new XVar(0); for (; i < MVCFunctions.count(tKeys); i++) { if (XVar.Pack(isPDF)) { keys.InitAndSetArrayItem(var_params[MVCFunctions.Concat("key", i + 1)], tKeys[i]); } else { keys.InitAndSetArrayItem(MVCFunctions.postvalue((XVar)(MVCFunctions.Concat("key", i + 1))), tKeys[i]); } } strWhereClause = XVar.Clone(CommonFunctions.KeyWhere((XVar)(keys))); if (pSet.getAdvancedSecurityType() != Constants.ADVSECURITY_ALL) { strWhereClause = XVar.Clone(CommonFunctions.whereAdd((XVar)(strWhereClause), (XVar)(CommonFunctions.SecuritySQL(new XVar("Search"))))); } queryObj = XVar.Clone(pSet.getQueryObject()); if (XVar.Pack(!(XVar)(queryObj.HasGroupBy()))) { queryObj.RemoveAllFieldsExcept((XVar)(pSet.getFieldIndex((XVar)(field)))); } qResult = XVar.Clone(_connection.query((XVar)(queryObj.gSQLWhere((XVar)(strWhereClause))))); if (XVar.Pack(isDBFile)) { if (XVar.Pack(qResult)) { dynamic data = XVar.Array(); data = XVar.Clone(qResult.fetchAssoc()); if (XVar.Pack(data)) { value = XVar.Clone(_connection.stripSlashesBinary((XVar)(data[field]))); } } } else { dynamic row = XVar.Array(); GlobalVars.cipherer = XVar.Clone(new RunnerCipherer((XVar)(GlobalVars.strTableName), (XVar)(pSet))); row = XVar.Clone(GlobalVars.cipherer.DecryptFetchedArray((XVar)(qResult.fetchAssoc()))); if (XVar.Pack(row)) { dynamic filesArray = XVar.Array(); filesArray = XVar.Clone(MVCFunctions.my_json_decode((XVar)(row[field]))); if ((XVar)(!(XVar)(MVCFunctions.is_array((XVar)(filesArray)))) || (XVar)(MVCFunctions.count(filesArray) == 0)) { if (row[field] == "") { filesArray = XVar.Clone(XVar.Array()); } else { dynamic uploadedFile = XVar.Array(); uploadedFile = XVar.Clone(upload_handler.get_file_object((XVar)(row[field]))); if (XVar.Pack(uploadedFile == null)) { filesArray = XVar.Clone(XVar.Array()); } else { filesArray = XVar.Clone(new XVar(0, MVCFunctions.my_json_decode((XVar)(MVCFunctions.my_json_encode((XVar)(uploadedFile)))))); } } } foreach (KeyValuePair <XVar, dynamic> uploadedFile in filesArray.GetEnumerator()) { if (uploadedFile.Value["usrName"] == fileName) { sessionFile = XVar.Clone(uploadedFile.Value); break; } } } } } iconShowed = new XVar(false); if (XVar.Pack(isDBFile)) { ftype = new XVar(""); if (pSet.getViewFormat((XVar)(field)) == Constants.FORMAT_DATABASE_IMAGE) { if (XVar.Pack(!(XVar)(value))) { value = XVar.Clone(MVCFunctions.myfile_get_contents(new XVar("images/no_image.gif"))); } ftype = XVar.Clone(MVCFunctions.SupposeImageType((XVar)(value))); } if (XVar.Pack(!(XVar)(ftype))) { ftype = XVar.Clone(CommonFunctions.getContentTypeByExtension((XVar)(MVCFunctions.substr((XVar)(fileName), (XVar)(MVCFunctions.strrpos((XVar)(fileName), new XVar("."))))))); } fsize = XVar.Clone(MVCFunctions.strlen_bin((XVar)(value))); } else { if (sessionFile != null) { dynamic isSRC = null, isThumbnail = null; isThumbnail = new XVar(false); isSRC = new XVar(false); if (XVar.Pack(isPDF)) { isThumbnail = XVar.Clone(var_params.KeyExists("thumbnail")); isSRC = XVar.Clone(var_params.KeyExists("src")); } else { isThumbnail = XVar.Clone(MVCFunctions.postvalue(new XVar("thumbnail")) != ""); isSRC = XVar.Clone(MVCFunctions.postvalue(new XVar("src")) == 1); } if (MVCFunctions.postvalue(new XVar("icon")) != "") { fsFileName = XVar.Clone(MVCFunctions.Concat("images/icons/", CommonFunctions.getIconByFileType((XVar)(sessionFile["type"]), (XVar)(sessionFile["name"])))); fsize = XVar.Clone(MVCFunctions.filesize((XVar)(MVCFunctions.getabspath((XVar)(fsFileName))))); ftype = new XVar("image/png"); } else { if ((XVar)((XVar)(isThumbnail) && (XVar)(sessionFile["thumbnail"])) && (XVar)(MVCFunctions.GDExist())) { fsFileName = XVar.Clone(sessionFile["thumbnail"]); fsize = XVar.Clone(sessionFile["thumbnail_size"]); ftype = XVar.Clone(sessionFile["thumbnail_type"]); } else { if ((XVar)((XVar)(false) && (XVar)((XVar)(pageType == Constants.PAGE_EDIT) || (XVar)(pageType == Constants.PAGE_ADD))) && (XVar)(isSRC)) { iconShowed = new XVar(true); fsFileName = XVar.Clone(MVCFunctions.Concat("images/icons/", CommonFunctions.getIconByFileType((XVar)(sessionFile["type"]), (XVar)(sessionFile["name"])))); fsize = XVar.Clone(MVCFunctions.filesize((XVar)(MVCFunctions.getabspath((XVar)(fsFileName))))); ftype = new XVar("image/png"); } else { fsFileName = XVar.Clone(sessionFile["name"]); fsize = XVar.Clone(sessionFile["size"]); ftype = XVar.Clone(sessionFile["type"]); } } } } } if ((XVar)((XVar)(isDBFile) && (XVar)(value)) || (XVar)(fsFileName != XVar.Pack(""))) { dynamic norange = null; if (XVar.Pack(!(XVar)(isDBFile))) { if ((XVar)((XVar)(!(XVar)(pSet.isAbsolute((XVar)(field)))) && (XVar)(!(XVar)(MVCFunctions.isAbsolutePath((XVar)(fsFileName))))) || (XVar)(iconShowed)) { fsFileName = XVar.Clone(MVCFunctions.getabspath((XVar)(fsFileName))); } if (XVar.Pack(!(XVar)(MVCFunctions.myfile_exists((XVar)(fsFileName))))) { fsFileName = XVar.Clone(MVCFunctions.getabspath(new XVar("images/no_image.gif"))); fsize = XVar.Clone(MVCFunctions.filesize((XVar)(fsFileName))); ftype = new XVar("image/gif"); } } if (XVar.Pack(isPDF)) { dynamic file = null; if (XVar.Pack(isDBFile)) { file = XVar.Clone(value); } else { file = XVar.Clone(MVCFunctions.myfile_get_contents((XVar)(fsFileName))); } return(MVCFunctions.GetBuferContentAndClearBufer()); } norange = XVar.Clone(MVCFunctions.postvalue(new XVar("norange")) == 1); if (MVCFunctions.postvalue(new XVar("norange")) == 1) { MVCFunctions.Header("Accept-Ranges", "none"); MVCFunctions.Header("Cache-Control", "private"); MVCFunctions.Header((XVar)(MVCFunctions.Concat("Content-Type: ", ftype))); MVCFunctions.Header("Access-Control-Allow-Methods", "HEAD, GET, POST"); if (XVar.Pack(outputAsAttachment)) { MVCFunctions.Header((XVar)(MVCFunctions.Concat("Content-Disposition: attachment;Filename=\"", fileName, "\""))); } MVCFunctions.SendContentLength((XVar)(fsize)); if (MVCFunctions.GetServerVariable("REQUEST_METHOD") == "HEAD") { MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } if (XVar.Pack(isDBFile)) { MVCFunctions.echoBinary((XVar)(value)); } else { MVCFunctions.printfile((XVar)(fsFileName)); } } else { dynamic httpRange = null, printContentLength = null, range = null, range_orig = null, seek_end = null, seek_start = null, size_unit = null, tmparr = XVar.Array(); size_unit = new XVar(""); range_orig = new XVar(""); httpRange = XVar.Clone(MVCFunctions.GetHttpRange()); if (XVar.Pack(MVCFunctions.preg_match(new XVar("/^bytes=((\\d*-\\d*,? ?)+)$/"), (XVar)(httpRange)))) { tmparr = XVar.Clone(MVCFunctions.explode(new XVar("="), (XVar)(httpRange))); size_unit = XVar.Clone(tmparr[0]); range_orig = XVar.Clone(tmparr[1]); } if (size_unit == "bytes") { if (!XVar.Equals(XVar.Pack(MVCFunctions.strpos((XVar)(range_orig), new XVar(","))), XVar.Pack(false))) { dynamic extra_ranges = null; tmparr = XVar.Clone(MVCFunctions.explode(new XVar(","), (XVar)(range_orig))); range = XVar.Clone(tmparr[0]); extra_ranges = XVar.Clone(tmparr[1]); } else { range = XVar.Clone(range_orig); } } else { range = new XVar("-"); } tmparr = XVar.Clone(MVCFunctions.explode(new XVar("-"), (XVar)(range))); seek_start = XVar.Clone(tmparr[0]); seek_end = XVar.Clone(tmparr[1]); seek_end = XVar.Clone((XVar.Pack(MVCFunctions.strlen((XVar)(seek_end)) == 0) ? XVar.Pack(fsize - 1) : XVar.Pack(MVCFunctions.min((XVar)(MVCFunctions.abs((XVar)(MVCFunctions.intval((XVar)(seek_end))))), (XVar)(fsize - 1))))); seek_start = XVar.Clone((XVar.Pack((XVar)(MVCFunctions.strlen((XVar)(seek_start)) == 0) || (XVar)(seek_end < MVCFunctions.abs((XVar)(MVCFunctions.intval((XVar)(seek_start)))))) ? XVar.Pack(0) : XVar.Pack(MVCFunctions.max((XVar)(MVCFunctions.abs((XVar)(MVCFunctions.intval((XVar)(seek_start))))), new XVar(0))))); if ((XVar)(XVar.Pack(0) < seek_start) || (XVar)(seek_end < fsize - 1)) { MVCFunctions.Header(new XVar("HTTP/1.1 206 Partial Content")); } MVCFunctions.Header("Accept-Ranges", "bytes"); MVCFunctions.Header((XVar)(MVCFunctions.Concat("Content-Range: bytes ", seek_start, "-", seek_end, "/", fsize))); if (XVar.Pack(outputAsAttachment)) { MVCFunctions.Header((XVar)(MVCFunctions.Concat("Content-Disposition: attachment;Filename=\"", fileName, "\""))); } printContentLength = new XVar(true); if (XVar.Pack(printContentLength)) { MVCFunctions.Header((XVar)(MVCFunctions.Concat("Content-Length: ", (seek_end - seek_start) + 1))); } MVCFunctions.Header("Cache-Control", "cache, must-revalidate"); MVCFunctions.Header("Pragma", "public"); MVCFunctions.Header((XVar)(MVCFunctions.Concat("Content-Type: ", ftype))); if (MVCFunctions.GetServerVariable("REQUEST_METHOD") == "HEAD") { MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } if (XVar.Pack(isDBFile)) { MVCFunctions.echoBinaryPartial((XVar)(value), (XVar)(seek_start), (XVar)(seek_end)); } else { MVCFunctions.printfileByRange((XVar)(fsFileName), (XVar)(seek_start), (XVar)(seek_end)); } } } break; } MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult add() { try { dynamic id = null, pageMode = null, pageObject = null, var_params = XVar.Array(); XTempl xt; Licencias_sin_goce_sueldo_Variables.Apply(); CommonFunctions.add_nocache_headers(); CommonFunctions.InitLookupLinks(); if (XVar.Pack(!(XVar)(AddPage.processAddPageSecurity((XVar)(GlobalVars.strTableName))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } AddPage.handleBrokenRequest(); { TLayout t_layout = null; t_layout = new TLayout(new XVar("add_bootstrap"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "Licencias_sin_goce_sueldo_add"; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["editpage"] = XVar.Array(); t_layout.containers["editpage"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "header")); t_layout.containers["header"] = XVar.Array(); t_layout.containers["header"].Add(new XVar("name", "addheader", "block", "addheader", "substyle", 1)); t_layout.skins["header"] = ""; t_layout.containers["editpage"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "message")); t_layout.containers["message"] = XVar.Array(); t_layout.containers["message"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.skins["message"] = ""; t_layout.containers["editpage"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "steps")); t_layout.containers["steps"] = XVar.Array(); t_layout.containers["steps"].Add(new XVar("name", "multistep_nav_add", "block", "", "substyle", 1)); t_layout.skins["steps"] = ""; t_layout.skins["editpage"] = ""; t_layout.blocks["top"].Add("editpage"); t_layout.containers["fields"] = XVar.Array(); t_layout.containers["fields"].Add(new XVar("name", "addfields", "block", "", "substyle", 1)); t_layout.skins["fields"] = ""; t_layout.blocks["top"].Add("fields"); t_layout.containers["bottombuttons"] = XVar.Array(); t_layout.containers["bottombuttons"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "buttons")); t_layout.containers["buttons"] = XVar.Array(); t_layout.containers["buttons"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "leftbuttons")); t_layout.containers["leftbuttons"] = XVar.Array(); t_layout.containers["leftbuttons"].Add(new XVar("name", "addbuttons", "block", "addbuttons", "substyle", 1)); t_layout.skins["leftbuttons"] = ""; t_layout.skins["buttons"] = ""; t_layout.skins["bottombuttons"] = ""; t_layout.blocks["top"].Add("bottombuttons"); GlobalVars.page_layouts["Licencias_sin_goce_sueldo_add"] = t_layout; } { TLayout t_layout = null; t_layout = new TLayout(new XVar("list_bootstrap1"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "Licencias_sin_goce_sueldo_list"; t_layout.blocks["center"] = XVar.Array(); t_layout.containers["gridcontrols"] = XVar.Array(); t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "add_delete")); t_layout.containers["add_delete"] = XVar.Array(); t_layout.containers["add_delete"].Add(new XVar("name", "add", "block", "newrecord_controls_block", "substyle", 1)); t_layout.containers["add_delete"].Add(new XVar("name", "recordcontrol", "block", "record_controls_block", "substyle", 1)); t_layout.skins["add_delete"] = ""; t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "gridinfo")); t_layout.containers["gridinfo"] = XVar.Array(); t_layout.containers["gridinfo"].Add(new XVar("name", "details_found", "block", "details_found", "substyle", 1)); t_layout.containers["gridinfo"].Add(new XVar("name", "printpanel", "block", "print_friendly", "substyle", 1)); t_layout.containers["gridinfo"].Add(new XVar("name", "bsfieldhidepanel", "block", "field_hide_panel", "substyle", 1)); t_layout.skins["gridinfo"] = ""; t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "gridinfo_sort")); t_layout.containers["gridinfo_sort"] = XVar.Array(); t_layout.containers["gridinfo_sort"].Add(new XVar("name", "reorder_records", "block", "reorder_records", "substyle", 1)); t_layout.skins["gridinfo_sort"] = ""; t_layout.skins["gridcontrols"] = ""; t_layout.blocks["center"].Add("gridcontrols"); t_layout.containers["tabs"] = XVar.Array(); t_layout.containers["tabs"].Add(new XVar("name", "bsgrid_tabs", "block", "grid_tabs", "substyle", 1)); t_layout.skins["tabs"] = ""; t_layout.blocks["center"].Add("tabs"); t_layout.containers["messagerow"] = XVar.Array(); t_layout.containers["messagerow"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "message")); t_layout.containers["message"] = XVar.Array(); t_layout.containers["message"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.skins["message"] = ""; t_layout.skins["messagerow"] = ""; t_layout.blocks["center"].Add("messagerow"); t_layout.containers["center"] = XVar.Array(); t_layout.containers["center"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "grid")); t_layout.containers["grid"] = XVar.Array(); t_layout.containers["grid"].Add(new XVar("name", "grid", "block", "grid_block", "substyle", 1)); t_layout.skins["grid"] = ""; t_layout.skins["center"] = ""; t_layout.blocks["center"].Add("center"); t_layout.containers["pagination"] = XVar.Array(); t_layout.containers["pagination"].Add(new XVar("name", "pagination", "block", "pagination_block", "substyle", 1)); t_layout.skins["pagination"] = ""; t_layout.blocks["center"].Add("pagination"); t_layout.blocks["left"] = XVar.Array(); t_layout.containers["left"] = XVar.Array(); t_layout.containers["left"].Add(new XVar("name", "searchpanel", "block", "searchPanel", "substyle", 1)); t_layout.containers["left"].Add(new XVar("name", "filterpanel", "block", "filterPanel", "substyle", 1)); t_layout.skins["left"] = ""; t_layout.blocks["left"].Add("left"); t_layout.blocks["top"] = XVar.Array(); t_layout.containers["menu"] = XVar.Array(); t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "hdr")); t_layout.containers["hdr"] = XVar.Array(); t_layout.containers["hdr"].Add(new XVar("name", "logo", "block", "logo_block", "substyle", 1)); t_layout.containers["hdr"].Add(new XVar("name", "bsnavbarcollapse", "block", "collapse_block", "substyle", 1)); t_layout.skins["hdr"] = ""; t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "menu_1")); t_layout.containers["menu_1"] = XVar.Array(); t_layout.containers["menu_1"].Add(new XVar("name", "hmenu", "block", "menu_block", "substyle", 1)); t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "more")); t_layout.containers["more"] = XVar.Array(); t_layout.containers["more"].Add(new XVar("name", "morebutton", "block", "more_list", "substyle", 1)); t_layout.containers["more"].Add(new XVar("name", "loggedas", "block", "security_block", "substyle", 1)); t_layout.skins["more"] = ""; t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "more_1")); t_layout.containers["more_1"] = XVar.Array(); t_layout.containers["more_1"].Add(new XVar("name", "search", "block", "searchform_block", "substyle", 1)); t_layout.skins["more_1"] = ""; t_layout.skins["menu_1"] = ""; t_layout.skins["menu"] = ""; t_layout.blocks["top"].Add("menu"); t_layout.blocks["topmiddle"] = XVar.Array(); t_layout.containers["breadcrumbs"] = XVar.Array(); t_layout.containers["breadcrumbs"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "bc")); t_layout.containers["bc"] = XVar.Array(); t_layout.containers["bc"].Add(new XVar("name", "breadcrumbs", "block", "breadcrumbs", "substyle", 1)); t_layout.skins["bc"] = ""; t_layout.skins["breadcrumbs"] = ""; t_layout.blocks["topmiddle"].Add("breadcrumbs"); t_layout.containers["masterinfo"] = XVar.Array(); t_layout.containers["masterinfo"].Add(new XVar("name", "masterinfo", "block", "mastertable_block", "substyle", 1)); t_layout.skins["masterinfo"] = ""; t_layout.blocks["topmiddle"].Add("masterinfo"); GlobalVars.page_layouts["Licencias_sin_goce_sueldo_list"] = t_layout; } pageMode = XVar.Clone(AddPage.readAddModeFromRequest()); xt = XVar.UnPackXTempl(new XTempl()); id = XVar.Clone(CommonFunctions.postvalue_number(new XVar("id"))); id = XVar.Clone((XVar.Pack(MVCFunctions.intval((XVar)(id)) == 0) ? XVar.Pack(1) : XVar.Pack(id))); var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(id, "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(pageMode, "mode"); var_params.InitAndSetArrayItem(Constants.PAGE_ADD, "pageType"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("page")), "pageName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("a")), "action"); var_params.InitAndSetArrayItem(false, "needSearchClauseObj"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("afteradd")), "afterAdd_id"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("mastertable")), "masterTable"); if (XVar.Pack(var_params["masterTable"])) { dynamic i = null; i = new XVar(1); var_params.InitAndSetArrayItem(XVar.Array(), "masterKeysReq"); while (XVar.Pack(MVCFunctions.REQUESTKeyExists(MVCFunctions.Concat("masterkey", i)))) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(MVCFunctions.Concat("masterkey", i)), "masterKeysReq", i); i++; } } var_params.InitAndSetArrayItem("captcha_1209xre", "captchaName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue((XVar)(MVCFunctions.Concat("value_captcha_1209xre_", id))), "captchaValue"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("fromDashboard")), "fromDashboard"); var_params.InitAndSetArrayItem((XVar.Pack(var_params["fromDashboard"]) ? XVar.Pack(var_params["fromDashboard"]) : XVar.Pack(MVCFunctions.postvalue(new XVar("dashTName")))), "dashTName"); if (pageMode == Constants.ADD_INLINE) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("forLookup")), "forListPageLookup"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("screenWidth")), "screenWidth"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("screenHeight")), "screenHeight"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("orientation")), "orientation"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("masterpagetype")), "masterPageType"); } if ((XVar)(pageMode == Constants.ADD_ONTHEFLY) || (XVar)((XVar)(pageMode == Constants.ADD_INLINE) && (XVar)(MVCFunctions.postvalue(new XVar("forLookup"))))) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("table")), "lookupTable"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("field")), "lookupField"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("pageType")), "lookupPageType"); if (XVar.Pack(MVCFunctions.postvalue(new XVar("parentsExist")))) { var_params.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("parentCtrlsData")))), "parentCtrlsData"); } } GlobalVars.pageObject = XVar.Clone(new AddPage((XVar)(var_params))); GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult edit() { try { dynamic id = null, keys = XVar.Array(), pageMode = null, pageObject = null, var_params = XVar.Array(); XTempl xt; dbo_TIPOEMPLEADO_Variables.Apply(); CommonFunctions.add_nocache_headers(); if (XVar.Pack(!(XVar)(EditPage.processEditPageSecurity((XVar)(GlobalVars.strTableName))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } EditPage.handleBrokenRequest(); { TLayout t_layout = null; t_layout = new TLayout(new XVar("edit_bootstrap"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "dbo_TIPOEMPLEADO_edit"; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["editpage"] = XVar.Array(); t_layout.containers["editpage"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "header")); t_layout.containers["header"] = XVar.Array(); t_layout.containers["header"].Add(new XVar("name", "editheader", "block", "editheader", "substyle", 1)); t_layout.skins["header"] = ""; t_layout.containers["editpage"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "message")); t_layout.containers["message"] = XVar.Array(); t_layout.containers["message"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.skins["message"] = ""; t_layout.containers["editpage"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "steps")); t_layout.containers["steps"] = XVar.Array(); t_layout.containers["steps"].Add(new XVar("name", "multistep_nav_edit", "block", "", "substyle", 1)); t_layout.skins["steps"] = ""; t_layout.skins["editpage"] = ""; t_layout.blocks["top"].Add("editpage"); t_layout.containers["fields"] = XVar.Array(); t_layout.containers["fields"].Add(new XVar("name", "editfields", "block", "", "substyle", 1)); t_layout.skins["fields"] = ""; t_layout.blocks["top"].Add("fields"); t_layout.containers["bottombuttons"] = XVar.Array(); t_layout.containers["bottombuttons"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "buttons")); t_layout.containers["buttons"] = XVar.Array(); t_layout.containers["buttons"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "leftbuttons")); t_layout.containers["leftbuttons"] = XVar.Array(); t_layout.containers["leftbuttons"].Add(new XVar("name", "editbuttons", "block", "editbuttons", "substyle", 1)); t_layout.skins["leftbuttons"] = ""; t_layout.containers["buttons"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "leftbuttons_1")); t_layout.containers["leftbuttons_1"] = XVar.Array(); t_layout.containers["leftbuttons_1"].Add(new XVar("name", "righteditbuttons", "block", "righteditbuttons", "substyle", 1)); t_layout.skins["leftbuttons_1"] = ""; t_layout.skins["buttons"] = ""; t_layout.skins["bottombuttons"] = ""; t_layout.blocks["top"].Add("bottombuttons"); GlobalVars.page_layouts["dbo_TIPOEMPLEADO_edit"] = t_layout; } { TLayout t_layout = null; t_layout = new TLayout(new XVar("list_bootstrap1"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "dbo_TIPOEMPLEADO_list"; t_layout.blocks["center"] = XVar.Array(); t_layout.containers["gridcontrols"] = XVar.Array(); t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "add_delete")); t_layout.containers["add_delete"] = XVar.Array(); t_layout.containers["add_delete"].Add(new XVar("name", "add", "block", "newrecord_controls_block", "substyle", 1)); t_layout.containers["add_delete"].Add(new XVar("name", "recordcontrol", "block", "record_controls_block", "substyle", 1)); t_layout.skins["add_delete"] = ""; t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "gridinfo")); t_layout.containers["gridinfo"] = XVar.Array(); t_layout.containers["gridinfo"].Add(new XVar("name", "details_found", "block", "details_found", "substyle", 1)); t_layout.containers["gridinfo"].Add(new XVar("name", "printpanel", "block", "print_friendly", "substyle", 1)); t_layout.containers["gridinfo"].Add(new XVar("name", "bsfieldhidepanel", "block", "field_hide_panel", "substyle", 1)); t_layout.skins["gridinfo"] = ""; t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "gridinfo_sort")); t_layout.containers["gridinfo_sort"] = XVar.Array(); t_layout.containers["gridinfo_sort"].Add(new XVar("name", "reorder_records", "block", "reorder_records", "substyle", 1)); t_layout.skins["gridinfo_sort"] = ""; t_layout.skins["gridcontrols"] = ""; t_layout.blocks["center"].Add("gridcontrols"); t_layout.containers["tabs"] = XVar.Array(); t_layout.containers["tabs"].Add(new XVar("name", "bsgrid_tabs", "block", "grid_tabs", "substyle", 1)); t_layout.skins["tabs"] = ""; t_layout.blocks["center"].Add("tabs"); t_layout.containers["messagerow"] = XVar.Array(); t_layout.containers["messagerow"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "message")); t_layout.containers["message"] = XVar.Array(); t_layout.containers["message"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.skins["message"] = ""; t_layout.skins["messagerow"] = ""; t_layout.blocks["center"].Add("messagerow"); t_layout.containers["center"] = XVar.Array(); t_layout.containers["center"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "grid")); t_layout.containers["grid"] = XVar.Array(); t_layout.containers["grid"].Add(new XVar("name", "grid", "block", "grid_block", "substyle", 1)); t_layout.skins["grid"] = ""; t_layout.skins["center"] = ""; t_layout.blocks["center"].Add("center"); t_layout.containers["pagination"] = XVar.Array(); t_layout.containers["pagination"].Add(new XVar("name", "pagination", "block", "pagination_block", "substyle", 1)); t_layout.skins["pagination"] = ""; t_layout.blocks["center"].Add("pagination"); t_layout.blocks["left"] = XVar.Array(); t_layout.containers["left"] = XVar.Array(); t_layout.containers["left"].Add(new XVar("name", "searchpanel", "block", "searchPanel", "substyle", 1)); t_layout.containers["left"].Add(new XVar("name", "filterpanel", "block", "filterPanel", "substyle", 1)); t_layout.skins["left"] = ""; t_layout.blocks["left"].Add("left"); t_layout.blocks["top"] = XVar.Array(); t_layout.containers["menu"] = XVar.Array(); t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "hdr")); t_layout.containers["hdr"] = XVar.Array(); t_layout.containers["hdr"].Add(new XVar("name", "logo", "block", "logo_block", "substyle", 1)); t_layout.containers["hdr"].Add(new XVar("name", "bsnavbarcollapse", "block", "collapse_block", "substyle", 1)); t_layout.skins["hdr"] = ""; t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "menu_1")); t_layout.containers["menu_1"] = XVar.Array(); t_layout.containers["menu_1"].Add(new XVar("name", "hmenu", "block", "menu_block", "substyle", 1)); t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "more")); t_layout.containers["more"] = XVar.Array(); t_layout.containers["more"].Add(new XVar("name", "morebutton", "block", "more_list", "substyle", 1)); t_layout.containers["more"].Add(new XVar("name", "loggedas", "block", "security_block", "substyle", 1)); t_layout.skins["more"] = ""; t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "more_1")); t_layout.containers["more_1"] = XVar.Array(); t_layout.containers["more_1"].Add(new XVar("name", "search", "block", "searchform_block", "substyle", 1)); t_layout.skins["more_1"] = ""; t_layout.skins["menu_1"] = ""; t_layout.skins["menu"] = ""; t_layout.blocks["top"].Add("menu"); t_layout.blocks["topmiddle"] = XVar.Array(); t_layout.containers["breadcrumbs"] = XVar.Array(); t_layout.containers["breadcrumbs"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "bc")); t_layout.containers["bc"] = XVar.Array(); t_layout.containers["bc"].Add(new XVar("name", "breadcrumbs", "block", "breadcrumbs", "substyle", 1)); t_layout.skins["bc"] = ""; t_layout.skins["breadcrumbs"] = ""; t_layout.blocks["topmiddle"].Add("breadcrumbs"); t_layout.containers["masterinfo"] = XVar.Array(); t_layout.containers["masterinfo"].Add(new XVar("name", "masterinfo", "block", "mastertable_block", "substyle", 1)); t_layout.skins["masterinfo"] = ""; t_layout.blocks["topmiddle"].Add("masterinfo"); GlobalVars.page_layouts["dbo_TIPOEMPLEADO_list"] = t_layout; } { TLayout t_layout = null; t_layout = new TLayout(new XVar("list_bootstrap1"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "dbo_EMPLEADO_list"; t_layout.blocks["center"] = XVar.Array(); t_layout.containers["gridcontrols"] = XVar.Array(); t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "add_delete")); t_layout.containers["add_delete"] = XVar.Array(); t_layout.containers["add_delete"].Add(new XVar("name", "add", "block", "newrecord_controls_block", "substyle", 1)); t_layout.containers["add_delete"].Add(new XVar("name", "recordcontrol", "block", "record_controls_block", "substyle", 1)); t_layout.skins["add_delete"] = ""; t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "gridinfo")); t_layout.containers["gridinfo"] = XVar.Array(); t_layout.containers["gridinfo"].Add(new XVar("name", "details_found", "block", "details_found", "substyle", 1)); t_layout.containers["gridinfo"].Add(new XVar("name", "printpanel", "block", "print_friendly", "substyle", 1)); t_layout.containers["gridinfo"].Add(new XVar("name", "bsfieldhidepanel", "block", "field_hide_panel", "substyle", 1)); t_layout.skins["gridinfo"] = ""; t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "gridinfo_sort")); t_layout.containers["gridinfo_sort"] = XVar.Array(); t_layout.containers["gridinfo_sort"].Add(new XVar("name", "reorder_records", "block", "reorder_records", "substyle", 1)); t_layout.skins["gridinfo_sort"] = ""; t_layout.skins["gridcontrols"] = ""; t_layout.blocks["center"].Add("gridcontrols"); t_layout.containers["tabs"] = XVar.Array(); t_layout.containers["tabs"].Add(new XVar("name", "bsgrid_tabs", "block", "grid_tabs", "substyle", 1)); t_layout.skins["tabs"] = ""; t_layout.blocks["center"].Add("tabs"); t_layout.containers["messagerow"] = XVar.Array(); t_layout.containers["messagerow"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "message")); t_layout.containers["message"] = XVar.Array(); t_layout.containers["message"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.skins["message"] = ""; t_layout.skins["messagerow"] = ""; t_layout.blocks["center"].Add("messagerow"); t_layout.containers["center"] = XVar.Array(); t_layout.containers["center"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "grid")); t_layout.containers["grid"] = XVar.Array(); t_layout.containers["grid"].Add(new XVar("name", "grid", "block", "grid_block", "substyle", 1)); t_layout.skins["grid"] = ""; t_layout.skins["center"] = ""; t_layout.blocks["center"].Add("center"); t_layout.containers["pagination"] = XVar.Array(); t_layout.containers["pagination"].Add(new XVar("name", "pagination", "block", "pagination_block", "substyle", 1)); t_layout.skins["pagination"] = ""; t_layout.blocks["center"].Add("pagination"); t_layout.blocks["left"] = XVar.Array(); t_layout.containers["left"] = XVar.Array(); t_layout.containers["left"].Add(new XVar("name", "searchpanel", "block", "searchPanel", "substyle", 1)); t_layout.containers["left"].Add(new XVar("name", "filterpanel", "block", "filterPanel", "substyle", 1)); t_layout.skins["left"] = ""; t_layout.blocks["left"].Add("left"); t_layout.blocks["top"] = XVar.Array(); t_layout.containers["menu"] = XVar.Array(); t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "hdr")); t_layout.containers["hdr"] = XVar.Array(); t_layout.containers["hdr"].Add(new XVar("name", "logo", "block", "logo_block", "substyle", 1)); t_layout.containers["hdr"].Add(new XVar("name", "bsnavbarcollapse", "block", "collapse_block", "substyle", 1)); t_layout.skins["hdr"] = ""; t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "menu_1")); t_layout.containers["menu_1"] = XVar.Array(); t_layout.containers["menu_1"].Add(new XVar("name", "hmenu", "block", "menu_block", "substyle", 1)); t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "more")); t_layout.containers["more"] = XVar.Array(); t_layout.containers["more"].Add(new XVar("name", "morebutton", "block", "more_list", "substyle", 1)); t_layout.containers["more"].Add(new XVar("name", "loggedas", "block", "security_block", "substyle", 1)); t_layout.skins["more"] = ""; t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "more_1")); t_layout.containers["more_1"] = XVar.Array(); t_layout.containers["more_1"].Add(new XVar("name", "search", "block", "searchform_block", "substyle", 1)); t_layout.skins["more_1"] = ""; t_layout.skins["menu_1"] = ""; t_layout.skins["menu"] = ""; t_layout.blocks["top"].Add("menu"); t_layout.blocks["topmiddle"] = XVar.Array(); t_layout.containers["breadcrumbs"] = XVar.Array(); t_layout.containers["breadcrumbs"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "bc")); t_layout.containers["bc"] = XVar.Array(); t_layout.containers["bc"].Add(new XVar("name", "breadcrumbs", "block", "breadcrumbs", "substyle", 1)); t_layout.skins["bc"] = ""; t_layout.skins["breadcrumbs"] = ""; t_layout.blocks["topmiddle"].Add("breadcrumbs"); t_layout.containers["masterinfo"] = XVar.Array(); t_layout.containers["masterinfo"].Add(new XVar("name", "masterinfo", "block", "mastertable_block", "substyle", 1)); t_layout.skins["masterinfo"] = ""; t_layout.blocks["topmiddle"].Add("masterinfo"); GlobalVars.page_layouts["dbo_EMPLEADO_list"] = t_layout; } { TLayout t_layout = null; t_layout = new TLayout(new XVar("list_bootstrap1"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "Saldo_Horas_Empleado_list"; t_layout.blocks["center"] = XVar.Array(); t_layout.containers["gridcontrols"] = XVar.Array(); t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "add_delete")); t_layout.containers["add_delete"] = XVar.Array(); t_layout.containers["add_delete"].Add(new XVar("name", "add", "block", "newrecord_controls_block", "substyle", 1)); t_layout.containers["add_delete"].Add(new XVar("name", "recordcontrol", "block", "record_controls_block", "substyle", 1)); t_layout.skins["add_delete"] = ""; t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "gridinfo")); t_layout.containers["gridinfo"] = XVar.Array(); t_layout.containers["gridinfo"].Add(new XVar("name", "details_found", "block", "details_found", "substyle", 1)); t_layout.containers["gridinfo"].Add(new XVar("name", "printpanel", "block", "print_friendly", "substyle", 1)); t_layout.containers["gridinfo"].Add(new XVar("name", "bsfieldhidepanel", "block", "field_hide_panel", "substyle", 1)); t_layout.skins["gridinfo"] = ""; t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "gridinfo_sort")); t_layout.containers["gridinfo_sort"] = XVar.Array(); t_layout.containers["gridinfo_sort"].Add(new XVar("name", "reorder_records", "block", "reorder_records", "substyle", 1)); t_layout.skins["gridinfo_sort"] = ""; t_layout.skins["gridcontrols"] = ""; t_layout.blocks["center"].Add("gridcontrols"); t_layout.containers["tabs"] = XVar.Array(); t_layout.containers["tabs"].Add(new XVar("name", "bsgrid_tabs", "block", "grid_tabs", "substyle", 1)); t_layout.skins["tabs"] = ""; t_layout.blocks["center"].Add("tabs"); t_layout.containers["messagerow"] = XVar.Array(); t_layout.containers["messagerow"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "message")); t_layout.containers["message"] = XVar.Array(); t_layout.containers["message"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.skins["message"] = ""; t_layout.skins["messagerow"] = ""; t_layout.blocks["center"].Add("messagerow"); t_layout.containers["center"] = XVar.Array(); t_layout.containers["center"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "grid")); t_layout.containers["grid"] = XVar.Array(); t_layout.containers["grid"].Add(new XVar("name", "grid", "block", "grid_block", "substyle", 1)); t_layout.skins["grid"] = ""; t_layout.skins["center"] = ""; t_layout.blocks["center"].Add("center"); t_layout.containers["pagination"] = XVar.Array(); t_layout.containers["pagination"].Add(new XVar("name", "pagination", "block", "pagination_block", "substyle", 1)); t_layout.skins["pagination"] = ""; t_layout.blocks["center"].Add("pagination"); t_layout.blocks["left"] = XVar.Array(); t_layout.containers["left"] = XVar.Array(); t_layout.containers["left"].Add(new XVar("name", "searchpanel", "block", "searchPanel", "substyle", 1)); t_layout.containers["left"].Add(new XVar("name", "filterpanel", "block", "filterPanel", "substyle", 1)); t_layout.skins["left"] = ""; t_layout.blocks["left"].Add("left"); t_layout.blocks["top"] = XVar.Array(); t_layout.containers["menu"] = XVar.Array(); t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "hdr")); t_layout.containers["hdr"] = XVar.Array(); t_layout.containers["hdr"].Add(new XVar("name", "logo", "block", "logo_block", "substyle", 1)); t_layout.containers["hdr"].Add(new XVar("name", "bsnavbarcollapse", "block", "collapse_block", "substyle", 1)); t_layout.skins["hdr"] = ""; t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "menu_1")); t_layout.containers["menu_1"] = XVar.Array(); t_layout.containers["menu_1"].Add(new XVar("name", "hmenu", "block", "menu_block", "substyle", 1)); t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "more")); t_layout.containers["more"] = XVar.Array(); t_layout.containers["more"].Add(new XVar("name", "morebutton", "block", "more_list", "substyle", 1)); t_layout.containers["more"].Add(new XVar("name", "loggedas", "block", "security_block", "substyle", 1)); t_layout.skins["more"] = ""; t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "more_1")); t_layout.containers["more_1"] = XVar.Array(); t_layout.containers["more_1"].Add(new XVar("name", "search", "block", "searchform_block", "substyle", 1)); t_layout.skins["more_1"] = ""; t_layout.skins["menu_1"] = ""; t_layout.skins["menu"] = ""; t_layout.blocks["top"].Add("menu"); t_layout.blocks["topmiddle"] = XVar.Array(); t_layout.containers["breadcrumbs"] = XVar.Array(); t_layout.containers["breadcrumbs"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "bc")); t_layout.containers["bc"] = XVar.Array(); t_layout.containers["bc"].Add(new XVar("name", "breadcrumbs", "block", "breadcrumbs", "substyle", 1)); t_layout.skins["bc"] = ""; t_layout.skins["breadcrumbs"] = ""; t_layout.blocks["topmiddle"].Add("breadcrumbs"); t_layout.containers["masterinfo"] = XVar.Array(); t_layout.containers["masterinfo"].Add(new XVar("name", "masterinfo", "block", "mastertable_block", "substyle", 1)); t_layout.skins["masterinfo"] = ""; t_layout.blocks["topmiddle"].Add("masterinfo"); GlobalVars.page_layouts["Saldo_Horas_Empleado_list"] = t_layout; } pageMode = XVar.Clone(EditPage.readEditModeFromRequest()); xt = XVar.UnPackXTempl(new XTempl()); id = XVar.Clone(CommonFunctions.postvalue_number(new XVar("id"))); id = XVar.Clone((XVar.Pack(MVCFunctions.intval((XVar)(id)) == 0) ? XVar.Pack(1) : XVar.Pack(id))); keys = XVar.Clone(XVar.Array()); keys.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("editid1")), "id_tipo"); var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(id, "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(keys, "keys"); var_params.InitAndSetArrayItem(pageMode, "mode"); var_params.InitAndSetArrayItem(Constants.PAGE_EDIT, "pageType"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("page")), "pageName"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("a")), "action"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("fields")), "selectedFields"); var_params.InitAndSetArrayItem("captcha_1209xre", "captchaName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue((XVar)(MVCFunctions.Concat("value_captcha_1209xre_", id))), "captchaValue"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("selection")), "selection"); var_params.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("rowIds")))), "rowIds"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("mastertable")), "masterTable"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("action")), "lockingAction"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("sid")), "lockingSid"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("keys")), "lockingKeys"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("startEdit")), "lockingStart"); if (pageMode == Constants.EDIT_INLINE) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("screenWidth")), "screenWidth"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("screenHeight")), "screenHeight"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("orientation")), "orientation"); } if (pageMode == Constants.EDIT_DASHBOARD) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("table")), "dashTName"); if (XVar.Pack(MVCFunctions.postvalue(new XVar("mapRefresh")))) { var_params.InitAndSetArrayItem(true, "mapRefresh"); var_params.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("vpCoordinates")))), "vpCoordinates"); } } if ((XVar)((XVar)(pageMode == Constants.EDIT_POPUP) || (XVar)(pageMode == Constants.EDIT_INLINE)) && (XVar)(MVCFunctions.postvalue(new XVar("dashTName")))) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashTName")), "dashTName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); } if (XVar.Pack(var_params["masterTable"])) { var_params.InitAndSetArrayItem(EditPage.processMasterKeys(), "masterKeysReq"); } GlobalVars.pageObject = XVar.Clone(EditPage.EditPageFactory((XVar)(var_params))); if (XVar.Pack(GlobalVars.pageObject.isLockingRequest())) { GlobalVars.pageObject.doLockingAction(); MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult search() { try { dynamic accessGranted = null, chrt_array = XVar.Array(), cname = null, id = null, layoutVersion = null, pageMode = null, pageObject = null, rname = null, templatefile = null, var_params = XVar.Array(); XTempl xt; CommonFunctions.add_nocache_headers(); Licencias_sin_goce_sueldo_Variables.Apply(); Security.processLogoutRequest(); if (XVar.Pack(!(XVar)(CommonFunctions.isLogged()))) { Security.saveRedirectURL(); CommonFunctions.redirectToLogin(); } cname = XVar.Clone(MVCFunctions.postvalue(new XVar("cname"))); rname = XVar.Clone(MVCFunctions.postvalue(new XVar("rname"))); accessGranted = XVar.Clone(CommonFunctions.CheckTablePermissions((XVar)(GlobalVars.strTableName), new XVar("S"))); if (XVar.Pack(!(XVar)(accessGranted))) { MVCFunctions.HeaderRedirect(new XVar("menu")); } { TLayout t_layout = null; t_layout = new TLayout(new XVar("search_bootstrap"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "Licencias_sin_goce_sueldo_search"; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["searchpage"] = XVar.Array(); t_layout.containers["searchpage"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "header")); t_layout.containers["header"] = XVar.Array(); t_layout.containers["header"].Add(new XVar("name", "bssearchheader", "block", "searchheader", "substyle", 1)); t_layout.skins["header"] = ""; t_layout.skins["searchpage"] = ""; t_layout.blocks["top"].Add("searchpage"); t_layout.containers["fields"] = XVar.Array(); t_layout.containers["fields"].Add(new XVar("name", "bssearchfields", "block", "", "substyle", 1)); t_layout.skins["fields"] = ""; t_layout.blocks["top"].Add("fields"); t_layout.containers["bottombuttons"] = XVar.Array(); t_layout.containers["bottombuttons"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "bbuttons")); t_layout.containers["bbuttons"] = XVar.Array(); t_layout.containers["bbuttons"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "leftbuttons")); t_layout.containers["leftbuttons"] = XVar.Array(); t_layout.containers["leftbuttons"].Add(new XVar("name", "srchbuttons", "block", "searchbuttons", "substyle", 1)); t_layout.skins["leftbuttons"] = ""; t_layout.skins["bbuttons"] = ""; t_layout.skins["bottombuttons"] = ""; t_layout.blocks["top"].Add("bottombuttons"); GlobalVars.page_layouts["Licencias_sin_goce_sueldo_search"] = t_layout; } xt = XVar.UnPackXTempl(new XTempl()); pageMode = XVar.Clone(SearchPage.readSearchModeFromRequest()); if (pageMode == Constants.SEARCH_LOAD_CONTROL) { layoutVersion = XVar.Clone(MVCFunctions.postvalue(new XVar("layoutVersion"))); } var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(CommonFunctions.postvalue_number(new XVar("id")), "id"); var_params.InitAndSetArrayItem(pageMode, "mode"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("page")), "pageName"); var_params.InitAndSetArrayItem(Constants.PAGE_SEARCH, "pageType"); var_params.InitAndSetArrayItem(cname, "chartName"); var_params.InitAndSetArrayItem(rname, "reportName"); var_params.InitAndSetArrayItem(templatefile, "templatefile"); var_params.InitAndSetArrayItem("Licencias_sin_goce_sueldo", "shortTableName"); var_params.InitAndSetArrayItem(layoutVersion, "layoutVersion"); var_params.InitAndSetArrayItem((XVar.Pack(MVCFunctions.postvalue(new XVar("searchControllerId"))) ? XVar.Pack(MVCFunctions.postvalue(new XVar("searchControllerId"))) : XVar.Pack(id)), "searchControllerId"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("ctrlField")), "ctrlField"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("isNeedSettings")), "needSettings"); if (pageMode == Constants.SEARCH_DASHBOARD) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("table")), "dashTName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); } var_params.InitAndSetArrayItem(SearchPage.getExtraPageParams(), "extraPageParams"); GlobalVars.pageObject = XVar.Clone(new SearchPage((XVar)(var_params))); if (pageMode == Constants.SEARCH_LOAD_CONTROL) { GlobalVars.pageObject.displaySearchControl(); return(MVCFunctions.GetBuferContentAndClearBufer()); } GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); if (pageMode == Constants.SEARCH_DASHBOARD) { MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult search() { try { dynamic accessGranted = null, chrt_array = XVar.Array(), cname = null, id = null, layoutVersion = null, mode = null, pageObject = null, rname = null, templatefile = null, var_params = XVar.Array(); XTempl xt; ABC_Voting_Submitted1_Variables.Apply(); CommonFunctions.add_nocache_headers(); Security.processLogoutRequest(); if (XVar.Pack(!(XVar)(CommonFunctions.isLogged()))) { Security.saveRedirectURL(); CommonFunctions.redirectToLogin(); } cname = XVar.Clone(MVCFunctions.postvalue(new XVar("cname"))); rname = XVar.Clone(MVCFunctions.postvalue(new XVar("rname"))); accessGranted = XVar.Clone(CommonFunctions.CheckTablePermissions((XVar)(GlobalVars.strTableName), new XVar("S"))); if (XVar.Pack(!(XVar)(accessGranted))) { MVCFunctions.HeaderRedirect(new XVar("menu")); } { TLayout t_layout = null; t_layout = new TLayout(new XVar("search2"), new XVar("AvenueAvenue"), new XVar("MobileAvenue")); t_layout.version = 2; t_layout.blocks["top"] = XVar.Array(); t_layout.containers["search"] = XVar.Array(); t_layout.containers["search"].Add(new XVar("name", "srchheader", "block", "searchheader", "substyle", 2)); t_layout.containers["search"].Add(new XVar("name", "srchconditions", "block", "conditions_block", "substyle", 1)); t_layout.containers["search"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "fields")); t_layout.containers["fields"] = XVar.Array(); t_layout.containers["fields"].Add(new XVar("name", "srchfields", "block", "", "substyle", 1)); t_layout.containers["fields"].Add(new XVar("name", "srchbuttons", "block", "searchbuttons", "substyle", 2)); t_layout.skins["fields"] = "fields"; t_layout.skins["search"] = "1"; t_layout.blocks["top"].Add("search"); GlobalVars.page_layouts["ABC_Voting_Submitted1_search"] = t_layout; t_layout.skinsparams = XVar.Array(); t_layout.skinsparams["empty"] = XVar.Array(); t_layout.skinsparams["empty"]["button"] = "button2"; t_layout.skinsparams["menu"] = XVar.Array(); t_layout.skinsparams["menu"]["button"] = "button1"; t_layout.skinsparams["hmenu"] = XVar.Array(); t_layout.skinsparams["hmenu"]["button"] = "button1"; t_layout.skinsparams["undermenu"] = XVar.Array(); t_layout.skinsparams["undermenu"]["button"] = "button1"; t_layout.skinsparams["fields"] = XVar.Array(); t_layout.skinsparams["fields"]["button"] = "button1"; t_layout.skinsparams["form"] = XVar.Array(); t_layout.skinsparams["form"]["button"] = "button1"; t_layout.skinsparams["1"] = XVar.Array(); t_layout.skinsparams["1"]["button"] = "button1"; t_layout.skinsparams["2"] = XVar.Array(); t_layout.skinsparams["2"]["button"] = "button1"; t_layout.skinsparams["3"] = XVar.Array(); t_layout.skinsparams["3"]["button"] = "button1"; } xt = XVar.UnPackXTempl(new XTempl()); id = XVar.Clone(MVCFunctions.postvalue(new XVar("id"))); id = XVar.Clone((XVar.Pack(id) ? XVar.Pack(id) : XVar.Pack(1))); mode = new XVar(Constants.SEARCH_SIMPLE); if (MVCFunctions.postvalue(new XVar("mode")) == "dashsearch") { mode = new XVar(Constants.SEARCH_DASHBOARD); } else { if (MVCFunctions.postvalue(new XVar("mode")) == "inlineLoadCtrl") { mode = new XVar(Constants.SEARCH_LOAD_CONTROL); layoutVersion = XVar.Clone(MVCFunctions.postvalue(new XVar("layoutVersion"))); } } var_params = XVar.Clone(XVar.Array()); var_params.InitAndSetArrayItem(id, "id"); var_params.InitAndSetArrayItem(xt, "xt"); var_params.InitAndSetArrayItem(mode, "mode"); var_params.InitAndSetArrayItem(cname, "chartName"); var_params.InitAndSetArrayItem(rname, "reportName"); var_params.InitAndSetArrayItem(GlobalVars.strTableName, "tName"); var_params.InitAndSetArrayItem(Constants.PAGE_SEARCH, "pageType"); var_params.InitAndSetArrayItem(templatefile, "templatefile"); var_params.InitAndSetArrayItem("ABC_Voting_Submitted1", "shortTableName"); var_params.InitAndSetArrayItem(layoutVersion, "layoutVersion"); var_params.InitAndSetArrayItem((XVar.Pack(MVCFunctions.postvalue(new XVar("searchControllerId"))) ? XVar.Pack(MVCFunctions.postvalue(new XVar("searchControllerId"))) : XVar.Pack(id)), "searchControllerId"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("ctrlField")), "ctrlField"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("isNeedSettings")), "needSettings"); if (mode == Constants.SEARCH_DASHBOARD) { var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("table")), "dashTName"); var_params.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); } var_params.InitAndSetArrayItem(SearchPage.getExtraPageParams(), "extraPageParams"); GlobalVars.pageObject = XVar.Clone(new SearchPage((XVar)(var_params))); if (mode == Constants.SEARCH_LOAD_CONTROL) { GlobalVars.pageObject.displaySearchControl(); return(MVCFunctions.GetBuferContentAndClearBufer()); } GlobalVars.pageObject.init(); GlobalVars.pageObject.process(); if (mode == Constants.SEARCH_DASHBOARD) { MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public ActionResult list() { try { dynamic i = null, mode = null, options = XVar.Array(), pageObject = null; XTempl xt; GlobalVars.requestTable = new XVar("dbo.ESTADO_PERSONALES"); GlobalVars.requestPage = new XVar("list"); CommonFunctions.add_nocache_headers(); dbo_ESTADO_PERSONALES_Variables.Apply(); CommonFunctions.InitLookupLinks(); if (XVar.Pack(!(XVar)(ListPage.processListPageSecurity((XVar)(GlobalVars.strTableName))))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } if (XVar.Pack(ListPage.processSaveParams((XVar)(GlobalVars.strTableName)))) { return(MVCFunctions.GetBuferContentAndClearBufer()); } { TLayout t_layout = null; t_layout = new TLayout(new XVar("list_bootstrap1"), new XVar("OfficeOffice"), new XVar("MobileOffice")); t_layout.version = 3; t_layout.bootstrapTheme = "default"; t_layout.customCssPageName = "dbo_ESTADO_PERSONALES_list"; t_layout.blocks["center"] = XVar.Array(); t_layout.containers["gridcontrols"] = XVar.Array(); t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "add_delete")); t_layout.containers["add_delete"] = XVar.Array(); t_layout.containers["add_delete"].Add(new XVar("name", "add", "block", "newrecord_controls_block", "substyle", 1)); t_layout.containers["add_delete"].Add(new XVar("name", "recordcontrol", "block", "record_controls_block", "substyle", 1)); t_layout.skins["add_delete"] = ""; t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "gridinfo")); t_layout.containers["gridinfo"] = XVar.Array(); t_layout.containers["gridinfo"].Add(new XVar("name", "details_found", "block", "details_found", "substyle", 1)); t_layout.containers["gridinfo"].Add(new XVar("name", "printpanel", "block", "print_friendly", "substyle", 1)); t_layout.containers["gridinfo"].Add(new XVar("name", "bsfieldhidepanel", "block", "field_hide_panel", "substyle", 1)); t_layout.skins["gridinfo"] = ""; t_layout.containers["gridcontrols"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "gridinfo_sort")); t_layout.containers["gridinfo_sort"] = XVar.Array(); t_layout.containers["gridinfo_sort"].Add(new XVar("name", "reorder_records", "block", "reorder_records", "substyle", 1)); t_layout.skins["gridinfo_sort"] = ""; t_layout.skins["gridcontrols"] = ""; t_layout.blocks["center"].Add("gridcontrols"); t_layout.containers["tabs"] = XVar.Array(); t_layout.containers["tabs"].Add(new XVar("name", "bsgrid_tabs", "block", "grid_tabs", "substyle", 1)); t_layout.skins["tabs"] = ""; t_layout.blocks["center"].Add("tabs"); t_layout.containers["messagerow"] = XVar.Array(); t_layout.containers["messagerow"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "message")); t_layout.containers["message"] = XVar.Array(); t_layout.containers["message"].Add(new XVar("name", "message", "block", "message_block", "substyle", 1)); t_layout.skins["message"] = ""; t_layout.skins["messagerow"] = ""; t_layout.blocks["center"].Add("messagerow"); t_layout.containers["center"] = XVar.Array(); t_layout.containers["center"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "grid")); t_layout.containers["grid"] = XVar.Array(); t_layout.containers["grid"].Add(new XVar("name", "grid", "block", "grid_block", "substyle", 1)); t_layout.skins["grid"] = ""; t_layout.skins["center"] = ""; t_layout.blocks["center"].Add("center"); t_layout.containers["pagination"] = XVar.Array(); t_layout.containers["pagination"].Add(new XVar("name", "pagination", "block", "pagination_block", "substyle", 1)); t_layout.skins["pagination"] = ""; t_layout.blocks["center"].Add("pagination"); t_layout.blocks["left"] = XVar.Array(); t_layout.containers["left"] = XVar.Array(); t_layout.containers["left"].Add(new XVar("name", "searchpanel", "block", "searchPanel", "substyle", 1)); t_layout.containers["left"].Add(new XVar("name", "filterpanel", "block", "filterPanel", "substyle", 1)); t_layout.skins["left"] = ""; t_layout.blocks["left"].Add("left"); t_layout.blocks["top"] = XVar.Array(); t_layout.containers["menu"] = XVar.Array(); t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "hdr")); t_layout.containers["hdr"] = XVar.Array(); t_layout.containers["hdr"].Add(new XVar("name", "logo", "block", "logo_block", "substyle", 1)); t_layout.containers["hdr"].Add(new XVar("name", "bsnavbarcollapse", "block", "collapse_block", "substyle", 1)); t_layout.skins["hdr"] = ""; t_layout.containers["menu"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "menu_1")); t_layout.containers["menu_1"] = XVar.Array(); t_layout.containers["menu_1"].Add(new XVar("name", "hmenu", "block", "menu_block", "substyle", 1)); t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "more")); t_layout.containers["more"] = XVar.Array(); t_layout.containers["more"].Add(new XVar("name", "morebutton", "block", "more_list", "substyle", 1)); t_layout.containers["more"].Add(new XVar("name", "loggedas", "block", "security_block", "substyle", 1)); t_layout.skins["more"] = ""; t_layout.containers["menu_1"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "more_1")); t_layout.containers["more_1"] = XVar.Array(); t_layout.containers["more_1"].Add(new XVar("name", "search", "block", "searchform_block", "substyle", 1)); t_layout.skins["more_1"] = ""; t_layout.skins["menu_1"] = ""; t_layout.skins["menu"] = ""; t_layout.blocks["top"].Add("menu"); t_layout.blocks["topmiddle"] = XVar.Array(); t_layout.containers["breadcrumbs"] = XVar.Array(); t_layout.containers["breadcrumbs"].Add(new XVar("name", "wrapper", "block", "", "substyle", 1, "container", "bc")); t_layout.containers["bc"] = XVar.Array(); t_layout.containers["bc"].Add(new XVar("name", "breadcrumbs", "block", "breadcrumbs", "substyle", 1)); t_layout.skins["bc"] = ""; t_layout.skins["breadcrumbs"] = ""; t_layout.blocks["topmiddle"].Add("breadcrumbs"); t_layout.containers["masterinfo"] = XVar.Array(); t_layout.containers["masterinfo"].Add(new XVar("name", "masterinfo", "block", "mastertable_block", "substyle", 1)); t_layout.skins["masterinfo"] = ""; t_layout.blocks["topmiddle"].Add("masterinfo"); GlobalVars.page_layouts["dbo_ESTADO_PERSONALES_list"] = t_layout; } options = XVar.Clone(XVar.Array()); mode = XVar.Clone(ListPage.readListModeFromRequest()); if (mode == Constants.LIST_SIMPLE) { } else { if (mode == Constants.LIST_AJAX) { } else { if (mode == Constants.LIST_LOOKUP) { options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("table")), "mainTable"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("field")), "mainField"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("pageType")), "mainPageType"); options.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("data")))), "mainRecordData"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("mainRecordMasterTable")), "mainRecordMasterTable"); if (XVar.Pack(MVCFunctions.postvalue(new XVar("parentsExist")))) { options.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("parentCtrlsData")))), "parentCtrlsData"); } } else { if (mode == Constants.LIST_POPUPDETAILS) { } else { if (mode == Constants.LIST_DETAILS) { } else { if (mode == Constants.LIST_DASHDETAILS) { } else { if (mode == Constants.LIST_DASHBOARD) { } else { if (mode == Constants.MAP_DASHBOARD) { } } } } } } } } xt = XVar.UnPackXTempl(new XTempl((XVar)(mode != Constants.LIST_SIMPLE))); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("page")), "pageName"); options.InitAndSetArrayItem(Constants.PAGE_LIST, "pageType"); options.InitAndSetArrayItem((XVar.Pack(CommonFunctions.postvalue_number(new XVar("id"))) ? XVar.Pack(CommonFunctions.postvalue_number(new XVar("id"))) : XVar.Pack(1)), "id"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("recordId")) + 0, "flyId"); options.InitAndSetArrayItem(mode, "mode"); options.InitAndSetArrayItem(xt, "xt"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("masterpagetype")), "masterPageType"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("mastertable")), "masterTable"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("masterpage")), "masterPage"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("masterid")), "masterId"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("firsttime")), "firstTime"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("sortby")), "sortBy"); if ((XVar)((XVar)(mode == Constants.LIST_DASHBOARD) && (XVar)(MVCFunctions.postvalue(new XVar("nodata")))) && (XVar)(MVCFunctions.strlen((XVar)(options["masterTable"])))) { options.InitAndSetArrayItem(true, "showNoData"); } if (mode != Constants.LIST_LOOKUP) { options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("dashelement")), "dashElementName"); options.InitAndSetArrayItem(MVCFunctions.postvalue(new XVar("table")), "dashTName"); } if (XVar.Pack(MVCFunctions.postvalue(new XVar("mapRefresh")))) { options.InitAndSetArrayItem(true, "mapRefresh"); options.InitAndSetArrayItem(MVCFunctions.my_json_decode((XVar)(MVCFunctions.postvalue(new XVar("vpCoordinates")))), "vpCoordinates"); } i = new XVar(1); while (XVar.Pack(MVCFunctions.REQUESTKeyExists(MVCFunctions.Concat("masterkey", i)))) { if (i == 1) { options.InitAndSetArrayItem(XVar.Array(), "masterKeysReq"); } options.InitAndSetArrayItem(MVCFunctions.postvalue(MVCFunctions.Concat("masterkey", i)), "masterKeysReq", i); i++; } GlobalVars.pageObject = XVar.Clone(ListPage.createListPage((XVar)(GlobalVars.strTableName), (XVar)(options))); if (XVar.Pack(GlobalVars.pageObject.processSaveSearch())) { MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } GlobalVars.gQuery.ReplaceFieldsWithDummies((XVar)(GlobalVars.pageObject.getNotListBlobFieldsIndices())); if ((XVar)((XVar)(mode != Constants.LIST_DETAILS) && (XVar)(mode != Constants.MAP_DASHBOARD)) && (XVar)(mode != Constants.LIST_DASHBOARD)) { } XSession.Session.Remove("message_add"); XSession.Session.Remove("message_edit"); GlobalVars.pageObject.prepareForBuildPage(); GlobalVars.pageObject.showPage(); if (mode != Constants.LIST_SIMPLE) { MVCFunctions.Echo(new XVar("")); return(MVCFunctions.GetBuferContentAndClearBufer()); } ViewBag.xt = xt; return(View(xt.GetViewPath())); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }
public XVar fulltext() { try { dynamic _connection = null, cViewControl = null, container = null, data = XVar.Array(), field = null, fieldValue = null, htmlEncodedValue = null, keys = XVar.Array(), keysArr = XVar.Array(), lookup = null, lookupInRegisterPage = null, mainField = null, mainTable = null, mode = null, pageType = null, qResult = null, returnJSON = null, searchClauseObj = null, sessionPrefix = null, sql = null, table = null, where = null; ProjectSettings pSet; mode = XVar.Clone(MVCFunctions.postvalue(new XVar("mode"))); table = XVar.Clone(MVCFunctions.postvalue(new XVar("table"))); field = XVar.Clone(MVCFunctions.postvalue(new XVar("field"))); pageType = XVar.Clone(MVCFunctions.postvalue(new XVar("pagetype"))); mainTable = XVar.Clone(MVCFunctions.postvalue(new XVar("maintable"))); mainField = XVar.Clone(MVCFunctions.postvalue(new XVar("mainfield"))); lookup = new XVar(false); if ((XVar)(mainTable) && (XVar)(mainField)) { lookup = new XVar(true); } if (XVar.Pack(!(XVar)(CommonFunctions.checkTableName((XVar)(table))))) { MVCFunctions.Echo(new XVar(0)); return(MVCFunctions.GetBuferContentAndClearBufer()); } Assembly.GetExecutingAssembly().GetType(MVCFunctions.Concat("runnerDotNet.", MVCFunctions.Concat("", table, ""), "_Variables")).InvokeMember("Apply", BindingFlags.InvokeMethod, null, null, null); pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(CommonFunctions.GetTableByShort((XVar)(table))), (XVar)(pageType))); GlobalVars.cipherer = XVar.Clone(new RunnerCipherer((XVar)(CommonFunctions.GetTableByShort((XVar)(table))), (XVar)(pSet))); _connection = XVar.Clone(GlobalVars.cman.byTable((XVar)(GlobalVars.strTableName))); lookupInRegisterPage = new XVar(false); if (XVar.Pack(!(XVar)(MVCFunctions.in_array((XVar)(field), (XVar)(pSet.getListFields()))))) { lookupInRegisterPage = new XVar(false); } if ((XVar)((XVar)(!(XVar)(CommonFunctions.isLogged())) || (XVar)(!(XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search"))))) && (XVar)(!(XVar)(lookupInRegisterPage))) { returnJSON = XVar.Clone(new XVar("success", false, "error", "")); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON))); return(MVCFunctions.GetBuferContentAndClearBufer()); } if (XVar.Pack(!(XVar)(pSet.checkFieldPermissions((XVar)(field))))) { returnJSON = XVar.Clone(new XVar("success", false, "error", "Error: You have not permission for read this text")); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON))); return(MVCFunctions.GetBuferContentAndClearBufer()); } if (XVar.Pack(!(XVar)(GlobalVars.gQuery.HasGroupBy()))) { GlobalVars.gQuery.RemoveAllFieldsExcept((XVar)(pSet.getFieldIndex((XVar)(field)))); } keysArr = XVar.Clone(pSet.getTableKeys()); keys = XVar.Clone(XVar.Array()); foreach (KeyValuePair <XVar, dynamic> k in keysArr.GetEnumerator()) { keys.InitAndSetArrayItem(MVCFunctions.postvalue((XVar)(MVCFunctions.Concat("key", k.Key + 1))), k.Value); } where = XVar.Clone(CommonFunctions.KeyWhere((XVar)(keys))); if (pSet.getAdvancedSecurityType() == Constants.ADVSECURITY_VIEW_OWN) { where = XVar.Clone(CommonFunctions.whereAdd((XVar)(where), (XVar)(CommonFunctions.SecuritySQL(new XVar("Search"), (XVar)(GlobalVars.strTableName))))); } sql = XVar.Clone(GlobalVars.gQuery.gSQLWhere((XVar)(where))); qResult = XVar.Clone(_connection.query((XVar)(sql))); if ((XVar)(!(XVar)(qResult)) || (XVar)(!(XVar)(data = XVar.Clone(GlobalVars.cipherer.DecryptFetchedArray((XVar)(qResult.fetchAssoc())))))) { returnJSON = XVar.Clone(new XVar("success", false, "error", "Error: Wrong SQL query")); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON))); return(MVCFunctions.GetBuferContentAndClearBufer()); } fieldValue = XVar.Clone(data[field]); sessionPrefix = XVar.Clone(pSet.getOriginalTableName()); if (mode == Constants.LIST_DASHBOARD) { sessionPrefix = XVar.Clone(MVCFunctions.Concat("Dashboard_", pSet.getOriginalTableName())); } if (XVar.Pack(lookup)) { sessionPrefix = XVar.Clone(MVCFunctions.Concat(pSet.getOriginalTableName(), "_lookup_", mainTable, "_", mainField)); } searchClauseObj = XVar.Clone(SearchClause.UnserializeObject((XVar)(XSession.Session[MVCFunctions.Concat(sessionPrefix, "_advsearch")]))); container = XVar.Clone(new ViewControlsContainer((XVar)(pSet), new XVar(Constants.PAGE_LIST), new XVar(null))); cViewControl = XVar.Clone(container.getControl((XVar)(field))); if ((XVar)(cViewControl.localControlsContainer) && (XVar)(!(XVar)(cViewControl.linkAndDisplaySame))) { cViewControl.localControlsContainer.fullText = new XVar(true); } else { cViewControl.container.fullText = new XVar(true); } if (XVar.Pack(searchClauseObj)) { dynamic useViewControl = null; if ((XVar)(searchClauseObj.bIsUsedSrch) || (XVar)(useViewControl)) { cViewControl.searchClauseObj = XVar.Clone(searchClauseObj); cViewControl.searchHighlight = new XVar(true); } } htmlEncodedValue = XVar.Clone(cViewControl.showDBValue((XVar)(data), new XVar(""))); returnJSON = XVar.Clone(new XVar("success", true, "textCont", MVCFunctions.nl2br((XVar)(htmlEncodedValue)))); MVCFunctions.Echo(CommonFunctions.printJSON((XVar)(returnJSON))); return(MVCFunctions.GetBuferContentAndClearBufer()); } catch (RunnerRedirectException ex) { return(Redirect(ex.Message)); } }