private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox1.Text != "System.Data.DataRowView")
{
SqlServerFull _sqlServerSpectacle = new SqlServerFull();
DataSet _dataSetSpectacle = new DataSet();
_sqlServerSpectacle.SelectSqlCommand = "SELECT * FROM spectacle WHERE (spectacle_id = " + comboBox1.Text + ")";
if (_sqlServerSpectacle.ExecuteFill(_dataSetSpectacle, "spectacle"))
{
label2.Text = "(" + _dataSetSpectacle.Tables["spectacle"].Rows[0]["spectacle_name"].ToString() + ")";
}
else MessageBox.Show("Произошла ошибка загрузки данных о спектаклях.");
}
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox2.Text != "System.Data.DataRowView")
{
SqlServerFull _sqlServerPlaces = new SqlServerFull();
DataSet _dataSetPlaces = new DataSet();
_sqlServerPlaces.SelectSqlCommand = "SELECT * FROM places WHERE (places_id = " + comboBox2.Text + ")";
if (_sqlServerPlaces.ExecuteFill(_dataSetPlaces, "places"))
{
label4.Text = "(Ряд: " + _dataSetPlaces.Tables["places"].Rows[0]["places_series"].ToString() +
" Место: " + _dataSetPlaces.Tables["places"].Rows[0]["places_place"].ToString() +
" Цена: " + _dataSetPlaces.Tables["places"].Rows[0]["places_price"].ToString() + ")";
}
else MessageBox.Show("Произошла ошибка загрузки данных о местах.");
}
}
private void dataLoad()
{
SqlServerFull _sqlServerSpectacle = new SqlServerFull();
DataSet _dataSetSpectacle = new DataSet();
_sqlServerSpectacle.SelectSqlCommand = "SELECT * FROM spectacle";
if (_sqlServerSpectacle.ExecuteFill(_dataSetSpectacle, "spectacle"))
{
comboBox1.DataSource = _dataSetSpectacle.Tables["spectacle"];
comboBox1.DisplayMember = "spectacle_id";
}
else MessageBox.Show("Произошла ошибка загрузки данных о спектаклях.");
SqlServerFull _sqlServerPlaces = new SqlServerFull();
DataSet _dataSetPlaces = new DataSet();
_sqlServerPlaces.SelectSqlCommand = "SELECT * FROM places";
if (_sqlServerPlaces.ExecuteFill(_dataSetPlaces, "places"))
{
comboBox2.DataSource = _dataSetPlaces.Tables["places"];
comboBox2.DisplayMember = "places_id";
}
else MessageBox.Show("Произошла ошибка загрузки данных о местах.");
if (this.Text == "Изменить билет.")
{
SqlServerFull _sqlServerTicket = new SqlServerFull();
DataSet _dataSetTicket = new DataSet();
_sqlServerTicket.SelectSqlCommand = "SELECT * FROM ticket WHERE (ticket_id = " + ID.ToString() + ")";
if (_sqlServerTicket.ExecuteFill(_dataSetTicket, "ticket"))
{
comboBox1.Text = _dataSetTicket.Tables["ticket"].Rows[0]["ticket_spectacle"].ToString();
comboBox2.Text = _dataSetTicket.Tables["ticket"].Rows[0]["ticket_place"].ToString();
comboBox3.Text = _dataSetTicket.Tables["ticket"].Rows[0]["ticket_order"].ToString();
comboBox4.Text = _dataSetTicket.Tables["ticket"].Rows[0]["ticket_subscription"].ToString();
}
else MessageBox.Show("Произошла ошибка открытия данных о выбраном билете.");
}
}
