public void UpdateOutcome(PCMDSessionOutcomeViewModel vm, int Intake_Assessment_Id, int Diversion_Outotcome_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_D_Diversion_Outcome oo = db.PCM_D_Diversion_Outcome.Find(Diversion_Outotcome_Id); //cases.PCM_Case_Id = caseID; oo.Diversion_Outotcome_Id = vm.Diversion_Outotcome_Id; oo.Intake_Assessment_Id = Intake_Assessment_Id; oo.Court_Date = vm.Court_Date; oo.Remand = vm.Remand; oo.Reason_Remand = vm.Reason_Remand; oo.Next_Court_Date = vm.Next_Court_Date; oo.Court_Outcome = vm.Court_Outcome; oo.Case_Status = vm.Case_Status; db.SaveChanges(); } catch { } } }
public List <PCMDSessionOutcomeViewModel> GetOutcomeList() { List <PCMDSessionOutcomeViewModel> vm = new List <PCMDSessionOutcomeViewModel>(); SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities(); var oList = (from o in db.PCM_D_Diversion_Outcome select new { o.Diversion_Outotcome_Id, o.Intake_Assessment_Id, o.Court_Date, o.Remand, o.Reason_Remand, o.Next_Court_Date, o.Court_Outcome, o.Case_Status }).ToList(); foreach (var item in oList) { PCMDSessionOutcomeViewModel obj = new PCMDSessionOutcomeViewModel(); obj.Diversion_Outotcome_Id = item.Diversion_Outotcome_Id; obj.Intake_Assessment_Id = item.Intake_Assessment_Id; obj.Court_Date = item.Court_Date; obj.Remand = item.Remand; obj.Reason_Remand = item.Reason_Remand; obj.Next_Court_Date = item.Next_Court_Date; obj.Court_Outcome = item.Court_Outcome; obj.Case_Status = item.Case_Status; vm.Add(obj); } return(vm); }
public JsonResult CreatePCMDSO(PCMDSessionOutcomeViewModel vm) { //int pcmreg = 3; var result = false; try { if (vm.DSession_Id > 0) { //cm.GetPCMChildrensCourtEditDetails(vm.Children_Court_Id); //cm.CreatePCMChildrensCourt(vm, pcmreg, Intake_Assessment_Id); result = true; } else { m.CreateDSO(vm, 28377); result = true; } } catch (Exception ex) { throw ex; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public PCMDSessionOutcomeViewModel GetOutcomeEditDetails(int Diversion_Outotcome_Id) { PCMDSessionOutcomeViewModel vm = new PCMDSessionOutcomeViewModel(); using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { int?id = (from c in db.PCM_D_Diversion_Outcome where (c.Diversion_Outotcome_Id == Diversion_Outotcome_Id) select c.Diversion_Outotcome_Id).FirstOrDefault(); PCM_D_Diversion_Outcome o = db.PCM_D_Diversion_Outcome.Find(id); if (o != null) { vm.Diversion_Outotcome_Id = db.PCM_D_Diversion_Outcome.Find(o.Diversion_Outotcome_Id).Diversion_Outotcome_Id; vm.Intake_Assessment_Id = o.Intake_Assessment_Id; vm.Court_Date = o.Court_Date; vm.Remand = o.Remand; vm.Reason_Remand = o.Reason_Remand; vm.Next_Court_Date = o.Next_Court_Date; vm.Court_Outcome = o.Court_Outcome; vm.Case_Status = o.Case_Status; 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 List <PCMDSessionOutcomeViewModel> GetDSOList() { List <PCMDSessionOutcomeViewModel> vm = new List <PCMDSessionOutcomeViewModel>(); SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities(); var DSOList = (from d in db.PCM_D_Session_Outcome select new { d.DSession_Id, d.Intake_Assessment_Id, d.Current_Module_Attended, d.Session_Attend, d.Session_Date, d.Name_of_the_Facilitator, d.Name_of_Co_Facilitator, d.Process_Notes, d.Next_Session_Date, d.Compliance }).ToList(); foreach (var item in DSOList) { PCMDSessionOutcomeViewModel obj = new PCMDSessionOutcomeViewModel(); obj.DSession_Id = item.DSession_Id; obj.Intake_Assessment_Id = item.Intake_Assessment_Id; obj.Current_Module_Attended = item.Current_Module_Attended; obj.Session_Attend = item.Session_Attend; obj.Session_Date = item.Session_Date; obj.Name_of_the_Facilitator = item.Name_of_the_Facilitator; obj.Name_of_Co_Facilitator = item.Name_of_Co_Facilitator; obj.Process_Notes = item.Process_Notes; obj.Next_Session_Date = item.Next_Session_Date; obj.Compliance = item.Compliance; vm.Add(obj); } return(vm); }
public void CreateDSO(PCMDSessionOutcomeViewModel vm, int Intake_Assessment_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_D_Session_Outcome newdso = new PCM_D_Session_Outcome(); newdso.Intake_Assessment_Id = 28377; newdso.Current_Module_Attended = vm.Current_Module_Attended; newdso.Session_Attend = vm.Session_Attend; newdso.Session_Date = vm.Session_Date; newdso.Name_of_the_Facilitator = vm.Name_of_the_Facilitator; newdso.Name_of_Co_Facilitator = vm.Name_of_Co_Facilitator; newdso.Process_Notes = vm.Process_Notes; newdso.Next_Session_Date = vm.Next_Session_Date; newdso.Compliance = vm.Compliance; db.PCM_D_Session_Outcome.Add(newdso); 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 JsonResult CreateOutcome(PCMDSessionOutcomeViewModel vm) { var result = false; int Intake_Assessment_Id = 28377; try { if (vm.Diversion_Outotcome_Id > 0) { result = true; } else { m.CreateOutcome(vm, Intake_Assessment_Id); result = true; } } catch (Exception ex) { throw ex; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public void CreateOutcome(PCMDSessionOutcomeViewModel vm, int Intake_Assessment_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_D_Diversion_Outcome newOutcome = new PCM_D_Diversion_Outcome(); newOutcome.Intake_Assessment_Id = Intake_Assessment_Id; newOutcome.Court_Date = vm.Court_Date; 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.Case_Status = vm.Case_Status; db.PCM_D_Diversion_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; } } }