public PCMPresentenceDetailsViewModel GetPresentenseList(int Presentence_Id) { PCMPresentenceDetailsViewModel fvm = new PCMPresentenceDetailsViewModel(); using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Presentence_Details act = db.PCM_Presentence_Details.Find(Presentence_Id); fvm.Presentence_Id = act.Presentence_Id; fvm.Court_id = act.Referral_Court_Id; fvm.Date_Request_Received = act.Date_Request_Received; fvm.Court_Appearance_Date = act.Court_Appearance_Date; fvm.Date_Report_Submitted_To_Court = act.Date_Report_Submitted_To_Court; fvm.Reasons_For_Non_Submission = act.Reasons_For_Non_Submission; fvm.Sentencing_Options = act.Sentencing_Options; fvm.Community_Based_Options_Id = act.Community_Based_Options_Id; fvm.Restorective_Justice_Option_Id = act.Restorective_Justice_Option_Id; fvm.Programme_Type_Id = act.Programme_Type_Id; fvm.Programme_Id = act.Programme_Id; fvm.Fine_or_Alternatives_To_Fine = act.Fine_or_Alternatives_To_Fine ?? false; fvm.Fine_Alternatives_Fine_Comments = act.Fine_Alternatives_Fine_Comments; fvm.Suspended_Postponed_Sentence_Id = act.Suspended_Postponed_Sentence_Id; fvm.Commital_Treatment_Centre = act.Commital_Treatment_Centre ?? false; fvm.Center_Name = act.Center_Name; fvm.CYCCCenter_Name = act.Center_Name_CYCC; fvm.Period_Commital_Treatment_Centre_From = act.Period_Commital_Treatment_Centre_From; fvm.Period_Commital_Treatment_Centre_To = act.Period_Commital_Treatment_Centre_To; fvm.Compulsory_esidence_CYCC = act.Compulsory_esidence_CYCC ?? false; fvm.Compulsory_esidence_CYCC_From = act.Compulsory_esidence_CYCC_From; fvm.Compulsory_esidence_CYCC_To = act.Compulsory_esidence_CYCC_To; fvm.Imprisoment = act.Imprisoment ?? false; fvm.Imprisoment_Id = act.Imprisoment_Id; fvm.Imprisomen_From = act.Imprisomen_From; fvm.Imprisomen_To = act.Imprisomen_To; fvm.Department_Id = act.Department_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(fvm); } }
public void UpdatePresentence(PCMPresentenceDetailsViewModel cases, int userId, int Summary_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Presentence_Details editCase = db.PCM_Presentence_Details.Find(Summary_Id); if (Summary_Id > 0) { editCase.Referral_Court_Id = cases.Court_id; editCase.Date_Request_Received = cases.Date_Request_Received; editCase.Court_Appearance_Date = cases.Court_Appearance_Date; editCase.Date_Report_Submitted_To_Court = cases.Date_Report_Submitted_To_Court; editCase.Reasons_For_Non_Submission = cases.Reasons_For_Non_Submission; editCase.Sentencing_Options = cases.Sentencing_Options; editCase.Community_Based_Options_Id = cases.Community_Based_Options_Id; editCase.Restorective_Justice_Option_Id = cases.Restorective_Justice_Option_Id; editCase.Programme_Type_Id = cases.Programme_Type_Id; editCase.Programme_Id = cases.Programme_Id; editCase.Fine_or_Alternatives_To_Fine = cases.Fine_or_Alternatives_To_Fine; editCase.Fine_Alternatives_Fine_Comments = cases.Fine_Alternatives_Fine_Comments; editCase.Suspended_Postponed_Sentence_Id = cases.Suspended_Postponed_Sentence_Id; editCase.Commital_Treatment_Centre = cases.Commital_Treatment_Centre; editCase.Center_Name = cases.Center_Name; editCase.Center_Name_CYCC = cases.CYCCCenter_Name; editCase.Period_Commital_Treatment_Centre_From = cases.Period_Commital_Treatment_Centre_From; editCase.Period_Commital_Treatment_Centre_To = cases.Period_Commital_Treatment_Centre_To; editCase.Compulsory_esidence_CYCC = cases.Compulsory_esidence_CYCC; editCase.Compulsory_esidence_CYCC_From = cases.Compulsory_esidence_CYCC_From; editCase.Compulsory_esidence_CYCC_To = cases.Compulsory_esidence_CYCC_To; editCase.Imprisoment = cases.Imprisoment; editCase.Imprisoment_Id = cases.Imprisoment_Id; editCase.Imprisomen_From = cases.Imprisomen_From; editCase.Imprisomen_To = cases.Imprisomen_To; editCase.Department_Id = cases.Department_Id; editCase.Date_Modified = DateTime.Now; editCase.Modified_By = userId; } 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; } } }