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