public static void Initialize(BusContext context)
{
// create seats
context.SeatFormats.AddOrUpdate(f => f.Name,
new SeatFormat { Name = "Format1" });
context.SaveChanges();
context.Seats.AddOrUpdate(s => s.UniqueId,
new Seat { SeatFormatId = 1, SeatClass = "Business", SeatNumber = "A1", UniqueId = "1-1"},
new Seat { SeatFormatId = 1, SeatClass = "Business", SeatNumber = "A2", UniqueId = "1-2"},
new Seat { SeatFormatId = 1, SeatClass = "Business", SeatNumber = "B1", UniqueId = "1-3"},
new Seat { SeatFormatId = 1, SeatClass = "Business", SeatNumber = "B2", UniqueId = "1-4"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "C1", UniqueId = "1-5"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "C2", UniqueId = "1-6"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "C3", UniqueId = "1-7"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "C4", UniqueId = "1-8"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "D1", UniqueId = "1-9"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "D2", UniqueId = "1-10"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "D3", UniqueId = "1-11"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "D4", UniqueId = "1-12"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "E1", UniqueId = "1-13"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "E2", UniqueId = "1-14"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "E3", UniqueId = "1-15"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "E4", UniqueId = "1-16"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "F1", UniqueId = "1-17"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "F2", UniqueId = "1-18"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "F3", UniqueId = "1-19"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "F4", UniqueId = "1-20"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "G1", UniqueId = "1-21"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "G2", UniqueId = "1-22"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "G3", UniqueId = "1-23"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "G4", UniqueId = "1-24"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "H1", UniqueId = "1-25"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "H2", UniqueId = "1-26"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "H3", UniqueId = "1-27"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "H4", UniqueId = "1-28"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "I1", UniqueId = "1-29"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "I2", UniqueId = "1-30"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "I3", UniqueId = "1-31"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "I4", UniqueId = "1-32"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "J1", UniqueId = "1-33"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "J2", UniqueId = "1-34"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "J3", UniqueId = "1-35"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "J4", UniqueId = "1-36"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "K1", UniqueId = "1-37"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "K2", UniqueId = "1-38"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "K3", UniqueId = "1-39"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "K4", UniqueId = "1-40"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "L1", UniqueId = "1-41"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "L2", UniqueId = "1-42"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "L3", UniqueId = "1-43"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "L4", UniqueId = "1-44"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "M1", UniqueId = "1-45"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "M2", UniqueId = "1-46"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "M3", UniqueId = "1-47"},
new Seat { SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "M4", UniqueId = "1-48"}
);
// create companies and bus types
context.Companies.AddOrUpdate(c => c.Name,
new Company { Name = "Shohagh Paribahan" },
new Company { Name = "GreenLine Paribahan" },
new Company { Name = "Shyamoli Paribahan" },
new Company { Name = "Hanif Paribahan" },
new Company { Name = "Saudia S. Aalam" });
context.BuseTypes.AddOrUpdate(b => b.Name,
new BusType { Name = "Volvo 48 Seater", SeatFormatId = 1 },
new BusType { Name = "AC 48 Seater", SeatFormatId = 1 },
new BusType { Name = "Non-AC 48 Seater", SeatFormatId = 1 });
// create locations
context.Locations.AddOrUpdate(l => l.Name,
new Location { Name = "Dhaka" },
new Location { Name = "Sylhet" },
new Location { Name = "Chittagong" },
new Location { Name = "Bandarban" },
new Location { Name = "Coxs Bazar" },
new Location { Name = "Rangamati" },
new Location { Name = "Khulna" },
new Location { Name = "Srimangal" },
new Location { Name = "Jessore" },
new Location { Name = "Rajshahi" });
// create schedules
context.Schedules.AddOrUpdate(s => s.DepartureTime,
new Schedule
{
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed vitae consectetur ante. Aliquam hendrerit libero eros, sed condimentum ligula egestas et. Nam lacus neque, ornare.",
DepartureTime = DateTime.Parse("2014-06-23 08:00:00"),
JourneyFromId = 1,
JourneyToId = 2,
BusTypeId = 1,
CompanyId = 1
},
new Schedule
{
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed vitae consectetur ante. Aliquam hendrerit libero eros, sed condimentum ligula egestas et. Nam lacus neque, ornare.",
DepartureTime = DateTime.Parse("2014-06-23 12:00:00"),
JourneyFromId = 1,
JourneyToId = 2,
BusTypeId = 1,
CompanyId = 2
});
}
public static void Initialize(BusContext context)
{
// create seats
context.SeatFormats.AddOrUpdate(f => f.Name,
new SeatFormat {
Name = "Format1"
});
context.SaveChanges();
context.Seats.AddOrUpdate(s => s.UniqueId,
new Seat {
SeatFormatId = 1, SeatClass = "Business", SeatNumber = "A1", UniqueId = "1-1"
},
new Seat {
SeatFormatId = 1, SeatClass = "Business", SeatNumber = "A2", UniqueId = "1-2"
},
new Seat {
SeatFormatId = 1, SeatClass = "Business", SeatNumber = "B1", UniqueId = "1-3"
},
new Seat {
SeatFormatId = 1, SeatClass = "Business", SeatNumber = "B2", UniqueId = "1-4"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "C1", UniqueId = "1-5"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "C2", UniqueId = "1-6"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "C3", UniqueId = "1-7"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "C4", UniqueId = "1-8"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "D1", UniqueId = "1-9"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "D2", UniqueId = "1-10"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "D3", UniqueId = "1-11"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "D4", UniqueId = "1-12"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "E1", UniqueId = "1-13"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "E2", UniqueId = "1-14"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "E3", UniqueId = "1-15"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "E4", UniqueId = "1-16"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "F1", UniqueId = "1-17"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "F2", UniqueId = "1-18"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "F3", UniqueId = "1-19"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "F4", UniqueId = "1-20"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "G1", UniqueId = "1-21"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "G2", UniqueId = "1-22"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "G3", UniqueId = "1-23"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "G4", UniqueId = "1-24"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "H1", UniqueId = "1-25"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "H2", UniqueId = "1-26"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "H3", UniqueId = "1-27"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "H4", UniqueId = "1-28"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "I1", UniqueId = "1-29"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "I2", UniqueId = "1-30"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "I3", UniqueId = "1-31"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "I4", UniqueId = "1-32"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "J1", UniqueId = "1-33"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "J2", UniqueId = "1-34"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "J3", UniqueId = "1-35"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "J4", UniqueId = "1-36"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "K1", UniqueId = "1-37"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "K2", UniqueId = "1-38"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "K3", UniqueId = "1-39"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "K4", UniqueId = "1-40"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "L1", UniqueId = "1-41"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "L2", UniqueId = "1-42"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "L3", UniqueId = "1-43"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "L4", UniqueId = "1-44"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "M1", UniqueId = "1-45"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "M2", UniqueId = "1-46"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "M3", UniqueId = "1-47"
},
new Seat {
SeatFormatId = 1, SeatClass = "Economy", SeatNumber = "M4", UniqueId = "1-48"
}
);
// create companies and bus types
context.Companies.AddOrUpdate(c => c.Name,
new Company {
Name = "Shohagh Paribahan"
},
new Company {
Name = "GreenLine Paribahan"
},
new Company {
Name = "Shyamoli Paribahan"
},
new Company {
Name = "Hanif Paribahan"
},
new Company {
Name = "Saudia S. Aalam"
});
context.BuseTypes.AddOrUpdate(b => b.Name,
new BusType {
Name = "Volvo 48 Seater", SeatFormatId = 1
},
new BusType {
Name = "AC 48 Seater", SeatFormatId = 1
},
new BusType {
Name = "Non-AC 48 Seater", SeatFormatId = 1
});
// create locations
context.Locations.AddOrUpdate(l => l.Name,
new Location {
Name = "Dhaka"
},
new Location {
Name = "Sylhet"
},
new Location {
Name = "Chittagong"
},
new Location {
Name = "Bandarban"
},
new Location {
Name = "Coxs Bazar"
},
new Location {
Name = "Rangamati"
},
new Location {
Name = "Khulna"
},
new Location {
Name = "Srimangal"
},
new Location {
Name = "Jessore"
},
new Location {
Name = "Rajshahi"
});
// create schedules
context.Schedules.AddOrUpdate(s => s.DepartureTime,
new Schedule
{
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed vitae consectetur ante. Aliquam hendrerit libero eros, sed condimentum ligula egestas et. Nam lacus neque, ornare.",
DepartureTime = DateTime.Parse("2014-06-23 08:00:00"),
JourneyFromId = 1,
JourneyToId = 2,
BusTypeId = 1,
CompanyId = 1
},
new Schedule
{
Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed vitae consectetur ante. Aliquam hendrerit libero eros, sed condimentum ligula egestas et. Nam lacus neque, ornare.",
DepartureTime = DateTime.Parse("2014-06-23 12:00:00"),
JourneyFromId = 1,
JourneyToId = 2,
BusTypeId = 1,
CompanyId = 2
});
}
