public int?GetPlacementId(int IntakeAssessmentId)
{
PCMPreliminaryViewModel vm = new PCMPreliminaryViewModel();
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
var prem = db.PCM_Preliminary_Details.Where(o => o.Intake_Assessment_Id == IntakeAssessmentId);
int?xID = prem.FirstOrDefault().Placement_Pre_Recommended_Id;
return(xID);
}
}
public List <PCMPreliminaryViewModel> GetOffence()
{
List <PCMPreliminaryViewModel> vm = new List <PCMPreliminaryViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var oList = (from OL in db.PCM_Offence_Details
join OC in db.Offence_Categories
on OL.Offence_Category_Id equals OC.Offence_Category_Id
join CD in db.PCM_Case_Details
on OL.PCM_Case_Id equals CD.PCM_Case_Id
join c in db.Courts
on CD.Court_id equals c.Court_Id
select new
{
OL.PCM_Offence_Id,
OL.PCM_Case_Id,
OL.Intake_Assessment_Id,
OL.Offence_Category_Id,
//OL.Charge_Id,
OL.Offence_Circumstance,
OL.Value_Of_Goods,
OL.Value_Recovered,
OL.IsChild_Responsible,
OL.Responsibility_Details,
//OC.Description,
OC.Source,
OC.Definition,
CD.Date_Arrested,
CD.Investigate_Officer_Name,
CD.Court_id,
c.Description
}).ToList();
foreach (var item in oList)
{
PCMPreliminaryViewModel objO = new PCMPreliminaryViewModel();
objO.PCM_Offence_Id = item.PCM_Offence_Id;
objO.PCM_Case_Id = item.PCM_Case_Id;
objO.Intake_Assessment_Id = item.Intake_Assessment_Id;
objO.Date_Arrested = item.Date_Arrested;
objO.Investigate_Officer_Name = item.Investigate_Officer_Name;
objO.Description = item.Description;
vm.Add(objO);
}
return(vm);
}
//Method for Updating Employee record
public void Add(PCMPreliminaryViewModel vm, int userId, int assID)
{
using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities())
{
try
{
PCM_Preliminary_Details newPre = new PCM_Preliminary_Details();
newPre.Intake_Assessment_Id = assID;
newPre.PCM_Preliminary_Status_Id = vm.PCM_Preliminary_Status_Id;
newPre.PreInquiryConducted = vm.PreInquiryConducted;
newPre.ReasonPreInquiryConducted = vm.ReasonPreInquiryConducted;
newPre.PCM_Preliminary_Date = vm.PCM_Preliminary_Date;
newPre.PCM_Outcome_Reason = vm.PCM_Outcome_Reason;
newPre.PCM_Offence_Id = vm.PCM_Offence_Id;
newPre.PCM_Recommendation_Id = vm.PCM_Recommendation_Id;
newPre.Modified_By = userId;
newPre.Date_Modified = DateTime.Now;
newPre.Modified_By = userId;
newPre.Date_Created = DateTime.Now;
db.PCM_Preliminary_Details.Add(newPre);
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;
}
}
}
//string cs = "data source=.;initial catalog=SDIIS_Database_Tes;Integrated Security=True";
public List <PCMPreliminaryViewModel> gridList()
{
List <PCMPreliminaryViewModel> pvm = new List <PCMPreliminaryViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var pList = (from d in db.PCM_Preliminary_Details
join s in db.PCM_Preliminary_Status
on d.PCM_Preliminary_Status_Id equals s.Preliminary_Status_Id
join r in db.PCM_Preliminary_Recommendation
on d.PCM_Recommendation_Id equals r.PCM_Recommendation_Id
//where (pcmPre.Client_Id == 27890)
select new
{
d.PCM_Preliminary_Id,
d.PCM_Case_Id,
d.Client_Id,
d.Intake_Assessment_Id,
d.PCM_Preliminary_Date,
d.PCM_Outcome_Reason,
d.PCM_Offence_Id,
d.PCM_Recommendation_Id,
r.Recommendation,
s.Preliminary_Status_Id,
s.Preliminary_Status
}).ToList();
foreach (var item in pList)
{
PCMPreliminaryViewModel pre = new PCMPreliminaryViewModel();
pre.PCM_Preliminary_Id = item.PCM_Preliminary_Id;
pre.PCM_Case_Id = item.PCM_Case_Id;
pre.Client_Id = item.Client_Id;
pre.Intake_Assessment_Id = item.Intake_Assessment_Id;
pre.PCM_Outcome_Reason = item.PCM_Outcome_Reason;
pre.PCM_Offence_Id = item.PCM_Offence_Id;
pre.PCM_Recommendation_Id = item.PCM_Recommendation_Id;
pre.PCM_Preliminary_Status_Id = item.Preliminary_Status_Id;
pre.Preliminary_Status = item.Preliminary_Status;
pre.Recommendation = item.Recommendation;
pvm.Add(pre);
}
return(pvm);
}
public PCMPreliminaryViewModel Display(int id)
{
PCMPreliminaryViewModel vm = new PCMPreliminaryViewModel();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var pdata = db.PCM_Preliminary_Details.Find(id);
// Updated by Yanga...........................
if (pdata.Intake_Assessment_Id != null)
{
vm.Intake_Assessment_Id = pdata.Intake_Assessment_Id;
}
if (pdata.PCM_Preliminary_Date != null)
{
vm.PCM_Preliminary_Date = pdata.PCM_Preliminary_Date;
}
if (pdata.PCM_Preliminary_Status_Id != null)
{
vm.Preliminary_Status_Id = pdata.PCM_Preliminary_Status_Id;
}
if (pdata.PCM_Outcome_Reason != null)
{
vm.PCM_Outcome_Reason = pdata.PCM_Outcome_Reason;
}
if (pdata.PCM_Recommendation_Id != null)
{
vm.PCM_Recommendation_Id = pdata.PCM_Recommendation_Id;
}
if (pdata.Placement_Pre_Recommended_Id != null)
{
vm.Placement_Type_Id = pdata.Placement_Pre_Recommended_Id;
}
return(vm);
}
public List <PCMPreliminaryViewModel> GetRecommendation()
{
List <PCMPreliminaryViewModel> vm = new List <PCMPreliminaryViewModel>();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
var rRec = (from r in db.PCM_Recommendation
join o in db.PCM_Orders
on r.Recommendation_Id equals o.Recommendation_Id
join p in db.PCM_Placement
on r.Recommendation_Id equals p.Recommendation_Id
select new
{
r.Recommendation_Id,
r.Recommendation_Type_Id,
r.Placement_Type_Id,
r.Comments_For_Recommendation,
r.Intake_Assessment_Id,
o.Recomendation_Order_Id,
p.Person_Id,
p.Type_Of_Center_Id,
p.Facility_Id,
}).ToList();
foreach (var item in rRec)
{
PCMPreliminaryViewModel pvm = new PCMPreliminaryViewModel();
pvm.Recommendation_Id = item.Recommendation_Id;
pvm.Recommendation_Type_Id = item.Recommendation_Type_Id;
pvm.Placement_Type_Id = item.Placement_Type_Id;
pvm.Comments_For_Recommendation = item.Comments_For_Recommendation;
pvm.Intake_Assessment_Id = item.Intake_Assessment_Id;
pvm.Recomendation_Order_Id = item.Recomendation_Order_Id;
pvm.Person_Id = item.Person_Id;
pvm.Type_Of_Center_Id = item.Type_Of_Center_Id;
pvm.Facility_Id = item.Facility_Id;
vm.Add(pvm);
}
return(vm);
}
public ActionResult addPreliminary(PCMPreliminaryViewModel vm, 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;
}
}
int assID = Convert.ToInt32(Session["IntakeassId"]);
if (assID > 0)
{
int PcmPreliID = preModel.GetPCMPreliminaryIdDetailsByssId(assID);
if (PcmPreliID > 0)
{
preModel.Update(vm, userId, PcmPreliID, assID);
}
}
return(RedirectToAction("Home", "PCMPreliminary", new { Id = assID }));
}
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 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;
}
}
string ClientRef = Convert.ToString(Session["ClientRef"]);
ViewBag.ModuleRef = ClientRef;
var StatusType = preModel.GetStatusType();
var RecommendationType = preModel.GetRecommendationType();
int PcmPreliID = preModel.GetPCMPreliminaryIdDetailsByssId(Id);
if (PcmPreliID != 0)
{
pVM = preModel.Display(PcmPreliID);
pVM.Status_Type = preModel.GetStatusType();
pVM.Recommendation_Type = preModel.GetRecommendationType();
pVM.PlacementRecomendation_List = preModel.GetPlacementRecomendation();
pVM.PreliminaryStatus_List = preModel.GetPreliminaryStatus();
return(PartialView(pVM));
}
else
{
pVM.Status_Type = preModel.GetStatusType();
pVM.Recommendation_Type = preModel.GetRecommendationType();
pVM.PlacementRecomendation_List = preModel.GetPlacementRecomendation();
pVM.PreliminaryStatus_List = preModel.GetPreliminaryStatus();
preModel.Add(pVM, userId, Id);
Session["Idc1"] = Id;
Session["IntakeassId"] = Id;
return(PartialView(pVM));
}
}