public AdvisorList getAdvisorByAdvID(int advID) { AdvisorList advisor = new AdvisorList(); var adv = dataContext.sp_GetAdvisorByAdvID(advID).First(); advisor.AdvisorID = adv.Advisor_ID; advisor.LastName = adv.LastName; advisor.FirstName = adv.FirstName; advisor.Name = adv.FirstName + " " + adv.LastName; if (adv.offCampus == true) { advisor.Type = "Community"; } else { advisor.Type = "Carroll"; } return(advisor); }