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 async Task <bool> CreateArtist(ArtistResource artist) { var entity = new Artist() { Name = artist.Name, Description = artist.Description }; using (var context = new OneOffEntities()) { context.Artists.Add(entity); return(await context.SaveChangesAsync() == 1); } }
public async Task <bool> CreateVenue(VenueResource venue) { var entity = new Venue() { Name = venue.Name, Description = venue.Description, PostalCode = venue.PostalCode }; using (var ctx = new OneOffEntities()) { ctx.Venues.Add(entity); return(await ctx.SaveChangesAsync() == 1); } }
public RequestResource GetRequestById(int id) { using (var context = new OneOffEntities()) { var entity = context .Requests // TODO: check ownership .SingleOrDefault(e => e.RequestId == id); return (new RequestResource { Date = entity.Date, Offer = entity.Offer, VenueId = entity.VenueId }); } }
public GigResource GetGigById(int id) { using (var context = new OneOffEntities()) { var entity = context .Gigs // TODO: check ownership .SingleOrDefault(e => e.GigId == id); return (new GigResource { Date = entity.Date, PostalCode = entity.PostalCode, ArtistId = entity.ArtistId }); } }
public IEnumerable <RequestResource> GetRequests() { using (var context = new OneOffEntities()) { var query = context .Requests .Select( e => new RequestResource { Date = e.Date, Offer = e.Offer, VenueId = e.VenueId } ); return(query.ToArray()); } }
public IEnumerable <GigResource> GetGigs() { using (var context = new OneOffEntities()) { var query = context .Gigs .Select( e => new GigResource { Date = e.Date, PostalCode = e.PostalCode, ArtistId = e.ArtistId } ); return(query.ToArray()); } }
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); } }