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;
}
}
}
public PCMHBSViewModel GetHBCourtOutcometById(int HB_CourtOutcome_Id)
{
PCMHBSViewModel vm = new PCMHBSViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_HB_CourtOutcome act = db.PCM_HB_CourtOutcome.Find(HB_CourtOutcome_Id);
if (act != null)
{
vm.HB_CourtOutcome_Id = act.HB_CourtOutcome_Id;
vm.Intake_Assessment_Id = act.Intake_Assessment_Id;
vm.Remand = act.Remand;
vm.Reason_Remand = act.Reason_Remand;
vm.Next_Court_Date = act.Next_Court_Date;
vm.Court_Outcome = act.Court_Outcome;
vm.HB_Case_Status_Id = act.Court_Case_Status_Id;
if (act.Court_Case_Status_Id > 0)
{
vm.HB_Case_Status = db.apl_PCM_Court_Case_Status.Find(act.Court_Case_Status_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 PCMHBSViewModel EditCourtOutCome(int HB_CourtOutcome_Id)
{
PCMHBSViewModel vm = new PCMHBSViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
//int? id = (from c in db.PCM_HB_CourtOutcome
// where (c.HB_CourtOutcome_Id == HB_CourtOutcome_Id)
// select c.HB_CourtOutcome_Id).FirstOrDefault();
PCM_HB_CourtOutcome s = db.PCM_HB_CourtOutcome.Find(HB_CourtOutcome_Id);
if (s != null)
{
vm.HB_CourtOutcome_Id = db.PCM_HB_CourtOutcome.Find(s.HB_CourtOutcome_Id).HB_CourtOutcome_Id;
vm.Intake_Assessment_Id = s.Intake_Assessment_Id;
vm.Remand = s.Remand;
vm.Reason_Remand = s.Reason_Remand;
vm.Court_Outcome = s.Court_Outcome;
vm.HB_Case_Status_Id = s.Court_Case_Status_Id;
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 UpdateCourtOutCome(PCMHBSViewModel vm, int id, int Intake_Assessment_Id)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_HB_CourtOutcome cc = db.PCM_HB_CourtOutcome.Find(id);
cc.Intake_Assessment_Id = Intake_Assessment_Id;
cc.Remand = vm.Remand;
cc.Reason_Remand = vm.Reason_Remand;
cc.Court_Outcome = vm.Court_Outcome;
cc.Court_Case_Status_Id = vm.HB_Case_Status_Id;
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
}
public void CreateCourtOutCome(PCMHBSViewModel vm, int Intake_Assessment_Id)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_HB_CourtOutcome newOutCome = new PCM_HB_CourtOutcome();
newOutCome.Intake_Assessment_Id = Intake_Assessment_Id;
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.Court_Case_Status_Id = vm.HB_Case_Status_Id;
db.PCM_HB_CourtOutcome.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 = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
