public List <vw_CaseDefectsData> GetVictimsByCaseID(int CaseID, int SessionID)
{
var victims = (from _case in DataContext.Cases_Cases
join _session in DataContext.Cases_CaseSessions on _case.ID equals _session.CaseID
join _victim in DataContext.Cases_CaseVictims on _case.ID equals _victim.CaseID
join _personVictim in DataContext.Configurations_Persons on _victim.PersonID equals _personVictim.ID
join _victimsSessionLog in DataContext.Cases_VictimsSessionsLog on _victim.ID equals _victimsSessionLog.VictimID into VSLog
from _vslog in VSLog.DefaultIfEmpty()
join _PresenceStatus in DataContext.Configurations_Lookups on _vslog.PresenceStatusID equals _PresenceStatus.ID into PStatus
from _ps in PStatus.DefaultIfEmpty()
where _case.ID == CaseID && _session.ID == SessionID && _case.IsDeleted != true
select new vw_CaseDefectsData
{
ID = _victim.ID,
PersonID = _victim.PersonID,
Name = _personVictim.FullName,
NationalID = _personVictim.NationalID,
DefectType = PartyTypes.Victim,
IsCivilRightProsecutor = _victim.IsCivilRightProsecutor,
Presence = _vslog == null ? 0 :(PresenceStatus)_vslog.PresenceStatusID,
JobName = _personVictim.JobTitle,
NationalityType = _personVictim.NationalityID,
PassportNumber = _personVictim.PassportNumber,
Birthdate = _personVictim.Birthdate,
Order = _victim.Order,
Address = _personVictim.Address,
Nationality = _personVictim.Configurations_Lookups.Name,
}).ToList();
return(victims);
}
