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