private void button_add_abonent_Click(object sender, EventArgs e)
{
var form = new AbonentForm();
var res = form.ShowDialog();
if (res == DialogResult.OK)
{
var surname = form.surname_textbox.Text;
var name = form.name_textbox.Text;
var patronymic = form.patronymic_textbox.Text;
var comment = form.comment_textbox.Text;
var address = form.address_textbox.Text;
form.dateTimePicker_bd.CustomFormat = "yyyy-MM-dd";
form.dateTimePicker_bd.Format = DateTimePickerFormat.Custom;
var birth_day = form.dateTimePicker_bd.Value;
var connection = new SqlConnection(connectionString);
connection.Open();
var request = @"INSERT INTO Mikolaichuk_Abonent (surname, name, patronymic, address, birth_date, comment)
VALUES ('" + surname + "','" + name + "','" + patronymic + "','" + address + "','" + birth_day.ToString("yyyy-MM-dd") + "','" + comment + "')";
var command = new SqlCommand(request, connection);
command.ExecuteNonQuery();
connection.Close();
updateAbonentDGV();
updatePhoneHelpDGV();
}
}
private void changeabonent_button_Click(object sender, EventArgs e)
{
var row = abonent_grid.SelectedRows.Count > 0 ? abonent_grid.SelectedRows[0] : null;
if (row == null)
{
MessageBox.Show("Сначала укажите строку!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var form = new AbonentForm();
form.surname_textbox.Text = row.Cells["surname"].Value.ToString();
form.name_textbox.Text = row.Cells["name"].Value.ToString();
form.patronymic_textbox.Text = row.Cells["patronymic"].Value.ToString();
form.address_textbox.Text = row.Cells["address"].Value.ToString();
form.comment_textbox.Text = row.Cells["comment"].Value.ToString();
form.dateTimePicker_bd.Text = row.Cells["birth_date"].Value.ToString();
var res = form.ShowDialog();
if (res == DialogResult.OK)
{
var surname = form.surname_textbox.Text;
var name = form.name_textbox.Text;
var patronymic = form.patronymic_textbox.Text;
var comment = form.comment_textbox.Text;
var address = form.address_textbox.Text;
form.dateTimePicker_bd.CustomFormat = "yyyy-MM-dd";
form.dateTimePicker_bd.Format = DateTimePickerFormat.Custom;
var birth_day = form.dateTimePicker_bd.Value;
var id = row.Cells["id"].Value.ToString();
var connection = new SqlConnection(connectionString);
connection.Open();
var request = @"UPDATE Mikolaichuk_Abonent SET
surname='" + surname + "', name='" + name + "', patronymic='" + patronymic + "', address='" + address + "'," +
" birth_date='" + birth_day.ToString("yyyy-MM-dd") + "', comment='" + comment + "' WHERE id='" + id + "'";
var command = new SqlCommand(request, connection);
command.ExecuteNonQuery();
connection.Close();
updateAbonentDGV();
updatePhoneHelpDGV();
}
}
