private void DeleteMovie_Click(object sender, EventArgs e)
{
try
{
if (MovieId.Text.ToString().Equals(""))
{
MessageBox.Show("Select the Movie First to delete ");
}
else
{
DatabaseModule.Movie obj_Movie = new DatabaseModule.Movie(1, txtName.Text.ToString(), txtScore.Text.ToString(), Convert.ToInt32(txtYear.Text.ToString()), Convert.ToInt32(txtCost.Text.ToString()), Convert.ToInt32(txtCopies.Text.ToString()));
if (obj_Movie.srchMovieData(Convert.ToInt32(MovieId.Text.ToString())) == 0)
{
obj_Movie.delMovie(Convert.ToInt32(MovieId.Text.ToString()));
MessageBox.Show("Movie Record is deleted from the Database ");
}
else
{
MessageBox.Show("Movie is already booked ");
}
txtName.Text = "";
txtScore.Text = "";
txtYear.Text = "";
txtCost.Text = "";
txtCopies.Text = "";
MovieId.Text = "";
}
}
catch (Exception ex) {
MessageBox.Show("error " + ex.Message);
}
}
private void ShowVideo_Click(object sender, EventArgs e)
{
DatabaseModule.Movie obj = new DatabaseModule.Movie(1, "txtName.Text.ToString()", "txtScore.Text.ToString()", 2019, 5, 5);
obj.Datarecord(Database);
movie = 1;
rent = 0;
customer = 0;
}
private void UpdateMovie_Click(object sender, EventArgs e)
{
if (txtName.Text.ToString().Equals("") || txtScore.Text.ToString().Equals("") || MovieId.Text.ToString().Equals("") || txtYear.Text.ToString().Equals("") || txtCopies.Text.ToString().Equals(""))
{
MessageBox.Show("Fill all the details of the Movie POrtal to keep it up to Date ");
}
else
{
DatabaseModule.Movie obj_Movie = new DatabaseModule.Movie(1, txtName.Text.ToString(), txtScore.Text.ToString(), Convert.ToInt32(txtYear.Text.ToString()), Convert.ToInt32(txtCost.Text.ToString()), Convert.ToInt32(txtCopies.Text.ToString()));
obj_Movie.updateMovie(Convert.ToInt32(MovieId.Text.ToString()));
MessageBox.Show("Movie Record is Updated in the Database Table ");
txtName.Text = "";
txtScore.Text = "";
txtYear.Text = "";
txtCost.Text = "";
txtCopies.Text = "";
MovieId.Text = "";
}
}
private void AddMovie_Click(object sender, EventArgs e)
{
if (txtName.Text.ToString().Equals("") || txtScore.Text.ToString().Equals("") || txtYear.Text.ToString().Equals("") || txtCopies.Text.ToString().Equals(""))
{
MessageBox.Show("Fill all the details of the Movie POrtal to keep it up to Date ");
}
else
{
try
{
//dislay the cost of the price of the video after adding the year of the video
DateTime dateNow = DateTime.Now;
int Currentyear = dateNow.Year;
int diffYear = Currentyear - Convert.ToInt32(txtYear.Text.ToString());
// MessageBox.Show(diff.ToString());
if (diffYear >= 5)
{
txtCost.Text = "2";
}
if (diffYear >= 0 && diffYear < 5)
{
txtCost.Text = "5";
}
}
catch (Exception ex)
{
}
DatabaseModule.Movie obj_Movie = new DatabaseModule.Movie(1, txtName.Text.ToString(), txtScore.Text.ToString(), Convert.ToInt32(txtYear.Text.ToString()), Convert.ToInt32(txtCost.Text.ToString()), Convert.ToInt32(txtCopies.Text.ToString()));
obj_Movie.addMovie();
MessageBox.Show("Movie Record is saved in the Database Table and the Movie Rental Cost is ==$" + txtCost.Text);
txtName.Text = "";
txtScore.Text = "";
txtYear.Text = "";
txtCost.Text = "";
txtCopies.Text = "";
}
}
private void btnMostMovie_Click(object sender, EventArgs e)
{
DatabaseModule.Movie obj_Movie = new DatabaseModule.Movie(1, " txtName.Text.ToString()", " txtScore.Text.ToString()", 2019, 5, 5);
MessageBox.Show("" + obj_Movie.mostMovie());
}
