public void CheckQueryAircraftFlight()
{
var enviroment = GetEnviroment();
enviroment.NewLoader.FirstLoad();
var aircraftCore = new AircraftsCore(enviroment.Loader, enviroment.NewKeeper, enviroment.NewLoader);
aircraftCore.LoadAllAircrafts();
var itemsRelationsDataAccess = new ItemsRelationsDataAccess(enviroment);
var componentCore = new ComponentCore(enviroment, enviroment.Loader, enviroment.NewLoader, enviroment.NewKeeper, aircraftCore, itemsRelationsDataAccess);
var aircraftFlightCore = new AircraftFlightCore(enviroment, enviroment.Loader, enviroment.NewLoader, null, null, componentCore, null, aircraftCore);
aircraftFlightCore.LoadAircraftFlights(2316);
//aircraftFlightCore.LoadAllFlights();
}
public void FindFlights()
{
var env = GetEnviroment();
var aircraftCore = new AircraftsCore(env.Loader, env.NewKeeper, env.NewLoader);
var itemRelationCore = new ItemsRelationsDataAccess(env);
var directiveCore = new DirectiveCore(env.NewKeeper, env.NewLoader, env.Keeper, env.Loader, itemRelationCore);
var componentCore = new ComponentCore(env, env.Loader, env.NewLoader, env.NewKeeper, aircraftCore, itemRelationCore);
var aircraftFlightCore = new AircraftFlightCore(env, env.Loader, env.NewLoader, directiveCore, env.Manipulator, componentCore, env.NewKeeper, aircraftCore);
aircraftFlightCore.LoadAircraftFlights(2344);
var flights = aircraftFlightCore.GetAircraftFlightsByAircraftId(2343);
var codes = env.GetDictionary <AirportsCodes>().ToArray().Cast <AirportsCodes>();
var flightNums = env.GetDictionary <FlightNum>().Cast <FlightNum>().ToList();
//Экспортируем полеты в Dataset из Excel файла
var ds = ExcelToDataTableUsingExcelDataReader(@"H:\007.xlsx", false);
int time = 0;
foreach (DataTable table in ds.Tables)
{
foreach (DataRow row in table.Rows)
{
var pageNo = row[0].ToString();
AirportsCodes stationFromId = AirportsCodes.Unknown;
AirportsCodes stationToId = AirportsCodes.Unknown;
if (row[3] != null)
{
stationFromId = codes.FirstOrDefault(c => c.ShortName.ToUpper() == row[3].ToString().Trim().ToUpper());
}
if (row[4] != null)
{
stationToId = codes.FirstOrDefault(c => c.ShortName.ToUpper() == row[4].ToString().Trim().ToUpper());
}
var dateOut = DateTime.Parse(row[5].ToString());
var dateIn = DateTime.Parse(row[6].ToString());
var outTime = (int)dateOut.TimeOfDay.TotalMinutes;
var inTime = (int)dateIn.TimeOfDay.TotalMinutes;
var takeOffTime = outTime;
var lDGTime = inTime;
DateTime res;
if (!DateTime.TryParse(row[1].ToString(), out res))
{
Trace.WriteLine($"!!!!!!!!!Нету: {pageNo} | {row[1]} | {row[3]} - {row[4]} | ({outTime}-{inTime})");
if (outTime > inTime)
{
time += outTime - inTime;
}
else
{
time += inTime - outTime;
}
continue;
}
var flightDate = DateTime.Parse(row[1].ToString());
var find = flights.Where(i => i.PageNo == pageNo);
if (!find.Any())
{
Trace.WriteLine($"Нету: {pageNo} | {flightDate} | {row[3]} - {row[4]} | ({outTime}-{inTime})");
time += inTime - outTime;
}
}
Trace.WriteLine(time);
}
}
