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;
}
}
}
