//RentedMovie Gridview Bind Data here
private void RentedMovieGridData()
{
DataTable ds = new RentedMOvies().ShowAllRentedMovies();
RentalDataGridView.DataSource = ds;
RentalDataGridView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
//Get Customers who borrow most movies
private void button3_Click(object sender, EventArgs e)
{
try
{
TabControlSystem.SelectedTab = TabControlSystem.TabPages["RentedMovies"];
DataTable dt = new RentedMOvies().CustBorrowMostMovies();
RentalDataGridView.DataSource = dt;
RentalDataGridView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//Display all rented movies from customer
private void DropDownAllCust_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int customerId = int.Parse(DropDownAllCust.SelectedValue.ToString());
if (customerId > 0)
{
ddlRentedMovies.Enabled = true;
DataTable dsRented = new RentedMOvies().ShowRentedMoviesDDL(customerId);
if (dsRented.Rows.Count > 0)
{
DataRow row = dsRented.NewRow();
row[0] = 0;
row[1] = "Select...";
dsRented.Rows.InsertAt(row, 0); // add item at INDEX = 0;
ddlRentedMovies.DisplayMember = "Title";
ddlRentedMovies.ValueMember = "MovieId";
ddlRentedMovies.DataSource = dsRented;
}
else
{
ddlRentedMovies.Enabled = false;
}
}
else
{
ddlRentedMovies.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
