private void saveButton_Click(object sender, EventArgs e) { try { StockManagementSystem stockManagementSystem = new StockManagementSystem(); stockManagementSystem.CategoryName = categoryNameTextBox.Text; CategoriesMenager categoriesMenager = new CategoriesMenager(); if (string.IsNullOrEmpty(stockManagementSystem.CategoryName)) { messageLabel.Text = " Fill Up The Required Information"; messageLabel.ForeColor = Color.Red; } else { string categoryNameQuery = "SELECT * FROM Categories WHERE Category = '" + stockManagementSystem.CategoryName + "'"; string categoryNameCheck = "Category"; int categoryNameCount = DataRead(categoryNameQuery, categoryNameCheck); if (categoryNameCount > 0) { messageLabel.Text = " Category Name Already Have"; messageLabel.ForeColor = Color.Green; } else { bool isSaved = categoriesMenager.Save(stockManagementSystem); if (isSaved) { messageLabel.Text = "Category Informetion Save Successfully"; messageLabel.ForeColor = Color.Green; DataTable cdt = categoryShowManager.GetCategoryShow(); categoryDataGridView.DataSource = cdt; } else { messageLabel.Text = ("Failed"); messageLabel.ForeColor = Color.Red; } } } } catch (Exception exception) { MessageBox.Show(exception.Message); } }
private void updateButton_Click(object sender, EventArgs e) { try { StockManagementSystem stockManagementSystem = new StockManagementSystem(); stockManagementSystem.CategoryName = categoryNameTextBox.Text; CategoriesMenager categoriesMenager = new CategoriesMenager(); if (string.IsNullOrEmpty(stockManagementSystem.CategoryName)) { messageLabel.Text = " Fill Up The Required Information"; messageLabel.ForeColor = Color.Red; } else { string categoryNameQuery = "SELECT * FROM Categories WHERE Category = '" + stockManagementSystem.CategoryName + "'"; string categoryNameCheck = "Category"; int categoryNameCount = DataRead(categoryNameQuery, categoryNameCheck); if (categoryNameCount > 0) { messageLabel.Text = " Category Name Already Have"; messageLabel.ForeColor = Color.Blue; } else { connection.Open(); string updeteQuery = "UPDATE Categories SET Category = '" + categoryNameTextBox.Text + "' WHERE SL ='" + Serial + "'"; SqlDataAdapter Ud = new SqlDataAdapter(updeteQuery, connection); Ud.SelectCommand.ExecuteNonQuery(); connection.Close(); { messageLabel.Text = "Category Name Update Successfully"; messageLabel.ForeColor = Color.Blue; DataTable cdt = categoryShowManager.GetCategoryShow(); categoryDataGridView.DataSource = cdt; } } } } catch (Exception exception) { MessageBox.Show(exception.Message); } }