public ActionResult Create([Bind(Include = "CustomerID,FirstName,LastName,Phone")] Customer customer) { if (ModelState.IsValid) { db.Customers.Add(customer); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customer)); }
public ActionResult Create([Bind(Include = "MovieID,Title,Director,Genre")] Movy movy) { if (ModelState.IsValid) { db.Movies.Add(movy); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(movy)); }
public ActionResult Create([Bind(Include = "RentalID,CustomerID,MovieID,RentalDate")] Rental rental) { if (ModelState.IsValid) { db.Rentals.Add(rental); 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)); }
public void InsertCustomers_DAL(Customer obj_Customers_insert) { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { //adding object to movies table db.Customers.Add(obj_Customers_insert); db.SaveChanges(); } }
// calling the object from business.Movies_BAL public void InsertMovies_DAL(Movy obj_movie_insert) { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { //adding object to movies table db.Movies.Add(obj_movie_insert); db.SaveChanges(); } }
//Inserting data to return movie table public static void InsertReturnedMovie(MovieReturned Obj_Returned_Movie_Insert) { try { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { db.MovieReturneds.Add(Obj_Returned_Movie_Insert); db.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static void DeletCustomer(string Obj_Cust_Delete) { try { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { //Lembda expression for deleting customer Customer c = db.Customers.SingleOrDefault(x => x.CustomerID.ToString().Trim() == Obj_Cust_Delete.Trim()); if (c != null) { db.Customers.Remove(c); db.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public static void DeleteMovie(string Obj_mov_Delete) { try { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { //Lembda expression to delete movie Movy c = db.Movies.SingleOrDefault(x => x.MovieID.ToString().Trim() == Obj_mov_Delete.Trim()); if (c != null) { db.Movies.Remove(c); db.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public static int UpdateCustomer(Customer Obj_Cust_Update) { try { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { //Lembda expression for updating customer Customer c = db.Customers.SingleOrDefault(x => x.CustomerID == Obj_Cust_Update.CustomerID); c.FirstName = Obj_Cust_Update.FirstName; c.LastName = Obj_Cust_Update.LastName; c.Address = Obj_Cust_Update.Address; c.Phone = Obj_Cust_Update.Phone; db.SaveChanges(); return(Obj_Cust_Update.CustomerID); } } catch (Exception ex) { throw ex; } }
public static int UpdateMovie(Movy Obj_Movi_Update) { try { using (MovieRentalDBEntities db = new MovieRentalDBEntities()) { //Lembda expression to update movie Movy c = db.Movies.SingleOrDefault(x => x.MovieID == Obj_Movi_Update.MovieID); c.Title = Obj_Movi_Update.Title; c.Year = Obj_Movi_Update.Year; c.Gener = Obj_Movi_Update.Gener; c.RentPerDay = Obj_Movi_Update.RentPerDay; db.SaveChanges(); return(Obj_Movi_Update.MovieID); } } catch (Exception ex) { throw ex; } }