private void toolStripMenuItem3_Click(object sender, EventArgs e) { DataGridViewRow selectData = dataGridView1.SelectedRows[0]; ClientRegistration clR = new ClientRegistration(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)); clR.ShowDialog(); ClientLoginRegistration clientLoginRegistration = new ClientLoginRegistration(Convert.ToInt32(selectData.Cells[0].Value), Convert.ToString(selectData.Cells[8].Value), Convert.ToString(selectData.Cells[9].Value), Convert.ToString(selectData.Cells[10].Value)); clientLoginRegistration.ShowDialog(); OwnInformation(); fitness_DbDataSet1.AcceptChanges(); }
private void buttonOK_Click(object sender, EventArgs e) { string gender = ""; if (comboBox1.SelectedIndex == 0) { gender = "Чоловіча"; } else if (comboBox1.SelectedIndex == 1) { gender = "Жіноча"; } if (!editParameter) { SqlConnection sqlConnection = new SqlConnection(sqlConnectionString); sqlConnection.Open(); SqlCommand queryInsert = new SqlCommand("INSERT INTO Клієнт (Прізвище, [Ім'я], [По-батькові], [Дата народження], Стать, Телефон, Пошта) " + "Values(@data_0, @data_1, @data_2, @data_3, @data_4, @data_5, @data_6)", sqlConnection); queryInsert.Parameters.Add("@data_0", SqlDbType.NVarChar).Value = textBox7.Text; queryInsert.Parameters.Add("@data_1", SqlDbType.NVarChar).Value = textBox1.Text; queryInsert.Parameters.Add("@data_2", SqlDbType.NVarChar).Value = textBox2.Text; queryInsert.Parameters.Add("@data_3", SqlDbType.NVarChar).Value = textBox3.Text; queryInsert.Parameters.Add("@data_4", SqlDbType.NVarChar).Value = gender; queryInsert.Parameters.Add("@data_5", SqlDbType.NVarChar).Value = textBox4.Text; queryInsert.Parameters.Add("@data_6", SqlDbType.NVarChar).Value = textBox5.Text; queryInsert.ExecuteNonQuery(); sqlConnection.Close(); MessageBox.Show("Реєстрація даних успішна. Надалі слід зареєструвати дані персонального акаунту."); clientLoginRegistration = new ClientLoginRegistration(); clientLoginRegistration.Show(); this.Close(); } else if (editParameter) { SqlConnection sqlConnection = new SqlConnection(sqlConnectionString); sqlConnection.Open(); string queryUpdate = String.Format("UPDATE Клієнт Set [Прізвище] = N'{1}', [Ім'я] = N'{2}', [По-батькові] = N'{3}', [Дата народження] = N'{4}', [Стать] = N'{5}', [Телефон] = N'{6}', [Пошта] = N'{7}' WHERE Id = '{0}' ", clientID.ToString(), textBox7.Text, textBox1.Text, textBox2.Text, textBox3.Text, gender, textBox4.Text, textBox5.Text); SqlCommand query = new SqlCommand(queryUpdate, sqlConnection); query.ExecuteNonQuery(); sqlConnection.Close(); this.Close(); } else { MessageBox.Show("Перевірте дані", "", MessageBoxButtons.OK); } }
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; } }