public async Task <IHttpActionResult> Put([FromODataUri] int key, Movie update) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (key != update.Id) { return(BadRequest()); } db.Entry(update).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ItemExists(key)) { return(NotFound()); } else { throw; } } return(Updated(update)); }
//public ActionResult Edit([Bind(Include = "Id,Name,Surname,Retired")] Director director, List<int> selectedIds) public ActionResult Edit(DirectorsEditViewModel model) { if (ModelState.IsValid) { var director = db.Directors.Find(model.Director.Id); director.Name = model.Director.Name; director.Surname = model.Director.Surname; director.Retired = model.Director.Retired; director.MovieDirectors = new List <MovieDirector>(); //var movieDirectors = db.MovieDirectors.Where(e => e.DirectorId == model.Director.Id).ToList(); //movieDirectors.ForEach(e => db.Entry(e).State = EntityState.Deleted); foreach (var movieDirector in db.MovieDirectors.Where(e => e.DirectorId == director.Id)) { db.Entry(movieDirector).State = EntityState.Deleted; } model.moviesIds?.ForEach(e => director.MovieDirectors.Add(new MovieDirector() { DirectorId = model.Director.Id, MovieId = e })); db.Entry(director).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(model.Director)); }
public void Delete(T entityToDelete) { if (Context.Entry(entityToDelete).State == EntityState.Detached) { DbSet.Attach(entityToDelete); } DbSet.Remove(entityToDelete); }
// PUT http://localhost:54701/odata/Movies(1) public async Task <IActionResult> Put([FromODataUri] int key, [FromBody] Movie update) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (key != update.Id) { return(BadRequest()); } _db.Entry(update).State = EntityState.Modified; try { await _db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException ex) { var entry = ex.Entries.First(); var errorMessage = ""; var clientValues = (Movie)entry.Entity; var databaseEntry = entry.GetDatabaseValues(); if (databaseEntry == null) { errorMessage = "Unable to save changes. The record was deleted by another user."; } else { var databaseValues = (Movie)databaseEntry.ToObject(); errorMessage += "The record you attempted to edit " + "was modified by another user after you got the original value. The " + "edit operation was canceled and the current values in the database " + "have been displayed. Please reload. "; errorMessage += Environment.NewLine + "Current value: "; errorMessage += Environment.NewLine + $"Code : {databaseValues.Code}"; if (databaseValues.Name != clientValues.Name) { // ModelState.AddModelError("Name", "Current value: " // + databaseValues.Name); errorMessage += Environment.NewLine + $"Name : {databaseValues.Name}"; } } return(StatusCode(StatusCodes.Status412PreconditionFailed, errorMessage)); } return(Updated(update)); }
public ActionResult Edit([Bind(Include = "Id,Name,ProductionYear")] Movie movie, string BoxOfficeReturn, List <int> directorIds, HttpPostedFileBase Image) { if (ModelState.IsValid) { var newMovie = db.Movies.Find(movie.Id); newMovie.Name = movie.Name; newMovie.ProductionYear = movie.ProductionYear; newMovie.MovieDirectors = new List <MovieDirector>(); if (!string.IsNullOrWhiteSpace(BoxOfficeReturn)) { newMovie.BoxOfficeReturn = Convert.ToDouble(BoxOfficeReturn.Replace(',', '.'), CultureInfo.InvariantCulture); } string oldFilePath = newMovie.FilePath; if (ImageFilePath(movie.Name, Image) != null) { newMovie.FilePath = ImageFilePath(movie.Name, Image); } var movieDirectors = db.MovieDirectors.Where(e => e.MovieId == movie.Id).ToList(); movieDirectors.ForEach(e => db.Entry(e).State = EntityState.Deleted); directorIds?.ForEach(e => newMovie.MovieDirectors.Add(new MovieDirector() { MovieId = newMovie.Id, DirectorId = e })); db.Entry(newMovie).State = EntityState.Modified; db.SaveChanges(); if (ImageFilePath(movie.Name, Image) != null) { if (oldFilePath != null && System.IO.File.Exists(Server.MapPath(oldFilePath))) { System.IO.File.Delete(Server.MapPath(oldFilePath)); } Image.SaveAs(Server.MapPath(newMovie.FilePath)); } TempData["Info"] = "Record successfully updated in database"; return(RedirectToAction("Index")); } return(View(movie)); }
public async Task <IActionResult> Put(int id, [FromBody] Producer producer) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != producer.Id) { return(BadRequest()); } _context.Entry(producer).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ActorExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> Put([FromRoute] int movieId, [FromBody] MovieTable movieTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (movieId != movieTable.MovieId) { return(BadRequest()); } _context.Entry(movieTable).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MovieTableExists(movieId)) { return(NotFound()); } else { throw; } } return(Ok(movieTable)); }
public ActionResult Edit(Movies movie, List <int> DirectorIds) { Movies movieEntity = db.Movies.Find(movie.Id); // güncellemek istediğimiz kayıt veritabanı kaydı onun için entityden çekmemiz lazım... if (movieEntity == null) { return(new HttpStatusCodeResult(HttpStatusCode.NotFound)); } movieEntity.Name = movie.Name; movieEntity.ProductionYear = movie.ProductionYear; movieEntity.BoxOfficeReturn = movie.BoxOfficeReturn; List <MovieDirectors> movieDirectorsEntity = db.MovieDirectors.Where(movieDirector => movieDirector.MovieId == movieEntity.Id).ToList(); // veritabanından filmin yönetmeninin Id'si üzerinden getiriyoruz... db.MovieDirectors.RemoveRange(movieDirectorsEntity); // seçtiğimiz filmin yönetmen bilgilerini silecek movieEntity.MovieDirectors = DirectorIds.Select(directorId => new MovieDirectors() // sildiğimiz filmin yönetmenlerini update yaparken yeni seçilecek film ve yönetmen Idleri yenilenecek { MovieId = movieEntity.Id, DirectorId = directorId }).ToList(); db.Entry(movieEntity).State = EntityState.Modified; db.SaveChanges(); TempData["Successful"] = "Movie Updated Successfully..."; return(RedirectToAction("Index")); }
private void bSave_Click(object sender, EventArgs e) { try { if (string.IsNullOrWhiteSpace(tbName.Text) || string.IsNullOrWhiteSpace(tbSurname.Text)) { MessageBox.Show("Fields cannot be empty!"); return; } //var directorModel = db.Directors.SingleOrDefault(d => d.Id == Convert.ToInt32(lId.Text)); var directorModel = directorService.Details(Convert.ToInt32(lId.Text)); directorModel.Name = tbName.Text.Trim(); directorModel.Surname = tbSurname.Text.Trim(); if (rbYes.Checked) { directorModel.Retired = true; } else { directorModel.Retired = false; } db.Entry(directorModel).State = EntityState.Modified; db.SaveChanges(); MessageBox.Show("Changes saved!"); } catch (Exception exc) { MessageBox.Show(exc.ToString()); } }
public IHttpActionResult PutActor(int id, ActorModel actorModel) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != actorModel.Id) { return(BadRequest()); } var actor = Mapper.Map <Actor>(actorModel); db.Entry(actor).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ActorExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutReview(int id, ReviewModel reviewModel) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != reviewModel.Id) { return(BadRequest()); } var review = Mapper.Map <Review>(reviewModel); db.Entry(review).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ReviewExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutFootballClub(int id, FootballClubModel footballClubModel) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != footballClubModel.Id) { return(BadRequest()); } var footballClub = Mapper.Map <FootballClub>(footballClubModel); db.Entry(footballClub).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!FootballClubExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Edit([Bind(Include = "Id, Name, ProductionYear")] Movie movie, string BoxOfficeReturn, List <int> directorIds) { var entity = db.Movies.SingleOrDefault(e => e.Id == movie.Id); entity.Name = movie.Name; entity.ProductionYear = movie.ProductionYear; entity.BoxOfficeReturn = Convert.ToDouble(BoxOfficeReturn.Replace(",", "."), CultureInfo.InvariantCulture); entity.MovieDirectors = new List <MovieDirector>(); var movieDirectors = db.MovieDirectors.Where(e => e.MovieId == movie.Id).ToList(); foreach (var movieDirector in movieDirectors) { db.MovieDirectors.Remove(movieDirector); } foreach (var directorId in directorIds) { var movieDirector = new MovieDirector() { MovieId = movie.Id, DirectorId = directorId }; entity.MovieDirectors.Add(movieDirector); } db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); TempData["Info"] = "Record successfully updated in database."; return(RedirectToRoute(new { controller = "Movies", action = "Index" })); }
public async Task <IActionResult> PutMovie(int id, Movie movie) { if (id != movie.Id) { return(BadRequest()); } _context.Entry(movie).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MovieExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutUsers([FromRoute] int id, [FromBody] Users users) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != users.Id) { return(BadRequest()); } _context.Entry(users).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UsersExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult> EditActor(int id, ActorDto actor) { Actor updateActor = new Actor() { Id = id, FirstName = actor.FirstName, LastName = actor.LastName, BirthDate = actor.BirthDate, MovieActors = context.MovieActors.Where(ma => ma.ActorId == actor.Id).ToList() }; context.Entry(updateActor).State = EntityState.Modified; await context.SaveChangesAsync(); return(Ok()); }
public ActionResult Edit(DirectorsEditViewModel directorsEditViewModel) { if (ModelState.IsValid) { var director = db.Directors.Find(directorsEditViewModel.Director.Id); director.Name = directorsEditViewModel.Director.Name; director.Surname = directorsEditViewModel.Director.Surname; director.Retired = directorsEditViewModel.Director.Retired; var movieDirectors = db.MovieDirectors.Where(e => e.DirectorId == director.Id).ToList(); //var movieDirectors = director.MovieDirectors; foreach (var movieDirector in movieDirectors) { db.MovieDirectors.Remove(movieDirector); } director.MovieDirectors = directorsEditViewModel.movieIds.Select(e => new MovieDirector() { DirectorId = director.Id, MovieId = e }).ToList(); db.Entry(director).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(directorsEditViewModel)); }
public IHttpActionResult PutMovie(int id, MovieModel movieModel) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != movieModel.Id) { return(BadRequest()); } var movie = Mapper.Map <Movie>(movieModel); db.Entry(movie).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!MovieExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
//public ActionResult Edit([Bind(Include = "Id,Name,Surname,Retired")] Director director, List<int> movieIds) //{ // if (ModelState.IsValid) // { // var entity = db.Directors.SingleOrDefault(e => e.Id == director.Id); // entity.Name = director.Name; // entity.Retired = director.Retired; // entity.Surname = director.Surname; // entity.MovieDirectors = new List<MovieDirector>(); //yeni liste // var movieDirectors = db.MovieDirectors.Where(e => e.DirectorId == director.Id).ToList(); // foreach (var movieDirector in movieDirectors) // { // //db.Entry(movieDirector).State = EntityState.Deleted; //önce eski kayıtları silmek gerekiyor. // db.Entry(movieDirector).State = EntityState.Deleted; // } // foreach (var movieId in movieIds) // { // var movieDirector = new MovieDirector() // { // DirectorId = director.Id, // MovieId = movieId // }; // entity.MovieDirectors.Add(movieDirector); // } // db.Entry(entity).State = EntityState.Modified; // db.SaveChanges(); // TempData["Info"] = "Record successfully updated to database"; // return RedirectToRoute(new { Controller = "Directors", action = "Index" }); // } // return View(director); //} #endregion public ActionResult Edit(DirectorsEditViewModel directorEditViewModel) { if (ModelState.IsValid) { var director = db.Directors.Find(directorEditViewModel.Director.Id); //director çekiyoruz db contexten aldık director.Name = directorEditViewModel.Director.Name; //güncellemeler için veri tabanından kayıt çekmek. director.Surname = directorEditViewModel.Director.Surname; director.Retired = directorEditViewModel.Director.Retired; //veri tabınında eskileri temizlemek gerek //var movieDirectors = db.MovieDirectors.Where(e => e.DirectorId == director.Id).ToList(); //1.yol var movieDirectors = director.MovieDirectors; foreach (var movieDirector in movieDirectors.ToList()) { db.MovieDirectors.Remove(movieDirector); } //var movieDirectors = db.MovieDirectors.Where(e => e.DirectorId == director.Id).ToList(); //1.yol //foreach (var movieDirector in movieDirectors) //{ // db.MovieDirectors.Remove(movieDirector); //} //sildikten sonra gelen idlerden moviedirector yapıyor director.MovieDirectors = directorEditViewModel.movieIds.Select(e => new MovieDirector() { DirectorId = director.Id, MovieId = e }).ToList(); db.Entry(director).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(directorEditViewModel)); }
public void Update(MovieModel model) { try { Movie entity = db.Movies.Find(model.Id); entity.Name = model.Name; entity.BoxOfficeReturn = model.BoxOfficeReturn; entity.ProductionYear = model.ProductionYear; entity.MovieDirectors = new List <MovieDirector>(); MovieDirector movieDirector; foreach (int directorId in model.DirectorIds) { movieDirector = new MovieDirector() { MovieId = entity.Id, DirectorId = directorId }; entity.MovieDirectors.Add(movieDirector); } db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); } catch (Exception e) { throw e; } }
public async Task <IActionResult> PutMovie(long id, Movie movie) { if (id != movie.ID) { return(BadRequest()); } if (!MovieExists(id)) { return(NotFound()); } _context.Entry(movie).State = EntityState.Modified; await _context.SaveChangesAsync(); return(Ok(movie)); }
public ActionResult Edit([Bind(Include = "ActorID,LastName,FirstName")] Actor actor) { if (ModelState.IsValid) { db.Entry(actor).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(actor)); }
public ActionResult Edit([Bind(Include = "id_bilet,cena,e_mail,vreme_na_rezervacija,id_proekcija,id_film,broj_sala,broj_sediste,broj_red")] Bilet bilet) { if (ModelState.IsValid) { db.Entry(bilet).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(bilet)); }
public ActionResult Edit([Bind(Include = "Id,Name,Img,ReleaseDate,ReviewScore")] Movie movie) { if (ModelState.IsValid) { _context.Entry(movie).State = EntityState.Modified; _context.SaveChanges(); return(RedirectToAction("Index")); } return(View(movie)); }
public ActionResult Edit([Bind(Include = "Id,Gender,Username,FirstName,LastName,Password,IsAdmin")] User user) { if (ModelState.IsValid) { db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public ActionResult Edit([Bind(Include = "Id,MovieName,MovieGenere,MovieReleaseYear,MovieCollectionAmount")] MoviesClass moviesClass) { if (ModelState.IsValid) { Db.Entry(moviesClass).State = EntityState.Modified; Db.SaveChanges(); return(RedirectToAction("Index")); } return(View(moviesClass)); }
public ActionResult Edit([Bind(Include = "card_id,card_num,card_type,card_name,card_expiry,card_cvv")] CreditCard creditCard) { if (ModelState.IsValid) { db.Entry(creditCard).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(creditCard)); }
public ActionResult Edit([Bind(Include = "show_id,show_name,runtime,rating,image_path")] Show show) { if (ModelState.IsValid) { db.Entry(show).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(show)); }
public ActionResult Edit(Movie movie) { if (ModelState.IsValid) { db.Entry(movie).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(movie)); }
public ActionResult Edit([Bind(Include = "Id,Title,Release,Kind,Price")] Movie movie) { if (ModelState.IsValid) { db.Entry(movie).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(movie)); }