public Movie CreateMovie(NewEventWithInvites NewEvent) { var sql = @"INSERT INTO [Movie](MovieTitle, MoviePoster, MovieDBId) OUTPUT INSERTED.* VALUES(@MovieTitle, @MoviePoster, @MovieDBId)"; using (var db = new SqlConnection(ConnectionString)) { var result = db.QueryFirstOrDefault <Movie>(sql, NewEvent); return(result); } }
public IActionResult CreateEvent(NewEventWithInvites NewEvent) { var newMovie = _movieRepository.CreateMovie(NewEvent); var newCreatedEvent = _eventRepository.CreateEvent(NewEvent, newMovie.MovieId); foreach (var userId in NewEvent.InvitedUsers) { _inviteRepository.CreateInvite(userId, newCreatedEvent.EventId); var emailAddress = _userRepository.GetEmail(userId); var movieTitle = _movieRepository.GetMovieTitle(newMovie.MovieId); _twilioRepository.Other(emailAddress, movieTitle); } return(Ok(newCreatedEvent)); }
public Event CreateEvent(NewEventWithInvites NewEvent, int movieId) { var parameters = new { movieId = movieId, HostId = NewEvent.HostId, DateTime = NewEvent.DateTime, Location = NewEvent.Location, Notes = NewEvent.Notes }; var sql = @"INSERT INTO [Event](MovieId, HostId, [DateTime], Location, DateEventCreated, Notes) OUTPUT INSERTED.* VALUES(@MovieId, @HostId, @DateTime, @Location, getDate(), @Notes)"; using (var db = new SqlConnection(ConnectionString)) { var result = db.QueryFirstOrDefault <Event>(sql, parameters); return(result); } }