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