public void generateRemainingTimetabling(string fixedPath, Thread loadingThread)
{
try
{
string path = "comp01";
GenerateInstance instance = new GenerateInstance();
instance.main(path);
ResetILS();
IO.Read(path, fixedPath);
Solution solution = new Solution();
ILS ils = new ILS();
solution = ils.FindSolution();
IO.Write(solution.assignments, solution.GetScore());
insertSolutionOnSystem(IO.filename);
loadingThread.Abort();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
public List <ILS> FillILSs()
{
List <ILS> list = new List <ILS>();
if (this.ConnectioString != null)
{
try
{
using (var conn = new SQLiteConnection(this.ConnectioString))
{
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(@"SELECT * FROM ILS", conn);
SQLiteDataReader r = cmd.ExecuteReader();
while (r.Read())
{
ILS ils = new ILS();
ils.ils_id = r.GetValue(0) != DBNull.Value ? r.GetInt64(0) : 0;
ils.ident = r.GetValue(1) != DBNull.Value ? r.GetString(1) : "";
ils.name = r.GetValue(2) != DBNull.Value ? r.GetString(2) : "";
ils.region = r.GetValue(3) != DBNull.Value ? r.GetString(3) : "";
ils.frequency = r.GetValue(4) != DBNull.Value ? r.GetInt64(4) : 0;
ils.range = r.GetValue(5) != DBNull.Value ? r.GetInt64(5) : 0;
ils.mag_var = r.GetValue(6) != DBNull.Value ? r.GetDouble(6) : 0;
ils.has_backcourse = r.GetValue(7) != DBNull.Value ? r.GetInt64(7) : 0;
ils.dme_range = r.GetValue(8) != DBNull.Value ? r.GetInt64(8) : 0;
ils.dme_altitude = r.GetValue(9) != DBNull.Value ? r.GetInt64(9) : 0;
ils.dme_lonx = r.GetValue(10) != DBNull.Value ? r.GetDouble(10) : 0;
ils.dme_laty = r.GetValue(11) != DBNull.Value ? r.GetDouble(11) : 0;
ils.gs_range = r.GetValue(12) != DBNull.Value ? r.GetInt64(12) : 0;
ils.gs_pitch = r.GetValue(13) != DBNull.Value ? r.GetDouble(13) : 0;
ils.gs_altitude = r.GetValue(14) != DBNull.Value ? r.GetInt64(14) : 0;
ils.gs_lonx = r.GetValue(15) != DBNull.Value ? r.GetDouble(15) : 0;
ils.gs_laty = r.GetValue(16) != DBNull.Value ? r.GetDouble(16) : 0;
ils.loc_runway_end_id = r.GetValue(17) != DBNull.Value ? r.GetInt64(17) : 0;
ils.loc_airport_ident = r.GetValue(18) != DBNull.Value ? r.GetString(18) : "";
ils.loc_runway_name = r.GetValue(19) != DBNull.Value ? r.GetString(19) : "";
ils.loc_heading = r.GetValue(20) != DBNull.Value ? r.GetDouble(20) : 0;
ils.loc_width = r.GetValue(21) != DBNull.Value ? r.GetDouble(21) : 0;
ils.end1_lonx = r.GetValue(22) != DBNull.Value ? r.GetDouble(22) : 0;
ils.end1_laty = r.GetValue(23) != DBNull.Value ? r.GetDouble(23) : 0;
ils.end_mid_lonx = r.GetValue(24) != DBNull.Value ? r.GetDouble(24) : 0;
ils.end_mid_laty = r.GetValue(25) != DBNull.Value ? r.GetDouble(25) : 0;
ils.end2_lonx = r.GetValue(26) != DBNull.Value ? r.GetDouble(26) : 0;
ils.end2_laty = r.GetValue(27) != DBNull.Value ? r.GetDouble(27) : 0;
ils.altitude = r.GetValue(28) != DBNull.Value ? r.GetInt64(28) : 0;
ils.lonx = r.GetValue(29) != DBNull.Value ? r.GetDouble(29) : 0;
ils.laty = r.GetValue(30) != DBNull.Value ? r.GetDouble(30) : 0;
list.Add(ils);
}
}
}
catch (Exception ex)
{
}
}
return(list);
}
