public Program Get(int id)
{
var filter = new ProgramFilter()
{
Id = id
};
return GetPrograms(filter).FirstOrDefault();
}
private List<Program> GetPrograms(ProgramFilter filter)
{
using (var db = DataFactory.GetRemoteEntities())
{
var query = db.Programs.AsQueryable();
//add filters
if (filter.Id.HasValue)
{
query = query.Where(program => program.Id == filter.Id.Value);
}
//include other tables if single select
if (filter.Id.HasValue)
{
query = query.Include(p => p.Remote);
}
return query.ToList();
}
}
public List<Program> GetAll()
{
var filter = new ProgramFilter();
return GetPrograms(filter);
}
