//-----Return all the Projects--
public List <Project> GetProjects()
{
using (MH_CRUDContext db = new MH_CRUDContext())
{
return(db.Projects.ToList());
}
}
//Get All members
public List <MemberReturn> GetMembers()
{
using (MH_CRUDContext db = new MH_CRUDContext())
{
var allData = from m in db.Members
join p in db.Projects on m.ProjectId equals p.Id
select new MemberReturn
{
ID = m.Id,
FirstName = m.FirstName,
LastName = m.LastName,
Title = m.Title,
ProjectName = p.ProjectName,
ProjectId = m.ProjectId
};
return(allData.ToList());
}
}
//--------Get members by Project ID
public List <MemberReturn> GetProjectMembrs(int id)
{
using (MH_CRUDContext db = new MH_CRUDContext())
{
var members = from m in db.Members
join p in db.Projects on m.ProjectId equals p.Id
where p.Id == id
select new MemberReturn
{
ID = m.Id,
FirstName = m.FirstName,
LastName = m.LastName,
Title = m.Title,
ProjectName = p.ProjectName,
ProjectId = m.ProjectId
};
return(members.ToList());
}
}
