public void UpdateHBS(PCMHBSViewModel vm, int userId, int HomeBasedSupervision_Id, int assID) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_HB_Supervision newCC = db.PCM_HB_Supervision.Find(HomeBasedSupervision_Id); newCC.HomeBasedSupervision_Id = HomeBasedSupervision_Id; newCC.Conditions_Id = vm.Conditions_Id; newCC.Visitation_Period = vm.Visitation_Period; newCC.Number_of_Visit = vm.Number_of_Visit; newCC.Placement_Date = vm.Placement_Date; newCC.HBS_Supervisor_Id = vm.HBS_Supervisor_Id; newCC.Placement_Confirmed = vm.Placement_Confirmed; db.SaveChanges(); PCM_HB_CourtOutcome exist2 = db.PCM_HB_CourtOutcome.Where(x => x.HomeBasedSupervision_Id == HomeBasedSupervision_Id).SingleOrDefault(); if (exist2 == null) { PCM_HB_CourtOutcome newHB = new PCM_HB_CourtOutcome(); newHB.Intake_Assessment_Id = assID; newHB.HomeBasedSupervision_Id = vm.HomeBasedSupervision_Id; db.PCM_HB_CourtOutcome.Add(newHB); 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; } } }
public PCMHBSViewModel GetHBCourtOutcometById(int HB_CourtOutcome_Id) { PCMHBSViewModel vm = new PCMHBSViewModel(); using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_HB_CourtOutcome act = db.PCM_HB_CourtOutcome.Find(HB_CourtOutcome_Id); if (act != null) { vm.HB_CourtOutcome_Id = act.HB_CourtOutcome_Id; vm.Intake_Assessment_Id = act.Intake_Assessment_Id; vm.Remand = act.Remand; vm.Reason_Remand = act.Reason_Remand; vm.Next_Court_Date = act.Next_Court_Date; vm.Court_Outcome = act.Court_Outcome; vm.HB_Case_Status_Id = act.Court_Case_Status_Id; if (act.Court_Case_Status_Id > 0) { vm.HB_Case_Status = db.apl_PCM_Court_Case_Status.Find(act.Court_Case_Status_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 PCMHBSViewModel EditCourtOutCome(int HB_CourtOutcome_Id) { PCMHBSViewModel vm = new PCMHBSViewModel(); using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { //int? id = (from c in db.PCM_HB_CourtOutcome // where (c.HB_CourtOutcome_Id == HB_CourtOutcome_Id) // select c.HB_CourtOutcome_Id).FirstOrDefault(); PCM_HB_CourtOutcome s = db.PCM_HB_CourtOutcome.Find(HB_CourtOutcome_Id); if (s != null) { vm.HB_CourtOutcome_Id = db.PCM_HB_CourtOutcome.Find(s.HB_CourtOutcome_Id).HB_CourtOutcome_Id; vm.Intake_Assessment_Id = s.Intake_Assessment_Id; vm.Remand = s.Remand; vm.Reason_Remand = s.Reason_Remand; vm.Court_Outcome = s.Court_Outcome; vm.HB_Case_Status_Id = s.Court_Case_Status_Id; 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; } } return(vm); }
public void UpdateCourtOutCome(PCMHBSViewModel vm, int id, int Intake_Assessment_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_HB_CourtOutcome cc = db.PCM_HB_CourtOutcome.Find(id); cc.Intake_Assessment_Id = Intake_Assessment_Id; cc.Remand = vm.Remand; cc.Reason_Remand = vm.Reason_Remand; cc.Court_Outcome = vm.Court_Outcome; cc.Court_Case_Status_Id = vm.HB_Case_Status_Id; db.SaveChanges(); } catch (Exception ex) { throw ex; } } }
public void CreateCourtOutCome(PCMHBSViewModel vm, int Intake_Assessment_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_HB_CourtOutcome newOutCome = new PCM_HB_CourtOutcome(); newOutCome.Intake_Assessment_Id = Intake_Assessment_Id; newOutCome.Remand = vm.Remand; newOutCome.Reason_Remand = vm.Reason_Remand; newOutCome.Next_Court_Date = vm.Next_Court_Date; newOutCome.Court_Outcome = vm.Court_Outcome; newOutCome.Court_Case_Status_Id = vm.HB_Case_Status_Id; db.PCM_HB_CourtOutcome.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 = new InvalidOperationException(message, raise); } } throw raise; } } }