protected void btnSave_Click(object sender, EventArgs e)
        {
            CategoryBLL category_bll = new CategoryBLL();
            string category_name = txtCategory.Text;
            int cat_id = category_bll.AddNewCategory(category_name);

            StockItemBLL stockBll = new StockItemBLL();
            string item_Code = txtItemNo.Text;
            // int categoryID = Convert.ToInt32(txtCategory.Text);
            string description = txtDesc.Text;
            int reorder_Level = Convert.ToInt32(txtReorderLevel.Text);
            int reorder_Qty = Convert.ToInt32(txtReorderQty.Text);
            string unit = ddlUnit.SelectedItem.Text;
            int qty = Convert.ToInt32(txtQuantity.Text);

            string add_info = stockBll.AddNewStockItem(item_Code, cat_id, description, reorder_Level, reorder_Qty, unit, qty);
            lblmsg.Text = add_info;
        }
 private void FillCategoryList()
 {
     CategoryBLL categorybll = new CategoryBLL();
     var c = categorybll.GetCategory();
     ddlCategory.DataSource = c;
     ddlCategory.DataTextField = "Category_Name";
     ddlCategory.DataValueField = "CategoryID";
     ddlCategory.DataBind();
 }
        protected void ddlCategory_SelectedIndexChanged(object sender, EventArgs e)
        {
            CategoryBLL category_bll = new CategoryBLL();
            StockItemBLL stock_bll = new StockItemBLL();

            string category_name = ddlCategory.SelectedItem.Text;
            int category_id = category_bll.GetCategoryId(category_name);

            /*****Testing for Category ID value
            //lblCategoryValue.Text = category_id.ToString(); */
            var item_list = stock_bll.GetCategoryList_ByItem(category_id);

            ddlItemName.DataSource = item_list;
            ddlItemName.DataTextField = "Description";
            ddlItemName.DataValueField = "Item_Code";
            ddlItemName.DataBind();
        }
        void ComboDataBind()
        {
            CategoryBLL catBll = new CategoryBLL();
            var cat = catBll.GetCategory();
            ddlCategory.DataTextField = "Category_Name";
            ddlCategory.DataValueField = "CategoryID";

            ddlCategory.DataSource = cat;
            ddlCategory.DataBind();
            //ddlCategory.Items.Insert(0, "Choose Category ...");
            int catid = Convert.ToInt32(ddlCategory.SelectedValue.ToString());
            ddlItem_DataBind(catid);
        }