public IList<PerformanceModelDTO> GetPerformances(Guid theaterId)
{
IList<PerformanceModelDTO> performancesList = new List<PerformanceModelDTO>();
using (var context = new CinemaEntities())
{
var performances = (from performance in context.Perfomances.Include("Room")
where performance.TheaterID == theaterId
select performance).ToList();
foreach (var perform in performances)
{
var performanceRow = new PerformanceModelDTO();
performanceRow.PerformanceID = perform.PerfomanceID;
string date = perform.Date.ToString("yyyy'/'MM'/'dd");
performanceRow.Date = date;//(DateTime)perform.Date;
TimeSpan time = (TimeSpan)perform.StartingTime;
performanceRow.StartingTime = string.Format("{0:hh\\:mm}", time);// (TimeSpan)perform.StartingTime;
performanceRow.Title = perform.Movie.Title;
performanceRow.Price = perform.Price;
performanceRow.RoomNumber = perform.Room.RoomNumber;
performanceRow.Duration = perform.Duration; ;
performancesList.Add(performanceRow);
}
}
return performancesList;
}
public List<MovieModelDTO> GetAllGenres()
{
using (var context = new CinemaEntities())
{
var allGenre = (from genre in context.Genres
select new
{
GenreName = genre.Name
}).ToList();
List<MovieModelDTO> allGenresToReturn = new List<MovieModelDTO>();
if (allGenre != null)
{
foreach (var item in allGenre)
{
MovieModelDTO genreRow = new MovieModelDTO()
{
GenreName = item.GenreName
};
allGenresToReturn.Add(genreRow);
}
return allGenresToReturn;
}
else
{
return null;
}
}
}
//Method that gets all Comments of specific user
public IList<UserCommentDTO> GetAllUserComments(System.Guid userID)
{
IList<UserCommentDTO> ListOfComments = new List<UserCommentDTO>();
using (var context = new CinemaEntities())
{
var results = (from com in context.Comments.Include("Movie")
where com.UserID == userID
select com);
if (results!=null)
{
foreach (var item in results)
{
UserCommentDTO row = new UserCommentDTO();
row.userID = userID.ToString();
row.commentID = item.CommentID;
row.movieID = item.MovieID;
row.Content = item.Content;
row.MovieTitle = item.Movie.Title;
ListOfComments.Add(row);
}
}
}
return ListOfComments;
}
public List<MovieModelDTO> GetAllMovies()
{
using (var context = new CinemaEntities())
{
var allMovies = (from movie in context.Movies
select new
{
MovieId = movie.MovieID,
Title = movie.Title
}).ToList();
List<MovieModelDTO> allMoviesToReturn = new List<MovieModelDTO>();
if (allMovies != null)
{
foreach (var item in allMovies)
{
MovieModelDTO movieRow = new MovieModelDTO()
{
MovieID = item.MovieId,
Tilte = item.Title
};
allMoviesToReturn.Add(movieRow);
}
return allMoviesToReturn;
}
else
{
return null;
}
}
}
//Method that gets all Ratings for specific user
public IList<UserRatingDTO> GetAllUserRatings(Guid userID)
{
IList<UserRatingDTO> ListOfRatings = new List<UserRatingDTO>();
using (var context = new CinemaEntities())
{
var results = (from rt in context.Ratings.Include("Movie")
where rt.UserID == userID
select rt);
if (results != null)
{
foreach (var item in results)
{
UserRatingDTO row = new UserRatingDTO();
row.ratingID = item.RatingID;
row.userID = userID.ToString();
row.movieID = item.MovieID;
row.MovieTitle = item.Movie.Title;
row.rate = item.Rate;
ListOfRatings.Add(row);
}
}
}
return ListOfRatings;
}
// 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;
}
}
}
public List<MovieModelDTO> GetAllMovies()
{
using (var context = new CinemaEntities())
{
var allMovies = (from movie in context.Movies
select new
{
MovieID = movie.MovieID,
Title = movie.Title,
Photo=movie.Photo,//added by Elena for RepeaterMovie MovieMain.aspx
Description=movie.Description//
}).ToList();
List<MovieModelDTO> allMoviesToReturn = new List<MovieModelDTO>();
if (allMovies != null)
{
foreach (var item in allMovies)
{
MovieModelDTO movieRow = new MovieModelDTO()
{
MovieID = item.MovieID,
Title = item.Title,
//Photo=item.Photo,
Description=item.Description,
Photo = (byte[])item.Photo
};
allMoviesToReturn.Add(movieRow);
}
return allMoviesToReturn;
}
else
{
return null;
}
//byte[] buffer = binary.ToArray();
//MemoryStream stream = new MemoryStream(buffer);
//BitmapImage image = new BitmapImage();
//image.BeginInit();
//image.StreamSource = stream;
//image.EndInit();
//return image;
}
}
// 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;
}
}
}
public IList<String> GetCities()
{
IList<String> citiesList = new List<String>();
using (var context = new CinemaEntities())
{
var cities = (from ct in context.Addresses
select new { City = ct.City }).Distinct();
foreach (var item in cities)
{
String cityRow = null;
cityRow = item.City;
citiesList.Add(cityRow);
}
}
return citiesList;
}
public IList<PerformanceModelDTO> GetPerformances(Guid theaterId)
{
IList<PerformanceModelDTO> performancesList = new List<PerformanceModelDTO>();
IList<RoomModelDTO>roomsList=new List<RoomModelDTO>();
using (var context1 = new CinemaEntities())
{
var rooms = (from room in context1.Rooms
where room.TheaterID == theaterId
select room).ToList();
if (rooms.Count > 0)
{
foreach (var room in rooms)
{
var roomRow = new RoomModelDTO();
roomRow.RoomNumber = room.RoomID;
roomRow.RoomNumber = room.RoomNumber;
roomsList.Add(roomRow);
if (roomsList != null)
{
using (var context = new CinemaEntities())
{
var performances = (from performance in context.Perfomances
where performance.TheaterID == theaterId
select performance).ToList();
foreach (var perform in performances)
{
var performanceRow = new PerformanceModelDTO();
performanceRow.PerformanceID = perform.PerfomanceID;
performanceRow.Tilte = perform.Movie.Title;
performanceRow.Price = perform.Price;
//performanceRow.Room.RoomNumber = perform.Room.RoomNumber;
performanceRow.Duration = perform.Duration; ;
performancesList.Add(performanceRow);
}
}
}
}
}
} return performancesList;
}
public TheaterModelDTO GetTheater(Guid theaterId)
{
Theater spesificTheater = new Theater();
using (var context = new CinemaEntities())
{
spesificTheater = (from theater in context.Theaters
where theater.TheaterID == theaterId
select theater).FirstOrDefault();
}
TheaterModelDTO theaterToReturn = new TheaterModelDTO();
theaterToReturn.TheaterID = spesificTheater.TheaterID;
theaterToReturn.Name = spesificTheater.Name;
return theaterToReturn;
}
public String GetTheater(Guid theaterId)
{
String TheaterName = null;
using (var context = new CinemaEntities())
{
var results = (from theater in context.Theaters
where theater.TheaterID == theaterId
select theater);
foreach (var item in results)
{
TheaterName = item.Name;
}
}
return TheaterName;
}
public IList<TheaterModelDTO> GetTheaters(string city)
{
IList<TheaterModelDTO> theaterList = new List<TheaterModelDTO>();
IList<Addresses.AddressModelDTO> addressList = new List<Addresses.AddressModelDTO>();
using (var context = new CinemaEntities())
{
var adddresses = (from address in context.Addresses
where address.City == city
select address).ToList();
if (adddresses.Count > 0)
{
foreach (var address in adddresses)
{
var addressRow = new Addresses.AddressModelDTO();
addressRow.AddressID = address.AddressID;
addressRow.ObjectID = address.ObjectID;
addressList.Add(addressRow);
Guid currentTheater = addressRow.ObjectID;
if (addressList != null)
{
using (var context1 = new CinemaEntities())
{
var theaters = (from theater in context1.Theaters
where theater.TheaterID == currentTheater
select theater).ToList();
if (theaters.Count>0)
{
foreach (var theater in theaters)
{
var theaterRow = new TheaterModelDTO();
theaterRow.Name = theater.Name;
theaterRow.TheaterID = theater.TheaterID;
theaterList.Add(theaterRow);
}
}
}
}
}
}
}
return theaterList;
}
//public IList<String> GetCities()
//{
// List<String> citiesList = new List<String>();
// using (var context = new CinemaEntities())
// {
// var cities = (from city in context.Addresses
// where city.ObjectType.Description == "Theater"
// select city).ToList();
// if (cities.Count > 0)
// {
// foreach (var city in cities)
// {
// AddressModelDTO cityRow = new AddressModelDTO();
// cityRow.City = city.City;
// citiesList.Add(cityRow);
// }
// }
// return citiesList;
// }
//}
public IList<AddressModelDTO> GetCities()
{
IList<AddressModelDTO> citiesList = new List<AddressModelDTO>();
using (var context = new CinemaEntities())
{
var cities = (from city in context.Addresses
where city.ObjectType.Description == "Theater"
select city).ToList();
if (cities.Count > 0)
{
foreach (var city in cities)
{
var cityRow = new AddressModelDTO();
cityRow.City = city.City;
citiesList.Add(cityRow);
List<AddressModelDTO> newCitiesList = new List<AddressModelDTO>();
foreach (var item in citiesList)
{
if (!newCitiesList.Contains(item))
{ newCitiesList.Add(item);}
}
//if (citiesList != null)
//{
// foreach (var cit in citiesList)
// {
// if (cit.City != cityRow.City)
// { citiesList.Add(cityRow); }
// //if (cityRow.City != city.City)
// //{
// // citiesList.Add(cityRow);
// //}
// else
// {
// return citiesList;
// }
}
}
}
return citiesList;
}
//Method that gets all Favorite movies of a specific user
public IList<UserFavoriteMovieDTO> GetFavoriteMoviesByUser(Guid userID)
{
IList<UserFavoriteMovieDTO> ListOfMovies = new List<UserFavoriteMovieDTO>();
using (var context = new CinemaEntities())
{
var results = (from fv in context.Favorites.Include("Movie")
where fv.UserID == userID
select fv);
foreach (var item in results)
{
UserFavoriteMovieDTO row = new UserFavoriteMovieDTO();
row.userID = userID.ToString();
row.movieID = item.MovieID;
row.MovieTitle = item.Movie.Title;
ListOfMovies.Add(row);
}
}
return ListOfMovies;
}
public AddressModelDTO GetAddress(Guid objectId)
{
Address spesificAddress = new Address();
using (var context = new CinemaEntities())
{
spesificAddress = (from address in context.Addresses
where address.ObjectID == objectId
select address).FirstOrDefault();
}
AddressModelDTO addressToReturn = new AddressModelDTO();
addressToReturn.AddressID = spesificAddress.AddressID;
addressToReturn.AddressLine1 = spesificAddress.AddressLine1;
addressToReturn.City = spesificAddress.City;
addressToReturn.PostalCode = spesificAddress.PostalCode;
addressToReturn.Province = spesificAddress.Province;
addressToReturn.Country = spesificAddress.Country;
addressToReturn.Phone = spesificAddress.Phone;
addressToReturn.Email = spesificAddress.Email;
return addressToReturn;
}
public MovieModelDTO GetMovieByID(int movieID)
{
MovieModelDTO SelectedMovie = new MovieModelDTO();
using (var context = new CinemaEntities())
{
var results = (from mv in context.Movies.Include("Genre")
where mv.MovieID == movieID
select mv);
if (results != null)
{
foreach (var item in results)
{
SelectedMovie.MovieID = item.MovieID;
SelectedMovie.Title = item.Title;
SelectedMovie.GenreName = item.Genre.Name;
SelectedMovie.Description = item.Description;
SelectedMovie.Year = item.Year;
}
}
}
return SelectedMovie;
}
//Method that gets Movie description
public String GetMovieDescriptionByMovieID(int movieID)
{
String Description = null;
using (var context = new CinemaEntities())
{
var results = (from mv in context.Movies
where mv.MovieID == movieID
select mv);
if (results != null)
{
foreach (var item in results)
{
Description = item.Description;
}
}
}
return Description;
}
//Method that gets list of movies to which the specific user commented
public IList<String> GetMoviesToWhichTheUserCommented(Guid userID)
{
IList<String> ListOfMovies = new List<String>();
using (var context = new CinemaEntities())
{
var results = (from cm in context.Comments
where cm.UserID == userID
select new
{
MovieName = cm.Movie.Title
});
if (results != null)
{
results = results.Distinct();
foreach (var item in results)
{
String row = item.MovieName;
ListOfMovies.Add(row);
}
}
}
return ListOfMovies;
}
//Method that gets Performance info by its ID
public UserPerformanceDTO GetPerformanceByID(int performanceID)
{
UserPerformanceDTO CurrentPerformance = new UserPerformanceDTO();
using (var context = new CinemaEntities())
{
var results = (from pr in context.Perfomances.Include("Theater").Include("Movie").Include("Room")
where pr.PerfomanceID == performanceID
join ad in context.Addresses
on pr.TheaterID equals ad.ObjectID
where ad.ObjectType.Description == "Theater"
select new
{
PerformanceOut = pr,
AddressOut = ad
});
if (results != null)
{
foreach (var item in results)
{
CurrentPerformance = new UserPerformanceDTO();
CurrentPerformance.performanceID = performanceID;
CurrentPerformance.TheaterName = item.PerformanceOut.Theater.Name;
CurrentPerformance.Date = item.PerformanceOut.Date.ToString("yyy/MM/dd");
CurrentPerformance.Duration = item.PerformanceOut.Duration;
string hour = item.PerformanceOut.StartingTime.Hours.ToString();
if (hour.Length < 2)
{
hour = string.Format("{0}{1}", "0", hour);
}
string minutes = item.PerformanceOut.StartingTime.Minutes.ToString();
CurrentPerformance.StartingTime = string.Format("{0}:{1}", hour, minutes);
CurrentPerformance.price = item.PerformanceOut.Price;
CurrentPerformance.MovieTitle = item.PerformanceOut.Movie.Title;
CurrentPerformance.roomNumber = item.PerformanceOut.Room.RoomNumber;
string street = item.AddressOut.AddressLine1;
if (item.AddressOut.AddressLine2 != null)
{
street = string.Format("{0}, {1}", item.AddressOut.AddressLine1, item.AddressOut.AddressLine2);
}
string phone = item.AddressOut.Phone;
CurrentPerformance.TheaterAddress = string.Format("{0}, Phone: {1}", street, phone);
}
}
}
return CurrentPerformance;
}
//Method that gets the theaters by City
public IList<UserTheaterDTO> GetTheatersByCity(String City, int movieID)
{
IList<UserTheaterDTO> ListOfTheaters = new List<UserTheaterDTO>();
using (var context = new CinemaEntities())
{
var results = (from pr in context.Perfomances.Include("Theater")
join ad in context.Addresses.Include("ObjectType")
on pr.TheaterID equals ad.ObjectID
where pr.MovieID == movieID
where ad.City == City
where ad.ObjectType.Description == "Theater"
select new
{
TheaterID = pr.TheaterID,
TheaterName = pr.Theater.Name,
AddressTh = ad
});
if (results != null)
{
foreach (var item in results)
{
UserTheaterDTO row = new UserTheaterDTO();
row.TheaterID = item.TheaterID;
row.TheaterName = item.TheaterName;
row.TheaterAddress = String.Format("str. {0}, {1}, phone number: {2}.", item.AddressTh.AddressLine1, item.AddressTh.City, item.AddressTh.Phone);
ListOfTheaters.Add(row);
}
}
}
return ListOfTheaters;
}
//Method that gets Performances by Theater
public IList<UserPerformanceDTO> GetPerformancesByTheaterIDandMovieID(Guid TheaterID, int movieID)
{
IList<UserPerformanceDTO> ListOfPerformances = new List<UserPerformanceDTO>();
using (var context = new CinemaEntities())
{
var results = (from pr in context.Perfomances.Include("Movie").Include("Theater")
where pr.TheaterID == TheaterID && pr.MovieID == movieID
select pr);
if (results != null)
{
foreach (var item in results)
{
UserPerformanceDTO row = new UserPerformanceDTO();
row.performanceID = item.PerfomanceID;
row.MovieTitle = item.Movie.Title;
row.roomNumber = item.Room.RoomNumber;
row.Date = item.Date.ToString("yyyy/MM/dd");
string hours = item.StartingTime.Hours.ToString();
if (hours.Length < 2)
{
hours = string.Format("{0}{1}", "0", hours);
}
string minutes = item.StartingTime.Minutes.ToString();
row.StartingTime = string.Format("{0}:{1}", hours, minutes);
row.Duration = item.Duration;
row.price = item.Price;
ListOfPerformances.Add(row);
}
}
}
return ListOfPerformances;
}
//Method that get user type by description
public int GetUserType(String Description)
{
int type = 0;
using (var context = new CinemaEntities())
{
var results = (from pt in context.PersonTypes
where pt.Description == Description
select pt);
if (results != null)
{
foreach (var item in results)
{
type = item.PersonType1;
}
}
}
return type;
}
//Method that gets UserID during the login
public Guid GetUserID(String UserName)
{
Guid UserID = new Guid();
using (var context = new CinemaEntities())
{
var results = (from usr in context.aspnet_Users
where usr.UserName == UserName
select usr);
if (results != null)
{
foreach (var item in results)
{
UserID = item.UserId;
}
}
return UserID;
}
}
//Method that deletes movie from favorite list
public bool RemoveMovieFromFavoriteList(Guid UserID, string movieTitle)
{
bool check;
using (TransactionScope Trans = new TransactionScope())
{
try
{
using (var context = new CinemaEntities())
{
var results = (from fv in context.Favorites.Include("Movie")
where fv.Movie.Title == movieTitle &&
fv.UserID == UserID
select fv);
if (results != null)
{
Favorite LineToDelete = (Favorite)results.First();
context.Favorites.DeleteObject(LineToDelete);
context.SaveChanges();
}
}
}
catch
{
check = false;
Trans.Dispose();
return check;
}
check = true;
Trans.Complete();
return check;
}
}
//---Method that extracts movie photo
public Byte[] GetPhoto(int movieId)
{
byte[] photo = null;
using (var context = new CinemaEntities())
{
var result = (from image in context.Movies
where image.MovieID == movieId
select image).SingleOrDefault();
if (result == null)
{
return null;
}
photo = result.Photo;
//foreach (var item in result)
//{
//photo = item.Photo;
//}
}
return photo;
}
//Method that updates comment
public bool UpdateComment(UserCommentDTO UpdatedComment)
{
bool check = false;
using (TransactionScope Trans = new TransactionScope())
{
try
{
using (var context = new CinemaEntities())
{
var results = (from cm in context.Comments
where cm.CommentID == UpdatedComment.commentID
select cm);
if (results != null)
{
Comment CommentToUpdate = new Comment();
CommentToUpdate = (Comment)results.First();
CommentToUpdate.Content = UpdatedComment.Content;
context.ObjectStateManager.ChangeObjectState(CommentToUpdate, System.Data.EntityState.Modified);
context.SaveChanges();
}
}
}
catch
{
check = false;
Trans.Dispose();
return check;
}
check = true;
Trans.Complete();
return check;
}
}
//Method that submits the order
public UserOrderDTO CreateOrder(UserOrderDTO NewOrder)
{
UserOrderDTO OrderOut = new UserOrderDTO();
Order OrderIn = new Order();
using (TransactionScope Trans = new TransactionScope())
{
try
{
using (var context = new CinemaEntities())
{
OrderIn.NumberOfSeatsReserved = NewOrder.NumberOfSeats;
OrderIn.TotalPrice = NewOrder.TotalPrice;
OrderIn.UserID = NewOrder.UserID;
OrderIn.PerfomanceID = NewOrder.PerformanceID;
if (OrderIn.EntityState == EntityState.Detached)
{
context.Orders.AddObject(OrderIn);
}
context.SaveChanges();
OrderOut.OrderID = OrderIn.OrderID;
}
}
catch
{
OrderOut.isValid = false;
Trans.Dispose();
return OrderOut;
}
OrderOut.isValid = true;
Trans.Complete();
return OrderOut;
}
}
public List<MovieModelDTO> GetAllYears()
{
using (var context = new CinemaEntities())
{
var allYears = (from movie in context.Movies
orderby movie.Year ascending
select new
{
MovieId = movie.MovieID,
Year = movie.Year
}).ToList();
List<MovieModelDTO> allYearsToReturn = new List<MovieModelDTO>();
if (allYears != null)
{
foreach (var item in allYears)
{
MovieModelDTO yearRow = new MovieModelDTO()
{
MovieID = item.MovieId,
Year = item.Year
};
allYearsToReturn.Add(yearRow);
}
return allYearsToReturn;
}
else
{
return null;
}
}
}
