public InvoiceDto GetSale1() { InvoiceDto dto = new InvoiceDto(TransactionType.Sale, InvoiceLayout.Item); dto.Date = DateTime.Today; dto.ContactUid = this.MrSmith.Uid; dto.Summary = "Test Insert Item Sale"; dto.Notes = "From REST"; dto.DueOrExpiryDate = dto.Date.AddMonths(1); dto.Layout = InvoiceLayout.Item; dto.Status = InvoiceStatus.Invoice; dto.InvoiceNumber = "<Auto Number>"; ItemInvoiceItemDto item = null; item = new ItemInvoiceItemDto(); item.Quantity = 1; item.InventoryItemUid = this.Item1.Uid; item.Description = this.Item1.Description; item.TaxCode = TaxCode.SaleInclGst; item.UnitPriceInclTax = this.Item1.RrpInclTax; dto.Items.Add(item); dto.Tags = "CC"; return dto; }
public InvoiceDto GetItemSale() { InvoiceDto dto = new InvoiceDto(TransactionType.Sale, InvoiceLayout.Item); dto.Date = DateTime.Parse("6-Oct-05"); dto.ContactUid = this.MrSmith.Uid; dto.Summary = "Test Insert Item Sale"; dto.Notes = "From REST"; dto.DueOrExpiryDate = DateTime.Parse("6-Nov-05"); dto.Layout = InvoiceLayout.Item; dto.Status = InvoiceStatus.Invoice; dto.InvoiceNumber = "<Auto Number>"; dto.PurchaseOrderNumber = "PO333"; ItemInvoiceItemDto item = null; item = new ItemInvoiceItemDto(); item.Quantity = 2; item.InventoryItemUid = this.AsusLaptop.Uid; item.Description = "Asus Laptop"; item.TaxCode = TaxCode.SaleInclGst; item.UnitPriceInclTax = 1200.75M; item.PercentageDiscount = 12.50M; dto.Items.Add(item); item = new ItemInvoiceItemDto(); item.Quantity = 5.125M; item.InventoryItemUid = this.Cat5Cable.Uid; item.Description = "Cat 5 Cable (in meter)"; item.TaxCode = TaxCode.SaleGstFree; item.UnitPriceInclTax = 2.1234M; dto.Items.Add(item); item = new ItemInvoiceItemDto(); item.Quantity = 3; item.InventoryItemUid = this.Cat5Cable.Uid; item.Description = "Cat 5 Cable (in meter)"; item.TaxCode = TaxCode.SaleExports; item.UnitPriceInclTax = 5.125M; dto.Items.Add(item); QuickPaymentDto payment = new QuickPaymentDto(); payment.DatePaid = dto.Date; payment.BankedToAccountUid = this.StGeorge.Uid; payment.Reference = "C-001-023"; payment.Amount = 222.22M; dto.QuickPayment = payment; return dto; }
public virtual void CreatePurchaseForInventoryItemsUsed() { InvoiceDto dto = new InvoiceDto(TransactionType.Purchase, InvoiceLayout.Item); dto.Date = DateTime.Today.Date; dto.ContactUid = this.MrSmith.Uid; dto.Summary = "Invoice Tests - CreatePurchaseForInventoryItemsUsed()"; dto.Notes = "From REST"; dto.DueOrExpiryDate = dto.Date.AddMonths(1); dto.Status = InvoiceStatus.Invoice; dto.PurchaseOrderNumber = "<Auto Number>"; ItemInvoiceItemDto item = null; item = new ItemInvoiceItemDto(); item.Quantity = 10000; item.InventoryItemUid = this.AsusLaptop.Uid; item.Description = this.AsusLaptop.Description; item.TaxCode = TaxCode.ExpInclGst; item.UnitPriceInclTax = 1000M; dto.Items.Add(item); item = new ItemInvoiceItemDto(); item.Quantity = 10000; item.InventoryItemUid = this.HardDisk.Uid; item.Description = this.HardDisk.Description; item.TaxCode = TaxCode.ExpInclGst; item.UnitPriceInclTax = 99.95M; dto.Items.Add(item); item = new ItemInvoiceItemDto(); item.Quantity = 500000; item.InventoryItemUid = this.Cat5Cable.Uid; item.Description = this.Cat5Cable.Description; item.TaxCode = TaxCode.ExpInclGst; item.UnitPriceInclTax = 0.95M; dto.Items.Add(item); new InvoiceProxy().Insert(dto); }
public InvoiceDto GetUnpaidItemSale() { InvoiceDto dto = new InvoiceDto(TransactionType.Sale, InvoiceLayout.Item); dto.Date = DateTime.Parse("6-Oct-05"); dto.ContactUid = this.MrsSmith.Uid; dto.Summary = "Test Insert Item Sale"; dto.Notes = "From REST"; dto.DueOrExpiryDate = DateTime.Parse("6-Nov-05"); dto.Status = InvoiceStatus.Invoice; dto.InvoiceNumber = "<Auto Number>"; dto.PurchaseOrderNumber = "PO333"; ItemInvoiceItemDto item = null; item = new ItemInvoiceItemDto(); item.Quantity = 2; item.InventoryItemUid = this.HardDisk.Uid; item.Description = this.HardDisk.Description; item.TaxCode = TaxCode.SaleInclGst; item.UnitPriceInclTax = 120.75M; dto.Items.Add(item); item = new ItemInvoiceItemDto(); item.Quantity = 5.125M; item.InventoryItemUid = this.Cat5Cable.Uid; item.Description = this.Cat5Cable.Description; item.TaxCode = TaxCode.SaleInclGst; item.UnitPriceInclTax = 2.555M; dto.Items.Add(item); return dto; }
private InvoiceDto GetUnpaidItemPurchase() { InvoiceDto dto = new InvoiceDto(TransactionType.Purchase, InvoiceLayout.Item); dto.Date = DateTime.Today.Date; dto.ContactUid = this.MrSmith.Uid; dto.Summary = "Test Insert Item Purchase"; dto.Notes = "From REST"; dto.DueOrExpiryDate = dto.Date.AddMonths(1); dto.Status = InvoiceStatus.Invoice; dto.InvoiceNumber = "I123"; dto.PurchaseOrderNumber = "<Auto Number>"; ItemInvoiceItemDto item = null; item = new ItemInvoiceItemDto(); item.Quantity = 100; item.InventoryItemUid = this.HardDisk.Uid; item.Description = this.HardDisk.Description; item.TaxCode = TaxCode.ExpInclGst; item.UnitPriceInclTax = 99.95M; dto.Items.Add(item); item = new ItemInvoiceItemDto(); item.Quantity = 5000; item.InventoryItemUid = this.Cat5Cable.Uid; item.Description = this.Cat5Cable.Description; item.TaxCode = TaxCode.ExpInclGst; item.UnitPriceInclTax = 0.95M; dto.Items.Add(item); item = new ItemInvoiceItemDto(); item.Quantity = 1; item.InventoryItemUid = this.Shipping1.Uid; item.Description = this.Shipping1.Description; item.TaxCode = TaxCode.ExpInclGst; item.UnitPriceInclTax = 111.11M; dto.Items.Add(item); return dto; }
public void TestInsertAndGetItemPurchase_Invoice_Totals_Test() { //Arange var proxy = new InvoiceProxy(); var input = GetUnpaidItemPurchase(); input.Items.Clear(); var item = new ItemInvoiceItemDto { Quantity = 100, InventoryItemUid = this.HardDisk.Uid, Description = this.HardDisk.Description, TaxCode = TaxCode.SaleInclGst, UnitPriceInclTax = 99.95M }; input.Items.Add(item); item = new ItemInvoiceItemDto { Quantity = 5000, InventoryItemUid = this.Cat5Cable.Uid, Description = this.Cat5Cable.Description, TaxCode = TaxCode.SaleInclGst, UnitPriceInclTax = 0.95M }; input.Items.Add(item); //act var item1 = ((ItemInvoiceItemDto)input.Items[0]); var item2 = ((ItemInvoiceItemDto)input.Items[1]); var totalItem1 = (item1.UnitPriceInclTax*item1.Quantity); var totalItem2 = (item2.UnitPriceInclTax*item2.Quantity); var totalTax1 = totalItem1 - (Math.Round(totalItem1 / (1 + 0.100000m), 2, MidpointRounding.AwayFromZero)); var totalTax2 = totalItem2 - (Math.Round(totalItem2 / (1 + 0.100000m), 2, MidpointRounding.AwayFromZero)); proxy.Insert(input); var output = (InvoiceDto)proxy.GetByUid(input.Uid); var outputLineItem1 = ((ItemInvoiceItemDto)output.Items[0]); var outputLineItem2 = ((ItemInvoiceItemDto)output.Items[1]); //assert //Test Line Item Totals. Assert.AreEqual(outputLineItem1.TotalAmountInclTax, totalItem1); Assert.AreEqual(outputLineItem1.TotalTaxAmount, totalTax1); Assert.AreEqual(outputLineItem1.TotalAmountExclTax, outputLineItem1.TotalAmountInclTax - totalTax1); Assert.AreEqual(outputLineItem2.TotalAmountInclTax, totalItem2); Assert.AreEqual(outputLineItem2.TotalTaxAmount, totalTax2); Assert.AreEqual(outputLineItem2.TotalAmountExclTax, outputLineItem2.TotalAmountInclTax - totalTax2); //Test Invoice Totals. Assert.AreEqual(output.TotalAmountInclTax, outputLineItem1.TotalAmountInclTax + outputLineItem2.TotalAmountInclTax); Assert.AreEqual(output.TotalTaxAmount, outputLineItem1.TotalTaxAmount + outputLineItem2.TotalTaxAmount); Assert.AreEqual(output.TotalAmountExclTax, outputLineItem1.TotalAmountExclTax + outputLineItem2.TotalAmountExclTax); }
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); } }
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); } }
private InvoiceDto GetSaleOrder(InventoryItemDto itemDto) { InvoiceDto dto = new InvoiceDto(TransactionType.Sale, InvoiceLayout.Item); dto.Date = DateTime.Parse("6-Oct-05"); dto.ContactUid = this.MrSmith.Uid; dto.Summary = "Test Insert Item Sale"; dto.Notes = "From REST"; dto.DueOrExpiryDate = DateTime.Parse("6-Nov-05"); dto.Layout = InvoiceLayout.Item; dto.Status = InvoiceStatus.Order; dto.InvoiceNumber = "<Auto Number>"; dto.PurchaseOrderNumber = "PO333"; ItemInvoiceItemDto item = null; item = new ItemInvoiceItemDto(); item.Quantity = 5; item.InventoryItemUid = itemDto.Uid; item.Description = "Asus Laptop"; item.TaxCode = TaxCode.SaleInclGst; item.UnitPriceInclTax = 1200.75M; item.PercentageDiscount = 12.50M; dto.Items.Add(item); return dto; }
protected static void AssertEqual(ItemInvoiceItemDto expected, ItemInvoiceItemDto actual, int index) { string msg = "Item index: " + index.ToString() + ". Different "; Assert.AreEqual(expected.Quantity, actual.Quantity, msg + "quantity."); Assert.AreEqual(expected.InventoryItemUid, actual.InventoryItemUid, msg + "inventory item uid."); Assert.AreEqual(expected.Description, actual.Description, msg + "description."); Assert.AreEqual(expected.TaxCode, actual.TaxCode, msg + "tax code."); Assert.AreEqual(expected.UnitPriceInclTax, actual.UnitPriceInclTax, msg + "unit price incl tax."); Assert.AreEqual(expected.PercentageDiscount, actual.PercentageDiscount, msg + "percentage discount."); }