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
}
