public void UpdateOutcome(PCMFCRViewModel vm, int FormalCourtOutcome_Id, int assID) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_FCR_Outcome pp = db.PCM_FCR_Outcome.Find(FormalCourtOutcome_Id); pp.CourtDate = vm.CourtDate; pp.Remand = vm.Remand; pp.RemandReason = vm.RemandReason; pp.NextCourtDate = vm.NextCourtDate; pp.CourtOutcome = vm.CourtOutcome; pp.FormalCaseStatus_Id = vm.FormalCaseStatus_Id; pp.Placement_Type_Id = vm.Placement_Type_Id; pp.Recommendation_Type_Id = vm.PCM_Recommendation_Id; db.SaveChanges(); PCM_HB_Supervision exist1 = db.PCM_HB_Supervision.OrderByDescending(x => x.HomeBasedSupervision_Id).FirstOrDefault(x => x.FormalCourtOutcome_Id == FormalCourtOutcome_Id); //PCM_HB_Supervision exist1 = db.PCM_HB_Supervision.OrderByDescending.Where(x => x.FormalCourtOutcome_Id == FormalCourtOutcome_Id).FirstOrDefault(); if (pp.Placement_Type_Id == 187 && exist1 == null) { PCM_HB_Supervision newhomebase = new PCM_HB_Supervision(); newhomebase.FormalCourtOutcome_Id = pp.FormalCourtOutcome_Id; newhomebase.Intake_Assessment_Id = assID; newhomebase.Court_Type_Id = 2; db.PCM_HB_Supervision.Add(newhomebase); db.SaveChanges(); } PCM_Diversion exist12 = db.PCM_Diversion.OrderByDescending(x => x.Diversion_Id).FirstOrDefault(x => x.Formal_Courtcome_Id == FormalCourtOutcome_Id); //PCM_Diversion exist12 = db.PCM_Diversion.Where(x => x.Formal_Courtcome_Id == FormalCourtOutcome_Id).FirstOrDefault(); if (pp.Recommendation_Type_Id == 1 && exist12 == null) { PCM_Diversion newhomebase = new PCM_Diversion(); newhomebase.Formal_Courtcome_Id = pp.FormalCourtOutcome_Id; newhomebase.Intake_Assessment_Id = assID; newhomebase.Court_Type_Id = 2; db.PCM_Diversion.Add(newhomebase); db.SaveChanges(); } } catch (Exception ex) { throw ex; } } }
public PCMFCRViewModel GetFormalCourtById(int CourtId) { PCMFCRViewModel vm = new PCMFCRViewModel(); using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_FCR_Outcome act = db.PCM_FCR_Outcome.Find(CourtId); if (act != null) { vm.FormalCourtOutcome_Id = act.FormalCourtOutcome_Id; vm.FormalCaseStatus_Id = act.FormalCaseStatus_Id; vm.Placement_Type_Id = act.Placement_Type_Id; vm.Recommendation_Type_Id = act.Recommendation_Type_Id; vm.CourtOutcome = act.CourtOutcome; vm.NextCourtDate = act.NextCourtDate; vm.RemandReason = act.RemandReason; vm.Remand = act.Remand; vm.CourtDate = act.CourtDate; if (act.Recommendation_Type_Id > 0) { vm.descrRecommendation = db.apl_Recommendation_Type.Find(act.Recommendation_Type_Id).Description; } if (act.Placement_Type_Id > 0) { vm.descrPlacement = db.apl_Placement_Type.Find(act.Placement_Type_Id).Description; } if (act.FormalCaseStatus_Id > 0) { vm.descrStatusCourt = db.apl_PCM_Court_Case_Status.Find(act.FormalCaseStatus_Id).Description; } } } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } return(vm); } }
public void AddProceeding(PCMFCRViewModel pVM, int Intake_Assessment_Id, int userId) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_FCR_Proceeding newProceeding = new PCM_FCR_Proceeding(); newProceeding.Intake_Assessment_Id = Intake_Assessment_Id; newProceeding.Formal_Court_Id = pVM.Court_Id; newProceeding.Appearance_Date = pVM.Appearance_Date; db.PCM_FCR_Proceeding.Add(newProceeding); db.SaveChanges(); PCM_FCR_Outcome newOutcome = new PCM_FCR_Outcome(); newOutcome.Intake_Assessment_Id = Intake_Assessment_Id; newOutcome.FormalCourt_Id = newProceeding.FormalCourt_Id; db.PCM_FCR_Outcome.Add(newOutcome); db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } } }