public XVar report_error(XVar _param_message)
{
XVar message = _param_message.Clone();
MVCFunctions.EchoToOutput(message);
return(null);
}
public static XVar getValues()
{
dynamic ctx = null;
ctx = XVar.Clone(current());
return(ctx.getValues());
}
private void buildRiskMasterPaymentErrorList(dynamic record, string errorMessage)
{
XVar insertErrorRow = buildPfImportRecordPrimaryKeyClause(record);
insertErrorRow.SetArrayItem("ERROR_DESCR", errorMessage);
insertErrorList.Add(insertErrorRow);
}
public virtual XVar getSecCtrlParamsArr(dynamic _param_fName, dynamic _param_recId, dynamic _param_fieldNum, dynamic _param_value, dynamic _param_opt, dynamic _param_renderHidden = null, dynamic _param_isCached = null)
{
#region default values
if (_param_renderHidden as Object == null)
{
_param_renderHidden = new XVar(false);
}
if (_param_isCached as Object == null)
{
_param_isCached = new XVar(true);
}
#endregion
#region pass-by-value parameters
dynamic fName = XVar.Clone(_param_fName);
dynamic recId = XVar.Clone(_param_recId);
dynamic fieldNum = XVar.Clone(_param_fieldNum);
dynamic value = XVar.Clone(_param_value);
dynamic opt = XVar.Clone(_param_opt);
dynamic renderHidden = XVar.Clone(_param_renderHidden);
dynamic isCached = XVar.Clone(_param_isCached);
#endregion
dynamic fType = null;
fType = XVar.Clone(this.pSet.getEditFormat((XVar)(fName)));
if (XVar.Pack(isNeedSecondCtrl((XVar)(fName))))
{
return(getCtrlParamsArr((XVar)(fName), (XVar)(recId), (XVar)(fieldNum + 1), (XVar)(value), (XVar)(opt), (XVar)(renderHidden), (XVar)(isCached)));
}
return(false);
}
public virtual XVar getCtrlParamsArr(dynamic _param_fName, dynamic _param_recId, dynamic _param_fieldNum, dynamic _param_value, dynamic _param_opt, dynamic _param_renderHidden = null, dynamic _param_isCached = null)
{
#region default values
if (_param_renderHidden as Object == null)
{
_param_renderHidden = new XVar(false);
}
if (_param_isCached as Object == null)
{
_param_isCached = new XVar(true);
}
#endregion
#region pass-by-value parameters
dynamic fName = XVar.Clone(_param_fName);
dynamic recId = XVar.Clone(_param_recId);
dynamic fieldNum = XVar.Clone(_param_fieldNum);
dynamic value = XVar.Clone(_param_value);
dynamic opt = XVar.Clone(_param_opt);
dynamic renderHidden = XVar.Clone(_param_renderHidden);
dynamic isCached = XVar.Clone(_param_isCached);
#endregion
dynamic parameters = null;
parameters = XVar.Clone(buildCtrlParamsArr((XVar)(fName), (XVar)(recId), (XVar)(fieldNum), (XVar)(value), (XVar)(opt), (XVar)(renderHidden), (XVar)(isCached)));
return(XTempl.create_function_assignment(new XVar("xt_buildeditcontrol"), (XVar)(parameters)));
}
public virtual XVar loadLookupContent(dynamic _param_parentValuesData, dynamic _param_childVal = null, dynamic _param_doCategoryFilter = null, dynamic _param_initialLoad = null)
{
#region default values
if (_param_childVal as Object == null)
{
_param_childVal = new XVar("");
}
if (_param_doCategoryFilter as Object == null)
{
_param_doCategoryFilter = new XVar(true);
}
if (_param_initialLoad as Object == null)
{
_param_initialLoad = new XVar(true);
}
#endregion
#region pass-by-value parameters
dynamic parentValuesData = XVar.Clone(_param_parentValuesData);
dynamic childVal = XVar.Clone(_param_childVal);
dynamic doCategoryFilter = XVar.Clone(_param_doCategoryFilter);
dynamic initialLoad = XVar.Clone(_param_initialLoad);
#endregion
return("");
}
protected override XVar getSubsetSQLComponents()
{
dynamic selectedRecords = XVar.Array(), sql = XVar.Array();
sql = XVar.Clone(XVar.Array());
selectedRecords = XVar.Clone(getSelectedRecords());
if (!XVar.Equals(XVar.Pack(selectedRecords), XVar.Pack(null)))
{
dynamic selectedWhereParts = XVar.Array();
sql.InitAndSetArrayItem(this.gQuery.getSqlComponents(), "sqlParts");
selectedWhereParts = XVar.Clone(XVar.Array());
foreach (KeyValuePair <XVar, dynamic> keys in selectedRecords.GetEnumerator())
{
selectedWhereParts.InitAndSetArrayItem(CommonFunctions.KeyWhere((XVar)(keys.Value)), null);
}
sql.InitAndSetArrayItem(MVCFunctions.implode(new XVar(" or "), (XVar)(selectedWhereParts)), "mandatoryWhere", null);
if (0 == MVCFunctions.count(selectedRecords))
{
sql.InitAndSetArrayItem("1=0", "mandatoryWhere", null);
}
}
else
{
sql = XVar.Clone(base.getSubsetSQLComponents());
}
if (this.connection.dbType == Constants.nDATABASE_DB2)
{
sql["sqlParts"]["head"] = MVCFunctions.Concat(sql["sqlParts"]["head"], ", ROW_NUMBER() over () as DB2_ROW_NUMBER ");
}
sql.InitAndSetArrayItem(SecuritySQL(new XVar("Export"), (XVar)(this.tName)), "mandatoryWhere", null);
return(sql);
}
public virtual XVar getFullUrl()
{
dynamic https = null;
https = XVar.Clone((XVar)(MVCFunctions.strlen((XVar)(MVCFunctions.GetServerVariable("HTTPS"))) != 0) && (XVar)(!XVar.Equals(XVar.Pack(MVCFunctions.GetServerVariable("HTTPS")), XVar.Pack("off"))));
return(MVCFunctions.Concat((XVar.Pack(https) ? XVar.Pack("https://") : XVar.Pack("http://")), (XVar.Pack(MVCFunctions.strlen((XVar)(MVCFunctions.GetRemoteUser())) != 0) ? XVar.Pack(MVCFunctions.Concat(MVCFunctions.GetRemoteUser(), "@")) : XVar.Pack("")), (XVar.Pack(MVCFunctions.SERVERKeyExists("HTTP_HOST")) ? XVar.Pack(MVCFunctions.GetServerVariable("HTTP_HOST")) : XVar.Pack(MVCFunctions.Concat(MVCFunctions.GetServerName(), (XVar.Pack((XVar)((XVar)(https) && (XVar)(XVar.Equals(XVar.Pack(MVCFunctions.GetServerPort()), XVar.Pack(443)))) || (XVar)(XVar.Equals(XVar.Pack(MVCFunctions.GetServerPort()), XVar.Pack(80)))) ? XVar.Pack("") : XVar.Pack(MVCFunctions.Concat(":", MVCFunctions.GetServerPort())))))), MVCFunctions.substr((XVar)(MVCFunctions.GetScriptName()), new XVar(0), (XVar)(MVCFunctions.strrpos((XVar)(MVCFunctions.GetScriptName()), new XVar("/"))))));
}
public override XVar addSpansForGridCells(dynamic _param_type, dynamic record, dynamic _param_data = null)
{
#region default values
if (_param_data as Object == null)
{
_param_data = new XVar();
}
#endregion
#region pass-by-value parameters
dynamic var_type = XVar.Clone(_param_type);
dynamic data = XVar.Clone(_param_data);
#endregion
if (var_type == "add")
{
base.addSpansForGridCells((XVar)(var_type), (XVar)(record), (XVar)(data));
return(null);
}
if (XVar.Pack(!(XVar)(data == null)))
{
dynamic dispVal = null;
if (XVar.Pack(this.dispFieldAlias))
{
dispVal = XVar.Clone(data[this.dispFieldAlias]);
}
else
{
dispVal = XVar.Clone(data[this.dispField]);
}
this.lookupValuesArr.InitAndSetArrayItem(new XVar("linkVal", data[this.linkField], "dispVal", dispVal), null);
}
return(null);
}
public override XVar xt_doevent(dynamic _param_params)
{
XVar var_params = _param_params.Clone();
XVar eventName, eventObj;
if (this.xt_events.KeyExists(var_params["custom1"]))
{
XVar eventArr;
eventArr = this.xt_events[var_params["custom1"]];
if (eventArr.KeyExists("method"))
{
XVar method;
var_params = new XVar();
if (eventArr.KeyExists("params"))
{
var_params = eventArr["params"];
}
method = eventArr["method"];
return(eventArr["object"].Invoke(method, var_params));
}
}
eventObj = GlobalVars.globalEvents;
if (!eventObj)
{
return(null);
}
eventName = var_params["custom1"];
if (!eventObj.Invoke("exists", eventName))
{
return(null);
}
return(eventObj.Invoke("event_" + MVCFunctions.GoodFieldName(eventName).ToString(), var_params));
}
public virtual XVar buildUserFile(dynamic _param_file)
{
#region pass-by-value parameters
dynamic file = XVar.Clone(_param_file);
#endregion
dynamic hasThumbnail = null, userFile = XVar.Array();
userFile = XVar.Clone(XVar.Array());
userFile.InitAndSetArrayItem(file["usrName"], "name");
userFile.InitAndSetArrayItem(file["size"], "size");
userFile.InitAndSetArrayItem(file["type"], "type");
userFile.InitAndSetArrayItem(CommonFunctions.CheckImageExtension((XVar)(file["name"])) != false, "isImg");
if (XVar.Pack(file["error"]))
{
userFile.InitAndSetArrayItem(file["error"], "error");
}
hasThumbnail = XVar.Clone(file["thumbnail"] != "");
userFile.InitAndSetArrayItem(MVCFunctions.GetTableLink(new XVar("mfhandler"), new XVar(""), (XVar)(MVCFunctions.Concat("file=", MVCFunctions.RawUrlEncode((XVar)(userFile["name"])), "&table=", MVCFunctions.RawUrlEncode((XVar)(this.table)), "&field=", MVCFunctions.RawUrlEncode((XVar)(this.field)), "&pageType=", MVCFunctions.RawUrlEncode((XVar)(this.pageType)), (XVar.Pack(this.tkeys != "") ? XVar.Pack(this.tkeys) : XVar.Pack(MVCFunctions.Concat("&fkey=", this.formStamp)))))), "url");
if (XVar.Pack(hasThumbnail))
{
userFile.InitAndSetArrayItem(MVCFunctions.Concat(userFile["url"], "&thumbnail=1"), "thumbnail_url");
}
else
{
userFile.InitAndSetArrayItem("", "thumbnail_url");
}
return(userFile);
}
public static XVar create_method_assignment(XVar method, object var_object, XVar _params = null)
{
var ret = XVar.Array();
ret["method"] = (XVar)MVCFunctions.AssignMethod(method, var_object, _params);
return(ret);
}
public static XVar create_function_assignment(XVar func, XVar _params, XVar obj = null)
{
var ret = XVar.Array();
ret["func"] = (XVar)MVCFunctions.AssignFunction(func, _params, obj);
return(ret);
}
private void WriteToPage(object page, XVar objectToWrite)
{
if (objectToWrite.IsArray())
{
if (objectToWrite.KeyExists("method"))
{
XVar parameters = objectToWrite.KeyExists("params") ? objectToWrite["params"] : new XVar();
xtMethodDelegate invokedMethod = (xtMethodDelegate)objectToWrite["method"].Value;
MVCFunctions.ob_start();
var result = invokedMethod.Invoke(parameters);
var resultStr = result as object == null ? "" : result.ToString();
MvcHtmlString textToWrite = MvcHtmlString.Create(MVCFunctions.ob_get_contents() + resultStr);
MVCFunctions.ob_end_clean();
page.GetType().GetMethod("Write", new Type[] { typeof(MvcHtmlString) }).Invoke(page, new object[] { textToWrite });
}
}
else
{
page.GetType().GetMethod("Write", new Type[] { typeof(MvcHtmlString) }).Invoke(page, new object[] { MvcHtmlString.Create(objectToWrite.ToString()) });
}
}
public override XVar getFieldValueCopy(dynamic _param_fieldValue)
{
#region pass-by-value parameters
dynamic fieldValue = XVar.Clone(_param_fieldValue);
#endregion
dynamic absoluteUploadDirPath = null, filesData = XVar.Array(), uploadFolder = null;
initUploadHandler();
uploadFolder = XVar.Clone(this.pageObject.pSetEdit.getUploadFolder((XVar)(this.field)));
absoluteUploadDirPath = XVar.Clone(this.pageObject.pSetEdit.getFinalUploadFolder((XVar)(this.field)));
filesData = XVar.Clone(MVCFunctions.my_json_decode((XVar)(fieldValue)));
if ((XVar)(!(XVar)(MVCFunctions.is_array((XVar)(filesData)))) || (XVar)(MVCFunctions.count(filesData) == 0))
{
return(fieldValue);
}
foreach (KeyValuePair <XVar, dynamic> fileData in filesData.GetEnumerator())
{
dynamic info = XVar.Array(), newFieldName = null;
info = XVar.Clone(this.upload_handler.pathinfo_local((XVar)(fileData.Value["usrName"])));
newFieldName = XVar.Clone(this.upload_handler.tempnam_sfx((XVar)(absoluteUploadDirPath), (XVar)(info["filename"]), (XVar)(info["extension"])));
MVCFunctions.runner_copy_file((XVar)(MVCFunctions.getabspath((XVar)(fileData.Value["name"]))), (XVar)(MVCFunctions.Concat(absoluteUploadDirPath, newFieldName)));
filesData.InitAndSetArrayItem(MVCFunctions.Concat(uploadFolder, newFieldName), fileData.Key, "name");
if (XVar.Pack(this.pageObject.pSetEdit.getCreateThumbnail((XVar)(this.field))))
{
dynamic newThumbName = null, thumbnailPrefix = null;
thumbnailPrefix = XVar.Clone(this.pageObject.pSetEdit.getStrThumbnail((XVar)(this.field)));
newThumbName = XVar.Clone(this.upload_handler.tempnam_sfx((XVar)(absoluteUploadDirPath), (XVar)(MVCFunctions.Concat(thumbnailPrefix, info["filename"])), (XVar)(info["extension"])));
MVCFunctions.runner_copy_file((XVar)(MVCFunctions.getabspath((XVar)(fileData.Value["thumbnail"]))), (XVar)(MVCFunctions.Concat(absoluteUploadDirPath, newThumbName)));
filesData.InitAndSetArrayItem(MVCFunctions.Concat(uploadFolder, newThumbName), fileData.Key, "thumbnail");
}
}
return(MVCFunctions.my_json_encode((XVar)(filesData)));
}
public override XVar showPage()
{
dynamic bricksExcept = XVar.Array();
BeforeShowList();
if (XVar.Pack(mobileTemplateMode()))
{
this.xt.assign(new XVar("cancelbutton_block"), new XVar(true));
this.xt.assign(new XVar("searchform_block"), new XVar(true));
this.xt.assign(new XVar("searchform_showall"), new XVar(true));
bricksExcept = XVar.Clone(new XVar(0, "grid_mobile", 1, "message", 2, "pagination", 3, "vmsearch2", 4, "cancelbutton_mobile"));
}
else
{
bricksExcept = XVar.Clone(new XVar(0, "grid", 1, "message", 2, "pagination", 3, "vsearch1", 4, "vsearch2", 5, "search", 6, "recordcontrols_new", 7, "bsgrid_tabs"));
if (getLayoutVersion() == Constants.BOOTSTRAP_LAYOUT)
{
bricksExcept.InitAndSetArrayItem("add", null);
bricksExcept.InitAndSetArrayItem("reorder_records", null);
}
}
this.xt.hideAllBricksExcept((XVar)(bricksExcept));
this.xt.prepare_template((XVar)(this.templatefile));
showPageAjax();
return(null);
}
public virtual XVar updateUserGroups(dynamic _param_user, dynamic _param_groups)
{
#region pass-by-value parameters
dynamic user = XVar.Clone(_param_user);
dynamic groups = XVar.Clone(_param_groups);
#endregion
dynamic grConnection = null, groupIdWFieldName = null, membersWTableName = null, userNameWFieldName = null;
grConnection = XVar.Clone(GlobalVars.cman.getForUserGroups());
membersWTableName = XVar.Clone(grConnection.addTableWrappers(new XVar("dbo.acceso_ugmembers")));
userNameWFieldName = XVar.Clone(grConnection.addFieldWrappers(new XVar("UserName")));
groupIdWFieldName = XVar.Clone(grConnection.addFieldWrappers(new XVar("GroupID")));
foreach (KeyValuePair <XVar, dynamic> state in groups.GetEnumerator())
{
dynamic sql = null;
if (state.Value == 1)
{
sql = XVar.Clone(MVCFunctions.Concat("insert into ", membersWTableName, " (", userNameWFieldName, ", ", groupIdWFieldName, ") values (", grConnection.prepareString((XVar)(user)), ",", state.Key, ")"));
}
else
{
sql = XVar.Clone(MVCFunctions.Concat("delete from ", membersWTableName, " where ", userNameWFieldName, "=", grConnection.prepareString((XVar)(user)), " and ", groupIdWFieldName, "=", state.Key));
}
grConnection.exec((XVar)(sql));
}
return(null);
}
public override XVar SecuritySQL(dynamic _param_strAction, dynamic _param_table = null)
{
#region default values
if (_param_table as Object == null)
{
_param_table = new XVar("");
}
#endregion
#region pass-by-value parameters
dynamic strAction = XVar.Clone(_param_strAction);
dynamic table = XVar.Clone(_param_table);
#endregion
dynamic strPerm = null;
if (XVar.Pack(!(XVar)(MVCFunctions.strlen((XVar)(table)))))
{
table = XVar.Clone(GlobalVars.strTableName);
}
strPerm = XVar.Clone(CommonFunctions.GetUserPermissions((XVar)(table)));
if (XVar.Equals(XVar.Pack(MVCFunctions.strpos((XVar)(strPerm), new XVar("S"))), XVar.Pack(false)))
{
strPerm = MVCFunctions.Concat(strPerm, "S");
}
return(CommonFunctions.SecuritySQL((XVar)(strAction), (XVar)(table), (XVar)(strPerm)));
}
public virtual XVar exportTo(dynamic _param_type, dynamic _param_rs, dynamic _param_nPageSize)
{
#region pass-by-value parameters
dynamic var_type = XVar.Clone(_param_type);
dynamic rs = XVar.Clone(_param_rs);
dynamic nPageSize = XVar.Clone(_param_nPageSize);
#endregion
if (MVCFunctions.substr((XVar)(var_type), new XVar(0), new XVar(5)) == "excel")
{
GlobalVars.locale_info.InitAndSetArrayItem("0", "LOCALE_SGROUPING");
GlobalVars.locale_info.InitAndSetArrayItem("0", "LOCALE_SMONGROUPING");
CommonFunctions.ExportToExcel((XVar)(rs), (XVar)(nPageSize), (XVar)(this.eventsObject), (XVar)(this.cipherer), this);
return(null);
}
if (var_type == "word")
{
ExportToWord((XVar)(rs), (XVar)(nPageSize));
return(null);
}
if (var_type == "xml")
{
ExportToXML((XVar)(rs), (XVar)(nPageSize));
return(null);
}
if (var_type == "csv")
{
GlobalVars.locale_info.InitAndSetArrayItem("0", "LOCALE_SGROUPING");
GlobalVars.locale_info.InitAndSetArrayItem(".", "LOCALE_SDECIMAL");
GlobalVars.locale_info.InitAndSetArrayItem("0", "LOCALE_SMONGROUPING");
GlobalVars.locale_info.InitAndSetArrayItem(".", "LOCALE_SMONDECIMALSEP");
ExportToCSV((XVar)(rs), (XVar)(nPageSize));
}
return(null);
}
public virtual XVar initLookupParams()
{
if ((XVar)(this.mainPageType != Constants.PAGE_ADD) && (XVar)(this.mainPageType != Constants.PAGE_EDIT))
{
this.mainPageType = new XVar(Constants.PAGE_SEARCH);
}
this.mainPSet = XVar.Clone(new ProjectSettings((XVar)(this.mainTable), (XVar)(this.mainPageType)));
this.linkField = XVar.Clone(this.mainPSet.getLinkField((XVar)(this.mainField)));
this.dispField = XVar.Clone(this.mainPSet.getDisplayField((XVar)(this.mainField)));
if (XVar.Pack(this.mainPSet.getCustomDisplay((XVar)(this.mainField))))
{
this.dispFieldAlias = XVar.Clone(CommonFunctions.GetGlobalData(new XVar("dispFieldAlias"), new XVar("rrdf1")));
this.customField = XVar.Clone(this.linkField);
}
outputFieldValue((XVar)(this.linkField), new XVar(2));
outputFieldValue((XVar)(this.dispField), new XVar(2));
if ((XVar)(this.dispFieldAlias) && (XVar)(this.pSet.appearOnListPage((XVar)(this.dispField))))
{
this.lookupSelectField = XVar.Clone(this.dispField);
}
else
{
if (XVar.Pack(this.pSet.appearOnListPage((XVar)(this.dispField))))
{
this.lookupSelectField = XVar.Clone(this.dispField);
}
else
{
this.lookupSelectField = XVar.Clone(this.listFields[0]["fName"]);
}
}
this.mainContext = XVar.Clone(getMainContext());
return(null);
}
protected virtual XVar getControlMap(dynamic _param_fName, dynamic _param_format, dynamic _param_recId, dynamic _param_fieldNum, dynamic _param_hidden, dynamic _param_value)
{
#region pass-by-value parameters
dynamic fName = XVar.Clone(_param_fName);
dynamic format = XVar.Clone(_param_format);
dynamic recId = XVar.Clone(_param_recId);
dynamic fieldNum = XVar.Clone(_param_fieldNum);
dynamic hidden = XVar.Clone(_param_hidden);
dynamic value = XVar.Clone(_param_value);
#endregion
dynamic ctrlsMap = XVar.Array(), preload = null;
ctrlsMap = XVar.Clone(new XVar("controls", XVar.Array()));
ctrlsMap.InitAndSetArrayItem(fName, "controls", "fieldName");
ctrlsMap.InitAndSetArrayItem(Constants.MODE_SEARCH, "controls", "mode");
ctrlsMap.InitAndSetArrayItem(format, "controls", "editFormat");
ctrlsMap.InitAndSetArrayItem(recId, "controls", "id");
ctrlsMap.InitAndSetArrayItem(fieldNum, "controls", "ctrlInd");
ctrlsMap.InitAndSetArrayItem(hidden, "controls", "hidden");
ctrlsMap.InitAndSetArrayItem(this.tName, "controls", "table");
preload = XVar.Clone(this.pageObj.fillPreload((XVar)(fName), (XVar)(new XVar(0, fName)), (XVar)(new XVar(fName, value)), (XVar)(this.controlsContainer)));
if (!XVar.Equals(XVar.Pack(preload), XVar.Pack(false)))
{
ctrlsMap.InitAndSetArrayItem(preload, "controls", "preloadData");
}
return(ctrlsMap);
}
public override XVar SQLWhere(dynamic _param_SearchFor, dynamic _param_strSearchOption, dynamic _param_SearchFor2, dynamic _param_etype, dynamic _param_isSuggest)
{
#region pass-by-value parameters
dynamic SearchFor = XVar.Clone(_param_SearchFor);
dynamic strSearchOption = XVar.Clone(_param_strSearchOption);
dynamic SearchFor2 = XVar.Clone(_param_SearchFor2);
dynamic etype = XVar.Clone(_param_etype);
dynamic isSuggest = XVar.Clone(_param_isSuggest);
#endregion
dynamic baseResult = null, gstrField = null;
baseResult = XVar.Clone(baseSQLWhere((XVar)(strSearchOption)));
if (XVar.Equals(XVar.Pack(baseResult), XVar.Pack(false)))
{
return("");
}
if (baseResult != XVar.Pack(""))
{
return(baseResult);
}
if (XVar.Pack(CommonFunctions.IsCharType((XVar)(this.var_type))))
{
gstrField = XVar.Clone(getFieldSQLDecrypt());
if ((XVar)((XVar)(!(XVar)(this.btexttype)) && (XVar)(!(XVar)(this.pageObject.cipherer.isFieldPHPEncrypted((XVar)(this.field))))) && (XVar)(this.pageObject.pSetEdit.getNCSearch()))
{
gstrField = XVar.Clone(this.connection.upper((XVar)(gstrField)));
}
}
else
{
if ((XVar)(strSearchOption == "Contains") || (XVar)(strSearchOption == "Starts with"))
{
gstrField = XVar.Clone(this.connection.field2char((XVar)(getFieldSQLDecrypt()), (XVar)(this.var_type)));
}
else
{
gstrField = XVar.Clone(getFieldSQLDecrypt());
}
}
if ((XVar)(strSearchOption == "Contains") || (XVar)(strSearchOption == "Starts with"))
{
SearchFor = XVar.Clone(this.connection.escapeLIKEpattern((XVar)(SearchFor)));
}
if (strSearchOption == "Contains")
{
SearchFor = XVar.Clone(MVCFunctions.Concat("%", SearchFor, "%"));
}
else
{
if (strSearchOption == "Starts with")
{
SearchFor = XVar.Clone(MVCFunctions.Concat(SearchFor, "%"));
}
}
if ((XVar)((XVar)(strSearchOption == "Contains") || (XVar)(strSearchOption == "Starts with")) || (XVar)(strSearchOption == "Equals"))
{
return(buildWhere((XVar)(gstrField), (XVar)(SearchFor), (XVar)(strSearchOption == "Equals")));
}
return("");
}
public virtual XVar getSearchRadio()
{
dynamic id508l = null, id508n = null, resArr = XVar.Array();
resArr = XVar.Clone(XVar.Array());
resArr.InitAndSetArrayItem(new XVar(0, "", 1, ""), "all_checkbox_label");
resArr.InitAndSetArrayItem(new XVar(0, "", 1, ""), "any_checkbox_label");
if (XVar.Pack(CommonFunctions.isEnableSection508()))
{
resArr.InitAndSetArrayItem(new XVar(0, "<label for=\"all_checkbox\">", 1, "</label>"), "all_checkbox_label");
resArr.InitAndSetArrayItem(new XVar(0, "<label for=\"any_checkbox\">", 1, "</label>"), "any_checkbox_label");
}
id508l = new XVar("id=\"all_checkbox\" ");
id508n = new XVar("id=\"any_checkbox\" ");
resArr.InitAndSetArrayItem(id508l, "all_checkbox");
resArr.InitAndSetArrayItem(id508n, "any_checkbox");
resArr["all_checkbox"] = MVCFunctions.Concat(resArr["all_checkbox"], "value=\"and\" ");
resArr["any_checkbox"] = MVCFunctions.Concat(resArr["any_checkbox"], "value=\"or\" ");
if ((XVar)(this.globSrchParams.KeyExists("srchTypeRadio")) && (XVar)(this.globSrchParams["srchTypeRadio"] == "or"))
{
resArr["any_checkbox"] = MVCFunctions.Concat(resArr["any_checkbox"], " checked");
}
else
{
resArr["all_checkbox"] = MVCFunctions.Concat(resArr["all_checkbox"], " checked");
}
return(resArr);
}
public virtual XVar buildWhere(dynamic _param_gstrField, dynamic _param_value, dynamic _param_equals = null)
{
#region default values
if (_param_equals as Object == null)
{
_param_equals = new XVar(false);
}
#endregion
#region pass-by-value parameters
dynamic gstrField = XVar.Clone(_param_gstrField);
dynamic value = XVar.Clone(_param_value);
dynamic equals = XVar.Clone(_param_equals);
#endregion
dynamic likeVal = null, notLikeVal = null, testSymbols = null;
likeVal = XVar.Clone(this.connection.prepareString((XVar)(MVCFunctions.Concat("%searchStr\":\"", value, ":sStrEnd\"%"))));
notLikeVal = XVar.Clone(this.connection.prepareString((XVar)(value)));
if ((XVar)((XVar)(!(XVar)(this.btexttype)) && (XVar)(CommonFunctions.IsCharType((XVar)(this.var_type)))) && (XVar)(this.pageObject.pSetEdit.getNCSearch()))
{
likeVal = XVar.Clone(this.connection.upper((XVar)(likeVal)));
notLikeVal = XVar.Clone(this.connection.upper((XVar)(notLikeVal)));
}
if (this.connection.dbType == Constants.nDATABASE_Access)
{
testSymbols = new XVar("'_{%}_'");
}
else
{
testSymbols = new XVar("'[{%'");
}
return(MVCFunctions.Concat("((", gstrField, " ", this.var_like, " ", testSymbols, " and ", gstrField, " ", this.var_like, " ", likeVal, ") or (", gstrField, " not ", this.var_like, " ", testSymbols, " and ", gstrField, " ", (XVar.Pack(equals) ? XVar.Pack("=") : XVar.Pack(this.var_like)), " ", notLikeVal, "))"));
}
public RunnerContext()
{
dynamic context = null;
context = XVar.Clone(new RunnerContextItem(new XVar(Constants.CONTEXT_GLOBAL), (XVar)(XVar.Array())));
this.stack.InitAndSetArrayItem(context, MVCFunctions.count(this.stack));
}
public override XVar getSearchOptions(dynamic _param_selOpt, dynamic _param_not, dynamic _param_both)
{
#region pass-by-value parameters
dynamic selOpt = XVar.Clone(_param_selOpt);
dynamic var_not = XVar.Clone(_param_not);
dynamic both = XVar.Clone(_param_both);
#endregion
dynamic isPHPEncripted = null, optionsArray = XVar.Array();
optionsArray = XVar.Clone(XVar.Array());
isPHPEncripted = XVar.Clone(this.pageObject.cipherer.isFieldPHPEncrypted((XVar)(this.field)));
if (XVar.Pack(!(XVar)(isPHPEncripted)))
{
optionsArray.InitAndSetArrayItem(Constants.CONTAINS, null);
optionsArray.InitAndSetArrayItem(Constants.EQUALS, null);
}
optionsArray.InitAndSetArrayItem(Constants.EMPTY_SEARCH, null);
if (XVar.Pack(both))
{
if (XVar.Pack(!(XVar)(isPHPEncripted)))
{
optionsArray.InitAndSetArrayItem(Constants.NOT_CONTAINS, null);
optionsArray.InitAndSetArrayItem(Constants.NOT_EQUALS, null);
}
optionsArray.InitAndSetArrayItem(Constants.NOT_EMPTY, null);
}
return(buildSearchOptions((XVar)(optionsArray), (XVar)(selOpt), (XVar)(var_not), (XVar)(both)));
}
private void updateCokRiskmasterPfImportRecord(XVar recordWhereClause, string isValid)
{
XVar setIsValidColumn = new XVar();
setIsValidColumn.SetArrayItem("IS_VALID", isValid);
oracleDBFacade.Update("xxcok.xxcok_rm_import_pf", setIsValidColumn, recordWhereClause);
}
public override XVar afterSuccessfulSave()
{
if (0 < MVCFunctions.count(XSession.Session[MVCFunctions.Concat("mupload_", this.formStamp)]))
{
foreach (KeyValuePair <XVar, dynamic> fileArray in XSession.Session[MVCFunctions.Concat("mupload_", this.formStamp)].GetEnumerator())
{
if (XVar.Equals(XVar.Pack(fileArray.Value["deleted"]), XVar.Pack(true)))
{
dynamic file_path = null;
file_path = XVar.Clone(fileArray.Value["file"]["name"]);
if (XVar.Pack(MVCFunctions.file_exists(file_path)))
{
MVCFunctions.unlink((XVar)(file_path));
}
if (fileArray.Value["file"]["thumbnail"] != "")
{
file_path = XVar.Clone(fileArray.Value["file"]["thumbnail"]);
if (XVar.Pack(MVCFunctions.file_exists(file_path)))
{
MVCFunctions.unlink((XVar)(file_path));
}
}
}
}
}
XSession.Session.Remove(MVCFunctions.Concat("mupload_", this.formStamp));
return(null);
}
private void countValidRiskMasterPayments()
{
string selectValidRecordsStatement = @"select count(*) as COUNT
FROM XXCOK.XXCOK_RM_IMPORT_PF PF inner join
(select
IMPORT_ID,
IMPORT_DATE,
PAYMENT_ID,
nvl(max(INVOICE_NUMBER), '0') as INVOICE_NUMBER
from XXCOK.XXCOK_RM_IMPORT_PD
group by IMPORT_ID, IMPORT_DATE, PAYMENT_ID) PD
on PF.IMPORT_ID = PD.IMPORT_ID and
PF.IMPORT_DATE = PD.IMPORT_DATE and
PF.PAYMENT_ID = PD.PAYMENT_ID
where PF.IS_VALID = 1
AND IS_PROCESSED = 0";
dynamic qresult = oracleDBFacade.Query(selectValidRecordsStatement);
XVar recordXVar = qresult.fetchAssoc();
if (recordXVar != null && recordXVar.Count() > 0)
{
dynamic record = recordXVar.Value;
XVar value;
if (record.TryGetValue("COUNT", out value))
{
if (value != null && value.IsNumeric())
{
int count = int.Parse(value);
this.TotalRecordsValidated = this.TotalRecordsValidated + count;
}
}
}
}
public ViewControlsContainer(dynamic _param_pSet_packed, dynamic _param_pageType, dynamic _param_pageObject = null)
{
#region packeted values
ProjectSettings _param_pSet = XVar.UnPackProjectSettings(_param_pSet_packed);
#endregion
#region default values
if (_param_pageObject as Object == null)
{
_param_pageObject = new XVar();
}
#endregion
#region pass-by-value parameters
ProjectSettings pSet = XVar.Clone(_param_pSet);
dynamic pageType = XVar.Clone(_param_pageType);
dynamic pageObject = XVar.Clone(_param_pageObject);
#endregion
this.pSet = XVar.UnPackProjectSettings(pSet);
this.pageType = XVar.Clone(pageType);
this.pageObject = XVar.Clone(pageObject);
this.tName = XVar.Clone(pSet.getTableName());
if (XVar.Pack(pageObject))
{
this.pSet.setPageMode((XVar)(pageObject.mode));
}
this.searchHighlight = XVar.Clone(highlightSearchResults());
}
