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();
}
}
