private void ProcLoad(object sender, RoutedEventArgs e)
{
SQL_Class.SQL_OpenServer();
data1 = new List <string>();
ProcLabel.Background = Brushes.Red;
data1.Add("Выберете процессор");
var combo = sender as ComboBox;
sql = "SELECT * FROM `processor`";
MySqlCommand command = new MySqlCommand(sql, SQL_Class.connection);
MySqlDataReader reader = command.ExecuteReader();
combo.SelectedIndex = 0;
while (reader.Read())
{
data1.Add(reader[1].ToString() + " " + reader[2].ToString());
}
combo.ItemsSource = data1;
/* Обнуление лишней строки */
data1.Remove("Выберете процессор");
combo.ItemsSource = data1;
reader.Close();
SQL_Class.SQL_CloseServer();
}
private void Proс_Selection(object sender, SelectionChangedEventArgs e)
{
string spname = "Выберете процессор";
var selected = sender as ComboBox;
if (!(spname == selected.SelectedItem as string))
{
string name = selected.SelectedItem as string;
string[] stringer = name.Split(' ');
if (factor)
{
SQL_Class.SQL_OpenServer();
sql = "SELECT * FROM `processor` WHERE `Название` = " + '"' + stringer[0] + '"';
MySqlCommand nextCommand = new MySqlCommand(sql, SQL_Class.connection);
MySqlDataReader reader = nextCommand.ExecuteReader();
while (reader.Read())
{
allID = System.Convert.ToInt32(reader[0].ToString());
}
reader.Close();
SQL_Class.SQL_CloseServer();
}
ProcLabel.Background = Brushes.Transparent;
}
GlobalDataBase.pr = Convert.ToString(selected.SelectedItem);
SovmestReloader();
}
private void BlockLoad(object sender, RoutedEventArgs e)
{
SQL_Class.SQL_OpenServer();
data6 = new List <string>();
data6.Add("Выберете блок питания");
var combo = sender as ComboBox;
sql = "SELECT * FROM `power`";
MySqlCommand command = new MySqlCommand(sql, SQL_Class.connection);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
data6.Add(reader[1].ToString() + " " + reader[2].ToString());
}
reader.Close();
SQL_Class.SQL_CloseServer();
combo.SelectedIndex = 0;
combo.ItemsSource = data6;
data6.Remove("Выберете блок питания");
combo.ItemsSource = data6;
BlockLabel.Background = Brushes.Red;
}
private void OperLoad(object sender, RoutedEventArgs e)
{
SQL_Class.SQL_OpenServer();
data4 = new List <string>();
data4.Add("Выберете оперативную память");
var combo = sender as ComboBox;
sql = "SELECT * FROM `operativa`";
MySqlCommand command = new MySqlCommand(sql, SQL_Class.connection);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
data4.Add(reader[1].ToString() + " " + reader[2].ToString());
}
reader.Close();
SQL_Class.SQL_CloseServer();
combo.SelectedIndex = 0;
combo.ItemsSource = data4;
data4.Remove("Выберете оперативную память");
combo.ItemsSource = data4;
OperLabel.Background = Brushes.Red;
}
private void MatLoad(object sender, RoutedEventArgs e)
{
SQL_Class.SQL_OpenServer();
data2 = new List <string>();
data2.Add("Выберете материнскую плату");
var combo = sender as ComboBox;
sql = "SELECT * FROM `motherboard`";
MySqlCommand command = new MySqlCommand(sql, SQL_Class.connection);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
data2.Add(reader[1].ToString() + " " + reader[2].ToString());
}
reader.Close();
SQL_Class.SQL_CloseServer();
combo.SelectedIndex = 0;
combo.ItemsSource = data2;
data2.Remove("Выберете материнскую плату");
combo.ItemsSource = data2;
MatLabel.Background = Brushes.Red;
}
private void SovmestReloader()
{
if (factor)
{
SQL_Class.SQL_OpenServer();
data2 = new List <string>();
data2.Add("Выберете материнскую плату");
sql = "SELECT * FROM `motherboard` WHERE `id` = " + allID.ToString();
MySqlCommand nextCommand = new MySqlCommand(sql, SQL_Class.connection);
MySqlDataReader reader = nextCommand.ExecuteReader();
while (reader.Read())
{
data2.Add(reader[1].ToString() + " " + reader[2].ToString());
}
reader.Close();
SQL_Class.SQL_CloseServer();
combo2.ItemsSource = data2;
combo2.SelectedIndex = 0;
data2.Remove("Выберете материнскую плату");
combo2.ItemsSource = data2;
SQL_Class.SQL_CloseServer();
/*----------------------------------------------------------------------------------------------------------------*/
SQL_Class.SQL_OpenServer();
data3 = new List <string>();
data3.Add("Выберете видеокарту");
sql = "SELECT * FROM `videocard` WHERE `id` = " + allID.ToString();
MySqlCommand nextCommand3 = new MySqlCommand(sql, SQL_Class.connection);
MySqlDataReader reader3 = nextCommand3.ExecuteReader();
while (reader3.Read())
{
data3.Add(reader3[1].ToString() + " " + reader3[2].ToString());
}
reader3.Close();
SQL_Class.SQL_CloseServer();
combo3.ItemsSource = data3;
combo3.SelectedIndex = 0;
data3.Remove("Выберете видеокарту");
combo3.ItemsSource = data3;
SQL_Class.SQL_CloseServer();
/*----------------------------------------------------------------------------------------------------------------*/
SQL_Class.SQL_OpenServer();
data4 = new List <string>();
data4.Add("Выберете оперативную память");
sql = "SELECT * FROM `operativa` WHERE `id` = " + allID.ToString();
MySqlCommand nextCommand4 = new MySqlCommand(sql, SQL_Class.connection);
MySqlDataReader reader4 = nextCommand4.ExecuteReader();
while (reader4.Read())
{
data4.Add(reader4[1].ToString() + " " + reader4[2].ToString());
}
reader4.Close();
SQL_Class.SQL_CloseServer();
combo4.ItemsSource = data4;
combo4.SelectedIndex = 0;
data4.Remove("Выберете оперативную память");
combo4.ItemsSource = data4;
SQL_Class.SQL_CloseServer();
/*----------------------------------------------------------------------------------------------------------------*/
SQL_Class.SQL_OpenServer();
data5 = new List <string>();
data5.Add("Выберете хранилище данных");
sql = "SELECT * FROM `hdd` WHERE `id` = " + allID.ToString();
MySqlCommand nextCommand5 = new MySqlCommand(sql, SQL_Class.connection);
MySqlDataReader reader5 = nextCommand5.ExecuteReader();
while (reader5.Read())
{
data5.Add(reader5[1].ToString() + " " + reader5[2].ToString());
}
reader5.Close();
SQL_Class.SQL_CloseServer();
combo5.ItemsSource = data5;
combo5.SelectedIndex = 0;
data5.Remove("Выберете хранилище данных");
combo5.ItemsSource = data5;
SQL_Class.SQL_CloseServer();
/*----------------------------------------------------------------------------------------------------------------*/
SQL_Class.SQL_OpenServer();
data6 = new List <string>();
data6.Add("Выберете блок питания");
sql = "SELECT * FROM `power` WHERE `id` = " + allID.ToString();
MySqlCommand nextCommand6 = new MySqlCommand(sql, SQL_Class.connection);
MySqlDataReader reader6 = nextCommand6.ExecuteReader();
while (reader6.Read())
{
data6.Add(reader6[1].ToString() + " " + reader6[2].ToString());
}
reader6.Close();
SQL_Class.SQL_CloseServer();
combo6.ItemsSource = data6;
combo6.SelectedIndex = 0;
data6.Remove("Выберете блок питания");
combo6.ItemsSource = data6;
SQL_Class.SQL_CloseServer();
}
}