public bool DeleteRequest(int id)
{
using (var context = new OneOffEntities())
{
var entity = context
.Requests
// TODO: check ownership
.SingleOrDefault(e => e.RequestId == id);
context.Requests.Remove(entity);
return(context.SaveChanges() == 1);
}
}
public bool UpdateRequest(int id, RequestUpdateResource request)
{
using (var context = new OneOffEntities())
{
var entity = context
.Requests
.SingleOrDefault(e => e.RequestId == id);
entity.Date = request.Date;
entity.Offer = request.Offer;
return(context.SaveChanges() == 1);
}
}
public bool UpdateGig(int id, GigUpdateResource gig)
{
using (var context = new OneOffEntities())
{
var entity = context
.Gigs
.SingleOrDefault(e => e.GigId == id);
entity.Date = gig.Date;
entity.PostalCode = gig.PostalCode;
return(context.SaveChanges() == 1);
}
}
public bool CreateRequest(RequestResource request)
{
var entity =
new Request()
{
Date = request.Date,
Offer = request.Offer,
VenueId = request.VenueId
};
using (var context = new OneOffEntities())
{
Venue venue = context
.Venues
.SingleOrDefault(v => v.VenueId == entity.VenueId);
venue.Requests.Add(entity);
context.Requests.Add(entity);
return(context.SaveChanges() == 1);
}
}
public bool CreateGig(GigResource gig)
{
var entity =
new Gig()
{
Date = gig.Date,
PostalCode = gig.PostalCode,
ArtistId = gig.ArtistId
};
using (var context = new OneOffEntities())
{
Artist artist = context
.Artists
.SingleOrDefault(a => a.ArtistId == entity.ArtistId);
artist.Gigs.Add(entity);
context.Gigs.Add(entity);
return(context.SaveChanges() == 1);
}
}
