コード例 #1
0
        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));
        }
コード例 #2
0
        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));
        }