public IList<HandsetOpotunity> GetAll()
 {
     using (var context = new LumiaContext())
     {
         return context.HandsetOpotunitieses.ToList();
     }
 }
 public IList<Region> GetAll()
 {
     using (var context = new LumiaContext())
     {
         return context.Regions.Where(x => x.IsEnabled).ToList();
     }
 }
 public HandsetOpotunity Get(Guid opotunityGuid)
 {
     using (var context = new LumiaContext())
     {
         return context.HandsetOpotunitieses.FirstOrDefault(x => x.Id == opotunityGuid);
     }
 }
 public Region Get(Guid regionId)
 {
     using (var context = new LumiaContext())
     {
         return context.Regions.FirstOrDefault(x => x.Id == regionId);
     }
 }
 public TimeFrame Get(Guid regionId)
 {
     using (var context = new LumiaContext())
     {
         return context.TimeFrames.FirstOrDefault(x => x.RegionId == regionId);
     }
 }
 public IEnumerable<SelectionDate> GetAll(Guid regionGuid)
 {
     using (var context = new LumiaContext())
     {
         return context.SelectionDates.Where(x => x.RegionId == regionGuid).ToList();
     }
 }
 public SelectionDate Get(Guid selectedDateGuid)
 {
     using (var context = new LumiaContext())
     {
         return context.SelectionDates.FirstOrDefault(x => x.Id == selectedDateGuid);
     }
 }
 public IList<Device> GetAll(Guid regionGuid)
 {
     using (var context = new LumiaContext())
     {
         return context.Devices.Where(x => x.RegionId == regionGuid).ToList();
     }
 }