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 List <PCMDSessionOutcomeViewModel> GetOutcomeList()
{
List <PCMDSessionOutcomeViewModel> vm = new List <PCMDSessionOutcomeViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var oList = (from o in db.PCM_D_Diversion_Outcome
select new {
o.Diversion_Outotcome_Id,
o.Intake_Assessment_Id,
o.Court_Date,
o.Remand,
o.Reason_Remand,
o.Next_Court_Date,
o.Court_Outcome,
o.Case_Status
}).ToList();
foreach (var item in oList)
{
PCMDSessionOutcomeViewModel obj = new PCMDSessionOutcomeViewModel();
obj.Diversion_Outotcome_Id = item.Diversion_Outotcome_Id;
obj.Intake_Assessment_Id = item.Intake_Assessment_Id;
obj.Court_Date = item.Court_Date;
obj.Remand = item.Remand;
obj.Reason_Remand = item.Reason_Remand;
obj.Next_Court_Date = item.Next_Court_Date;
obj.Court_Outcome = item.Court_Outcome;
obj.Case_Status = item.Case_Status;
vm.Add(obj);
}
return(vm);
}
public JsonResult CreatePCMDSO(PCMDSessionOutcomeViewModel vm)
{
//int pcmreg = 3;
var result = false;
try
{
if (vm.DSession_Id > 0)
{
//cm.GetPCMChildrensCourtEditDetails(vm.Children_Court_Id);
//cm.CreatePCMChildrensCourt(vm, pcmreg, Intake_Assessment_Id);
result = true;
}
else
{
m.CreateDSO(vm, 28377);
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
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 List <PCMDSessionOutcomeViewModel> GetDSOList()
{
List <PCMDSessionOutcomeViewModel> vm = new List <PCMDSessionOutcomeViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var DSOList = (from d in db.PCM_D_Session_Outcome
select new
{
d.DSession_Id,
d.Intake_Assessment_Id,
d.Current_Module_Attended,
d.Session_Attend,
d.Session_Date,
d.Name_of_the_Facilitator,
d.Name_of_Co_Facilitator,
d.Process_Notes,
d.Next_Session_Date,
d.Compliance
}).ToList();
foreach (var item in DSOList)
{
PCMDSessionOutcomeViewModel obj = new PCMDSessionOutcomeViewModel();
obj.DSession_Id = item.DSession_Id;
obj.Intake_Assessment_Id = item.Intake_Assessment_Id;
obj.Current_Module_Attended = item.Current_Module_Attended;
obj.Session_Attend = item.Session_Attend;
obj.Session_Date = item.Session_Date;
obj.Name_of_the_Facilitator = item.Name_of_the_Facilitator;
obj.Name_of_Co_Facilitator = item.Name_of_Co_Facilitator;
obj.Process_Notes = item.Process_Notes;
obj.Next_Session_Date = item.Next_Session_Date;
obj.Compliance = item.Compliance;
vm.Add(obj);
}
return(vm);
}
public void CreateDSO(PCMDSessionOutcomeViewModel vm, int Intake_Assessment_Id)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_D_Session_Outcome newdso = new PCM_D_Session_Outcome();
newdso.Intake_Assessment_Id = 28377;
newdso.Current_Module_Attended = vm.Current_Module_Attended;
newdso.Session_Attend = vm.Session_Attend;
newdso.Session_Date = vm.Session_Date;
newdso.Name_of_the_Facilitator = vm.Name_of_the_Facilitator;
newdso.Name_of_Co_Facilitator = vm.Name_of_Co_Facilitator;
newdso.Process_Notes = vm.Process_Notes;
newdso.Next_Session_Date = vm.Next_Session_Date;
newdso.Compliance = vm.Compliance;
db.PCM_D_Session_Outcome.Add(newdso);
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 JsonResult CreateOutcome(PCMDSessionOutcomeViewModel vm)
{
var result = false;
int Intake_Assessment_Id = 28377;
try
{
if (vm.Diversion_Outotcome_Id > 0)
{
result = true;
}
else
{
m.CreateOutcome(vm, Intake_Assessment_Id);
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
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;
}
}
}
