}// closes Page_load
//on page load the stock category drop down contain all categories from the database
protected void fillDDLProdCat()
{
Products allProducts = new Products();
SqlDataReader ddlCat = allProducts.GetStockCode();
DDLProdCat.DataSource = ddlCat;
DDLProdCat.DataTextField = "prod_cat_desc";
DDLProdCat.DataValueField = "prod_cat_id";
DDLProdCat.DataBind();
DDLProdCat.Items.Insert(0, new ListItem(String.Empty, String.Empty));
}
protected void addNewProduct(object sender, EventArgs e)
{ /* the barcode scanner cause the page to act as thought the submit product button has been clicked
* the page.valid will only try to pass the product details to the database once client side validation has been passed
*/
if (Page.IsValid)
{
// the method passes the product details entered by the user to the AddNewProduct() method in the HWW.cs file
Products addProd = new Products();
addProd.productName = Convert.ToString(TextProdName.Text);
addProd.prodBar = Convert.ToInt64(TextProdBarcode.Text);
addProd.prodMinLevel = Convert.ToInt32(TextProdMinLevel.Text);
addProd.prodStockLevel = Convert.ToInt32(TextProdStockLevel.Text);
addProd.prodStockCode = Convert.ToString(TextProdStockCode.Text).ToUpper();
addProd.prodCatID = Convert.ToInt32(DDLProdCat.SelectedValue);
addProd.AddNewProduct();
//If an error occurs when adding the product to the database then display the error messgae tot the user
String errNumber = Convert.ToString(addProd.errNo);
if (addProd.errNo.Equals(2627) && (addProd.errMsg.Contains("Error in Adding barcode")))
{
//Error message displayed if the barcode already exists in the database
LblDupBarcode.Text = "The barcode already exists in the database";
LblDupStockCode.Text = string.Empty;
}
else if (addProd.errNo.Equals(2627) && (addProd.errMsg.Contains("Error in Adding product")))
{
//Error message displayed if the stockcode already exists in the database
LblDupStockCode.Text = "The stock code already exists in the database";
LblDupBarcode.Text = string.Empty;
}
else
{
//displays a confirmation that the product has been added to the database
TxtProdAdded.Text = "The product " + addProd.productName + " has been successfully added to the database";
LblDupBarcode.Text = string.Empty;
LblDupStockCode.Text = string.Empty;
TxtProdAdded.Visible = true;
TextProdName.Text = string.Empty;
TextProdBarcode.Text = string.Empty;
TextProdMinLevel.Text = string.Empty;
TextProdStockLevel.Text = string.Empty;
TextProdStockCode.Text = string.Empty;
DDLProdCat.ClearSelection();
}
} //closes if page is valid
}//closes the addNewProduct class
