/**
* <summary>Build logininfo object for the web service.</summary>
* <remarks>Note: this is the LoginInfo class that is used by the web service and not the loginInfo class that is used for modifying the
* login information when filing the web service through the menu option.</remarks>
* <returns>Returns an object of the class LoginInfo that will be filed to the XMLService web service.</returns>
*/
private XMLService.LoginInfo buildLoginInfo()
{
var loginInfo = new XMLService.LoginInfo();
loginInfo.systemCode = systemCode;
loginInfo.userName = userName;
loginInfo.password = password;
return(loginInfo);
}
/**
* <summary> This method will construct a SOAP message and send it to the web service. </summary>
* <remarks> This web service does not seem to be enabled. It needs to be enabled before using otherwise,
* this program will encounter an InvalidOperationException</remarks>
* <param name="loginInfo">Web service LoginInfo class that contains the logon credentials necessary to file the web service.</param>
* <param name="sql">The SQL query text to be interpreted by the Cache database.</param>
* <param name="runtimeMode">This property will set the SQL runtime mode for the query to be executed. There are 3 modes to choose from 0,1,2.
* 0 for LOGICAL mode also the DEFAULT. 1 for ODBC mode. 2 for DISPLAY mode.</param>
* <returns>The web service response is returned by this method because this is the call that is made to the web service. This response will contain
* the sql query results if no errors were encountered otherwise read the message part of the response to determine what error was detected.</returns>
*/
private XMLService.XMLResponse submitSQL(XMLService.LoginInfo loginInfo, String sql, String runtimeMode)
{
try
{
var XMLServiceInstance = new XMLService.XMLService();
return(XMLServiceInstance.XMLResultSet(loginInfo, sql, runtimeMode));
}
catch (InvalidOperationException e)
{
XMLService.XMLResponse err = new XMLService.XMLResponse();
err.resultCode = "-1";
err.resultMessage = e.Message + newline + "A fatal exception was encountered, this is known to occur when the XMLService web service is not"
+ " enabled in your system. Contact your Netsmart Representative for further information.";
return(err);
}
}
