private void SearchButton_Click(object sender, EventArgs e)
{
SqlConnection sqlConnection = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Ippodrom.mdf;Integrated Security=True");
sqlConnection.Open();
SqlDataAdapter sqlDataAdapter = null;
if (HorseFRB.Checked)
{
sqlDataAdapter = new SqlDataAdapter($"SELECT * FROM HorseView Where Name Like '%{SearchTextBox.Text}%' OR Sex Like '%{SearchTextBox.Text}%' OR Color Like '%{SearchTextBox.Text}%' OR Country Like '%{SearchTextBox.Text}%'", sqlConnection);
}
if (RiderFRB.Checked)
{
sqlDataAdapter = new SqlDataAdapter($"SELECT * FROM RiderView Where Name Like '%{SearchTextBox.Text}%' OR Sex Like '%{SearchTextBox.Text}%' OR Country Like '%{SearchTextBox.Text}%'", sqlConnection);
}
if (LapsFRB.Checked)
{
sqlDataAdapter = new SqlDataAdapter($"SELECT * FROM LapView Where Name Like '%{SearchTextBox.Text}%' OR Country Like '%{SearchTextBox.Text}%' OR [Horse-winner name] LIKE '%{SearchTextBox.Text}%' OR [Rider-winner name] LIKE '%{SearchTextBox.Text}%'", sqlConnection);
}
SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(sqlDataAdapter);
DataSet dataSetbuf = new DataSet();
sqlDataAdapter.Fill(dataSetbuf);
SearchDatagrid.DataSource = dataSetbuf.Tables[0];
SearchDatagrid.Show();
}
private void RefreshMainPanel()
{
switch (Mode)
{
case 0:
niceLabel1.Text = "Horses";
horseViewDataGridView.Show();
riderViewDataGridView.Hide();
lapViewDataGridView.Hide();
FlowLayoutSearch.Hide();
break;
case 1:
niceLabel1.Text = "Riders";
horseViewDataGridView.Hide();
riderViewDataGridView.Show();
lapViewDataGridView.Hide();
FlowLayoutSearch.Hide();
break;
case 2:
niceLabel1.Text = "Laps";
horseViewDataGridView.Hide();
riderViewDataGridView.Hide();
lapViewDataGridView.Show();
FlowLayoutSearch.Hide();
break;
case 3:
niceLabel1.Text = "Search";
horseViewDataGridView.Hide();
riderViewDataGridView.Hide();
lapViewDataGridView.Hide();
FlowLayoutSearch.Show();
SearchDatagrid.Hide();
break;
}
}
