public static void Initialize(MaintenanceDbContext context)
{
context.Database.EnsureCreated();
//Look for any aircraft values to see if the DB successfully seeded
if (context.Aircrafts.Any())
{
return; // returning means DB successfully seeded
}
var aircraftModels = new AircraftModel[]
{
//new AircraftModel{ModelType="A-29", Manufacturer="Embraer", AircraftID=1},
//new AircraftModel{ModelType="C-146", Manufacturer="Fairchild Dornier", AircraftID=2},
//new AircraftModel{ModelType="C-146", Manufacturer="Fairchild Dornier", AircraftID=3},
//new AircraftModel{ModelType="A-29", Manufacturer="Embraer", AircraftID=4},
//new AircraftModel{ModelType="A-29", Manufacturer="Embraer", AircraftID=5}
new AircraftModel {
ModelType = "A-29", Manufacturer = "Embraer"
},
new AircraftModel {
ModelType = "C-146", Manufacturer = "Fairchild Dornier"
}
};
foreach (AircraftModel am in aircraftModels)
{
context.AircraftModels.Add(am);
}
context.SaveChanges();
var aircrafts = new Aircraft[]
{
new Aircraft {
FaaNumber = "0011001", EasaNumber = null, TailNumber = "1234567", AircraftModelID = 1
},
new Aircraft {
FaaNumber = "0011002", EasaNumber = null, TailNumber = "1234568", AircraftModelID = 1
},
new Aircraft {
FaaNumber = "0011003", EasaNumber = null, TailNumber = "1234569", AircraftModelID = 1
},
new Aircraft {
FaaNumber = "0011004", EasaNumber = null, TailNumber = "1234560", AircraftModelID = 2
},
new Aircraft {
FaaNumber = "0011005", EasaNumber = null, TailNumber = "1234561", AircraftModelID = 2
}
//new Aircraft{FaaNumber="0011001",EasaNumber=null,TailNumber="1234567"},
//new Aircraft{FaaNumber="0011002",EasaNumber=null,TailNumber="1234568"},
//new Aircraft{FaaNumber="0011003",EasaNumber=null,TailNumber="1234569"},
//new Aircraft{FaaNumber="0011004",EasaNumber=null,TailNumber="1234560"},
//new Aircraft{FaaNumber="0011005",EasaNumber=null,TailNumber="1234561"}
};
foreach (Aircraft a in aircrafts)
{
context.Aircrafts.Add(a);
}
context.SaveChanges();
var locations = new Location[]
{
new Location {
RegionCode = "DENV", RegionName = "West", LocationCode = "WWRM"
},
new Location {
RegionCode = "CALI", RegionName = "Pacific", LocationCode = "WWPO"
},
new Location {
RegionCode = "BOST", RegionName = "East", LocationCode = "ECCA"
},
new Location {
RegionCode = "FLAA", RegionName = "South East", LocationCode = "SESC"
},
new Location {
RegionCode = "TENN", RegionName = "Central", LocationCode = "CCAM"
}
};
foreach (Location l in locations)
{
context.Locations.Add(l);
}
context.SaveChanges();
var locationAssignments = new AircraftLocationAssignment[]
{
new AircraftLocationAssignment {
LocationID = 1, AircraftID = 1, Planned = true, Unplanned = false
},
new AircraftLocationAssignment {
LocationID = 1, AircraftID = 2, Planned = true, Unplanned = false
},
new AircraftLocationAssignment {
LocationID = 2, AircraftID = 3, Planned = true, Unplanned = false
},
new AircraftLocationAssignment {
LocationID = 3, AircraftID = 4, Planned = true, Unplanned = false
},
new AircraftLocationAssignment {
LocationID = 4, AircraftID = 5, Planned = false, Unplanned = true
}
};
foreach (AircraftLocationAssignment ala in locationAssignments)
{
context.AircraftLocationAssignments.Add(ala);
}
context.SaveChanges();
var titles = new Title[]
{
//new Title{EmployeeID=1, TitleName="Technician"},
//new Title{EmployeeID=2, TitleName="Quality Assure"},
//new Title{EmployeeID=3, TitleName="Technician"},
//new Title{EmployeeID=4, TitleName="Government Official"},
//new Title{EmployeeID=5, TitleName="Supervisor"}
new Title {
TitleName = "Technician"
},
new Title {
TitleName = "Quality Assure"
},
new Title {
TitleName = "Technician"
},
new Title {
TitleName = "Government Official"
},
new Title {
TitleName = "Supervisor"
}
};
foreach (Title t in titles)
{
context.Titles.Add(t);
}
context.SaveChanges();
var employees = new Employee[]
{
new Employee {
FirstName = "Bob", LastName = "Haskins", HireDate = DateTime.Parse("2018-10-01"), TitleID = 1
},
new Employee {
FirstName = "Claire", LastName = "Little", HireDate = DateTime.Parse("2010-06-05"), TitleID = 2
},
new Employee {
FirstName = "Tom", LastName = "Law", HireDate = DateTime.Parse("2015-12-11"), TitleID = 1
},
new Employee {
FirstName = "Jason", LastName = "Day", HireDate = DateTime.Parse("2011-03-25"), TitleID = 4
},
new Employee {
FirstName = "Kelly", LastName = "Wynn", HireDate = DateTime.Parse("2009-05-16"), TitleID = 5
}
};
foreach (Employee e in employees)
{
context.Employees.Add(e);
}
context.SaveChanges();
// adding ATA Chapters
var chapters = new AtaChapter[]
{
new AtaChapter {
ChapterNumber = 01, ChapterSummary = "Introduction / Aircraft General"
},
new AtaChapter {
ChapterNumber = 02, ChapterSummary = "Operations Information"
},
new AtaChapter {
ChapterNumber = 03, ChapterSummary = "Periodic Inspections"
},
new AtaChapter {
ChapterNumber = 04, ChapterSummary = "Dimensions and Areas"
},
new AtaChapter {
ChapterNumber = 05, ChapterSummary = "Lifting and Shoring"
},
new AtaChapter {
ChapterNumber = 06, ChapterSummary = "Leveling and Weighing"
},
new AtaChapter {
ChapterNumber = 07, ChapterSummary = "Towing and Taxiing"
},
new AtaChapter {
ChapterNumber = 08, ChapterSummary = "Parking, Mooring, Storage and Return to Service"
},
new AtaChapter {
ChapterNumber = 09, ChapterSummary = "Placards and Markings"
},
new AtaChapter {
ChapterNumber = 10, ChapterSummary = "Servicing Routine Maintenance"
},
new AtaChapter {
ChapterNumber = 11, ChapterSummary = "Vibration and Noise Analysis (Helicopters)"
}
};
foreach (AtaChapter ata in chapters)
{
context.AtaChapters.Add(ata);
}
context.SaveChanges();
// adding Significant Event
var events = new SignificantEvent[]
{
new SignificantEvent {
SignificantEventDescription = "Bird Strike"
},
new SignificantEvent {
SignificantEventDescription = "Hard Landing"
},
new SignificantEvent {
SignificantEventDescription = "Flap Over Speed"
},
new SignificantEvent {
SignificantEventDescription = "Gear Over Speed"
},
new SignificantEvent {
SignificantEventDescription = "Lightning Strike"
}
};
foreach (SignificantEvent se in events)
{
context.SignificantEvents.Add(se);
}
context.SaveChanges();
// adding Maintenance Type
var types = new MaintenanceType[]
{
new MaintenanceType {
MaintenanceTypeDescription = "Scheduled"
},
new MaintenanceType {
MaintenanceTypeDescription = "Unscheduled"
},
new MaintenanceType {
MaintenanceTypeDescription = "Major Mod or C-Check"
},
new MaintenanceType {
MaintenanceTypeDescription = "Pilot Writeup"
},
new MaintenanceType {
MaintenanceTypeDescription = "Customer Defered"
},
new MaintenanceType {
MaintenanceTypeDescription = "Grounding Writeup"
}
};
foreach (MaintenanceType mt in types)
{
context.MaintenanceTypes.Add(mt);
}
context.SaveChanges();
// adding Reference Group Data
//var references = new ReferenceGroup[]
//{
// new ReferenceGroup{ReferenceDocument1="0001-90235", ReferenceDocument2="0001-90236"},
// new ReferenceGroup{ReferenceDocument1="0001-90199", ReferenceDocument2="0001-90200"},
// new ReferenceGroup{ReferenceDocument1="0001-80236", ReferenceDocument2="0001-80005"},
// new ReferenceGroup{ReferenceDocument1="0021-70067", ReferenceDocument2="0021-70068"},
// new ReferenceGroup{ReferenceDocument1="0004-90250", ReferenceDocument2="0004-90250"},
//};
//foreach(ReferenceGroup rg in references)
//{
// context.ReferenceGroups.Add(rg);
//}
//context.SaveChanges();
var reports = new DiscrepancyReportC[]
{
new DiscrepancyReportC {
ReportRecord = "ABVD-0000001", AircraftID = 1, EmployeeID = 1, DateDiscovered = DateTime.Parse("2018-12-01"),
LocationID = 1, AtaChapterID = 1, AtaChapterEnd = "000_010", EngineStart = false, BeforeTakeoff = false,
OnTakeoffRoll = false, Climb = true, Cruise = true, Descent = true, Approach = false, Landing = false, Rollout = false,
Postflight = false, SignificantEventID = 1, MaintenanceTypeID = 2, MasterWarning = false, MasterCaution = true,
WarningMessage1 = null, WarningMessage2 = null, AdvisoryMessage1 = null, AdvisoryMessage2 = null, WarningMessageOther = null,
DiscrepancyDescription = "Bird struck the aircraft while in flight and changed the flight characteristics Aircraft must be grounded until fixed.",
AoG = true, Rii = false, WorkInstructionsPlannedAction = "Check the are where the bird struck the plane.",
CorrectiveActionDescription = "Found dent in a winglet from bird strike. New winglet installed and plane flight characteristics checked after fix",
OpsCheckRequired = false, LeakCheck = true, TechnicianName = "Bob Haskins", TechnicianDateSigned = DateTime.Parse("2018-12-01"),
QaName = "Claire Little", QaDateSigned = DateTime.Parse("2018-12-01"), GovernmentOfficial = "Steve Harmon",
GovOfficialDateSigned = DateTime.Parse("2018-12-01"), ReferenceDocument1 = "100_1", ReferenceDocument2 = "100_2",
CustomerName = "Jeff Ways", CustomerAcceptanceDate = DateTime.Parse("2018-12-03")
},
new DiscrepancyReportC {
ReportRecord = "ABVD-0000002", AircraftID = 2, EmployeeID = 3, DateDiscovered = DateTime.Parse("2018-12-03"),
LocationID = 2, AtaChapterID = 2, AtaChapterEnd = "-01-115", EngineStart = true, BeforeTakeoff = true,
OnTakeoffRoll = false, Climb = false, Cruise = false, Descent = false, Approach = false, Landing = false, Rollout = false,
Postflight = false, SignificantEventID = 2, MaintenanceTypeID = 2, MasterCaution = false, MasterWarning = false,
WarningMessage1 = "GEAR OVER SPEED", WarningMessage2 = "", AdvisoryMessage1 = "", AdvisoryMessage2 = "", WarningMessageOther = "",
DiscrepancyDescription = "On landing the gear was over stressed by the pilots speed so the gear assembly" +
"has to be looked at.", AoG = true, Rii = false, WorkInstructionsPlannedAction = "Check to see if anything has changed" +
"during the landing and the gear over speed", CorrectiveActionDescription = "The gear was deemed opperable" +
"and was cleared for flight", OpsCheckRequired = true, LeakCheck = false, TechnicianName = "Tom Law", TechnicianDateSigned = DateTime.Parse("2018-12-03"),
QaName = "Claire Little", QaDateSigned = DateTime.Parse("2018-12-03"), GovernmentOfficial = null,
ReferenceDocument1 = null, ReferenceDocument2 = null, CustomerName = "Jeff Ways", CustomerAcceptanceDate = DateTime.Parse("2018-12-06")
},
new DiscrepancyReportC {
ReportRecord = "ABVD-0000003", AircraftID = 3, EmployeeID = 1, DateDiscovered = DateTime.Parse("2018-12-05"),
LocationID = 3, AtaChapterID = 3, AtaChapterEnd = "-00-012", EngineStart = false, BeforeTakeoff = false,
OnTakeoffRoll = false, Climb = false, Cruise = false, Descent = false, Approach = false, Landing = false, Rollout = false,
Postflight = false, SignificantEventID = 3, MaintenanceTypeID = 1, MasterCaution = false, MasterWarning = false,
WarningMessage1 = "", WarningMessage2 = "", AdvisoryMessage1 = "", AdvisoryMessage2 = "", WarningMessageOther = "",
DiscrepancyDescription = "Routine oil change on the aircraft", AoG = true, Rii = false,
WorkInstructionsPlannedAction = "The oil on the plane needed to be changed after 10,000 flight hours",
CorrectiveActionDescription = "Change oil and check engine for proper function", OpsCheckRequired = false,
LeakCheck = true, TechnicianName = "Bob Haskins", TechnicianDateSigned = DateTime.Parse("2018-12-05"),
QaName = "Claire Little", QaDateSigned = DateTime.Parse("2018-12-05"), GovernmentOfficial = null, ReferenceDocument1 = "11-0005",
ReferenceDocument2 = null, CustomerName = "Jeff Ways", CustomerAcceptanceDate = DateTime.Parse("2018-12-08")
},
new DiscrepancyReportC {
ReportRecord = "ABVD-0000004", AircraftID = 4, EmployeeID = 3, DateDiscovered = DateTime.Parse("2018-12-08"),
LocationID = 4, AtaChapterID = 5, AtaChapterEnd = "-00-300", EngineStart = false, BeforeTakeoff = false,
OnTakeoffRoll = false, Climb = false, Cruise = false, Descent = false, Approach = false, Landing = false, Rollout = false,
Postflight = false, SignificantEventID = 3, MaintenanceTypeID = 1, MasterCaution = false, MasterWarning = false,
WarningMessage1 = "", WarningMessage2 = "", AdvisoryMessage1 = "", AdvisoryMessage2 = "", WarningMessageOther = "",
DiscrepancyDescription = "Placards are falling off must be replaced", AoG = true, Rii = false,
WorkInstructionsPlannedAction = "Fix the placards and make sure connection is tight",
CorrectiveActionDescription = "Placards fixed and secured tightly", OpsCheckRequired = false,
LeakCheck = true, TechnicianName = "Tom Law", TechnicianDateSigned = DateTime.Parse("2018-12-08"),
QaName = "Claire Little", QaDateSigned = DateTime.Parse("2018-12-08"), GovernmentOfficial = null, ReferenceDocument1 = null,
ReferenceDocument2 = null, CustomerName = "Jeff Ways", CustomerAcceptanceDate = DateTime.Parse("2018-12-08")
},
new DiscrepancyReportC {
ReportRecord = "ABVD-0000005", AircraftID = 5, EmployeeID = 1, DateDiscovered = DateTime.Parse("2018-12-09"),
LocationID = 5, AtaChapterID = 7, AtaChapterEnd = "-00-301", EngineStart = false, BeforeTakeoff = false,
OnTakeoffRoll = false, Climb = false, Cruise = false, Descent = false, Approach = false, Landing = false, Rollout = false,
Postflight = false, SignificantEventID = 5, MaintenanceTypeID = 1, MasterCaution = false, MasterWarning = false,
WarningMessage1 = "", WarningMessage2 = "", AdvisoryMessage1 = "", AdvisoryMessage2 = "", WarningMessageOther = "",
DiscrepancyDescription = "Aircraft is undergoing a full inspection. This is a scheduled event.", AoG = true, Rii = false,
WorkInstructionsPlannedAction = "The aircraft and it's system will undergo full system inspection",
CorrectiveActionDescription = "Aircraft inspected and deemed flight worthy. Everything operational",
OpsCheckRequired = true, LeakCheck = true, TechnicianName = "Bob Haskins", TechnicianDateSigned = DateTime.Parse("2018-12-09"),
QaName = "Claire Little", QaDateSigned = DateTime.Parse("2018-12-09"), GovernmentOfficial = null, ReferenceDocument1 = null,
ReferenceDocument2 = null, CustomerName = "Jeff Ways", CustomerAcceptanceDate = DateTime.Parse("2018-12-11")
}
};
foreach (DiscrepancyReportC dr in reports)
{
context.DiscrepancyReportCs.Add(dr);
}
context.SaveChanges();
// seeding the removal installation form data
var forms = new RemovalInstallationForm[]
{
new RemovalInstallationForm {
DiscrepancyReportCID = 1, DateFormCreated = DateTime.Parse("2018-12-01"), EmployeeID = 1, RemovedPartNumber1 = "PN1234", RemovedPartSerialNumber1 = "SN1234", NomenclaturePart1 = "Nom1",
RemovedPartNumber2 = "PN1235", RemovedPartSerialNumber2 = "SN1235", NomenclaturePart2 = "Nom2", RemovedPartNumber3 = null, RemovedPartSerialNumber3 = null, NomenclaturePart3 = null,
RemovedPartNumber4 = null, RemovedPartSerialNumber4 = null, NomenclaturePart4 = null, InstalledPartNumber1 = "PN0987", InstalledPartSerialNumber1 = "SN0987",
InstalledPartNumber2 = "SN0986", InstalledPartSerialNumber2 = "SN0986", InstalledPartNumber3 = null, InstalledPartSerialNumber3 = null,
InstalledPartNumber4 = null, InstalledPartSerialNumber4 = null, CorrectedBy = "Bob Haskins", DateCorrected = DateTime.Parse("2018-12-01"), InspectedBy = null, DateInspected = null,
FiledBy = null, DateFiled = null
},
new RemovalInstallationForm {
DiscrepancyReportCID = 2, DateFormCreated = DateTime.Parse("2018-12-03"), EmployeeID = 3, RemovedPartNumber1 = "PN1123", RemovedPartSerialNumber1 = "SN1123", NomenclaturePart1 = "Nom1",
RemovedPartNumber2 = "PN1135", RemovedPartSerialNumber2 = "SN1135", NomenclaturePart2 = "Nom2", RemovedPartNumber3 = "PN1126", RemovedPartSerialNumber3 = "SN1126", NomenclaturePart3 = "Nom3",
RemovedPartNumber4 = null, RemovedPartSerialNumber4 = null, NomenclaturePart4 = null, InstalledPartNumber1 = "PN1987", InstalledPartSerialNumber1 = "SN1987",
InstalledPartNumber2 = null, InstalledPartSerialNumber2 = null, InstalledPartNumber3 = null, InstalledPartSerialNumber3 = null,
InstalledPartNumber4 = null, InstalledPartSerialNumber4 = null, CorrectedBy = "Tom Law", DateCorrected = DateTime.Parse("2018-12-03"), InspectedBy = "Claire Little", DateInspected = DateTime.Parse("2018-12-03"),
FiledBy = null, DateFiled = null
},
new RemovalInstallationForm {
DiscrepancyReportCID = 3, DateFormCreated = DateTime.Parse("2018-12-05"), EmployeeID = 1, RemovedPartNumber1 = "PN1114", RemovedPartSerialNumber1 = "SN1114", NomenclaturePart1 = "Nom1",
RemovedPartNumber2 = "PN1115", RemovedPartSerialNumber2 = "SN1115", NomenclaturePart2 = "Nom2", RemovedPartNumber3 = null, RemovedPartSerialNumber3 = null, NomenclaturePart3 = null,
RemovedPartNumber4 = null, RemovedPartSerialNumber4 = null, NomenclaturePart4 = null, InstalledPartNumber1 = "PN0987", InstalledPartSerialNumber1 = "SN0987",
InstalledPartNumber2 = "SN2986", InstalledPartSerialNumber2 = "SN2986", InstalledPartNumber3 = "PN2987", InstalledPartSerialNumber3 = "SN2987",
InstalledPartNumber4 = "PN2988", InstalledPartSerialNumber4 = "SN2988", CorrectedBy = "Bob Haskins", DateCorrected = DateTime.Parse("2018-12-05"), InspectedBy = "Claire Little", DateInspected = DateTime.Parse("2018-12-05"),
FiledBy = "Sarah Homes", DateFiled = DateTime.Parse("2018-12-05")
},
new RemovalInstallationForm {
DiscrepancyReportCID = 4, DateFormCreated = DateTime.Parse("2018-12-08"), EmployeeID = 3, RemovedPartNumber1 = "PN1111", RemovedPartSerialNumber1 = "SN1111", NomenclaturePart1 = "Nom1",
RemovedPartNumber2 = "PN1112", RemovedPartSerialNumber2 = "SN1112", NomenclaturePart2 = "Nom2", RemovedPartNumber3 = null, RemovedPartSerialNumber3 = null, NomenclaturePart3 = null,
RemovedPartNumber4 = null, RemovedPartSerialNumber4 = null, NomenclaturePart4 = null, InstalledPartNumber1 = "PN0984", InstalledPartSerialNumber1 = "SN0984",
InstalledPartNumber2 = "SN0983", InstalledPartSerialNumber2 = "SN0983", InstalledPartNumber3 = null, InstalledPartSerialNumber3 = null,
InstalledPartNumber4 = null, InstalledPartSerialNumber4 = null, CorrectedBy = "Tom Law", DateCorrected = DateTime.Parse("2018-12-08"), InspectedBy = null, DateInspected = null,
FiledBy = null, DateFiled = null
},
new RemovalInstallationForm {
DiscrepancyReportCID = 1, DateFormCreated = DateTime.Parse("2018-12-09"), EmployeeID = 1, RemovedPartNumber1 = "PN1234", RemovedPartSerialNumber1 = "SN1234", NomenclaturePart1 = "Nom1",
RemovedPartNumber2 = "PN1222", RemovedPartSerialNumber2 = "SN1222", NomenclaturePart2 = "Nom2", RemovedPartNumber3 = null, RemovedPartSerialNumber3 = null, NomenclaturePart3 = null,
RemovedPartNumber4 = null, RemovedPartSerialNumber4 = null, NomenclaturePart4 = null, InstalledPartNumber1 = "PN0087", InstalledPartSerialNumber1 = "SN0087",
InstalledPartNumber2 = "SN0086", InstalledPartSerialNumber2 = "SN0086", InstalledPartNumber3 = null, InstalledPartSerialNumber3 = null,
InstalledPartNumber4 = null, InstalledPartSerialNumber4 = null, CorrectedBy = "Bob Haskins", DateCorrected = DateTime.Parse("2018-12-09"), InspectedBy = null, DateInspected = null,
FiledBy = null, DateFiled = null
}
};
foreach (RemovalInstallationForm rif in forms)
{
context.RemovalInstallationForms.Add(rif);
}
context.SaveChanges();
// seeding the order status data
var statuses = new OrderStatus[]
{
new OrderStatus {
StatusDescription = "New"
},
new OrderStatus {
StatusDescription = "Processing"
},
new OrderStatus {
StatusDescription = "Closed/Shipped"
},
new OrderStatus {
StatusDescription = "Dead"
},
new OrderStatus {
StatusDescription = "Drop Shipped"
}
};
foreach (OrderStatus os in statuses)
{
context.OrderStatuses.Add(os);
}
context.SaveChangesAsync();
// seeding tag color data
var colors = new TagColor[]
{
new TagColor {
ColorOfTag = "Green"
},
new TagColor {
ColorOfTag = "Red"
},
new TagColor {
ColorOfTag = "Yellow"
},
new TagColor {
ColorOfTag = "Blue"
},
new TagColor {
ColorOfTag = "Orange"
}
};
foreach (TagColor tg in colors)
{
context.TagColors.Add(tg);
}
context.SaveChangesAsync();
// seeding Category data
var categories = new PartCategory[]
{
new PartCategory {
CategoryName = "Wings"
},
new PartCategory {
CategoryName = "Engines"
},
new PartCategory {
CategoryName = "Landing Gear"
},
new PartCategory {
CategoryName = "Fuselage"
},
new PartCategory {
CategoryName = "Cargo Bay"
}
};
foreach (PartCategory pc in categories)
{
context.PartCategories.Add(pc);
}
context.SaveChangesAsync();
// seeding Subcategory data
var subcategories = new PartSubCategory[]
{
new PartSubCategory {
SubCategoryName = "Boeing"
},
new PartSubCategory {
SubCategoryName = "GE"
},
new PartSubCategory {
SubCategoryName = "AeroShell"
},
new PartSubCategory {
SubCategoryName = "Dunlop Aviation"
},
new PartSubCategory {
SubCategoryName = "HB Fuller"
},
new PartSubCategory {
SubCategoryName = "L3"
},
new PartSubCategory {
SubCategoryName = "Rieker Instruments"
},
new PartSubCategory {
SubCategoryName = "UTC Aerospace Systems"
}
};
foreach (PartSubCategory psc in subcategories)
{
context.PartSubCategories.Add(psc);
}
context.SaveChangesAsync();
// seeding the NEW Order Form Data
var orders = new NewOrderForm[]
{
new NewOrderForm {
DateOrderCreated = DateTime.Parse("2018-12-01"), Edd = DateTime.Parse("2018-12-15"),
EmployeeID = employees.Single(e => e.FirstName == "Bob").ID,
OrderNumber = "XVY-1234",
OrderStatusID = statuses.Single(s => s.StatusDescription == "New").ID,
PartCategoryID = categories.Single(c => c.CategoryName == "Wings").ID,
PartDocumentNumber = "AV-0101",
PartName = "Winglet", PartQuantity = 1,
PartSubCategoryID = subcategories.Single(ps => ps.SubCategoryName == "Boeing").ID,
TrackingNumber = "AB1452-HJB0098", Ui = "Nom"
}
};
foreach (NewOrderForm o in orders)
{
context.NewOrderForms.Add(o);
}
context.SaveChangesAsync();
}
