public ActionResult Create([Bind(Include = "MovieID,Name,SmallPictureUrl,LargePictureUrl,HasReleased,LanguageID")] Movie movie) { if (ModelState.IsValid) { _db.Movies.Add(movie); _db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.LanguageID = new SelectList(_db.Languages, "LanguageID", "LanguageName", movie.LanguageID); return(View(movie)); }
public void CreateNewDb() { foreach (var language in LangaugeCreator.GetAll()) { _db.Languages.Add(language); } foreach (var sites in WebSiteCreator.GetAllCriticSites()) { _db.CriticSites.Add(sites); } foreach (var movie in MovieCreator.CreateMovies()) { _db.Movies.Add(movie); } foreach (var movieDetail in MovieDetailCreator.CreateMovies()) { _db.MovieDetails.Add(movieDetail); } foreach (var criticRating in CriticRatingCreator.CreateCriticRatings()) { _db.CriticRatings.Add(criticRating); } foreach (var userRating in UserRatingCreator.CreateUserRating()) { _db.UserRatings.Add(userRating); } _db.SaveChanges(); }
public void InsertOrUpdateEntity(int id, TEntityDTO entityDTO) { using (var dbContext = new ProjectManhattanEntities()) { var entity = dbContext.Set <TEntity>().Find(id); if (entity != null) { Mapper.Map(entityDTO, entity); dbContext.SaveChanges(); } else { var newEntity = Mapper.Map <TEntity>(entityDTO); dbContext.Set <TEntity>().Add(newEntity); dbContext.SaveChanges(); Mapper.Map(newEntity, entityDTO); } } }
public int InsertOrUpdateUser(UserDTO entityDTO) { using (var dbContext = new ProjectManhattanEntities()) { var entity = dbContext.Set <User>().Find(entityDTO.UserId); if (entity != null) { Mapper.Map(entityDTO, entity); dbContext.SaveChanges(); return(entity.UserId); } else { var newEntity = Mapper.Map <User>(entityDTO); dbContext.Set <User>().Add(newEntity); dbContext.SaveChanges(); return(newEntity.UserId); } } }
public void DeleteEntity(int id) { using (var dbContext = new ProjectManhattanEntities()) { var entity = dbContext.Set <TEntity>().Find(id); if (entity != null) { dbContext.Set <TEntity>().Remove(entity); dbContext.SaveChanges(); } } }