public Boolean DeleteInventoryItem(int itemid)
        {
            da = new DAInventorytem(dbProviderFactory);
            data = new InventoryItemData();

            data = da.DeleteInventoryItem(itemid);

            if (data.ResultCode == ResultCodes.SUCCESSFUL_TRANSACTION)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        public InventoryItem getInventoryItem(Int32 itemid)
        {
            da = new DAInventorytem(dbProviderFactory);
            data = new InventoryItemData();

            data = da.getInventoryItem(0, itemid);

            if (data.ResultCode == ResultCodes.SUCCESSFUL_TRANSACTION)
            {
                if (data.InventoryItemList.Count > 0)
                {
                    return data.InventoryItemList[0];
                }
                else
                {
                    return null;
                }
            }
            else
            {
                return null;
            }
        }
        public Boolean checkInventoryItemByName(String itemname)
        {
            da = new DAInventorytem(dbProviderFactory);
            data = new InventoryItemData();

            data = da.getInventoryItemByName(itemname);

            if (data.ResultCode == ResultCodes.SUCCESSFUL_TRANSACTION)
            {
                if (data.InventoryItemList.Count > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            else
            {
                return false;
            }
        }
        public Boolean InsertInventoryItem(string itemname,
                                        int categoryid,
                                        int quantity,
                                        decimal price,
                                        string available,
                                        string remarks,
                                        int by)
        {
            Boolean result = false;
            da = new DAInventorytem(dbProviderFactory);
            data = new InventoryItemData();

            data = da.InsertInventoryItem(itemname, categoryid, quantity, price, available, remarks, by);

            if (data.ResultCode == ResultCodes.SUCCESSFUL_TRANSACTION)
            {
                result = true;
            }

            return result;
        }
        private void GetItemDetails(int itemid)
        {
            BSInventoryItem bs = new BSInventoryItem();
            InventoryItemData item = new InventoryItemData();

            //item = bs.GetItemByID(itemid);

            //if (item != null)
            //{

            //    txtAvailableStock.Text = item.Quantity.ToString();
            //    txtPrice.Text = String.Format("{0:0.00}",item.Price);
            //    txtQuantity.Text = "0";

            //}
            //else
            //{
            //    txtAvailableStock.Text = "0";
            //    txtPrice.Text = String.Format("{0:0.00}",0);
            //    txtQuantity.Text = "0";
            //}
        }