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 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"));
}
}
