private void button7_Click(object sender, System.EventArgs e) { Category category = new Category() { CategoryName = newCategoryName.Text }; _baseWorker.AddNewCategory(category); RefreshCategories(); }
private void button6_Click(object sender, System.EventArgs e) { Category oldCategory = categoryesListBox.SelectedItem as Category; if (oldCategory != null) { Category newCategory = new Category() { CategoryName = categoryNameTextBox.Text }; _baseWorker.ChangeCategory(oldCategory, newCategory); RefreshCategories(); } }
public void DeleteCategory(Category category) { using (SqlCommand sqlCommand = new SqlCommand(RemoveCategory, _sqlConnection)) { sqlCommand.Parameters.AddWithValue("@categoryId", category.Id); if (sqlCommand.ExecuteNonQuery() > 0) { MessageBox.Show("Категория удалена"); } else { MessageBox.Show("Ошибка при удалении"); } } }
public void ChangeCategory(Category oldCategory, Category newCategory) { using (SqlCommand sqlCommand = new SqlCommand(UpdateCategory, _sqlConnection)) { sqlCommand.Parameters.AddWithValue("@categoryName", newCategory.CategoryName); sqlCommand.Parameters.AddWithValue("@categoryId", oldCategory.Id); if (sqlCommand.ExecuteNonQuery() > 0) { MessageBox.Show("Категория изменена"); } else { MessageBox.Show("Ошибка при изменении"); } } }
public List<Attack> Attacks(Category category) { List<Attack> attacks = new List<Attack>(); using (SqlCommand sqlCommand = new SqlCommand(SelectattacksCategory, _sqlConnection)) { sqlCommand.Parameters.AddWithValue("@id", category.Id); using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader()) { if (sqlDataReader.HasRows) { while (sqlDataReader.Read()) { attacks.Add(new Attack() { Id = int.Parse(sqlDataReader["Id"].ToString()), AttackName = sqlDataReader["Attack_Name"].ToString(), AttackClass = int.Parse(sqlDataReader["Attack_Class"].ToString()) }); } return attacks; } return attacks; } } }
public void AddNewCategory(Category category) { using (SqlCommand sqlCommand = new SqlCommand(AddCategoty, _sqlConnection)) { sqlCommand.Parameters.AddWithValue("@categoryName", category.CategoryName); if (sqlCommand.ExecuteNonQuery() > 0) { // MessageBox.Show("Добвленно"); } else { MessageBox.Show("Ошибка при добавлении"); } } }