private void button1_Click(object sender, EventArgs e) { try { if (movieTime.Value.TimeOfDay >= new TimeSpan(16, 0, 0) && movieTime.Value.TimeOfDay <= new TimeSpan(23, 30, 0)) { movie m = new movie(); m.movieName = movieName.Text; m.dateAndTime = movieDate.Value.Date + movieTime.Value.TimeOfDay; m.durationInMinutes = Convert.ToInt32(movieDuration.Text); m.typeName = types[movieType.SelectedIndex].typeName; m.cinemaName = cinemas[movieCinema.SelectedIndex].cinemaName; db.movie.Add(m); db.SaveChanges(); } else { MessageBox.Show(String.Format("Time must be between {0} and {1}", cinemas[movieCinema.SelectedIndex].Opening, cinemas[movieCinema.SelectedIndex].Closing)); } } catch { MessageBox.Show("An error occured", "Error", MessageBoxButtons.OK); } finally { frm.RefreshGrid(); //this.Close(); } }
private void resMovieButton_Click(object sender, EventArgs e) { if (isAdmin) { string command = String.Format( "DELETE FROM movie where cinemaName = '{0}' and movieName = '{1}' and CONVERT(VARCHAR,dateAndTime,120) = '{2}';", movieDetail.cinemaName, movieDetail.movieName, movieDetail.dateAndTime.ToString("yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.GetCultureInfo("en-us", "en")) ); db.Database.ExecuteSqlCommand(command); frm.RefreshGrid(); this.Close(); } else { var form = new SeatingForm(movieDetail); form.ShowDialog(); } }