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"); }
public void AddNew(DbInteract dbInteract) { dbInteract.AddNew(NewInvoices, @", 'Y', 'N', 'N'"); }
public void ChangeStatus(DbInteract dbInteract) { dbInteract.ChangeValue(Matched, "invoice"); dbInteract.ChangeValue(Matched, "filed"); }
public void MatchCheck(DbInteract dbInteract) { dbInteract.InputSorter(2, 1, NewInvoices, Matched, Filed); }
public void MatchCheck(DbInteract dbInteract) { dbInteract.InputSorter(1, 2, NewPOs, Matched, Filed); }