public FilmSubmission GetFilm(int filmId, int userId) { FilmSubmission res = _context.FilmSubmissions .Include("FilmAltTitles") //.Include .FirstOrDefault(x => x.FilmSubmissionId == filmId && x.UserId == userId && !x.Deleted && x.Submitted == null); if (res != null && res.Synopsis != null) { res.Synopsis.Replace("\n", "\r\n"); } return(res); }
public bool DeleteTitle(int filmSubmissionId, int userId) { FilmSubmission film = _context.FilmSubmissions.FirstOrDefault(x => x.UserId == userId && x.FilmSubmissionId == filmSubmissionId && x.Submitted == null); if (film == null) { return(false); } film.Deleted = true; film.ModifiedBy = userId; film.ModifiedDate = DateTime.Now; _context.SaveChanges(); return(true); }
public ActionResult Title(int?filmId) { FilmSubmission model = new FilmSubmission { FilmAltTitles = new List <FilmAltTitle>() }; if (filmId == null) // new Title { this.CurrentFilm = null; return(View(model)); } model = new FilmRepository().GetFilm(filmId.Value, User.UserId); this.CurrentFilm = model; // save the selected film in session return(View(model)); }
public ActionResult SaveTitle(FilmSubmission film, List <string> AltTitle, string NextPage) { // UserID of the saved film must be taken from session film.UserId = this.User.UserId; // FilmID of the saved film also must be taken from session if (this.CurrentFilm != null) // else FilmId=0 (means new Film) { film.FilmSubmissionId = this.CurrentFilm.FilmSubmissionId; } FilmSubmission model = new FilmRepository().SaveFilm(film, AltTitle.Where(x => x != "").ToList(), this.User.UserId); //the saved film must be saved in session - now it's current film this.CurrentFilm = model; if (!String.IsNullOrEmpty(NextPage)) { return(Redirect(NextPage)); } ViewBag.Message = "The Title has been saved"; return(View("Title", model)); }
public FilmSubmission SaveFilm(FilmSubmission newFilm, List <string> altTitles, int userId) { FilmSubmission film = null; if (newFilm.FilmSubmissionId >= 1) { film = GetFilm(newFilm.FilmSubmissionId, newFilm.UserId); if (film == null) { return(null); } film.FilmTitle = newFilm.FilmTitle; film.Synopsis = newFilm.Synopsis.Trim().Replace("\r", ""); film.USFilmLocation = newFilm.USFilmLocation; film.CanadaFilmLocation = newFilm.CanadaFilmLocation; film.ForeignFilmLocation = newFilm.ForeignFilmLocation; film.IncludeOtherLanguage = newFilm.IncludeOtherLanguage; film.IsDistributedUnrated = newFilm.IsDistributedUnrated; film.DistributedUnrated = newFilm.DistributedUnrated; film.ModifiedDate = DateTime.Now; film.ModifiedBy = userId; _context.SaveChanges(); foreach (FilmAltTitle at in film.FilmAltTitles.ToList()) { _context.FilmAltTitles.Remove(at); } _context.SaveChanges(); foreach (string str in altTitles) { FilmAltTitle at = new FilmAltTitle { FilmSubmissionId = newFilm.FilmSubmissionId, AltTitle = str }; _context.FilmAltTitles.Add(at); _context.SaveChanges(); } } else { film = new FilmSubmission(); film.UserId = newFilm.UserId; film.FilmTitle = newFilm.FilmTitle; film.Synopsis = newFilm.Synopsis.Trim().Replace("\r", ""); film.USFilmLocation = newFilm.USFilmLocation; film.CanadaFilmLocation = newFilm.CanadaFilmLocation; film.ForeignFilmLocation = newFilm.ForeignFilmLocation; film.IncludeOtherLanguage = newFilm.IncludeOtherLanguage; film.IsDistributedUnrated = newFilm.IsDistributedUnrated; film.DistributedUnrated = newFilm.DistributedUnrated; film.CreatedDate = DateTime.Now; film.ModifiedDate = DateTime.Now; film.ModifiedBy = userId; _context.FilmSubmissions.Add(film); _context.SaveChanges(); foreach (string str in altTitles) { FilmAltTitle at = new FilmAltTitle { FilmSubmissionId = film.FilmSubmissionId, AltTitle = str }; _context.FilmAltTitles.Add(at); _context.SaveChanges(); } } return(film); }