protected ComboItemDto GetComboItem02()
        {
            ComboItemDto comboItemDto = new ComboItemDto();

            comboItemDto.Code        = "C - " + System.Guid.NewGuid().ToString().Substring(0, 10);
            comboItemDto.Description = "Insert Combo Item Test";
            comboItemDto.Items       = new List <ComboItemLineItemDto>();

            ComboItemLineItemDto lineItem = new ComboItemLineItemDto();

            lineItem.Uid      = this.Shipping1.Uid;
            lineItem.Code     = this.Shipping1.Code;
            lineItem.Quantity = 1;
            comboItemDto.Items.Add(lineItem);

            lineItem          = new ComboItemLineItemDto();
            lineItem.Uid      = this.AsusLaptop.Uid;
            lineItem.Code     = this.AsusLaptop.Code;
            lineItem.Quantity = 1;
            comboItemDto.Items.Add(lineItem);

            comboItemDto.IsInventoried   = true;
            comboItemDto.AssetAccountUid = this.AssetInventory.Uid;

            comboItemDto.IsSold = true;
            comboItemDto.SaleIncomeAccountUid = this.IncomeHardwareSales.Uid;
            comboItemDto.SaleCoSAccountUid    = this.CoSHardware.Uid;
            comboItemDto.SaleTaxCode          = "G1";
            comboItemDto.SellingPrice         = 350.00M;
            comboItemDto.RrpInclTax           = 350.00M;

            return(comboItemDto);
        }
        private void SetupComboItems()
        {
            string         guid      = Guid.NewGuid().ToString().Remove(0, 20);
            ComboItemProxy comboItem = new ComboItemProxy();

            this.CPU                      = new ComboItemDto();
            this.CPU.Code                 = "DESKTOP " + guid;
            this.CPU.Description          = "Desktop PC";
            this.CPU.IsInventoried        = true;
            this.CPU.AssetAccountUid      = this.AssetInventory.Uid;
            this.CPU.IsSold               = true;
            this.CPU.SaleCoSAccountUid    = this.CoSHardware.Uid;
            this.CPU.SaleIncomeAccountUid = this.IncomeHardwareSales.Uid;
            this.CPU.RrpInclTax           = 575.00M;
            this.CPU.Items                = new System.Collections.Generic.List <ComboItemLineItemDto>();

            ComboItemLineItemDto lineItem = new ComboItemLineItemDto();

            lineItem.Uid      = this.HardDisk.Uid;
            lineItem.Code     = this.HardDisk.Code;
            lineItem.Quantity = 1;
            this.CPU.Items.Add(lineItem);

            lineItem          = new ComboItemLineItemDto();
            lineItem.Uid      = this.Cat5Cable.Uid;
            lineItem.Code     = this.Cat5Cable.Code;
            lineItem.Quantity = 1;
            this.CPU.Items.Add(lineItem);

            comboItem.Insert(this.CPU);
        }
        public void GetByUtcLastModified()
        {
            ComboItemProxy proxy = new ComboItemProxy();

            Thread.Sleep(10000);             //Wait for ten seconds. Avoid retreiving items from text fixture setup.

            ComboItemDto dto = GetComboItem01();

            proxy.Insert(dto);

            DateTime lastModifiedFrom = ((ComboItemDto)proxy.GetByUid(dto.Uid)).LastModified;

            Thread.Sleep(10000);             //Wait for ten seconds.

            dto = GetComboItem01();
            proxy.Insert(dto);

            DateTime lastModifiedTo = ((ComboItemDto)proxy.GetByUid(dto.Uid)).LastModified.AddSeconds(1);

            string utcFrom = SqlStrPrep.ToDateTime(lastModifiedFrom).ToString();
            string utcTo   = SqlStrPrep.ToDateTime(lastModifiedTo).ToString();

            utcFrom = utcFrom.Replace('/', '-');
            utcFrom = utcFrom.Replace(' ', 'T');

            utcTo = utcTo.Replace('/', '-');
            utcTo = utcTo.Replace(' ', 'T');

            List <ComboItemDto> list = proxy.FindList <ComboItemDto>(ComboItemProxy.ResponseXPath,
                                                                     "UtcLastModifiedFrom", utcFrom, "UtcLastModifiedTo", utcTo);

            Assert.AreEqual(2, list.Count, string.Format("Incorrect number of combo items returned for UtcLastModifiedFrom {0} and UtcLastModifiedTo{1}", utcFrom, utcTo));
        }
        public void TestGetByUid()
        {
            ComboItemDto comboItemDto = this.GetComboItem01();

            ComboItemProxy proxy = new ComboItemProxy();

            proxy.Insert(comboItemDto);

            Assert.AreNotEqual(0, comboItemDto.Uid);

            ComboItemDto result = (ComboItemDto)proxy.GetByUid(comboItemDto.Uid);

            Assert.AreEqual(2, result.Items.Count);

            proxy.DeleteByUid(comboItemDto.Uid);

            try
            {
                proxy.GetByUid(comboItemDto.Uid);
            }
            catch (RestException ex)
            {
                StringAssert.Contains("Unable to find inventory item uid ", ex.Message);
            }
        }
        public void SyncCheck()
        {
            ComboItemDto   comboItemDto = this.GetComboItem01();
            ComboItemProxy proxy        = new ComboItemProxy();

            proxy.Insert(comboItemDto);

            ComboItemDto fromDB = (ComboItemDto)proxy.GetByUid(comboItemDto.Uid);

            fromDB.Description = fromDB.Description + " - Updated";
            fromDB.Notes       = "Updated today.";

            proxy.Update(fromDB);

            comboItemDto.Notes = "Late update.";

            try
            {
                proxy.Update(comboItemDto);
                Assert.Fail("Expected exception not thrown.");
            }
            catch (RestException ex)
            {
                Assert.AreEqual("Record to be updated has changed since last read.", ex.Message);
            }
        }
        public void GetByCode()
        {
            ComboItemProxy proxy = new ComboItemProxy();
            ComboItemDto   dto   = GetComboItem01();

            proxy.Insert(dto);

            List <ComboItemDto> list = proxy.FindList <ComboItemDto>(ComboItemProxy.ResponseXPath,
                                                                     "CodeBeginsWith", dto.Code);

            Assert.AreEqual(1, list.Count, string.Format("Incorrect number of combo items returned for code {0}", dto.Code));
        }
        public void InsertAndGetByUid()
        {
            ComboItemDto comboItemDto = this.GetComboItem01();

            ComboItemProxy proxy = new ComboItemProxy();

            proxy.Insert(comboItemDto);

            ComboItemDto fromDB = (ComboItemDto)proxy.GetByUid(comboItemDto.Uid);

            this.AssertEqual(comboItemDto, fromDB);
        }
        protected ComboItemDto GetComboItem01()
        {
            ComboItemDto comboItemDto = new ComboItemDto();

            comboItemDto.Code        = "C - " + System.Guid.NewGuid().ToString().Substring(0, 10);
            comboItemDto.Description = "Insert Combo Item Test";
            comboItemDto.Items       = new List <ComboItemLineItemDto>();

            ComboItemLineItemDto lineItem = new ComboItemLineItemDto();

            lineItem.Uid      = this.AsusLaptop.Uid;
            lineItem.Code     = this.AsusLaptop.Code;
            lineItem.Quantity = 1;
            comboItemDto.Items.Add(lineItem);

            lineItem          = new ComboItemLineItemDto();
            lineItem.Uid      = this.Cat5Cable.Uid;
            lineItem.Code     = this.Cat5Cable.Code;
            lineItem.Quantity = 1;
            comboItemDto.Items.Add(lineItem);

            comboItemDto.IsInventoried   = true;
            comboItemDto.AssetAccountUid = this.AssetInventory.Uid;

            comboItemDto.IsSold = true;
            comboItemDto.SaleIncomeAccountUid = this.IncomeHardwareSales.Uid;
            comboItemDto.SaleCoSAccountUid    = this.CoSHardware.Uid;
            comboItemDto.SaleTaxCode          = "G1";
            comboItemDto.SellingPrice         = 350.00M;
            comboItemDto.RrpInclTax           = 350.00M;

            comboItemDto.IsBought                  = true;
            comboItemDto.PurchaseTaxCode           = "G10";
            comboItemDto.PrimarySupplierContactUid = this.MrSmith.Uid;
            comboItemDto.BuyingPrice               = 175.00M;
            comboItemDto.PrimarySupplierItemCode   = "ITOP090";
            comboItemDto.DefaultReOrderQuantity    = 10;

            comboItemDto.IsVoucher = true;
            comboItemDto.ValidFrom = DateTime.Parse("28-May-2010");
            comboItemDto.ValidTo   = DateTime.Parse("28-Dec-2010");

            comboItemDto.IsVirtual = true;
            comboItemDto.VType     = "Virtual Voucher";
            comboItemDto.Notes     = "Combo item notes.";
            comboItemDto.IsVisible = true;

            return(comboItemDto);
        }
        public void InsertWithItemsNotInventoriedOrMakedAsVirtual()
        {
            ComboItemDto   comboItemDto = this.GetComboItem02();
            ComboItemProxy proxy        = new ComboItemProxy();

            try
            {
                proxy.Insert(comboItemDto);
                Assert.Fail("Expected exception not thrown.");
            }
            catch (RestException ex)
            {
                Assert.AreEqual("Combo Item's line item with code " + comboItemDto.Items[0].Code + " is not inventoried or not marked as virtual.", ex.Message.Substring(0, 104));
            }
        }
        public void UpdateAsInventoryItem()
        {
            ComboItemProxy proxy     = new ComboItemProxy();
            ComboItemDto   comboItem = this.GetComboItem01();

            proxy.Insert(comboItem);

            ComboItemDto fromDB = (ComboItemDto)proxy.GetByUid(comboItem.Uid);

            fromDB.Description = fromDB.Description + " - Update as Inventory Item";
            fromDB.Items.Clear();

            InventoryItemProxy itemProxy = new InventoryItemProxy();

            itemProxy.Update(fromDB);
        }
        public void BuildComboItemFailsWithNotEnoughtStock()
        {
            ComboItemProxy proxy = new ComboItemProxy();

            ComboItemDto comboItemDto = this.GetComboItem01();

            proxy.Insert(comboItemDto);
            ComboItemDto         comboItem = (ComboItemDto)proxy.GetByUid(comboItemDto.Uid);
            BuildComboItemResult result    = proxy.Build(comboItemDto.Uid, 1000);

            Assert.AreEqual(1, result.Errors.Count);
            ErrorInfo error = (ErrorInfo)result.Errors[0];

            Assert.AreEqual("InvalidInventoryItemStockOnHandException", error.Type);
            StringAssert.StartsWith("Unable to complete the requested operation as it will cause negative stock-on-hand for ", error.Message);
        }
        public void InsertWithComboItemAsItem()
        {
            ComboItemProxy       proxy             = new ComboItemProxy();
            ComboItemDto         comboItemDto      = this.GetComboItem01();
            ComboItemLineItemDto lineItemComboItem = new ComboItemLineItemDto();

            lineItemComboItem.Uid      = this.CPU.Uid;
            lineItemComboItem.Code     = this.CPU.Code;
            lineItemComboItem.Quantity = 1;
            comboItemDto.Items.Add(lineItemComboItem);

            proxy.Insert(comboItemDto);

            ComboItemDto fromDB = (ComboItemDto)proxy.GetByUid(comboItemDto.Uid);

            this.AssertEqual(comboItemDto, fromDB);
        }
        public void InsertWithNoItems()
        {
            ComboItemDto   comboItemDto = this.GetComboItem01();
            ComboItemProxy proxy        = new ComboItemProxy();

            comboItemDto.Items.Clear();

            try
            {
                proxy.Insert(comboItemDto);
                Assert.Fail("Expected exception was not thrown.");
            }
            catch (RestException ex)
            {
                Assert.AreEqual("Please select at least one item for the combo item.", ex.Message.Substring(0, 51));
            }
        }
        public void Delete()
        {
            ComboItemDto   comboItemDto = this.GetComboItem01();
            ComboItemProxy proxy        = new ComboItemProxy();

            proxy.Insert(comboItemDto);

            proxy.DeleteByUid(comboItemDto.Uid);

            try
            {
                ComboItemDto fromDB = (ComboItemDto)proxy.GetByUid(comboItemDto.Uid);
                Assert.Fail("The Combo Item was not deleted successfully.");
            }
            catch (RestException ex)
            {
                Assert.IsTrue(ex.Type == "RecordNotFoundException", "Expected exception RecordNotFoundException not thrown.");
            }
        }
        public void GetByDescription()
        {
            string         description01 = Guid.NewGuid().ToString().Substring(0, 15);
            string         description02 = description01 + "foo";
            ComboItemProxy proxy         = new ComboItemProxy();
            ComboItemDto   dto           = GetComboItem01();

            dto.Description = description01;
            proxy.Insert(dto);

            dto             = GetComboItem01();
            dto.Description = description02;
            proxy.Insert(dto);

            List <ComboItemDto> list = proxy.FindList <ComboItemDto>(ComboItemProxy.ResponseXPath,
                                                                     "DescriptionBeginsWith", description01);

            Assert.AreEqual(2, list.Count, "Incorrect number of combo items returned for description ");
        }
        public void DeleteReferenced()
        {
            ComboItemProxy proxy     = new ComboItemProxy();
            ComboItemDto   comboItem = this.GetComboItem01();

            proxy.Insert(comboItem);

            // We need to insert stock first using a purchase
            CrudProxy  invoiceProxy = new InvoiceProxy();
            InvoiceDto dto          = new InvoiceDto(TransactionType.Purchase, InvoiceLayout.Item);

            dto.Date                = DateTime.Today.Date;
            dto.ContactUid          = this.MrSmith.Uid;
            dto.Summary             = "Using a combo item.";
            dto.Notes               = "From REST";
            dto.DueOrExpiryDate     = dto.Date.AddMonths(1);
            dto.Status              = InvoiceStatus.Invoice;
            dto.InvoiceNumber       = "I123";
            dto.PurchaseOrderNumber = "<Auto Number>";

            decimal unitsToBuild = 12.25M;

            // "purchase" all the items that are part of this combo item so we have valid stock
            ItemInvoiceItemDto item = new ItemInvoiceItemDto();

            item.Quantity         = 5;
            item.InventoryItemUid = comboItem.Uid;
            item.Description      = "Purchasing: " + comboItem.Description;
            item.TaxCode          = TaxCode.ExpInclGst;
            item.UnitPriceInclTax = 99.95M;
            dto.Items.Add(item);
            invoiceProxy.Insert(dto);

            try
            {
                proxy.DeleteByUid(comboItem.Uid);
                Assert.Fail("Expected exception was not thrown.");
            }
            catch (RestException ex)
            {
                Assert.AreEqual("The specified inventory item is referenced by some Transactions and/or Combo Items  and therefore cannot be deleted.", ex.Message);
            }
        }
        public void Update()
        {
            ComboItemDto   comboItemDto = this.GetComboItem01();
            ComboItemProxy proxy        = new ComboItemProxy();

            proxy.Insert(comboItemDto);

            ComboItemLineItemDto lineItemDto = new ComboItemLineItemDto();

            lineItemDto.Uid      = this.HardDisk.Uid;
            lineItemDto.Code     = this.HardDisk.Code;
            lineItemDto.Quantity = 1;
            comboItemDto.Items.Add(lineItemDto);

            proxy.Update(comboItemDto);

            ComboItemDto fromDB = (ComboItemDto)proxy.GetByUid(comboItemDto.Uid);

            this.AssertEqual(comboItemDto, fromDB);
        }
        public void InsertWithItemsFromDifferentFile()
        {
            ComboItemDto   comboItemDto = this.GetComboItem01();
            ComboItemProxy proxy        = new ComboItemProxy();

            ComboItemLineItemDto lineItem = new ComboItemLineItemDto();

            lineItem.Uid      = 14605;
            lineItem.Code     = "100";
            lineItem.Quantity = 2;
            comboItemDto.Items.Add(lineItem);

            try
            {
                proxy.Insert(comboItemDto);
                Assert.Fail("Expected exception not thrown.");
            }
            catch (RestException ex)
            {
                Assert.AreEqual("One or more line items of the Combo Item was not found. Please make sure correct items are selected for creating the Combo Item.", ex.Message.Substring(0, 128));
            }
        }
        public void BuildComboItem()
        {
            ComboItemProxy proxy = new ComboItemProxy();

            ComboItemDto comboItemDto = this.GetComboItem01();

            proxy.Insert(comboItemDto);
            ComboItemDto comboItem = (ComboItemDto)proxy.GetByUid(comboItemDto.Uid);

            // We need to insert stock first using a purchase
            CrudProxy  invoiceProxy = new InvoiceProxy();
            InvoiceDto dto          = new InvoiceDto(TransactionType.Purchase, InvoiceLayout.Item);

            dto.Date                = DateTime.Today.Date;
            dto.ContactUid          = this.MrSmith.Uid;
            dto.Summary             = "Add stock do we can build ComboItems";
            dto.Notes               = "From REST";
            dto.DueOrExpiryDate     = dto.Date.AddMonths(1);
            dto.Status              = InvoiceStatus.Invoice;
            dto.InvoiceNumber       = "I123";
            dto.PurchaseOrderNumber = "<Auto Number>";

            decimal unitsToBuild = 12.25M;

            foreach (ComboItemLineItemDto itemInCombo in comboItem.Items)
            {   // "purchase" all the items that are part of this combo item so we have valid stock
                ItemInvoiceItemDto item = new ItemInvoiceItemDto();
                item.Quantity         = itemInCombo.Quantity * unitsToBuild;
                item.InventoryItemUid = itemInCombo.Uid;
                item.Description      = "Purchasing: " + itemInCombo.Code;
                item.TaxCode          = TaxCode.ExpInclGst;
                item.UnitPriceInclTax = 99.95M;
                dto.Items.Add(item);
            }
            invoiceProxy.Insert(dto);

            // Download stock info before
            InventoryItemProxy inventoryItemProxy = new InventoryItemProxy();
            InventoryItemDto   inventoryItem      = (InventoryItemDto)inventoryItemProxy.GetByUid(comboItemDto.Uid);
            decimal            stockOnHand        = inventoryItem.StockOnHand;


            // Build the item!
            BuildComboItemResult result = proxy.Build(comboItemDto.Uid, unitsToBuild);

            Assert.AreNotEqual(0, result.Uid);
            Assert.IsNotNull(result.LastUpdatedUid);

            inventoryItem = (InventoryItemDto)inventoryItemProxy.GetByUid(comboItemDto.Uid);
            decimal newStockOnHand = inventoryItem.StockOnHand;

            Assert.AreEqual(stockOnHand + unitsToBuild, newStockOnHand, "We have one extra item in stock");

            // Read Inventory Transfer details
            InventoryTransferProxy transferProxy = new InventoryTransferProxy();
            InventoryTransferDto   transfer      = (InventoryTransferDto)transferProxy.GetByUid(result.Uid);

            Assert.AreEqual(comboItem.Items.Count + 1, transfer.Items.Count); // +1 as we have the combo item the first one

            // confirm first item is the combo with +1
            InventoryTransferItemDto comboItemTransfer = (InventoryTransferItemDto)transfer.Items[0];

            Assert.AreEqual(comboItemDto.Uid, comboItemTransfer.InventoryItemUid);
            Assert.AreEqual(unitsToBuild, comboItemTransfer.Quantity);

            for (int i = 0; i < comboItem.Items.Count; i++)
            {
                ComboItemLineItemDto     line = comboItem.Items[i];
                InventoryTransferItemDto item = (InventoryTransferItemDto)transfer.Items[i + 1];
                Assert.AreEqual(line.Uid, item.InventoryItemUid);
                Assert.AreEqual(line.Quantity * unitsToBuild, -item.Quantity);
            }
        }
 private void AssertEqual(ComboItemDto expected, ComboItemDto actual)
 {
     InventoryItemTests.AssertEqual(expected, actual);
     this.AssertEqual(expected.Items, actual.Items);
 }