public static void Initialize(ParaglidingClubContext context)
{
context.Database.EnsureCreated();
if (context.Pilots.Any())
{
return;
}
var pilots = new Pilot[]
{
new Pilot {
FirstName = "Tony", LastName = "Stark", Adress = "39 Cliffbide Drive Malibu, CA 56677", PhoneNumber = "0488971525", Weight = 78, Role = Role.Président
},
new Pilot {
FirstName = "Steve", LastName = "Rogers", Adress = "1404 Alameda Ave Brooklyn, NY 11365", PhoneNumber = "0456321598", Weight = 99, Role = Role.Secrétaire
},
new Pilot {
FirstName = "Clint", LastName = "Barton", Adress = "244 Ramblewood St. San Angelo, TX 76904", PhoneNumber = "0423165878", Weight = 80, Role = Role.Trésorier
},
new Pilot {
FirstName = "Bruce", LastName = "Banner", Adress = "273 South St Louis Lane New York, NY 10034", PhoneNumber = "04598617", Weight = 79
},
new Pilot {
FirstName = "Natacha", LastName = "Romanov", Adress = "70 Arnold St. Los Angeles, CA 90042", PhoneNumber = "04598617", Weight = 55
},
};
foreach (Pilot p in pilots)
{
context.Pilots.Add(p);
}
context.SaveChanges();
var models = new ModelParagliding[]
{
new ModelParagliding {
HeightParagliding = "25m²", MaxWeightPilot = 90, MinWeightPilot = 40, AprovalDate = DateTime.Parse("2015-03-15"), AprovalNumber = "152689"
},
new ModelParagliding {
HeightParagliding = "26m²", MaxWeightPilot = 100, MinWeightPilot = 45, AprovalDate = DateTime.Parse("2012-07-28"), AprovalNumber = "256986"
},
new ModelParagliding {
HeightParagliding = "28m²", MaxWeightPilot = 120, MinWeightPilot = 60, AprovalDate = DateTime.Parse("2017-01-04"), AprovalNumber = "362514"
},
};
foreach (ModelParagliding m in models)
{
context.ModelParaglidings.Add(m);
}
context.SaveChanges();
var licenses = new License[]
{
new License {
Title = "Pilote de parapente"
},
new License {
Title = "Pilote XC de parapente"
},
new License {
Title = "Moniteur de parapente"
},
new License {
Title = "Pilote au treuil de parapente"
},
new License {
Title = "Examinateur de parapente"
}
};
foreach (License l in licenses)
{
context.Licenses.Add(l);
}
context.SaveChanges();
var courses = new Course[]
{
new Course {
StartDate = DateTime.Parse("2018-04-29"), EndDate = DateTime.Parse("2018-05-30")
},
new Course {
StartDate = DateTime.Parse("2018-06-18"), EndDate = DateTime.Parse("2018-07-10")
},
new Course {
StartDate = DateTime.Parse("2018-09-15"), EndDate = DateTime.Parse("2018-11-12")
},
new Course {
StartDate = DateTime.Parse("2019-01-15"), EndDate = DateTime.Parse("2019-03-20")
},
new Course {
StartDate = DateTime.Parse("2019-05-25"), EndDate = DateTime.Parse("2019-07-19")
},
new Course {
StartDate = DateTime.Parse("2019-10-02"), EndDate = DateTime.Parse("2019-12-23")
}
};
foreach (Course c in courses)
{
context.Courses.Add(c);
}
context.SaveChanges();
}
public static void Initialize(ParaglidingClubContext context)
{
context.Database.EnsureCreated();
#region Pilots
if (context.Pilots.Any())
{
return;
}
var pilots = new Pilot[]
{
new Pilot {
FirstName = "Tony", LastName = "Stark", Adress = "39 Cliffbide Drive Malibu, CA 56677", PhoneNumber = "0488971525", Weight = 78, IsActif = true, PostitionID = 1
},
new Pilot {
FirstName = "Steve", LastName = "Rogers", Adress = "1404 Alameda Ave Brooklyn, NY 11365", PhoneNumber = "0456321598", Weight = 99, IsActif = true, PostitionID = 2
},
new Pilot {
FirstName = "Clint", LastName = "Barton", Adress = "244 Ramblewood St. San Angelo, TX 76904", PhoneNumber = "0423165878", Weight = 80, IsActif = true, PostitionID = 3
},
new Pilot {
FirstName = "Bruce", LastName = "Banner", Adress = "273 South St Louis Lane New York, NY 10034", PhoneNumber = "04598617", Weight = 79, IsActif = true
},
new Pilot {
FirstName = "Natacha", LastName = "Romanov", Adress = "70 Arnold St. Los Angeles, CA 90042", PhoneNumber = "04598617", Weight = 55, IsActif = true
},
};
foreach (Pilot p in pilots)
{
context.Pilots.Add(p);
}
context.SaveChanges();
#endregion
#region Flights
if (context.Flights.Any())
{
return;
}
var flights = new Flight[]
{
new Flight {
PilotID = 1, ParaglidingID = 2, FlightDate = DateTime.Parse("2018-04-18"), FlightStart = DateTime.Parse("2018-04-18 01:04:16"), FlightEnd = DateTime.Parse("2018-04-18 01:09:55"), SiteID = 2
},
new Flight {
PilotID = 1, ParaglidingID = 1, FlightDate = DateTime.Parse("2018-07-12"), FlightStart = DateTime.Parse("2018-07-12 01:04:16"), FlightEnd = DateTime.Parse("2018-07-12 01:09:55"), SiteID = 1
},
new Flight {
PilotID = 1, ParaglidingID = 2, FlightDate = DateTime.Parse("2019-04-04"), FlightStart = DateTime.Parse("2019-04-04 01:04:16"), FlightEnd = DateTime.Parse("2019-04-04 01:09:55"), SiteID = 1
},
new Flight {
PilotID = 1, ParaglidingID = 2, FlightDate = DateTime.Parse("2019-07-21"), FlightStart = DateTime.Parse("2019-07-21 01:04:16"), FlightEnd = DateTime.Parse("2019-07-21 01:09:55"), SiteID = 3
},
new Flight {
PilotID = 2, ParaglidingID = 5, FlightDate = DateTime.Parse("2018-01-21"), FlightStart = DateTime.Parse("2018-01-21 02:10:14"), FlightEnd = DateTime.Parse("2019-07-21 02:14:45"), SiteID = 1
},
new Flight {
PilotID = 2, ParaglidingID = 5, FlightDate = DateTime.Parse("2019-04-21"), FlightStart = DateTime.Parse("2019-04-21 02:10:14"), FlightEnd = DateTime.Parse("2019-04-21 02:14:45"), SiteID = 1
},
new Flight {
PilotID = 2, ParaglidingID = 5, FlightDate = DateTime.Parse("2018-08-21"), FlightStart = DateTime.Parse("2019-08-21 02:10:14"), FlightEnd = DateTime.Parse("2019-08-21 02:14:45"), SiteID = 1
},
new Flight {
PilotID = 2, ParaglidingID = 5, FlightDate = DateTime.Parse("2019-09-21"), FlightStart = DateTime.Parse("2019-09-21 02:10:14"), FlightEnd = DateTime.Parse("2019-09-21 02:14:45"), SiteID = 1
},
new Flight {
PilotID = 3, ParaglidingID = 2, FlightDate = DateTime.Parse("2018-04-18"), FlightStart = DateTime.Parse("2018-04-18 03:04:16"), FlightEnd = DateTime.Parse("2018-04-18 03:09:55"), SiteID = 3
},
new Flight {
PilotID = 3, ParaglidingID = 2, FlightDate = DateTime.Parse("2018-07-12"), FlightStart = DateTime.Parse("2018-07-12 03:04:16"), FlightEnd = DateTime.Parse("2018-07-12 03:09:55"), SiteID = 2
},
new Flight {
PilotID = 3, ParaglidingID = 3, FlightDate = DateTime.Parse("2019-04-04"), FlightStart = DateTime.Parse("2019-04-04 03:04:16"), FlightEnd = DateTime.Parse("2019-04-04 03:09:55"), SiteID = 1
},
new Flight {
PilotID = 3, ParaglidingID = 2, FlightDate = DateTime.Parse("2019-07-21"), FlightStart = DateTime.Parse("2019-07-21 03:04:16"), FlightEnd = DateTime.Parse("2019-07-21 03:09:55"), SiteID = 3
},
new Flight {
PilotID = 4, ParaglidingID = 4, FlightDate = DateTime.Parse("2018-04-18"), FlightStart = DateTime.Parse("2018-04-18 05:04:16"), FlightEnd = DateTime.Parse("2018-04-18 05:09:55"), SiteID = 3
},
new Flight {
PilotID = 4, ParaglidingID = 2, FlightDate = DateTime.Parse("2018-07-12"), FlightStart = DateTime.Parse("2018-07-12 05:04:16"), FlightEnd = DateTime.Parse("2018-07-12 05:09:55"), SiteID = 1
},
new Flight {
PilotID = 4, ParaglidingID = 1, FlightDate = DateTime.Parse("2019-04-04"), FlightStart = DateTime.Parse("2019-04-04 05:04:16"), FlightEnd = DateTime.Parse("2019-04-04 05:09:55"), SiteID = 1
},
new Flight {
PilotID = 4, ParaglidingID = 2, FlightDate = DateTime.Parse("2019-07-21"), FlightStart = DateTime.Parse("2019-07-21 05:04:16"), FlightEnd = DateTime.Parse("2019-07-21 05:09:55"), SiteID = 3
},
new Flight {
PilotID = 5, ParaglidingID = 1, FlightDate = DateTime.Parse("2018-04-18"), FlightStart = DateTime.Parse("2018-04-18 08:04:16"), FlightEnd = DateTime.Parse("2018-04-18 08:09:55"), SiteID = 1
},
new Flight {
PilotID = 5, ParaglidingID = 2, FlightDate = DateTime.Parse("2018-07-12"), FlightStart = DateTime.Parse("2018-07-12 08:04:16"), FlightEnd = DateTime.Parse("2018-07-12 08:09:55"), SiteID = 1
},
new Flight {
PilotID = 5, ParaglidingID = 1, FlightDate = DateTime.Parse("2019-04-04"), FlightStart = DateTime.Parse("2019-04-04 08:04:16"), FlightEnd = DateTime.Parse("2019-04-04 08:09:55"), SiteID = 1
},
new Flight {
PilotID = 5, ParaglidingID = 2, FlightDate = DateTime.Parse("2019-07-21"), FlightStart = DateTime.Parse("2019-07-21 08:04:16"), FlightEnd = DateTime.Parse("2019-07-21 08:09:55"), SiteID = 1
}
};
foreach (Flight f in flights)
{
context.Flights.Add(f);
}
context.SaveChanges();
#endregion
#region Paraglidings
if (context.Paraglidings.Any())
{
return;
}
var paraglidings = new Paragliding[]
{
new Paragliding {
ModelParaglidingID = 1, DateOfCommissioning = DateTime.Parse("2015-07-02"), DateOfLastRevision = DateTime.Parse("2019-12-09")
},
new Paragliding {
ModelParaglidingID = 1, DateOfCommissioning = DateTime.Parse("2016-01-28"), DateOfLastRevision = DateTime.Parse("2019-11-04")
},
new Paragliding {
ModelParaglidingID = 2, DateOfCommissioning = DateTime.Parse("2014-02-12"), DateOfLastRevision = DateTime.Parse("2020-01-10")
},
new Paragliding {
ModelParaglidingID = 2, DateOfCommissioning = DateTime.Parse("2013-08-03"), DateOfLastRevision = DateTime.Parse("2019-09-18")
},
new Paragliding {
ModelParaglidingID = 3, DateOfCommissioning = DateTime.Parse("2017-04-22"), DateOfLastRevision = DateTime.Parse("2019-11-25")
},
};
foreach (Paragliding p in paraglidings)
{
context.Paraglidings.Add(p);
}
context.SaveChanges();
#endregion
#region ModelParaglidings
if (context.ModelParaglidings.Any())
{
return;
}
var models = new ModelParagliding[]
{
new ModelParagliding {
HeightParagliding = "25m²", MaxWeightPilot = 90, MinWeightPilot = 40, AprovalDate = DateTime.Parse("2015-03-15"), AprovalNumber = "152689"
},
new ModelParagliding {
HeightParagliding = "26m²", MaxWeightPilot = 100, MinWeightPilot = 45, AprovalDate = DateTime.Parse("2012-07-28"), AprovalNumber = "256986"
},
new ModelParagliding {
HeightParagliding = "28m²", MaxWeightPilot = 120, MinWeightPilot = 60, AprovalDate = DateTime.Parse("2017-01-04"), AprovalNumber = "362514"
},
};
foreach (ModelParagliding m in models)
{
context.ModelParaglidings.Add(m);
}
context.SaveChanges();
#endregion
#region Licenses
if (context.Licenses.Any())
{
return;
}
var licenses = new License[]
{
new License {
Title = "Pilote de parapente", LevelID = 1
},
new License {
Title = "Pilote XC de parapente", LevelID = 2
},
new License {
Title = "Moniteur de parapente", LevelID = 3
},
new License {
Title = "Pilote au treuil de parapente", LevelID = 4
},
new License {
Title = "Examinateur de parapente", LevelID = 5
}
};
foreach (License l in licenses)
{
context.Licenses.Add(l);
}
context.SaveChanges();
#endregion
#region Courses
if (context.Courses.Any())
{
return;
}
var courses = new Course[]
{
new Course {
StartDate = DateTime.Parse("2018-04-29"), EndDate = DateTime.Parse("2018-05-30"), CoursePrice = 70.00M, LicenseID = 1
},
new Course {
StartDate = DateTime.Parse("2018-06-18"), EndDate = DateTime.Parse("2018-07-10"), CoursePrice = 30.50M, LicenseID = 3
},
new Course {
StartDate = DateTime.Parse("2018-09-15"), EndDate = DateTime.Parse("2018-11-12"), CoursePrice = 46.00M, LicenseID = 2
},
new Course {
StartDate = DateTime.Parse("2019-01-15"), EndDate = DateTime.Parse("2019-03-20"), CoursePrice = 60.00M, LicenseID = 4
},
new Course {
StartDate = DateTime.Parse("2019-05-25"), EndDate = DateTime.Parse("2019-07-19"), CoursePrice = 35.80M, LicenseID = 5
},
new Course {
StartDate = DateTime.Parse("2019-10-02"), EndDate = DateTime.Parse("2019-12-23"), CoursePrice = 30.50M, LicenseID = 3
}
};
foreach (Course c in courses)
{
context.Courses.Add(c);
}
context.SaveChanges();
#endregion
#region Levels
if (context.Levels.Any())
{
return;
}
var levels = new Level[]
{
new Level {
Name = "Colibri", Skill = "Savoir decoller, savoir atterrir", DifficultyNumber = 1
},
new Level {
Name = "Mouette", Skill = "Bonne maitrise du parapente, savoir évaluer les conditions météo", DifficultyNumber = 2
},
new Level {
Name = "Aigle de bronze", Skill = "Savoir enseigner aux aspirants pilotes, savoir voler avec treuil, très bonne maitrise", DifficultyNumber = 3
},
new Level {
Name = "Aigle d'argent", Skill = "Maitrise totale du parapente à tous temps", DifficultyNumber = 4
},
new Level {
Name = "Aigle d'or", Skill = "Savoir évaluer les aspirants pilotes et les moniteurs", DifficultyNumber = 5
},
};
foreach (Level l in levels)
{
context.Levels.Add(l);
}
context.SaveChanges();
#endregion
#region Sites
if (context.Sites.Any())
{
return;
}
var sites = new Site[]
{
new Site {
Name = "Boom", FlightType = "Thermodynamiques", OrientationLanding = "Est", AltitudeTakeOff = 25, OrientationTakeOff = "Sud", LevelID = 1
},
new Site {
Name = "Ouren", FlightType = "Thermodynamiques", OrientationLanding = "Nord", OrientationTakeOff = "Ouest", LevelID = 3
},
new Site {
Name = "Hornu", FlightType = "Termodynamiques", OrientationLanding = "Sud", OrientationTakeOff = "Est", LevelID = 2
},
};
foreach (Site s in sites)
{
context.Sites.Add(s);
}
context.SaveChanges();
#endregion
#region Subscriptions
if (context.Subscriptions.Any())
{
return;
}
var subscriptions = new Subscription[]
{
new Subscription {
YearID = 2017, Price = 20.00M
},
new Subscription {
YearID = 2018, Price = 25.00M
},
new Subscription {
YearID = 2019, Price = 15.50M
},
new Subscription {
YearID = 2020, Price = 19.50M
},
};
foreach (Subscription s in subscriptions)
{
context.Subscriptions.Add(s);
}
context.SaveChanges();
#endregion
#region Payments
if (context.Payments.Any())
{
return;
}
var payments = new Payment[]
{
new Payment {
SubsciptionID = 1, PilotID = 1, IsPay = true, DatePay = DateTime.Parse("2017-04-02")
},
new Payment {
SubsciptionID = 2, PilotID = 1, IsPay = true, DatePay = DateTime.Parse("2018-04-02")
},
new Payment {
SubsciptionID = 3, PilotID = 1, IsPay = true, DatePay = DateTime.Parse("2019-04-02")
},
new Payment {
SubsciptionID = 4, PilotID = 1, IsPay = true, DatePay = DateTime.Parse("2020-01-02")
},
new Payment {
SubsciptionID = 1, PilotID = 2, IsPay = true, DatePay = DateTime.Parse("2017-03-15")
},
new Payment {
SubsciptionID = 2, PilotID = 2, IsPay = true, DatePay = DateTime.Parse("2018-06-02")
},
new Payment {
SubsciptionID = 3, PilotID = 2, IsPay = true, DatePay = DateTime.Parse("2019-03-12")
},
new Payment {
SubsciptionID = 4, PilotID = 2, IsPay = false
},
new Payment {
SubsciptionID = 2, PilotID = 3, IsPay = true, DatePay = DateTime.Parse("2018-02-02")
},
new Payment {
SubsciptionID = 3, PilotID = 3, IsPay = true, DatePay = DateTime.Parse("2019-01-22")
},
new Payment {
SubsciptionID = 4, PilotID = 3, IsPay = true, DatePay = DateTime.Parse("2020-01-25")
},
new Payment {
SubsciptionID = 1, PilotID = 4, IsPay = true, DatePay = DateTime.Parse("2017-04-12")
},
new Payment {
SubsciptionID = 2, PilotID = 4, IsPay = true, DatePay = DateTime.Parse("2018-02-25")
},
new Payment {
SubsciptionID = 3, PilotID = 4, IsPay = true, DatePay = DateTime.Parse("2019-01-14")
},
new Payment {
SubsciptionID = 4, PilotID = 4, IsPay = true, DatePay = DateTime.Parse("2020-01-19")
},
new Payment {
SubsciptionID = 1, PilotID = 5, IsPay = true, DatePay = DateTime.Parse("2017-01-23")
},
new Payment {
SubsciptionID = 2, PilotID = 5, IsPay = true, DatePay = DateTime.Parse("2018-04-02")
},
new Payment {
SubsciptionID = 3, PilotID = 5, IsPay = true, DatePay = DateTime.Parse("2019-04-28")
},
new Payment {
SubsciptionID = 3, PilotID = 5, IsPay = false
},
};
foreach (Payment p in payments)
{
context.Payments.Add(p);
}
context.SaveChanges();
#endregion
#region Obtainings
if (context.Obtainings.Any())
{
return;
}
var obtainings = new Obtaining[]
{
new Obtaining {
PilotID = 1, LicenseID = 5, IsSucced = true, ObtainingDate = DateTime.Parse("2019-07-19")
},
new Obtaining {
PilotID = 2, LicenseID = 1, IsSucced = true, ObtainingDate = DateTime.Parse("2018-05-30")
},
new Obtaining {
PilotID = 3, LicenseID = 3, IsSucced = true, ObtainingDate = DateTime.Parse("2018-07-10")
},
new Obtaining {
PilotID = 3, LicenseID = 4, IsSucced = false
},
new Obtaining {
PilotID = 4, LicenseID = 1, IsSucced = true, ObtainingDate = DateTime.Parse("2018-05-30")
},
new Obtaining {
PilotID = 4, LicenseID = 2, IsSucced = true, ObtainingDate = DateTime.Parse("2018-11-12")
},
new Obtaining {
PilotID = 5, LicenseID = 1, IsSucced = true, ObtainingDate = DateTime.Parse("2018-05-30")
},
new Obtaining {
PilotID = 5, LicenseID = 2, IsSucced = true, ObtainingDate = DateTime.Parse("2018-11-12")
},
new Obtaining {
PilotID = 5, LicenseID = 3, IsSucced = true, ObtainingDate = DateTime.Parse("2019-12-23")
},
};
foreach (Obtaining o in obtainings)
{
context.Obtainings.Add(o);
}
context.SaveChanges();
#endregion
#region Teachings
if (context.Teachings.Any())
{
return;
}
var teachings = new Teaching[]
{
new Teaching {
PilotID = 1, CourseID = 1
},
new Teaching {
PilotID = 1, CourseID = 2
},
new Teaching {
PilotID = 1, CourseID = 3
},
new Teaching {
PilotID = 1, CourseID = 4
},
new Teaching {
PilotID = 1, CourseID = 6
},
new Teaching {
PilotID = 3, CourseID = 3
},
new Teaching {
PilotID = 3, CourseID = 6
},
};
foreach (Teaching t in teachings)
{
context.Teachings.Add(t);
}
context.SaveChanges();
#endregion
#region Participations
if (context.Participations.Any())
{
return;
}
var participations = new Participation[]
{
new Participation {
CourseID = 1, PilotID = 2, DateOfParticipation = DateTime.Parse("2018-04-02"), IsPay = true
},
new Participation {
CourseID = 1, PilotID = 4, DateOfParticipation = DateTime.Parse("2018-04-02"), IsPay = true
},
new Participation {
CourseID = 1, PilotID = 5, DateOfParticipation = DateTime.Parse("2018-04-03"), IsPay = true
},
new Participation {
CourseID = 2, PilotID = 3, DateOfParticipation = DateTime.Parse("2018-05-25"), IsPay = true
},
new Participation {
CourseID = 3, PilotID = 4, DateOfParticipation = DateTime.Parse("2018-08-30"), IsPay = true
},
new Participation {
CourseID = 3, PilotID = 5, DateOfParticipation = DateTime.Parse("2018-09-02"), IsPay = true
},
new Participation {
CourseID = 4, PilotID = 3, DateOfParticipation = DateTime.Parse("2019-01-03"), IsPay = true
},
new Participation {
CourseID = 5, PilotID = 1, DateOfParticipation = DateTime.Parse("2019-05-02"), IsPay = true
},
new Participation {
CourseID = 6, PilotID = 5, DateOfParticipation = DateTime.Parse("2019-09-19"), IsPay = true
},
};
foreach (Participation p in participations)
{
context.Participations.Add(p);
}
context.SaveChanges();
#endregion
#region Positions
if (context.Positions.Any())
{
return;
}
var positions = new Position[]
{
new Position {
Name = "Président", PilotID = 1
},
new Position {
Name = "Secrétaire", PilotID = 2
},
new Position {
Name = "Trésorier", PilotID = 3
},
};
foreach (Position p in positions)
{
context.Positions.Add(p);
}
context.SaveChanges();
#endregion
}