private void saveButton_Click(object sender, EventArgs e) { try { StockManagementSystem stockManagementSystem = new StockManagementSystem(); stockManagementSystem.CategoryName = categoriesComboBox.Text; stockManagementSystem.CategoryID = Convert.ToInt32(categoriesComboBox.SelectedValue); stockManagementSystem.CompanyName = companiesComboBox.Text; stockManagementSystem.CompanyID = Convert.ToInt32(companiesComboBox.SelectedValue); string reOrder = reoderLevelTextBox.Text; string itemName = itemNameTextBox.Text; if (categoriesComboBox.SelectedValue == null || companiesComboBox.SelectedValue == null || String.IsNullOrEmpty(itemName) || String.IsNullOrEmpty(reOrder)) { messageLabel.Text = "Fill Up The Required Information"; messageLabel.ForeColor = Color.Red; } else { stockManagementSystem.Item = itemNameTextBox.Text; stockManagementSystem.ReoderLevel = Convert.ToInt32(reoderLevelTextBox.Text); string itemNameQuery = "SELECT * FROM Itemes WHERE Item = '" + stockManagementSystem.Item + "'"; string itemNameCheck = "Item"; int itemNameCount = DataRead(itemNameQuery, itemNameCheck); if (itemNameCount > 0) { messageLabel.Text = " Item Name Already Have"; messageLabel.ForeColor = Color.Green; } else { bool isSaved = itemSetupManager.Save(stockManagementSystem); if (isSaved) { messageLabel.Text = " Item Name Save Successfully"; messageLabel.ForeColor = Color.Blue; categoriesComboBox.Text = companiesComboBox.Text = itemNameTextBox.Text = reoderLevelTextBox.Text = ""; } else { messageLabel.Text = ("Failed"); messageLabel.ForeColor = Color.Red; } } } } catch (Exception exception) { MessageBox.Show(exception.Message); } }
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); } }