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