protected DataSet getSearchData()
{
//Get image data
SearchDS searchDS = new SearchDS();
SearchDS.SearchTableRow searchRow = searchDS.SearchTable.NewSearchTableRow();
searchRow.ScopeName = this.cboDocClass.SelectedValue;
searchRow.DocumentClass = this.cboDocClass.SelectedValue;
searchRow.PropertyName = this.cboProp1.SelectedValue;
searchRow.PropertyValue = this.txtSearch1.Text.Trim();
if (this.txtSearch2.Text.Trim().Length > 0)
{
searchRow.Operand1 = this.cboOperand1.SelectedValue;
searchRow.PropertyName1 = this.cboProp2.SelectedValue;
searchRow.PropertyValue1 = this.txtSearch2.Text.Trim();
}
if (this.txtSearch3.Text.Trim().Length > 0)
{
searchRow.Operand2 = this.cboOperand2.SelectedValue;
searchRow.PropertyName2 = this.cboProp3.SelectedValue;
searchRow.PropertyValue2 = this.txtSearch3.Text.Trim();
}
if (this.txtSearch4.Text.Trim().Length > 0)
{
searchRow.Operand3 = this.cboOperand3.SelectedValue;
searchRow.PropertyName3 = this.cboProp4.SelectedValue;
searchRow.PropertyValue3 = this.txtSearch4.Text.Trim();
}
searchDS.SearchTable.AddSearchTableRow(searchRow);
Argix.Freight.ImagingService isvc = new Argix.Freight.ImagingService();
return(isvc.SearchSharePointImageStore(searchDS));
}
private string getWhereClause(SearchDS search)
{
//Build a WHERE clause
string propertyName;
StringBuilder sb = new StringBuilder();
if (search.SearchTable[0].PropertyValue.Trim().Length > 0)
{
propertyName = XmlConvert.EncodeName(search.SearchTable[0].PropertyName);
if (propertyName.ToLower().Contains("date") || propertyName.ToLower() == "created")
{
sb.Append(getDateClause(propertyName, search.SearchTable[0].PropertyValue.Trim()));
}
else
{
sb.Append("Property LIKE 'SearchText' ".Replace("Property", propertyName).Replace("SearchText", search.SearchTable[0].PropertyValue.Trim()));
}
}
if (!search.SearchTable[0].IsPropertyName1Null() && !search.SearchTable[0].IsPropertyValue1Null() && !search.SearchTable[0].IsOperand1Null() && search.SearchTable[0].PropertyValue1.Trim().Length > 0)
{
sb.Append(" " + search.SearchTable[0].Operand1);
propertyName = XmlConvert.EncodeName(search.SearchTable[0].PropertyName1);
if (propertyName.ToLower().Contains("date") || propertyName.ToLower() == "created")
{
sb.Append(getDateClause(propertyName, search.SearchTable[0].PropertyValue1.Trim()));
}
else
{
sb.Append(" " + "Property LIKE 'SearchText' ".Replace("Property", propertyName).Replace("SearchText", search.SearchTable[0].PropertyValue1.Trim()));
}
}
if (!search.SearchTable[0].IsPropertyName2Null() && !search.SearchTable[0].IsPropertyValue2Null() && !search.SearchTable[0].IsOperand2Null() && search.SearchTable[0].PropertyValue2.Trim().Length > 0)
{
sb.Append(" " + search.SearchTable[0].Operand2);
propertyName = XmlConvert.EncodeName(search.SearchTable[0].PropertyName2);
if (propertyName.ToLower().Contains("date") || propertyName.ToLower() == "created")
{
sb.Append(getDateClause(propertyName, search.SearchTable[0].PropertyValue2.Trim()));
}
else
{
sb.Append(" " + "Property LIKE 'SearchText' ".Replace("Property", propertyName).Replace("SearchText", search.SearchTable[0].PropertyValue2.Trim()));
}
}
if (!search.SearchTable[0].IsPropertyName3Null() && !search.SearchTable[0].IsPropertyValue3Null() && !search.SearchTable[0].IsOperand3Null() && search.SearchTable[0].PropertyValue3.Trim().Length > 0)
{
sb.Append(" " + search.SearchTable[0].Operand3);
propertyName = XmlConvert.EncodeName(search.SearchTable[0].PropertyName3);
if (propertyName.ToLower().Contains("date") || propertyName.ToLower() == "created")
{
sb.Append(getDateClause(propertyName, search.SearchTable[0].PropertyValue3.Trim()));
}
else
{
sb.Append(" " + "Property LIKE 'SearchText' ".Replace("Property", propertyName).Replace("SearchText", search.SearchTable[0].PropertyValue3.Trim()));
}
}
return(sb.ToString());
}
public DataSet SearchSharePointImageStore(SearchDS search)
{
//
DataSet ds = null;
try {
string SQL = getSQLQuery(search.SearchTable[0].ScopeName);
SQL = SQL.Replace("selectStmnt", getSelectClause(search.SearchTable[0].DocumentClass)).Replace("whereClause", getWhereClause(search)).Replace("MaxSearchResults", search.SearchTable[0].MaxResults.ToString());
rgxvmsp.QueryService qs = new rgxvmsp.QueryService();
qs.Credentials = getCredentials();
qs.PreAuthenticate = true;
//qs.Timeout = 500000; //Default 100000 msec
qs.Url = WebConfigurationManager.AppSettings["rgxvmsp.spsearch"].ToString();
qs.Credentials = getCredentials();
ds = qs.QueryEx(SQL);
}
catch (Exception ex) { throw new ApplicationException("Unexpected error in SearchSharePointImageStore(SearchDS).", ex); }
return(ds);
}
public byte[] GetSharePointImageStream(SearchDS search)
{
//Return an image from SharePoint as a byte[]
byte[] bytes = null;
try {
//Search for image
DataSet ds = SearchSharePointImageStore(search);
if (ds.Tables[0].Rows.Count > 0)
{
//Get image url
string url = ds.Tables[0].Rows[0]["DAV%3ahref"].ToString();
//Pull the image from a remote client and load into an image object
WebClient wc = new WebClient();
wc.Credentials = getCredentials();
bytes = wc.DownloadData(url);
}
}
catch (ApplicationException ex) { throw ex; }
catch (Exception ex) { throw new ApplicationException("Unexpected error in GetSharePointImageStream(SearchDS).", ex); }
return(bytes);
}
