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