public async Task <IActionResult> GetAccountPayableDetailView(long accountPyableDetailId)
        {
            AccountPayableDetailModule invMod = new AccountPayableDetailModule();

            AccountPayableDetailView view = await invMod.AccountPayableDetail.Query().GetViewById(accountPyableDetailId);

            return(Ok(view));
        }
        public async Task <IActionResult> DeleteAccountPayableDetail([FromBody] AccountPayableDetailView view)
        {
            AccountPayableDetailModule invMod = new AccountPayableDetailModule();
            AccountPayableDetail       accountPyableDetail = await invMod.AccountPayableDetail.Query().MapToEntity(view);

            invMod.AccountPayableDetail.DeleteAccountPayableDetail(accountPyableDetail).Apply();

            return(Ok(view));
        }
        public async Task <IActionResult> AddAccountPayableDetail([FromBody] AccountPayableDetailView view)
        {
            AccountPayableDetailModule invMod = new AccountPayableDetailModule();

            NextNumber nnAccountPayableDetail = await invMod.AccountPayableDetail.Query().GetNextNumber();

            view.AccountPayableDetailNumber = nnAccountPayableDetail.NextNumberValue;

            AccountPayableDetail accountPyableDetail = await invMod.AccountPayableDetail.Query().MapToEntity(view);

            invMod.AccountPayableDetail.AddAccountPayableDetail(accountPyableDetail).Apply();

            AccountPayableDetailView newView = await invMod.AccountPayableDetail.Query().GetViewByNumber(view.AccountPayableDetailNumber);


            return(Ok(newView));
        }
예제 #4
0
        public async Task TestAddUpdatDelete()
        {
            AccountPayableModule AccountPayableMod = new AccountPayableModule();
            Supplier             supplier          = await AccountPayableMod.Supplier.Query().GetEntityById(3);

            ChartOfAccount chartOfAccount = await AccountPayableMod.ChartOfAccount.Query().GetEntityById(17);


            AccountPayableView view = new AccountPayableView()
            {
                DocNumber       = 17,
                GrossAmount     = 299.99M,
                DiscountAmount  = null,
                Remark          = null,
                Gldate          = DateTime.Now,
                SupplierId      = supplier.SupplierId,
                ContractId      = null,
                PoquoteId       = null,
                Description     = "back to school",
                PurchaseOrderId = null,
                Tax             = 16.08M,
                AccountId       = chartOfAccount.AccountId,
                DocType         = "STD",
                PaymentTerms    = "Net 30",
                DiscountPercent = 0,
                AmountOpen      = 0M,
                OrderNumber     = "PO-2",
                AmountPaid      = 299.99M,
            };
            NextNumber nnNextNumber = await AccountPayableMod.AccountPayable.Query().GetNextNumber();

            view.AccountPayableNumber = nnNextNumber.NextNumberValue;

            AccountPayable accountPayable = await AccountPayableMod.AccountPayable.Query().MapToEntity(view);

            AccountPayableMod.AccountPayable.AddAccountPayable(accountPayable).Apply();

            AccountPayable newAccountPayable = await AccountPayableMod.AccountPayable.Query().GetEntityByNumber(view.AccountPayableNumber);

            Assert.NotNull(newAccountPayable);

            //Add Account Payable Detail for an invoice detail payment
            AccountPayableDetailModule AccountPayableDetailMod = new AccountPayableDetailModule();

            Invoice invoice = await AccountPayableDetailMod.Invoice.Query().GetEntityById(20);

            InvoiceDetail invoiceDetail = await AccountPayableDetailMod.InvoiceDetail.Query().GetEntityById(21);

            PurchaseOrderDetail purchaseOrderDetail = await AccountPayableDetailMod.PurchaseOrderDetail.Query().GetEntityById(invoiceDetail.PurchaseOrderDetailId);

            AccountPayableDetailView accountPayableDetailView = new AccountPayableDetailView()
            {
                InvoiceId                  = invoice.InvoiceId,
                InvoiceDetailId            = invoiceDetail.InvoiceDetailId,
                UnitPrice                  = invoiceDetail.UnitPrice,
                Quantity                   = invoiceDetail.Quantity,
                QuantityReceived           = purchaseOrderDetail.ReceivedQuantity,
                Amount                     = purchaseOrderDetail.Amount,
                AmountPaid                 = invoiceDetail.Amount,
                PurchaseOrderDetailId      = invoiceDetail.PurchaseOrderDetailId,
                SalesOrderDetailId         = invoiceDetail.SalesOrderDetailId,
                ItemId                     = invoiceDetail.ItemId,
                ExtendedDescription        = invoiceDetail.ExtendedDescription,
                PurchaseOrderId            = invoiceDetail.PurchaseOrderId,
                CustomerId                 = invoiceDetail.CustomerId,
                SupplierId                 = invoiceDetail.SupplierId,
                AccountPayableId           = newAccountPayable.AccountPayableId,
                AccountPayableDetailNumber = (await AccountPayableDetailMod.AccountPayableDetail.Query().GetNextNumber()).NextNumberValue
            };

            AccountPayableDetail accountPayableDetail = await AccountPayableDetailMod.AccountPayableDetail.Query().MapToEntity(accountPayableDetailView);

            AccountPayableDetailMod.AccountPayableDetail.AddAccountPayableDetail(accountPayableDetail).Apply();

            AccountPayableDetail newAccountPayableDetail = await AccountPayableDetailMod.AccountPayableDetail.Query().GetEntityByNumber(accountPayableDetailView.AccountPayableDetailNumber);

            Assert.NotNull(newAccountPayableDetail);


            newAccountPayable.PaymentTerms = "Net 30 Update";

            AccountPayableMod.AccountPayable.UpdateAccountPayable(newAccountPayable).Apply();

            AccountPayableView updateView = await AccountPayableMod.AccountPayable.Query().GetViewById(newAccountPayable.AccountPayableId);

            Assert.Same(updateView.PaymentTerms, "Net 30 Update");

            AccountPayableDetailMod.AccountPayableDetail.DeleteAccountPayableDetail(newAccountPayableDetail).Apply();
            AccountPayableDetail lookupAccountPayableDetail = await AccountPayableDetailMod.AccountPayableDetail.Query().GetEntityById(accountPayableDetailView.AccountPayableDetailId);

            Assert.Null(lookupAccountPayableDetail);

            AccountPayableMod.AccountPayable.DeleteAccountPayable(newAccountPayable).Apply();
            AccountPayable lookupAccountPayable = await AccountPayableMod.AccountPayable.Query().GetEntityById(view.AccountPayableId);

            Assert.Null(lookupAccountPayable);
        }