public JsonResult CreatePCMFormalCourt(PCMChildrensCourtViewModel vm)
{
PCMFormalCourtRecommendationModel fm = new PCMFormalCourtRecommendationModel();
var result = false;
int pcmreg = 3;
int userId = 5;
try
{
if (vm.PCM_Formal_Court_Recomm_Id > 0)
{
fm.GetPCMFormalCourtEditDetails(vm.PCM_Formal_Court_Recomm_Id);
result = true;
}
else
{
fm.CreatePCMFormalCourt(vm, pcmreg, userId);
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public PCMChildrensCourtViewModel GetChildrensCourtOutcometById(int CourtId)
{
PCMChildrensCourtViewModel vm = new PCMChildrensCourtViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Childrens_Court_Outcome act = db.PCM_Childrens_Court_Outcome.Find(CourtId);
if (act != null)
{
vm.Outcome_Id = act.Outcome_Id;
vm.Court_Case_Status_Id = act.Court_Case_Status_Id;
vm.Placement_Type_Id = act.Placement_Type_Id;
vm.Recommendation_Type_Id = act.Recommendation_Type_Id;
vm.Court_Outcome = act.Court_Outcome;
vm.Intake_Assessment_Id = act.Intake_Assessment_Id;
vm.Next_Court_Date = act.Next_Court_Date;
vm.Reason_Remand = act.Reason_Remand;
vm.Remand = act.Remand;
vm.Court_Date = act.Court_Date;
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.Court_Case_Status_Id > 0)
{
vm.descrStatusCourt = 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 JsonResult CreatePCMCourtOutcome(PCMChildrensCourtViewModel 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;
}
}
PCMChildrensCourtModel cm = new PCMChildrensCourtModel();
int RecomendationID = Convert.ToInt32(Session["Rec1"]);
int PlacementID = Convert.ToInt32(Session["Placementid"]);
int assID = Convert.ToInt32(Session["IntakeassId"]);
var result = false;
try
{
if (vm.Outcome_Id > 0)
{
cm.CreatePCMChildrensCourtOutcome(vm, RecomendationID, vm.Outcome_Id, assID);
result = true;
result = true;
}
else
{
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public void CreatePCMChildrensCourt(PCMChildrensCourtViewModel vm, int RecomendationID, int Intake_Assessment_Id)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Childrens_Court newCC = new PCM_Childrens_Court();
newCC.PCM_Recommendation_Id = RecomendationID;
newCC.Intake_Assessment_Id = Intake_Assessment_Id;
newCC.Court_Expiry_Date = vm.Court_Expiry_Date;
newCC.Prelim_Enquiry_Date = vm.Prelim_Enquiry_Date;
newCC.Child_Need_Care = vm.Child_Need_Care;
newCC.Substance_Abuse_Treat = vm.Substance_Abuse_Treat;
//newCC.Substance_Abuse_Treat = subAbuseTreat;
newCC.Referral_Date = vm.Referral_Date;
newCC.Alternative_Placement = vm.Alternative_Placement;
newCC.Case_Manager = vm.Case_Manager;
newCC.Service_Provider = vm.Service_Provider;
db.PCM_Childrens_Court.Add(newCC);
db.SaveChanges();
PCM_Childrens_Court_Outcome newOutcome = new PCM_Childrens_Court_Outcome();
newOutcome.Outcome_Id = vm.Outcome_Id;
newOutcome.Intake_Assessment_Id = Intake_Assessment_Id;
newOutcome.Children_Court_Id = newCC.Children_Court_Id;
db.PCM_Childrens_Court_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;
}
}
}
public JsonResult GetPCMCourtOutcomeById(int 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;
}
}
PCMChildrensCourtModel cm = new PCMChildrensCourtModel();
PCMChildrensCourtViewModel vm = new PCMChildrensCourtViewModel();
vm.PlacementRecomendation_List = cm.GetPlacementRecomendation();
vm.Recommendation_Type_List = cm.GetRecommendationType();
vm.CourtOutcomeCaseStatusation_Type = cm.GetCourtOutcomeCaseStatusType();
ViewBag.Recommendation_Type_List = new SelectList(db.apl_Recommendation_Type.ToList(), "Recommendation_Type_Id", "Description");
ViewBag.PlacementRecomendation_List = new SelectList(db.apl_Placement_Type.ToList(), "Placement_Type_Id", "Description");
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 = cm.GetChildrensCourtOutcometById(Outcome_Id);
string value = string.Empty;
value = JsonConvert.SerializeObject(vm, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(value, JsonRequestBehavior.AllowGet));
}
}
public PCMChildrensCourtViewModel GetCCOutComeByID(int Outcome_Id)
{
PCMChildrensCourtViewModel vm = new PCMChildrensCourtViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
int?id = (from c in db.PCM_Childrens_Court_Outcome
where (c.Intake_Assessment_Id == Outcome_Id)
select c.Intake_Assessment_Id).FirstOrDefault();
PCM_Childrens_Court_Outcome cc = db.PCM_Childrens_Court_Outcome.Find(id);
if (cc != null)
{
vm.Intake_Assessment_Id = db.PCM_Childrens_Court_Outcome.Find(cc.Intake_Assessment_Id).Intake_Assessment_Id;
vm.Outcome_Id = cc.Outcome_Id;
vm.Intake_Assessment_Id = cc.Intake_Assessment_Id;
//vm.barcode = ass.barcode;
//vm.serial = ass.serial;
//vm.reason = ass.reason;
//vm.official = ass.official;
//vm.datereceived = ass.datereceived;
//vm.datereturned = ass.datereturned;
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 PCMChildrensCourtViewModel GetPCMChildrensCourtEditDetails(int ChildrenCourtId)
{
PCMChildrensCourtViewModel vm = new PCMChildrensCourtViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
int?id = (from c in db.PCM_Childrens_Court
where (c.Children_Court_Id == ChildrenCourtId)
select c.Children_Court_Id).FirstOrDefault();
PCM_Childrens_Court cc = db.PCM_Childrens_Court.Find(id);
if (cc != null)
{
vm.Children_Court_Id = db.PCM_Childrens_Court.Find(cc.Children_Court_Id).Children_Court_Id;
vm.PCM_Recommendation_Id = cc.PCM_Recommendation_Id;
vm.Court_Expiry_Date = cc.Court_Expiry_Date;
vm.Prelim_Enquiry_Date = cc.Prelim_Enquiry_Date;
vm.Child_Need_Care = cc.Child_Need_Care;
vm.Substance_Abuse_Treat = cc.Substance_Abuse_Treat;
vm.Referral_Date = cc.Referral_Date;
vm.Intake_Assessment_Id = cc.Intake_Assessment_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 PCMChildrensCourtViewModel GetPCMFormalCourtEditDetails(int FormalCourtRecommId)
{
PCMChildrensCourtViewModel vm = new PCMChildrensCourtViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
int?id = (from c in db.PCM_Formal_Court_Recommendation
where (c.PCM_Formal_Court_Recomm_Id == FormalCourtRecommId)
select c.PCM_Formal_Court_Recomm_Id).FirstOrDefault();
PCM_Formal_Court_Recommendation fc = db.PCM_Formal_Court_Recommendation.Find(id);
if (fc != null)
{
vm.PCM_Formal_Court_Recomm_Id = db.PCM_Formal_Court_Recommendation.Find(fc.PCM_Formal_Court_Recomm_Id).PCM_Formal_Court_Recomm_Id;
vm.PCM_Recommendation_Id = fc.PCM_Recommendation_Id;
vm.Type_Of_Center_Id = fc.Type_Of_Center_Id;
vm.Type_Of_Placement_Id = fc.Type_Of_Placement_Id;
vm.Personal_Details_Id = fc.Personal_Details_Id;
vm.Facility_Id = fc.Facility_Id;
vm.Date_Modified = fc.Date_Modified;
vm.Modified_By = fc.Modified_By;
vm.Date_Created = fc.Date_Created;
vm.Withdrawal_Status = vm.Withdrawal_Status;
}
}
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 PCMChildrensCourtViewModel GetCCDetails(int Id)
{
PCMChildrensCourtViewModel vm = new PCMChildrensCourtViewModel();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
//var cc = db.PCM_Childrens_Court.Find(Id);
PCM_Childrens_Court model = db.PCM_Childrens_Court.Where(x => x.Intake_Assessment_Id == Id).SingleOrDefault();
vm.Children_Court_Id = model.Children_Court_Id;
vm.Court_Expiry_Date = model.Court_Expiry_Date;
vm.Prelim_Enquiry_Date = model.Prelim_Enquiry_Date;
//vm.Child_Need_Care = model.Child_Need_Care;
vm.Alternative_Placement = model.Alternative_Placement;
//vm.kidAddress = gd.kidAddress;
return(vm);
}
public List <PCMChildrensCourtViewModel> GetOutcometList(int assID)
{
List <PCMChildrensCourtViewModel> cVM = new List <PCMChildrensCourtViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var cList = (from cc in db.PCM_Childrens_Court
join outc in db.PCM_Childrens_Court_Outcome
on cc.Children_Court_Id equals outc.Children_Court_Id
where cc.Intake_Assessment_Id == assID
select new
{
outc.Outcome_Id,
outc.Court_Date,
outc.Remand,
outc.Reason_Remand,
outc.Next_Court_Date,
outc.Court_Outcome,
outc.Intake_Assessment_Id,
outc.Children_Court_Id
}).ToList();
foreach (var item in cList)
{
PCMChildrensCourtViewModel objR = new PCMChildrensCourtViewModel();
objR.Outcome_Id = item.Outcome_Id;
objR.Court_Date = item.Court_Date;
objR.Remand = item.Remand;
objR.Reason_Remand = item.Reason_Remand;
objR.Next_Court_Date = item.Next_Court_Date;
objR.Court_Outcome = item.Court_Outcome;
objR.Intake_Assessment_Id = item.Intake_Assessment_Id;
objR.Court_Expiry_Date = db.PCM_Childrens_Court.Find(item.Children_Court_Id).Court_Expiry_Date;
objR.Children_Court_Id = Convert.ToInt32(item.Children_Court_Id);
cVM.Add(objR);
}
return(cVM);
}
public void UpdatePCMChildrensCourt(PCMChildrensCourtViewModel vm, int Children_Court_Id, int userid)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Childrens_Court newCC = db.PCM_Childrens_Court.Find(Children_Court_Id);
newCC.Court_Expiry_Date = vm.Court_Expiry_Date;
newCC.Prelim_Enquiry_Date = vm.Prelim_Enquiry_Date;
newCC.Child_Need_Care = vm.Child_Need_Care;
newCC.Substance_Abuse_Treat = vm.Substance_Abuse_Treat;
newCC.Referral_Date = vm.Referral_Date;
newCC.Alternative_Placement = vm.Alternative_Placement;
newCC.Case_Manager = vm.Case_Manager;
newCC.Service_Provider = vm.Service_Provider;
vm.Modified_By = userid;
vm.Date_Modified = DateTime.Now;
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 CreatePCMCC(PCMChildrensCourtViewModel 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 RecomendationID = Convert.ToInt32(Session["Rec1"]);;
int assID = Convert.ToInt32(Session["IntakeassId"]);
if (vm.Children_Court_Id > 0)
{
cm.UpdatePCMChildrensCourt(vm, vm.Children_Court_Id, userId);
}
else
{
cm.CreatePCMChildrensCourt(vm, RecomendationID, assID);
}
return(RedirectToAction("Home", "PCMPreliminary", new { Id = assID }));
}
public void CreatePCMFormalCourt(PCMChildrensCourtViewModel vm, int PcmReg, int userId)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Formal_Court_Recommendation newFC = new PCM_Formal_Court_Recommendation();
newFC.PCM_Recommendation_Id = PcmReg;
newFC.Type_Of_Center_Id = vm.Type_Of_Center_Id;
newFC.Type_Of_Placement_Id = vm.Type_Of_Placement_Id;
newFC.Personal_Details_Id = vm.Personal_Details_Id;
newFC.Facility_Id = vm.Facility_Id;
newFC.Created_By = userId;
newFC.Date_Modified = DateTime.Now;
newFC.Modified_By = userId;
newFC.Date_Created = DateTime.Now;
newFC.Withdrawal_Status = vm.Withdrawal_Status;
db.PCM_Formal_Court_Recommendation.Add(newFC);
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 GetOutcometList()
{
//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"]);
PCMChildrensCourtModel cm = new PCMChildrensCourtModel();
PCMChildrensCourtViewModel vm = new PCMChildrensCourtViewModel();
vm.PlacementRecomendation_List = cm.GetPlacementRecomendation();
vm.Recommendation_Type_List = cm.GetRecommendationType();
vm.CourtOutcomeCaseStatusation_Type = cm.GetCourtOutcomeCaseStatusType();
ViewBag.Recommendation_Type_List = new SelectList(db.apl_Recommendation_Type.ToList(), "Recommendation_Type_Id", "Description");
ViewBag.PlacementRecomendation_List = new SelectList(db.apl_Placement_Type.ToList(), "Placement_Type_Id", "Description");
ViewBag.CourtOutcomeCaseStatusation_Type = new SelectList(db.apl_PCM_Court_Case_Status.ToList(), "Court_Case_Status_Id", "Description");
return(Json(cm.GetOutcometList(assID), JsonRequestBehavior.AllowGet));
}
public List <PCMChildrensCourtViewModel> GetPCMChildrensCourtList()
{
List <PCMChildrensCourtViewModel> cVM = new List <PCMChildrensCourtViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var cList = (from cc in db.PCM_Childrens_Court
select new { cc.Children_Court_Id, cc.PCM_Recommendation_Id, cc.Court_Expiry_Date, cc.Prelim_Enquiry_Date }).ToList();
foreach (var item in cList)
{
PCMChildrensCourtViewModel objR = new PCMChildrensCourtViewModel();
objR.Children_Court_Id = item.Children_Court_Id;
objR.PCM_Recommendation_Id = item.PCM_Recommendation_Id;
objR.Court_Expiry_Date = item.Court_Expiry_Date;
objR.Prelim_Enquiry_Date = item.Prelim_Enquiry_Date;
cVM.Add(objR);
}
return(cVM);
}
public List <PCMChildrensCourtViewModel> GetPCMFormalCourtRecommendationList()
{
List <PCMChildrensCourtViewModel> fVM = new List <PCMChildrensCourtViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var fList = (from fc in db.PCM_Formal_Court_Recommendation
select new { fc.PCM_Formal_Court_Recomm_Id, fc.PCM_Recommendation_Id, fc.Type_Of_Center_Id, fc.Type_Of_Placement_Id }).ToList();
foreach (var item in fList)
{
PCMChildrensCourtViewModel objR = new PCMChildrensCourtViewModel();
objR.PCM_Formal_Court_Recomm_Id = item.PCM_Formal_Court_Recomm_Id;
objR.PCM_Recommendation_Id = item.PCM_Recommendation_Id;
objR.Type_Of_Center_Id = item.Type_Of_Center_Id;
objR.Type_Of_Placement_Id = item.Type_Of_Placement_Id;
fVM.Add(objR);
}
return(fVM);
}
public List <PCMChildrensCourtViewModel> GetPCMChildrensOutcometList()
{
List <PCMChildrensCourtViewModel> vm = new List <PCMChildrensCourtViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var outcomeList = (from co in db.PCM_Childrens_Court_Outcome
select new { co.Outcome_Id, co.Children_Court_Id, co.Court_Date, co.Remand, co.Next_Court_Date, co.Court_Outcome, co.Court_Case_Status_Id }).ToList();
foreach (var item in outcomeList)
{
PCMChildrensCourtViewModel objR = new PCMChildrensCourtViewModel();
objR.Outcome_Id = item.Outcome_Id;
//objR.Children_Court_Id = item.Children_Court_Id;
objR.Court_Date = item.Court_Date;
objR.Remand = item.Remand;
objR.Next_Court_Date = item.Next_Court_Date;
objR.Court_Outcome = item.Court_Outcome;
vm.Add(objR);
}
return(vm);
}
public List <PCMChildrensCourtViewModel> GetCourtList(int Intake_Assessment_Id)
{
List <PCMChildrensCourtViewModel> cVM = new List <PCMChildrensCourtViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var cList = (from cc in db.PCM_Childrens_Court
select new
{
cc.Children_Court_Id,
cc.Court_Expiry_Date,
cc.Child_Need_Care,
cc.Referral_Date,
cc.Service_Provider,
cc.Substance_Abuse_Treat,
cc.Intake_Assessment_Id,
cc.Alternative_Placement
}).ToList();
foreach (var item in cList)
{
PCMChildrensCourtViewModel objR = new PCMChildrensCourtViewModel();
objR.Children_Court_Id = item.Children_Court_Id;
objR.Court_Expiry_Date = item.Court_Expiry_Date;
objR.Child_Need_Care = item.Child_Need_Care;
objR.Referral_Date = item.Referral_Date;
objR.Service_Provider = item.Service_Provider;
objR.Intake_Assessment_Id = item.Intake_Assessment_Id;
objR.Substance_Abuse_Treat = item.Substance_Abuse_Treat;
objR.Alternative_Placement = item.Alternative_Placement;
cVM.Add(objR);
}
return(cVM);
}
public ActionResult Index(int 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;
}
}
bool IdExist = db.PCM_Childrens_Court.Any(x => x.Intake_Assessment_Id == id);
if (IdExist)
{
PCMChildrensCourtModel cm = new PCMChildrensCourtModel();
PCMChildrensCourtViewModel vm = new PCMChildrensCourtViewModel();
vm.PlacementRecomendation_List = cm.GetPlacementRecomendation();
vm.Recommendation_Type_List = cm.GetRecommendationType();
vm.CourtOutcomeCaseStatusation_Type = cm.GetCourtOutcomeCaseStatusType();
ViewBag.Recommendation_Type_List = new SelectList(db.apl_Recommendation_Type.ToList(), "Recommendation_Type_Id", "Description");
ViewBag.PlacementRecomendation_List = new SelectList(db.apl_Placement_Type.ToList(), "Placement_Type_Id", "Description");
ViewBag.CourtOutcomeCaseStatusation_Type = new SelectList(db.apl_PCM_Court_Case_Status.ToList(), "Court_Case_Status_Id", "Description");
List <PCMChildrensCourtViewModel> vm1 = new List <PCMChildrensCourtViewModel>();
vm1 = cm.GetPCMChildrensOutcometList();
}
else
{
PCMChildrensCourtModel cm = new PCMChildrensCourtModel();
PCMChildrensCourtViewModel vm = new PCMChildrensCourtViewModel();
vm.PlacementRecomendation_List = cm.GetPlacementRecomendation();
vm.Recommendation_Type_List = cm.GetRecommendationType();
vm.CourtOutcomeCaseStatusation_Type = cm.GetCourtOutcomeCaseStatusType();
ViewBag.Recommendation_Type_List = new SelectList(db.apl_Recommendation_Type.ToList(), "Recommendation_Type_Id", "Description");
ViewBag.PlacementRecomendation_List = new SelectList(db.apl_Placement_Type.ToList(), "Placement_Type_Id", "Description");
ViewBag.CourtOutcomeCaseStatusation_Type = new SelectList(db.apl_PCM_Court_Case_Status.ToList(), "Court_Case_Status_Id", "Description");
Response.Write("Does not Exist");
}
int?Placementid = cm.GetPlacementId(id);
int?Recomendationid = cm.GetRecomendationId(id);
ViewBag.MessagePlacement = Placementid;
Session["Placementid"] = Placementid;
Session["Rec1"] = Recomendationid;
Session["Idc1"] = id;
Session["IntakeassId"] = id;
return(PartialView(vm));
}
//private SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
public ActionResult Index(int id)
{
vm = cm.GetCCOutComeByID(id);
return(PartialView(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;
}
}
}
