private static string GetXWebToken()
{
SchoolListTransformer.NetForumXML.netForumXMLSoapClient client = new NetForumXML.netForumXMLSoapClient();
SchoolListTransformer.NetForumXML.AuthorizationToken token = new NetForumXML.AuthorizationToken();
String AuthResult = String.Empty;
try
{
String xwebUser = ConfigurationManager.AppSettings.Get("XWebUser");
String xwebPwd = ConfigurationManager.AppSettings.Get("XWebPwd");
token = client.Authenticate(xwebUser, xwebPwd, out AuthResult);
return(token.Token);
}
catch (Exception e)
{
Console.Out.Write("Error connecting to XWeb: {0}", e.Message);
if (!bChangedOutStream)
{
System.Console.Read();
}
}
finally
{
if (client.State == System.ServiceModel.CommunicationState.Opened)
{
client.Close();
}
}
return(token.Token);
}
private static System.Xml.XmlNode GetSchoolList(string sztoken)
{
SchoolListTransformer.NetForumXML.netForumXMLSoapClient client = new NetForumXML.netForumXMLSoapClient();
SchoolListTransformer.NetForumXML.AuthorizationToken token = new NetForumXML.AuthorizationToken();
String szObjectName = "Organization @TOP -1";
String szColumnList = "org_name,org_school_oe_code_ext,org_school_oe_branch_code_ext,org_acronym";
String szWhereClause = "org_ogt_code = 'School' and org_delete_flag = 0";
String szOrderBy = "org_name ASC";
System.Xml.XmlNode node = null;
try
{
token.Token = sztoken;
node = client.GetQuery(ref token, szObjectName, szColumnList, szWhereClause, szOrderBy);
}
catch (Exception e)
{
Console.WriteLine("Error while trying to retrieve school list from Netforum: {0}", e.Message);
if (!bChangedOutStream)
{
System.Console.Read();
}
}
finally
{
if (client.State == System.ServiceModel.CommunicationState.Opened)
{
client.Close();
}
}
return(node);
}
