private void btnretmov_Click(object sender, EventArgs e) { RentedMovies rmov = new RentedMovies(); int index = ddcust.SelectedIndex; if (index != 0) { int val = (int)ddcust.SelectedValue; rmov.set_CID(val); } else { MessageBox.Show("Select Customer"); } index = ddmov.SelectedIndex; if (index != 0) { int val = (int)ddmov.SelectedValue; rmov.set_MID(val); } else { MessageBox.Show("Select Customer"); } if (rmov.get_CID() != 0 && rmov.get_MID() != 0) { //rmov.set_RMID(int.Parse(textrmid.Text)); //rmov.set_CID(int.Parse(lblcidfk.Text)); //rmov.set_MID(int.Parse(lblmidfk.Text)); rmov.returned(); } BindRetnal(); }
public async Task <IActionResult> PutRentedMovies(int id, RentedMovies rentedMovies) { if (id != rentedMovies.Id) { return(BadRequest()); } _context.Entry(rentedMovies).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!RentedMoviesExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public static RentedMovies Getrental(int RMID) { SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("getrental", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@rentalid", RMID); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { RentedMovies b = new RentedMovies(); b.MovieIDFK = dr["MovieIDFK"].ToString(); b.CustIDFK = dr["CustIDFK"].ToString(); b.DateRented = dr["DateRented"].ToString(); b.DateReturned = Double.Parse(dr["DateReturned"].ToString()); return(b); } else { return(null); } } catch (Exception ex) { return(null); } finally { con.Close(); } }
public async Task <IActionResult> Edit(int id, [Bind("RentedMovieId,UserId,TvShowId")] RentedMovies rentedMovies) { if (id != rentedMovies.RentedMoviesId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(rentedMovies); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!RentedMoviesExists(rentedMovies.RentedMoviesId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["TvShowId"] = new SelectList(_context.TvShow, "ID", "ImageUrl", rentedMovies.TvShowId); return(View(rentedMovies)); }
public async Task <ActionResult <RentedMovies> > PostRentedMovies(RentedMovies rentedMovies) { _context.RentedMovies.Add(rentedMovies); await _context.SaveChangesAsync(); return(CreatedAtAction("GetRentedMovies", new { id = rentedMovies.Id }, rentedMovies)); }
public async Task <IActionResult> Edit(int id, [Bind("RentedMovieId,UsersID,TvShowID,RentDate,ReturnDate")] RentedMovies rentedMovies) { if (id != rentedMovies.RentedMovieId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(rentedMovies); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!RentedMoviesExists(rentedMovies.RentedMovieId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(rentedMovies)); }
//Rented Movie private void btnissumov_Click(object sender, EventArgs e) { RentedMovies rmov = new RentedMovies(); int index = ddcust.SelectedIndex; if (index != 0) { int val = (int)ddcust.SelectedValue; rmov.set_CID(val); } else { MessageBox.Show("Select Customer"); } index = ddmov.SelectedIndex; if (index != 0) { int val = (int)ddmov.SelectedValue; rmov.set_MID(val); } else { MessageBox.Show("Select Customer"); } if (rmov.get_CID() != 0 && rmov.get_MID() != 0) { rmov.insert(); } BindRetnal(); }
public void BindRetnal() { RentedMovies obj = new RentedMovies(); obj.getRentedMovies(dataGridView3); bindcmov(); bindcust(); }
public async Task <IActionResult> Create([Bind("RMID,MovieIDFK,CustIDFK,DateRented,DateReturned")] RentedMovies rentedMovies) { if (ModelState.IsValid) { _context.Add(rentedMovies); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(rentedMovies)); }
public async Task <IActionResult> Create([Bind("RentedMovieId,UserId,TvShowId")] RentedMovies rentedMovies) { if (ModelState.IsValid) { _context.Add(rentedMovies); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["UserId"] = new SelectList(_context.Users, "UserId", "Name", rentedMovies.UserId); ViewData["TvShowId"] = new SelectList(_context.TvShow, "ID", "ImageUrl", rentedMovies.TvShowId); return(View(rentedMovies)); }
public void Return(int TvShowId, int UserId) { RentedMovies rentedMovies = _context.RentedMovies.FirstOrDefault(x => x.ReturnDate == null && x.TvShowId == TvShowId); rentedMovies.ReturnDate = DateTime.Now; _context.Update(rentedMovies); _context.SaveChangesAsync(); TvShow TvShow = _context.TvShow.FirstOrDefault(x => x.ID == TvShowId); TvShow.Available = false; _context.Update(TvShow); _context.SaveChangesAsync(); //return RedirectToAction("Index", "TvShows"); }
public bool HireMovieUpdateEntry(RentedMovies rentedMovie) { bool isRent = false; var checkRentedTo = context.RenteredSetMovies.FirstOrDefault(x => x.RentedID == rentedMovie.RentedID); checkRentedTo.CustomerID = rentedMovie.CustomerID; checkRentedTo.MovieID = rentedMovie.MovieID; checkRentedTo.RentedTo = rentedMovie.RentedTo; context.SaveChanges(); isRent = true; return(isRent); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } RentedMovies = await _context.RentedMovies.FindAsync(id); if (RentedMovies != null) { _context.RentedMovies.Remove(RentedMovies); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } RentedMovies = await _context.RentedMovies .Include(r => r.Customers) .Include(r => r.Movie).FirstOrDefaultAsync(m => m.ID == id); if (RentedMovies == null) { return(NotFound()); } return(Page()); }
public void Rent(int TvShowId, int UserId) { RentedMovies rentedMovies = new RentedMovies(); rentedMovies.TvShowId = TvShowId; rentedMovies.UserId = UserId; rentedMovies.RentalDate = DateTime.Now; _context.Add(rentedMovies); _context.SaveChanges(); TvShow TvShow = _context.TvShow.FirstOrDefault(x => x.ID == TvShowId); TvShow.Available = true; _context.Update(TvShow); _context.SaveChanges(); //return RedirectToAction("Index","TvShows"); }
/// <summary> /// Creates a new record in RentedMovies table, saves changes to Database, and then closes the form /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnRentMovie_Click(object sender, EventArgs e) { if (TheCustomer is null) { MessageBox.Show(Resources.select_customer); return; } RentedMovies newRentedMovie = new RentedMovies(); using (var context = new Entities()) { newRentedMovie.MovieIDFK = Convert.ToInt32(TheMovie["MovieID"].Value);//turns out you can use the column names instead of numbers in a DGVCellCollection newRentedMovie.CustIDFK = Convert.ToInt32(TheCustomer["CustID"].Value); newRentedMovie.DateRented = DateTime.Now; context.RentedMovies.Add(newRentedMovie); context.SaveChanges(); } Close(); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } RentedMovies = await _context.RentedMovies .Include(r => r.Customers) .Include(r => r.Movie).FirstOrDefaultAsync(m => m.ID == id); if (RentedMovies == null) { return(NotFound()); } ViewData["CustomerId"] = new SelectList(_context.Customer, "CustomerID", "CustomerID"); ViewData["MovieId"] = new SelectList(_context.Movie, "MovieID", "MovieID"); return(Page()); }
public void /*Task<IActionResult>*/ Rent(int TvShowId, int UserId) { RentedMovies rentedMovies = new RentedMovies(); rentedMovies.TvID = TvShowId; rentedMovies.UsersID = UserId; rentedMovies.RentDate = DateTime.Now; _context.Add(rentedMovies); /*await _context.SaveChangesAsync();*/ TvShow TvShow = _context.TvShow.FirstOrDefault(x => x.TvShowsId == TvShowId); TvShow.Available = true; _context.Update(TvShow); _context.SaveChanges(); /*await _context.SaveChangesAsync();*/ /*return RedirectToAction("Index", "TvShows");*/ }
public void Setup() { rentals = Substitute.For <IRentals>(); datetime = Substitute.For <IDateTime>(); sut = new RentedMovies(datetime); }
private void radioout_Click(object sender, EventArgs e) { RentedMovies mov = new RentedMovies(); mov.getoutRentedMovies(dataGridView3); }