示例#1
0
 // Return Movie Button (This button used for return movie details)
 private void ReturnMovies_Click(object sender, EventArgs e)
 {
     con.Open();// Connection Open
     comm = new SqlCommand("update RentalMovies set ReturnDate= '" + RentalReturnDate.Text + "' where RentalMoviesId = '" + RentalMovieID.Text + "' ", con);
     try
     {
         comm.ExecuteNonQuery();
         MessageBox.Show("Movie Return");
         con.Close();// Connection Close
         ShowRentalMoviesRecord();
         RentalMovieID.Clear();
         RentalCustomerID.Clear();
         RentalsMovieID.Clear();
         RentalIssueDate.Clear();
         RentalReturnDate.Clear();
     }
     catch (Exception)
     {
         MessageBox.Show("Movie Not Return");
     }
     finally
     {
         con.Close();// Connection Close
     }
 }
示例#2
0
 // Issue Movies Button (This button used for Issue Movie)
 private void IssueMovies_Click(object sender, EventArgs e)
 {
     con.Open();// Connection Open
     comm = new SqlCommand("insert into RentalMovies values('" + RentalMovieID.Text + "','" + RentalsMovieID.Text + "','" + RentalCustomerID.Text + "','" + RentalIssueDate.Text + "','" + RentalReturnDate.Text + "')", con);
     try
     {
         comm.ExecuteNonQuery();
         MessageBox.Show("Rental Movie Saved");
         con.Close();// Connection Close
         ShowRentalMoviesRecord();
         RentalMovieID.Clear();
         RentalCustomerID.Clear();
         RentalsMovieID.Clear();
         RentalIssueDate.Clear();
         RentalReturnDate.Clear();
     }
     catch (Exception)
     {
         MessageBox.Show("Rental Movie Not Saved");
     }
     finally
     {
         con.Close();// Connection Close
     }
 }