public SearchResultPTO FullTextSearch(string query, int page = 1, int pageSize = 10)
{
int offset = 0;
if (page > 1)
{
offset = (page - 1) * pageSize;
}
// client to interact with elasticSearch
client = ElasticSearchConfig.GetClient();
// query to run against the Author, Title and name field
var result = client.Search <Document>(x => x
.Query(q => q
.MultiMatch(mp => mp
.Query(query)
.Fields(f => f
.Fields(f1 => f1.Title, f2 => f2.Subtitle))))
.Highlight(h => h
.PreTags("<bold style=\"color: blue; \">")
.PostTags("</bold>")
.Fields(fs => fs
.Field(p => p.Title) // Highlight strings in title and Subtitle fields
.Type("plain"), // that match the query
fs => fs
.Field(p => p.Subtitle)
.Type("plain")))
.From(offset) //pagination options
.Size(pageSize));
// return a result object containing resulting documents from Query along with some more
// information about the query results
return(new SearchResultPTO
{
Total = (int)result.Total,
Page = page,
Results = result.Hits.Select(h => new ResultPTO()
{
DocuID = h.Source.DocuID,
DocumentID = h.Source.DocumentID,
FileSize = h.Source.FileSize,
FilePath = "",
Title = (h.Highlights.Values.Count > 1) ? h.Highlights.Values.ElementAt(1).Highlights.First() : h.Source.Title,
Subtitle = (h.Highlights.Values.Count > 0) ? h.Highlights.Values.First().Highlights.First() : h.Source.Subtitle,
FunctionalArea = h.Source.FunctionalArea,
LastModified = h.Source.LastModified,
Release = h.Source.Release,
SubType = h.Source.SubType,
InPackage = false,
PrevInPackage = false
}),
QueryTime = result.Took,
// add the aggregations later on
});
}
public void Create(HttpPostedFileBase upload)
{
// client to interact with elasticSearch
client = ElasticSearchConfig.GetClient();
//Most of Avaloq's document filenames follow the format of ID-ReleaseNum-ClientNum-Subtype-Subtitle.pdf
//The service checks if the given file follows the same format, and if so, retrieves the metadata.
using (var dc = new DocuContext())
{
var document = new Models.Document {
};
var fileName = upload.FileName;
String[] metadata = fileName.Split('-');
if (upload != null && upload.ContentLength > 0 && metadata.Length >= 5)
{
document.SubType = metadata[3];
document.DocuID = Convert.ToInt32(metadata[0]);
if (metadata[1].Equals("en"))
{
document.Release = "Release Independent";
}
else
{
document.Release = "Release " + metadata[1];
}
document.LastModified = DateTime.Today.Date;
document.FileSize = upload.ContentLength;
document.Title = upload.FileName;
document.Subtitle = metadata[4];
var filepath = new Models.FilePath
{
FileName = Path.GetFileName(upload.FileName),
};
document.FilePath = filepath;
}
else if (upload != null && upload.ContentLength > 0)
{
document.SubType = "null";
document.DocuID = 0;
document.Release = "null";
document.LastModified = DateTime.Today.Date;
document.FileSize = upload.ContentLength;
document.Title = upload.FileName;
document.Subtitle = "null";
var filepath = new Models.FilePath
{
FileName = Path.GetFileName(upload.FileName),
};
document.FilePath = filepath;
}
dc.Documents.Add(document);
dc.SaveChanges();
document.FilePath = null;
var result = client.Index(document);
}
}
public void SetElasticDb()
{
client = ElasticSearchConfig.GetClient();
var docs = client.Search <Document>(x => x
.Query(q => q
.MultiMatch(mp => mp
.Query(" ")
.Fields(f => f
.Fields(f1 => f1.Title, f2 => f2.Subtitle))))
.From(0)
.Size(0));
var y = 5;
}
public SearchResultPTO FilterSearch(string query, int page = 1, int pageSize = 10, bool titleOnly = false, int DocuID = 0, string Release = null, string FunctionalArea = null, string DocuType = null, string SubType = null, DateTime?LastModifiedTo = null, DateTime?LastModifiedFrom = null, string sortBy = null)
{
var filters = new List <Func <QueryContainerDescriptor <Document>, QueryContainer> >();
if (DocuID != 0)
{
filters.Add(r2 => r2.Match(q2 => q2
.Query(DocuID.ToString())
.Field(f3 => f3.DocuID)));
}
if (FunctionalArea != null)
{
//var selectedFunctionalAreas = FunctionalArea.Split(" ");
filters.Add(r2 => r2.Match(q2 => q2
.Query(FunctionalArea)
.Field(f3 => f3.FunctionalArea)));
}
if (Release != null)
{
filters.Add(r2 => r2.MatchPhrase(q2 => q2
.Query(Release)
.Field(f3 => f3.Release)));
}
if (LastModifiedFrom != null)
{
filters.Add(r2 => r2.DateRange(d => d
.Field(d1 => d1.LastModified)
.GreaterThanOrEquals(LastModifiedFrom)));
}
if (LastModifiedTo != null)
{
filters.Add(r2 => r2.DateRange(d => d
.Field(d1 => d1.LastModified)
.LessThanOrEquals(LastModifiedTo)));
}
if (DocuType != null)
{
filters.Add(r2 => r2.MatchPhrase(q2 => q2
.Query(DocuType)
.Field(f3 => f3.DocuType)));
}
if (SubType != null)
{
filters.Add(r2 => r2.MatchPhrase(q2 => q2
.Query(SubType)
.Field(f3 => f3.SubType)));
}
client = ElasticSearchConfig.GetClient();
int offset = 0;
if (page > 1)
{
offset = page * pageSize;
}
if (query == null)
{
query = " ";
}
var result = client.Search <Document>(x => x
.Sort(sort =>
{
if (sortBy == "LastModified")
{
return(sort.Descending(r => r.LastModified));
}
else if (sortBy == "DocuID")
{
return(sort.Descending(r => r.DocuID));
}
else
{
return(sort.Descending("_score"));
}
})
.Query(q => q
.MultiMatch(mp => mp
.Query(query)
.Fields(f => f
.Fields(f1 => f1.Title, f2 => f2.Subtitle))))
.Highlight(h => h
.PreTags("<bold style=\"color: blue; \">")
.PostTags("</bold>")
.Fields(fs => fs
.Field(p => p.Title) // Highlight strings in title and Subtitle fields
.Type("plain"), // that match the query
fs => fs
.Field(p => p.Subtitle)
.Type("plain")))
.PostFilter(r => r
.Bool(r1 => r1.Must(filters)))
.From(offset) //pagination options
.Size(pageSize)
);
return(new SearchResultPTO
{
Total = (int)result.Total,
Page = page,
Results = result.Hits.Select(h => new ResultPTO()
{
DocuID = h.Source.DocuID,
DocumentID = h.Source.DocumentID,
FileSize = h.Source.FileSize,
FilePath = "",
Title = (h.Highlights.Values.Count > 1) ? h.Highlights.Values.ElementAt(1).Highlights.First() : h.Source.Title,
Subtitle = (h.Highlights.Values.Count > 0) ? h.Highlights.Values.First().Highlights.First() : h.Source.Subtitle,
FunctionalArea = h.Source.FunctionalArea,
LastModified = h.Source.LastModified,
Release = h.Source.Release,
SubType = h.Source.SubType,
InPackage = false,
PrevInPackage = false
}),
QueryTime = result.Took,
// add the aggregations later on
});
}