public bool Create(Movie movie)
{
ImageManager imageManager = new ImageManager();
decimal imageId = imageManager.SaveImage(movie._Image.ImagePath, movie._Image.Title);
try
{
if (imageId != 0)
{
using (MoviesEntities db = new MoviesEntities())
{
tblMovy tMovie = new tblMovy();
UpdateMovieEntity(ref tMovie, movie);
tMovie.CreatedDateTime = DateTime.Now;
tMovie.ImageId = imageId;
db.tblMovies.Add(tMovie);
db.SaveChanges();
MapMovieAndActors(tMovie.MovieId, movie._SelectedActors, db);
}
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
tblMovy tblMovy = await db.tblMovies.FindAsync(id);
db.tblMovies.Remove(tblMovy);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
private void UpdateMovieEntity(ref tblMovy tMovie, Movie movie)
{
tMovie.MovieName = movie._Name;
tMovie.Plot = movie._Plot;
tMovie.YearOfRelease = movie._YearOfRelease;
tMovie.IsDeleted = false;
tMovie.ProducerId = movie._SelectedProducer;
tMovie.LastModifiedDateTime = DateTime.Now;
}
public async Task <ActionResult> Edit([Bind(Include = "id,name,releaseDate,director,email,language,category")] tblMovy tblMovy)
{
if (ModelState.IsValid)
{
db.Entry(tblMovy).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(tblMovy));
}
public async Task <ActionResult> Create([Bind(Include = "id,name,releaseDate,director,email,language,category")] tblMovy tblMovy)
{
if (ModelState.IsValid)
{
db.tblMovies.Add(tblMovy);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(tblMovy));
}
public void DeleteMovie(decimal id)
{
using (MoviesEntities db = new MoviesEntities())
{
DeleteMovieAndActors(id, db);
tblMovy tMovie = db.tblMovies.Find(id);
tblImage tblImage = tMovie.tblImage;
db.tblMovies.Remove(tMovie);
db.SaveChanges();
db.tblImages.Remove(tblImage);
db.SaveChanges();
}
}
// GET: Movies/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblMovy tblMovy = await db.tblMovies.FindAsync(id);
if (tblMovy == null)
{
return(HttpNotFound());
}
return(View(tblMovy));
}
public bool AddUpdateMovie(MovieModel model)
{
try
{
tblMovy _movieModel = model.MovieID > 0 ? _MoviesDBEntitiesContext.tblMovies.FirstOrDefault(f => f.MovieID == model.MovieID) : new tblMovy();
_movieModel.Name = model.Name;
_movieModel.Plot = model.Plot;
if (!string.IsNullOrEmpty(model.Poster))
{
_movieModel.Poster = Base64Image.Parse(model.Poster).FileContents;
_movieModel.PosterContentType = model.ContentType;
}
_movieModel.ProducerID = model.ProducerID;
_movieModel.YearOfRelease = model.YearOfRelease;
_MoviesDBEntitiesContext.Entry(_movieModel).State = model.MovieID > 0 ? System.Data.Entity.EntityState.Modified : System.Data.Entity.EntityState.Added;
_MoviesDBEntitiesContext.SaveChanges();
if (model.MovieID > 0)
{
_MoviesDBEntitiesContext.tblMovieActors.RemoveRange(_MoviesDBEntitiesContext.tblMovieActors.Where(w => w.MovieID == model.MovieID));
_MoviesDBEntitiesContext.SaveChanges();
}
foreach (int actorID in model.Actors)
{
if (!_MoviesDBEntitiesContext.tblMovieActors.Any(fk => fk.ActorID == actorID && fk.MovieID == _movieModel.MovieID))
{
tblMovieActor _movieActor = new tblMovieActor();
_movieActor.ActorID = actorID;
_movieActor.MovieID = _movieModel.MovieID;
_MoviesDBEntitiesContext.tblMovieActors.Add(_movieActor);
_MoviesDBEntitiesContext.SaveChanges();
}
}
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void UpdateMovie(Movie movie)
{
ImageManager imageManager = new ImageManager();
using (MoviesEntities db = new MoviesEntities())
{
Decimal imageId = 0;
tblMovy tMovie = db.tblMovies.Where(q => q.MovieId == movie._Id).FirstOrDefault();
if (movie._Image.ImagePath != null)
{
imageId = imageManager.SaveImage(movie._Image.ImagePath, movie._Image.Title);
}
UpdateMovieEntity(ref tMovie, movie);
if (imageId != 0)
{
tMovie.ImageId = imageId;
}
db.SaveChanges();
DeleteMovieAndActors(movie._Id, db);
MapMovieAndActors(movie._Id, movie._SelectedActors, db);
}
}
