private DataTable RetrieveRoutingTable()
{
QueryClass lcQuery;
lcQuery = new QueryClass(QueryClass.QueryType.RetrieveRoutingTable);
return(lcQuery.RunQuery());
}
private DataTable RetrieveInputInfoList(String paDataGroup)
{
QueryClass lcQuery;
lcQuery = new QueryClass(QueryClass.QueryType.RetrieveInputInfo);
lcQuery.ReplacePlaceHolder("$ESERVICEID", clEServiceID, true);
lcQuery.ReplacePlaceHolder("$INPUTGROUP", paDataGroup, true);
return(lcQuery.RunQuery());
}
private DataTable RetrieveMessageList()
{
QueryClass lcQuery;
lcQuery = new QueryClass(QueryClass.QueryType.RetrieveMessageList);
lcQuery.ReplacePlaceHolder("$LANGUAGE", ApplicationFrame.GetInstance().ActiveSubscription.ActiveLanguage.ActiveRow.Language.ToLower(), true);
lcQuery.ReplacePlaceHolder("$FORMNAME", clFormInfoManager.ActiveRow.FormName, true);
clFormInfoManager.ReplaceQueryPlaceHolder(lcQuery);
return(lcQuery.RunQuery());
}
public DataTable RunRetrieveQuery()
{
QueryClass lcQuery;
if (!String.IsNullOrEmpty(ActiveRow.RetrieveQuery))
{
lcQuery = new QueryClass(ActiveRow.RetrieveQuery, clConnectionMode);
ReplaceQueryPlaceHolder(lcQuery);
lcQuery.ReplaceDictionaryPlaceHolder(clFormParam);
return(lcQuery.RunQuery());
}
else
{
return(null);
}
}
private AppManifestRow GetAppManifestRow(String paSubscriptionID)
{
DataTable lcDataTable;
QueryClass lcQuery;
lcQuery = new QueryClass(QueryClass.QueryType.GetAppManifestRow);
lcQuery.ReplacePlaceHolder("$SUBSCRIPTIONID", paSubscriptionID, true);
if (((lcDataTable = lcQuery.RunQuery()) != null) && (lcDataTable.Rows.Count > 0))
{
return(new AppManifestRow(lcDataTable.Rows[0]));
}
else
{
return(null);
}
}
protected static SessionRow GetSessionRow(String paSessionKey)
{
QueryClass lcQuery;
DataTable lcDataTable;
lcQuery = new QueryClass(QueryClass.QueryType.GetSessionRowBySessionKey);
lcQuery.ReplacePlaceHolder("$SESSIONKEY", paSessionKey, true);
if (((lcDataTable = lcQuery.RunQuery()) != null) && (lcDataTable.Rows.Count > 0))
{
return(new SessionRow(lcDataTable.Rows[0]));
}
else
{
return(null);
}
}
static private FormInfoRow GetFormInfoRow(String paFormName)
{
QueryClass lcQuery;
DataTable lcDataTable;
lcQuery = new QueryClass(QueryClass.QueryType.GetFormInfoRow);
lcQuery.ReplacePlaceHolder("$FORMNAME", paFormName, true);
if (((lcDataTable = lcQuery.RunQuery()) != null) && (lcDataTable.Rows.Count > 0))
{
return(new FormInfoRow(lcDataTable.Rows[0]));
}
else
{
return(null);
}
}
private String[] RetrieveData(String paQueryString)
{
QueryClass lcQueryClass;
DataTable lcDataTable;
if (!String.IsNullOrEmpty(paQueryString))
{
lcQueryClass = new QueryClass(paQueryString, QueryClass.ConnectionMode.EService);
ApplicationFrame.GetInstance().ActiveFormInfoManager.ReplaceQueryPlaceHolder(lcQueryClass);
if (((lcDataTable = lcQueryClass.RunQuery()) != null) && (lcDataTable.Rows.Count > 0))
{
return(General.SingleDimensionStringArray(lcDataTable.Select(), lcDataTable.Columns[0].ColumnName));
}
}
return(null);
}
protected static SessionRow GetSessionRow(String paSubscriptionID, String paLoginID)
{
QueryClass lcQuery;
DataTable lcDataTable;
lcQuery = new QueryClass(QueryClass.QueryType.GetSessionRow);
lcQuery.ReplacePlaceHolder("$SUBSCRIPTIONID", paSubscriptionID, true);
lcQuery.ReplacePlaceHolder("$LOGINID", paLoginID, true);
if (((lcDataTable = lcQuery.RunQuery()) != null) && (lcDataTable.Rows.Count > 0))
{
return(new SessionRow(lcDataTable.Rows[0]));
}
else
{
return(null);
}
}
private DataTable RetrieveData()
{
QueryClass lcQuery;
if (!String.IsNullOrEmpty(clFormInfoRow.RetrieveQuery))
{
try
{
lcQuery = new QueryClass(clFormInfoRow.RetrieveQuery, clConnectionMode);
lcQuery.ReplaceDictionaryPlaceHolder(clFormParam);
return(lcQuery.RunQuery());
}
catch (Exception paException)
{
General.WriteExceptionLog(paException, "FORMINFOMANAGER.RETRIEVEDATA");
}
}
return(null);
}