private void picClose_Click(object sender, EventArgs e) //Закрытие данной формы и переход на предыдущую (Medicines) { this.Close(); GC.Collect(); Medicines medicines = new Medicines(); medicines.Visible = true; medicines.ShowInTaskbar = true; }
private void picClose_Click(object sender, EventArgs e) //Закрытие формы и переход к меню администратора { this.Close(); GC.Collect(); Medicines medicines = new Medicines(); medicines.Visible = true; medicines.ShowInTaskbar = true; }
private void changeMedicines_Click(object sender, EventArgs e) { this.Close(); GC.Collect(); Medicines medicines = new Medicines(); medicines.Visible = true; medicines.ShowInTaskbar = true; }
private void btnChange_Click(object sender, EventArgs e) //Изменение данных при нажатии на кнопку изменить { using (SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-O3331SL\SQLEXPRESS;Initial Catalog=PharmPanaceya;Integrated Security=True")) { if (txtAmount.TextLength != 0 && txtCategories.TextLength != 0 && txtDiscription.TextLength != 0 && txtName.TextLength != 0 && txtPrice.TextLength != 0) { try { conn.Open(); SqlCommand cmd = conn.CreateCommand(); SqlCommand cmd_1 = conn.CreateCommand(); SqlCommand cmd_2 = conn.CreateCommand(); cmd_1.CommandText = "SELECT IDCategory FROM [Categories] WHERE Name = @name"; cmd_1.Parameters.AddWithValue(@"name", txtCategories.Text); int typeEx = int.Parse(cmd_1.ExecuteScalar().ToString()); cmd.CommandText = "UPDATE [Medicines] SET Name = @Name, IDCategory = @IDCategory, Description = @Description, Price = @Price, Amount = @Amount, Presence = @Presence WHERE IDMedicine = @IDMedicine"; cmd.Parameters.AddWithValue(@"IDMedicine", MedId); cmd.Parameters.AddWithValue(@"IDCategory", typeEx); cmd.Parameters.AddWithValue(@"Name", txtName.Text); cmd.Parameters.AddWithValue(@"Description", txtDiscription.Text); cmd.Parameters.AddWithValue(@"Price", txtPrice.Text); cmd.Parameters.AddWithValue(@"Amount", txtAmount.Text); string how; if (checkPresence.Checked == true) { how = "True"; } else { how = "False"; } cmd.Parameters.AddWithValue(@"Presence", how); cmd.ExecuteNonQuery(); MessageBox.Show("Запись успешно изменена!"); Medicines medicines = new Medicines(); medicines.Show(); this.Hide(); GC.Collect(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } } else { MessageBox.Show("Введите данные!"); } } }
private void btnAdd_Click(object sender, EventArgs e) //Добавление записи в БД при нажатии на копку добавить по заполнению необходимых полей { if (txtAmount.TextLength != 0 && txtCategories.TextLength != 0 && txtDiscription.TextLength != 0 && txtName.TextLength != 0 && txtPrice.TextLength != 0) { using (SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-O3331SL\SQLEXPRESS;Initial Catalog=PharmPanaceya;Integrated Security=True")) { try { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "INSERT INTO [Medicines] VALUES (@IDCategory,@Name,@Description,@Price,@Amount,@Presence)"; cmd.Parameters.AddWithValue(@"IDCategory", type.type); cmd.Parameters.AddWithValue(@"Name", txtName.Text); cmd.Parameters.AddWithValue(@"Description", txtDiscription.Text); cmd.Parameters.AddWithValue(@"Price", txtPrice.Text); cmd.Parameters.AddWithValue(@"Amount", txtAmount.Text); string how; if (checkPresence.Checked == true) { how = "True"; } else { how = "False"; } cmd.Parameters.AddWithValue(@"Presence", how); cmd.ExecuteNonQuery(); MessageBox.Show("Запись успешно добавлена!"); Medicines medicines = new Medicines(); medicines.Show(); this.Hide(); GC.Collect(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } } } else { MessageBox.Show("Введите данные!"); } }