private void sync_Click(object sender, EventArgs e)
{
// batch update queries: Seb + Gianni
string fetchCustomersDB = "INSERT INTO SecondaryDB.mdb.Customers SELECT * FROM Customers",
fetchFlightsDB = "INSERT INTO SecondaryDB.mdb.Flights SELECT * FROM Flights",
fetchHotelDB = "INSERT INTO SecondaryDB.mdb.Hotel SELECT * FROM Hotel",
fetchCarsDB = "INSERT INTO SecondaryDB.mdb.Cars SELECT * FROM Cars";
string[] dbList = { fetchCustomersDB, fetchFlightsDB, fetchHotelDB, fetchCarsDB };
// Avar: batch update notification
var primaryDatabase = new PrimaryDatabase();
bool query = primaryDatabase.batchUpdate(dbList, false);
if (query == true)
{
MessageBox.Show("Sync completed successfully.");
}
else
{
MessageBox.Show("Sync unsuccessful. Please contact your system administrator.");
}
}
private void button1_Click(object sender, EventArgs e)
{
// batch update queries
string fetchCustomersDB = "INSERT INTO SecondaryDB.mdb.Customers SELECT * FROM Customers",
fetchFlightsDB = "INSERT INTO SecondaryDB.mdb.Flights SELECT * FROM Flights",
fetchHotelDB = "INSERT INTO SecondaryDB.mdb.Hotel SELECT * FROM Hotel",
fetchCarsDB = "INSERT INTO SecondaryDB.mdb.Cars SELECT * FROM Cars";
string[] dbList = { fetchCustomersDB, fetchFlightsDB, fetchHotelDB, fetchCarsDB };
var primaryDatabase = new PrimaryDatabase();
bool query = primaryDatabase.batchUpdate(dbList, false);
if (query == true)
{
MessageBox.Show("Syncronization successfull"); // success
}
else
{
// fail
}
}
