public async Task TestAddUpdatDelete() { SupplierModule SupplierMod = new SupplierModule(); SupplierView view = new SupplierView() { SupplierId = 1, AddressId = 20, Identification = "test" }; NextNumber nnNextNumber = await SupplierMod.Supplier.Query().GetNextNumber(); view.SupplierNumber = nnNextNumber.NextNumberValue; Supplier supplier = await SupplierMod.Supplier.Query().MapToEntity(view); SupplierMod.Supplier.AddSupplier(supplier).Apply(); Supplier newSupplier = await SupplierMod.Supplier.Query().GetEntityByNumber(view.SupplierNumber); Assert.NotNull(newSupplier); newSupplier.Identification = "test update"; SupplierMod.Supplier.UpdateSupplier(newSupplier).Apply(); SupplierView updateView = await SupplierMod.Supplier.Query().GetViewById(newSupplier.SupplierId); Assert.Same(updateView.Identification, "test update"); SupplierMod.Supplier.DeleteSupplier(newSupplier).Apply(); Supplier lookupSupplier = await SupplierMod.Supplier.Query().GetEntityById(view.SupplierId); Assert.Null(lookupSupplier); }
public async Task <IActionResult> GetSupplierView(long supplierId) { SupplierModule invMod = new SupplierModule(); SupplierView view = await invMod.Supplier.Query().GetViewById(supplierId); return(Ok(view)); }
public async Task <IActionResult> DeleteSupplier([FromBody] SupplierView view) { SupplierModule invMod = new SupplierModule(); Supplier supplier = await invMod.Supplier.Query().MapToEntity(view); invMod.Supplier.DeleteSupplier(supplier).Apply(); return(Ok(view)); }
public async Task <IActionResult> UpdateSupplier([FromBody] SupplierView view) { SupplierModule invMod = new SupplierModule(); Supplier supplier = await invMod.Supplier.Query().MapToEntity(view); invMod.Supplier.UpdateSupplier(supplier).Apply(); SupplierView retView = await invMod.Supplier.Query().GetViewById(supplier.SupplierId); return(Ok(retView)); }
public async Task <IActionResult> AddSupplier([FromBody] SupplierView view) { SupplierModule invMod = new SupplierModule(); NextNumber nnSupplier = await invMod.Supplier.Query().GetNextNumber(); view.SupplierNumber = nnSupplier.NextNumberValue; Supplier supplier = await invMod.Supplier.Query().MapToEntity(view); invMod.Supplier.AddSupplier(supplier).Apply(); SupplierView newView = await invMod.Supplier.Query().GetViewByNumber(view.SupplierNumber); return(Ok(newView)); }
public async Task TestReceiveSupplierInvoice() { long? supplierId = 3; SupplierModule supplierMod = new SupplierModule(); try { SupplierView supplierView = await supplierMod.Supplier.Query().GetViewById(supplierId ?? 0); string json = @"{ ""SupplierId"" : " + supplierView.SupplierId + @", ""SupplierInvoiceNumber"": ""AZW23-1"", ""SupplierInvoiceDate"" : """ + DateTime.Parse("8/20/2018") + @""", ""PONumber"" : ""PO-2"", ""Amount"": 268, ""Description"": ""Back to School supplies"", ""TaxAmount"" : 16.08, ""PaymentDueDate"": """ + DateTime.Parse("8/20/2018") + @""", ""PaymentTerms"" : ""Net 30"", ""FreightCost"" : 4.98, ""SupplierInvoiceDetailViews"":[ { ""ItemId"": 5, ""Quantity"": 5, ""UnitPrice"" : " + 10 + @", ""ExtendedCost"" : " + 50 + @", ""UnitOfMeasure"" : """ + "Dozen" + @""", ""Description"": """ + "Pencil HB" + @""" }, { ""ItemId"": 6, ""Quantity"": 4, ""UnitPrice"" : " + 10 + @", ""ExtendedCost"" : " + 40 + @", ""UnitOfMeasure"" : """ + "Dozen" + @""", ""Description"": """ + "Pencils 2B" + @""" }, { ""ItemId"": 7, ""Quantity"": 10, ""UnitPrice"" : " + 3 + @", ""ExtendedCost"" : " + 30 + @", ""UnitOfMeasure"" : """ + "Ream" + @""", ""Description"": """ + "Paper - A4, Photo coper, 70 grams" + @""" }, { ""ItemId"": 8, ""Quantity"": 15, ""UnitPrice"" : " + 3.20 + @", ""ExtendedCost"" : " + 48 + @", ""UnitOfMeasure"" : """ + "Ream" + @""", ""Description"": """ + "NPaper - A4, Photo Copier, 80 gramULL" + @""" }, { ""ItemId"": 9, ""Quantity"": 5, ""UnitPrice"" : " + 10 + @", ""ExtendedCost"" : " + 100 + @", ""UnitOfMeasure"" : """ + "Ream" + @""", ""Description"": """ + "Pens - Ball Point, Blue" + @""" } ] }"; SupplierInvoiceView supplierInvoiceView = JsonConvert.DeserializeObject <SupplierInvoiceView>(json); AccountPayableModule apMod = new AccountPayableModule(); apMod.CreateSupplierInvoice(supplierInvoiceView); apMod.AccountPayable.Apply(); } catch (Exception ex) { } }
public async Task TestCreatePurchaseOrder() { SupplierModule supplierMod = new SupplierModule(); ItemMaster itemMaster = new ItemMaster(); itemMaster.ItemCode = "P2001Test"; itemMaster.Branch = "700"; itemMaster.Description = "Highlighter - 3 Color"; itemMaster.UnitOfMeasure = "Sets"; itemMaster.UnitPrice = 6M; supplierMod.ItemMaster.CreateItemMaster(itemMaster); supplierMod.ItemMaster.Apply(); AddressBook addressBook = new AddressBook(); addressBook.CompanyName = "Sample Company Part Ltd"; addressBook.Name = ""; addressBook.FirstName = ""; addressBook.LastName = ""; LocationAddress locationAddress = new LocationAddress(); locationAddress.AddressLine1 = "204 Collins Street"; locationAddress.City = "Melbourne"; locationAddress.Zipcode = "3000"; locationAddress.Country = "Australia"; EmailEntity email = new EmailEntity(); email.Email = "*****@*****.**"; email.LoginEmail = true; email.Password = "******"; supplierMod.CreateSupplierProfile(addressBook, email, locationAddress); SupplierView supplierView = await supplierMod.Supplier.Query().GetViewByEmail(email); ChartOfAccount coa = await supplierMod.ChartOfAccount.Query().GetEntity("1000", "1200", "240", ""); Company company = await supplierMod.ChartOfAccount.Query().GetCompany(); ItemMaster[] itemMasterLookup = new ItemMaster[5]; itemMasterLookup[0] = await supplierMod.ItemMaster.Query().GetEntityById(5); itemMasterLookup[1] = await supplierMod.ItemMaster.Query().GetEntityById(6); itemMasterLookup[2] = await supplierMod.ItemMaster.Query().GetEntityById(7); itemMasterLookup[3] = await supplierMod.ItemMaster.Query().GetEntityById(8); itemMasterLookup[4] = await supplierMod.ItemMaster.Query().GetEntityById(9); Udc udcAcctPayDocType = await supplierMod.Udc.Query().GetUdc("AcctPayDocType", "STD"); string json = @"{ ""DocType"" : """ + udcAcctPayDocType.KeyCode + @""", ""PaymentTerms"" : ""Net 30"", ""GLDate"" : """ + DateTime.Parse("7/30/2018") + @""", ""AccountId"" :" + coa.AccountId + @", ""SupplierId"" :" + (supplierView.SupplierId).ToString() + @", ""SupplierName"" :""" + supplierView.SupplierName + @""", ""Description"" :""Back to School Inventory"", ""PONumber"" :""PO-2"", ""TakenBy"" : ""David Nishimoto"", ""BuyerId"" :" + company.CompanyId + @", ""TaxCode1"" :""" + company.TaxCode1 + @""", ""TaxCode2"" :""" + company.TaxCode2 + @""", ""ShippedToName"" :""" + company.CompanyName + @""", ""ShippedToAddress1"" :""" + company.CompanyStreet + @""", ""ShippedToCity"" :""" + company.CompanyCity + @""", ""ShippedToState"" :""" + company.CompanyState + @""", ""ShippedToZipcode"" :""" + company.CompanyZipcode + @""", ""RequestedDate"" :""" + DateTime.Parse("7/24/2018") + @""", ""PromisedDeliveredDate"" :""" + DateTime.Parse("8/2/2018") + @""", ""TransactionDate"" :""" + DateTime.Parse("7/30/2018") + @""", ""PurchaseOrderDetailViews"":[ { ""ItemId"": 5, ""OrderDate"":""" + DateTime.Parse("7 / 30 / 2018") + @""", ""OrderedQuantity"": 5, ""UnitPrice"" : " + itemMasterLookup[0].UnitPrice + @", ""UnitOfMeasure"" : """ + itemMasterLookup[0].UnitOfMeasure + @""", ""Amount"" : " + itemMasterLookup[0].UnitPrice * 5 + @", ""Description"": """ + itemMasterLookup[0].Description + @""", ""ExpectedDeliveryDate"" :""" + DateTime.Parse("8/2/2018") + @""", ""ReceivedQuantity"":0, ""RemainingQuantity"":5 }, { ""ItemId"": 6, ""OrderDate"":""" + DateTime.Parse("7 / 30 / 2018") + @""", ""OrderedQuantity"": 4, ""UnitPrice"" : " + itemMasterLookup[1].UnitPrice + @", ""UnitOfMeasure"" : """ + itemMasterLookup[1].UnitOfMeasure + @""", ""Amount"" : " + itemMasterLookup[1].UnitPrice * 4 + @", ""Description"": """ + itemMasterLookup[1].Description + @""", ""ExpectedDeliveryDate"" :""" + DateTime.Parse("8/2/2018") + @""", ""ReceivedQuantity"":0, ""RemainingQuantity"":4 }, { ""ItemId"": 7, ""OrderDate"":""" + DateTime.Parse("7 / 30 / 2018") + @""", ""OrderedQuantity"": 10, ""UnitPrice"" : " + itemMasterLookup[2].UnitPrice + @", ""UnitOfMeasure"" : """ + itemMasterLookup[2].UnitOfMeasure + @""", ""Amount"" : " + itemMasterLookup[2].UnitPrice * 10 + @", ""Description"": """ + itemMasterLookup[2].Description + @""", ""ExpectedDeliveryDate"" :""" + DateTime.Parse("8/2/2018") + @""", ""ReceivedQuantity"":0, ""RemainingQuantity"":10 }, { ""ItemId"": 8, ""OrderDate"":""" + DateTime.Parse("7 / 30 / 2018") + @""", ""OrderedQuantity"": 15, ""UnitPrice"" : " + itemMasterLookup[3].UnitPrice + @", ""UnitOfMeasure"" : """ + itemMasterLookup[3].UnitOfMeasure + @""", ""Amount"" : " + itemMasterLookup[3].UnitPrice * 15 + @", ""Description"": """ + itemMasterLookup[3].Description + @""", ""ExpectedDeliveryDate"" :""" + DateTime.Parse("8/2/2018") + @""", ""ReceivedQuantity"":0, ""RemainingQuantity"":15 }, { ""ItemId"": 9, ""OrderDate"":""" + DateTime.Parse("7 / 30 / 2018") + @""", ""OrderedQuantity"": 10, ""UnitPrice"" : " + itemMasterLookup[4].UnitPrice + @", ""UnitOfMeasure"" : """ + itemMasterLookup[3].UnitOfMeasure + @""", ""Amount"" : " + itemMasterLookup[4].UnitPrice * 10 + @", ""Description"": """ + itemMasterLookup[4].Description + @""", ""ExpectedDeliveryDate"" :""" + DateTime.Parse("8/2/2018") + @""", ""ReceivedQuantity"":0, ""RemainingQuantity"":10 } ] }"; PurchaseOrderView purchaseOrderView = JsonConvert.DeserializeObject <PurchaseOrderView>(json); AccountPayableModule apMod = new AccountPayableModule(); apMod.CreateByPurchaseOrderView(purchaseOrderView); apMod.AccountPayable.Apply(); Assert.True(true); }
public async Task TestCreateInboundPackingSlip() { long supplierId = 3; try { SupplierModule supplierMod = new SupplierModule(); SupplierView supplierView = await supplierMod.Supplier.Query().GetViewById(supplierId); Udc slipTypeUDC = await supplierMod.Udc.Query().GetUdc("PACKINGSLIP_TYPE", "INBOUND"); string json = @"{ ""SupplierId"" : " + supplierView.SupplierId + @", ""ReceivedDate"" : """ + DateTime.Parse("8/16/2018") + @""", ""SlipDocument"" : ""SLIP-1"", ""PONumber"" :""PO-2"", ""SlipType"" : """ + slipTypeUDC.KeyCode + @""", ""PackingSlipDetailViews"":[ { ""ItemId"": 5, ""Quantity"": 5, ""UnitPrice"" : " + 10 + @", ""ExtendedCost"" : " + 50 + @", ""UnitOfMeasure"" : """ + "Dozen" + @""", ""Description"": """ + "Pencil HB" + @""" }, { ""ItemId"": 6, ""Quantity"": 4, ""UnitPrice"" : " + 10 + @", ""ExtendedCost"" : " + 40 + @", ""UnitOfMeasure"" : """ + "Dozen" + @""", ""Description"": """ + "Pencils 2B" + @""" }, { ""ItemId"": 7, ""Quantity"": 10, ""UnitPrice"" : " + 3 + @", ""ExtendedCost"" : " + 30 + @", ""UnitOfMeasure"" : """ + "Ream" + @""", ""Description"": """ + "Paper - A4, Photo coper, 70 grams" + @""" }, { ""ItemId"": 8, ""Quantity"": 15, ""UnitPrice"" : " + 3.20 + @", ""ExtendedCost"" : " + 48 + @", ""UnitOfMeasure"" : """ + "Ream" + @""", ""Description"": """ + "NPaper - A4, Photo Copier, 80 gramULL" + @""" }, { ""ItemId"": 9, ""Quantity"": 5, ""UnitPrice"" : " + 10 + @", ""ExtendedCost"" : " + 100 + @", ""UnitOfMeasure"" : """ + "Ream" + @""", ""Description"": """ + "Pens - Ball Point, Blue" + @""" } ] }"; PackingSlipView packingSlipView = JsonConvert.DeserializeObject <PackingSlipView>(json); AccountPayableModule apMod = new AccountPayableModule(); apMod.CreatePackingSlip(packingSlipView); apMod.AccountPayable.Apply(); Assert.True(true); } catch (Exception ex) { } }
private void SupplierModuleBtn_Click(object sender, EventArgs e) { SupplierModule supplierModule = new SupplierModule(); supplierModule.ShowDialog(); }