public int GetCount(string species)
{
using (var context = new WhaleSightingsContext())
{
return(context.WhaleSightings.Count(x => x.Species.Equals(species)));
}
}
public List <SightingTrip> Get()
{
using (var context = new WhaleSightingsContext())
{
return(context.SightingTrips.ToList());
}
}
public List <WhaleSighting> Get()
{
using (var context = new WhaleSightingsContext())
{
return(context.WhaleSightings.ToList());
}
}
public SpeciesModel LoadBlueWhaleModel()
{
using (var context = new WhaleSightingsContext())
{
return(context.SpeciesModels.FirstOrDefault(x => x.Species.Equals("BlueWhale")));
}
}
public void Add(SightingTrip trip)
{
using (var context = new WhaleSightingsContext())
{
context.SightingTrips.Add(trip);
context.SaveChanges();
}
}
public void Add(WhaleSighting whaleSighting)
{
using (var context = new WhaleSightingsContext())
{
context.WhaleSightings.Add(whaleSighting);
context.SaveChanges();
}
}
public void Update(SightingTrip trip)
{
using (var context = new WhaleSightingsContext())
{
var sightingTripDb = context.SightingTrips.FirstOrDefault(x => x.Id == trip.Id);
sightingTripDb.Captain = trip.Captain;
sightingTripDb.DepartureTime = trip.DepartureTime;
context.SaveChanges();
}
}
public void Update(WhaleSighting whaleSighting)
{
using (var context = new WhaleSightingsContext())
{
var whaleSightingDb = context.WhaleSightings.FirstOrDefault(x => x.Id == whaleSighting.Id);
whaleSightingDb.Name = whaleSighting.Name;
whaleSightingDb.Species = whaleSighting.Species;
whaleSightingDb.Latitude = whaleSighting.Latitude;
whaleSightingDb.Longitude = whaleSighting.Longitude;
whaleSightingDb.Time = whaleSighting.Time;
context.SaveChanges();
}
}
