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);
}
}
