public ActionResult AcceptPCMEndPointCase(PCMSocialWorkerEndpointCasesVM update, string id)
{
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = -1;
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;
}
}
// Accetp Case Allocated
int End_Point_POD_Id = Convert.ToInt32(id);
var _db = new SDIIS_DatabaseEntities();
var list = new PCMSocialWorkerEndpointCasesVM();
PCMWorkListModel model = new PCMWorkListModel();
//Call update function..................................................................................................................
model.UpdatePCMEndpointWorkListCase(update, End_Point_POD_Id, userId);
return(RedirectToAction("Index", "Home", new { End_Point_POD_Id = End_Point_POD_Id }));
}
public ActionResult Index()
{
var _db = new SDIIS_DatabaseEntities();
PCMMainPageWorklistModelVM vm = new PCMMainPageWorklistModelVM();
PCMWorkListModel model = new PCMWorkListModel();
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;
}
}
#region LOAD NEW CASES FROM INTAKE
// Check for new case from intake and Insert
model.CheckPCMAssementExistance();
#endregion
//Get all the cases assigned to the loggedinuser.
List <Intake_Assessment> intakeAssesments = _db.Intake_Assessments.Where(x => x.Case_Manager_Id == userId).ToList();
//Get User worklist for the logged user
List <PCMSocialWorkerWorkListVM> Worklist = model.PCMGetUserWorkList(userId);
List <PCMCaseGridMain> PCMOldworkList = model.GetPCMWorkList();
List <PCMSocialWorkerWorkListVM> newWorklist = model.GetPCMUserNewWorkList(userId);
List <PCMSocialWorkerEndpointCasesVM> newAllocatedCaseslist = model.GetNewEndpointAlloctedCasesList(userId);
// All new work list assigned to user
vm.PCMNewCasez = newWorklist;
vm.PCMEndPointAllocatedCasez = newAllocatedCaseslist;
//All the cases currently assigned and working on
vm.PCMCurrentCases = Worklist;
//All the adoption cases completed
vm.PCMClients_Case_List = PCMOldworkList;
return(View(vm));
}
public ActionResult PCMSearch()
{
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = -1;
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;
}
}
// get client list
var caseViewModel = new PCMCaseListViewModel {
Client_List = new List <Client>(), PCMClients_Case_List = new List <PCMCaseGridMain>()
};
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
if (userProvince == -1)
{
// Logged In User is not assigned to a province, what should happen here?
}
else
{
var intakeAssessmentModel = new IntakeAssessmentModel();
var assessments = intakeAssessmentModel.GetListOfPCMIntakeAssessments(userProvince, userId);
PCMWorkListModel model = new PCMWorkListModel();
var clientAssessments = model.GetListOfPersonsPCM();
var clientItems = clientAssessments.Select(x => new PCMCaseGridMain()
{
PersonId = x.Person_Id,
FirstName = x.First_Name,
LastName = x.Last_Name,
IDNumber = x.Identification_Number,
AssessmentCount = x.Clients.Any() ? x.Clients.First().Intake_Assessments.Count : 0,
PCMNestedItems = !x.Clients.Any() ? new List <PCMCaseGridNested>() : x.Clients.First().Intake_Assessments.Select(y => new PCMCaseGridNested()
{
PersonId = x.Person_Id,
AssessmentId = y.Intake_Assessment_Id,
AssessmentDate = y.Assessment_Date,
POName = db.Users.Find(y.Assessed_By_Id).Last_Name
}).ToList()
}).ToList();
caseViewModel.PCMClients_Case_List.AddRange(clientItems);
}
return(PartialView(caseViewModel));
}
public ActionResult AcceptPCMCase(PCMSocialWorkerWorkListVM update, string id)
{
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = -1;
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;
}
}
// Accetp Case Allocated
int assessmentId = Convert.ToInt32(id);
var _db = new SDIIS_DatabaseEntities();
var currentCasesCount = _db.PCM_Case_Details.Count();
var nextSeqNumber = currentCasesCount + 1;
var assessment = _db.Intake_Assessments.Where(x => x.Intake_Assessment_Id == assessmentId).FirstOrDefault();
var list = new PCMSocialWorkerWorkListVM();
PCMWorkListModel model = new PCMWorkListModel();
var IntAss = model.GetAssessment(assessmentId);
//Call update function..................................................................................................................
model.UpdatePCMWorkListCase(update, assessmentId);
return(RedirectToAction("Index", "Home", new { assessmentId = assessmentId }));
}
public ActionResult PCMSearch(PCMCaseListViewModel caseViewModel)
{
var currentUser = (User)Session["CurrentUser"];
var userProvince = -1;
var userId = -1;
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;
}
}
caseViewModel.PCMClients_Case_List = new List <PCMCaseGridMain>();
if (userProvince == -1)
{
// Logged In User is not assigned to a province, what should happen here?
}
else
{
var intakeAssessmentModel = new IntakeAssessmentModel();
var assessments = intakeAssessmentModel.GetListOfPCMIntakeAssessments(userProvince, userId);
PCMWorkListModel model = new PCMWorkListModel();
SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities();
//var clientAssessments = model.GetListOfPersonsPCM();
var persons = model.GetListOfPersonsPCM();
//var query = from c in clientAssessments select c;
var query1 = from p in persons select p;
if (!string.IsNullOrEmpty(caseViewModel.Search_First_Name))
{
query1 = query1.Where(p => p.First_Name.ToLower().Contains(caseViewModel.Search_First_Name.ToLower()));
}
if (!string.IsNullOrEmpty(caseViewModel.Search_Last_Name))
{
query1 = query1.Where(p => p.Last_Name.ToLower().Contains(caseViewModel.Search_Last_Name.ToLower()));
}
if (!string.IsNullOrEmpty(caseViewModel.Search_ID_Number))
{
query1 = query1.Where(p => p.Identification_Number.Contains(caseViewModel.Search_ID_Number));
}
var filteredResults = query1.ToList();
var clientItems = filteredResults.Select(x => new PCMCaseGridMain()
{
PersonId = x.Person_Id,
FirstName = x.First_Name,
LastName = x.Last_Name,
IDNumber = x.Identification_Number,
AssessmentCount = x.Clients.Any() ? x.Clients.First().Intake_Assessments.Count : 0,
PCMNestedItems = !x.Clients.Any() ? new List <PCMCaseGridNested>() : x.Clients.First().Intake_Assessments.Select(y => new PCMCaseGridNested()
{
PersonId = x.Person_Id,
AssessmentId = y.Intake_Assessment_Id,
AssessmentDate = y.Assessment_Date,
POName = db.Users.Find(y.Assessed_By_Id).Last_Name
}).ToList()
}).ToList().Distinct();
caseViewModel.PCMClients_Case_List.AddRange(clientItems);
}
return(PartialView(caseViewModel));
}
