public movieView()
{
InitializeComponent();
dbConnection dbc = new dbConnection();
dbc.selection("moive", dataGridView1);
}
public insertSeatView()
{
InitializeComponent();
dbConnection dbc = new dbConnection();
dbc.Fill_Combo("auditorium_name", "auditorium", comboBox1);
}
public screeningView()
{
InitializeComponent();
dbConnection dbc = new dbConnection();
dbc.selection("screening", dataGridView1);
}
public reservation2(String auditorium_name, String movie_title, String screening_start)
{
InitializeComponent();
this.label3.Text = auditorium_name.ToString();
this.label4.Text = movie_title.ToString();
this.label5.Text = screening_start.ToString();
label3.Hide();
label4.Hide();
label5.Hide();
String connString = "Data Source=127.0.0.1;" + "Initial Catalog=movie_ticket_reservation_system;" + "User id=root;" + "Password='';";
String get_id = "SELECT * FROM auditorium WHERE auditorium_name = " + "'" + this.label3.Text + "'";
MySqlConnection conn = new MySqlConnection(connString);
MySqlCommand command = new MySqlCommand(get_id, conn);
try
{
MySqlDataReader reader;
conn.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
String auditorium_id = reader["auditorium_id"].ToString();
String data_to_be_filled_in_seat = "seat_number";
String commandText1 = "SELECT * FROM seat WHERE auditorium_id = " + "'" + auditorium_id + "'";
dbConnection dbc = new dbConnection();
dbc.Fill_Seat(data_to_be_filled_in_seat, commandText1, comboBox1);
conn.Close();
}
}
catch
{
}
}
public void Fill_Combo(String data_name, String database_name, ComboBox combo_box)
{
dbConnection dbc = new dbConnection();
String connString = "Data Source=127.0.0.1;" + "Initial Catalog=movie_ticket_reservation_system;" + "User id=root;" + "Password='';";
String commandText = "SELECT * FROM " + database_name;
MySqlConnection conn = new MySqlConnection(connString);
MySqlCommand command = new MySqlCommand(commandText, conn);
try
{
MySqlDataReader reader;
conn.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
String data = reader.GetString(data_name);
combo_box.Items.Add(data);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public reservationView()
{
InitializeComponent();
dbConnection dbc = new dbConnection();
dbc.Fill_Combo("auditorium_name", "auditorium", comboBox1);
dbc.Fill_Combo("movie_title", "moive", comboBox3);
dbc.Fill_Combo("screening_start", "screening", comboBox5);
}
public insertScreeningView()
{
InitializeComponent();
dbConnection dbc = new dbConnection();
dbc.Fill_Combo("movie_title", "moive", comboBox1);
dbc.Fill_Combo("auditorium_name", "auditorium", comboBox2);
Fillcombothree();
}
private void button1_Click(object sender, EventArgs e)
{
String database_name = "auditorium";
String input_data = Interaction.InputBox("Enter the id of the auditorium", "Delete", "", 0, 0);
String commandText = "DELETE FROM " + database_name + " WHERE auditorium_id = " + input_data;
dbConnection DBC = new dbConnection();
DBC.deletion(commandText);
table_load();
}
private void button1_Click(object sender, EventArgs e)
{
dbConnection dbconn = new dbConnection();
String data_one = this.textBox1.Text;
String data_two = this.textBox2.Text;
String commandText = "INSERT INTO auditorium VALUES('', '" + data_one + "', '" + data_two + "')";
dbconn.insert(commandText);
}
private void button1_Click(object sender, EventArgs e)
{
dbConnection dbc = new dbConnection();
String selectedindex1 = comboBox1.SelectedItem.ToString();
String selectedindex2 = comboBox2.SelectedItem.ToString();
String data_three = comboBox3.SelectedItem.ToString();
//String commandText = "INSERT INTO `seat` (`seat_id`, `seat_row`, `seat_number`, `auditorium_id`) VALUES (NULL, '"+ data_one + "', '" + data_two + "', '" + data_three + "')";
//dbc.insert(commandText);
String connString = "Data Source=127.0.0.1;" + "Initial Catalog=movie_ticket_reservation_system;" + "User id=root;" + "Password='';";
String get_id = "SELECT * FROM moive WHERE movie_title = " + "'" + selectedindex1 + "'";
String get_id2 = "SELECT * FROM auditorium WHERE auditorium_name = " + "'" + selectedindex2 + "'";
MySqlConnection conn = new MySqlConnection(connString);
MySqlCommand command = new MySqlCommand(get_id, conn);
MySqlCommand command2 = new MySqlCommand(get_id2, conn);
try
{
MySqlDataReader reader;
conn.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
String data_one = reader["movie_id"].ToString();
conn.Close();
try
{
MySqlDataReader reader1;
conn.Open();
reader1 = command2.ExecuteReader();
while (reader1.Read())
{
String data_two = reader1["auditorium_id"].ToString();
String commandText = "INSERT INTO `screening` (`screening_id`, `movie_id`, `auditorium_id`, `screening_start`) VALUES (NULL, '" + data_one + "', '" + data_two + "', '" + data_three + "')";
dbc.insert(commandText);
}
}
catch (Exception ex)
{
}
}
conn.Close();
Console.ReadLine();
}
catch (Exception ex)
{
}
}
private void button1_Click(object sender, EventArgs e)
{
String data_one = this.textBox1.Text;
String data_two = this.textBox2.Text;
String data_three = this.textBox3.Text;
String data_four = this.textBox4.Text;
String data_five = this.textBox5.Text;
String commandText = "INSERT INTO `moive` (`movie_id`, `movie_title`, `movie_director`, `movie_cast`, `movie_description`, `movie_duration_min`) VALUES (NULL, '" + data_one + "', '" + data_two + "', '" + data_three + "', '" + data_four + "', '" + data_five + "')";
dbConnection dbc = new dbConnection();
dbc.insert(commandText);
}
private void button1_Click(object sender, EventArgs e)
{
dbConnection dbc = new dbConnection();
String data_one = this.textBox1.Text;
String data_two = this.textBox3.Text;
String selectedindex = comboBox1.SelectedItem.ToString();
//String commandText = "INSERT INTO `seat` (`seat_id`, `seat_row`, `seat_number`, `auditorium_id`) VALUES (NULL, '"+ data_one + "', '" + data_two + "', '" + data_three + "')";
//dbc.insert(commandText);
String connString = "Data Source=127.0.0.1;" + "Initial Catalog=movie_ticket_reservation_system;" + "User id=root;" + "Password='';";
String get_id = "SELECT * FROM auditorium WHERE auditorium_name = " + "'" + selectedindex + "'";
MySqlConnection conn = new MySqlConnection(connString);
MySqlCommand command = new MySqlCommand(get_id, conn);
Datagyi dg = new Datagyi();
try
{
MySqlDataReader reader;
conn.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
String data_three = reader["auditorium_id"].ToString();
String commandText = "INSERT INTO `seat` (`seat_id`, `seat_row`, `seat_number`, `auditorium_id`) VALUES (NULL, '" + data_one + "', '" + data_two + "', '" + data_three + "')";
dbc.insert(commandText);
}
Console.ReadLine();
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void table_load()
{
dbConnection dbc = new dbConnection();
dbc.selection("auditorium", dataGridView1);
}
private void button1_Click(object sender, EventArgs e)
{
String auditorium_name = this.label3.Text;
String movie_title = this.label4.Text;
String screening_start = this.label5.Text;
String seat_number = this.comboBox1.SelectedItem.ToString();
String cost = this.textBox2.Text;
String connString = "Data Source=127.0.0.1;" + "Initial Catalog=movie_ticket_reservation_system;" + "User id=root;" + "Password='';";
String get_id = "SELECT * FROM auditorium WHERE auditorium_name = " + "'" + auditorium_name + "'";
String get_id2 = "SELECT * FROM moive WHERE movie_title = " + "'" + movie_title + "'";
MySqlConnection conn = new MySqlConnection(connString);
MySqlCommand command = new MySqlCommand(get_id, conn);
MySqlCommand command2 = new MySqlCommand(get_id2, conn);
try
{
MySqlDataReader reader;
conn.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
String auditorium_id = reader["auditorium_id"].ToString();
conn.Close();
try
{
MySqlDataReader reader2;
conn.Open();
reader2 = command2.ExecuteReader();
while (reader2.Read())
{
String movie_id = reader2["movie_id"].ToString();
conn.Close();
String get_screening_id = "SELECT * FROM screening WHERE movie_id = " + "'" + movie_id + "'" + " AND auditorium_id = " + "'" + auditorium_id + "'" + "AND screening_start = " + "'" + screening_start + "'";
MySqlCommand command3 = new MySqlCommand(get_screening_id, conn);
try
{
MySqlDataReader reader3;
conn.Open();
reader3 = command3.ExecuteReader();
while (reader3.Read())
{
String screening_id = reader3["screening_id"].ToString();
conn.Close();
String get_seat_id = "SELECT * FROM seat WHERE seat_number = " + "'" + seat_number + "'";
MySqlCommand command4 = new MySqlCommand(get_seat_id, conn);
try
{
MySqlDataReader reader4;
conn.Open();
reader4 = command4.ExecuteReader();
while (reader4.Read())
{
String seat_id = reader4["seat_id"].ToString();
conn.Close();
dbConnection dbc = new dbConnection();
String commandText = "INSERT INTO `finalreservation` (`res_id`, `screening_id`, `seat_id`, `cost`) VALUES (NULL, '" + screening_id + "', '" + seat_id + "', '" + cost + "')";
dbc.insert(commandText);
}
}
catch (Exception ex)
{
}
}
}
catch (Exception ex)
{
}
}
}
catch (Exception ex)
{
}
}
}
catch (Exception ex)
{
}
}
public void Table_Load()
{
dbConnection dbc = new dbConnection();
dbc.selection("seat", dataGridView1);
}
private void button9_Click(object sender, EventArgs e)
{
dbConnection dbconn = new dbConnection();
}
