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