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));
}
