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 }));
}
