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