public JsonResult GetSentenseById(int Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { PCMPresentenceModel Model = new PCMPresentenceModel(); //initialise view model PCMPresentenceDetailsViewModel vm = new PCMPresentenceDetailsViewModel(); vm.CommunityBasedOptions_List = Model.GetCommunityBasedOption(); vm.SupendedPostponedSentence_List = Model.GetSupendedPostponedSentence(); vm.CaseStatus_List = Model.GetCaseStatus();//..................? vm.RestorectiveJustice_List = Model.GetRestorectiveJustice(); vm.ProgrammeType_List = Model.GetProgrammeType(); vm.Programme_List = Model.GetProgramme(); vm.Imprisoment_List = Model.GetImprisoment();//..................? vm.Department_List = Model.GetDepartment(); vm.Court_List = Model.GetAllCourt(); vm.Province_List = Model.GetAllProvinces(); vm.District_List = Model.GetAllDistrict(); ViewBag.CommunityBasedOptions = new SelectList(db.apl_PCM_Community_Based_Options.ToList(), "Community_Based_Options_Id", "Description"); ViewBag.SupendedPostponedSentence = new SelectList(db.apl_PCM_Supended_Postponed_Sentence.ToList(), "Suspended_Postponed_Sentence_Id", "Description"); ViewBag.CaseStatus = new SelectList(db.apl_PCM_Case_Status.ToList(), "PCM_Case_Status_Id", "Description"); ViewBag.RestorectiveJustice = new SelectList(db.apl_Restorective_Justice_Types.ToList(), "Restorective_Justice_Option_Id", "Description"); ViewBag.ProgrammeType = new SelectList(db.apl_Programme_Type.ToList(), "Programme_Type_Id", "Description"); ViewBag.Programme = new SelectList(db.apl_Programmes.ToList(), "Programme_Type_Id", "Programme_Name"); ViewBag.Imprisoment = new SelectList(db.apl_PCM_Imprisoment.ToList(), "Imprisoment_Id", "Description"); ViewBag.Department = new SelectList(db.apl_Department.ToList(), "Department_Id", "Description"); ViewBag.Province = new SelectList(db.Provinces.ToList(), "Province_Id", "Description"); ViewBag.District = new SelectList(db.Districts.ToList(), "District_Id", "Description"); ViewBag.Court = new SelectList(db.Courts.ToList(), "Court_Id", "Description"); vm = Model.GetPCMSentenseOnEditDetails(Id); string value = string.Empty; value = JsonConvert.SerializeObject(vm, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); return(Json(value, JsonRequestBehavior.AllowGet)); } }