public EventResponse UpdateEvent(PutRequest <Event> putRequest) { using (var db = new EventSourceDbContext(_dbContext)) { var @event = db.Events.FirstOrDefault(e => e.Id == putRequest.Id); if (@event == null) { return new EventResponse() { Result = false } } ; @event.Name = (!string.IsNullOrEmpty(putRequest.Payload.Name)) ? putRequest.Payload.Name : @event.Name; @event.Description = (!string.IsNullOrEmpty(putRequest.Payload.Description)) ? putRequest.Payload.Description : @event.Description; @event.City = (!string.IsNullOrEmpty(putRequest.Payload.City)) ? putRequest.Payload.City : @event.City; @event.Category = (!string.IsNullOrEmpty(putRequest.Payload.Category)) ? putRequest.Payload.Category : @event.Category; @event.Location = (!string.IsNullOrEmpty(putRequest.Payload.Location)) ? putRequest.Payload.Location : @event.Location; @event.Seats = (putRequest.Payload.Seats > 0) ? putRequest.Payload.Seats : @event.Seats; db.SaveChanges(); return(new EventResponse() { Event = @event }); } }
public Response DeleteEvent(EventIdRequest idRequest) { using (var db = new EventSourceDbContext(_dbContext)) { var @event = db.Events.Find(idRequest.Id); db.Events.Remove(@event); db.SaveChanges(); return(new Response()); } }
public EventResponse CreateEvent(PostRequest <Event> postRequest) { using (var db = new EventSourceDbContext(_dbContext)) { db.Events.Add(postRequest.Payload); db.SaveChanges(); return(new EventResponse() { Event = postRequest.Payload }); } }
public Response DeletePlace(PlaceIdRequest request) { var response = new Response(); using (var db = new EventSourceDbContext(_contextOptions)) { var _place = db.Places.Find(request.Id); if (_place == null) { response.Result = false; return(response); } db.Places.Remove(_place); db.SaveChanges(); return(response); } }
public PlaceResponse CreatePlace(PostRequest <Place> request) { using (var db = new EventSourceDbContext(_contextOptions)) { var newPlace = new Place() { DateRegistered = request.Payload.DateRegistered, Capacity = request.Payload.Capacity, Location = request.Payload.Location.ToLower(), Name = request.Payload.Name.ToLower(), Description = request.Payload.Description, City = request.Payload.City.ToLower() }; db.Places.Add(newPlace); db.SaveChanges(); return(new PlaceResponse() { Place = newPlace, }); } }
public PlaceResponse UpdatePlace(PutRequest <Place> request) { using (var db = new EventSourceDbContext(_contextOptions)) { var response = new PlaceResponse(); var _place = db.Places.Find(request.Id); if (_place != null) { _place.Description = !string.IsNullOrEmpty(request.Payload.Description) ? request.Payload.Description : _place.Description; _place.City = !string.IsNullOrEmpty(request.Payload.City) ? request.Payload.City.ToLower() : _place.City; _place.Capacity = request.Payload.Capacity > 0 ? request.Payload.Capacity : _place.Capacity; _place.Name = !string.IsNullOrEmpty(request.Payload.Name) ? request.Payload.Name.ToLower() : _place.Name; _place.Location = !string.IsNullOrEmpty(request.Payload.Location) ? request.Payload.Location.ToLower() : _place.Location; db.Places.Attach(_place); db.SaveChanges(); response.Place = _place; return(response); } response.Result = false; return(response); } }