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