internal static void AddMovie(RentInfo newmovie)
{
string connectionString = ConfigurationManager.ConnectionStrings["MovieRental"].ConnectionString;
//string queryString0 = @"Delete from MOVIE_INFO where MOVIE_ID = @MOVIE_ID";
string queryString = @"Insert into MOVIE_INFO (MOVIE_ID,MOVIE_TITLE)
values(@MOVIE_ID,@MOVIE_TITLE)";
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand cmd2 = new SqlCommand();
try
{
cmd2 = new SqlCommand(queryString, connection);
cmd2.Parameters.AddWithValue("@MOVIE_ID", newmovie.movieID);
cmd2.Parameters.AddWithValue("@MOVIE_TITLE", newmovie.movieTitle);
cmd2.ExecuteNonQuery();
MessageBox.Show("Movie " + newmovie.movieID + ": " + newmovie.movieTitle +
" was successfully added.");
connection.Close();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
connection.Close();
}
}
}
public void addMovie(int id, String movietitle)
{
RentInfo newmovie = new RentInfo()
{
movieID = id,
movieTitle = movietitle
};
if (id <= 0 || movietitle == "")
{
MessageBox.Show("ID and movie title are required");
}
else
{
RentalInfoModel.AddMovie(newmovie);
}
}