public ActionResult GetConditiondetails()
{
int intassid = Convert.ToInt32(Session["IntakeassId"]);
// get current username
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
PCMHBSModel assModel = new PCMHBSModel();
PCMHBSViewModel assVM = new PCMHBSViewModel();
assVM.Condition_List = assModel.GetCondition();
ViewBag.Condition_List = new SelectList(db.apl_PCM_Conditions.ToList(), "Condition_Id", "Description");
return(PartialView(assVM));
}
public List <PCMHBSViewModel> GetCourtOutComeList(int AssID)
{
List <PCMHBSViewModel> vm = new List <PCMHBSViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var OutComeList = (from a in db.PCM_HB_CourtOutcome
join b in db.PCM_HB_Supervision
on a.HomeBasedSupervision_Id equals b.HomeBasedSupervision_Id
select new
{
a.HB_CourtOutcome_Id,
a.Intake_Assessment_Id,
a.Remand,
a.Reason_Remand,
a.Court_Outcome,
b.HomeBasedSupervision_Id
}).ToList();
foreach (var item in OutComeList)
{
PCMHBSViewModel obj = new PCMHBSViewModel();
obj.HB_CourtOutcome_Id = item.HB_CourtOutcome_Id;
obj.Intake_Assessment_Id = item.Intake_Assessment_Id;
obj.Remand = item.Remand;
obj.Reason_Remand = item.Reason_Remand;
obj.Court_Outcome = item.Court_Outcome;
obj.Placement_Date = db.PCM_HB_Supervision.Find(item.HomeBasedSupervision_Id).Placement_Date;
vm.Add(obj);
}
return(vm);
}
public void CreateVO(PCMHBSViewModel vm, int Intake_Assessment_Id)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_HB_VistationOutcome newVO = new PCM_HB_VistationOutcome();
newVO.Intake_Assessment_Id = Intake_Assessment_Id;
newVO.Conatact_Number = vm.Conatact_Number;
newVO.Process_Notes = vm.Process_Notes;
newVO.Visitaion_Register = vm.Visitaion_Register;
newVO.Compliance_Id = vm.Compliance_Id;
db.PCM_HB_VistationOutcome.Add(newVO);
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;
}
}
}
public void CreatePCMConditionsDeatils(PCMHBSViewModel cases, int HomebaseId, int Condition_Id, int userId)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_HBS_Condition newCase = new PCM_HBS_Condition();
newCase.HomeBasedSupervision_Id = HomebaseId;
newCase.Condition_Id = Condition_Id;
newCase.Created_By = userId;
newCase.Date_Created = DateTime.Now;
db.PCM_HBS_Condition.Add(newCase);
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 ActionResult CreateConditions(PCMHBSViewModel vm)
{
int intassid = Convert.ToInt32(Session["IntakeassId"]);
// get current username
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
PCMHBSModel assModel = new PCMHBSModel();
PCMHBSViewModel assVM = new PCMHBSViewModel();
// get recomendation Id for insert..................
int HomebaseId = assModel.GetPCMHBByassId(intassid);
ViewBag.Error = null;
if (vm.Condition_Id != null && HomebaseId != 0)
{
var selectedItems = db.apl_PCM_Conditions.Where(p => vm.Condition_Id.Contains((p.Condition_Id))).ToList();
if (selectedItems != null)
{
foreach (var selectedItem in selectedItems)
{
int Condition_Id = selectedItem.Condition_Id;
assModel.CreatePCMConditionsDeatils(vm, HomebaseId, Condition_Id, userId);
}
}
}
else
{
ViewBag.Error = string.Format("Error you must add Home base under recommendation", DateTime.Now.ToString());
}
return(RedirectToAction("Home", "PCMHBS", new { Id = intassid }));
}
public JsonResult CreateHBS(PCMHBSViewModel vm)
{
//get current username
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
PCMHBSModel cm = new PCMHBSModel();
//int PlacementID = Convert.ToInt32(Session["Placementid"]);
int assID = Convert.ToInt32(Session["IntakeassId"]);
var result = false;
try
{
if (vm.HomeBasedSupervision_Id > 0)
{
cm.UpdateHBS(vm, userId, vm.HomeBasedSupervision_Id, assID);
result = true;
result = true;
}
else
{
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
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 JsonResult GetVOById(int HB_Visitaion_Outcome_Id)
{
//get current username
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
int assID = Convert.ToInt32(Session["IntakeassId"]);
PCM_HB_VistationOutcome model = db.PCM_HB_VistationOutcome.Where(x => x.HB_Visitaion_Outcome_Id == HB_Visitaion_Outcome_Id).SingleOrDefault();
PCMHBSModel m = new PCMHBSModel();
PCMHBSViewModel vm = new PCMHBSViewModel();
var Compliance_Type = m.GetComplianceType();
vm.Compliance_Type = m.GetComplianceType();
ViewBag.Compliance_List = new SelectList(db.apl_PCM_Compliance.ToList(), "Compliance_Id", "Description");
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
db.Configuration.LazyLoadingEnabled = false;
vm = m.GetVisitationOutcometById(HB_Visitaion_Outcome_Id);
string value = string.Empty;
value = JsonConvert.SerializeObject(vm, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(value, JsonRequestBehavior.AllowGet));
}
}
public JsonResult CreateVO(PCMHBSViewModel vm)
{
//get current username
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
int Intake_Assessment_Id = Convert.ToInt32(Session["IntakeassId"]);
var result = false;
try
{
if (vm.HB_Visitaion_Outcome_Id > 0)
{
m.EditVO(vm.HB_Visitaion_Outcome_Id);
m.UpdateVO(vm, vm.HB_Visitaion_Outcome_Id, Intake_Assessment_Id);
result = true;
}
else
{
int HomebaseId = m.GetPCMHBByassId(Intake_Assessment_Id);
m.CreateVO(vm, Intake_Assessment_Id, HomebaseId);
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <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 PCMHBSViewModel GetHBS(int Id)
{
PCMHBSViewModel pvm = new PCMHBSViewModel();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
//var gd = db.PCM_General_Details.Find(Id);
var gd = db.PCM_HB_Supervision.Find(Id);
pvm.HomeBasedSupervision_Id = gd.HomeBasedSupervision_Id;
pvm.Intake_Assessment_Id = gd.Intake_Assessment_Id;
pvm.Compliance_Id = gd.Conditions_Id;
pvm.Visitation_Period = gd.Visitation_Period;
pvm.Number_of_Visit = gd.Number_of_Visit;
pvm.Placement_Date = gd.Placement_Date;
return(pvm);
}
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 PCMHBSViewModel GetVisitationOutcometById(int VisitoutId)
{
PCMHBSViewModel vm = new PCMHBSViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_HB_VistationOutcome act = db.PCM_HB_VistationOutcome.Find(VisitoutId);
if (act != null)
{
vm.HB_Visitaion_Outcome_Id = act.HB_Visitaion_Outcome_Id;
vm.Intake_Assessment_Id = act.Intake_Assessment_Id;
vm.Conatact_Number = act.Conatact_Number;
vm.Process_Notes = act.Process_Notes;
vm.Visitaion_Register = act.Visitaion_Register;
vm.Compliance_Id = act.Compliance_Id;
if (act.Compliance_Id > 0)
{
vm.Compliance = db.apl_PCM_Compliance.Find(act.Compliance_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 EditVO(int HB_Visitaion_Outcome_Id)
{
PCMHBSViewModel vm = new PCMHBSViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
int?id = (from c in db.PCM_HB_VistationOutcome
where (c.HB_Visitaion_Outcome_Id == HB_Visitaion_Outcome_Id)
select c.HB_Visitaion_Outcome_Id).FirstOrDefault();
PCM_HB_VistationOutcome s = db.PCM_HB_VistationOutcome.Find(id);
if (s != null)
{
vm.HB_Visitaion_Outcome_Id = db.PCM_HB_VistationOutcome.Find(s.HB_Visitaion_Outcome_Id).HB_Visitaion_Outcome_Id;
vm.Intake_Assessment_Id = s.Intake_Assessment_Id;
vm.Conatact_Number = s.Conatact_Number;
vm.Process_Notes = s.Process_Notes;
vm.Visitaion_Register = s.Visitaion_Register;
vm.Compliance_Id = s.Compliance_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 JsonResult GetCourtOutComeById(int HB_CourtOutcome_Id)
{
//get current username
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
int Intake_Assessment_Id = Convert.ToInt32(Session["IntakeassId"]);
var CaseStatus_Type = m.GetCaseStatusType();
vm.CaseStatus_Type = m.GetCaseStatusType();
ViewBag.CourtOutcomeCaseStatusation_Type = new SelectList(db.apl_PCM_Court_Case_Status.ToList(), "Court_Case_Status_Id", "Description");
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
db.Configuration.LazyLoadingEnabled = false;
vm = m.GetHBCourtOutcometById(HB_CourtOutcome_Id);
string value = string.Empty;
value = JsonConvert.SerializeObject(vm, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(value, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteConditionFromTable(int id)
{
int intassid = Convert.ToInt32(Session["IntakeassId"]);
// get current username
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
PCMHBSModel assModel = new PCMHBSModel();
PCMHBSViewModel assVM = new PCMHBSViewModel();
if (id != 0)
{
try
{
assModel.DeleteConditionRecord(id);
}
catch (Exception ex)
{
//Log errror
}
}
//return "failed";
return(RedirectToAction("Index", "PCMHBS", new { Id = intassid }));
}
public void UpdateVO(PCMHBSViewModel vm, int id, int Intake_Assessment_Id)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_HB_VistationOutcome cc = db.PCM_HB_VistationOutcome.Find(id);
cc.Intake_Assessment_Id = Intake_Assessment_Id;
cc.Conatact_Number = vm.Conatact_Number;
cc.Process_Notes = vm.Process_Notes;
cc.Visitaion_Register = vm.Visitaion_Register;
cc.Compliance_Id = vm.Compliance_Id;
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
}
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 List <PCMHBSViewModel> GetHBSList(int assID)
{
List <PCMHBSViewModel> vm = new List <PCMHBSViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var hbsList = (from h in db.PCM_HB_Supervision
join courtt in db.apl_PCM_Court_Type on h.Court_Type_Id equals courtt.Court_Type_Id
where h.Intake_Assessment_Id == assID
select new
{
h.HomeBasedSupervision_Id,
h.Intake_Assessment_Id,
h.Visitation_Period,
h.Number_of_Visit,
h.Placement_Date,
h.Conditions_Id,
courtt.Court_Type_Id
}).ToList();
foreach (var item in hbsList)
{
PCMHBSViewModel obj = new PCMHBSViewModel();
obj.HomeBasedSupervision_Id = item.HomeBasedSupervision_Id;
obj.Intake_Assessment_Id = item.Intake_Assessment_Id;
obj.Visitation_Period = item.Visitation_Period;
obj.Number_of_Visit = item.Number_of_Visit;
obj.Placement_Date = item.Placement_Date;
obj.Compliance_Id = item.Conditions_Id;
obj.Court_Type = db.apl_PCM_Court_Type.Find(item.Court_Type_Id).Description;
vm.Add(obj);
}
return(vm);
}
public List <PCMHBSViewModel> GetSelectedConditionFromDB(int HomebaseId)
{
List <PCMHBSViewModel> avm = new List <PCMHBSViewModel>();
// initialise connection
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
// get work list for user logged in
var ConditionList =
(from r in db.PCM_HB_Supervision
join o in db.PCM_HBS_Condition on r.HomeBasedSupervision_Id equals
o.HomeBasedSupervision_Id
join ot in db.apl_PCM_Conditions on o.Condition_Id equals ot.Condition_Id
//join rt in db.apl_Recommendation_Type on r.Recommendation_Type_Id equals rt.Recommendation_Type_Id
where (r.HomeBasedSupervision_Id == HomebaseId)
select new
{
r.Intake_Assessment_Id,
r.HomeBasedSupervision_Id,
o.HB_Condition_Id,
ot.Condition_Id,
//rt.Recommendation_Type_Id
}).ToList();
;
foreach (var item in ConditionList)
{
// initialising view model
PCMHBSViewModel obj = new PCMHBSViewModel();
obj.HB_Condition_Id = item.HB_Condition_Id;
obj.Description_Condition = db.apl_PCM_Conditions.Find(item.Condition_Id).Description;
avm.Add(obj);
}
return(avm);
}
/// <summary>
///
/// </summary>
/// <param name="vm"></param>
/// <param name="Intake_Assessment_Id"></param>
public void CreateCondition(PCMHBSViewModel vm, int Intake_Assessment_Id)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_HBS_Condition newCondition = new PCM_HBS_Condition();
//string School_Attendance = true;
newCondition.Intake_Assessment_Id = Intake_Assessment_Id;
newCondition.School_Attendance = vm.School_Attendance;
newCondition.Family_Time = vm.Family_Time;
newCondition.Good_Behaviour = vm.Good_Behaviour;
newCondition.Reporting = vm.Reporting;
newCondition.Supervision = vm.Supervision;
db.PCM_HBS_Condition.Add(newCondition);
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;
}
}
}
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 List <PCMHBSViewModel> GetVOList(int assID)
{
List <PCMHBSViewModel> vm = new List <PCMHBSViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var hbsList = (from v in db.PCM_HB_VistationOutcome
join c in db.PCM_HB_Supervision
on v.HomeBasedSupervision_Id equals c.HomeBasedSupervision_Id
//join s in db.PCM_HB
//on h.HBS_Supervisor_Id equals s.HBS_Supervisor_Id
select new
{
v.HB_Visitaion_Outcome_Id,
v.Intake_Assessment_Id,
v.Conatact_Number,
v.Process_Notes,
v.Visitaion_Register,
v.HomeBasedSupervision_Id
}).ToList();
foreach (var item in hbsList)
{
PCMHBSViewModel obj = new PCMHBSViewModel();
obj.HB_Visitaion_Outcome_Id = item.HB_Visitaion_Outcome_Id;
obj.Intake_Assessment_Id = item.Intake_Assessment_Id;
obj.Conatact_Number = item.Conatact_Number;
obj.Process_Notes = item.Process_Notes;
obj.Visitaion_Register = item.Visitaion_Register;
obj.Placement_Date = db.PCM_HB_Supervision.Find(item.HomeBasedSupervision_Id).Placement_Date;
vm.Add(obj);
}
return(vm);
}
public ActionResult GetSelectedConditionsFromDB()
{
int intassid = Convert.ToInt32(Session["IntakeassId"]);
// get current username
string loginName = User.Identity.Name;
Session["LoginName"] = loginName;
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = 0;
if (currentUser != null)
{
userId = currentUser.User_Id;
if (currentUser.Employees.Any())
{
userProvince = currentUser.Employees.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
if (currentUser.apl_Social_Worker.Any())
{
userProvince = currentUser.apl_Social_Worker.First().apl_Service_Office.apl_Local_Municipality.District.Province_Id;
}
}
PCMHBSModel assModel = new PCMHBSModel();
PCMHBSViewModel assVM = new PCMHBSViewModel();
int HomebaseId = assModel.GetPCMHBByassId(intassid);
if (HomebaseId != 0)
{
List <PCMHBSViewModel> OurList = assModel.GetSelectedConditionFromDB(HomebaseId);
return(PartialView(OurList));
}
return(PartialView());
}
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;
}
}
}
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();
PCMHBSViewModel vmhb = new PCMHBSViewModel();
add.HomeBasedSupervision_Id = vmhb.HomeBasedSupervision_Id;
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_Recommendation_Id == 1 && exist12 == null)
{
PCM_Diversion newhomebase = new PCM_Diversion();
PCMDiversionViewModel mdiv = new PCMDiversionViewModel();
newhomebase.Diversion_Id = mdiv.Diversion_Id;
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);
}
}
