public EFPhotoRepository()
{
using (var context = new PhotoContext())
{
context.Database.CreateIfNotExists();
}
}
public IList<Photo> LoadPhotosByTripId(int tripId)
{
using (var context = new PhotoContext())
{
var photos = context.Photos.Where(x => x.TripId == tripId).ToList();
return photos;
}
}
public IList<Trip> LoadAllTrips()
{
using (var context = new PhotoContext())
{
var trips = from t in context.Trips
select t;
return trips.ToList();
}
}
public void CreatePhotos(IList<Photo> photos)
{
using (var context = new PhotoContext())
{
foreach (var photo in photos)
{
context.Photos.Add(photo);
}
context.SaveChanges();
}
}
public void CreateTrip(string path, string title, string description)
{
using (var context = new PhotoContext())
{
var trip = new Trip
{
Description = description,
RootPath = path,
TripName = title,
};
context.Trips.Add(trip);
context.SaveChanges();
}
}
public Trip LoadTripWithName(string title)
{
using (var context = new PhotoContext())
{
var data = from t in context.Trips
where t.TripName == title
select t;
var trip = data.ToList();
switch (trip.Count)
{
case 0:
return new Trip {TripId = 0};
case 1:
return trip[0];
default:
//should never hit this case, but if I don't the exception will be epic.
return null;
}
}
}
public void UpdatePhoto(Photo photo)
{
using (var context = new PhotoContext())
{
Photo oldPhoto = context.Photos.FirstOrDefault(x => x.PhotoId == photo.PhotoId);
oldPhoto.Description = photo.Description;
context.SaveChanges();
}
}