public static RESTSearchResultsSerialized ProcessResults(RESTSearchResults res, SearchInputs inputs)
{
RESTSearchResultsSerialized SerializedResults = new RESTSearchResultsSerialized();
SerializedResults.Inputs = inputs;
if (res != null)
{
SerializedResults.ExecutionTime = res.ElapsedTime;
if (res.PrimaryQueryResult != null && res.PrimaryQueryResult.RelevantResults != null)
{
SerializedResults.TotalRows = res.PrimaryQueryResult.RelevantResults.TotalRows;
SerializedResults.ResultRows = res.PrimaryQueryResult.RelevantResults.RowCount;
SerializedResults.ResultTitle = res.PrimaryQueryResult.RelevantResults.ResultTitle;
SerializedResults.SearchResults = res.PrimaryQueryResult.RelevantResults.Table;
SerializedResults.ResultTitleUrl = res.PrimaryQueryResult.RelevantResults.ResultTitleUrl;
}
else
{
SerializedResults.TotalRows = 0;
SerializedResults.ResultRows = 0;
}
SerializedResults.SpellingSuggestions = res.SpellingSuggestion;
// set SourceId from execution results
Guid sid = Guid.Empty;
SearchProperty SourceId = res.Properties.Where(p => p.Key.Equals("sourceid", StringComparison.InvariantCultureIgnoreCase)).First();
if (SourceId != null && Guid.TryParse(SourceId.Value, out sid))
{
SerializedResults.Inputs.SourceId = sid;
}
}
return SerializedResults;
}
public void ExecuteSearchRead(Property[] inputs, RequiredProperties required, Property[] returns, MethodType methodType, ServiceObject serviceObject)
{
serviceObject.Properties.InitResultTable();
try
{
RESTSearchResultsSerialized SerializedResults = new RESTSearchResultsSerialized();
if (serviceObject.Methods[0].Name.Equals("spsearchread") || serviceObject.Methods[0].Name.Equals("spsearchdocumentsread"))
{
SerializedResults = Utilities.BrokerUtils.ExecuteSharePointSearch(inputs, required, Configuration, serviceBroker);
}
if (serviceObject.Methods[0].Name.Equals("spsearchrawread"))
{
SerializedResults = Utilities.BrokerUtils.ExecuteSharePointSearchRaw(inputs, required, Configuration, serviceBroker);
}
if (serviceObject.Methods[0].Name.Equals("spsearchusersread"))
{
SerializedResults = Utilities.BrokerUtils.ExecuteSharePointUserSearch(inputs, required, Configuration, serviceBroker);
}
if (SerializedResults != null)
{
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.Search))
{
returns.Where(p => p.Name.Equals("search", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.Search;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.SiteUrl))
{
returns.Where(p => p.Name.Equals("searchsiteurl", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.SiteUrl;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.FileExtensionsString))
{
returns.Where(p => p.Name.Equals("fileextensionsfilter", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.FileExtensionsString;
}
if (SerializedResults.Inputs.SourceId != null && SerializedResults.Inputs.SourceId != Guid.Empty)
{
returns.Where(p => p.Name.Equals("sourceid", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.SourceId;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.SortString))
{
returns.Where(p => p.Name.Equals("sort", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.SortString;
}
if (SerializedResults.Inputs.StartRow.HasValue && SerializedResults.Inputs.StartRow.Value > -1)
{
returns.Where(p => p.Name.Equals("startrow", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.StartRow.Value;
}
if (SerializedResults.Inputs.RowLimit.HasValue && SerializedResults.Inputs.RowLimit.Value > 0)
{
returns.Where(p => p.Name.Equals("rowlimit", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.RowLimit.Value;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.Properties))
{
returns.Where(p => p.Name.Equals("properties", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.Properties;
}
if (SerializedResults.Inputs.EnableStemming.HasValue)
{
returns.Where(p => p.Name.Equals("enablestemming", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.EnableStemming.Value;
}
if (SerializedResults.Inputs.TrimDuplicates.HasValue)
{
returns.Where(p => p.Name.Equals("trimduplicates", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.TrimDuplicates.Value;
}
if (SerializedResults.Inputs.EnableQueryRules.HasValue)
{
returns.Where(p => p.Name.Equals("enablequeryrules", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.EnableQueryRules.Value;
}
if (SerializedResults.Inputs.ProcessBestBets.HasValue)
{
returns.Where(p => p.Name.Equals("processbestbets", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.ProcessBestBets.Value;
}
if (SerializedResults.Inputs.ProcessPersonal.HasValue)
{
returns.Where(p => p.Name.Equals("processpersonal", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.ProcessPersonal.Value;
}
if (SerializedResults.Inputs.EnableNicknames.HasValue)
{
returns.Where(p => p.Name.Equals("enablenicknames", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.EnableNicknames.Value;
}
if (SerializedResults.Inputs.EnablePhonetic.HasValue)
{
returns.Where(p => p.Name.Equals("enablephonetic", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.EnablePhonetic.Value;
}
if (SerializedResults.ExecutionTime.HasValue)
{
returns.Where(p => p.Name.Equals("executiontime", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.ExecutionTime.Value;
}
if (SerializedResults.ResultRows.HasValue)
{
returns.Where(p => p.Name.Equals("resultrows", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.ResultRows.Value;
}
if (SerializedResults.TotalRows.HasValue)
{
returns.Where(p => p.Name.Equals("totalrows", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.TotalRows.Value;
}
string resultsJson = JsonConvert.SerializeObject(SerializedResults);
returns.Where(p => p.Name.Equals("serializedresults", StringComparison.OrdinalIgnoreCase)).First().Value = resultsJson;
returns.Where(p => p.Name.Equals("responsestatus", StringComparison.OrdinalIgnoreCase)).First().Value = ResponseStatus.Success;
}
else
{
throw new Exception("No results returned.");
}
}
catch (Exception ex)
{
returns.Where(p => p.Name.Equals("responsestatus", StringComparison.OrdinalIgnoreCase)).First().Value = ResponseStatus.Error;
returns.Where(p => p.Name.Equals("responsestatusdescription", StringComparison.OrdinalIgnoreCase)).First().Value = ex.Message;
}
serviceObject.Properties.BindPropertiesToResultTable();
}
//for debugging
public static string GetColumns(RESTSearchResultsSerialized results)
{
string cols = string.Empty;
int i = 0;
foreach (ResultCell cell in results.SearchResults.Rows[0].Cells.OrderBy(p => p.Key))
{
cols += cell.Key + " (" + cell.ValueType + ")";
if (i <= results.SearchResults.Rows.Count - 2)
{
cols += ",";
}
i++;
}
return cols;
}
public void ExecuteSearchRead(Property[] inputs, RequiredProperties required, Property[] returns, MethodType methodType, ServiceObject serviceObject)
{
serviceObject.Properties.InitResultTable();
try
{
//SearchInputs SearchInputs = GetInputs(inputs);
RESTSearchResultsSerialized SerializedResults = new RESTSearchResultsSerialized();
SerializedResults = ExecuteSharePointSearch(inputs, required, returns, methodType, serviceObject);
if (SerializedResults != null)
{
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.Search))
{
returns.Where(p => p.Name.Equals("search", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.Search;
}
if (SerializedResults.Inputs.StartRow.HasValue && SerializedResults.Inputs.StartRow.Value > -1)
{
returns.Where(p => p.Name.Equals("startrow", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.StartRow.Value;
}
if (SerializedResults.Inputs.RowLimit.HasValue && SerializedResults.Inputs.RowLimit.Value > 0)
{
returns.Where(p => p.Name.Equals("rowlimit", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.RowLimit.Value;
}
if (SerializedResults.Inputs.SourceId != null && SerializedResults.Inputs.SourceId != Guid.Empty)
{
returns.Where(p => p.Name.Equals("sourceid", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.SourceId;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.SortString))
{
returns.Where(p => p.Name.Equals("sort", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.SortString;
}
if (SerializedResults.Inputs.EnableNicknames.HasValue && SerializedResults.Inputs.EnableNicknames.Value)
{
returns.Where(p => p.Name.Equals("enablenicknames", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.EnableNicknames.Value;
}
if (SerializedResults.Inputs.EnablePhonetic.HasValue && SerializedResults.Inputs.EnablePhonetic.Value)
{
returns.Where(p => p.Name.Equals("enablephonetic", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.EnablePhonetic.Value;
}
if (SerializedResults.ExecutionTime.HasValue)
{
returns.Where(p => p.Name.Equals("executiontime", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.ExecutionTime.Value;
}
if (SerializedResults.ResultRows.HasValue)
{
returns.Where(p => p.Name.Equals("resultrows", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.ResultRows.Value;
}
if (SerializedResults.TotalRows.HasValue)
{
returns.Where(p => p.Name.Equals("totalrows", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.TotalRows.Value;
}
returns.Where(p => p.Name.Equals("resulttitle", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.ResultTitle;
returns.Where(p => p.Name.Equals("resulttitleurl", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.ResultTitleUrl;
returns.Where(p => p.Name.Equals("tabletype", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.TableType;
returns.Where(p => p.Name.Equals("spellingsuggestions", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.SpellingSuggestions;
//string resultsJson = JsonConvert.SerializeObject(results.Value[0].ResultRows);
string resultsJson = JsonConvert.SerializeObject(SerializedResults);
returns.Where(p => p.Name.Equals("serializedresults", StringComparison.OrdinalIgnoreCase)).First().Value = resultsJson;
returns.Where(p => p.Name.Equals("responsestatus", StringComparison.OrdinalIgnoreCase)).First().Value = ResponseStatus.Success;
}
else
{
throw new Exception("No results returned.");
}
}
catch (Exception ex)
{
returns.Where(p => p.Name.Equals("responsestatus", StringComparison.OrdinalIgnoreCase)).First().Value = ResponseStatus.Error;
returns.Where(p => p.Name.Equals("responsestatusdescription", StringComparison.OrdinalIgnoreCase)).First().Value = ex.Message;
}
serviceObject.Properties.BindPropertiesToResultTable();
}
public RESTSearchResultsSerialized ExecuteSharePointSearch(Property[] inputs, RequiredProperties required, Property[] returns, MethodType methodType, ServiceObject serviceObject)
{
serviceObject.Properties.InitResultTable();
ClientResult<ResultTableCollection> results = null;
SearchInputs SearchInputs = GetInputs(inputs);
RESTSearchResultsSerialized SerializedResults = new RESTSearchResultsSerialized();
SerializedResults.Inputs = SearchInputs;
//KeywordQuery keywordQuery = new KeywordQuery(cc);
//keywordQuery.QueryText = SearchInputs.Search;
//SearchExecutor searchExecutor = new SearchExecutor(cc);
if (SearchInputs.StartRow.HasValue && SearchInputs.StartRow.Value > -1)
{
//keywordQuery.StartRow = SearchInputs.StartRow.Value;
}
//keywordQuery.RowsPerPage = int.Parse(txtRowsPerPage.Text);
if (SearchInputs.RowLimit.HasValue && SearchInputs.RowLimit.Value > -1)
{
//keywordQuery.RowLimit = SearchInputs.RowLimit.Value;
}
//keywordQuery.Culture = Configuration.LocaleId;
if (SearchInputs.SourceId != null && SearchInputs.SourceId != Guid.Empty)
{
//keywordQuery.SourceId = SearchInputs.SourceId;
}
if (SearchInputs.Sort.Count > 0)
{
}
if (SearchInputs.EnableNicknames.HasValue && SearchInputs.EnableNicknames.Value)
{
//keywordQuery.EnableNicknames = SearchInputs.EnableNicknames.Value;
}
if (SearchInputs.EnablePhonetic.HasValue && SearchInputs.EnablePhonetic.Value)
{
//keywordQuery.EnablePhonetic = SearchInputs.EnablePhonetic.Value;
}
// updated for inputs
RESTSearchResults res = ExecuteRESTRequest(BuildSearchText(SearchInputs));
if (res != null)
{
int executiontime = res.ElapsedTime;
int totalresults = res.PrimaryQueryResult.RelevantResults.TotalRows;
int resultrows = res.PrimaryQueryResult.RelevantResults.RowCount;
SerializedResults.ResultTitle = res.PrimaryQueryResult.RelevantResults.ResultTitle;
SerializedResults.ResultTitleUrl = res.PrimaryQueryResult.RelevantResults.ResultTitleUrl;
SerializedResults.SpellingSuggestions = res.SpellingSuggestion;
SerializedResults.SearchResults = res.PrimaryQueryResult.RelevantResults.Table;
// set SourceId from execution results
Guid sid = Guid.Empty;
SearchProperty SourceId = res.Properties.Where(p => p.Key.Equals("sourceid", StringComparison.InvariantCultureIgnoreCase)).First();
if (SourceId != null && Guid.TryParse(SourceId.Value, out sid))
{
SerializedResults.Inputs.SourceId = sid;
}
}
return SerializedResults;
}
public void ExecuteSearch(Property[] inputs, RequiredProperties required, Property[] returns, MethodType methodType, ServiceObject serviceObject)
{
serviceObject.Properties.InitResultTable();
System.Data.DataRow dr;
try
{
RESTSearchResultsSerialized SerializedResults = null;
// if deserializesearchresults
if (serviceObject.Methods[0].Name.StartsWith("deserialize"))
{
Property SerializedProp = inputs.Where(p => p.Name.Equals("serializedresults", StringComparison.OrdinalIgnoreCase)).First();
string json = string.Empty;
json = SerializedProp.Value.ToString();
SerializedResults = JsonConvert.DeserializeObject <RESTSearchResultsSerialized>(json.Trim());
if (string.IsNullOrWhiteSpace(json) || SerializedResults == null)
{
throw new Exception("Failed to deserialize search results");
}
}
if (serviceObject.Methods[0].Name.Equals("spsearch") || serviceObject.Methods[0].Name.Equals("spsearchdocuments"))
{
// if Search
SerializedResults = Utilities.BrokerUtils.ExecuteSharePointSearch(inputs, required, Configuration, serviceBroker);
}
if (serviceObject.Methods[0].Name.Equals("spsearchraw"))
{
// if Search Raw Read
SerializedResults = Utilities.BrokerUtils.ExecuteSharePointSearchRaw(inputs, required, Configuration, serviceBroker);
}
if (serviceObject.Methods[0].Name.Equals("spsearchusers"))
{
// if Search
SerializedResults = Utilities.BrokerUtils.ExecuteSharePointUserSearch(inputs, required, Configuration, serviceBroker);
}
if (SerializedResults != null)
{
if (SerializedResults.SearchResults == null || SerializedResults.SearchResults.Rows == null)
{
SerializedResults.SearchResults = new ResultTable();
//SerializedResults.SearchResults.Rows.Add(new ResultRow());
}
foreach (ResultRow result in SerializedResults.SearchResults.Rows)
{
dr = serviceBroker.ServicePackage.ResultTable.NewRow();
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.Search))
{
dr["search"] = SerializedResults.Inputs.Search;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.SiteUrl))
{
dr["searchsiteurl"] = SerializedResults.Inputs.Search;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.FileExtensionsString))
{
dr["fileextensionsfilter"] = SerializedResults.Inputs.FileExtensionsString;
}
if (SerializedResults.Inputs.SourceId != null && SerializedResults.Inputs.SourceId != Guid.Empty)
{
dr["sourceid"] = SerializedResults.Inputs.SourceId;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.SortString))
{
dr["sort"] = SerializedResults.Inputs.SortString;
}
if (SerializedResults.Inputs.StartRow.HasValue && SerializedResults.Inputs.StartRow.Value > -1)
{
dr["startrow"] = SerializedResults.Inputs.StartRow.Value;
}
if (SerializedResults.Inputs.RowLimit.HasValue && SerializedResults.Inputs.RowLimit.Value > 0)
{
dr["rowlimit"] = SerializedResults.Inputs.RowLimit.Value;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.Properties))
{
dr["properties"] = SerializedResults.Inputs.Properties;
}
if (SerializedResults.Inputs.EnableStemming.HasValue && SerializedResults.Inputs.EnableStemming.Value)
{
dr["enablestemming"] = SerializedResults.Inputs.EnableStemming.Value;
}
if (SerializedResults.Inputs.TrimDuplicates.HasValue && SerializedResults.Inputs.TrimDuplicates.Value)
{
dr["trimduplicates"] = SerializedResults.Inputs.TrimDuplicates.Value;
}
if (SerializedResults.Inputs.EnableQueryRules.HasValue && SerializedResults.Inputs.EnableQueryRules.Value)
{
dr["enablequeryrules"] = SerializedResults.Inputs.EnableQueryRules.Value;
}
if (SerializedResults.Inputs.ProcessBestBets.HasValue && SerializedResults.Inputs.ProcessBestBets.Value)
{
dr["processbestbets"] = SerializedResults.Inputs.ProcessBestBets.Value;
}
if (SerializedResults.Inputs.ProcessPersonal.HasValue && SerializedResults.Inputs.ProcessPersonal.Value)
{
dr["processpersonal"] = SerializedResults.Inputs.ProcessPersonal.Value;
}
if (SerializedResults.Inputs.EnableNicknames.HasValue && SerializedResults.Inputs.EnableNicknames.Value)
{
dr["enablenicknames"] = SerializedResults.Inputs.EnableNicknames.Value;
}
if (SerializedResults.Inputs.EnablePhonetic.HasValue && SerializedResults.Inputs.EnablePhonetic.Value)
{
dr["enablephonetic"] = SerializedResults.Inputs.EnablePhonetic.Value;
}
if (SerializedResults.ExecutionTime.HasValue)
{
dr["executiontime"] = SerializedResults.ExecutionTime.Value;
}
if (SerializedResults.ResultRows.HasValue)
{
dr["resultrows"] = SerializedResults.ResultRows.Value;
}
if (SerializedResults.TotalRows.HasValue)
{
dr["totalrows"] = SerializedResults.TotalRows.Value;
}
List <string> missingprops = new List <string>();
foreach (ResultCell cell in result.Cells)
{
if (dr.Table.Columns.Contains(cell.Key.ToLower()))
{
if (cell.Value != null)
{
dr[cell.Key.ToLower()] = cell.Value;
}
}
else
{
missingprops.Add(cell.Key);
}
}
dr["responsestatus"] = ResponseStatus.Success;
serviceBroker.ServicePackage.ResultTable.Rows.Add(dr);
}
}
else
{
throw new Exception("No results returned.");
}
}
catch (Exception ex)
{
dr = serviceBroker.ServicePackage.ResultTable.NewRow();
dr["responsestatus"] = ResponseStatus.Error;
dr["responsestatusdescription"] = ex.Message;
serviceBroker.ServicePackage.ResultTable.Rows.Add(dr);
}
//serviceObject.Properties.BindPropertiesToResultTable();
}
public void ExecuteSearchRead(Property[] inputs, RequiredProperties required, Property[] returns, MethodType methodType, ServiceObject serviceObject)
{
serviceObject.Properties.InitResultTable();
try
{
RESTSearchResultsSerialized SerializedResults = new RESTSearchResultsSerialized();
if (serviceObject.Methods[0].Name.Equals("spsearchread") || serviceObject.Methods[0].Name.Equals("spsearchdocumentsread"))
{
SerializedResults = Utilities.BrokerUtils.ExecuteSharePointSearch(inputs, required, Configuration, serviceBroker);
}
if (serviceObject.Methods[0].Name.Equals("spsearchrawread"))
{
SerializedResults = Utilities.BrokerUtils.ExecuteSharePointSearchRaw(inputs, required, Configuration, serviceBroker);
}
if (serviceObject.Methods[0].Name.Equals("spsearchusersread"))
{
SerializedResults = Utilities.BrokerUtils.ExecuteSharePointUserSearch(inputs, required, Configuration, serviceBroker);
}
if (SerializedResults != null)
{
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.Search))
{
returns.Where(p => p.Name.Equals("search", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.Search;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.SiteUrl))
{
returns.Where(p => p.Name.Equals("searchsiteurl", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.SiteUrl;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.FileExtensionsString))
{
returns.Where(p => p.Name.Equals("fileextensionsfilter", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.FileExtensionsString;
}
if (SerializedResults.Inputs.SourceId != null && SerializedResults.Inputs.SourceId != Guid.Empty)
{
returns.Where(p => p.Name.Equals("sourceid", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.SourceId;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.SortString))
{
returns.Where(p => p.Name.Equals("sort", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.SortString;
}
if (SerializedResults.Inputs.StartRow.HasValue && SerializedResults.Inputs.StartRow.Value > -1)
{
returns.Where(p => p.Name.Equals("startrow", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.StartRow.Value;
}
if (SerializedResults.Inputs.RowLimit.HasValue && SerializedResults.Inputs.RowLimit.Value > 0)
{
returns.Where(p => p.Name.Equals("rowlimit", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.RowLimit.Value;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.Properties))
{
returns.Where(p => p.Name.Equals("properties", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.Properties;
}
if (SerializedResults.Inputs.EnableStemming.HasValue)
{
returns.Where(p => p.Name.Equals("enablestemming", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.EnableStemming.Value;
}
if (SerializedResults.Inputs.TrimDuplicates.HasValue)
{
returns.Where(p => p.Name.Equals("trimduplicates", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.TrimDuplicates.Value;
}
if (SerializedResults.Inputs.EnableQueryRules.HasValue)
{
returns.Where(p => p.Name.Equals("enablequeryrules", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.EnableQueryRules.Value;
}
if (SerializedResults.Inputs.ProcessBestBets.HasValue)
{
returns.Where(p => p.Name.Equals("processbestbets", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.ProcessBestBets.Value;
}
if (SerializedResults.Inputs.ProcessPersonal.HasValue)
{
returns.Where(p => p.Name.Equals("processpersonal", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.ProcessPersonal.Value;
}
if (SerializedResults.Inputs.EnableNicknames.HasValue)
{
returns.Where(p => p.Name.Equals("enablenicknames", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.EnableNicknames.Value;
}
if (SerializedResults.Inputs.EnablePhonetic.HasValue)
{
returns.Where(p => p.Name.Equals("enablephonetic", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.EnablePhonetic.Value;
}
if (SerializedResults.ExecutionTime.HasValue)
{
returns.Where(p => p.Name.Equals("executiontime", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.ExecutionTime.Value;
}
if (SerializedResults.ResultRows.HasValue)
{
returns.Where(p => p.Name.Equals("resultrows", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.ResultRows.Value;
}
if (SerializedResults.TotalRows.HasValue)
{
returns.Where(p => p.Name.Equals("totalrows", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.TotalRows.Value;
}
string resultsJson = JsonConvert.SerializeObject(SerializedResults);
returns.Where(p => p.Name.Equals("serializedresults", StringComparison.OrdinalIgnoreCase)).First().Value = resultsJson;
returns.Where(p => p.Name.Equals("responsestatus", StringComparison.OrdinalIgnoreCase)).First().Value = ResponseStatus.Success;
}
else
{
throw new Exception("No results returned.");
}
}
catch (Exception ex)
{
returns.Where(p => p.Name.Equals("responsestatus", StringComparison.OrdinalIgnoreCase)).First().Value = ResponseStatus.Error;
returns.Where(p => p.Name.Equals("responsestatusdescription", StringComparison.OrdinalIgnoreCase)).First().Value = ex.Message;
}
serviceObject.Properties.BindPropertiesToResultTable();
}
public RESTSearchResultsSerialized ExecuteSharePointSearch(Property[] inputs, RequiredProperties required, Property[] returns, MethodType methodType, ServiceObject serviceObject)
{
serviceObject.Properties.InitResultTable();
ClientResult <ResultTableCollection> results = null;
SearchInputs SearchInputs = GetInputs(inputs);
RESTSearchResultsSerialized SerializedResults = new RESTSearchResultsSerialized();
SerializedResults.Inputs = SearchInputs;
//KeywordQuery keywordQuery = new KeywordQuery(cc);
//keywordQuery.QueryText = SearchInputs.Search;
//SearchExecutor searchExecutor = new SearchExecutor(cc);
if (SearchInputs.StartRow.HasValue && SearchInputs.StartRow.Value > -1)
{
//keywordQuery.StartRow = SearchInputs.StartRow.Value;
}
//keywordQuery.RowsPerPage = int.Parse(txtRowsPerPage.Text);
if (SearchInputs.RowLimit.HasValue && SearchInputs.RowLimit.Value > -1)
{
//keywordQuery.RowLimit = SearchInputs.RowLimit.Value;
}
//keywordQuery.Culture = Configuration.LocaleId;
if (SearchInputs.SourceId != null && SearchInputs.SourceId != Guid.Empty)
{
//keywordQuery.SourceId = SearchInputs.SourceId;
}
if (SearchInputs.Sort.Count > 0)
{
}
if (SearchInputs.EnableNicknames.HasValue && SearchInputs.EnableNicknames.Value)
{
//keywordQuery.EnableNicknames = SearchInputs.EnableNicknames.Value;
}
if (SearchInputs.EnablePhonetic.HasValue && SearchInputs.EnablePhonetic.Value)
{
//keywordQuery.EnablePhonetic = SearchInputs.EnablePhonetic.Value;
}
// updated for inputs
RESTSearchResults res = ExecuteRESTRequest(BuildSearchText(SearchInputs));
if (res != null)
{
int executiontime = res.ElapsedTime;
int totalresults = res.PrimaryQueryResult.RelevantResults.TotalRows;
int resultrows = res.PrimaryQueryResult.RelevantResults.RowCount;
SerializedResults.ResultTitle = res.PrimaryQueryResult.RelevantResults.ResultTitle;
SerializedResults.ResultTitleUrl = res.PrimaryQueryResult.RelevantResults.ResultTitleUrl;
SerializedResults.SpellingSuggestions = res.SpellingSuggestion;
SerializedResults.SearchResults = res.PrimaryQueryResult.RelevantResults.Table;
// set SourceId from execution results
Guid sid = Guid.Empty;
SearchProperty SourceId = res.Properties.Where(p => p.Key.Equals("sourceid", StringComparison.InvariantCultureIgnoreCase)).First();
if (SourceId != null && Guid.TryParse(SourceId.Value, out sid))
{
SerializedResults.Inputs.SourceId = sid;
}
}
return(SerializedResults);
}
public void ExecuteSearchRead(Property[] inputs, RequiredProperties required, Property[] returns, MethodType methodType, ServiceObject serviceObject)
{
serviceObject.Properties.InitResultTable();
try
{
//SearchInputs SearchInputs = GetInputs(inputs);
RESTSearchResultsSerialized SerializedResults = new RESTSearchResultsSerialized();
SerializedResults = ExecuteSharePointSearch(inputs, required, returns, methodType, serviceObject);
if (SerializedResults != null)
{
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.Search))
{
returns.Where(p => p.Name.Equals("search", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.Search;
}
if (SerializedResults.Inputs.StartRow.HasValue && SerializedResults.Inputs.StartRow.Value > -1)
{
returns.Where(p => p.Name.Equals("startrow", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.StartRow.Value;
}
if (SerializedResults.Inputs.RowLimit.HasValue && SerializedResults.Inputs.RowLimit.Value > 0)
{
returns.Where(p => p.Name.Equals("rowlimit", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.RowLimit.Value;
}
if (SerializedResults.Inputs.SourceId != null && SerializedResults.Inputs.SourceId != Guid.Empty)
{
returns.Where(p => p.Name.Equals("sourceid", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.SourceId;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.SortString))
{
returns.Where(p => p.Name.Equals("sort", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.SortString;
}
if (SerializedResults.Inputs.EnableNicknames.HasValue && SerializedResults.Inputs.EnableNicknames.Value)
{
returns.Where(p => p.Name.Equals("enablenicknames", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.EnableNicknames.Value;
}
if (SerializedResults.Inputs.EnablePhonetic.HasValue && SerializedResults.Inputs.EnablePhonetic.Value)
{
returns.Where(p => p.Name.Equals("enablephonetic", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.Inputs.EnablePhonetic.Value;
}
if (SerializedResults.ExecutionTime.HasValue)
{
returns.Where(p => p.Name.Equals("executiontime", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.ExecutionTime.Value;
}
if (SerializedResults.ResultRows.HasValue)
{
returns.Where(p => p.Name.Equals("resultrows", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.ResultRows.Value;
}
if (SerializedResults.TotalRows.HasValue)
{
returns.Where(p => p.Name.Equals("totalrows", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.TotalRows.Value;
}
returns.Where(p => p.Name.Equals("resulttitle", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.ResultTitle;
returns.Where(p => p.Name.Equals("resulttitleurl", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.ResultTitleUrl;
returns.Where(p => p.Name.Equals("tabletype", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.TableType;
returns.Where(p => p.Name.Equals("spellingsuggestions", StringComparison.OrdinalIgnoreCase)).First().Value = SerializedResults.SpellingSuggestions;
//string resultsJson = JsonConvert.SerializeObject(results.Value[0].ResultRows);
string resultsJson = JsonConvert.SerializeObject(SerializedResults);
returns.Where(p => p.Name.Equals("serializedresults", StringComparison.OrdinalIgnoreCase)).First().Value = resultsJson;
returns.Where(p => p.Name.Equals("responsestatus", StringComparison.OrdinalIgnoreCase)).First().Value = ResponseStatus.Success;
}
else
{
throw new Exception("No results returned.");
}
}
catch (Exception ex)
{
returns.Where(p => p.Name.Equals("responsestatus", StringComparison.OrdinalIgnoreCase)).First().Value = ResponseStatus.Error;
returns.Where(p => p.Name.Equals("responsestatusdescription", StringComparison.OrdinalIgnoreCase)).First().Value = ex.Message;
}
serviceObject.Properties.BindPropertiesToResultTable();
}
public void ExecuteSearch(Property[] inputs, RequiredProperties required, Property[] returns, MethodType methodType, ServiceObject serviceObject)
{
serviceObject.Properties.InitResultTable();
System.Data.DataRow dr;
try
{
RESTSearchResultsSerialized SerializedResults = null;
// if deserializesearchresults
var sps = inputs.Where(p => p.Name.Equals("serializedresults", StringComparison.OrdinalIgnoreCase));
if (sps.Count() > 0 && inputs.Where(p => p.Name.Equals("serializedresults", StringComparison.OrdinalIgnoreCase)).First() != null && inputs.Where(p => p.Name.Equals("serializedresults", StringComparison.OrdinalIgnoreCase)).First().Value != null)
{
Property SerializedProp = inputs.Where(p => p.Name.Equals("serializedresults", StringComparison.OrdinalIgnoreCase)).First();
//if (SerializedProp != null && SerializedProp.Value != null)
//{
string json = string.Empty;
json = SerializedProp.Value.ToString();
//IEnumerable<IDictionary<string, object>> searchResults = JsonConvert.DeserializeObject<IEnumerable<IDictionary<string, object>>>(json.Trim());
SerializedResults = JsonConvert.DeserializeObject <RESTSearchResultsSerialized>(json.Trim());
if (string.IsNullOrWhiteSpace(json) || SerializedResults == null)
{
throw new Exception("Failed to deserialize search results");
}
//}
}
else
{
// if Search
SerializedResults = ExecuteSharePointSearch(inputs, required, returns, methodType, serviceObject);
}
if (SerializedResults != null)
{
// needs updating for REST
foreach (ResultRow result in SerializedResults.SearchResults.Rows)
{
dr = serviceBroker.ServicePackage.ResultTable.NewRow();
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.Search))
{
dr["search"] = SerializedResults.Inputs.Search;
}
if (SerializedResults.Inputs.StartRow.HasValue && SerializedResults.Inputs.StartRow.Value > -1)
{
dr["startrow"] = SerializedResults.Inputs.StartRow.Value;
}
if (SerializedResults.Inputs.RowLimit.HasValue && SerializedResults.Inputs.RowLimit.Value > 0)
{
dr["rowlimit"] = SerializedResults.Inputs.RowLimit.Value;
}
if (SerializedResults.Inputs.SourceId != null && SerializedResults.Inputs.SourceId != Guid.Empty)
{
dr["sourceid"] = SerializedResults.Inputs.SourceId;
}
if (!string.IsNullOrWhiteSpace(SerializedResults.Inputs.SortString))
{
dr["sort"] = SerializedResults.Inputs.SortString;
}
if (SerializedResults.Inputs.EnableNicknames.HasValue && SerializedResults.Inputs.EnableNicknames.Value)
{
dr["enablenicknames"] = SerializedResults.Inputs.EnableNicknames.Value;
}
if (SerializedResults.Inputs.EnablePhonetic.HasValue && SerializedResults.Inputs.EnablePhonetic.Value)
{
dr["enablephonetic"] = SerializedResults.Inputs.EnablePhonetic.Value;
}
if (SerializedResults.ExecutionTime.HasValue)
{
dr["executiontime"] = SerializedResults.ExecutionTime.Value;
}
if (SerializedResults.ResultRows.HasValue)
{
dr["resultrows"] = SerializedResults.ResultRows.Value;
}
if (SerializedResults.TotalRows.HasValue)
{
dr["totalrows"] = SerializedResults.TotalRows.Value;
}
dr["resulttitle"] = SerializedResults.ResultTitle;
dr["resulttitleurl"] = SerializedResults.ResultTitleUrl;
dr["tabletype"] = SerializedResults.TableType;
dr["spellingsuggestions"] = SerializedResults.SpellingSuggestions;
List <string> missingprops = new List <string>();
foreach (ResultCell cell in result.Cells)
{
if (dr.Table.Columns.Contains(cell.Key.ToLower()))
{
if (cell.Value != null)
{
dr[cell.Key.ToLower()] = cell.Value;
}
}
else
{
missingprops.Add(cell.Key);
}
}
dr["responsestatus"] = ResponseStatus.Success;
serviceBroker.ServicePackage.ResultTable.Rows.Add(dr);
}
}
else
{
throw new Exception("No results returned.");
}
}
catch (Exception ex)
{
dr = serviceBroker.ServicePackage.ResultTable.NewRow();
dr["responsestatus"] = ResponseStatus.Error;
dr["responsestatusdescription"] = ex.Message;
serviceBroker.ServicePackage.ResultTable.Rows.Add(dr);
}
//serviceObject.Properties.BindPropertiesToResultTable();
}