public IHttpActionResult PutMovie(int id, Movy movie)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != movie.ID)
{
return(BadRequest());
}
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 = "ID1,ImdbId,Title,Genre")] ID iD)
{
if (ModelState.IsValid)
{
db.Entry(iD).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(iD));
}
public ActionResult Edit([Bind(Include = "MovieID,Title,Director,Genre")] 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,Director,Year,LeadingMaleRole,LeadingMaleRoleAge,LeadingMaleRoleAgeStudio,LeadingMaleRoleAgeStudioAddress,LeadingFemaleRole,LeadingFemaleRoleAge,LeadingFemaleRoleStudio,LeadingFemaleRoleStudioAddress")] Movy movy)
{
if (ModelState.IsValid)
{
db.Entry(movy).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movy));
}
public ActionResult Edit([Bind(Include = "id,Name,Genre")] Movy movy)
{
if (ModelState.IsValid)
{
db.Entry(movy).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movy));
}
public ActionResult Edit([Bind(Include = "Theater_id,TheaterName,Address,PhoneNumber")] Theater theater)
{
if (ModelState.IsValid)
{
db.Entry(theater).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(theater));
}
public ActionResult Edit([Bind(Include = "CustomerID,CustomerName,CustomerPhone")] Customer customer)
{
if (ModelState.IsValid)
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Edit([Bind(Include = "GenreID,GenreName")] Genre genre)
{
if (ModelState.IsValid)
{
db.Entry(genre).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(genre));
}
// POST api/<controller>
public HttpResponseMessage Post(Movie movie)
{
if (ModelState.IsValid)
{
_db.Movies.Add(movie);
_db.Entry(movie.Producer).State = EntityState.Unchanged;
foreach (var actor in movie.Actors)
{
_db.Entry(actor).State = EntityState.Unchanged;
}
_db.SaveChanges();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, movie);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { movieId = movie.MovieId }));
return(response);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public ActionResult Edit([Bind(Include = "ID,Title,ReleaseDate,GenreID")] Movies movies)
{
if (ModelState.IsValid)
{
db.Entry(movies).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.GenreID = new SelectList(db.Genre, "ID", "Genre1", movies.GenreID);
return(View(movies));
}
public ActionResult Edit([Bind(Include = "Theater_id,Screen_id,No_of_Seats,Current_Movie,ThreeD")] Screen screen)
{
if (ModelState.IsValid)
{
db.Entry(screen).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Theater_id = new SelectList(db.Theaters, "Theater_id", "TheaterName", screen.Theater_id);
return(View(screen));
}
public ActionResult Edit([Bind(Include = "MovieID,MovieName,MovieDescription,MovieGenre")] Movie movie)
{
if (ModelState.IsValid)
{
db.Entry(movie).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MovieGenre = new SelectList(db.Genres, "GenreID", "GenreName", movie.MovieGenre);
return(View(movie));
}
public ActionResult Edit([Bind(Include = "RentalID,MovieID,CustomerID,RentalDate,DueDate,ReturnDate")] RentRecord rentRecord)
{
if (ModelState.IsValid)
{
db.Entry(rentRecord).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "CustomerName", rentRecord.CustomerID);
ViewBag.MovieID = new SelectList(db.Movies, "MovieID", "MovieName", rentRecord.MovieID);
return(View(rentRecord));
}
public ActionResult Edit([Bind(Include = "RentalID,CustomerID,MovieID,DateRented")] Rental rental)
{
if (ModelState.IsValid)
{
db.Entry(rental).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "FirstName", rental.CustomerID);
ViewBag.MovieID = new SelectList(db.Movies, "MovieID", "Title", rental.MovieID);
return(View(rental));
}
/// <summary>
/// Delete user by user's id
/// </summary>
/// <param name="userId"></param>
public void DeleteUserByUserId(long userId)
{
User userToDelete;
using (var ctx = new MoviesEntities())
{
userToDelete = ctx.Users.Where(s => s.UserId == userId).FirstOrDefault <User>();
}
using (var newContext = new MoviesEntities())
{
newContext.Entry(userToDelete).State = EntityState.Deleted;
newContext.SaveChanges();
}
}
/// <summary>
/// Delete producer based on producer id
/// </summary>
/// <param name="producerId"></param>
public void DeleteProducerByProducerId(long producerId)
{
tblProducer producerToDelete;
using (var ctx = new MoviesEntities())
{
producerToDelete = ctx.tblProducers.Where(s => s.ProducerID == producerId).FirstOrDefault <tblProducer>();
}
using (var newContext = new MoviesEntities())
{
newContext.Entry(producerToDelete).State = EntityState.Deleted;
newContext.SaveChanges();
}
}
/// <summary>
/// Delete movie from the database
/// </summary>
/// <param name="movieId"></param>
public void DeleteMovieByMovieId(long movieId)
{
tblMovy movieToDelete;
using (var ctx = new MoviesEntities())
{
movieToDelete = ctx.tblMovies.Where(s => s.MovieID == movieId).FirstOrDefault <tblMovy>();
}
using (var newContext = new MoviesEntities())
{
newContext.Entry(movieToDelete).State = EntityState.Deleted;
newContext.SaveChanges();
}
}
public ActionResult Edit([Bind(Include = "Id,Title,ReleaseDate,Director")] Movie movie)
{
// Validate the movie
if (!MovieValidate(movie))
{
ModelState.AddModelError("Title", "There is another movie with the same title and director");
}
if (ModelState.IsValid)
{
db.Entry(movie).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movie));
}
//a Movie object with the data from the Edit view
//is passed into this action method
//binding is used to ensure that only content for certain fields
//is accepted
public ActionResult Edit([Bind(Include = "Id,Title,ReleaseDate,Genre,Price,ImageUrl")] Movie movie)
{
//if the ImageUrl field is empty, give it a default value to stop the Url.Content
//helper crashing the application
if (movie.ImageUrl == null)
{
movie.ImageUrl = "https://pbs.twimg.com/profile_images/836629578554748928/DHbaSYYv_400x400.jpg";
}
if (ModelState.IsValid)
{
//the edited record is tagged for changing at
//the next database update
db.Entry(movie).State = EntityState.Modified;
//database is updated
db.SaveChanges();
//user is returned to the Index view
return(RedirectToAction("Index"));
}
return(View(movie));
}
// PUT api/<controller>/5
public HttpResponseMessage Put(int actorId, Actor actor)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
if (actorId != actor.ActorId)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
_db.Entry(actor).State = EntityState.Modified;
try
{
_db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
