public List <Module> GetListOfModules(bool showInActive, bool showDeleted) { List <Module> modules; var dbContext = new SDIIS_DatabaseEntities(); try { var modulesList = (from m in dbContext.Modules where m.Is_Active.Equals(true) || m.Is_Active.Equals(!showInActive) where m.Is_Deleted.Equals(false) || m.Is_Deleted.Equals(showDeleted) select m).ToList(); modules = (from module in modulesList select module).ToList(); } catch (Exception) { return(null); } return(modules); }
public Module GetSpecificModule(int moduleId) { Module module; var dbContext = new SDIIS_DatabaseEntities(); try { var moduleItems = (from m in dbContext.Modules where m.Module_Id.Equals(moduleId) select m).ToList(); // Set Additional properties module = (from m in moduleItems select m).FirstOrDefault(); } catch (Exception) { module = null; } return(module); }
public Menu GetSpecificMenu(int menuId) { Menu menu; var dbContext = new SDIIS_DatabaseEntities(); try { var menusList = (from m in dbContext.Menus where m.Menu_Id.Equals(menuId) && m.Is_Active == true select m).ToList(); menu = (from m in menusList select m).FirstOrDefault(); } catch (Exception ex) { string e = ex.Message; return(null); } return(menu); }
public SAPS_Official CreateSAPSOfficial(string firstName, string lastName) { var dbContext = new SDIIS_DatabaseEntities(); var sapsOfficial = new SAPS_Official() { First_Name = firstName, Last_Name = lastName }; try { var newSAPSOfficial = dbContext.SAPS_Officials.Add(sapsOfficial); dbContext.SaveChanges(); return(newSAPSOfficial); } catch (Exception) { return(null); } }
public CYCAChildAllocationViewModel GetCareWorkerByVenueId(int venueId) { CYCAChildAllocationViewModel vm = new CYCAChildAllocationViewModel(); using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { CYCA_Team_Allocation act = db.CYCA_Team_Allocation.Find(venueId); if (act != null) { vm.Team_Allocation_Id = act.Team_Allocation_Id; vm.Venue_Id = act.Venue_Id; vm.CareWorker_Name = db.Users.Find(act.Reporting_User).First_Name + " " + db.Users.Find(act.Reporting_User).Last_Name; vm.Start_Date = act.Start_Date.ToString("dd/MM/yyyy"); } } 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 void CreateDiversion_M(PCMDiversionViewModel vm) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Diversion_M m = new PCM_Diversion_M(); m.P_Id = vm.P_Id; m.Modules_Id = vm.Modules_Id; m.No_Module = vm.No_Module; m.Sessions = vm.Sessions; m.No_Sessions = vm.No_Sessions; m.Session_StartDate = vm.Session_StartDate; m.Session_EndDate = vm.Session_EndDate; db.PCM_Diversion_M.Add(m); 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 Reception_Register EditReceptionRegister(int receptionRegisterId, int?personId, string reasonForVisit, int?receptionVisitTypeId, DateTime?visitDate, int?receptionActionTakenId, DateTime dateLastModified, string modifiedBy, bool isActive, bool isDeleted) { Reception_Register editReceptionRegister; using (var dbContext = new SDIIS_DatabaseEntities()) { try { editReceptionRegister = (from r in dbContext.Reception_Registers where r.Reception_Register_Id.Equals(receptionRegisterId) select r).FirstOrDefault(); if (editReceptionRegister == null) { return(null); } editReceptionRegister.Person_Id = personId; editReceptionRegister.Reason_For_Visit = reasonForVisit; editReceptionRegister.Reception_Visit_Type_Id = receptionVisitTypeId; editReceptionRegister.Visit_Date = visitDate; editReceptionRegister.Reception_Action_Taken_Id = receptionActionTakenId; editReceptionRegister.Date_Last_Modified = dateLastModified; editReceptionRegister.Modified_By = modifiedBy; editReceptionRegister.Is_Active = isActive; editReceptionRegister.Is_Deleted = isDeleted; dbContext.SaveChanges(); } catch (Exception) { return(null); } } return(editReceptionRegister); }
//public PCMPretrailViewModel Update(int PCM_Pretrial_Id) //{ // PCMPretrailViewModel vm = new PCMPretrailViewModel(); // using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) // { // try // { // //int? id = (from c in db.PCM_Pretrial_Details // // where (c.PCM_Pretrial_Id == PCM_Pretrial_Id) // // select c.PCM_Pretrial_Id).FirstOrDefault(); // PCM_Pretrial_Details p = db.PCM_Pretrial_Details.Find(id); // if(p != null) // { // vm.PCM_Pretrial_Id = db.PCM_Pretrial_Details.Find(p.PCM_Pretrial_Id).PCM_Pretrial_Id; // vm.PCM_Case_Id = p.PCM_Case_Id; // vm.PCM_Pretrial_Date = p.PCM_Pretrial_Date; // vm.PCM_Court_Outcome_Id = p.PCM_Court_Outcome_Id; // vm.PCM_Commemts = vm.PCM_Commemts; // //vm.Created_By = DateTime.Now; // vm.Date_Created = DateTime.Now; ; // vm.Modified_By = p.Modified_By; // 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; // } // } // return vm; //} public void View(PCMPretrailViewModel vm, int userId, int PCM_Pretrial_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Pretrial_Details p = db.PCM_Pretrial_Details.Find(PCM_Pretrial_Id); vm.PCM_Case_Id = p.PCM_Case_Id; vm.PCM_Pretrial_Date = p.PCM_Pretrial_Date; vm.PCM_Court_Outcome_Id = p.PCM_Court_Outcome_Id; vm.PCM_Commemts = vm.PCM_Commemts; vm.Date_Created = DateTime.Now;; vm.Modified_By = p.Modified_By; 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 Profiling_Tool CreateProfilingTool(int profilingToolTypeId, string name, string version, string description, int?ownerOrganizationId, int?contactPersonId, DateTime?introductionDate, bool isDeprecated, DateTime?deprecationDate, bool isActive, bool isDeleted, DateTime dateCreated, string createdBy) { Profiling_Tool newProfilingTool; var dbContext = new SDIIS_DatabaseEntities(); var profilingTool = new Profiling_Tool() { Profiling_Tool_Type_Id = profilingToolTypeId, Name = name, Version = version, Description = description, Owner_Organization_Id = ownerOrganizationId, Contact_Person_id = contactPersonId, Introduction_Date = introductionDate, IsDeprecated = isDeprecated, Deprecation_Date = deprecationDate, Is_Active = isActive, Is_Deleted = isDeleted, Date_Created = dateCreated, Created_By = createdBy }; try { newProfilingTool = dbContext.Profiling_Tools.Add(profilingTool); dbContext.SaveChanges(); } catch (Exception ex) { return(null); } return(newProfilingTool); }
public void AddOutcome(PCMFCRViewModel pVM, int Intake_Assessment_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_FCR_Outcome newOutcome = new PCM_FCR_Outcome(); newOutcome.Intake_Assessment_Id = Intake_Assessment_Id; newOutcome.CourtDate = pVM.CourtDate; newOutcome.Remand = pVM.Remand; newOutcome.RemandReason = pVM.RemandReason; newOutcome.NextCourtDate = pVM.NextCourtDate; newOutcome.CourtOutcome = pVM.CourtOutcome; newOutcome.FormalCaseStatus_Id = pVM.FormalCaseStatus_Id; db.PCM_FCR_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 List <IntakeDataViewModel> GetListOfFacilityInventory(int Id) { List <IntakeDataViewModel> avm = new List <IntakeDataViewModel>(); SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities(); var ListP = ( (from pf in db.CYCA_PersonalAndFacilityInventory join p in db.Persons on pf.Person_Id equals p.Person_Id join it in db.apl_Cyca_Inventory_Type on pf.Inventory_Type_Id equals it.Inventory_Type_Id join r in db.apl_Cyca_Inventory_Return_Status on pf.Return_Status_Id equals r.Return_Status_Id where p.Person_Id == Id && pf.Inventory_Type_Id == 2 select new { pf.Inventory_Id, it.Inventory_Type_Id, r.Return_Status_Id }).ToList()); ; foreach (var item in ListP) { IntakeDataViewModel obj = new IntakeDataViewModel(); obj.Inventory_Id = item.Inventory_Id; obj.selectedInventoryType = db.apl_Cyca_Inventory_Type.Find(item.Inventory_Type_Id).Description; obj.Item_Color = db.CYCA_PersonalAndFacilityInventory.Find(item.Inventory_Id).Item_Color; obj.Item_Type = db.CYCA_PersonalAndFacilityInventory.Find(item.Inventory_Id).Item_Type; obj.Item_Quantity = db.CYCA_PersonalAndFacilityInventory.Find(item.Inventory_Id).Item_Quantity.ToString(); obj.Item_Description = db.CYCA_PersonalAndFacilityInventory.Find(item.Inventory_Id).Item_Description; obj.Return_Status_Id = item.Return_Status_Id; obj.selectedReturnStatus = db.apl_Cyca_Inventory_Return_Status.Find(item.Return_Status_Id).Description; obj.Date_Handed_In = db.CYCA_PersonalAndFacilityInventory.Find(item.Inventory_Id).Date_Handed_In; obj.Date_Returned = db.CYCA_PersonalAndFacilityInventory.Find(item.Inventory_Id).Date_Returned; obj.Reason_Not_Returned = db.CYCA_PersonalAndFacilityInventory.Find(item.Inventory_Id).Reason_Not_Returned; avm.Add(obj); } return(avm); }
public void ReturnInventory(IntakeDataViewModel vm, int Inventory_Id, int userId) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { CYCA_PersonalAndFacilityInventory edit = db.CYCA_PersonalAndFacilityInventory.Find(Inventory_Id); edit.Return_Status_Id = vm.Return_Status_Id; edit.Quantity_Returned = Convert.ToInt32(vm.Quantity_Returned); edit.Date_Returned = Convert.ToDateTime(vm.Date_Returnedd); edit.Returned_By = vm.Returned_By; edit.Reason_Not_Returned = vm.Reason_Not_Returned; edit.Date_Last_Modified = DateTime.Now; edit.Modified_By = userId; 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> 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 void CreateOutcome(PCMDSessionOutcomeViewModel vm, int Intake_Assessment_Id) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_D_Diversion_Outcome newOutcome = new PCM_D_Diversion_Outcome(); newOutcome.Intake_Assessment_Id = Intake_Assessment_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.Case_Status = vm.Case_Status; db.PCM_D_Diversion_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 int Create(int selected_abuseIndicatorId, int Unsuitability_Id, string userName) { var dbContext = new SDIIS_DatabaseEntities(); try { var abuseIndicatorRecord = new CPR_Unsuitability_Incident_Abuse_Indicator(); abuseIndicatorRecord.CPR_Unsuitability_Id = Unsuitability_Id; abuseIndicatorRecord.Abuse_Indicator_Id = selected_abuseIndicatorId; abuseIndicatorRecord.CreatedTimeStamp = DateTime.Now; abuseIndicatorRecord.Created_By = (from a in dbContext.Users where a.User_Name == userName select a.User_Id).FirstOrDefault(); dbContext.CPR_Unsuitability_Incident_Abuse_Indicator.Add(abuseIndicatorRecord); dbContext.SaveChanges(); return(abuseIndicatorRecord.CPR_Unsuitability_Incident_Abuse_Indicator_Id); } //catch (Exception ex) //{ // return -1; //} catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { //Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); var msg = validationError.PropertyName + " Error: " + validationError.ErrorMessage; } } } return(-1); }
public Person_Education EditPersonEducation(int personEducationId, int schoolId, int?gradeCompletedId, string yearCompleted, DateTime?dateLastAttended, string additionalInformation, DateTime dateLastModified, string modifiedBy, bool isActive, bool isDeleted) { Person_Education editPersonEducation; using (var dbContext = new SDIIS_DatabaseEntities()) { try { editPersonEducation = (from p in dbContext.Person_Education_Entities where p.Person_Education_Id.Equals(personEducationId) select p).FirstOrDefault(); if (editPersonEducation == null) { return(null); } editPersonEducation.School_Id = schoolId; editPersonEducation.Grade_Completed_Id = gradeCompletedId; editPersonEducation.Year_Completed = yearCompleted; editPersonEducation.Date_Last_Attended = dateLastAttended; editPersonEducation.Additional_Information = additionalInformation; editPersonEducation.Date_Last_Modified = dateLastModified; editPersonEducation.Modified_By = modifiedBy; editPersonEducation.Is_Active = isActive; editPersonEducation.Is_Deleted = isDeleted; dbContext.SaveChanges(); } catch (Exception) { return(null); } } return(editPersonEducation); }
public List <Profiling_Instance> GetListOfProfilingInstances(int provinceId) { List <Profiling_Instance> profilingInstances; var dbContext = new SDIIS_DatabaseEntities(); try { var profilingInstancesList = (from x in dbContext.Profiling_Instances where x.Is_Active.Equals(true) where x.Is_Deleted.Equals(false) where x.NISIS_Site_EA.NISIS_Site.Ward.Local_Municipality.District.Province_Id.Equals(provinceId) select x).ToList(); profilingInstances = (from x in profilingInstancesList select x).ToList(); } catch (Exception ex) { return(null); } return(profilingInstances); }
public List <NISIS_Ward> GetListOfNisisWards(bool showInActive, bool showDeleted, int localMunicipalityId) { List <NISIS_Ward> nisisWards; var dbContext = new SDIIS_DatabaseEntities(); try { var nisisWardList = (from x in dbContext.NISIS_Wards where x.Is_Active.Equals(true) || x.Is_Active.Equals(!showInActive) where x.Is_Deleted.Equals(false) || x.Is_Deleted.Equals(showDeleted) where x.Local_Municipality_Id.Equals(localMunicipalityId) select x).ToList(); nisisWards = (from x in nisisWardList select x).ToList(); } catch (Exception ex) { return(null); } return(nisisWards); }
public List <Town> GetListOfTowns(int localMunicipalityId) { List <Town> towns; using (var dbContext = new SDIIS_DatabaseEntities()) { try { var townList = (from r in dbContext.Towns where r.Local_Municipality_Id.Equals(localMunicipalityId) orderby r.Description select r).ToList(); towns = (from r in townList select r).ToList(); } catch (Exception) { return(null); } } return(towns); }
public List <CPR_Unsuitability_Forum> GetListOfForums(int ForumNumber) { List <CPR_Unsuitability_Forum> forums; using (var dbContext = new SDIIS_DatabaseEntities()) { try { var forumList = (from r in dbContext.CPR_Unsuitability_Forum where r.Forum_Id.Equals(ForumNumber) orderby r.Forum_Name select r).ToList(); forums = (from r in forumList select r).ToList(); } catch (Exception) { return(null); } } return(forums); }
public List <CPR_Unsuitability_Incident_Abuse_Indicator> GetListOfAbuseIndicatorsForCPR(int unsuitability_ID) { List <CPR_Unsuitability_Incident_Abuse_Indicator> abuseIndicators; using (var dbContext = new SDIIS_DatabaseEntities()) { try { var abuseIndicatorList = (from r in dbContext.CPR_Unsuitability_Incident_Abuse_Indicator where r.CPR_Unsuitability_Id == unsuitability_ID select r).ToList(); abuseIndicators = (from r in abuseIndicatorList select r).ToList(); } catch (Exception ex) { var Test = ex.Message; return(null); } } return(abuseIndicators); }
public List <Abuse_Indicator> GetListOfAbuseIndicators(int primaryAbuseTypeId) { List <Abuse_Indicator> abuseIndicators; using (var dbContext = new SDIIS_DatabaseEntities()) { try { var abuseIndicatorList = (from r in dbContext.Abuse_Indicators where r.Abuse_Type_Id == primaryAbuseTypeId select r).ToList(); abuseIndicators = (from r in abuseIndicatorList select r).ToList(); } catch (Exception ex) { var Test = ex.Message; return(null); } } return(abuseIndicators); }
public List <NISIS_Site> GetListOfNisisSites(bool showInActive, bool showDeleted, int nisisWardId) { List <NISIS_Site> nisisSites; var dbContext = new SDIIS_DatabaseEntities(); try { var nisisSiteList = (from x in dbContext.NISIS_Sites where x.Is_Active.Equals(true) || x.Is_Active.Equals(!showInActive) where x.Is_Deleted.Equals(false) || x.Is_Deleted.Equals(showDeleted) where x.NISIS_Ward_Id.Equals(nisisWardId) select x).ToList(); nisisSites = (from x in nisisSiteList select x).ToList(); } catch (Exception ex) { return(null); } return(nisisSites); }
public Person_Employment EditPersonEmployment(int personEmploymentId, int?natureOfEmploymentId, string occupation, int?incomeRangeId, DateTime dateLastModified, string modifiedBy, bool isActive, bool isDeleted, string NameOfEmployer) { Person_Employment editPersonEmployment; using (var dbContext = new SDIIS_DatabaseEntities()) { try { editPersonEmployment = (from p in dbContext.Person_Employment_Entities where p.Person_Employment_Id.Equals(personEmploymentId) select p).FirstOrDefault(); if (editPersonEmployment == null) { return(null); } editPersonEmployment.NameOfEmployer = NameOfEmployer; editPersonEmployment.Nature_Of_Employment_Id = natureOfEmploymentId; editPersonEmployment.Occupation = occupation; editPersonEmployment.Income_Range_Id = incomeRangeId; editPersonEmployment.Date_Last_Modified = dateLastModified; editPersonEmployment.Modified_By = modifiedBy; editPersonEmployment.Is_Active = isActive; editPersonEmployment.Is_Deleted = isDeleted; dbContext.SaveChanges(); } catch (Exception) { return(null); } } return(editPersonEmployment); }
public Reception_Visit_Type GetSpecificReceptionVisitType(int receptionVisitTypeId) { Reception_Visit_Type receptionVisitType; var dbContext = new SDIIS_DatabaseEntities(); try { var receptionVisitTypeItems = (from r in dbContext.Reception_Visit_Types where r.Reception_Visit_Type_Id.Equals(receptionVisitTypeId) select r).ToList(); //agent = PopulateAdditionalItems(agents, dbContext).FirstOrDefault(); receptionVisitType = (from r in receptionVisitTypeItems select r).FirstOrDefault(); } catch (Exception ex) { return(null); } return(receptionVisitType); }
public List <Social_Worker> GetListOfSocialWorkers(bool showInActive, bool showDeleted, int serviceOfficeId) { List <Social_Worker> listOfSocialWorkers; var dbContext = new SDIIS_DatabaseEntities(); try { var employees = (from e in dbContext.Social_Workers where e.Is_Active || e.Is_Active.Equals(!showInActive) where !e.Is_Deleted || e.Is_Deleted.Equals(showDeleted) where e.Service_Office_Id.Equals(serviceOfficeId) select e).ToList(); listOfSocialWorkers = (from e in employees select e).ToList(); } catch (Exception ex) { return(null); } return(listOfSocialWorkers); }
public List <Questionnaire_Question> GetListOfQuestionnaireQuestions(bool showInActive, bool showDeleted, int sectionId) { List <Questionnaire_Question> questionnaireQuestions; var dbContext = new SDIIS_DatabaseEntities(); try { var questionnaireQuestionList = (from x in dbContext.Questionnaire_Questions where x.Is_Active.Equals(true) || x.Is_Active.Equals(!showInActive) where x.Is_Deleted.Equals(false) || x.Is_Deleted.Equals(showDeleted) where x.Questionnaire_Section_Id.Equals(sectionId) select x).ToList(); questionnaireQuestions = (from x in questionnaireQuestionList select x).ToList(); } catch (Exception) { return(null); } return(questionnaireQuestions); }
public List <Profiling_Instance> GetListOfProfilingInstances(bool showInActive, bool showDeleted, int capturedByUserId) { List <Profiling_Instance> profilingInstances; var dbContext = new SDIIS_DatabaseEntities(); try { var profilingInstancesList = (from x in dbContext.Profiling_Instances where x.Is_Active.Equals(true) || x.Is_Active.Equals(!showInActive) where x.Is_Deleted.Equals(false) || x.Is_Deleted.Equals(showDeleted) where x.Captured_By_UserId.Equals(capturedByUserId) select x).ToList(); profilingInstances = (from x in profilingInstancesList select x).ToList(); } catch (Exception ex) { return(null); } return(profilingInstances); }
public Person_Education GetSpecificPersonEducation(int personEducationId) { Person_Education personEducation; var dbContext = new SDIIS_DatabaseEntities(); try { var personEducationItems = (from p in dbContext.Person_Education_Entities where p.Person_Education_Id.Equals(personEducationId) select p).ToList(); //agent = PopulateAdditionalItems(agents, dbContext).FirstOrDefault(); personEducation = (from p in personEducationItems select p).FirstOrDefault(); } catch (Exception ex) { return(null); } return(personEducation); }
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 })); }