public string GetAllDeals()
{
List<Deal> deals;
using (var entities = new sunday_driveEntities())
{
deals = (from d in entities.Deals select d).ToList();
deals.ForEach(d => entities.Detach(d));
}
return new JavaScriptSerializer().Serialize(deals);
}
public string GetBusinessDeals(int businessID)
{
List<Deal> deals;
using (var entities = new sunday_driveEntities())
{
deals = (from d in entities.Deals
where d.BusinessID == businessID
select d).ToList();
deals.ForEach(d => entities.Detach(d));
}
return new JavaScriptSerializer().Serialize(deals); ;
}
public string ExampleQuery1()
{
List<Business> businesses;
using (var entities = new sunday_driveEntities())
{
businesses = entities.Businesses.Where(b => b.PriceLevel > 2).ToList();
businesses.ForEach(b => entities.Detach(b)); // This line is needed to prevent circular references when serializing to Json.
}
return new JavaScriptSerializer().Serialize(businesses);
}
public string GetBusinessesByPriceLevel(int priceLevel)
{
List<Business> businesses;
using (var entities = new sunday_driveEntities())
{
businesses = (from b in entities.Businesses
where b.PriceLevel <= priceLevel
select b).ToList();
businesses.ForEach(b => entities.Detach(b)); // This line is needed to prevent circular references when serializing to Json.
}
return new JavaScriptSerializer().Serialize(businesses);
}
public string GetBusinessRatings(int businessID)
{
List<Rating> ratings;
using (var entities = new sunday_driveEntities())
{
ratings = (from r in entities.Ratings
where entities.Locations.Any(l => l.LocationID == r.LocationID && l.BusinessID == businessID)
select r).ToList();
ratings.ForEach(r => entities.Detach(r));
}
return new JavaScriptSerializer().Serialize(ratings);
}
public void InsertRating(int locationID, int rating, string review)
{
using (var entities = new sunday_driveEntities())
{
Rating newRating = new Rating();
newRating.LocationID = locationID;
newRating.Rating1 = rating;
newRating.Text = review;
entities.Ratings.AddObject(newRating);
entities.SaveChanges();
}
}
public void InsertLocation(int businessID, string street1, string street2, string municipality, string county, string state, string postalcode, string country, string phone)
{
using (var entities = new sunday_driveEntities())
{
Location newLocation = new Location()
{
BusinessID = businessID,
StreetLine1 = street1,
StreetLine2 = street2,
Municipality = municipality,
County = county,
State = state,
PostalCode = postalcode,
Country = country,
Phone = phone
};
SetGPSCoords(ref newLocation);
entities.Locations.AddObject(newLocation);
entities.SaveChanges();
}
}
public string GetLocations(int businessID)
{
List<Location> locations;
using (var entities = new sunday_driveEntities())
{
locations = (from l in entities.Locations
where l.BusinessID == businessID
select l).ToList();
locations.ForEach(l => entities.Detach(l)); // This line is needed to prevent circular references when serializing to Json.
}
return new JavaScriptSerializer().Serialize(locations);
}
public string GetLocationRatings(int locationID)
{
List<Rating> ratings;
using (var entities = new sunday_driveEntities())
{
ratings = (from r in entities.Ratings
where r.LocationID == locationID
select r).ToList();
ratings.ForEach(r => entities.Detach(r)); // This line is needed to prevent circular references when serializing to Json.
}
return new JavaScriptSerializer().Serialize(ratings);
}