Example #1
0
        private Ariv _checkbyInvoiceno(string invoiceno)
        {
            Ariv ariv = new Ariv(_dbpath);

            ariv.checkPayment(invoiceno);
            return(ariv);
        }
Example #2
0
 public UpdateBills(List <OutstandingBill> outstandingBills, string dbpath)
 {
     _outStandingBills = outstandingBills;
     _dbpath           = dbpath;
     _updatedBills     = new List <OutstandingBill>();
     _arpm             = new Arpm(_dbpath);
     _ariv             = new Ariv(_dbpath);
     _checkPayment();
 }
Example #3
0
        public void insertPayments()
        {
            foreach (AppPayments payment in _adyenPayments)
            {
                Console.WriteLine($"Checking payments for {payment.invoice_no} \n");
                Ariv ariv      = _checkbyInvoiceno(payment.invoice_no);
                int  gltransid = _gltrans.nextTransid();

                if (!String.IsNullOrEmpty(ariv.DOCNO))
                {
                    Console.WriteLine($"Recording the amount of {_convertAmount(payment.amount_paid)} for invoice : {payment.invoice_no}\n");

                    // _addGltrans(payment, "M", $"N{payment.code}", gltransid);
                    _addGltrans(payment, "M", $"{payment.unit_name}", gltransid);
                    _addGltrans(payment, "S", "310-000", gltransid);

                    int paymentDockey = _addPayment(payment, $"{payment.unit_name}", gltransid);
                    _addKnockoff(payment, ariv.DOCKEY, paymentDockey);
                    Console.WriteLine($"{ariv.PAYMENTAMT} + {_convertAmount(payment.amount_paid)}");
                    ariv.PAYMENTAMT = ariv.PAYMENTAMT + _convertAmount(payment.amount_paid);
                    ariv.Update(ariv.DOCNO);

                    // _adjustCustomerOutstanding(payment.amount_paid, $"N{payment.code}");
                    _adjustCustomerOutstanding(payment.amount_paid, $"{payment.unit_name}");

                    Console.WriteLine($"Updated payment : {ariv.PAYMENTAMT}\n");
                }
                else
                {
                    Console.WriteLine($"{payment.invoice_no} not found.\n");
                }
            }

            // Export receipts
            if (_khReceipts.Count != 0)
            {
                _exportReceipts(_khReceipts);
            }
        }
Example #4
0
        public void buildExport()
        {
            Fbexplore fbexplore = new Fbexplore(ConfigurationManager.AppSettings["estream"]);

            if (!String.IsNullOrEmpty(fbexplore.LatestPath))
            {
                Console.WriteLine($"Attempting to connect to latest DB : {fbexplore.LatestPath}\n");
                try
                {
                    // ===================================
                    //  Export new invoices to kiple home
                    // ===================================

                    Console.WriteLine($"Checking invoices for the past {ConfigurationManager.AppSettings["datespan"]} days.\n");

                    Ariv         ariv     = new Ariv(fbexplore.LatestPath);
                    FbDataReader invoices = ariv.queryInvoice();

                    if (invoices.HasRows)
                    {
                        PosthocBill posthocBill = new PosthocBill(ref invoices);

                        if (posthocBill.InvoiceLst.Count() != 0)
                        {
                            Console.WriteLine($"Invoice count: {posthocBill.InvoiceLst.Count()}\n");
                            ExportBill.dump(posthocBill.InvoiceLst, 0);
                        }
                        else
                        {
                            Console.WriteLine($"No invoice(s) found for the past {ConfigurationManager.AppSettings["datespan"]} days.\n");
                        }
                    }
                    else
                    {
                        Console.WriteLine($"No invoice(s) found for the past {ConfigurationManager.AppSettings["datespan"]} days.\n");
                    }

                    // ===================================================================================
                    //  Check kiple home for pending invoices. Export payments back to kiple home if any.
                    // ===================================================================================

                    Console.WriteLine("Checking for pending payments: Connecting to Kiple Home ...\n");
                    AssertBills assertBills = new AssertBills();
                    if (!(assertBills.Bills is null) && assertBills.Bills.Count != 0)
                    {
                        Console.WriteLine($"Outstanding Bills from KipleHome : {assertBills.Bills.Count} \n");
                        UpdateBills updateBills = new UpdateBills(assertBills.Bills, fbexplore.LatestPath);
                        updateBills.exportPayment();
                    }
                    else
                    {
                        Console.WriteLine("No outstanding bills. \n");
                    }

                    // =====================================================
                    //  Check kiple home for payments made through KipleBiz
                    // =====================================================

                    Console.WriteLine("Checking for payments made via KipleHome App ... \n");
                    AdyenPayment adyenPayment = new AdyenPayment();
                    if (!(adyenPayment.Payments is null) && adyenPayment.Payments.Count != 0)
                    {
                        Console.WriteLine($"Inserting {adyenPayment.Payments.Count} payment(s) to local database ... \n");
                        MakePayment makePayment = new MakePayment(adyenPayment.Payments, fbexplore.LatestPath);
                        makePayment.insertPayments();
                    }