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();
}
}