public async Task Post([FromBody] DbOrgMovie dbOrgMovie)
{
var movie = new Movie();
// Set basic details (easy)
movie.Title = dbOrgMovie.Title;
movie.Description = dbOrgMovie.Overview.Substring(0, Math.Min(dbOrgMovie.Overview.Length, 500));
movie.DurationInMinutes = (int)dbOrgMovie.Runtime;
movie.ReleaseDate = dbOrgMovie.ReleaseDate.DateTime;
// Set Restriction Rating. Use certification of first US Release in TheMovieDbOrg results.
movie.RestrictionRatingId = await GetRestrictionRating(dbOrgMovie);
// Set Genre/Language lists by reference
await SetMovieGenres(dbOrgMovie, movie);
await SetMovieLanguages(dbOrgMovie, movie);
#region Insert With Stored Procedure
//using var sqlConn = new SqlConnection(_context.Database.GetDbConnection().ConnectionString);
//await InsertMovieWithStoredProcedureAsync(sqlConn, movie);
#endregion
#region Insert with Entity Framework (Commented out)
_context.Add(movie);
await _context.SaveChangesAsync();
#endregion
}
public async Task <IActionResult> Create(MovieImage movieImage, IFormFile fileContents)
{
// set FileContents
using var ms = new MemoryStream();
fileContents.CopyTo(ms);
byte[] fileBytes = ms.ToArray();
movieImage.FileContents = fileBytes;
// set file extension
string fileExtension = new FileInfo(fileContents.FileName).Extension;
ImageType imageType = await _context.ImageType.Where(i => i.ImageExtension == fileExtension).FirstOrDefaultAsync();
movieImage.ImageTypeId = imageType.Id;
// timestamp (note: not UTC for now)
movieImage.DateUploaded = DateTime.Now;
if (ModelState.IsValid)
{
_context.Add(movieImage);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ImageTypeId"] = new SelectList(_context.ImageType, "Id", "ImageExtension", movieImage.ImageTypeId);
ViewData["MovieId"] = new SelectList(_context.Movie, "Id", "Title", movieImage.MovieId);
return(View(movieImage));
}
public async Task <IActionResult> Create([Bind("Id,Prefix,FirstName,MiddleName,LastName,Suffix,PreferredFullName,Gender,DateOfBirth,DateOfDeath,Biography")] FilmMember filmMember)
{
if (ModelState.IsValid)
{
_context.Add(filmMember);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(filmMember));
}
public async Task <IActionResult> Create([Bind("Id,GenreName,Description")] Genre genre)
{
if (ModelState.IsValid)
{
_context.Add(genre);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(genre));
}
public async Task <IActionResult> Create([Bind("Id,Code,ShortDescription,LongDescription,IsActive")] RestrictionRating restrictionRating)
{
if (ModelState.IsValid)
{
_context.Add(restrictionRating);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(restrictionRating));
}
public async Task <IActionResult> Create([Bind("LanguageIsoCode,LanguageName")] Language language)
{
if (ModelState.IsValid)
{
_context.Add(language);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(language));
}
public async Task <IActionResult> Create([Bind("Id,ShowName,Description")] AwardShow awardShow)
{
if (ModelState.IsValid)
{
_context.Add(awardShow);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(awardShow));
}
public async Task <IActionResult> Create(AwardShowInstance awardShowInstance)
{
if (ModelState.IsValid)
{
_context.Add(awardShowInstance);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["AwardShowId"] = new SelectList(_context.AwardShow, "Id", "ShowName", awardShowInstance.AwardShowId);
return(View(awardShowInstance));
}
public async Task <IActionResult> Create([Bind("Id,Title,Description,ReleaseDate,RestrictionRatingId,DirectorFilmMemberId,DurationInMinutes,AverageUserRating")] Movie movie)
{
if (ModelState.IsValid)
{
_context.Add(movie);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["RestrictionRatingId"] = new SelectList(_context.RestrictionRating, "Id", "Code", movie.RestrictionRatingId);
return(View(movie));
}
public async Task <IActionResult> Create([Bind("Id,AwardShowId,AwardName,Description")] Award award)
{
if (ModelState.IsValid)
{
_context.Add(award);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["AwardShowId"] = new SelectList(_context.AwardShow, "Id", "ShowName", award.AwardShowId);
return(View(award));
}
public async Task <IActionResult> Create([Bind("MovieId,GenreId")] MovieGenre movieGenre)
{
if (ModelState.IsValid)
{
_context.Add(movieGenre);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["GenreId"] = new SelectList(_context.Genre, "Id", "GenreName", movieGenre.GenreId);
ViewData["MovieId"] = new SelectList(_context.Movie, "Id", "Title", movieGenre.MovieId);
return(View(movieGenre));
}
public async Task <IActionResult> Create([Bind("MovieId,ActorFilmMemberId,CharacterName,Sequence")] MovieCastMember movieCastMember)
{
if (ModelState.IsValid)
{
_context.Add(movieCastMember);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ActorFilmMemberId"] = new SelectList(_context.FilmMember, "Id", "FirstName", movieCastMember.ActorFilmMemberId);
ViewData["MovieId"] = new SelectList(_context.Movie, "Id", "Title", movieCastMember.MovieId);
return(View(movieCastMember));
}
public async Task <IActionResult> Create([Bind("Id,MovieId,UserId,Rating,Review,DatePosted")] MovieUserReview movieUserReview)
{
if (ModelState.IsValid)
{
_context.Add(movieUserReview);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["MovieId"] = new SelectList(_context.Movie, "Id", "Title", movieUserReview.MovieId);
ViewData["UserId"] = new SelectList(_context.User, "Id", "EmailAddress", movieUserReview.UserId);
return(View(movieUserReview));
}
public async Task <IActionResult> Create([Bind("MovieUserReviewId,UserId,IsHelpful")] MovieUserReviewHelpful movieUserReviewHelpful)
{
if (ModelState.IsValid)
{
_context.Add(movieUserReviewHelpful);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["MovieUserReviewId"] = new SelectList(_context.MovieUserReview, "Id", "Id", movieUserReviewHelpful.MovieUserReviewId);
ViewData["UserId"] = new SelectList(_context.User, "Id", "EmailAddress", movieUserReviewHelpful.UserId);
return(View(movieUserReviewHelpful));
}
public async Task <IActionResult> Create([Bind("MovieId,LanguageIsoCode")] MovieLanguage movieLanguage)
{
if (ModelState.IsValid)
{
_context.Add(movieLanguage);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["LanguageIsoCode"] = new SelectList(_context.Language, "LanguageIsoCode", "LanguageIsoCode", movieLanguage.LanguageIsoCode);
ViewData["MovieId"] = new SelectList(_context.Movie, "Id", "Description", movieLanguage.MovieId);
return(View(movieLanguage));
}
public async Task <IActionResult> Create([Bind("Id,UserName,EmailAddress,HashedPassword")] User user)
{
if (ModelState.IsValid)
{
user.HashedPassword = HashUsersPassword(user.HashedPassword);
// Set all users added via this form to user role. Admins must be added via database.
user.UserRoleId = (int)DbEnum.UserRole.User;
_context.Add(user);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(user));
}
