public ActionResult GetRecords(int CompanyId, int SessionId)
{
List <SimpleDirectorship> ListRecordByCompany = new List <SimpleDirectorship>();
var rdirector = from d in _context.Directorship
join c in _context.Companies
on d.Companyid equals c.Id
join dr in _context.Directors
on d.Directorid equals dr.Id
where d.Companyid == CompanyId && d.SessionId == SessionId
select new { d.Id, CDP1 = d.Cdp1Navigation.Positiontype, CDP2 = d.Cdp2Navigation.Positiontype, DirectorAudit = d.DauditNavigation.Positiontype, DirectorRenumeration = d.DrenumNavigation.Positiontype, DirectorNomination = d.DnomNavigation.Positiontype, d.Duration, d.Director.Name, d.Session.Sessionyear, d.Company.Companyname };
foreach (var item in rdirector)
{
SimpleDirectorship sd = new SimpleDirectorship
{
Id = item.Id,
CDP1 = item.CDP1,
CDP2 = item.CDP2,
DirectorAudit = item.DirectorAudit,
DirectorRenumeration = item.DirectorRenumeration,
DirectorNomination = item.DirectorNomination,
Duration = item.Duration,
DirectorName = item.Name,
Company = item.Companyname,
Year = item.Sessionyear
};
ListRecordByCompany.Add(sd);
}
return(View(ListRecordByCompany));
}
public ActionResult GetCompanyDirectors(int id)
{
List <SimpleDirectorship> ListDirectorsByCompany = new List <SimpleDirectorship>();
var latestsession = _context.Sessions.Max(x => x.Id);
var cdirectors = from d in _context.Directorship.Include(d => d.Cdp1Navigation).Include(d => d.Cdp2Navigation).Include(d => d.DauditNavigation).Include(d => d.DnomNavigation).Include(d => d.DrenumNavigation)
join c in _context.Companies
on d.Companyid equals c.Id
join dr in _context.Directors
on d.Directorid equals dr.Id
join ss in _context.Sessions
on d.SessionId equals ss.Id
where d.Companyid == id && ss.Id == latestsession
select new { d.Id, CDP1 = d.Cdp1Navigation.Positiontype, CDP2 = d.Cdp2Navigation.Positiontype, DirectorAudit = d.DauditNavigation.Positiontype, DirectorRenumeration = d.DrenumNavigation.Positiontype, DirectorNomination = d.DnomNavigation.Positiontype, d.Duration, d.Directorid, d.Companyid, d.SessionId, Company = c.Companyname, DirectorName = dr.Name, Year = ss.Sessionyear };
foreach (var item in cdirectors)
{
SimpleDirectorship sd = new SimpleDirectorship
{
Id = item.Id,
CDP1 = item.CDP1,
CDP2 = item.CDP2,
DirectorAudit = item.DirectorAudit,
DirectorRenumeration = item.DirectorRenumeration,
DirectorNomination = item.DirectorNomination,
Duration = item.Duration,
Directorid = item.Directorid,
Companyid = item.Companyid,
SessionId = item.SessionId,
Company = item.Company,
DirectorName = item.DirectorName,
Year = item.Year
};
ListDirectorsByCompany.Add(sd);
}
return(View(ListDirectorsByCompany));
//return Json(cdirectors);
}
