private void edit_contact_button_Click(object sender, EventArgs e) { var row = contact_grid.SelectedRows.Count > 0 ? contact_grid.SelectedRows[0] : null; if (row == null) { MessageBox.Show("Сначала укажите строку!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var form = new ContactForm(); form.phone_textbox.Text = row.Cells["phone"].Value.ToString(); form.typephone_textbox.Text = row.Cells["type"].Value.ToString(); { var request = "SELECT * FROM Mikolaichuk_Provider"; var adapter = new SqlDataAdapter(request, connectionString); var provider_table = new DataTable(); adapter.Fill(provider_table); var dict = new Dictionary <int, string>(); foreach (DataRow dbRow in provider_table.Rows) { dict.Add((int)dbRow["id"], dbRow["name"].ToString()); } form.ProviderData = dict; } form.ProviderIdSelect = (int)row.Cells["provider_id"].Value; var res = form.ShowDialog(); if (res == DialogResult.OK) { var phone = form.phone_textbox.Text; var type = form.typephone_textbox.Text; var provider_id = form.ProviderIdSelect; var id = row.Cells["id"].Value.ToString(); var connection = new SqlConnection(connectionString); connection.Open(); var request = @"UPDATE Mikolaichuk_Contact SET phone='" + phone + "', type='" + type + "', provider_id='" + provider_id.ToString() + "' WHERE id='" + id + "'"; var command = new SqlCommand(request, connection); command.ExecuteNonQuery(); connection.Close(); updateContactDGV(); updatePhoneHelpDGV(); } }
private void add_contact_button_Click(object sender, EventArgs e) { var form = new ContactForm(); { var request = "SELECT * FROM Mikolaichuk_Provider"; var adapter = new SqlDataAdapter(request, connectionString); var provider_table = new DataTable(); adapter.Fill(provider_table); var dict = new Dictionary <int, string>(); foreach (DataRow row in provider_table.Rows) { dict.Add((int)row["id"], row["name"].ToString()); } form.ProviderData = dict; } var res = form.ShowDialog(); if (res == DialogResult.OK) { var phone = form.phone_textbox.Text; var type = form.typephone_textbox.Text; var providerid = form.ProviderIdSelect; var connection = new SqlConnection(connectionString); connection.Open(); var request = @"INSERT INTO Mikolaichuk_Contact (phone, type, provider_id) VALUES ('" + phone + "','" + type + "','" + providerid.ToString() + "')"; var command = new SqlCommand(request, connection); command.ExecuteNonQuery(); connection.Close(); updateContactDGV(); updatePhoneHelpDGV(); } }