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));
}
}