public async Task <IViewComponentResult> InvokeAsync(Models.Query query)
{
if (query == null)
{
query = new Models.Query();
}
//Models.Query query = new Models.Query();
if (string.IsNullOrEmpty(query.QueryTerm) && !string.IsNullOrEmpty(Request.Query["term"]))
{
query.QueryTerm = Request.Query["term"];
}
if (string.IsNullOrEmpty(query.ChosenOptions) && !string.IsNullOrEmpty(Request.Query["options"]))
{
query.ChosenOptions = Request.Query["options"];
}
if (string.IsNullOrEmpty(query.ChosenAggregations) && !string.IsNullOrEmpty(Request.Query["aggregations"]))
{
query.ChosenAggregations = Request.Query["aggregations"];
}
if (query.MinScore == 0 && !string.IsNullOrEmpty(Request.Query["minScore"]))
{
query.MinScore = double.Parse(Request.Query["minScore"]);
}
if (query.QueryOptions.Count() == 0)
{
var qc = new QueryController(_logger, _memoryCache);
query.QueryOptions = await qc.GetQueryOptions(query.ChosenOptions);
}
return(View(query));
}
public async Task <IViewComponentResult> InvokeAsync(Models.Query query)
{
if (query == null)
{
query = new Models.Query();
}
//Models.Query query = new Models.Query();
if (string.IsNullOrEmpty(query.QueryTerm) && !string.IsNullOrEmpty(Request.Query["term"]))
{
query.QueryTerm = Request.Query["term"];
}
if (string.IsNullOrEmpty(query.ChosenOptions))
{
if (!string.IsNullOrEmpty(Request.Query["options"]))
{
query.ChosenOptions = Request.Query["options"].ToString();
}
else
{
query.ChosenOptions = ""; //this is required to remove previous chosen options which are not used anymore
}
}
if (string.IsNullOrEmpty(query.ChosenAggregations) && !string.IsNullOrEmpty(Request.Query["aggregations"]))
{
query.ChosenAggregations = Request.Query["aggregations"];
}
if (query.QueryOptions.Count() == 0)
{
var qc = new Controllers.QueryController(_logger, _memoryCache);
query.QueryOptions = await qc.GetQueryOptions(query.ChosenOptions);
}
return(View(query));
}
public ActionResult Search(WebOrderRequestSearchViewModel webOrderRequestSearchViewModel)
{
GRINGlobalService grinGlobalService = new GRINGlobalService(this.AuthenticatedUserSession.Environment);
Models.Query query = new Models.Query();
try
{
//if (webOrderRequestSearchViewModel.SelectedStatusCode != "ANY")
//{
// QueryCriterion queryCriterion = new QueryCriterion { FieldName = "wor.status_code", FieldValue = webOrderRequestSearchViewModel.SelectedStatusCode, SearchOperatorCode = "=", DataType = "NVARCHAR" };
// query.QueryCriteria.Add(queryCriterion);
//}
//if (webOrderRequestSearchViewModel.SelectedTimeFrameCode > 0)
//{
// QueryCriterion queryCriterion = new QueryCriterion { FieldName = "time_frame_code", FieldValue = webOrderRequestSearchViewModel.SelectedTimeFrameCode.ToString(), SearchOperatorCode = "=", DataType = "INT" };
// query.QueryCriteria.Add(queryCriterion);
//}
if (!String.IsNullOrEmpty(webOrderRequestSearchViewModel.RequestorEmailAddress))
{
QueryCriterion queryCriterion = new QueryCriterion {
FieldName = "wc.email", FieldValue = webOrderRequestSearchViewModel.RequestorEmailAddress.ToString(), SearchOperatorCode = "LIKE", DataType = "NVARCHAR"
};
query.QueryCriteria.Add(queryCriterion);
}
if (!String.IsNullOrEmpty(webOrderRequestSearchViewModel.RequestorFirstName))
{
QueryCriterion queryCriterion = new QueryCriterion {
FieldName = "wc.first_name", FieldValue = webOrderRequestSearchViewModel.RequestorFirstName.ToString(), SearchOperatorCode = "LIKE", DataType = "NVARCHAR"
};
query.QueryCriteria.Add(queryCriterion);
}
if (!String.IsNullOrEmpty(webOrderRequestSearchViewModel.RequestorLastName))
{
QueryCriterion queryCriterion = new QueryCriterion {
FieldName = "wc.last_name", FieldValue = webOrderRequestSearchViewModel.RequestorLastName, SearchOperatorCode = "LIKE", DataType = "NVARCHAR"
};
query.QueryCriteria.Add(queryCriterion);
}
// Re-initialize main index view model, adding search results.
webOrderRequestSearchViewModel.WebOrderRequests = grinGlobalService.SearchWebOrderRequests(query);
webOrderRequestSearchViewModel.Statuses = grinGlobalService.GetWebOrderRequestStatuses();
webOrderRequestSearchViewModel.IntendedUseCodes = new SelectList(grinGlobalService.GetWebOrderRequestIntendedUseCodes(), "Name", "Description");
return(View("~/Views/GRINGlobal/WebOrder/Index.cshtml", webOrderRequestSearchViewModel));
}
catch (Exception ex)
{
log.Error(ex.Message + ex.StackTrace);
return(View("~/Views/Error/_Error.cshtml"));
}
}
public PartialViewResult _Search(string statusCode, int timeFrameCode, string requestorEmail, string requestorFirstName, string requestorLastName, string intendedUseCode, string selectedDateRange)
{
WebOrderRequestListViewModel webOrderRequestListViewModel = new WebOrderRequestListViewModel();
GRINGlobalService grinGlobalService = new GRINGlobalService(this.AuthenticatedUserSession.Environment);
Models.Query query = new Models.Query();
try
{
if (!String.IsNullOrEmpty(requestorEmail))
{
QueryCriterion queryCriterion = new QueryCriterion {
FieldName = "wc.email", FieldValue = requestorEmail, SearchOperatorCode = "LIKE", DataType = "NVARCHAR"
};
query.QueryCriteria.Add(queryCriterion);
}
if (!String.IsNullOrEmpty(requestorFirstName))
{
QueryCriterion queryCriterion = new QueryCriterion {
FieldName = "wc.first_name", FieldValue = requestorFirstName, SearchOperatorCode = "LIKE", DataType = "NVARCHAR"
};
query.QueryCriteria.Add(queryCriterion);
}
if (!String.IsNullOrEmpty(requestorLastName))
{
QueryCriterion queryCriterion = new QueryCriterion {
FieldName = "wc.last_name", FieldValue = requestorLastName, SearchOperatorCode = "LIKE", DataType = "NVARCHAR"
};
query.QueryCriteria.Add(queryCriterion);
}
if (!String.IsNullOrEmpty(intendedUseCode))
{
QueryCriterion queryCriterion = new QueryCriterion {
FieldName = "wor.intended_use_code", FieldValue = intendedUseCode, SearchOperatorCode = "LIKE", DataType = "NVARCHAR"
};
query.QueryCriteria.Add(queryCriterion);
}
webOrderRequestListViewModel.WebOrderRequests = grinGlobalService.SearchWebOrderRequests(query);
return(PartialView("~/Views/GRINGlobal/WebOrder/_List.cshtml", webOrderRequestListViewModel));
}
catch (Exception ex)
{
log.Error(ex.Message + ex.StackTrace);
return(PartialView("~/Views/Error/_Error.cshtml"));
}
}
public Query ConvertToRepositoryModel(Models.Query data)
{
return(new Query
{
Id = data.Id,
PaperId = data.PaperId,
CategoryId = data.CategoryId,
Question = data.Question,
Answer = data.Answer,
Option1 = data.Option1,
Option2 = data.Option2,
Option3 = data.Option3
});
}
private async void GenerateSequenceExecute(object obj)
{
LoaderManager.Instance.ShowLoader();
await Task.Run(() =>
{
int from = 0;
int to = 0;
if (Int32.TryParse(_fromNumber, out from) && Int32.TryParse(_toNumber, out to))
{
if (from > to)
{
MessageBox.Show("From (number) should be less than To (number)");
}
else
{
_result = string.Empty;
int randomNumber;
int totalQuantity = to - from + 1;
_randomSequenceCollection = new ObservableCollection <int>();
Random random = new Random();
while (totalQuantity > 0)
{
randomNumber = random.Next(from, to + 1);
if (!_randomSequenceCollection.Contains(randomNumber))
{
_randomSequenceCollection.Add(randomNumber);
totalQuantity--;
}
}
foreach (int i in _randomSequenceCollection)
{
_result += " " + i + "\n";
}
OnPropertyChanged("Result");
Query currentQuery = new Models.Query(from, to, StationManager.CurrentUser);
DBManager.AddQuery(currentQuery);
}
}
else
{
MessageBox.Show("Please enter correct numbers");
}
});
LoaderManager.Instance.HideLoader();
}
public IList <Models.Record> Search(Models.Query query, int pages)
{
return(new List <Record>()
{
new Record()
{
FirstName = "Shane",
LastName = "Burke",
Events = new List <Event>()
{
new Event()
{
Name = "Birth", Date = "26/07/1988"
}
},
Source = new Source()
{
Name = "Google", Link = "http://www.google.com"
}
},
new Record()
{
FirstName = "Shane",
LastName = "Burke",
Events = new List <Event>()
{
new Event()
{
Name = "Birth", Date = "26 Jul 1988"
}
},
Source = new Source()
{
Name = "Ancestry", Link = "http://www.ancestry.com"
}
},
});
}
public ActionResult Search(FormCollection formCollection)
{
GRINGlobalService grinGlobalService = new GRINGlobalService(this.AuthenticatedUserSession.Environment);
WebOrderRequestListViewModel webOrderRequestListViewModel = new WebOrderRequestListViewModel();
Models.Query query = new Models.Query();
try
{
if (!String.IsNullOrEmpty(formCollection["ID"].Trim()))
{
if (Int32.Parse(formCollection["ID"]) > 0)
{
query.QueryCriteria.Add(new QueryCriterion {
FieldName = "web_order_request_id", SearchOperatorCode = "=", FieldValue = formCollection["ID"], DataType = "INT"
});
}
}
if (!String.IsNullOrEmpty(formCollection["RequestorEmailAddress"]))
{
query.QueryCriteria.Add(new QueryCriterion {
FieldName = "web_cooperator_email", SearchOperatorCode = "LIKE", FieldValue = formCollection["RequestorEmailAddress"], DataType = "NVARCHAR"
});
}
if (!String.IsNullOrEmpty(formCollection["RequestorFirstName"]))
{
query.QueryCriteria.Add(new QueryCriterion {
FieldName = "web_cooperator_first_name", SearchOperatorCode = "LIKE", FieldValue = formCollection["RequestorFirstName"], DataType = "NVARCHAR"
});
}
if (!String.IsNullOrEmpty(formCollection["RequestorLastName"]))
{
query.QueryCriteria.Add(new QueryCriterion {
FieldName = "web_cooperator_last_name", SearchOperatorCode = "LIKE", FieldValue = formCollection["RequestorLastName"], DataType = "NVARCHAR"
});
}
if (!String.IsNullOrEmpty(formCollection["RequestorOrganization"]))
{
query.QueryCriteria.Add(new QueryCriterion {
FieldName = "web_cooperator_organization", SearchOperatorCode = "LIKE", FieldValue = formCollection["RequestorOrganization"], DataType = "NVARCHAR"
});
}
if (!String.IsNullOrEmpty(formCollection["IntendedUseCode"]))
{
query.QueryCriteria.Add(new QueryCriterion {
FieldName = "intended_use_code", SearchOperatorCode = "=", FieldValue = formCollection["IntendedUseCode"], DataType = "NVARCHAR"
});
}
if (!String.IsNullOrEmpty(formCollection["SelectedStatusCode"]))
{
query.QueryCriteria.Add(new QueryCriterion {
FieldName = "status_code", SearchOperatorCode = "=", FieldValue = formCollection["SelectedStatusCode"], DataType = "NVARCHAR"
});
}
if ((!String.IsNullOrEmpty(formCollection["SelectedStartDate"])) && (formCollection["SelectedStartDate"].Trim().Length > 0))
{
var DEBUG = formCollection["SelectedStartDate"].Trim().Length;
query.QueryCriteria.Add(new QueryCriterion {
FieldName = "ordered_date", SearchOperatorCode = ">=", FieldValue = formCollection["SelectedStartDate"], DataType = "DATETIME"
});
}
if ((!String.IsNullOrEmpty(formCollection["SelectedEndDate"])) && (formCollection["SelectedEndDate"].Trim().Length > 0))
{
query.QueryCriteria.Add(new QueryCriterion {
FieldName = "ordered_date", SearchOperatorCode = "<=", FieldValue = formCollection["SelectedEndDate"], DataType = "DATETIME"
});
}
webOrderRequestListViewModel.WebOrderRequests = grinGlobalService.SearchWebOrderRequests(query);
return(PartialView(BASE_PATH + "/_SearchResults.cshtml", webOrderRequestListViewModel));
}
catch (Exception ex)
{
Log.Error(ex, ex.Message);
return(RedirectToAction("InternalServerError", "Error"));
}
}
public async Task <ActionResult> Details(string _index, string _type, string _id)
{
var qc = new Controllers.QueryController(_logger, _memoryCache);
var result = await qc.GetDocument(_index, _type, _id);
Models.SearchResult searchResult = new Models.SearchResult()
{
Id = result.Id,
CanRead = true,
Index = result.Index,
Type = result.Type,
Summary = result.Source.ToString(),
Source = result.Source.ToString()
};
try
{
searchResult.Path = ((string)result.Source["Path"]);
searchResult.ThumbnailPath = ((string)result.Source["ThumbnailPath"]);
}
catch (Exception)
{
}
if (!string.IsNullOrEmpty(searchResult.Path))//(searchResult.Type == "directory" || searchResult.Type == "file" || searchResult.Type == "photo")
{
searchResult.CanRead = Helpers.QueryHelper.UserHasAccess(User.Identity.Name, searchResult.Path.Substring(0, searchResult.Path.LastIndexOf('/')), _memoryCache);
if (searchResult.CanRead)
{
//searchResult.Path = searchResult.PrettyPath;
try
{
searchResult.Extension = (string)result.Source["Extension"];
DateTime lm = new DateTime();
if (DateTime.TryParse((string)result.Source["LastModified"], out lm))
{
searchResult.LastModified = lm.ToLocalTime(); //convert from UTC
}
}
catch (Exception)
{
}
if (System.IO.File.Exists(searchResult.Path) && result.Type == "photo")
{
string imageMagicHome = Environment.GetEnvironmentVariable("MAGICK_HOME");
if (!string.IsNullOrEmpty(imageMagicHome) && System.IO.Directory.Exists(imageMagicHome))
{
System.IO.FileInfo fi = new System.IO.FileInfo(searchResult.Path);
string localname = fi.FullName.GetHashCode() + ".png";
var localPath = Path.Combine(Environment.GetEnvironmentVariable("WebRootPathTemp"), localname);
//var localPath = Path.Combine(_hostingEnvironment.WebRootPath, "temp", localname);
searchResult.ThumbnailPath = "temp/" + localname;
if (!System.IO.File.Exists(localPath))
{
ProcessStartInfo psi = new ProcessStartInfo(Path.Combine(imageMagicHome, "magick.exe"), string.Format("\"{0}\" -resize 300x300 \"{1}\"", fi.FullName, localPath));
psi.WorkingDirectory = imageMagicHome;
//psi.UseShellExecute = true;
var p = Process.Start(psi);
p.WaitForExit(2000); //needs 2 sec delay before rendering that page
}
}
else //slow !!!
{
using (Stream str = System.IO.File.OpenRead(searchResult.Path))
{
using (MemoryStream data = new MemoryStream())
{
str.CopyTo(data);
data.Seek(0, SeekOrigin.Begin);
byte[] buf = new byte[data.Length];
data.Read(buf, 0, buf.Length);
searchResult.Content = buf;
}
}
}
///SystemDrawing is NotFound implemented in Core 1 RC2 yet :(
//Image image = Image.FromFile(imagePath, false);
//Image thumb = image.GetThumbnailImage(100, 100, () => false, IntPtr.Zero);
//thumb.Save(localPath, System.Drawing.Imaging.ImageFormat.Png);
//thumb.Dispose();
}
}
}
//More Like This request
Models.Query mltQuery = new Models.Query()
{
QueryTerm = _index + "/" + _type + "/" + _id,
Size = 10,
ChosenOptions = "1_" + _index + "+2_" + _type + "+3_6+"
};
var mltResults = await qc.GetSearchResponse(mltQuery);
searchResult.MoreLikeThis = qc.GetSearchResults(User.Identity.Name, mltResults, mltQuery.QueryTerm)
.Where(sr => sr.Id != _id)
.Take(5);
//foreach (var item in searchResult.MoreLikeThis)
//{
// if (item.Id == _id)
// {
// item.Delete()
// }
//}
if (Request.Headers["X-Requested-With"] == "XMLHttpRequest")//(Request.IsAjaxRequest())
{
return(PartialView(searchResult));
}
return(View(searchResult));
}
public abstract IList <Models.Record> Search(Models.Query query, int pages);
