protected void btnCheck_Click(object sender, EventArgs e)
        {
            StockItemBLL stockBll = new StockItemBLL();
            int cat_Id = Convert.ToInt32(ddlCateogryList.SelectedItem.Value);
            var item_list = stockBll.GetCategoryList_ByItem(cat_Id);

            gvItemInfoList.DataSource = item_list;
            gvItemInfoList.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();
        }
        /*
        public DataSet myDataSet
        {
            get
            {
                return ViewState["myDataSet"] != null ? (DataSet)ViewState["myDataSet"] : null;
            }
            set
            {
                ViewState["myDataSet"] = value;
            }
        }
           * */
        protected void gvItemInfoList_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            StockItemBLL stockBll = new StockItemBLL();
            int index = Convert.ToInt32(e.RowIndex);
            string itemCode = gvItemInfoList.Rows[index].Cells[2].Text;
            string delete_msg = stockBll.DeleteStockItem(itemCode);
            lblmsg.Text = delete_msg;
            gvItemInfoList.EditIndex = -1;

            int cat_Id = Convert.ToInt32(ddlCateogryList.SelectedItem.Value);
            var item_list = stockBll.GetCategoryList_ByItem(cat_Id);

            gvItemInfoList.DataSource = item_list;
            gvItemInfoList.DataBind();
            //gvItemInfoList.DataSource = gvItemInfoList;
            gvItemInfoList.DataBind();
        }