internal void deleteMovie() { var db = new ImdbContext(); db.Database.EnsureCreated(); foreach (var movie in db.Movies) { Console.WriteLine("ID: " + movie.Id + " " + movie.Name); } Console.WriteLine("Napiš id filmu"); string idMovie = Console.ReadLine(); var movieDb = db.Movies.FirstOrDefault(x => x.Id == int.Parse(idMovie)); Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("Úspěšně jsi smazal film: " + movieDb.Name); Console.ResetColor(); db.Movies.Remove(movieDb); db.SaveChanges(); Console.BackgroundColor = ConsoleColor.Red; Console.WriteLine("STISKNI ENTER PRO DALŠÍ POUŽÍVÁNÍ PROGRAMU"); Console.ResetColor(); }
public List <Person> GetPerson(string id) { using var ctx = new ImdbContext(); var query = ctx.Person.Where(person => person.Id == id); return(query.ToList()); }
//GET USERS PERSON BOOKMARK LIST public List <Person_Bookmark_list> GetPersonBookmarkList(int id) { using var ctx = new ImdbContext(); var x = ctx.person_bookmark_list.Where(x => x.Id == id); return(x.ToList()); }
internal void AddMovie() { var db = new ImdbContext(); db.Database.EnsureCreated(); Console.WriteLine("\r\nNapiš název filmu"); string jmenoFilmu = Console.ReadLine(); if (jmenoFilmu != "") { Console.WriteLine("\r\nHodnocení filmu 0-100b"); string ratingMovie = Console.ReadLine(); int result; if (int.TryParse(ratingMovie, out result) || ratingMovie == "") { if (Int32.Parse(ratingMovie) >= 0 && Int32.Parse(ratingMovie) <= 100 || ratingMovie == "") { Console.WriteLine("\r\nPopis filmu"); string descriptionMovie = Console.ReadLine(); Console.WriteLine("\r\nOdkaz na film"); string urlMovie = Console.ReadLine(); db.Movies.Add(new Movie() { Name = jmenoFilmu, Description = descriptionMovie, Rating = Int32.Parse(ratingMovie), Link = urlMovie, }); Console.ForegroundColor = ConsoleColor.Cyan; Console.WriteLine("\r\nGratuluji přidal jsi film jménem: " + jmenoFilmu); Console.ResetColor(); db.SaveChanges(); } else { Console.WriteLine("Jejda chyba, zkus to znovu."); Console.BackgroundColor = ConsoleColor.Red; Console.WriteLine("STISKNI ENTER PRO DALŠÍ POUŽÍVÁNÍ PROGRAMU"); Console.ResetColor(); } } else { Console.WriteLine("Jejda chyba, zkus to znovu."); Console.BackgroundColor = ConsoleColor.Red; Console.WriteLine("STISKNI ENTER PRO DALŠÍ POUŽÍVÁNÍ PROGRAMU"); Console.ResetColor(); } } else { Console.WriteLine("Jejda chyba, zkus to znovu."); Console.BackgroundColor = ConsoleColor.Red; Console.WriteLine("STISKNI ENTER PRO DALŠÍ POUŽÍVÁNÍ PROGRAMU"); Console.ResetColor(); } }
internal void changeDescription() { var db = new ImdbContext(); db.Database.EnsureCreated(); foreach (var movie in db.Movies) { Console.WriteLine("ID: " + movie.Id + " " + movie.Name); } Console.WriteLine("\r\nNapiš id filmu u kterého chceš změnit popis"); string idName = Console.ReadLine(); var movieDb = db.Movies.SingleOrDefault(x => x.Id == int.Parse(idName)); Console.WriteLine("Napiš nový popis: "); string newDescription = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("Úspěšně jsi změnil popis filmu : " + movieDb.Description + " na " + newDescription); Console.ResetColor(); movieDb.Description = newDescription; db.SaveChanges(); Console.BackgroundColor = ConsoleColor.Red; Console.WriteLine("STISKNI ENTER PRO DALŠÍ POUŽÍVÁNÍ PROGRAMU"); Console.ResetColor(); }
//GET TITLE BOOKMARKS public List <Title_Bookmark> GetTitleBookmarks(int id) { using var ctx = new ImdbContext(); var query = ctx.title_bookmarks.Where(x => x.Id == id); return(query.ToList()); }
public Title GetTitle(string id) { using var ctx = new ImdbContext(); var query = ctx.title.Find(id); return(query); }
internal void AddActor() { var db = new ImdbContext(); db.Database.EnsureCreated(); Console.WriteLine("\r\nNapiš jméno Herce"); string jmenoHerce = Console.ReadLine(); if (jmenoHerce != "") { db.Actors.Add(new Actor() { Name = jmenoHerce }); Console.ForegroundColor = ConsoleColor.Cyan; Console.WriteLine("\r\nÚspěšně byl přidát herec/čka: " + jmenoHerce); Console.ResetColor(); db.SaveChanges(); } else { Console.WriteLine("\r\nJejda chyba, zkus to znovu."); Console.BackgroundColor = ConsoleColor.Red; Console.WriteLine("STISKNI ENTER PRO DALŠÍ POUŽÍVÁNÍ PROGRAMU"); Console.ResetColor(); } }
//GET SINGLE RATED MOVIE FROM USER (FOR DELETE) public Rating GetMovieRatingFromUser(int userid, string titleid) { using var ctx = new ImdbContext(); var x = ctx.rating.FirstOrDefault(r => r.User_Id == userid && r.Title_Id == titleid); return(x); }
///////////////////////////////////////////////////////////////////// /////////////// NOT YET IMPLEMENTED IN THE DATA SERVICE ///////////// ///////////////////////////////////////////////////////////////////// //GET LIST OF THE USERS SEARCH HISTORY public IList <Search_History> GetSearchHistories(int userid) { using var ctx = new ImdbContext(); var x = ctx.search_history.Where(s => s.User_Id == userid); return(x.ToList()); }
//GET LIST OF THE USERS RATED MOVIES ... DELETE USERS RATING public IList <Rating> GetRatingFromUsers(int userid) { using var ctx = new ImdbContext(); var x = ctx.rating.Where(r => r.User_Id == userid); return(x.ToList()); }
public IList <Title> GetTitles() { using var ctx = new ImdbContext(); var query = ctx.title.ToList(); return(query); }
//CHECK IF AN EMAIL IS AN EMAIL && DOESNT EXISTS IN THE DB private static bool IsValidEmail(string email) { using var ctx = new ImdbContext(); var emailTrimed = email.Trim(); if (string.IsNullOrEmpty(emailTrimed)) { return(false); } var hasWhitespace = emailTrimed.Contains(" "); var indexOfAtSign = emailTrimed.LastIndexOf('@'); if (indexOfAtSign <= 0 || hasWhitespace) { return(false); } var afterAtSign = emailTrimed.Substring(indexOfAtSign + 1); var indexOfDotAfterAtSign = afterAtSign.LastIndexOf('.'); var query = ctx.users.Where(x => x.Email == email).ToList(); if (query.Count > 0) { return(false); } return(indexOfDotAfterAtSign > 0 && afterAtSign.Substring(indexOfDotAfterAtSign).Length > 1); }
public IQueryable <Person> GetPersonBySubstring(string substring) { var ctx = new ImdbContext(); var query = ctx.Person.Where(x => x.Name.Contains(substring)); return(query); }
internal void listActorMovies() { var db = new ImdbContext(); db.Database.EnsureCreated(); foreach (var actor in db.Actors) { Console.WriteLine("ID: " + actor.Id + " " + actor.Name); } Console.WriteLine("Napiš id herce"); string idActor = Console.ReadLine(); var n = _context.ActorMovie.Include(x => x.Movie).Where(x => x.ActorId == int.Parse(idActor)).Select(x => new { x.Movie.Name }); if (n != null) { int i = 0; Console.WriteLine("Tento herec hrál ve filmu:"); foreach (var moviePlay in n) { i++; Console.WriteLine(i + ". " + moviePlay.Name); } } else { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("\r\nTento herec nehrál v žádném filmu z databáze, jaká škoda.."); Console.ResetColor(); Console.BackgroundColor = ConsoleColor.Red; Console.WriteLine("STISKNI ENTER PRO DALŠÍ POUŽÍVÁNÍ PROGRAMU"); Console.ResetColor(); } }
public IList <Title_Search> TitleSearches(string titleid) { using var ctx = new ImdbContext(); var query = ctx.title_search .Where(s => s.Id.Equals(titleid)); return(query.ToList()); }
public TitleType GetType(int id) { using var ctx = new ImdbContext(); var query = ctx.type.FirstOrDefault(x => x.Id == id); return(query); }
public List <TitleType> GetAllTypes() { using var ctx = new ImdbContext(); var query = ctx.type.ToList(); return(query); }
public Title getTitleEpisode(string id) { using var ctx = new ImdbContext(); var query = ctx.title.Where(x => x.Id == id) .Include(x => x.TitleEpisode).FirstOrDefault(); return(query); }
//GET A LIST OF PERSON BOOKMARKS (USED FOR DELETE) public IList <Person_Bookmark> GetPersonBookmarks(int listid) { using var ctx = new ImdbContext(); var x = ctx.person_bookmarks .Where(x => x.List_Id == listid) .ToList(); return(x); }
public List <Akas> GetTitleAkas(string id) { using var ctx = new ImdbContext(); var query = ctx.akas .Where(x => x.TitleId == id) .ToList(); return(query); }
//FOR ABOVE METHOD, MADE BCS OF AN ERROR; /* * The instance of entity type 'Rating' cannot be tracked because another * instance with the key value '{Id: x}' is already being tracked */ public bool DeleteRatingFromDB(int userid, string titleid) { using var ctx = new ImdbContext(); var dbRating = GetMovieRatingFromUser(userid, titleid); ctx.Remove(dbRating); ctx.SaveChanges(); return(true); }
// // PERSON BOOKMARKS // //GET USERS PERSON BOOKMARK LIST public List <Person_Bookmark_list> GetUsersPersonBookmarkLists(int userid) { using var ctx = new ImdbContext(); var x = ctx.person_bookmark_list .Where(b => b.User_Id == userid) .ToList(); return(x); }
private static void registerServices(IUnityContainer container) { ImdbContext context = new ImdbContext(); container.RegisterType <IPersonRepository, PersonRepository>(new InjectionConstructor(context)); container.RegisterType <IProducerRepository, ProducerRepository>(new InjectionConstructor(context)); container.RegisterType <IActorRepository, ActorRepository>(new InjectionConstructor(context)); container.RegisterType <IMovieRepository, MovieRepository>(new InjectionConstructor(context)); }
public List <Person_known_title> GetPersonKnownTitles(string id) { using var ctx = new ImdbContext(); var query = ctx.PersonKnownTitles .Include(x => x.person) .Where(c => c.person.Id == id); return(query.ToList()); }
public static ValidationResult CheckId(string id, ValidationContext ctx) { var db = new ImdbContext("Data Source = (localdb)\\MSSQLLocalDB; Initial Catalog = Imdb; Integrated Security = True; Connect Timeout = 30; Encrypt = False; TrustServerCertificate = True; ApplicationIntent = ReadWrite; MultiSubnetFailover = False"); if (db.Movies.Any(m => m.MovieId == id)) { return(new ValidationResult("Filmen er allerede registrert")); } return(ValidationResult.Success); }
public IList <Title_Person> getTitlePersons(string id) { using var ctx = new ImdbContext(); var query = ctx.TitlePersons .Where(x => x.TitleId == id) .ToList(); return(query); }
public IList <Title_Genre> GetTitleGenres(string id) { using var ctx = new ImdbContext(); var query = ctx.title_genre .Include(x => x.Genre) .Where(x => x.TitleId == id) .ToList(); return(query); }
public Title getTitlePersonName(string id) { using var ctx = new ImdbContext(); var query = ctx.title .Include(x => x.TitlePersons) .ThenInclude(x => x.Person) .FirstOrDefault(x => x.Id == id); return(query); }
public Akas GetAkas(int id) { using var ctx = new ImdbContext(); var query = ctx.akas .Where(x => x.Id == id) .Include(x => x.AkasType) .FirstOrDefault(); return(query); }