public ActionResult Edit(Movie_Users movie_user, List<string> Storage)
{
Movie_Users movieuserHelp = storeDb.Movie_Users.Find(movie_user.IdRelMovie_User);
if (ModelState.IsValid)
{
foreach (var item in movieuserHelp.MovieUser_TypeStorage.ToList())
{
storeDb.MovieUser_TypeStorage.Remove(item);
}
movieuserHelp.MovieUser_TypeStorage = new List<MovieUser_TypeStorage>();
Storage.ForEach(a =>
{
var type_storage = storeDb.TypeStorages.FirstOrDefault(store => store.TypeStorage1 == a);
movieuserHelp.MovieUser_TypeStorage.Add(new MovieUser_TypeStorage
{
TypeStorage = type_storage
});
});
movieuserHelp.PersonalScore = movie_user.PersonalScore;
movieuserHelp.Seen = movie_user.Seen;
movieuserHelp.Favorite = movie_user.Favorite;
storeDb.SaveChanges();
storeDb.Entry(movieuserHelp).State = System.Data.Entity.EntityState.Modified;
storeDb.SaveChanges();
return RedirectToAction("Index");
}
return View(movie_user);
}
public ActionResult AddMovie(Movie_Users _movieUser, string nameDirector, string nameActor, string nameCountry, string nameGenre, List<string> Storage)
{
var id_User = (Session["LogedUserId"]);
var logedUser = Convert.ToInt32(id_User);
if (ModelState.IsValid)
{
var auxMovie = storeDb.Movies1.FirstOrDefault(movie => movie.Title == _movieUser.Movies1.Title);
_movieUser.idUser = logedUser;
if(auxMovie==null)
{
_movieUser.Movies1.Movie_Director = new List<Movie_Director>();
nameDirector.Split(',').ToList().ForEach(a =>
{
var director = storeDb.Directors.FirstOrDefault(direc => direc.nameDirector == a.Trim());
if(director==null)
{
director = new Director();
director.nameDirector = a.Trim();
}
_movieUser.Movies1.Movie_Director.Add(new Movie_Director
{
Director = director
});
});
_movieUser.Movies1.Movie_Actors = new List<Movie_Actors>();
nameActor.Split(',').ToList().ForEach(a =>
{
var actor = storeDb.Actors.FirstOrDefault(_actor => _actor.Name == a.Trim());
if (actor==null)
{
actor = new Actor();
actor.Name = a.Trim();
}
_movieUser.Movies1.Movie_Actors.Add(new Movie_Actors
{
Actor=actor
});
});
_movieUser.Movies1.Movie_Country = new List<Movie_Country>();
nameCountry.Split(',').ToList().ForEach(a =>
{
var country = storeDb.Countries.FirstOrDefault(_country => _country.Name == a.Trim());
if (country==null)
{
country = new Country();
country.Name = a.Trim();
}
_movieUser.Movies1.Movie_Country.Add(new Movie_Country
{
Country = country
});
});
_movieUser.Movies1.Movies_Genres = new List<Movies_Genres>();
nameGenre.Split(',').ToList().ForEach(a =>
{
var genre = storeDb.Genres.FirstOrDefault(_country => _country.Name == a.Trim());
if (genre == null)
{
genre = new Genre();
genre.Name = a.Trim();
}
_movieUser.Movies1.Movies_Genres.Add(new Movies_Genres
{
Genre= genre
});
});
}
_movieUser.MovieUser_TypeStorage = new List<MovieUser_TypeStorage>();
Storage.ForEach(a =>{
var type_storage = storeDb.TypeStorages.FirstOrDefault(store => store.TypeStorage1 == a);
_movieUser.MovieUser_TypeStorage.Add(new MovieUser_TypeStorage
{
TypeStorage=type_storage
});
});
storeDb.Movie_Users.Add(_movieUser);
try {
storeDb.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Debug.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
return RedirectToAction("Index");
};
ViewBag.storageId = new SelectList(storeDb.TypeStorages, "IdTypeStorage", "TypeStorage1");
return View();
}
public ActionResult BrowseByYear(int year)
{
var id_User = (Session["LogedUserId"]);
var logedUser = Convert.ToInt32(id_User);
// Retrieve Movies by year from database
var moviesByYear = from p in storeDb.Movies1
where p.Year == year
select p;
var moviesByUserYear = from p in storeDb.Movie_Users
where p.Movies1.Year== year
select p;
List<Movie_Users> moviesHelp = new List <Movie_Users>();
Movie_Users movieUser= new Movie_Users();
foreach (var k in moviesByUserYear)
{
if (k.idUser == logedUser)
{moviesHelp.Add(k);}
}
ViewBag.logedUser = logedUser;
ViewBag.year = year;
return View(moviesHelp);
}