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 PCMDiversionViewModel GetDivesionFromDBDivbyId(int Diversion_Id) { PCMDiversionViewModel vm = new PCMDiversionViewModel(); using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Diversion act = db.PCM_Diversion.Find(Diversion_Id); if (act != null) { vm.Diversion_Id = act.Diversion_Id; vm.Source_Referral_Id = act.Source_Referral_Id; if (act.Source_Referral_Id > 0) { vm.RefSourcedesrciption = db.apl_PCM_Referral_Source.Find(act.Source_Referral_Id).Description; } vm.Programme_Id = act.Programme_id; if (act.Programme_id > 0) { vm.DesrciptionDivesionPrograme = db.apl_Programmes.Find(act.Programme_id).Programme_Name; } vm.No_Modules = act.No_Modules; vm.Programme_Level_Id = act.Programme_Level_Id; vm.Modified_By = act.Modified_By; vm.Date_Modified = act.Date_Modified; vm.Court_Type_Id = act.Court_Type_Id; vm.PCM_Preliminary_Id = act.PCM_Preliminary_Id; vm.Formal_Courtcome_Id = act.Formal_Courtcome_Id; vm.Childrens_Court_Outcome_Id = act.Childrens_Court_Outcome_Id; } } 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 DiversionAdd(PCMDiversionViewModel vm, int userid, int Intake_Assessment_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Diversion DiversionNew = db.PCM_Diversion.Find(Intake_Assessment_Id); if (DiversionNew != null) { DiversionNew.Intake_Assessment_Id = vm.Intake_Assessment_Id; DiversionNew.Source_Referral_Id = vm.Source_Referral; DiversionNew.Province_Id = vm.Province_Id; DiversionNew.Service_Provider_Category = vm.Service_Provider_Category; DiversionNew.Services_Provider_Id = vm.Services_Provider_Id; DiversionNew.Programme_id = vm.Programme_Id; DiversionNew.No_Modules = vm.No_Modules; DiversionNew.Programme_Level_Id = vm.Programme_Level_Id; DiversionNew.Created_By = userid; DiversionNew.Date_Created = DateTime.Now; DiversionNew.Modified_By = userid; DiversionNew.Date_Modified = DateTime.Now; 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 void PCM_Diversion_SPAddnew(PCMDiversionViewModel vm, int Intake_Assessment_Id, int userid) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Diversion _SP = new PCM_Diversion(); _SP.Intake_Assessment_Id = Intake_Assessment_Id; _SP.Source_Referral_Id = vm.Source_Referral; _SP.Programme_Level_Id = vm.Programme_Level_Id; _SP.Programme_AgeGroup_Id = vm.Programme_AgeGroup_Id; _SP.Programme_id = vm.Programme_Id; _SP.Created_By = userid; _SP.Childrens_Court_Outcome_Id = vm.Childrens_Court_Outcome_Id; _SP.PCM_Preliminary_Id = vm.PCM_Preliminary_Id; _SP.Formal_Courtcome_Id = vm.Formal_Courtcome_Id; _SP.Court_Type_Id = vm.Court_Type_Id; _SP.Diversion_Id = vm.Diversion_Id; _SP.Date_Created = DateTime.Now; _SP.Created_By = userid; db.PCM_Diversion.Add(_SP); 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 PCMPreliminaryViewModel Update(PCMPreliminaryViewModel pre, int userId, int PcmPreliID, int AssID) { PCMPreliminaryViewModel vm = new PCMPreliminaryViewModel(); using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Preliminary_Details fc = db.PCM_Preliminary_Details.Find(PcmPreliID); if (fc != null) { fc.PCM_Recommendation_Id = pre.PCM_Recommendation_Id; fc.PCM_Preliminary_Status_Id = pre.Preliminary_Status_Id; fc.Placement_Pre_Recommended_Id = pre.Placement_Type_Id; fc.PCM_Preliminary_Date = pre.PCM_Preliminary_Date; fc.PCM_Outcome_Reason = pre.PCM_Outcome_Reason; fc.Date_Modified = pre.Date_Modified; fc.Modified_By = pre.Modified_By; fc.Date_Created = pre.Date_Created; db.SaveChanges(); PCM_HB_Supervision exist1 = db.PCM_HB_Supervision.OrderByDescending(x => x.HomeBasedSupervision_Id).FirstOrDefault(x => x.PCM_Preliminary_Id == PcmPreliID); //PCM_HB_Supervision exist1 = db.PCM_HB_Supervision.Where(x => x.PCM_Preliminary_Id == PcmPreliID).SingleOrDefault(); if (fc.Placement_Pre_Recommended_Id == 187 && exist1 == null) { PCM_HB_Supervision add = new PCM_HB_Supervision(); add.PCM_Preliminary_Id = PcmPreliID; add.Intake_Assessment_Id = AssID; add.Court_Type_Id = 1; db.PCM_HB_Supervision.Add(add); db.SaveChanges(); } PCM_Diversion exist12 = db.PCM_Diversion.OrderByDescending(x => x.Diversion_Id).FirstOrDefault(x => x.PCM_Preliminary_Id == PcmPreliID); if (fc.PCM_Preliminary_Id == 1 && exist12 == null) { PCM_Diversion newhomebase = new PCM_Diversion(); newhomebase.PCM_Preliminary_Id = fc.PCM_Preliminary_Id; newhomebase.Intake_Assessment_Id = AssID; newhomebase.Court_Type_Id = 1; db.PCM_Diversion.Add(newhomebase); 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 CreatePCMChildrensCourtOutcome(PCMChildrensCourtViewModel vm, int RecomendationID, int Outcome_Id, int assID) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Childrens_Court_Outcome newOutcome = db.PCM_Childrens_Court_Outcome.Find(Outcome_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.Placement_Type_Id = vm.Type_Of_Placement_Id; newOutcome.Recommendation_Type_Id = vm.Recommendation_Type_Id; newOutcome.Court_Case_Status_Id = vm.Court_Case_Status_Id; db.SaveChanges(); PCM_HB_Supervision exist1 = db.PCM_HB_Supervision.OrderByDescending(x => x.HomeBasedSupervision_Id).FirstOrDefault(x => x.Outcome_Id == Outcome_Id); if (newOutcome.Placement_Type_Id == 187 && exist1 == null) { PCM_HB_Supervision newhomebase = new PCM_HB_Supervision(); newhomebase.Outcome_Id = newOutcome.Outcome_Id; newhomebase.Intake_Assessment_Id = assID; newhomebase.Court_Type_Id = 3; db.PCM_HB_Supervision.Add(newhomebase); db.SaveChanges(); } PCM_Diversion exist12 = db.PCM_Diversion.OrderByDescending(x => x.Diversion_Id).FirstOrDefault(x => x.Childrens_Court_Outcome_Id == Outcome_Id); if (newOutcome.Recommendation_Type_Id == 1 && exist12 == null) { PCM_Diversion newhomebase = new PCM_Diversion(); newhomebase.Childrens_Court_Outcome_Id = newOutcome.Outcome_Id; newhomebase.Intake_Assessment_Id = assID; newhomebase.Court_Type_Id = 3; db.PCM_Diversion.Add(newhomebase); 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; } } }