public int GetCount(string species)
{
using (var context = new WhaleRides())
{
return(context.Whales.Count(x => x.Species.Equals(species)));
}
}
public List <Whale> Get()
{
using (var context = new WhaleRides())
{
return(context.Whales.ToList());
}
}
public void Add(Whale whale)
{
using (var context = new WhaleRides())
{
context.Whales.Add(whale);
context.SaveChanges();
}
}
public void Add(Ride ride)
{
using (var context = new WhaleRides())
{
context.Rides.Add(ride);
context.SaveChanges();
}
}
public void Update(Whale whale)
{
using (var context = new WhaleRides())
{
var whaleDb = context.Whales.FirstOrDefault(x => x.Id == whale.Id);
whaleDb.Name = whale.Name;
whaleDb.Species = whale.Species;
context.SaveChanges();
}
}
public void Update(Ride ride)
{
using (var context = new WhaleRides())
{
var rideDb = context.Rides.FirstOrDefault(x => x.Id == ride.Id);
rideDb.WhaleId = ride.WhaleId;
rideDb.Rider = ride.Rider;
rideDb.RideTime = ride.RideTime;
context.SaveChanges();
}
}
