public void CreateAirportScheme(AirportScheme airportScheme)
{
_airportSchemeRepository.Add(airportScheme);
SaveAirportScheme();
}
public void UpdateAirportScheme(AirportScheme airportScheme)
{
_airportSchemeRepository.Update(airportScheme);
SaveAirportScheme();
}
protected override void Seed(ClassifiersContext context)
{
//Service class initialization zone
ServiceClass economyClass = new ServiceClass()
{
Name = "Economy class"
};
ServiceClass businessClass = new ServiceClass()
{
Name = "Business class"
};
context.ServiceClasses.Add(economyClass);
context.ServiceClasses.Add(businessClass);
context.SaveChanges();
//Plane initialization zone
Plane a319Plane = new Plane()
{
FirstBCSeat = "A", LastBCSeat = "D", FirstECSeat = "A", LastECSeat = "F", FirstBCSeatRow = 1, LastBCSeatRow = 6,
FirstECSeatRow = 7, LastECSeatRow = 25, Manufacturer = "Airbus", PlaneModel = "A319",
PlaneModification = "100 with Business class", FuelConsumptionPerKm = 3.615
};
Plane a320PlaneEc = new Plane()
{
FirstBCSeat = "-", LastBCSeat = "-", FirstECSeat = "A", LastECSeat = "F", FirstBCSeatRow = 0, LastBCSeatRow = 0,
FirstECSeatRow = 1, LastECSeatRow = 30, Manufacturer = "Airbus", PlaneModel = "A320",
PlaneModification = "200 without Business class", FuelConsumptionPerKm = 4.698
};
Plane a320Plane = new Plane()
{
FirstBCSeat = "A", LastBCSeat = "D", FirstECSeat = "A", LastECSeat = "F", FirstBCSeatRow = 1, LastBCSeatRow = 7,
FirstECSeatRow = 8, LastECSeatRow = 30, Manufacturer = "Airbus", PlaneModel = "A320",
PlaneModification = "200 with Business class", FuelConsumptionPerKm = 4.698
};
Plane a321PlaneEc = new Plane()
{
FirstBCSeat = "-", LastBCSeat = "-", FirstECSeat = "A", LastECSeat = "F", FirstBCSeatRow = 0, LastBCSeatRow = 0,
FirstECSeatRow = 1, LastECSeatRow = 39, Manufacturer = "Airbus", PlaneModel = "A321",
PlaneModification = "100 without Business class", FuelConsumptionPerKm = 5.85
};
Plane a321Plane = new Plane()
{
FirstBCSeat = "A", LastBCSeat = "D", FirstECSeat = "A", LastECSeat = "F", FirstBCSeatRow = 1, LastBCSeatRow = 7,
FirstECSeatRow = 8, LastECSeatRow = 39, Manufacturer = "Airbus", PlaneModel = "A321",
PlaneModification = "100 with Business class", FuelConsumptionPerKm = 5.85
};
Plane b737PlaneEc = new Plane()
{
FirstBCSeat = "-", LastBCSeat = "-", FirstECSeat = "A", LastECSeat = "F", FirstBCSeatRow = 0, LastBCSeatRow = 0,
FirstECSeatRow = 1, LastECSeatRow = 28, Manufacturer = "Boeing", PlaneModel = "737",
PlaneModification = "800 without Business class", FuelConsumptionPerKm = 4.6536
};
Plane b737Plane = new Plane()
{
FirstBCSeat = "A", LastBCSeat = "D", FirstECSeat = "A", LastECSeat = "F", FirstBCSeatRow = 1, LastBCSeatRow = 5,
FirstECSeatRow = 6, LastECSeatRow = 28, Manufacturer = "Boeing", PlaneModel = "737",
PlaneModification = "800 with Business class", FuelConsumptionPerKm = 4.6536
};
context.Planes.AddRange(new List <Plane>()
{
a319Plane, a320Plane, a320PlaneEc, a321Plane, a321PlaneEc, b737Plane, b737PlaneEc
});
context.SaveChanges();
//Country initialization zone
Country russiaCountry = new Country()
{
Name = "Russia"
};
Country franceCountry = new Country()
{
Name = "France"
};
Country netherlandsCountry = new Country()
{
Name = "Netherlands"
};
Country germanyCountry = new Country()
{
Name = "Germany"
};
context.Countries.AddRange(new List <Country>()
{
russiaCountry, franceCountry,
netherlandsCountry, germanyCountry
});
//City initialization zone
City moscowCity = new City()
{
Name = "Moscow", Country = russiaCountry
};
City volgogradCity = new City()
{
Name = "Volgograd", Country = russiaCountry
};
City saratovCity = new City()
{
Name = "Saratov", Country = russiaCountry
};
City sochiCity = new City()
{
Name = "Sochi", Country = russiaCountry
};
City amsterdamCity = new City()
{
Name = "Amsterdam", Country = netherlandsCountry
};
City parisCity = new City()
{
Name = "Paris", Country = franceCountry
};
City berlinCity = new City()
{
Name = "Berlin", Country = germanyCountry
};
City frankfurtCity = new City()
{
Name = "Frankfurt", Country = germanyCountry
};
context.Cities.AddRange(new List <City>()
{
moscowCity, volgogradCity, saratovCity,
sochiCity, amsterdamCity, parisCity, berlinCity, frankfurtCity
});
context.SaveChanges();
//Airport initialization zone
Airport domodedovoAirport = new Airport()
{
Name = "Domodedovo", Code = "DME", City = moscowCity
};
Airport vnukovoAirport = new Airport()
{
Name = "Vnukovo", Code = "VKO", City = moscowCity
};
Airport scheremetevoAirport = new Airport()
{
Name = "Scheremetevo", Code = "SVO", City = moscowCity
};
Airport volgAirport = new Airport()
{
Name = "Volgograd airport", Code = "VGO", City = volgogradCity
};
Airport saratovAirport = new Airport()
{
Name = "Saratov airport", Code = "SAO", City = saratovCity
};
Airport sochiAirport = new Airport()
{
Name = "Sochi airport", Code = "SCH", City = sochiCity
};
Airport schipholAirport = new Airport()
{
Name = "Schiphol", Code = "SPL", City = amsterdamCity
};
Airport sharlDeGollAirport = new Airport()
{
Name = "Sharl-De-Goll airport", Code = "SGD", City = parisCity
};
Airport schonefieldAirport = new Airport()
{
Name = "Schonefield", Code = "SCF", City = berlinCity
};
Airport frankfurtOnMaineAirport = new Airport()
{
Name = "Frankfurt on Meine", Code = "FOM", City = frankfurtCity
};
//Airport domodedovoAirport = new Airport() { Name = "Domodedovo", Code = "DME", Country = russiaCountry, City = moscowCity };
//Airport vnukovoAirport = new Airport() { Name = "Vnukovo", Code = "VKO", Country = russiaCountry, City = moscowCity };
//Airport scheremetevoAirport = new Airport() { Name = "Scheremetevo", Code = "SVO", Country = russiaCountry, City = moscowCity };
//Airport volgAirport = new Airport() { Name = "Volgograd airport", Code = "VGO", Country = russiaCountry, City = volgogradCity };
//Airport saratovAirport = new Airport() { Name = "Saratov airport", Code = "SAO", Country = russiaCountry, City = saratovCity };
//Airport sochiAirport = new Airport() { Name = "Sochi airport", Code = "SCH", Country = russiaCountry, City = sochiCity };
//Airport schipholAirport = new Airport() { Name = "Schiphol", Code = "SPL", Country = netherlandsCountry, City = amsterdamCity };
//Airport sharlDeGollAirport = new Airport() { Name = "Sharl-De-Goll airport", Code = "SGD", Country = franceCountry, City = parisCity };
//Airport schonefieldAirport = new Airport() { Name = "Schonefield", Code = "SCF", Country = germanyCountry, City = berlinCity };
//Airport frankfurtOnMaineAirport = new Airport() { Name = "Frankfurt on Meine", Code = "FOM", Country = germanyCountry, City = frankfurtCity };
context.Airports.AddRange(new List <Airport>()
{
domodedovoAirport, vnukovoAirport, scheremetevoAirport, volgAirport,
saratovAirport, sochiAirport, schipholAirport, sharlDeGollAirport, schonefieldAirport,
frankfurtOnMaineAirport
});
//Terminal initialization zone
Terminal aTerminal = new Terminal()
{
Name = "A"
};
Terminal bTerminal = new Terminal()
{
Name = "B"
};
Terminal cTerminal = new Terminal()
{
Name = "C"
};
Terminal dTerminal = new Terminal()
{
Name = "D"
};
Terminal eTerminal = new Terminal()
{
Name = "E"
};
context.Terminals.AddRange(new List <Terminal>()
{
aTerminal, bTerminal, cTerminal, dTerminal, eTerminal
});
//Gate initialization zone
Gate gate1 = new Gate()
{
Name = "1"
};
Gate gate2 = new Gate()
{
Name = "2"
};
Gate gate3 = new Gate()
{
Name = "3"
};
Gate gate4 = new Gate()
{
Name = "4"
};
Gate gate5 = new Gate()
{
Name = "5"
};
Gate gate6 = new Gate()
{
Name = "6"
};
Gate gate7 = new Gate()
{
Name = "7"
};
Gate gate8 = new Gate()
{
Name = "8"
};
Gate gate9 = new Gate()
{
Name = "9"
};
Gate gate10 = new Gate()
{
Name = "10"
};
Gate gate11 = new Gate()
{
Name = "11"
};
Gate gate12 = new Gate()
{
Name = "12"
};
Gate gate13 = new Gate()
{
Name = "13"
};
Gate gate14 = new Gate()
{
Name = "14"
};
Gate gate15 = new Gate()
{
Name = "15"
};
context.Gates.AddRange(new List <Gate>()
{
gate1, gate2, gate3, gate4, gate5, gate6, gate6, gate7, gate8, gate9, gate10, gate1, gate12, gate13,
gate14, gate15
});
context.SaveChanges();
//random generation of airport schemes for all airports
List <Airport> Airports = context.Airports.ToList();
List <Terminal> Terminals = context.Terminals.ToList();
List <Gate> Gates = context.Gates.ToList();
Random random = new Random();
foreach (Airport airport in Airports)
{
foreach (Terminal terminal in Terminals)
{
int gatesCount = random.Next(5, 15);
for (int i = 0; i < gatesCount; i++)
{
AirportScheme airportScheme = new AirportScheme()
{
Airport = airport, Terminal = terminal,
Gate = Gates[i]
};
context.AirportSchemes.Add(airportScheme);
}
}
}
context.SaveChanges();
}
