private void SaveButton_Click(object sender, EventArgs e)
{
if (IsValid())
{
SizesCart.Clear();
LoadDataIntoSizesCart();
using (SqlConnection con = new SqlConnection(ApplicationSettings.ConnectionString1()))
{
using (SqlCommand cmd = new SqlCommand("usp_Products_InsertNewProductt", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", ProductNameTextBox.Text);
cmd.Parameters.AddWithValue("@CategoryID", CategoryComboBox.SelectedValue);
cmd.Parameters.AddWithValue("@SupplierID", SupplierComboBox.SelectedValue);
cmd.Parameters.AddWithValue("@PurchasePrice", PurchasePriceTextBox.Text);
cmd.Parameters.AddWithValue("@SalesPrice", SalesPriceTextBox.Text);
con.Open();
int id = Convert.ToInt32(cmd.ExecuteScalar());
SaveSizes(id);
MessageBox.Show("product no. " + id.ToString() + " is saved succesfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearControls();
foreach (DataGridViewRow row in SizeDataGridView.Rows)
{
row.Cells["select"].Value = 0;
}
ProductNameTextBox.Focus();
}
}
}
}
private void textBox5_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
ProductNameTextBox.Focus();
e.Handled = true;
}
}
private void SelectAllSizeButton_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in SizeDataGridView.Rows)
{
row.Cells["select"].Value = 1;
}
ProductNameTextBox.Focus();
}
private void InitAll()
{
CategoryComboBox.DataSource = _context.Categories.ToList();
CategoryComboBox.DisplayMember = "Name";
CategoryComboBox.SelectedIndex = -1;
Icon = Resources.shopping_cart;
ProductNameTextBox.Select();
ProductNameTextBox.Focus();
}
private bool NameIsFilled()
{
bool filled = !(string.IsNullOrEmpty(ProductNameTextBox.Text));
if (!filled)
{
MessageBox.Show("Product name cannot be empty");
ProductNameTextBox.Focus();
}
return(filled);
}
private void ClearControls()
{
ProductNameTextBox.Clear();
SupplierComboBox.SelectedIndex = -1;
CategoryComboBox.SelectedIndex = -1;
PurchasePriceTextBox.Clear();
SalesPriceTextBox.Clear();
foreach (DataGridViewRow row in SizeDataGridView.Rows)
{
row.Cells["select"].Value = 0;
}
ProductNameTextBox.Focus();
}
private void NewContactButton_Click(object sender, RoutedEventArgs e)
{
string image = ((Icon)ImageComboBox.SelectedValue).ImagePath;
Products.Add(new Product {
ProductName = ProductNameTextBox.Text, Description = DescriptionTextBox.Text, Image = image
});
ProductNameTextBox.Text = "";
DescriptionTextBox.Text = "";
ImageComboBox.SelectedIndex = -1;
ProductNameTextBox.Focus(FocusState.Programmatic);
}
private bool IsValid()
{
if (ProductNameTextBox.Text.Trim() == string.Empty)
{
MessageBox.Show("Product Name is required!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
ProductNameTextBox.Focus();
return(false);
}
if (PurchasePriceTextBox.Text.Trim() == string.Empty)
{
MessageBox.Show("Purchase Price is required!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
PurchasePriceTextBox.Focus();
return(false);
}
return(true);
}
private void ProductsRecordForm_Load(object sender, EventArgs e)
{
LoadAllProductIntoDataGridView();
ProductNameTextBox.Focus();
}
// ====================== END OF SEARCH FUNCTIONALITY METHODS =========================
/*
* ====================== START OF INVENTORY MANAGEMENT METHODS =========================
* 1.AddProductButton_Click
* 2.CategoryButton_Click
* 3.ModifyButton_Click
*/
/*
* Event Handler for Adding New Product to Inventory
*/
private void AddProductButton_Click(object sender, EventArgs e)
{
Product Prod = new Product();
bool DuplicateProduct = false;
StreamWriter FileWriter;
FileWriter = File.AppendText(PRODUCTDATABASEFILENAME);
if (ProductNameTextBox.Text == "")
{
MessageBox.Show("Please enter New Product Name");
ProductNameTextBox.Focus();
ProductNameTextBox.SelectAll();
}
else
{
if (ProductCategoryListBox.SelectedIndex == -1)
{
MessageBox.Show("Please select Product Category from the list");
ProductCategoryListBox.Focus();
}
else
{
if (ProductPriceTextBox.Text == "")
{
MessageBox.Show("Please enter Product Price");
ProductPriceTextBox.Focus();
ProductPriceTextBox.SelectAll();
}
else
{
try
{
decimal.TryParse(ProductPriceTextBox.Text, out decimal ProductPrice);
if (ProductPrice <= 0)
{
MessageBox.Show("Product Price should be greater than Zero");
ProductPriceTextBox.Focus();
ProductPriceTextBox.SelectAll();
}
else
{
if (ProductQuantityTextBox.Text == "")
{
MessageBox.Show("Please enter Product Quantity");
ProductQuantityTextBox.Focus();
ProductQuantityTextBox.SelectAll();
}
else
{
try
{
int.TryParse(ProductQuantityTextBox.Text, out int ProductQuantity);
if (ProductQuantity <= 0)
{
MessageBox.Show("Product Quantity should be greater than Zero");
ProductQuantityTextBox.Focus();
ProductQuantityTextBox.SelectAll();
}
else
{
foreach (Product p in ProductList)
{
if (p.ProductCategory == ProductCategoryListBox.SelectedItem.ToString() &&
p.ProductName == ProductNameTextBox.Text)
{
MessageBox.Show("Same Product Already Exist in the same Category");
ProductNameTextBox.Focus();
ProductNameTextBox.SelectAll();
DuplicateProduct = true;
break;
}
}
if (DuplicateProduct == false)
{
Random RandomNumberGenerator = new Random();
int ProductNumber = RandomNumberGenerator.Next(1, 999999);
string CheckProductID = ProductCategoryListBox.SelectedItem.ToString().Substring(0, 4) + ProductNumber.ToString("D6");
while (ExistProductID_Check(CheckProductID))
{
ProductNumber = RandomNumberGenerator.Next(1, 999999);
CheckProductID = ProductCategoryListBox.SelectedItem.ToString().Substring(0, 4) + ProductNumber.ToString("D6");
}
Prod.ProductID = ProductCategoryListBox.SelectedItem.ToString().Substring(0, 4) + ProductNumber.ToString("D6");
FileWriter.WriteLine(Prod.ProductID);
Prod.ProductCategory = ProductCategoryListBox.SelectedItem.ToString();
FileWriter.WriteLine(Prod.ProductCategory);
Prod.ProductName = ProductNameTextBox.Text;
FileWriter.WriteLine(Prod.ProductName);
Prod.ProductPrice = decimal.Parse(ProductPriceTextBox.Text);
FileWriter.WriteLine(Prod.ProductPrice);
Prod.ProductQuantity = int.Parse(ProductQuantityTextBox.Text);
FileWriter.WriteLine(Prod.ProductQuantity);
ProductList.Add(Prod);
FileWriter.Close();
MessageBox.Show("Product '" + Prod.ProductName + "' Added Successfully to the Category '" + Prod.ProductCategory + "'");
ProductCategoryListBox.SelectedIndex = -1;
ProductNameTextBox.Text = ProductPriceTextBox.Text = ProductQuantityTextBox.Text = CheckProductID = "";
}
}
}
catch
{
}
}
}
}
catch
{
}
}
}
}
}
