Esempio n. 1
0
        private void add_provider_button_Click(object sender, EventArgs e)
        {
            var form = new ProviderForm();
            var res  = form.ShowDialog();

            if (res == DialogResult.OK)
            {
                var name  = form.name_provider_textbox.Text;
                var score = form.score_provider_textbox.Text;

                var connection = new SqlConnection(connectionString);
                connection.Open();

                var request = @"INSERT INTO Mikolaichuk_Provider (name, score) 
                    VALUES ('" + name + "','" + score + "')";

                var command = new SqlCommand(request, connection);
                command.ExecuteNonQuery();

                connection.Close();
                updateProviderDGV();
            }
        }
Esempio n. 2
0
        private void edit_provider_button_Click(object sender, EventArgs e)
        {
            var row = provider_grid.SelectedRows.Count > 0 ? provider_grid.SelectedRows[0] : null;

            if (row == null)
            {
                MessageBox.Show("Сначала укажите строку!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            var form = new ProviderForm();

            form.name_provider_textbox.Text  = row.Cells["name"].Value.ToString();
            form.score_provider_textbox.Text = row.Cells["score"].Value.ToString();

            var res = form.ShowDialog();

            if (res == DialogResult.OK)
            {
                var name  = form.name_provider_textbox.Text;
                var score = form.score_provider_textbox.Text;
                var id    = row.Cells["id"].Value.ToString();

                var connection = new SqlConnection(connectionString);
                connection.Open();

                var request = @"UPDATE Mikolaichuk_Provider SET 
                        name='" + name + "', score='" + score + "' WHERE id='" + id + "'";
                var command = new SqlCommand(request, connection);
                command.ExecuteNonQuery();

                connection.Close();
                updateProviderDGV();
                updateContactDGV();
                updatePhoneHelpDGV();
            }
        }