private void btnFullSync_Click(object sender, RoutedEventArgs e) { AccessQueries accquer = new AccessQueries(); //txtDBSyncStatus.Text = ""; if (cbStores.IsChecked.Value == true) { DataTable dt = new DataTable(); accquer.ImportDepartments(); //txtDBSyncStatus.Text += "Stores Imported...\n"; string addressid = "", departmentid = ""; foreach (DataRow row in dt.Rows) { // Insert into Address get ID addressid = si.InsertAddress("", "", "", "", "", "", "USA", "Imported from Access"); // Insert into Person get ID departmentid = si.InsertDepartment(row[0].ToString(), row[1].ToString(), addressid, "Imported from Access", "Active"); } try { dt.Clear(); } catch (Exception) { logging.writeToLog("Error: Clearing the results in Department of dataTable. "); } } if (cbEmployees.IsChecked.Value == true) { accquer.ImportEmployees(); // Import Employees //txtDBSyncStatus.Text += "Employees Imported...\n"; } if (cbCustomers.IsChecked.Value == true) { DataTable dt = new DataTable(); dt = accquer.ImportCustomers(); Customers(dt); //txtDBSyncStatus.Text += "Customers Imported...\n"; } if (cbVendors.IsChecked.Value == true) { DataTable dt = new DataTable(); eargs = eargs + "vendors "; //txtDBSyncStatus.Text += "Vendors Imported...\n"; // Import Vendors dt = accquer.ImportVendors(); VendorImport(dt); } if (cbCategories.IsChecked.Value == true) { //txtDBSyncStatus.Text += "Seasons Imported...\n"; //txtDBSyncStatus.Text += "Sizes Imported...\n"; //txtDBSyncStatus.Text += "Divisions Imported...\n"; // Import Divisions //txtDBSyncStatus.Text += "Classes Imported...\n"; // Import Classes // TODO: import categories } if (cbItems.IsChecked.Value == true) // Import Items { eargs = eargs + "items "; Items(); } if (cbTickets.IsChecked.Value == true) { DataTable tickets = new DataTable(); // Tickets => Date | TicketNumber | Total | Payment | Customer | Employee string date = dpTickets.SelectedDate.ToString(); DateTime start = DateTime.Now; DateTime end = DateTime.Now; start = conv.ConvertToDate(date); if (start.ToString("MM/dd/yyyy") == DateTime.Now.ToString("MM/dd/yyyy")) { start = start.AddMonths(-4); } for (var dte = start; dte <= end; dte = dte.AddDays(1)) { // Insert into tickets, ticket_items and ticket_payments tickets = accquer.GetTicketsByDate(dte.ToString("MM/dd/yyyy")); Tickets(tickets); tickets.Clear(); } PopUp pop = new PopUp("Tickets Imported.", "Tickets have finished importing."); pop.Show(); } //txtDBSyncStatus.Text += "Approvals Imported...\n"; //// Import Approvals //txtDBSyncStatus.Text += "Charge Customers Imported...\n"; //// Import Charge Customers. //txtDBSyncStatus.Text += "Cost Codes Imported...\n"; //// Import CostCode //txtDBSyncStatus.Text += "Credits Imported...\n"; //// Import Credits //txtDBSyncStatus.Text += "Orders Imported...\n"; //// Import Orders //txtDBSyncStatus.Text += "Sales Imported...\n"; //// Import Sales //txtDBSyncStatus.Text += "Tickets Imported...\n"; //// Import Tickets }