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 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 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 InsertAndGetByUid()
{
ComboItemDto comboItemDto = this.GetComboItem01();
ComboItemProxy proxy = new ComboItemProxy();
proxy.Insert(comboItemDto);
ComboItemDto fromDB = (ComboItemDto)proxy.GetByUid(comboItemDto.Uid);
this.AssertEqual(comboItemDto, fromDB);
}
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 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 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 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);
}
}
