public void ConvertFlightsNumForFlights()
{
var env = GetEnviroment();
var flights = env.NewLoader.GetObjectListAll <AircraftFlightDTO, AircraftFlight>().OrderBy(x => x.FlightNo);
var flightNums = env.GetDictionary <FlightNum>().Cast <FlightNum>().ToList();
foreach (var flight in flights)
{
var flightNum = flightNums.FirstOrDefault(x => x.FullName == flight.FlightNo);
if (flightNum == null)
{
var newFlightNum = new FlightNum {
FullName = flight.FlightNo
};
env.NewKeeper.Save(newFlightNum);
flightNums.Add(newFlightNum);
flight.FlightNumber = newFlightNum;
}
else
{
flight.FlightNumber = flightNum;
}
env.NewKeeper.Save(flight);
}
}
public void ImportFlights()
{
var env = GetEnviroment();
var codes = env.GetDictionary <AirportsCodes>().ToArray().Cast <AirportsCodes>();
var flightNums = env.GetDictionary <FlightNum>().Cast <FlightNum>().ToList();
//Экспортируем полеты в Dataset из Excel файла
var ds = ExcelToDataTableUsingExcelDataReader(@"H:\AZV.xlsx", false);
foreach (DataTable table in ds.Tables)
{
foreach (DataRow row in table.Rows)
{
var flight = new AircraftFlight();
flight.ATLBId = 151;
flight.AircraftId = 2335;
flight.DistanceMeasure = Measure.Kilometres;
flight.PageNo = row[0].ToString();
flight.FlightDate = DateTime.Parse(row[1].ToString());
var flightNum = flightNums.FirstOrDefault(x => x.FullName == row[2].ToString());
if (flightNum != null)
{
flight.FlightNumber = flightNum;
}
else
{
var newFlightNum = new FlightNum {
FullName = flight.FlightNo
};
env.NewKeeper.Save(newFlightNum);
flightNums.Add(newFlightNum);
flight.FlightNumber = newFlightNum;
}
if (row[3] != null)
{
flight.StationFromId = codes.FirstOrDefault(c => c.ShortName.ToUpper() == row[3].ToString().Trim().ToUpper());
}
if (row[4] != null)
{
flight.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());
flight.OutTime = (int)dateOut.TimeOfDay.TotalMinutes;
flight.InTime = (int)dateIn.TimeOfDay.TotalMinutes;
flight.TakeOffTime = flight.OutTime;
flight.LDGTime = flight.InTime;
env.NewKeeper.Save(flight);
}
}
}
public static FlightNumDTO Convert(this FlightNum flightnum)
{
return(new FlightNumDTO
{
ItemId = flightnum.ItemId,
IsDeleted = flightnum.IsDeleted,
Updated = flightnum.Updated,
CorrectorId = flightnum.CorrectorId,
FlightNumber = flightnum.FullName
});
}
