public static void AddLocation(Location newLocation)
{
using (var db = new WincWeatherEntities())
{
db.Locations.Add(newLocation);
db.SaveChanges();
}
}
public static string GetResponseFromLastFiveMinutesByLocationId(int locationId)
{
using (var db = new WincWeatherEntities())
{
return(db.WeatherCaches.FirstOrDefault(n =>
n.LocationId == locationId &&
n.TimeReceived > DbFunctions.AddMinutes(DateTime.Now, -5)
)?.Response);
}
}
public static Location GetLocationByZip(string zip)
{
using (var db = new WincWeatherEntities())
{
var locations = from location in db.Locations
where location.Zipcode == zip
select location;
return(locations.FirstOrDefault());
}
}
public static Location GetLocationById(int locationId)
{
using (var db = new WincWeatherEntities())
{
var locations = from location in db.Locations
where location.Id == locationId
select location;
return(locations.FirstOrDefault());
}
}
public static List <Location> GetLocationsByName(string name)
{
using (var db = new WincWeatherEntities())
{
var locations = from location in db.Locations
where location.Name == name
select location;
return(locations.ToList());
}
}
public static void SaveResponse(string response, int locationId)
{
using (var db = new WincWeatherEntities())
{
db.WeatherCaches.Add(
new WeatherCache {
Response = response,
LocationId = locationId,
TimeReceived = DateTime.Now
});
db.SaveChanges();
}
}
public static void DeleteLocation(int id)
{
using (var db = new WincWeatherEntities())
{
var removedLocation = GetLocationById(id);
if (removedLocation != null)
{
db.Locations.Attach(removedLocation);
db.Locations.Remove(removedLocation);
db.SaveChanges();
}
}
}
