private void Button1_Click(object sender, EventArgs e)
        {
            CoordinatorEdit coordinatorEdit = new CoordinatorEdit("", ID);

            coordinatorEdit.ShowDialog();
            UpdateTable();
        }
        private void Button3_Click(object sender, EventArgs e)
        {
            CoordinatorEdit coordinatorEdit = new CoordinatorEdit(textBox1.Text, ID);

            SqlConnection connection = UserCoordinator.GetDBConnection();

            connection.Open();
            SqlTransaction transaction = connection.BeginTransaction();

            try
            {
                using (SqlCommand sql = new SqlCommand())
                {
                    SqlCommand sqlCom =
                        new SqlCommand(@"SELECT WorkerID, ZoneID, TimeStart, TimeEnd, EventID  FROM Appointment WHERE ID = @ID", connection);
                    sqlCom.Transaction = transaction;
                    sqlCom.Parameters.Add("@ID", SqlDbType.Int);
                    sqlCom.Parameters["@ID"].Value = Convert.ToInt32(textBox1.Text);
                    SqlDataReader reader = sqlCom.ExecuteReader();
                    if (reader.Read() && reader.GetInt32(4).ToString() == ID)
                    {
                        int rankID = reader.GetInt32(1);
                        if (rankID != 4 && rankID != 5)
                        {
                            coordinatorEdit.textBox1.Text           = reader.GetInt32(0).ToString();
                            coordinatorEdit.comboBox1.SelectedIndex = rankID - 1;
                            coordinatorEdit.textBox4.Text           = reader.GetDateTime(2).ToString("dd/MM/yyyy HH:mm");
                            coordinatorEdit.textBox5.Text           = reader.GetDateTime(3).ToString("dd/MM/yyyy HH:mm");
                            reader.Close();
                            coordinatorEdit.ShowDialog();
                            UpdateTable();
                            transaction.Commit();
                        }
                        else
                        {
                            MessageBox.Show("Вы не имеете права изменять организатора и координатора мероприятия.", "Ошибка");
                            transaction.Rollback();
                        }
                    }
                    else
                    {
                        reader.Close();
                        MessageBox.Show("Такого номера нет в таблице.", "Ошибка");
                        transaction.Rollback();
                    }
                }
            } catch (Exception ex)
            {
                MessageBox.Show("Что-то пошло не так! Обратитесь к разработчику.", "Ошибка");
                transaction.Rollback();
            }
            connection.Close();
        }