public MovieActorBO SearchEvent(int maID)
        {
            MovieActorBO ma = new MovieActorBO();
            ma.MovieActorID = maID;

            string searchString = "SELECT * FROM MovieActor where id = " + ma.MovieActorID;

            using (conn = new SqlConnection(connectionString))
            {
                conn.Open();

                SqlCommand command = new SqlCommand(searchString, conn);
                SqlDataReader reader = command.ExecuteReader();

                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        ma.MovieID = reader.GetInt32(reader.GetOrdinal("MovieID"));
                        ma.ActorID = reader.GetInt32(reader.GetOrdinal("ActorID"));
                    }
                }

                conn.Close();
            }

            return ma;
        }
        public void DeleteEvent(MovieActorBO ma)
        {
            string deleteString = "DELETE FROM MovieActor WHERE id = '" + ma.MovieActorID + "'";

            using (conn = new SqlConnection(connectionString))
            {
                conn.Open();
                SqlCommand command = new SqlCommand(deleteString, conn);
                command.ExecuteNonQuery();

                conn.Close();
            }
        }
        public void InsertEvent(MovieActorBO ma)
        {
            string insertString = @"INSERT INTO MovieActor(
                                                MovieID,
                                                ActorID)
                                                            values(
                                                            @movieID,@actorID
                                                                        )";

            using (conn = new SqlConnection(connectionString))
            {
                conn.Open();
                SqlCommand command = new SqlCommand(insertString, conn);

                command.Parameters.Add("@movieID", ma.MovieID);
                command.Parameters.Add("@actorID", ma.ActorID);
                command.CommandType = CommandType.Text;
                command.ExecuteNonQuery();

                conn.Close();
            }
        }
        public void UpdateEvent(MovieActorBO ma)
        {
            string updateString = @"UPDATE MovieActor
                                           SET
                                               MovieID=@movieID,
                                               ActorID=@actorID
                                               WHERE id = '" + ma.MovieActorID + "'";

            using (conn = new SqlConnection(connectionString))
            {
                conn.Open();
                SqlCommand command = new SqlCommand(updateString, conn);

                command.Parameters.Add("@movieID", ma.MovieID);
                command.Parameters.Add("@actorID", ma.ActorID);

                command.ExecuteNonQuery();

                conn.Close();
            }
        }