/// <summary> /// Method return view Survey/Index.cshtml of Admin /// </summary> /// <returns></returns> public IActionResult Index() { try { SurveyListAdminModel listSurvey = new SurveyListAdminModel(); //Get list Event and put it into search dropdown at Survey/Index.cshtml of Admin listSurvey.ListEvent = _unitOfWork.MasterDataRepository.GetSelectListEvent(); return(View(listSurvey)); } catch (Exception) { throw; } }
public JsonResult LoadListSurveys(SurveyListAdminModel surveyList) { try { surveyList.SortColumnName = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"].FirstOrDefault(); surveyList.SortDirection = Request.Form["order[0][dir]"].FirstOrDefault(); //Get list survey var data = _unitOfWork.SurveyRepository.LoadListSurveyAdmin(surveyList); //Put list survey to json result var result = Json(new { data = data.ListSurvey, draw = surveyList.Draw, recordsFiltered = data.TotalRowsAfterFiltering }); return(result); } catch (Exception e) { return(Json(new AjaxResponseModel(false, e.Message))); } }
/// <summary> /// This method to get list Survey from DB and put it into Admin/List Survey /// </summary> /// <param name="surveyList"></param> /// <returns></returns> public SurveyListAdminModel LoadListSurveyAdmin(SurveyListAdminModel surveyList) { try { var listSurveyResult = new SurveyListAdminModel(); var surveysIQuery = _context.Surveys.Where(x => !x.IsDeleted); //Search survey with eventCd if eventCd is not null if (surveyList.EventCd != 0) { surveysIQuery = surveysIQuery.Where(x => x.EventCd == surveyList.EventCd); } listSurveyResult.TotalRowsAfterFiltering = surveysIQuery.Count(); //Sort And Paging surveysIQuery = Filtering(surveysIQuery, surveyList); listSurveyResult.ListSurvey = surveysIQuery .Select(s => new { s.Cd, s.InsertDate, s.MediaCd, MediaName = s.Media.Name, s.VisitTime, s.AgeRange, s.Gender, s.CareerCd, CareerName = s.Career.Name, s.IsMarried, s.LivingStatus, s.IsComeToBuy, s.IsVisitedReception, s.FavoriteArtist, SurveyArtistName = s.SurveyArtists.Select(a => new { a.Artist.Name, a.Artist.Code, }) }) .AsEnumerable() .Select(m => new SurveyItemAdminModel() { Cd = m.Cd, InsertDate = m.InsertDate?.ToString(ExactDateTimeFormat), MediaName = m.MediaName, VisitTimeDescription = ((VisitTime)m.VisitTime).GetEnumDescription(), AgeRangeDescription = ((AgeRange)m.AgeRange).GetEnumDescription(), GenderName = ((GenderOfSurvey)Convert.ToInt32(m.Gender)).GetEnumDescription(), CareerName = m.CareerName, IsMarriedDescription = ((IsMarried)Convert.ToInt32(m.IsMarried)).GetEnumDescription(), LivingStatusDescription = ((LivingStatus)Convert.ToInt32(m.LivingStatus)).GetEnumDescription(), IsComeToBuyDescription = ((IsComeToBuy)Convert.ToInt32(m.IsComeToBuy)).GetEnumDescription(), FavoriteArtist = m.FavoriteArtist, SurveyArtistName = m.SurveyArtistName.OrderBy(m => m.Code).Select(y => y.Name).ToList(), }).ToList(); return(listSurveyResult); } catch (Exception) { throw; } }