//закрытие данной формы и переход к форме списка товаров private void roundBtnSweets_Click(object sender, EventArgs e) { this.Close(); GC.Collect(); ProductsAdmin ProductsAdmin = new ProductsAdmin(); ProductsAdmin.Visible = true; ProductsAdmin.ShowInTaskbar = true; }
//закрытие данной формы и переход к форме списка товаров private void picArrawBack_Click(object sender, EventArgs e) { this.Close(); GC.Collect(); ProductsAdmin ProductsAdmin = new ProductsAdmin(); ProductsAdmin.Visible = true; ProductsAdmin.ShowInTaskbar = true; }
//изменение данных записи в таблице бд по заполненным полям и закрытие формы private void roundBtnChange_Click(object sender, EventArgs e) { using (SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-9IUFQMM\SQLEXPRESS;Initial Catalog=PateticoPractic;Integrated Security=True")) { double price1 = 0, weight1 = 0; try { price1 = Convert.ToDouble(txtForPrice.Text); weight1 = Convert.ToDouble(txtForWeight.Text); try { conn.Open(); SqlCommand cmd = conn.CreateCommand(); //SqlCommand cmd_1 = conn.CreateCommand(); cmd.CommandText = "UPDATE [Products] SET product_name = @Name, description = @Content, price = @Price, weight = @Weight, id_parameter = @IDPar WHERE id_product = @ID"; cmd.Parameters.AddWithValue(@"ID", ProdID); cmd.Parameters.AddWithValue(@"Name", txtForProductName.Text); cmd.Parameters.AddWithValue(@"Content", txtForDescription.Text); cmd.Parameters.AddWithValue(@"Price", price1); cmd.Parameters.AddWithValue(@"Weight", weight1); cmd.Parameters.AddWithValue(@"IDPar", comboBoxParameters.SelectedValue); cmd.ExecuteNonQuery(); MessageBox.Show("Запись успешно изменена!", "Изменение записи"); ProductsAdmin ProductsAdmin = new ProductsAdmin(); ProductsAdmin.Visible = true; ProductsAdmin.ShowInTaskbar = true; this.Close(); GC.Collect(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } } catch { MessageBox.Show("Введите корректную цену!"); txtForPrice.Text = ""; } } }