public string OfficeDistributionProjectionQuery() { lmDatasets.docDB.DocContentRow doccontentrow = myA.GetFile().GetDocMng().GetDocContent().Load(myA.GetSetting(atriumBE.AppIntSetting.PLOfficeForecastDocID)); if (doccontentrow != null && doccontentrow.ContentsAsText != null) { return(doccontentrow.ContentsAsText); } else { return("[Office Distribution Forecast Document could not be found]"); } }
public string HitHilite(int docRefId, string searchTerm, bool summaryResults, string VersionNumber) { System.Web.HttpContext ctx = System.Web.HttpContext.Current; string virt = ctx.Request.ApplicationPath; if (virt == "/") { virt = ""; } string ftFld = ctx.Server.MapPath(virt + "/fulltext/"); string website = ctx.Request.Url.Host; string scheme = ctx.Request.Url.Scheme; if (System.Configuration.ConfigurationManager.AppSettings["HHUseIP"].ToString().ToLower() == "true") { website = ctx.Request.ServerVariables["LOCAL_ADDR"]; } string query = "", tempName = ""; try { //searchTerm = searchTerm.Replace("(", " "); //searchTerm = searchTerm.Replace(")", " "); //if (!summaryResults) // query =scheme+ "://"+website + virt + "/fulltext/qfullhit.htw?ciwebhitsfile=" + virt + "/fulltext/{0}&cirestriction={1}&cihilitetype=Full&CiBold=y&cidialect=1"; //else // query = scheme + "://" + website + virt + "/fulltext/qfullhit.htw?ciwebhitsfile" + virt + "/fulltext/{0}&cirestriction={1}&cihilitetype=Summary&CiBold=y&cidialect=1"; //JLL For CHRC Evaluation - hook into localhost if (!summaryResults) { query = scheme + "://localhost/" + virt + "/fulltext/qfullhit.htw?ciwebhitsfile=" + virt + "/fulltext/{0}&cirestriction={1}&cihilitetype=Full&CiBold=y&cidialect=1"; } else { query = scheme + "://localhost/" + virt + "/fulltext/qfullhit.htw?ciwebhitsfile" + virt + "/fulltext/{0}&cirestriction={1}&cihilitetype=Summary&CiBold=y&cidialect=1"; } //get doc lmDatasets.docDB.DocContentDataTable ddt = GetDocContent().LoadDT(docRefId, VersionNumber); lmDatasets.docDB.DocContentRow dcr = ddt.FindByDocId(docRefId); //write doc to disk in fulltext folder tempName = System.IO.Path.GetRandomFileName() + dcr.Ext; System.IO.File.WriteAllBytes(ftFld + tempName, dcr.Contents); //searchTerm = Uri.EscapeDataString(searchTerm); //if (!summaryResults) //{ // // searchTerm = Uri.EscapeDataString(searchTerm); //} //else // searchTerm = Uri.EscapeUriString(searchTerm); //qfullhit.htw to get html System.Net.WebClient wc = new System.Net.WebClient(); //wc.Encoding = System.Text.Encoding.UTF8; //wc.QueryString.Add("ciwebhitsfile",String.Format("/lmras/fulltext/{0}",tempName)); //byte[] t = System.Text.Encoding.ASCII.GetBytes(searchTerm); //wc.QueryString.Add("cirestriction", System.Text.Encoding.ASCII.GetString(t)); //if (!summaryResults) // wc.QueryString.Add("cihilitetype", "Full"); //else // wc.QueryString.Add("cihilitetype", "Summary"); //wc.QueryString.Add("CiBold", "y"); //wc.QueryString.Add("cidialect", "1"); searchTerm = System.Web.HttpUtility.UrlEncodeUnicode(searchTerm); System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(String.Format(query, tempName, searchTerm)); System.IO.File.AppendAllText(@"C:/atrium/log.txt", sb.ToString()); sb.Clear(); System.Uri address = new Uri(String.Format(query, tempName, searchTerm)); string html = wc.DownloadString(address); //delete temp doc from ft folder System.IO.File.Delete(ftFld + tempName); //return html return(html); } catch (Exception x) { LogEvent("Error", Environment.UserName, User, User, x.GetType().ToString(), x.Source, x.Message, String.Format(query, tempName, searchTerm)); throw x; } }