public ActionResult SearchQuestionList(QuestionSearchFilter searchFilter) { Logger.Info(_logMsg.Clear().SetPrefixMsg("Search Question").ToInputLogString()); try { if (ModelState.IsValid) { _questionFacade = new QuestionFacade(); QuestionViewModel questionVM = new QuestionViewModel(); questionVM.SearchFilter = searchFilter; questionVM.QuestionList = _questionFacade.GetQuestionList(questionVM.SearchFilter); ViewBag.PageSize = questionVM.SearchFilter.PageSize; return(PartialView("~/Views/Question/_QuestionList.cshtml", questionVM)); } return(Json(new { Valid = false, Error = string.Empty })); } catch (Exception ex) { Logger.Error("Exception occur:\n", ex); Logger.Info(_logMsg.Clear().SetPrefixMsg("Search Question").Add("Error Message", ex.Message).ToFailLogString()); return(Error(new HandleErrorInfo(ex, this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString()))); } }
public IEnumerable <QuestionItemEntity> GetQuestionList(QuestionSearchFilter searchFilter) { var questionStatus = searchFilter.Status.ToNullable <bool>(); var resultQuery = (from question in _context.TB_M_QUESTION from createUser in _context.TB_R_USER.Where(x => x.USER_ID == question.CREATE_USER).DefaultIfEmpty() from updateUser in _context.TB_R_USER.Where(x => x.USER_ID == question.UPDATE_USER).DefaultIfEmpty() where ((searchFilter.QuestionName == null || question.QUESTION_NAME.Contains(searchFilter.QuestionName)) && (!questionStatus.HasValue || question.IS_ACTIVE == questionStatus)) select new QuestionItemEntity { QuestionId = question.QUESTION_ID, QuestionName = question.QUESTION_NAME, IsActive = question.IS_ACTIVE != null && (bool)question.IS_ACTIVE ? "Active" : "Inactive", UpdateUserName = (updateUser != null ? new UserEntity() { PositionCode = updateUser.POSITION_CODE, Firstname = updateUser.FIRST_NAME, Lastname = updateUser.LAST_NAME } : null), CreateUserName = (createUser != null ? new UserEntity() { PositionCode = createUser.POSITION_CODE, Firstname = createUser.FIRST_NAME, Lastname = createUser.LAST_NAME } : null), UpdateDate = question.UPDATE_DATE.HasValue ? question.UPDATE_DATE : question.CREATE_DATE, CreateUser = (int)question.CREATE_USER, UpdateUser = (int)question.UPDATE_USER }); int startPageIndex = (searchFilter.PageNo - 1) * searchFilter.PageSize; searchFilter.TotalRecords = resultQuery.Count(); if (startPageIndex >= searchFilter.TotalRecords) { startPageIndex = 0; searchFilter.PageNo = 1; } resultQuery = SetQuestionListSort(resultQuery, searchFilter); return(resultQuery.Skip(startPageIndex).Take(searchFilter.PageSize).ToList()); }
private static IQueryable <QuestionItemEntity> SetQuestionListSort(IQueryable <QuestionItemEntity> areaList, QuestionSearchFilter searchFilter) { if (searchFilter.SortOrder.ToUpper(CultureInfo.InvariantCulture).Equals("ASC")) { switch (searchFilter.SortField.ToUpper(CultureInfo.InvariantCulture)) { default: return(areaList.OrderBy(a => a.QuestionName)); } } else { switch (searchFilter.SortField.ToUpper(CultureInfo.InvariantCulture)) { default: return(areaList.OrderByDescending(a => a.QuestionName)); } } }
public IEnumerable <QuestionItemEntity> GetQuestionList(QuestionSearchFilter searchFilter) { _questionDataAccess = new QuestionDataAccess(_context); return(_questionDataAccess.GetQuestionList(searchFilter)); }