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 void UpdateHBS(PCMHBSViewModel vm, int userId, int HomeBasedSupervision_Id, int assID)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_HB_Supervision newCC = db.PCM_HB_Supervision.Find(HomeBasedSupervision_Id);
newCC.HomeBasedSupervision_Id = HomeBasedSupervision_Id;
newCC.Conditions_Id = vm.Conditions_Id;
newCC.Visitation_Period = vm.Visitation_Period;
newCC.Number_of_Visit = vm.Number_of_Visit;
newCC.Placement_Date = vm.Placement_Date;
newCC.HBS_Supervisor_Id = vm.HBS_Supervisor_Id;
newCC.Placement_Confirmed = vm.Placement_Confirmed;
db.SaveChanges();
PCM_HB_CourtOutcome exist2 = db.PCM_HB_CourtOutcome.Where(x => x.HomeBasedSupervision_Id == HomeBasedSupervision_Id).SingleOrDefault();
if (exist2 == null)
{
PCM_HB_CourtOutcome newHB = new PCM_HB_CourtOutcome();
newHB.Intake_Assessment_Id = assID;
newHB.HomeBasedSupervision_Id = vm.HomeBasedSupervision_Id;
db.PCM_HB_CourtOutcome.Add(newHB);
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;
}
}
}
/// <summary>
/// to edit PCM_HB_Supervision
/// to get HomeBasedSupervision_Id
/// </summary>
/// <param name="HomeBasedSupervision_Id"></param>
/// <returns></returns>
public PCMHBSViewModel EditHBS(int HomeBasedSupervision_Id)
{
PCMHBSViewModel vm = new PCMHBSViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
int?id = (from c in db.PCM_HB_Supervision
where (c.HomeBasedSupervision_Id == HomeBasedSupervision_Id)
select c.HomeBasedSupervision_Id).FirstOrDefault();
PCM_HB_Supervision s = db.PCM_HB_Supervision.Find(id);
if (s != null)
{
vm.HomeBasedSupervision_Id = db.PCM_HB_Supervision.Find(s.HomeBasedSupervision_Id).HomeBasedSupervision_Id;
vm.Intake_Assessment_Id = s.Intake_Assessment_Id;
vm.Compliance_Id = s.Conditions_Id;
vm.Visitation_Period = s.Visitation_Period;
vm.Number_of_Visit = s.Number_of_Visit;
vm.Placement_Date = s.Placement_Date;
vm.HBS_Supervisor_Id = s.HBS_Supervisor_Id;
vm.Placement_Confirmed = s.Placement_Confirmed;
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 CreateHBS(PCMHBSViewModel vm, int Intake_Assessment_Id)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_HB_Supervision newHB = new PCM_HB_Supervision();
newHB.Intake_Assessment_Id = Intake_Assessment_Id;
newHB.Conditions_Id = vm.Conditions_Id;
newHB.Visitation_Period = vm.Visitation_Period;
newHB.Number_of_Visit = vm.Number_of_Visit;
newHB.Placement_Date = vm.Placement_Date;
newHB.HBS_Supervisor_Id = vm.HBS_Supervisor_Id;
newHB.Placement_Confirmed = vm.Placement_Confirmed;
db.PCM_HB_Supervision.Add(newHB);
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;
}
}
}