Ejemplo n.º 1
0
        public void PO()
        {
            Console.Clear();
            var SqlConn        = new MyDbConnect("server=localhost;user=*****;database=invoice_match;port=3306;password=*****");
            var dbInteract     = new DbInteract(SqlConn);
            var purchaseOrders = new PurchaseOrders();

            Console.WriteLine("Enter PO numbers, when the last has been entered press enter again.");
            purchaseOrders.EnterPOs();
            purchaseOrders.MatchCheck(dbInteract);
            Console.WriteLine("The following POs are already filed:");
            Operations.DisplayEffected(purchaseOrders.ShowFiled());
            Console.WriteLine("\nPress Enter to continue.");
            Console.ReadLine();
            Console.WriteLine("The following orders are ready to file:");
            Operations.DisplayEffected(purchaseOrders.ShowMatched());
            Console.WriteLine("\n\nPress enter to change status to filed.");
            Console.ReadLine();
            purchaseOrders.ChangeStatus(dbInteract);
            Console.WriteLine("\n\nThe following orders need a database entry:");
            Operations.DisplayEffected(purchaseOrders.ShowNew());
            Console.WriteLine("\n\nPress enter to create entries.");
            Console.ReadLine();
            purchaseOrders.AddNew(dbInteract);
            Console.WriteLine("\nProcess Finished...\n");
        }
Ejemplo n.º 2
0
 public DbInteract(MyDbConnect sqlConn)
 {
     SqlConn = sqlConn;
 }