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;
}