public List<ApplicationTO> GetAllApplications() { List<ApplicationTO> applicationTOs = new List<ApplicationTO>(); using(var db = new WamAppEntities1()) { var applications = from a in db.Applications select a; foreach(Application app in applications){ ApplicationTO appTO = new ApplicationTO { id = app.Id, name = app.name }; applicationTOs.Add(appTO); } } return applicationTOs; }
public List<ApplicationTO> GetApplicationsForUsername(string username) { List<ApplicationTO> applicationTOs = new List<ApplicationTO>(); using (var db = new WamAppEntities1()) { var applications = from a in db.Applications join d in db.Developers on a.userId equals d.Id where d.username == username select a; foreach (Application app in applications) { ApplicationTO appTO = new ApplicationTO { id = app.Id, name = app.name }; applicationTOs.Add(appTO); } } return applicationTOs; }