public static List <Program> GetPrograms(bool activeOnly)
{
List <Program> programs;
using (CustomClearviewEntities ctx = new CustomClearviewEntities())
{
RateRepository repo = new RateRepository(ctx);
programs = activeOnly
? repo.Filter(a => a.EffectiveEndDate > DateTime.Now.Date, sort => sort.ProgramName, SortOrder.Ascending, u => u.UnitOfMeasure, p => p.PremiseType,
ut => ut.UtilityType, u => u.Utility, b => b.Brand)
: repo.All(sort => sort.ProgramName, SortOrder.Ascending, t => t.UnitOfMeasure, u => u.UtilityType, p => p.PremiseType,
ut => ut.UtilityType, u => u.Utility, b => b.Brand); //EffecticeEndDate >= today
}
return(programs);
}
public static List <Utility> GetUtilities()
{
List <Utility> utilities = new List <Utility>();
using (CustomClearviewEntities ctx = new CustomClearviewEntities())
{
RateRepository repo = new RateRepository(ctx);
List <Program> programs = repo.All(type => type.Utility);
foreach (Program p in programs)
{
utilities.Add(p.Utility);
}
}
return(utilities.Distinct().ToList());
}
public IEnumerable <Rate> GetAll()
{
return(_rateService.All());
}
