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);
}
}
