// Method gets movie Id and type of movie person ("Actor", "Director" etc..) and return list of people public List<MoviePersonDTO> GetMoviePeopleByMovieId(int movieId, string personType) { using (var context = new CinemaEntities()) { var moviePeople = (from moviePerson in context.PersonMovies // where moviePerson.MovieID == movieId && moviePerson.Person.PersonType.Description.Contains("actor") where moviePerson.MovieID == movieId && moviePerson.Person.PersonType.Description == personType select moviePerson).ToList(); if (moviePeople.Count() > 0) { List<MoviePersonDTO> moviePeopleToReturn = new List<MoviePersonDTO>(); foreach (var item in moviePeople) { MoviePersonDTO moviePeopleRow = new MoviePersonDTO() { FirstName = item.Person.FirstName, LastName = item.Person.LastName, BirthDate = (DateTime)item.Person.BirthDate, BirthPlace = item.Person.BirthPlace }; moviePeopleToReturn.Add(moviePeopleRow); } return moviePeopleToReturn; } else { return null; } } }
//get list of for ddlProducerMovie MainMovie.aspx public List <MoviePersonDTO> GetProducers() { using (var context = new CinemaEntities()) { string cast = "producer"; var castmovie = (from moviePerson in context.PersonMovies where moviePerson.Person.PersonType.Description == cast select moviePerson).ToList(); if (castmovie.Count() > 0) { List <MoviePersonDTO> castPeopleToReturn = new List <MoviePersonDTO>(); foreach (var item in castmovie) { MoviePersonDTO castPeopleRow = new MoviePersonDTO() { FirstName = item.Person.FirstName + " " + item.Person.LastName, //Fiction for getting a person full name into a drop LastName = item.Person.LastName, // down list (Marat) }; castPeopleToReturn.Add(castPeopleRow); } return(castPeopleToReturn); } else { return(null); } } }
// Method gets movie Id and type of movie person ("Actor", "Director" etc..) and return list of people public List <MoviePersonDTO> GetMoviePeopleByMovieId(int movieId, string personType) { using (var context = new CinemaEntities()) { var moviePeople = (from moviePerson in context.PersonMovies // where moviePerson.MovieID == movieId && moviePerson.Person.PersonType.Description.Contains("actor") where moviePerson.MovieID == movieId && moviePerson.Person.PersonType.Description == personType select moviePerson).ToList(); if (moviePeople.Count() > 0) { List <MoviePersonDTO> moviePeopleToReturn = new List <MoviePersonDTO>(); foreach (var item in moviePeople) { MoviePersonDTO moviePeopleRow = new MoviePersonDTO() { FirstName = item.Person.FirstName, LastName = item.Person.LastName, BirthDate = (DateTime)item.Person.BirthDate, BirthPlace = item.Person.BirthPlace }; moviePeopleToReturn.Add(moviePeopleRow); } return(moviePeopleToReturn); } else { return(null); } } }
//get list of actors for ddlActorMovie MainMovie.aspx public List<MoviePersonDTO> GetActors() { using (var context = new CinemaEntities()) { string cast = "actor"; var listmoviePeople = (from moviePerson in context.PersonMovies where moviePerson.Person.PersonType.Description == cast select moviePerson).ToList(); if (listmoviePeople.Count() > 0) { List<MoviePersonDTO> moviePeopleToReturn = new List<MoviePersonDTO>(); foreach (var item in listmoviePeople) { MoviePersonDTO moviePeopleRow = new MoviePersonDTO() { FirstName = item.Person.FirstName + " " + item.Person.LastName, //Fiction for getting a person full name into a drop LastName = item.Person.LastName, // down list (Marat) }; moviePeopleToReturn.Add(moviePeopleRow); } return moviePeopleToReturn; } else { return null; } } }
private void GetPersonInfo(string firstName, string lastName) { MoviePeopleServices personInfo = new MoviePeopleServices(); List <MoviePersonDTO> writerToShow = new List <MoviePersonDTO>(); MoviePersonDTO writer = personInfo.GetMoviePersonByName(firstName + " " + lastName, "Writer"); Guid personId = personInfo.GetMoviePersonIdByFirstAndLastName(firstName, lastName); writerToShow.Add(writer); ShowPersonFullInfo(writerToShow, personId); }
//Method gets First Name or Last Name or Full Name or Part of the Name of the person and // person type ("actor", "director" etc..) and return the person's Data public MoviePersonDTO GetMoviePersonByName(string personName, string personType) { using (var context = new CinemaEntities()) { var allPeopleByType = (from person in context.People where person.PersonType.Description == personType select new { FullName = person.FirstName + " " + person.LastName, BirthDate = person.BirthDate, BirthPlace = person.BirthPlace, FirstName = person.FirstName, LastName = person.LastName }).ToList(); var foundPerson = (from person in allPeopleByType where person.FullName.ToLower().Contains(personName.ToLower()) select person).FirstOrDefault(); if (foundPerson != null) { MoviePersonDTO moviePersonToReturn = new MoviePersonDTO(); moviePersonToReturn.FirstName = foundPerson.FirstName; moviePersonToReturn.LastName = foundPerson.LastName; if (foundPerson.BirthDate == null) { DateTime unavailableDateOfBirth = DateTime.ParseExact("01/01/9999", "d/MM/yyyy", null); moviePersonToReturn.BirthDate = unavailableDateOfBirth; } else { moviePersonToReturn.BirthDate = (DateTime)foundPerson.BirthDate; } if (foundPerson.BirthPlace == null) { moviePersonToReturn.BirthPlace = "Unknown"; } else { moviePersonToReturn.BirthPlace = foundPerson.BirthPlace; } return(moviePersonToReturn); } else { return(null); } } }
private void WriterFoundByNameHandler() { MoviePeopleServices personInfo = new MoviePeopleServices(); List <MoviePersonDTO> writerToShow = new List <MoviePersonDTO>(); MoviePersonDTO writer = personInfo.GetMoviePersonByName(Request.QueryString["personToShow"].ToString(), "Writer"); if (writer != null) { Guid personId = personInfo.GetMoviePersonIdByFirstAndLastName(writer.FirstName, writer.LastName); writerToShow.Add(writer); ShowPersonFullInfo(writerToShow, personId); } }
private void ActorFoundByNameHandler() { MoviePeopleServices personInfo = new MoviePeopleServices(); List <MoviePersonDTO> actorToShow = new List <MoviePersonDTO>(); MoviePersonDTO actor = personInfo.GetMoviePersonByName(Request.QueryString["personToShow"].ToString(), "Actor"); if (actor != null) { Guid personId = personInfo.GetMoviePersonIdByFirstAndLastName(actor.FirstName, actor.LastName); actorToShow.Add(actor); ShowPersonFullInfo(actorToShow, personId); } }
// Method gets movie Id and type of movie person ("Actor", "Director" etc..) and return list of people public List <MoviePersonDTO> GetMoviePeopleByMovieId(int movieId, string personType) { using (var context = new CinemaEntities()) { var moviePeople = (from moviePerson in context.PersonMovies // where moviePerson.MovieID == movieId && moviePerson.Person.PersonType.Description.Contains("actor") where moviePerson.MovieID == movieId && moviePerson.Person.PersonType.Description == personType select moviePerson).ToList(); if (moviePeople.Count() > 0) { List <MoviePersonDTO> moviePeopleToReturn = new List <MoviePersonDTO>(); foreach (var item in moviePeople) { MoviePersonDTO moviePeopleRow = new MoviePersonDTO(); moviePeopleRow.FirstName = item.Person.FirstName; moviePeopleRow.LastName = item.Person.LastName; if (item.Person.BirthDate == null) { DateTime unavailableDateOfBirth = DateTime.ParseExact("01/01/9999", "d/MM/yyyy", null); moviePeopleRow.BirthDate = unavailableDateOfBirth; } else { moviePeopleRow.BirthDate = (DateTime)item.Person.BirthDate; } // moviePeopleRow.BirthDate = (DateTime)item.Person.BirthDate; if (item.Person.BirthPlace == null) { moviePeopleRow.BirthPlace = "Unknown"; } else { moviePeopleRow.BirthPlace = item.Person.BirthPlace; } moviePeopleToReturn.Add(moviePeopleRow); } return(moviePeopleToReturn); } else { return(null); } } }
// Method gets movie Id and type of movie person ("Actor", "Director" etc..) and return list of people public List<MoviePersonDTO> GetMoviePeopleByMovieId(int movieId, string personType) { using (var context = new CinemaEntities()) { var moviePeople = (from moviePerson in context.PersonMovies // where moviePerson.MovieID == movieId && moviePerson.Person.PersonType.Description.Contains("actor") where moviePerson.MovieID == movieId && moviePerson.Person.PersonType.Description == personType select moviePerson).ToList(); if (moviePeople.Count() > 0) { List<MoviePersonDTO> moviePeopleToReturn = new List<MoviePersonDTO>(); foreach (var item in moviePeople) { MoviePersonDTO moviePeopleRow = new MoviePersonDTO(); moviePeopleRow.FirstName = item.Person.FirstName; moviePeopleRow.LastName = item.Person.LastName; if (item.Person.BirthDate == null) { DateTime unavailableDateOfBirth = DateTime.ParseExact("01/01/9999", "d/MM/yyyy", null); moviePeopleRow.BirthDate = unavailableDateOfBirth; } else { moviePeopleRow.BirthDate = (DateTime)item.Person.BirthDate; } // moviePeopleRow.BirthDate = (DateTime)item.Person.BirthDate; if (item.Person.BirthPlace == null) { moviePeopleRow.BirthPlace = "Unknown"; } else { moviePeopleRow.BirthPlace = item.Person.BirthPlace; } moviePeopleToReturn.Add(moviePeopleRow); } return moviePeopleToReturn; } else { return null; } } }
private void ShowPersonFullInfo(MoviePersonDTO personToShow, Guid personId) { lblFirstName.Text += " " + personToShow.FirstName; lblLastName.Text += " " + personToShow.LastName; lblBirthPlace.Text += " " + personToShow.BirthPlace; lblOccupation.Text += " " + Request.QueryString["personType"]; DateTime birthDate = personToShow.BirthDate; string result = birthDate.ToString("d/MM/yyyy"); if (result == "1/01/9999") { result = "Unknown"; } lblBirthDate.Text += " " + result; //GetAppropriateView(actorFoundByName); ImgPersonPhoto.ImageUrl = String.Format("~/ContentPages/MoviePeople/MoviePeopleUserControls/MoviePersonPhoto.ashx?personId=" + personId); }
private void DirectorFoundByNameHandler() { MoviePeopleServices personInfo = new MoviePeopleServices(); List <MoviePersonDTO> directorToShow = new List <MoviePersonDTO>(); MoviePersonDTO director = personInfo.GetMoviePersonByName(Request.QueryString["personToShow"].ToString(), "Director"); if (director != null) { Guid personId = personInfo.GetMoviePersonIdByFirstAndLastName(director.FirstName, director.LastName); directorToShow.Add(director); ShowPersonFullInfo(directorToShow, personId); //GridView directorFoundByName = new GridView(); //directorFoundByName = PeopleInMovie1.gridPeopleInMovie; //directorFoundByName.DataSource = directorToShow; //directorFoundByName.DataBind(); //GetAppropriateView(directorFoundByName); //PeopleInMovie1.PersonImage.ImageUrl = String.Format("~/ContentPages/MoviePeople/MoviePeopleUserControls/MoviePersonPhoto.ashx?personId=" + personId); } //actorToShow.Add(Request.QueryString["personToShow"]); }
//Method gets First Name or Last Name or Full Name or Part of the Name of the person and // person type ("actor", "director" etc..) and return the person's Data public MoviePersonDTO GetMoviePersonByName(string personName, string personType) { using (var context = new CinemaEntities()) { var allPeopleByType = (from person in context.People where person.PersonType.Description == personType select new { FullName = person.FirstName + " " + person.LastName, BirthDate = person.BirthDate, BirthPlace = person.BirthPlace, FirstName = person.FirstName, LastName = person.LastName }).ToList(); var foundPerson = (from person in allPeopleByType where person.FullName.ToLower().Contains(personName.ToLower()) select person).FirstOrDefault(); if (foundPerson != null) { MoviePersonDTO moviePersonToReturn = new MoviePersonDTO(); moviePersonToReturn.FirstName = foundPerson.FirstName; moviePersonToReturn.LastName = foundPerson.LastName; if (foundPerson.BirthDate == null) { DateTime unavailableDateOfBirth = DateTime.ParseExact("01/01/9999", "d/MM/yyyy", null); moviePersonToReturn.BirthDate = unavailableDateOfBirth; } else { moviePersonToReturn.BirthDate = (DateTime)foundPerson.BirthDate; } if (foundPerson.BirthPlace == null) { moviePersonToReturn.BirthPlace = "Unknown"; } else { moviePersonToReturn.BirthPlace = foundPerson.BirthPlace; } return moviePersonToReturn; } else { return null; } } }