private void toolStripMenuItem8_Click(object sender, EventArgs e)
{
switch (label4.Text)
{
case "Групи":
AddGroup addGroup = new AddGroup();
addGroup.Show();
SqlConnection sqlConnectionString1 = new SqlConnection(ConnectionString);
SqlDataAdapter sqlDataAdapt1 = new SqlDataAdapter("SELECT * FROM Групи", sqlConnectionString1);
DataTable dataTable1 = new DataTable();
sqlDataAdapt1.Fill(dataTable1);
dataGridView1.DataSource = dataTable1;
fitness_DbDataSet1.AcceptChanges();
break;
case "Тренер":
AddCoach addCoach = new AddCoach();
addCoach.Show();
SqlConnection sqlConnectionString = new SqlConnection(ConnectionString);
SqlDataAdapter sqlDataAdapt = new SqlDataAdapter("SELECT * FROM Тренер", sqlConnectionString);
DataTable dataTable = new DataTable();
sqlDataAdapt.Fill(dataTable);
dataGridView1.DataSource = dataTable;
fitness_DbDataSet1.AcceptChanges();
break;
case "Абонемент":
AddSeasonTicket addSeasonTicket = new AddSeasonTicket();
addSeasonTicket.Show();
SqlConnection sqlConnectionString3 = new SqlConnection(ConnectionString);
SqlDataAdapter sqlDataAdapt3 = new SqlDataAdapter("SELECT * FROM Абонемент", sqlConnectionString3);
DataTable dataTable3 = new DataTable();
sqlDataAdapt3.Fill(dataTable3);
dataGridView1.DataSource = dataTable3;
fitness_DbDataSet1.AcceptChanges();
break;
case "Клієнт":
ClientRegistration clientRegistration = new ClientRegistration();
clientRegistration.Show();
string query = "SELECT Клієнт.*, [Акаунт клієнта].Логін, [Акаунт клієнта].Пароль, [Акаунт клієнта].[Перевірочне слово] FROM Клієнт, [Акаунт клієнта] WHERE Клієнт.Id = [Акаунт клієнта].ID_клієнта";
SqlConnection sqlConnectionString4 = new SqlConnection(ConnectionString);
SqlDataAdapter sqlDataAdapt4 = new SqlDataAdapter(query, sqlConnectionString4);
DataTable dataTable4 = new DataTable();
sqlDataAdapt4.Fill(dataTable4);
dataGridView1.DataSource = dataTable4;
fitness_DbDataSet1.AcceptChanges();
break;
}
}
private void toolStripMenuItem3_Click(object sender, EventArgs e)
{
switch (label4.Text)
{
case "Власна інформація":
DataGridViewRow selectData = dataGridView1.SelectedRows[0];
AdminEditing adminEditing = new AdminEditing(Convert.ToInt32(selectData.Cells[0].Value), Convert.ToString(selectData.Cells[1].Value),
Convert.ToString(selectData.Cells[2].Value), Convert.ToString(selectData.Cells[3].Value), Convert.ToDateTime(selectData.Cells[4].Value),
Convert.ToString(selectData.Cells[5].Value), Convert.ToString(selectData.Cells[6].Value), Convert.ToString(selectData.Cells[7].Value));
adminEditing.ShowDialog();
AdminLoginEditing adminLoginEditing = new AdminLoginEditing(Convert.ToInt32(selectData.Cells[0].Value), Convert.ToString(selectData.Cells[8].Value), Convert.ToString(selectData.Cells[9].Value), Convert.ToString(selectData.Cells[10].Value));
adminLoginEditing.ShowDialog();
OwnInformation();
fitness_DbDataSet1.AcceptChanges();
break;
case "Групи":
DataGridViewRow selectData1 = dataGridView1.SelectedRows[0];
AddGroup addGroup = new AddGroup(Convert.ToInt32(selectData1.Cells[0].Value), Convert.ToString(selectData1.Cells[1].Value),
Convert.ToString(selectData1.Cells[2].Value), Convert.ToInt32(selectData1.Cells[3].Value), Convert.ToInt32(selectData1.Cells[4].Value));
addGroup.ShowDialog();
SqlConnection sqlConnectionString1 = new SqlConnection(ConnectionString);
SqlDataAdapter sqlDataAdapt1 = new SqlDataAdapter("SELECT * FROM Групи", sqlConnectionString1);
DataTable dataTable1 = new DataTable();
sqlDataAdapt1.Fill(dataTable1);
dataGridView1.DataSource = dataTable1;
fitness_DbDataSet1.AcceptChanges();
break;
case "Тренер":
DataGridViewRow selectData2 = dataGridView1.SelectedRows[0];
AddCoach addCoach = new AddCoach(Convert.ToInt32(selectData2.Cells[0].Value), Convert.ToString(selectData2.Cells[1].Value),
Convert.ToString(selectData2.Cells[2].Value), Convert.ToString(selectData2.Cells[3].Value), Convert.ToDateTime(selectData2.Cells[4].Value),
Convert.ToString(selectData2.Cells[5].Value), Convert.ToString(selectData2.Cells[6].Value), Convert.ToString(selectData2.Cells[7].Value), Convert.ToString(selectData2.Cells[8].Value));
addCoach.ShowDialog();
SqlConnection sqlConnectionString = new SqlConnection(ConnectionString);
SqlDataAdapter sqlDataAdapt = new SqlDataAdapter("SELECT * FROM Тренер", sqlConnectionString);
DataTable dataTable = new DataTable();
sqlDataAdapt.Fill(dataTable);
dataGridView1.DataSource = dataTable;
fitness_DbDataSet1.AcceptChanges();
break;
case "Абонемент":
DataGridViewRow selectData3 = dataGridView1.SelectedRows[0];
AddSeasonTicket addSeasonTicket = new AddSeasonTicket(Convert.ToInt32(selectData3.Cells[0].Value), Convert.ToString(selectData3.Cells[1].Value),
Convert.ToString(selectData3.Cells[2].Value), Convert.ToString(selectData3.Cells[3].Value));
addSeasonTicket.ShowDialog();
SqlConnection sqlConnectionString3 = new SqlConnection(ConnectionString);
SqlDataAdapter sqlDataAdapt3 = new SqlDataAdapter("SELECT * FROM Абонемент", sqlConnectionString3);
DataTable dataTable3 = new DataTable();
sqlDataAdapt3.Fill(dataTable3);
dataGridView1.DataSource = dataTable3;
fitness_DbDataSet1.AcceptChanges();
break;
case "Клієнт":
DataGridViewRow selectData4 = dataGridView1.SelectedRows[0];
ClientRegistration clientRegistration = new ClientRegistration(Convert.ToInt32(selectData4.Cells[0].Value), Convert.ToString(selectData4.Cells[1].Value),
Convert.ToString(selectData4.Cells[2].Value), Convert.ToString(selectData4.Cells[3].Value), Convert.ToDateTime(selectData4.Cells[4].Value),
Convert.ToString(selectData4.Cells[5].Value), Convert.ToString(selectData4.Cells[6].Value), Convert.ToString(selectData4.Cells[7].Value));
clientRegistration.ShowDialog();
ClientLoginRegistration clientLoginRegistration = new ClientLoginRegistration(Convert.ToInt32(selectData4.Cells[0].Value), Convert.ToString(selectData4.Cells[8].Value), Convert.ToString(selectData4.Cells[9].Value), Convert.ToString(selectData4.Cells[10].Value));
clientLoginRegistration.ShowDialog();
SqlConnection sqlConnectionString4 = new SqlConnection(ConnectionString);
SqlDataAdapter sqlDataAdapt4 = new SqlDataAdapter("SELECT * FROM Клієнт", sqlConnectionString4);
DataTable dataTable4 = new DataTable();
sqlDataAdapt4.Fill(dataTable4);
dataGridView1.DataSource = dataTable4;
fitness_DbDataSet1.AcceptChanges();
break;
}
}