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 ActionResult Index() { TempData["context"] = "Home"; GRINGlobalService grinGlobalService = new GRINGlobalService(this.AuthenticatedUserSession.Environment); WebOrderRequestSearchViewModel viewModel = new WebOrderRequestSearchViewModel(); try { viewModel.Statuses = grinGlobalService.GetWebOrderRequestStatuses(); viewModel.IntendedUseCodes = new SelectList(grinGlobalService.GetWebOrderRequestIntendedUseCodes(), "Name", "Description"); return(View("~/Views/GRINGlobal/WebOrder/Index.cshtml", viewModel)); } catch (Exception ex) { log.Error(ex.Message + ex.StackTrace); return(RedirectToAction("InternalServerError", "Error")); } }
public ActionResult Search(int webOrderRequestId = 0, string emailAddress = "", string firstName = "", string lastName = "", string organization = "") { TempData["page_title"] = "Web Order Request Search"; WebOrderRequestSearchViewModel webOrderRequestSearchViewModel = new WebOrderRequestSearchViewModel(); GRINGlobalService service = new GRINGlobalService(this.AuthenticatedUserSession.Environment); try { webOrderRequestSearchViewModel.StatusCodes = new SelectList(service.GetWebOrderRequestStatuses(), "Name", "Name"); webOrderRequestSearchViewModel.IntendedUseCodes = new SelectList(service.GetWebOrderRequestIntendedUseCodes(), "Name", "Description"); if (webOrderRequestId > 0) { webOrderRequestSearchViewModel.ID = webOrderRequestId; } if (!String.IsNullOrEmpty(emailAddress)) { webOrderRequestSearchViewModel.RequestorEmailAddress = emailAddress; } if (!String.IsNullOrEmpty(firstName)) { webOrderRequestSearchViewModel.RequestorFirstName = firstName; } if (!String.IsNullOrEmpty(lastName)) { webOrderRequestSearchViewModel.RequestorLastName = lastName; } if (!String.IsNullOrEmpty(organization)) { webOrderRequestSearchViewModel.RequestorOrganization = organization; } return(View("~/Views/GRINGlobal/WebOrder/Search.cshtml", webOrderRequestSearchViewModel)); } catch (Exception ex) { Log.Error(ex, ex.Message); return(RedirectToAction("InternalServerError", "Error")); } }
public ActionResult Index() { TempData["page_title"] = "Home"; GRINGlobalService grinGlobalService = new GRINGlobalService(this.AuthenticatedUserSession.Environment); WebOrderRequestSearchViewModel viewModel = new WebOrderRequestSearchViewModel(); try { viewModel.Statuses = grinGlobalService.GetWebOrderRequestStatuses(); if (viewModel.Statuses.Count() > 0) { viewModel.CurrentID = viewModel.Statuses.First().ID; } viewModel.IntendedUseCodes = new SelectList(grinGlobalService.GetWebOrderRequestIntendedUseCodes(), "Name", "Description"); return(View(BASE_PATH + "Index.cshtml", viewModel)); } catch (Exception ex) { Log.Error(ex, ex.Message); return(RedirectToAction("InternalServerError", "Error")); } }