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;
}
}
}
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;
}
}
}
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);
}
}
}
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);
}
}
}
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);
}
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);
}
}
}
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;
}
}
public IHttpActionResult Post(MovieModelDTO movieDTO)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var movie = Mapper.Map <MovieModelDTO, MovieModel>(movieDTO);
_dbContext.Movie.Add(movie);
_dbContext.SaveChanges();
movieDTO.Id = movie.Id;
return(Created(new Uri(Request.RequestUri + "/" + movie.Id), movieDTO));
}
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;
}
}
protected void RepeaterMovie_ItemCreated(object sender, RepeaterItemEventArgs e)
{
var ctrl = e.Item.FindControl("Img1");
string movieID = null;
if (e.Item.DataItem is MovieModelDTO)
{
var currentMovie = e.Item.DataItem;
MovieModelDTO CurrentMovie = new MovieModelDTO();
CurrentMovie = (MovieModelDTO)currentMovie;
movieID = CurrentMovie.MovieID.ToString();
}
if (ctrl is System.Web.UI.WebControls.Image)
{
string path = string.Format("~/ContentPages/Movies/MoviePhotoHandler.ashx?MovieID={0}", movieID);
((System.Web.UI.WebControls.Image)ctrl).ImageUrl = path;
}
}
// PUT api/<controller>/5
public IHttpActionResult Put(int id, MovieModelDTO movieDTO)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var movie = _dbContext.Movie.SingleOrDefault(m => m.Id == id);
if (movie == null)
{
return(NotFound());
}
Mapper.Map <MovieModelDTO, MovieModel>(movieDTO, movie);
_dbContext.SaveChanges();
return(Ok(movieDTO));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["MovieID"] != null)
{
string selectedMovieID = Request.QueryString["MovieID"];
int movieID;
bool isInt = int.TryParse(selectedMovieID, out movieID);
if (isInt)
{
string pathToImage = string.Format("~/ContentPages/Movies/MoviePhotoHandler.ashx?MovieID={0}", selectedMovieID);
imgMoviePicture.ImageUrl = pathToImage;
MovieModelDTO SelectedMovie = new MovieModelDTO();
MovieServices MovieServices = new MovieServices();
SelectedMovie = MovieServices.GetMovieByID(movieID);
lblGenreType.Text = SelectedMovie.GenreName;
lblMovieTitle.Text = SelectedMovie.Title;
blYear.Text = SelectedMovie.Year;
lblDescriptionDetails.Text = SelectedMovie.Description;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["MovieID"] != null)
{
string selectedMovieID = Request.QueryString["MovieID"];
int movieID;
bool isInt = int.TryParse(selectedMovieID, out movieID);
if (isInt)
{
string pathToImage = string.Format("~/ContentPages/Movies/MoviePhotoHandler.ashx?MovieID={0}", selectedMovieID);
imgMoviePicture.ImageUrl = pathToImage;
MovieModelDTO SelectedMovie = new MovieModelDTO();
MovieServices MovieServices = new MovieServices();
SelectedMovie = MovieServices.GetMovieByID(movieID);
lblGenreType.Text = SelectedMovie.GenreName;
lblMovieTitle.Text = SelectedMovie.Title;
blYear.Text = SelectedMovie.Year;
lblDescriptionDetails.Text = SelectedMovie.Description;
}
}
}
protected void RepeaterMovie_ItemCreated(object sender, RepeaterItemEventArgs e)
{
var ctrl = e.Item.FindControl("Img1");
string movieID=null;
if (e.Item.DataItem is MovieModelDTO)
{
var currentMovie = e.Item.DataItem;
MovieModelDTO CurrentMovie = new MovieModelDTO();
CurrentMovie = (MovieModelDTO)currentMovie;
movieID = CurrentMovie.MovieID.ToString();
}
if (ctrl is System.Web.UI.WebControls.Image)
{
string path = string.Format("~/ContentPages/Movies/MoviePhotoHandler.ashx?MovieID={0}",movieID);
((System.Web.UI.WebControls.Image)ctrl).ImageUrl = path;
}
}
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;
}
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;
}
}
}
