public IActionResult UpdateFilm(int filmid) { FilmItem film = context.Films.Where(f => f.FilmId == filmid).FirstOrDefault(); ViewBag.film = film; return(View()); }
public static FilmItem AddFilmItem(string text, int id, string Category) { bool check2 = false; var attach = Registration.unit.Attachments.Get(a => a.FilmsId == id && a.UsersID == user.Id).FirstOrDefault(); FilmItem item = new FilmItem(text, id, check2, user.Id) { Margin = new Thickness(10, 10, 10, 0), HorizontalAlignment = HorizontalAlignment.Stretch }; if (Category == "TopFilms") { sp_TopFilms.Children.Add(item); } if (Category == "NewFilms") { sp_NewFilms.Children.Add(item); } if (attach != null) { FilmItem item2 = new FilmItem(text, id, true, user.Id) { Margin = new Thickness(10, 10, 10, 0), HorizontalAlignment = HorizontalAlignment.Stretch }; if (attach.FavoriteFilm == true) { sp_MyFilms.Children.Add(item2); } } return(item); }
public static List <Episode> GetRecentlyAiredEpisodes(MovieContext _ctx, FilmItem item) { var threeRecentEpisodes = _ctx.Episodes.Where(e => e.Discriminator == "Episode") .Where(e => e.Slug == item.Slug) .OrderByDescending(e => e.ReleaseDate) .Take(3) .ToList(); return(threeRecentEpisodes); }
public static void SaveFilmItemCredits(MovieContext _ctx, FilmItem filmItem, Person person, int partType, string character) { character = (string.IsNullOrWhiteSpace(character) ? null : character); var personAlreadyCreditedInDepartment = _ctx.FilmItemCredits.Where(p => p.Person == person).Where(f => f.FilmItem == filmItem).Where(fic => fic.PartType == (PartType)partType).FirstOrDefault(); if (personAlreadyCreditedInDepartment == null) { SaveFilmItemMember(_ctx, filmItem, person, partType, character); } }
private void AddFilm(int id, MigrationBuilder migrationBuilder, GetRequest <FilmItem> client) { FilmItem film = client.GetById(id).GetAwaiter().GetResult(); migrationBuilder.InsertData( table: "Films", columns: new string[] { "id", "title", "opening_crawl", "director", "producer", "release_date", }, values: new object[] { id, film.title, film.opening_crawl, film.director, film.producer, film.release_date } ); }
public static void SaveFilmItemGenres(MovieContext _ctx, FilmItem filmItem, string genre) { FilmItemGenre sg = new FilmItemGenre() { FilmItem = filmItem, GenreId = Int32.Parse(genre) }; _ctx.FilmItemGenres.Add(sg); _ctx.SaveChanges(); }
public void AddFilmItemToHistory(FilmItem filmItem, string user, DateTime watchedOnDate) { UserWatchedFilmItemOn userWatchedOn = new UserWatchedFilmItemOn { ApplicationUserId = user, FilmItem = filmItem, WatchedOn = watchedOnDate }; _context.UserWatching.Add(userWatchedOn); _context.SaveChanges(); }
public IActionResult FilmSubmission(FilmItem film) { if (ModelState.IsValid) { context.Films.Add(film); context.SaveChanges(); return(View("Confirmation", film)); } else { return(View()); } }
public static void SaveFilmItemMember(MovieContext _ctx, FilmItem filmItem, Person person, int partType, string character) { FilmItemCredits fic = new FilmItemCredits { FilmItem = filmItem, Person = person, Character = character, PartType = (PartType)partType }; _ctx.FilmItemCredits.Add(fic); _ctx.SaveChanges(); }
public static int ListHavingFilmItem(List <List> lists, FilmItem filmItem) { var listsHavingFilmItem = 0; foreach (var list in lists) { foreach (var listItem in list.ListItems) { if (listItem.FilmItemId == filmItem.Id) { listsHavingFilmItem++; } } } return(listsHavingFilmItem); }
public void AddFilmItemChildrenToHistory(FilmItem item, string user, DateTime watchedOnDate) { var filmItemChildren = new List <FilmItem>(); if (item.Discriminator == "Series") { filmItemChildren = _context.FilmItem.Where(f => f.Slug == item.Slug).ToList(); } else if (item.Discriminator == "Season") { filmItemChildren = _context.FilmItem.Where(f => f.Slug == item.Slug).Where(f => f.Season_SeasonNumber == item.Season_SeasonNumber || f.Episode_SeasonNumber == item.Season_SeasonNumber).ToList(); } foreach (var filmItemChild in filmItemChildren) { AddFilmItemToHistory(filmItemChild, user, watchedOnDate); } }
public void AlterFilmItemAverage(FilmItem filmItem, int rating) { _context.Attach(filmItem); if (filmItem.VoteCount == null && filmItem.VoteAverage == null) { filmItem.VoteCount = 1; filmItem.VoteAverage = rating; } else { var totalRating = filmItem.VoteAverage * filmItem.VoteCount; filmItem.VoteCount++; filmItem.VoteAverage = (totalRating + rating) / filmItem.VoteCount; } filmItem.UpdatedAt = DateTime.Now; _context.SaveChanges(); }
public IActionResult UpdateFilm(FilmItem film, int filmid) { if (ModelState.IsValid) { context.Films.Where(f => f.FilmId == filmid).FirstOrDefault().Title = film.Title; context.Films.Where(f => f.FilmId == filmid).FirstOrDefault().Year = film.Year; context.Films.Where(f => f.FilmId == filmid).FirstOrDefault().Director = film.Director; context.Films.Where(f => f.FilmId == filmid).FirstOrDefault().Rating = film.Rating; context.Films.Where(f => f.FilmId == filmid).FirstOrDefault().Edited = film.Edited; context.Films.Where(f => f.FilmId == filmid).FirstOrDefault().LentTo = film.LentTo; context.Films.Where(f => f.FilmId == filmid).FirstOrDefault().Notes = film.Notes; context.SaveChanges(); return(View("UpdateConfirm", film)); } else { return(View()); } }
public void CalculateFilmItemAverageAfterDeletion(FilmItem filmItem, int rating) { _context.Attach(filmItem); if (filmItem.VoteCount == 1) { filmItem.VoteCount = null; filmItem.VoteAverage = null; } else { var totalRating = filmItem.VoteAverage * filmItem.VoteCount; filmItem.VoteCount--; filmItem.VoteAverage = (totalRating - rating) / filmItem.VoteCount; } filmItem.UpdatedAt = DateTime.Now; _context.SaveChanges(); }
public static void AddMediaEntry(MovieContext _ctx, FilmItem item = null, Person person = null) { if (item != null) { Media media = new Media { FilmItem = item }; _ctx.Media.Add(media); } else if (person != null) { Media media = new Media { Person = person }; _ctx.Media.Add(media); } _ctx.SaveChanges(); }
public static void SaveListItem(MovieContext _ctx, List list, FilmItem filmItem) { var filmItemAlreadyInList = _ctx.ListItems.Where(l => l.List == list).Where(f => f.FilmItem == filmItem).FirstOrDefault(); if (filmItem != null && filmItemAlreadyInList == null) { ListItem li = new ListItem() { FilmItem = filmItem, List = list }; _ctx.ListItems.Add(li); _ctx.SaveChanges(); _ctx.Lists.Attach(list); list.ItemCount++; list.UpdatedAt = DateTime.Now; _ctx.SaveChanges(); } }
public static void AddInfo(UIElement item, int id, string text) { var attach = Registration.unit.Attachments.Get(a => a.FilmsId == id && a.UsersID == user.Id).FirstOrDefault(); sp_TopFilms.Children.Clear(); sp_NewFilms.Children.Clear(); sp_MyFilms.Children.Clear(); bool check = true; FilmItem info = new FilmItem(text, id, check, user.Id) { Margin = new Thickness(10, 30, 10, 0), HorizontalAlignment = HorizontalAlignment.Stretch, VerticalAlignment = VerticalAlignment.Bottom }; if (text == "TopFilms") { sp_TopFilms.Children.Add(info); } if (text == "NewFilms") { sp_NewFilms.Children.Add(info); } if (attach != null) { FilmItem info2 = new FilmItem(text, id, true, user.Id) { Margin = new Thickness(10, 30, 10, 0), HorizontalAlignment = HorizontalAlignment.Stretch, VerticalAlignment = VerticalAlignment.Bottom }; if (attach.FavoriteFilm == true) { sp_MyFilms.Children.Add(info2); } } }
public IActionResult AddReview() { var applicationUser = _userManager.GetUserId(User); int? reviewId, listId, filmItemId; FilmItem filmItem = new FilmItem(); if (!string.IsNullOrWhiteSpace(Request.Form["ReviewId"])) { reviewId = int.Parse(Request.Form["ReviewId"]); } else { reviewId = null; } if (!string.IsNullOrWhiteSpace(Request.Form["ListId"])) { listId = int.Parse(Request.Form["ListId"]); } else { listId = null; } if (!string.IsNullOrWhiteSpace(Request.Form["FilmItemId"])) { filmItemId = int.Parse(Request.Form["FilmItemId"]); filmItem = _context.FilmItem.FirstOrDefault(f => f.Id == int.Parse(Request.Form["FilmItemId"])); } else { filmItemId = null; } Review review = new Review { ApplicationUserId = applicationUser, FilmItemId = filmItemId, Comment = Request.Form["Comment"], ShoutId = reviewId, ListId = listId }; _context.Reviews.Add(review); _context.SaveChanges(); if (listId != null) { var list = _context.Lists.FirstOrDefault(l => l.Id == listId); var user = _userManager.Users.FirstOrDefault(u => u.Id == list.ApplicationUserId); return(RedirectToAction("Comments", "List", new { Slug = user, listName = list.Slug })); } if (filmItem.Discriminator == "Season") { return(RedirectToAction("Details", filmItem.Discriminator, new { Slug = filmItem.Slug, SeasonNumber = filmItem.Season_SeasonNumber })); } else if (filmItem.Discriminator == "Episode") { return(RedirectToAction("Details", filmItem.Discriminator, new { Slug = filmItem.Slug, SeasonNumber = filmItem.Episode_SeasonNumber, EpisodeNumber = filmItem.Episode_EpisodeNumber })); } else { return(RedirectToAction("Details", filmItem.Discriminator, new { Slug = filmItem.Slug })); } }