private void button3_Click(object sender, EventArgs e)
{
MovieBooking obj = new MovieBooking();
DataTable tbl = new DataTable();
tbl = obj.Sql_Record("select * from RentalTable");
dgvTable.DataSource = tbl;
record = "rental";
}
private void btn_BookVideo_Click(object sender, EventArgs e)
{
MovieBooking obj = new MovieBooking(Convert.ToInt32(txt_CustomerID.Text), Convert.ToInt32(txt_MovieID.Text), dtp_IssueDate.Text);
txt_CustomerID.Text = "";
txt_MovieID.Text = "";
tarun_CustomerAddress.Text = "";
tarun_CustomerFName.Text = "";
tarun_CustomerLName.Text = "";
tarun_CustomerMobile.Value = 0;
tarun_VideoTitle.Text = "";
tarun_VideoRatting.Text = "";
tarun_movie_year.Text = "";
tarun_VideoCopies.Value = 0;
tarun_VideoCost.Value = 0;
tarun_VideoPlot.Text = "";
tarun_VideoGenre.Text = "";
}
private void btn_DeleteVideo_Click(object sender, EventArgs e)
{
// delete the movie to delete
MovieBooking obj = new MovieBooking(rentId);
txt_CustomerID.Text = "";
txt_MovieID.Text = "";
tarun_CustomerAddress.Text = "";
tarun_CustomerFName.Text = "";
tarun_CustomerLName.Text = "";
tarun_CustomerMobile.Value = 0;
tarun_VideoTitle.Text = "";
tarun_VideoRatting.Text = "";
tarun_movie_year.Text = "";
tarun_VideoCopies.Value = 0;
tarun_VideoCost.Value = 0;
tarun_VideoPlot.Text = "";
tarun_VideoGenre.Text = "";
rentId = 0;
}
private void btn_ReturnVideo_Click(object sender, EventArgs e)
{
/* try
* {
*/
MovieBooking obj = new MovieBooking(rentId, Convert.ToInt32(txt_CustomerID.Text), Convert.ToInt32(txt_MovieID.Text), dtp_IssueDate.Text, dtp_ReturnDate.Text);
DateTime new_date = DateTime.Now;
Movie objct = new Movie();
//convert the old date from string to Date fromat
DateTime prev_date = Convert.ToDateTime(dtp_IssueDate.Text);
//get the difference in the days fromat
String Daysdiff = (new_date - prev_date).TotalDays.ToString();
// calculate the round off value
Double DaysInterval = Math.Round(Convert.ToDouble(Daysdiff));
string query1 = "select * from MovieTable where Movie_Pk=" + Convert.ToInt32(txt_MovieID.Text) + "";
DataTable tbl1 = new DataTable();
tbl1 = objct.Sql_Record(query1);
int cost = Convert.ToInt32(tbl1.Rows[0]["Movie_Cost"]);
int Price = Convert.ToInt32(DaysInterval) * cost;
MessageBox.Show("Your bill is: " + Price);
/*
* }
* catch (Exception ex)
* {
* MessageBox.Show("select the video to return ");
* }
* finally {*/
txt_CustomerID.Text = "";
txt_MovieID.Text = "";
tarun_CustomerAddress.Text = "";
tarun_CustomerFName.Text = "";
tarun_CustomerLName.Text = "";
tarun_CustomerMobile.Value = 0;
tarun_VideoTitle.Text = "";
tarun_VideoRatting.Text = "";
tarun_movie_year.Text = "";
tarun_VideoCopies.Value = 0;
tarun_VideoCost.Value = 0;
tarun_VideoPlot.Text = "";
tarun_VideoGenre.Text = "";
// }
}
