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