private void btnEditShow_Click(object sender, EventArgs e)
{
string id = idShow.Text;
string time = timeShow.Text;
string day = dayShow.Text;
string tn = tnShow.Text;
string idm = idmShow.Text;
string idr = idrShow.Text;
Showtime_DTO show = new Showtime_DTO(id, time, day, tn, idm, idr);
Showtime_BUS.EditShowtime(show);
MessageBox.Show("Showtime was deleted", "My Application", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Close();
}
private void addShow_Click(object sender, EventArgs e)
{
string id = idAddShowtime.Text;
string time = timeAddShow.Text;
string day = dayAddShowTime.Value.ToString();
string tn = ticketNumberAddShowtime.Text;
string idm = idMovieAddShowTime.Text;
string idr = idRoomAddShowTime.Text;
Showtime_DTO showtime = new Showtime_DTO(id, time, day.Substring(0, 10), tn, idm, idr);
Showtime_BUS.AddShowtime(showtime);
MessageBox.Show("Complete!", "Add showtime", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Close();
}
//Add a showtime
public static void AddShowTime(Showtime_DTO showtime)
{
SqlConnection connecter = sqlConnectionData.Connecter();
SqlCommand commander = new SqlCommand("AddShowTime", connecter);
commander.CommandType = CommandType.StoredProcedure;
commander.Parameters.Add("@id", SqlDbType.Char, 10).Value = showtime.Id;
commander.Parameters.Add("@time", SqlDbType.Time).Value = showtime.Time;
commander.Parameters.Add("@day", SqlDbType.Date).Value = showtime.Date;
commander.Parameters.Add("@tn", SqlDbType.Int).Value = showtime.Ticketnumber;
commander.Parameters.Add("@idm", SqlDbType.Char, 10).Value = showtime.Idmovie;
commander.Parameters.Add("@idr", SqlDbType.Char, 10).Value = showtime.Idroom;
connecter.Open();
commander.ExecuteNonQuery();
connecter.Close();
}
//Edit info showtime
public static void EditShowtime(Showtime_DTO showtime)
{
Showtime_DAO.EditShowTime(showtime);
}
//Add a showtime
public static void AddShowtime(Showtime_DTO showtime)
{
Showtime_DAO.AddShowTime(showtime);
}
