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 PCMFCRViewModel GetFormalCourtById(int CourtId)
{
PCMFCRViewModel vm = new PCMFCRViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_FCR_Outcome act = db.PCM_FCR_Outcome.Find(CourtId);
if (act != null)
{
vm.FormalCourtOutcome_Id = act.FormalCourtOutcome_Id;
vm.FormalCaseStatus_Id = act.FormalCaseStatus_Id;
vm.Placement_Type_Id = act.Placement_Type_Id;
vm.Recommendation_Type_Id = act.Recommendation_Type_Id;
vm.CourtOutcome = act.CourtOutcome;
vm.NextCourtDate = act.NextCourtDate;
vm.RemandReason = act.RemandReason;
vm.Remand = act.Remand;
vm.CourtDate = act.CourtDate;
if (act.Recommendation_Type_Id > 0)
{
vm.descrRecommendation = db.apl_Recommendation_Type.Find(act.Recommendation_Type_Id).Description;
}
if (act.Placement_Type_Id > 0)
{
vm.descrPlacement = db.apl_Placement_Type.Find(act.Placement_Type_Id).Description;
}
if (act.FormalCaseStatus_Id > 0)
{
vm.descrStatusCourt = db.apl_PCM_Court_Case_Status.Find(act.FormalCaseStatus_Id).Description;
}
}
}
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 AddProceeding(PCMFCRViewModel pVM, int Intake_Assessment_Id, int userId)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_FCR_Proceeding newProceeding = new PCM_FCR_Proceeding();
newProceeding.Intake_Assessment_Id = Intake_Assessment_Id;
newProceeding.Formal_Court_Id = pVM.Court_Id;
newProceeding.Appearance_Date = pVM.Appearance_Date;
db.PCM_FCR_Proceeding.Add(newProceeding);
db.SaveChanges();
PCM_FCR_Outcome newOutcome = new PCM_FCR_Outcome();
newOutcome.Intake_Assessment_Id = Intake_Assessment_Id;
newOutcome.FormalCourt_Id = newProceeding.FormalCourt_Id;
db.PCM_FCR_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;
}
}
}
