//Add New Movie here private void btnAddMOvie_Click_1(object sender, EventArgs e) { try { string Title, Rent, Year, Rating, Genre; Title = txtTitle.Text.Trim(); Rent = txtRentedCost.Text.Trim(); Rating = txtRating.Text.Trim(); Year = txtYear.Text.Trim(); Genre = txtGenre.Text.Trim(); if (Title.Equals("")) { MessageBox.Show("Movie title is required!"); } else if (Year.Equals("")) { MessageBox.Show("Movie released year is required!"); } else if (Genre.Equals("")) { MessageBox.Show("Movie genre is required!"); } else if (Rent.Equals("")) { MessageBox.Show("Movie rent cost is required!"); } else if (Rating.Equals("")) { MessageBox.Show("Movie rating is required!"); } else { SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString; con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "insert into movies values(@Title,@Year,@Rent,@Genre,@Rating)"; cmd.Connection = con; cmd.Parameters.Add(new SqlParameter("@Title", Title)); cmd.Parameters.Add(new SqlParameter("@Rent", Rent)); cmd.Parameters.Add(new SqlParameter("@Genre", Genre)); cmd.Parameters.Add(new SqlParameter("@Year", Year)); cmd.Parameters.Add(new SqlParameter("@Rating", Rating)); bool result = cmd.ExecuteNonQuery() > 0; if (result) { BindGridMovies(); // method calling to Bind Grid Movies MessageBox.Show("Movie Info Saved!", "Alert"); txtTitle.Text = ""; txtYear.Text = ""; txtRating.Text = ""; txtGenre.Text = ""; txtRentedCost.Text = ""; } else { MessageBox.Show("Movie Info NOT Saved!", "Alert"); } cmd.Dispose(); con.Dispose(); } } catch (Exception exp) { MessageBox.Show(exp.Message); } }
//Update movie Info private void btnUpdate_Click(object sender, EventArgs e) { try { string Title, Rent, Year, Rating, Genre; Title = txtTitle.Text.Trim(); Rent = txtRentedCost.Text.Trim(); Rating = txtRating.Text.Trim(); Year = txtYear.Text.Trim(); Genre = txtGenre.Text.Trim(); string movieId = tbxMovieID.Text.Trim(); if (Title.Equals("")) { MessageBox.Show("Movie title is required!"); } else if (Year.Equals("")) { MessageBox.Show("Movie released year is required!"); } else if (Genre.Equals("")) { MessageBox.Show("Movie genre is required!"); } else if (Rent.Equals("")) { MessageBox.Show("Movie rent cost is required!"); } else if (Rating.Equals("")) { MessageBox.Show("Movie rating is required!"); } else { SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString; con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "UpdateMovieInfo"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@movieid", movieId)); cmd.Parameters.Add(new SqlParameter("@title", Title)); cmd.Parameters.Add(new SqlParameter("@rent", Rent)); cmd.Parameters.Add(new SqlParameter("@genre", Genre)); cmd.Parameters.Add(new SqlParameter("@year", Year)); cmd.Parameters.Add(new SqlParameter("@rating", Rating)); bool result = cmd.ExecuteNonQuery() > 0; if (result) { BindGridMovies(); // method calling to Bind Grid Movies MessageBox.Show("Movie Info updated!", "Alert"); tbxCustomerID.Text = ""; txtTitle.Text = ""; txtYear.Text = ""; txtRating.Text = ""; txtGenre.Text = ""; txtRentedCost.Text = ""; } else { MessageBox.Show("Movie Info NOT Updated!", "Alert"); } cmd.Dispose(); con.Dispose(); } } catch (Exception exp) { MessageBox.Show(exp.Message); } }