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;
        }