void IDisposable.Dispose() { if (_entities != null) { _entities.Dispose(); _entities = null; } }
public IQueryable <ZipCode> GetZipCodesInRange(float latitude, float longitude, float radiusInMiles = 5) { float tolerance = 0.08f * 5; // 0.08 lat/lon units approximately equals 5 miles DesiOfferEntities entities = GeneralService.GetDbEntities(); return(entities.ZipCodes.Where(z => ((z.Lat > latitude && (z.Lat - latitude) <= tolerance) || (z.Lat <= latitude && (latitude - z.Lat) <= tolerance)) && ((z.Long > longitude && (z.Long - longitude) <= tolerance) || (z.Long <= longitude && (longitude - z.Long) <= tolerance)) ) .AsQueryable()); }
public IEnumerable <ProductViewModel> ListRecent(int limit = 50) { DesiOfferEntities entities = GeneralService.GetDbEntities(); List <ProductViewModel> viewModels = new List <ProductViewModel>(); foreach (Product product in entities.Products.Take(limit)) { viewModels.Add(new ProductViewModel(product)); } return(viewModels); }
public IEnumerable <CustomerViewModel> ListInZipCodes(List <string> zipCodes) { DesiOfferEntities entities = GeneralService.GetDbEntities(); var query = entities.Customers.Where(c => zipCodes.Contains(c.ZipCode)); List <CustomerViewModel> customers = new List <CustomerViewModel>(); foreach (Customer customer in query) { customers.Add(new CustomerViewModel(customer)); } return(customers); }
public IEnumerable <ProductViewModel> ListByZipCodes(List <string> zipCodes) { DesiOfferEntities entities = GeneralService.GetDbEntities(); var query = entities.Products.Where(c => zipCodes.Contains(c.Customer.ZipCode)); List <ProductViewModel> viewModels = new List <ProductViewModel>(); foreach (Product product in query) { viewModels.Add(new ProductViewModel(product)); } return(viewModels); }
public IEnumerable <CustomerViewModel> ListMatching(string searchText) { searchText = searchText ?? string.Empty; searchText = searchText.Trim().ToLower(); DesiOfferEntities entities = GeneralService.GetDbEntities(); var query = entities.Customers.Where(c => (c.FirstName != null && c.FirstName.ToLower().Contains(searchText)) || (c.LastName != null && c.LastName.ToLower().Contains(searchText))); List <CustomerViewModel> customers = new List <CustomerViewModel>(); foreach (Customer customer in query) { customers.Add(new CustomerViewModel(customer)); } return(customers); }
public WebUserStore(DesiOfferEntities entities) { _entities = entities ?? new DesiOfferEntities(); }