protected void DrawUIOnLoad()
{
string DirectServiceURL = ConfigurationSettings.AppSettings["DirectServiceURL"];
string ProfilesURL = ConfigurationSettings.AppSettings["URLBASE"]; ;
string PopulationTypeText = ConfigurationSettings.AppSettings["DirectPopulationType"];
int QueryTimeout = 15;
try
{
QueryTimeout = Convert.ToInt16(ConfigurationSettings.AppSettings["DirectQueryTimeout"]);
}
catch { }
string sql = string.Empty;
string ResultDetailsURL = string.Empty;
string strResult = "";
XmlElement ResultXML = null;
SqlDataReader dr;
oDataIO = new DataIO();
SqlConnection Conn = new SqlConnection();
Conn = oDataIO.GetDBConnection("ProfilesDB");
sqlCmd = new SqlCommand();
sqlCmd.Connection = Conn;
if (Request["Request"] == null) { return; }
string task = Request["Request"].ToLower();
switch (task)
{
case "getsites":
string ResultStr = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>" + "<site-list>";
dr = oDataIO.GetSitesOrderBySortOrder();
while (dr.Read())
{
Int64 SiteID = Convert.ToInt64(dr["SiteID"]);
string SiteName = dr["SiteName"].ToString();
string QueryURL = dr["QueryURL"].ToString();
if (SiteName == null) SiteName = "";
if (QueryURL == null) QueryURL = "";
ResultStr = ResultStr + "<site-description><site-id>" + SiteID + "</site-id><name>" + cx(SiteName) + "</name><aggregate-query>" + cx(QueryURL) + "</aggregate-query></site-description>";
}
if (!dr.IsClosed)
dr.Close();
if (Conn.State == System.Data.ConnectionState.Open)
Conn.Close();
ResultStr += "</site-list>";
Response.ContentType = "text/xml";
Response.AddHeader("Content-Type", "text/xml;charset=UTF-8");
//Response.ContentEncoding.CodePage = 65001;
Response.Charset = "UTF-8";
Response.Write(ResultStr);
break;
case "incomingcount":
string q = Request["SearchPhrase"].Trim();
// Enter log record
sql = "insert into FSLogIncoming(Details,ReceivedDate,RequestIP,QueryString) " +
" values (0,GetDate()," + cs(Request.ServerVariables["REMOTE_ADDR"]) + "," + cs(q) + ")";
sqlCmd.CommandText = sql;
sqlCmd.CommandType = System.Data.CommandType.Text;
// Execute query
string QueryXML = "<Profiles Operation=\"GetPersonList\" Version=\"2\" xmlns=\"http://connects.profiles.schema/profiles/query\"><QueryDefinition><Name><LastName></LastName><FirstName></FirstName></Name><FacultyTypeList></FacultyTypeList><FacultyRankList></FacultyRankList><Affiliations><AffiliationList><Affiliation><InstitutionName></InstitutionName><DepartmentName></DepartmentName></Affiliation></AffiliationList></Affiliations><PersonFilterList></PersonFilterList><Keywords><KeywordString>" + cx(q) + "</KeywordString></Keywords></QueryDefinition><OutputOptions StartRecord=\"1\" MaxRecords=\"1\"></OutputOptions></Profiles>";
dr = oDataIO.GetPersonList_xml(cs(QueryXML));
if (dr.Read())
{
strResult = dr[0].ToString();
}
if (!dr.IsClosed)
dr.Close();
if (sqlCmd.Connection.State == System.Data.ConnectionState.Open)
sqlCmd.Connection.Close();
// Parse results
strResult = strResult.Replace(" xmlns=\"http://connects.profiles.schema/profiles/personlist\"", "");
XmlDocument objDoc = new XmlDocument();
objDoc.LoadXml(strResult);
ResultXML = objDoc.DocumentElement;
string QueryID = ResultXML.GetAttribute("QueryID");
string ResultCount = ResultXML.GetAttribute("TotalCount");
// Form result message
ResultStr = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>";
ResultStr += "<aggregation-result>";
ResultStr += "<count>" + ResultCount + "</count>";
ResultStr += "<population-type>" + PopulationTypeText + "</population-type>";
ResultStr += "<preview-URL>" + DirectServiceURL + "?Request=IncomingPreview&SearchPhrase=" + cx(q) + "</preview-URL>";
ResultStr += "<search-results-URL>" + DirectServiceURL + "?Request=IncomingDetails&SearchPhrase=" + cx(q) + "</search-results-URL>";
ResultStr += "</aggregation-result>";
// Send result
Response.ContentType = "text/xml";
Response.AddHeader("Content-Type", "text/xml;charset=UTF-8");
//Response.ContentEncoding.CodePage = 65001;
Response.Charset = "UTF-8";
Response.Write(ResultStr);
break;
case "incomingdetails":
q = Request["SearchPhrase"].Trim();
// Enter log record
sql = "insert into FSLogIncoming(Details,ReceivedDate,RequestIP,QueryString) ";
sql += " values (1,GetDate()," + cs(Request.ServerVariables["REMOTE_ADDR"]) + "," +
cs(q) + ")";
sqlCmd.CommandType = System.Data.CommandType.Text;
sqlCmd.CommandText = sql;
int iResult = sqlCmd.ExecuteNonQuery();
// Execute queryA
QueryXML = "<Profiles Operation=\"GetPersonList\" Version=\"2\" xmlns=\"http://connects.profiles.schema/profiles/query\"><QueryDefinition><Name><LastName></LastName><FirstName></FirstName></Name><FacultyTypeList></FacultyTypeList><FacultyRankList></FacultyRankList><Affiliations><AffiliationList><Affiliation><InstitutionName></InstitutionName><DepartmentName></DepartmentName></Affiliation></AffiliationList></Affiliations><PersonFilterList></PersonFilterList><Keywords><KeywordString>" + cx(q) + "</KeywordString></Keywords></QueryDefinition><OutputOptions StartRecord=\"1\" MaxRecords=\"1\"></OutputOptions></Profiles>";
dr = oDataIO.GetPersonList_xml(cs(QueryXML));
if (dr.Read())
strResult = dr[0].ToString();
if (!dr.IsClosed)
dr.Close();
if (sqlCmd.Connection.State == System.Data.ConnectionState.Open)
sqlCmd.Connection.Close();
// Parse results
strResult = strResult.Replace(" xmlns=\"http://connects.profiles.schema/profiles/personlist\"", "");
objDoc = new XmlDocument();
objDoc.LoadXml(strResult);
ResultXML = objDoc.DocumentElement;
QueryID = ResultXML.GetAttribute("QueryID");
ResultCount = ResultXML.GetAttribute("TotalCount");
if (ProfilesURL.Substring(ProfilesURL.Length - 1) != "/") { ProfilesURL += "/"; }
Response.Redirect(ProfilesURL + "Search.aspx?From=SP&Keyword=" + q);
break;
case "incomingpreview":
q = Request["SearchPhrase"].Trim();
Response.Write(DisplayPageHeader());
// Execute query
QueryXML = "<Profiles Operation=\"GetPersonList\" Version=\"2\" xmlns=\"http://connects.profiles.schema/profiles/query\"><QueryDefinition><Name><LastName></LastName><FirstName></FirstName></Name><FacultyTypeList></FacultyTypeList><FacultyRankList></FacultyRankList><Affiliations><AffiliationList><Affiliation><InstitutionName></InstitutionName><DepartmentName></DepartmentName></Affiliation></AffiliationList></Affiliations><PersonFilterList></PersonFilterList><Keywords><KeywordString>" + cx(q) + "</KeywordString></Keywords></QueryDefinition><OutputOptions StartRecord=\"1\" MaxRecords=\"1\"></OutputOptions></Profiles>";
dr = oDataIO.GetPersonList_xml(cs(QueryXML));
if (dr.Read())
{
strResult = dr[0].ToString();
}
if (!dr.IsClosed)
dr.Close();
// Parse results
strResult = strResult.Replace(" xmlns=\"http://connects.profiles.schema/profiles/personlist\"", "");
XmlDocument objDocincomepreview = new XmlDocument();
objDocincomepreview.LoadXml(strResult);
ResultXML = objDocincomepreview.DocumentElement;
QueryID = ResultXML.GetAttribute("QueryID");
ResultCount = ResultXML.GetAttribute("TotalCount");
Response.Write("<div style=\"width:260px;text-align:center;\"><b>");
if (Convert.ToInt64(ResultCount) == 0)
Response.Write("no people were found");
if (Convert.ToInt64(ResultCount) == 1)
Response.Write("one person was found");
if (Convert.ToInt64(ResultCount) > 1)
Response.Write(ResultCount + " people were found");
Response.Write("</b></div>");
if (Convert.ToInt64(ResultCount) > 0)
{
Response.Write("<div style=\"border-top:1px solid #999;width:260px;height:1px;overflow:hidden;margin:3px 0 3px 0;\"></div>");
Response.Write("<div style=\"width:290px;\">");
dr = oDataIO.GetFacultyRank(QueryID);
Int64 wz = 0;
while (dr.Read())
{
if (Convert.ToInt64(dr["n"]) > wz) wz = Convert.ToInt64(dr["n"]);
}
if(!dr.IsClosed)
dr.Close();
dr = oDataIO.GetFacultyRank(QueryID);
while (dr.Read())
{
Int64 w = 1 + Convert.ToInt64(100 * Convert.ToInt64(dr["n"]) / (wz * 1.000000));
Response.Write("<table cellpadding=\"0\" cellspacing=\"0\">");
Response.Write("<tr>");
Response.Write("<td style=\"width:120px; text-align:right; border-right:1px solid #000; padding-right:3px;\">" + dr["facultyrank"] + "</td>");
Response.Write("<td style=\"width:" + w.ToString() + "px; background-color:#900; \"></td>");
Response.Write("<td style=\"\">" + dr["n"] + "</td>");
Response.Write("<tr>");
Response.Write("</tr>");
Response.Write("</table>");
}
if (!dr.IsClosed)
dr.Close();
}
Response.Write("<div style=\"border-top:1px solid #999;width:260px;height:1px;overflow:hidden;margin:3px 0 3px 0;\"></div>");
Response.Write("<div style=\"width:260px;text-align:center;font-size:10px;\">Powered by Harvard Catalyst Profiles</div>");
Response.Write("</div>");
Response.Write("</body>");
Response.Write("</html>");
break;
/*
* The "outgoingcount" case test will call all public systems that are involved in DIRECT
* will receive one of our requests for what we have on
*/
case "outgoingcount":
if (Request["blank"] == "y")
{
Response.Write("<html><body></body></html>");
Response.End();
}
string SearchPhrase = Request["SearchPhrase"];
Response.Write("<script>parent.dsLoading=1;</script>" + Environment.NewLine);
dr = oDataIO.GetSitesOrderBySiteID();
SiteIDs = new int[1000];
URLs = new string[1000];
FSIDs = new string[1000];
Site site;
ListOfSites = new List<Site>();
Int64 sites = 0;
List<AsyncProcessing> ListOfThreads = new List<AsyncProcessing>();
AsyncProcessing async;
while (dr.Read())
{
SiteIDs[sites] = Convert.ToInt32(dr["SiteID"].ToString());
URLs[sites] = dr["QueryURL"] + SearchPhrase;
FSIDs[sites] = dr["FSID"].ToString();
site = new Site(URLs[sites], SiteIDs[sites], FSIDs[sites], SearchPhrase, HttpContext.Current);
ListOfSites.Add(site);
async = new AsyncProcessing();
async.BeginProcessRequest(site);
ListOfThreads.Add(async);
sites++;
}
if (!dr.IsClosed)
dr.Close();
//eat up the CPU for x number of seconds :) so all the requests can come back. This is set in the web.config file
DateTime end = DateTime.Now.AddSeconds(QueryTimeout);
while (DateTime.Now < end)
{ }
//close out anything that did not complete in 5 seconds
for (int loop = 0; loop < ListOfThreads.Count; loop++)
{
oDataIO = new DataIO();
sqlCmd = new SqlCommand();
sqlCmd.Connection = Conn;
if (!ListOfThreads[loop].Site.IsDone)
{
sql = "update FSLogOutgoing set ResponseTime = datediff(ms,SentDate,GetDate()), "
+ " ResponseState = " + 1
+ " where FSID = " + cs(ListOfThreads[loop].Site.FSID);
sqlCmd.CommandText = sql;
sqlCmd.CommandType = System.Data.CommandType.Text;
iResult = sqlCmd.ExecuteNonQuery();
Response.Write("<script>parent.siteResult(" + ListOfThreads[loop].Site.SiteID + ",1,0,'','','','');</script>");
ListOfThreads.Remove(ListOfThreads[loop]);
}
}
try
{
Response.Flush();
if (Conn.State == System.Data.ConnectionState.Open)
Conn.Close();
}
catch { }
break;
case "outgoingdetails":
string FSID = Request["fsid"].Trim();
string SiteId = string.Empty;
if (FSID != "")
{
dr = oDataIO.GetFsID(cs(FSID));
if (dr.Read())
{
SiteId = dr["SiteID"].ToString();
ResultDetailsURL = dr["ResultDetailsURL"].ToString().Replace("\n\t", "");
}
if (!dr.IsClosed)
dr.Close();
}
if ((FSID != "") && (SiteId != "") && (ResultDetailsURL != ""))
{
// Enter log record
sql = "insert into FSLogOutgoing(FSID,SiteID,Details,SentDate) "
+ " values (" + cs(FSID) + "," + cs(SiteId) + ",1,GetDate())";
sqlCmd.CommandText = sql;
sqlCmd.CommandType = System.Data.CommandType.Text;
iResult = sqlCmd.ExecuteNonQuery();
if (sqlCmd.Connection.State == System.Data.ConnectionState.Open)
sqlCmd.Connection.Close();
Response.Redirect(ResultDetailsURL);
}
else
Response.Redirect(ProfilesURL);
break;
}
Response.End();
}
protected void DrawUIOnLoad()
{
string DirectServiceURL = ConfigurationSettings.AppSettings["DirectServiceURL"];
string ProfilesURL = ConfigurationSettings.AppSettings["URLBASE"];;
string PopulationTypeText = ConfigurationSettings.AppSettings["DirectPopulationType"];
int QueryTimeout = 15;
try
{
QueryTimeout = Convert.ToInt16(ConfigurationSettings.AppSettings["DirectQueryTimeout"]);
}
catch { }
string sql = string.Empty;
string ResultDetailsURL = string.Empty;
string strResult = "";
XmlElement ResultXML = null;
SqlDataReader dr;
oDataIO = new DataIO();
SqlConnection Conn = new SqlConnection();
Conn = oDataIO.GetDBConnection("ProfilesDB");
sqlCmd = new SqlCommand();
sqlCmd.Connection = Conn;
if (Request["Request"] == null)
{
return;
}
string task = Request["Request"].ToLower();
switch (task)
{
case "getsites":
string ResultStr = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>" + "<site-list>";
dr = oDataIO.GetSitesOrderBySortOrder();
while (dr.Read())
{
Int64 SiteID = Convert.ToInt64(dr["SiteID"]);
string SiteName = dr["SiteName"].ToString();
string QueryURL = dr["QueryURL"].ToString();
if (SiteName == null)
{
SiteName = "";
}
if (QueryURL == null)
{
QueryURL = "";
}
ResultStr = ResultStr + "<site-description><site-id>" + SiteID + "</site-id><name>" + cx(SiteName) + "</name><aggregate-query>" + cx(QueryURL) + "</aggregate-query></site-description>";
}
if (!dr.IsClosed)
{
dr.Close();
}
if (Conn.State == System.Data.ConnectionState.Open)
{
Conn.Close();
}
ResultStr += "</site-list>";
Response.ContentType = "text/xml";
Response.AddHeader("Content-Type", "text/xml;charset=UTF-8");
//Response.ContentEncoding.CodePage = 65001;
Response.Charset = "UTF-8";
Response.Write(ResultStr);
break;
case "incomingcount":
string q = Request["SearchPhrase"].Trim();
// Enter log record
sql = "insert into FSLogIncoming(Details,ReceivedDate,RequestIP,QueryString) " +
" values (0,GetDate()," + cs(Request.ServerVariables["REMOTE_ADDR"]) + "," + cs(q) + ")";
sqlCmd.CommandText = sql;
sqlCmd.CommandType = System.Data.CommandType.Text;
// Execute query
string QueryXML = "<Profiles Operation=\"GetPersonList\" Version=\"2\" xmlns=\"http://connects.profiles.schema/profiles/query\"><QueryDefinition><Name><LastName></LastName><FirstName></FirstName></Name><FacultyTypeList></FacultyTypeList><FacultyRankList></FacultyRankList><Affiliations><AffiliationList><Affiliation><InstitutionName></InstitutionName><DepartmentName></DepartmentName></Affiliation></AffiliationList></Affiliations><PersonFilterList></PersonFilterList><Keywords><KeywordString>" + cx(q) + "</KeywordString></Keywords></QueryDefinition><OutputOptions StartRecord=\"1\" MaxRecords=\"1\"></OutputOptions></Profiles>";
dr = oDataIO.GetPersonList_xml(cs(QueryXML));
if (dr.Read())
{
strResult = dr[0].ToString();
}
if (!dr.IsClosed)
{
dr.Close();
}
if (sqlCmd.Connection.State == System.Data.ConnectionState.Open)
{
sqlCmd.Connection.Close();
}
// Parse results
strResult = strResult.Replace(" xmlns=\"http://connects.profiles.schema/profiles/personlist\"", "");
XmlDocument objDoc = new XmlDocument();
objDoc.LoadXml(strResult);
ResultXML = objDoc.DocumentElement;
string QueryID = ResultXML.GetAttribute("QueryID");
string ResultCount = ResultXML.GetAttribute("TotalCount");
// Form result message
ResultStr = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>";
ResultStr += "<aggregation-result>";
ResultStr += "<count>" + ResultCount + "</count>";
ResultStr += "<population-type>" + PopulationTypeText + "</population-type>";
ResultStr += "<preview-URL>" + DirectServiceURL + "?Request=IncomingPreview&SearchPhrase=" + cx(q) + "</preview-URL>";
ResultStr += "<search-results-URL>" + DirectServiceURL + "?Request=IncomingDetails&SearchPhrase=" + cx(q) + "</search-results-URL>";
ResultStr += "</aggregation-result>";
// Send result
Response.ContentType = "text/xml";
Response.AddHeader("Content-Type", "text/xml;charset=UTF-8");
//Response.ContentEncoding.CodePage = 65001;
Response.Charset = "UTF-8";
Response.Write(ResultStr);
break;
case "incomingdetails":
q = Request["SearchPhrase"].Trim();
// Enter log record
sql = "insert into FSLogIncoming(Details,ReceivedDate,RequestIP,QueryString) ";
sql += " values (1,GetDate()," + cs(Request.ServerVariables["REMOTE_ADDR"]) + "," +
cs(q) + ")";
sqlCmd.CommandType = System.Data.CommandType.Text;
sqlCmd.CommandText = sql;
int iResult = sqlCmd.ExecuteNonQuery();
// Execute queryA
QueryXML = "<Profiles Operation=\"GetPersonList\" Version=\"2\" xmlns=\"http://connects.profiles.schema/profiles/query\"><QueryDefinition><Name><LastName></LastName><FirstName></FirstName></Name><FacultyTypeList></FacultyTypeList><FacultyRankList></FacultyRankList><Affiliations><AffiliationList><Affiliation><InstitutionName></InstitutionName><DepartmentName></DepartmentName></Affiliation></AffiliationList></Affiliations><PersonFilterList></PersonFilterList><Keywords><KeywordString>" + cx(q) + "</KeywordString></Keywords></QueryDefinition><OutputOptions StartRecord=\"1\" MaxRecords=\"1\"></OutputOptions></Profiles>";
dr = oDataIO.GetPersonList_xml(cs(QueryXML));
if (dr.Read())
{
strResult = dr[0].ToString();
}
if (!dr.IsClosed)
{
dr.Close();
}
if (sqlCmd.Connection.State == System.Data.ConnectionState.Open)
{
sqlCmd.Connection.Close();
}
// Parse results
strResult = strResult.Replace(" xmlns=\"http://connects.profiles.schema/profiles/personlist\"", "");
objDoc = new XmlDocument();
objDoc.LoadXml(strResult);
ResultXML = objDoc.DocumentElement;
QueryID = ResultXML.GetAttribute("QueryID");
ResultCount = ResultXML.GetAttribute("TotalCount");
if (ProfilesURL.Substring(ProfilesURL.Length - 1) != "/")
{
ProfilesURL += "/";
}
Response.Redirect(ProfilesURL + "Search.aspx?From=SP&Keyword=" + q);
break;
case "incomingpreview":
q = Request["SearchPhrase"].Trim();
Response.Write(DisplayPageHeader());
// Execute query
QueryXML = "<Profiles Operation=\"GetPersonList\" Version=\"2\" xmlns=\"http://connects.profiles.schema/profiles/query\"><QueryDefinition><Name><LastName></LastName><FirstName></FirstName></Name><FacultyTypeList></FacultyTypeList><FacultyRankList></FacultyRankList><Affiliations><AffiliationList><Affiliation><InstitutionName></InstitutionName><DepartmentName></DepartmentName></Affiliation></AffiliationList></Affiliations><PersonFilterList></PersonFilterList><Keywords><KeywordString>" + cx(q) + "</KeywordString></Keywords></QueryDefinition><OutputOptions StartRecord=\"1\" MaxRecords=\"1\"></OutputOptions></Profiles>";
dr = oDataIO.GetPersonList_xml(cs(QueryXML));
if (dr.Read())
{
strResult = dr[0].ToString();
}
if (!dr.IsClosed)
{
dr.Close();
}
// Parse results
strResult = strResult.Replace(" xmlns=\"http://connects.profiles.schema/profiles/personlist\"", "");
XmlDocument objDocincomepreview = new XmlDocument();
objDocincomepreview.LoadXml(strResult);
ResultXML = objDocincomepreview.DocumentElement;
QueryID = ResultXML.GetAttribute("QueryID");
ResultCount = ResultXML.GetAttribute("TotalCount");
Response.Write("<div style=\"width:260px;text-align:center;\"><b>");
if (Convert.ToInt64(ResultCount) == 0)
{
Response.Write("no people were found");
}
if (Convert.ToInt64(ResultCount) == 1)
{
Response.Write("one person was found");
}
if (Convert.ToInt64(ResultCount) > 1)
{
Response.Write(ResultCount + " people were found");
}
Response.Write("</b></div>");
if (Convert.ToInt64(ResultCount) > 0)
{
Response.Write("<div style=\"border-top:1px solid #999;width:260px;height:1px;overflow:hidden;margin:3px 0 3px 0;\"></div>");
Response.Write("<div style=\"width:290px;\">");
dr = oDataIO.GetFacultyRank(QueryID);
Int64 wz = 0;
while (dr.Read())
{
if (Convert.ToInt64(dr["n"]) > wz)
{
wz = Convert.ToInt64(dr["n"]);
}
}
if (!dr.IsClosed)
{
dr.Close();
}
dr = oDataIO.GetFacultyRank(QueryID);
while (dr.Read())
{
Int64 w = 1 + Convert.ToInt64(100 * Convert.ToInt64(dr["n"]) / (wz * 1.000000));
Response.Write("<table cellpadding=\"0\" cellspacing=\"0\">");
Response.Write("<tr>");
Response.Write("<td style=\"width:120px; text-align:right; border-right:1px solid #000; padding-right:3px;\">" + dr["facultyrank"] + "</td>");
Response.Write("<td style=\"width:" + w.ToString() + "px; background-color:#900; \"></td>");
Response.Write("<td style=\"\">" + dr["n"] + "</td>");
Response.Write("<tr>");
Response.Write("</tr>");
Response.Write("</table>");
}
if (!dr.IsClosed)
{
dr.Close();
}
}
Response.Write("<div style=\"border-top:1px solid #999;width:260px;height:1px;overflow:hidden;margin:3px 0 3px 0;\"></div>");
Response.Write("<div style=\"width:260px;text-align:center;font-size:10px;\">Powered by Harvard Catalyst Profiles</div>");
Response.Write("</div>");
Response.Write("</body>");
Response.Write("</html>");
break;
/*
* The "outgoingcount" case test will call all public systems that are involved in DIRECT
* will receive one of our requests for what we have on
*/
case "outgoingcount":
if (Request["blank"] == "y")
{
Response.Write("<html><body></body></html>");
Response.End();
}
string SearchPhrase = Request["SearchPhrase"];
Response.Write("<script>parent.dsLoading=1;</script>" + Environment.NewLine);
dr = oDataIO.GetSitesOrderBySiteID();
SiteIDs = new int[1000];
URLs = new string[1000];
FSIDs = new string[1000];
Site site;
ListOfSites = new List <Site>();
Int64 sites = 0;
List <AsyncProcessing> ListOfThreads = new List <AsyncProcessing>();
AsyncProcessing async;
while (dr.Read())
{
SiteIDs[sites] = Convert.ToInt32(dr["SiteID"].ToString());
URLs[sites] = dr["QueryURL"] + SearchPhrase;
FSIDs[sites] = dr["FSID"].ToString();
site = new Site(URLs[sites], SiteIDs[sites], FSIDs[sites], SearchPhrase, HttpContext.Current);
ListOfSites.Add(site);
async = new AsyncProcessing();
async.BeginProcessRequest(site);
ListOfThreads.Add(async);
sites++;
}
if (!dr.IsClosed)
{
dr.Close();
}
//eat up the CPU for x number of seconds :) so all the requests can come back. This is set in the web.config file
DateTime end = DateTime.Now.AddSeconds(QueryTimeout);
while (DateTime.Now < end)
{
}
//close out anything that did not complete in 5 seconds
for (int loop = 0; loop < ListOfThreads.Count; loop++)
{
oDataIO = new DataIO();
sqlCmd = new SqlCommand();
sqlCmd.Connection = Conn;
if (!ListOfThreads[loop].Site.IsDone)
{
sql = "update FSLogOutgoing set ResponseTime = datediff(ms,SentDate,GetDate()), "
+ " ResponseState = " + 1
+ " where FSID = " + cs(ListOfThreads[loop].Site.FSID);
sqlCmd.CommandText = sql;
sqlCmd.CommandType = System.Data.CommandType.Text;
iResult = sqlCmd.ExecuteNonQuery();
Response.Write("<script>parent.siteResult(" + ListOfThreads[loop].Site.SiteID + ",1,0,'','','','');</script>");
ListOfThreads.Remove(ListOfThreads[loop]);
}
}
try
{
Response.Flush();
if (Conn.State == System.Data.ConnectionState.Open)
{
Conn.Close();
}
}
catch { }
break;
case "outgoingdetails":
string FSID = Request["fsid"].Trim();
string SiteId = string.Empty;
if (FSID != "")
{
dr = oDataIO.GetFsID(cs(FSID));
if (dr.Read())
{
SiteId = dr["SiteID"].ToString();
ResultDetailsURL = dr["ResultDetailsURL"].ToString().Replace("\n\t", "");
}
if (!dr.IsClosed)
{
dr.Close();
}
}
if ((FSID != "") && (SiteId != "") && (ResultDetailsURL != ""))
{
// Enter log record
sql = "insert into FSLogOutgoing(FSID,SiteID,Details,SentDate) "
+ " values (" + cs(FSID) + "," + cs(SiteId) + ",1,GetDate())";
sqlCmd.CommandText = sql;
sqlCmd.CommandType = System.Data.CommandType.Text;
iResult = sqlCmd.ExecuteNonQuery();
if (sqlCmd.Connection.State == System.Data.ConnectionState.Open)
{
sqlCmd.Connection.Close();
}
Response.Redirect(ResultDetailsURL);
}
else
{
Response.Redirect(ProfilesURL);
}
break;
}
Response.End();
}
