//GetRACAPParent public List <RACAP_Supporting_Document> GetListOfDocs(string receivedid) { if (receivedid == "") { int newreceivedid = Convert.ToInt32("0"); return(null); } else { int newreceivedid = Convert.ToInt32(receivedid); SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities(); RACAPCaseMatchesViewModel newObj = new RACAPCaseMatchesViewModel(); var SetOffenceList = (from p in db.Persons join k in db.Clients on p.Person_Id equals k.Person_Id join l in db.Intake_Assessments on k.Client_Id equals l.Client_Id join m in db.RACAP_Case_Details on l.Intake_Assessment_Id equals m.Intake_Assessment_Id join n in db.RACAP_Supporting_Document on m.RACAP_Case_Id equals n.RACAP_Case_Id where (p.Person_Id == newreceivedid) select n).ToList(); return(SetOffenceList); } }
public RACAPCaseMatchesViewModel GetRACAPParent(string receivedid) { if (receivedid == "") { receivedid = "0"; } int id = int.Parse(receivedid); SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities(); var person = (from a in db.Persons where a.Person_Id == id select a).FirstOrDefault(); int id2 = (from c in db.int_Client_ProspectiveAdoptiveParents join d in db.Clients on c.Client_Id equals d.Client_Id join e in db.Persons on d.Person_Id equals e.Person_Id where e.Person_Id == id select c.Person_Id).FirstOrDefault(); int?SocWorkId = (from p in db.Persons join q in db.Clients on p.Person_Id equals q.Person_Id join o in db.Intake_Assessments on q.Client_Id equals o.Client_Id join s in db.RACAP_Case_Details on o.Intake_Assessment_Id equals s.Intake_Assessment_Id join t in db.RACAP_OrgansationResponsible on s.RACAP_Case_Id equals t.RACAP_Case_Id where p.Person_Id == id select t.Social_Worker_Id).FirstOrDefault(); int?OrdRespPId = (from p in db.Persons join q in db.Clients on p.Person_Id equals q.Person_Id join o in db.Intake_Assessments on q.Client_Id equals o.Client_Id join s in db.RACAP_Case_Details on o.Intake_Assessment_Id equals s.Intake_Assessment_Id join t in db.RACAP_OrgansationResponsible on s.RACAP_Case_Id equals t.RACAP_Case_Id where p.Person_Id == id select t.Organization_Id_Parent).FirstOrDefault(); var OrgRespons = db.Organizations.Find(OrdRespPId); var PFeatures = (from i in db.Clients join j in db.Intake_Assessments on i.Client_Id equals j.Intake_Assessment_Id join k in db.Persons on i.Person_Id equals k.Person_Id join m in db.RACAP_Prospective_Parent on j.Intake_Assessment_Id equals m.Intake_Assessment_Id where k.Person_Id == id select m).FirstOrDefault(); int PID = (from a in db.Persons join b in db.Clients on a.Person_Id equals b.Person_Id join c in db.Intake_Assessments on b.Client_Id equals c.Client_Id where a.Person_Id == id select c.Intake_Assessment_Id).FirstOrDefault(); var SupDocuments = (from p in db.Persons join k in db.Clients on p.Person_Id equals k.Person_Id join l in db.Intake_Assessments on k.Client_Id equals l.Client_Id join m in db.RACAP_Case_Details on l.Intake_Assessment_Id equals m.Intake_Assessment_Id join n in db.RACAP_Supporting_Document on m.RACAP_Case_Id equals n.RACAP_Case_Id where (p.Person_Id == id) select new { n.RACAPDocumentTypeId, n.Document_Description }).ToList(); int RACAPCaseid = (from o in db.Persons join p in db.Clients on o.Person_Id equals p.Person_Id join q in db.Intake_Assessments on p.Client_Id equals q.Client_Id join r in db.RACAP_Case_Details on q.Intake_Assessment_Id equals r.Intake_Assessment_Id where p.Person_Id == id select r.RACAP_Case_Id).FirstOrDefault(); RACAPCaseMatchesViewModel newObj = new RACAPCaseMatchesViewModel(); newObj.intakeAssIdFPDV = PID; #region IdNotNull if (id != 0) { //newObj.First_Name_P1 = db.Persons.Find(id).First_Name; #region ParentOne newObj.Last_Name_P1 = db.Persons.Find(id).First_Name + " " + db.Persons.Find(id).Last_Name; if (db.Persons.Find(id).Known_As == null) { newObj.Known_As_P1 = "Not captured"; } else { newObj.Known_As_P1 = db.Persons.Find(id).Known_As; } if (db.Persons.Find(id).Identification_Number != null) { //newObj.Identity_Type_P1 = Convert.ToString(db.Persons.Find(id).Identification_Type_Id); newObj.Identity_Number_P1 = db.Persons.Find(id).Identification_Number; } else { newObj.Identity_Number_P1 = "Not captured"; } if (person.Language_Id != null) { newObj.Language_S = db.Languages.Find(db.Persons.Find(id).Language_Id).Description; } else { newObj.Language_S = "Not captured"; } if (person.Religion_Id != null) { newObj.Religion_S = db.Religions.Find(db.Persons.Find(id).Religion_Id).Description; } else { newObj.Religion_S = "Not captured"; } if (person.Population_Group_Id != null) { newObj.Race_S = db.Races.Find(db.Persons.Find(id).Population_Group_Id).Description; } else { newObj.Race_S = "Not captured"; } if (db.Persons.Find(id).Age != null) { newObj.Age_P1 = Convert.ToString(db.Persons.Find(id).Age); } else { newObj.Age_P1 = "Not captured"; } if (db.Persons.Find(id).Mobile_Phone_Number != null) { newObj.Mobile_Number_1 = Convert.ToString(db.Persons.Find(id).Mobile_Phone_Number); } else { newObj.Mobile_Number_1 = "Not captured"; } if (db.Persons.Find(id).Email_Address != null) { newObj.Email = Convert.ToString(db.Persons.Find(id).Email_Address); } else { newObj.Email = "Not captured"; } if (db.Persons.Find(id).Nationality_Id != null) { newObj.Nationality_S = db.Nationalities.Find(db.Persons.Find(id).Nationality_Id).Description; } else { newObj.Nationality_S = "Not captured"; } if (db.Persons.Find(id).Marital_Status_Id != null) { newObj.MaritalStatus_S = db.Marital_Statusses.Find(db.Persons.Find(id).Marital_Status_Id).Description; } else { newObj.MaritalStatus_S = "Not captured"; } if (db.Persons.Find(id).Religion_Id != null) { newObj.Religion_S = db.Religions.Find(db.Persons.Find(id).Religion_Id).Description; } else { newObj.Religion_S = "Not captured"; } if (db.Persons.Find(id).Gender_Id != null) { newObj.GenderS = db.Genders.Find(db.Persons.Find(id).Gender_Id).Description; } else { newObj.GenderS = "Not captured"; } int RWC = (from c in db.RACAP_Case_WorkList join d in db.Intake_Assessments on c.Intake_Assessment_Id equals d.Intake_Assessment_Id join e in db.Clients on d.Client_Id equals e.Client_Id join f in db.Persons on e.Person_Id equals f.Person_Id where f.Person_Id == id select c.RACAP_CaseWoklist_Id).FirstOrDefault(); if (RWC != 0) { newObj.RACAP_Ref_Number = db.RACAP_Case_WorkList.Find(RWC).Reference_Number; } else { newObj.RACAP_Ref_Number = "Not captured"; } if (RACAPCaseid != 0) { newObj.RecordStatus = db.apl_RACAP_Record_Status.Find(db.RACAP_Case_Details.Find(RACAPCaseid).RACAP_Record_Status_Id).Description; } else { newObj.RecordStatus = "Not captured"; } } #endregion #endregion #region id2NotNull if (id2 != 0) { if (db.Persons.Find(id).First_Name != null) { if (db.Persons.Find(id2).Last_Name != null) { newObj.Last_Name_P2 = db.Persons.Find(id2).First_Name + " " + db.Persons.Find(id2).Last_Name; } } else { newObj.Last_Name_P2 = "Not captured"; } if (db.Persons.Find(id).Known_As == null) { newObj.Known_As_P2 = "Not captured"; } else { newObj.Known_As_P2 = db.Persons.Find(id2).Known_As; } if (db.Persons.Find(id2).Identification_Number != null) { newObj.Identity_Number_P2 = db.Persons.Find(id2).Identification_Number; } else { newObj.Identity_Number_P2 = "Not captured"; } if (db.Persons.Find(id2).Religion_Id != null) { newObj.Religion_S_2 = db.Religions.Find(db.Persons.Find(id2).Religion_Id).Description; } else { newObj.Religion_S_2 = "Not captured"; } if (db.Persons.Find(id2).Population_Group_Id != null) { newObj.Race_S_2 = db.Races.Find(db.Persons.Find(id2).Population_Group_Id).Description; } else { newObj.Race_S_2 = "Not captured"; } if (db.Persons.Find(id2).Age != null) { newObj.Age_P2 = Convert.ToString(db.Persons.Find(id2).Age); } else { newObj.Age_P2 = "Not captured"; } if (db.Persons.Find(id2).Mobile_Phone_Number != null) { newObj.Mobile_Number_2 = Convert.ToString(db.Persons.Find(id2).Mobile_Phone_Number); } else { newObj.Mobile_Number_2 = "Not captured"; } if (db.Persons.Find(id2).Email_Address != null) { newObj.Email_2 = Convert.ToString(db.Persons.Find(id2).Email_Address); } else { newObj.Email_2 = "Not captured"; } if (db.Persons.Find(id2).Nationality != null) { newObj.Nationality_S_2 = db.Nationalities.Find(db.Persons.Find(id2).Nationality_Id).Description; } else { newObj.Nationality_S_2 = "Not captured"; } if (db.Persons.Find(id2).Marital_Status_Id != null) { newObj.MaritalStatus_S_2 = db.Marital_Statusses.Find(db.Persons.Find(id2).Marital_Status_Id).Description; } else { newObj.MaritalStatus_S_2 = "Not captured"; } if (db.Persons.Find(id2).Religion_Id != null) { newObj.Religion_S_2 = db.Religions.Find(db.Persons.Find(id2).Religion_Id).Description; } else { newObj.Religion_S_2 = "Not captured"; } if (db.Persons.Find(id2).Gender_Id != null) { newObj.GenderS_2 = db.Genders.Find(db.Persons.Find(id2).Gender_Id).Description; } else { newObj.GenderS_2 = "Not captured"; } } #endregion #region id2Null if (id2 == 0) { newObj.Last_Name_P2 = "Not captured"; newObj.Known_As_P2 = "Not captured"; newObj.Identity_Number_P2 = "Not captured"; newObj.Religion_S_2 = "Not captured"; newObj.Race_S_2 = "Not captured"; newObj.Age_P2 = "Not captured"; newObj.Mobile_Number_2 = "Not captured"; newObj.Email_2 = "Not captured"; newObj.Nationality_S_2 = "Not captured"; newObj.MaritalStatus_S_2 = "Not captured"; newObj.Religion_S_2 = "Not captured"; newObj.GenderS_2 = "Not captured"; } #endregion #region OrganisationalDetails #region OrgResponsNotNull if (OrgRespons != null) { if (OrgRespons.Description != null) { newObj.Organisation_Responsible_For_Child_S = OrgRespons.Description; } else { newObj.Organisation_Responsible_For_Child_S = "Not captured"; } if (SocWorkId != 0 && SocWorkId != null) { newObj.Social_Worker = db.Users.Find(SocWorkId).First_Name + "" + db.Users.Find(SocWorkId).Last_Name; } else { newObj.Social_Worker = "Not captured"; } if ((from s in db.Social_Workers where s.User_Id == SocWorkId select s.SocialWorkerPracticeNumber).FirstOrDefault() != null) { newObj.Accreditation_Ref = (from s in db.Social_Workers where s.User_Id == SocWorkId select s.SocialWorkerPracticeNumber).FirstOrDefault(); } else { newObj.Accreditation_Ref = "Not captured"; } newObj.Accreditation_Date = (from s in db.Social_Workers where s.User_Id == SocWorkId select s.AccreditedDate).FirstOrDefault(); if (SocWorkId != 0 && SocWorkId != null) { newObj.Email = db.Users.Find(SocWorkId).Email_Address; } else { newObj.Email = "Not captured"; } if (SocWorkId != 0 && SocWorkId != null) { newObj.Telephone = (from s in db.Social_Workers where s.User_Id == SocWorkId select s.Mobile_Phone_Number).FirstOrDefault(); } else { newObj.Telephone = "Not captured"; } if (SocWorkId != 0 && SocWorkId != null) { newObj.Province = (from p in db.Provinces join o in db.Districts on p.Province_Id equals o.Province_Id join q in db.Local_Municipalities on o.District_Id equals q.District_Municipality_Id join n in db.Service_Offices on q.Local_Municipality_Id equals n.Local_Municipality_Id join m in db.Social_Workers on n.Service_Office_Id equals m.Service_Office_Id where m.User_Id == SocWorkId select p.Description).FirstOrDefault(); } else { newObj.Province = "Not captured"; } } #endregion #region OrgResponsNull if (OrgRespons == null) { newObj.Organisation_Responsible_For_Child_S = "Not captured"; newObj.Social_Worker = "Not captured"; newObj.Accreditation_Ref = "Not captured"; newObj.Email = "Not captured"; newObj.Province = "Not captured"; } #endregion #endregion #region Features if (PFeatures != null) { newObj.Ethnic_CulturalGroup_S = db.apl_Ethnic_Cultural.Find(PFeatures.Ethnic_Cultural_Group_Id).Description; newObj.Eye_Color_S = db.Eye_Colors.Find(PFeatures.Eye_Color_Id).Description; newObj.Body_Structure_S = db.apl_Body_Structure.Find(PFeatures.Body_Structure_Id).Description; newObj.Skin_Color_S = db.apl_Skin_Colour.Find(PFeatures.Skin_Color_Id).Description; newObj.Religion_S = db.Religions.Find(PFeatures.Religion_Id).Description; newObj.Language_S = db.Languages.Find(PFeatures.Language_Id).Description; newObj.GenderS = db.apl_Ethnic_Cultural.Find(PFeatures.Ethnic_Cultural_Group_Id).Description; newObj.Race_S = db.Races.Find(PFeatures.Race_Id).Description; newObj.Age_From = PFeatures.Age_From; newObj.Age_To = PFeatures.Age_To; } #endregion #region SuportingDoc if (SupDocuments.Count != 0) { List <RACAP_Supporting_Document> NewObj = new List <RACAP_Supporting_Document>(); foreach (var item in SupDocuments) { RACAP_Supporting_Document Obj = new RACAP_Supporting_Document(); Obj.RACAPDocumentTypeId = item.RACAPDocumentTypeId; Obj.Document_Description = item.Document_Description; NewObj.Add(Obj); } newObj.DocumentsList = NewObj; } if (SupDocuments.Count == 0) { newObj.DocumentsList = null; } #endregion return(newObj); }