Пример #1
0
        static void Main(string[] args)
        {
            Uri uri = new Uri("http://dynamicsnavdemo:7048/BC/ODataV4/Company('CRONUS%20International%20Ltd.')");

            NAV.NAV nav = new NAV.NAV(uri);

            var serviceCreds = new NetworkCredential("Administrator", "Noafl2020");
            var cache        = new CredentialCache();

            cache.Add(uri, "Basic", serviceCreds);
            nav.Credentials = cache;


            PrintPurchaseInvoice(nav);
            PrintAccounts(nav);
            PrintCustomers(nav);
            PrintVendors(nav);

            PrintGLCode(nav);


            PrintJobList(nav);

            Console.Read();
        }
        public void CreaConnessione()
        {
            Uri uri = new Uri(_url);

            _nav             = new NAV.NAV(uri);
            _nav.Credentials = new NetworkCredential(_user, _password);
        }
        public void CreaConnessione(string azienda)
        {
            _azienda = azienda;
            string url = "https://srv-bc.viamattei.metal-plus.it:7148/PROD_WS/ODataV4/Company('" + _azienda + "')/";
            Uri    uri = new Uri(url);

            _nav             = new NAV.NAV(uri);
            _nav.Credentials = new NetworkCredential(_user, _password);
        }
Пример #4
0
        private static void PrintVendors(NAV.NAV nav)
        {
            Console.WriteLine($"------------- Vendors ---------------");

            int i = 0;

            foreach (var v in nav.Vendors)
            {
                Console.WriteLine($"index:{i}, No:{v.No}, Name:{v.Name}");
                i++;
            }

            Console.ReadLine();
        }
Пример #5
0
        private static void PrintAccounts(NAV.NAV nav)
        {
            Console.WriteLine($"------------- GLAccountList ---------------");

            int i = 0;

            foreach (var v in nav.GLAccountList)
            {
                Console.WriteLine($"index:{i}, No:{v.No}, Name:{v.Name}");
                i++;
            }

            Console.ReadLine();
        }
Пример #6
0
        private static void PrintCustomers(NAV.NAV nav)
        {
            Console.WriteLine($"------------- Customers ---------------");
            //Cust_LedgerEntries
            int i = 0;

            foreach (var v in nav.Customers)
            {
                Console.WriteLine($"No.:{v.No}, Name:{v.Name}, Contact:{v.Contact}");
                i++;
            }

            Console.ReadLine();
        }
Пример #7
0
        private static void PrintPurchaseInvoice(NAV.NAV nav)
        {
            Console.WriteLine($"------------- PurchaseInfoice ---------------");
            //Cust_LedgerEntries
            int i = 0;

            foreach (var v in nav.PurchaseInvoice)
            {
                Console.WriteLine($"No.:{v.No}, Entry_Point:{v.Entry_Point}, Purchaser_Code:{v.Purchaser_Code}");
                i++;
            }

            Console.ReadLine();
        }
        private static void TestDynamicsNavODataWebService()
        {
            var nav = new odata.NAV(new Uri("http://win-k4iu0ll836s:7048/DynamicsNAV90/OData/Company('CRONUS%20International%20Ltd.')/"));

            nav.Credentials = CredentialCache.DefaultNetworkCredentials;

            Console.WriteLine("Printing list of customers");
            PrintCustomersOdata(nav);

            odata.Customer newCustomer = new odata.Customer();
            newCustomer.Name = "Customer Name Odata";
            nav.AddToCustomer(newCustomer);
            nav.SaveChanges();
        }
Пример #9
0
        private static void PrintGLCode(NAV.NAV nav)
        {
            bool glFound = false;

            foreach (NAV.G_LEntries gl in nav.G_LEntries)
            {
                glFound = true;
                Console.WriteLine($"GL Code.:{gl.G_L_Account_No}, Name:{gl.G_L_Account_Name}");
            }

            if (!glFound)
            {
                Console.WriteLine("There are no GL Code");
            }
            Console.ReadLine();
        }
        private static void PrintCustomersOdata(odata.NAV nav)
        {
            var customers = (from c in nav.Customer
                             where c.Name.Contains("a")
                             select c).ToList();
            bool customerFound = false;

            foreach (odata.Customer customer in customers)
            {
                customerFound = true;
                Console.WriteLine($"No.: {customer.No} Name: {customer.Name}");
            }

            if (!customerFound)
            {
                Console.WriteLine("The are no customers fulfilling filter criteria");
            }
        }
Пример #11
0
        private static void PrintJobList(NAV.NAV nav)
        {
            var jobList = from c in nav.Job_List
                          select c;

            bool jobFound = false;

            foreach (NAV.Job_List j in nav.Job_List)
            {
                jobFound = true;
                Console.WriteLine($"Job No.: {j.No},Job Name: {j.Description}");
            }

            if (!jobFound)
            {
                Console.WriteLine("There are no Job");
            }
            Console.ReadLine();
        }
        private static string TestDynamicsNavODataWebService()
        {
            var nav = new odata.NAV(new Uri("http://win-k4iu0ll836s:7048/DynamicsNAV90/OData/Company('CRONUS%20International%20Ltd.')/"));

            nav.Credentials = CredentialCache.DefaultNetworkCredentials;

            var sb = new StringBuilder();

            sb.AppendLine("Printing list of customers OData");
            sb.AppendLine(PrintCustomersOdata(nav));

            odata.Customer newCustomer = new odata.Customer();
            newCustomer.Name = "Customer Name Odata";
            nav.AddToCustomer(newCustomer);
            nav.SaveChanges();

            sb.AppendLine(PrintCustomersOdata(nav));
            return(sb.ToString());
        }
Пример #13
0
        private static void PrintVendor(NAV.NAV nav)
        {
            var vendors = from c in nav.VendorLedgerEntries
                          //where c.Vendor_Name.StartsWith("Paytec")
                          select c;

            Boolean vendorFound = false;

            foreach (var v in vendors)
            {
                vendorFound = true;
                Console.WriteLine($"Vendor No.:{v.Vendor_No}, Vendor Name:{v.Vendor_Name}");
            }

            if (!vendorFound)
            {
                Console.WriteLine("There are no Job");
            }
            Console.ReadLine();
        }
        private static string PrintCustomersOdata(odata.NAV nav)
        {
            var sb        = new StringBuilder();
            var customers = (from c in nav.Customer
                             where c.Name.Contains("a")
                             select c).ToList();
            bool customerFound = false;

            foreach (odata.Customer customer in customers)
            {
                customerFound = true;
                sb.AppendLine($"No.: {customer.No} Name: {customer.Name}");
            }

            if (!customerFound)
            {
                sb.AppendLine("The are no customers fulfilling filter criteria");
            }

            return(sb.ToString());
        }