public JsonResult GetQuestionListEditByUser(CrmBuyTypeViewModel model) { Response response; try { using (var db = new KiaGalleryContext()) { var customer = db.CrmCustomer.Single(x => x.Id == model.id); var list = db.CrmQuestion.Where(x => x.BuyTypeOnline == customer.BuyTypeOnline && x.BuyTypeSubset == customer.BuyTypeSubset); var data = list.Select(x => new QuestionViewModel() { id = x.Id, crmQuestionType = x.CrmQuestionType, buyType = x.BuyType, buyTypeSubset = x.BuyTypeSubset, buyTypeOnline = x.BuyTypeOnline, defaultDescriptive = x.DefaultDescriptive, defaultYesNo = x.DefaultYesNo, title = x.Title, crmQuestionValueViewModelList = x.CrmQuestionValueList.Select(y => new CrmQuestionValueViewModel() { id = y.Id, crmQuestionId = y.CrmQuestionId, defaultSelected = y.DefaultSelected, description = y.Description, value = y.Value, }).ToList(), }).ToList(); response = new Response() { status = 200, data = new { list = data } }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult GetQuestionList(CrmBuyTypeViewModel model) { Response response; try { using (var db = new KiaGalleryContext()) { var list = db.CrmQuestion.Where(x => x.BuyTypeSubset == model.buyTypeSubset && x.BuyTypeOnline == model.buyTypeOnline).ToList(); if (User.IsInRole("branchCrm")) { list = list.Where(x => x.BuyType == BuyType.BuyAttendance).ToList(); } if (User.IsInRole("officeCrm")) { list = list.Where(x => x.BuyType == BuyType.BuyOnline).ToList(); } list.Select(x => new QuestionViewModel() { id = x.Id, crmQuestionType = x.CrmQuestionType, buyType = x.BuyType, buyTypeSubset = x.BuyTypeSubset, buyTypeOnline = x.BuyTypeOnline, defaultDescriptive = x.DefaultDescriptive, defaultYesNo = x.DefaultYesNo, title = x.Title, crmQuestionValueViewModelList = x.CrmQuestionValueList.Select(y => new CrmQuestionValueViewModel() { id = y.Id, crmQuestionId = y.CrmQuestionId, defaultSelected = y.DefaultSelected, description = y.Description, value = y.Value, }).ToList(), }).ToList(); response = new Response() { status = 200, data = new { list = list.Select(x => new { id = x.Id, crmQuestionType = x.CrmQuestionType, buyType = x.BuyType, buyTypeSubset = x.BuyTypeSubset, buyTypeOnline = x.BuyTypeOnline, defaultDescriptive = x.DefaultDescriptive, defaultYesNo = x.DefaultYesNo, title = x.Title, crmQuestionValueViewModelList = x.CrmQuestionValueList.Select(y => new CrmQuestionValueViewModel() { id = y.Id, crmQuestionId = y.CrmQuestionId, defaultSelected = y.DefaultSelected, description = y.Description, value = y.Value, }).ToList(), }).ToList(), } }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }