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