public void NavigateToMovie(string movieName)
{
//Navigate to the chosen Movie where the name is equal to the Movie-title the user clicked on
int movieId = MovieCast.Where(x => x.name == movieName).Single().id;
NavigationService.Navigate(typeof(MoviePage), movieId);
}
public override async Task OnNavigatedToAsync(object parameter, NavigationMode mode, IDictionary <string, object> state)
{
//Create service and ask information from the API
var personID = (int)parameter;
var service = new MovieService();
Person = await service.GetPersonAsync(personID);
var seriesCast = await service.GetSeriesCredits(personID);
var movieCast = await service.GetMovieCredits(personID);
//Forge the string Alias with the help of the also_known_as array of Person
Alias = "Aliases: ";
for (int i = 0; i < Person.also_known_as.Length; i++)
{
Alias = Alias + ", " + Person.also_known_as[i];
}
//Add movies and series to the Lists
foreach (var item in movieCast.cast)
{
MovieCast.Add(item);
}
foreach (var item in seriesCast.cast)
{
SeriesCast.Add(item);
}
await base.OnNavigatedToAsync(parameter, mode, state);
}
public async Task <IActionResult> PutMovieCast([FromRoute] int id, [FromBody] MovieCast movieCast)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != movieCast.id)
{
return(BadRequest());
}
_context.Entry(movieCast).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MovieCastExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
//Beérkezésre mi történik
public override async Task OnNavigatedToAsync(
object parameter, NavigationMode mode, IDictionary <string, object> state)
{
var movieID = (int)parameter;
//Film részletes adatainak letöltése, és listába kötése
var service = new MovieService();
Movie = await service.GetExactMovieAsync(movieID);
var movieGroups = await service.GetRecommendationMoviesAsync(movieID);
foreach (var item in movieGroups.results)
{
MovieList.Add(item);
}
//Filmhez tartozó emberek betöltése és listába kötése
var personService = new PersonService();
MoviePeople = await personService.GetMoviePeopleAsync(movieID);
foreach (var item in MoviePeople.crew)
{
MovieCrew.Add(item);
}
foreach (var item in MoviePeople.cast)
{
MovieCast.Add(item);
}
await base.OnNavigatedToAsync(parameter, mode, state);
}
public bool AddMovieCast(int movieId, int personId, string personRole)
{
var movieCast = new MovieCast {
MovieId = movieId, PersonId = personId, Role = personRole
};
return(_repsitory.AddMovieCast(movieCast));
}
public bool RemoveMovieCast([FromBody] MovieCastModel newMovieCastModel)
{
var movieCast = new MovieCast {
MovieId = newMovieCastModel.MovieId, PersonId = newMovieCastModel.PersonId, Role = newMovieCastModel.Role
};
return(_repsitory.RemoveMovieCast(movieCast));
}
public IActionResult Create(MovieCast movieCast)
{
if (!UserIsInRole(UserTypeEnum.Admin))
{
return(Unauthorized("You are not in role to permit this action"));
}
_service.Insert(movieCast);
return(Ok(movieCast));
}
public async Task <IActionResult> PostMovieCast([FromBody] MovieCast movieCast)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.MovieCasts.Add(movieCast);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetMovieCast", new { id = movieCast.id }, movieCast));
}
async Task DeleteMovieCastAsync()
{
Console.Write("Enter Movie Id = ");
int id = Convert.ToInt32(Console.ReadLine());
MovieCast mc = await mcService.GetByIdAsync(id);
if (await mcService.DeleteMovieCastAsync(id) > 0)
{
Console.WriteLine($"Movie Id: {id} deleted");
}
else
{
Console.WriteLine("Some error occurred");
}
}
void DeleteMovieCast()
{
MovieCast movieCast = new MovieCast();
Console.WriteLine("Enter MovieCast Id to delete");
movieCast.Id = Console.ReadLine();
if (movieCastServices.Delete(movieCast) > 0)
{
Console.WriteLine("MovieCast removed");
}
else
{
Console.WriteLine("Error removing movieCast");
}
}
void DeleteMovieCast()
{
Console.Write("Enter Movie Id = ");
int id = Convert.ToInt32(Console.ReadLine());
MovieCast mc = movieCastService.GetById(id);
if (movieCastService.DeleteMovieCast(mc.MovieId) > 0)
{
Console.WriteLine($"MovieCast {mc.Character} deleted successfully");
}
else
{
Console.WriteLine("Some error has occurred");
}
}
void AddMovieCast()
{
MovieCast movieCast = new MovieCast();
Console.WriteLine("Enter MovieCast MovieId to add");
movieCast.MovieId = Console.ReadLine();
if (movieCastServices.Insert(movieCast) > 0)
{
Console.WriteLine("MovieCast added");
}
else
{
Console.WriteLine("Error adding movieCast");
}
}
void PrintById()
{
Console.Write("Enter Movie Id = ");
int id = Convert.ToInt32(Console.ReadLine());
MovieCast mc = movieCastService.GetById(id);
if (mc != null)
{
Console.WriteLine(mc.MovieId + " \t " + mc.CastId + " \t " + mc.Character);
}
else
{
Console.WriteLine("Cannot find selected MovieCast");
}
}
void DeleteMovieCast()
{
Console.Write("Enter Movie Id = ");
int id = Convert.ToInt32(Console.ReadLine());
MovieCast mc = mcService.GetById(id);
if (mcService.DeleteMovieCast(id) > 0)
{
Console.WriteLine($"Movie Id: {id} deleted");
}
else
{
Console.WriteLine("Some error occurred");
}
}
void UpdateMovieCast()
{
MovieCast movieCast = new MovieCast();
Console.WriteLine("Enter MovieCast Id to update");
movieCast.Id = Console.ReadLine();
if (movieCastServices.Update(movieCast) > 0)
{
Console.WriteLine("MovieCast updated");
}
else
{
Console.WriteLine("Error updating movieCast");
}
}
public async Task PrintByIdAsync()
{
Console.Write("Enter Movie Id = ");
int id = Convert.ToInt32(Console.ReadLine());
MovieCast mc = await mcService.GetByIdAsync(id);
if (mc != null)
{
Console.WriteLine(mc.MovieId + "\t" + mc.CastId + "\t" + mc.Character);
}
else
{
Console.WriteLine("Cannot find Movie Id");
}
}
//Insert MovieId and ActorId to MovieCast table
private void ProcessMovieCast(List <int> actorIdList, int movieid)
{
foreach (int actorid in actorIdList)
{
MovieCast movieCastModel = db.MovieCast.Where(a => a.ActorId.Equals(actorid)).Where(a => a.MovieId.Equals(movieid)).FirstOrDefault();
if (movieCastModel == null)
{
movieCastModel = new MovieCast();
movieCastModel.ActorId = actorid;
movieCastModel.MovieId = movieid;
db.MovieCast.Add(movieCastModel);
db.SaveChanges();
}
}
}
void UpdateMovieCast()
{
MovieCast mc = new MovieCast();
Console.Write("Enter Movie Id = ");
mc.MovieId = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter Cast Id = ");
mc.CastId = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter Character Name = ");
mc.Character = Console.ReadLine();
if (movieCastService.UpdateMovieCast(mc) > 0)
{
Console.WriteLine("MovieCast Updated successfully");
}
else
{
Console.WriteLine("Some error has occurred");
}
}
async Task UpdateMovieCastAsync()
{
MovieCast mc = new MovieCast();
Console.Write("Enter Movie Id = ");
mc.MovieId = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter Cast Id = ");
mc.CastId = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter Cast Character = ");
mc.Character = Console.ReadLine();
if (await mcService.UpdateMovieCastAsync(mc) > 0)
{
Console.WriteLine("Cast added successfully");
}
else
{
Console.WriteLine("Some error occurred");
}
}
public bool Update(MovieCast movieCast)
{
_repository.Update(movieCast);
return(_repository.SaveChanges());
}
public int AddMovieCast(MovieCast item)
{
return(mcRepository.Insert(item));
}
public async Task <int> Insert(MovieCast item)
{
return(await movieCastRepository.Insert());
}
public Task <int> UpdateMovieCastAsync(MovieCast item)
{
return(mcRepository.UpdateAsync(item));
}
public async Task <int> Insert(MovieCast item)
{
using (SqlConnection connection = new SqlConnection(DbHelper.ConnectionString)) {
return(connection.Execute("insert into MovieCast values (@MovieId, @CastId, @Character)", item));
}
}
public async Task <int> Update(MovieCast item)
{
using (SqlConnection connection = new SqlConnection(DbHelper.ConnectionString)) {
return(connection.QueryFirstOrDefault <MovieCast>("Update MovieCast set from MovieCast where MovieId=@MovieId", new { id = id }));
}
}
public int UpdateMovieCast(MovieCast item)
{
return(mcRepository.Update(item));
}
public async Task <int> Update(MovieCast item)
{
return(await movieCastRepository.Update());
}
/*public IEnumerable<MovieCast> GetMovieCastAllWithMovieCast()
* {
* return mcRepository.GetAllWith();
* }
* public IEnumerable<MovieCast> GetMovieCastByIdWithMovieCast(int id)
* {
* return mcRepository.GetByIdWith(id);
* }*/
// async
public Task <int> AddMovieCastAsync(MovieCast item)
{
return(mcRepository.InsertAsync(item));
}
public bool Insert(MovieCast movieCast)
{
_repository.Create(movieCast);
return(_repository.SaveChanges());
}
