protected void OnDeleteClick(object sender, EventArgs e)
        {
            using (Database1Entities db = new Database1Entities())
            {
                var query = (from a in db.Movies select a).ToList();
                var result = query.Where(a => a.Id == Int32.Parse( movieID.Text)).FirstOrDefault();

                db.Movies.Remove(result);

                db.SaveChanges();

                message.Text = "Movie successfully deleted!";

            }
        }
        protected void OnButton_Click(object sender, EventArgs e)
        {
            using (Database1Entities db = new Database1Entities())
            {
                Movie movie = new Movie();

                movie.Title = title.Text;
                movie.Format = format.SelectedValue;
                movie.Length = Int32.Parse(length.Text);
                movie.Release_Year = Int32.Parse(releaseYear.Text);
                movie.Rating = Int32.Parse(rating.SelectedValue);

                db.Movies.Add(movie);
                db.SaveChanges();

                message.Text="Movie successfully created!";
            }
        }