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