public PCMSocialWorkerWorkListVM CheckPCMAssementExistance() { // initializing view model PCMSocialWorkerWorkListVM newCase = new PCMSocialWorkerWorkListVM(); // initialise connection using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { //Check assessment from intake assessment not in Adoption work list var List = (from List1 in db.Intake_Assessments where !(from List2 in db.PCM_WorkList select List2.Intake_Assessment_Id).Contains(List1.Intake_Assessment_Id) where List1.Problem_Sub_Category_Id == 22 select List1).ToList(); //ADOPT_Case_WorkList act = db.ADOPT_Case_WorkList.Find(worlistid); foreach (var item in List) { if (List != null) { //insert values not in Work list for List PCM_WorkList act = new PCM_WorkList(); act.Intake_Assessment_Id = item.Intake_Assessment_Id; act.Allocated_By = item.Assessed_By_Id; act.PCM_Record_Status_Id = 1; act.Manager = item.Case_Manager_Id; act.Date_Allocated = item.Date_Allocated; db.PCM_WorkList.Add(act); 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(newCase); } }
public List <PCMSocialWorkerWorkListVM> PCMGetUserWorkList(int useridlogged) { // initialising view model List <PCMSocialWorkerWorkListVM> avm = new List <PCMSocialWorkerWorkListVM>(); // initialise connection SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities(); // get work list for user logged in var workList = (from list in db.PCM_WorkList join status in db.apl_PCM_Record_Status on list.PCM_Record_Status_Id equals status.PCM_Record_Status_Id join Assessment in db.Intake_Assessments on list.Intake_Assessment_Id equals Assessment.Intake_Assessment_Id join client in db.Clients on Assessment.Client_Id equals client.Client_Id join person in db.Persons on client.Person_Id equals person.Person_Id join sub in db.Problem_Sub_Categories on Assessment.Problem_Sub_Category_Id equals sub.Problem_Sub_Category_Id where (list.Manager == useridlogged) select new { list.Intake_Assessment_Id, list.PCMCaseWoklist_Id, list.Allocated_By, list.Manager, list.Date_Allocated, list.Reference_Number, list.PCM_Record_Status_Id, list.Date_Accepted, person.First_Name, person.Last_Name, person.Identification_Number, sub.Problem_Sub_Category_Id }).ToList(); ; foreach (var item in workList) { // initialising view model PCMSocialWorkerWorkListVM obj = new PCMSocialWorkerWorkListVM(); obj.Intake_Assessment_Id = item.Intake_Assessment_Id; obj.PCMCaseWoklist_Id = item.PCMCaseWoklist_Id; obj.Allocated_By = item.Allocated_By; obj.Allocate_To = item.Manager; obj.Date_Allocated = item.Date_Allocated; obj.Reference_Number = item.Reference_Number; obj.RecordStatusDescription = db.apl_PCM_Record_Status.Find(item.PCM_Record_Status_Id).Description; obj.Date_Accepted = item.Date_Accepted; obj.FirstName = item.First_Name; obj.LastName = item.Last_Name; obj.IDNumber = item.Identification_Number; obj.ProblemSubCategoryDescription = db.Problem_Sub_Categories.Find(item.Problem_Sub_Category_Id).Description; avm.Add(obj); } return(avm); }
public void UpdatePCMWorkListCase(PCMSocialWorkerWorkListVM list, int AssId) { // initialise connection using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { // Accept New case on work list var editlist = (from i in db.PCM_WorkList where i.Intake_Assessment_Id == (AssId) select i.PCMCaseWoklist_Id).FirstOrDefault(); PCM_WorkList edit = db.PCM_WorkList.Find(editlist); edit.Intake_Assessment_Id = AssId; edit.PCM_Record_Status_Id = 2; edit.Accepted_By = list.Case_Manager_Id; edit.Date_Accepted = 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 = new InvalidOperationException(message, raise); } } throw raise; } } }
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 })); }