public void GenerateTheDB(string AirlineCompaniesNo, string CustomersNo, string FlightsPerCompany,
string TicketsPerCustomer, string CountriesNoToAdd)
{
_AirlineCompaniesNo = AirlineCompaniesNo;
_CustomersNo = CustomersNo;
_FlightsPerCompany = FlightsPerCompany;
_TicketsPerCustomer = TicketsPerCustomer;
_CountriesNoToAdd = CountriesNoToAdd;
try
{
//send all numbers from user to generate DB:
GenerateDataAndPutInDB = new GenerateDataAndPutInDB(Convert.ToInt32(_AirlineCompaniesNo),
Convert.ToInt32(_CustomersNo), Convert.ToInt32(_FlightsPerCompany),
Convert.ToInt32(_TicketsPerCustomer), Convert.ToInt32(_CountriesNoToAdd));
_bgWorker.DoWork += (s, e) =>
{
for (int i = 0; i < 101; i++)
{
Thread.Sleep(10);
WorkerState = i;
}
};
_bgWorker.RunWorkerAsync();
GenerateDataAndPutInDB.GenerateData();
}
catch (Exception exx)
{
//check all strings are numbers:
if (!Int32.TryParse(_AirlineCompaniesNo, out int i1))
{
MessageBox.Show("Airline Companies No is not A number");
MainWindowViewModel.ListForLog.Add("Airline Companies No is not A number");
}
if (!Int32.TryParse(_CustomersNo, out int i2))
{
MessageBox.Show("Customers No is not A number");
MainWindowViewModel.ListForLog.Add("Customers No is not A number");
}
if (!Int32.TryParse(_FlightsPerCompany, out int i3))
{
MessageBox.Show("Flights Per Company is not A number");
MainWindowViewModel.ListForLog.Add("Flights Per Company is not A number");
}
if (!Int32.TryParse(_TicketsPerCustomer, out int i4))
{
MessageBox.Show("Tickets Per Customer is not A number");
MainWindowViewModel.ListForLog.Add("Tickets Per Customer is not A number");
}
if (!Int32.TryParse(_CountriesNoToAdd, out int i5))
{
MessageBox.Show("Countries No To Add is not A number");
MainWindowViewModel.ListForLog.Add("Countries No To Add is not A number");
}
MessageBox.Show("The exception is: " + exx.ToString());
MainWindowViewModel.ListForLog.Add("The exception of not a number is: " + exx.ToString());
}
}
public void DeleteTheDB()
{
GenerateDataAndPutInDB2 = new GenerateDataAndPutInDB();
GenerateDataAndPutInDB2.DeleteFlightsDB();
}