1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
|
// Copyright (c) Microsoft Open Technologies, Inc. All rights reserved. See License.txt in the project root for license information.
namespace AdvancedPatternsModel
{
using System;
using System.Collections.Generic;
using System.Data.Entity;
public class AdvancedPatternsInitializer : DropCreateDatabaseIfModelChanges<AdvancedPatternsMasterContext>
{
protected override void Seed(AdvancedPatternsMasterContext context)
{
var buildings = new List<Building>
{
new Building
{
BuildingId = new Guid("21EC2020-3AEA-1069-A2DD-08002B30309D"),
Name = "Building One",
Value = 1500000m,
Address = new Address
{
Street = "100 Work St",
City = "Redmond",
State = "WA",
ZipCode = "98052",
SiteInfo = new SiteInfo
{
Zone = 1,
Environment = "Clean"
}
},
},
new Building
{
BuildingId = Guid.NewGuid(),
Name = "Building Two",
Value = 1000000m,
Address = new Address
{
Street = "200 Work St",
City = "Redmond",
State = "WA",
ZipCode = "98052",
SiteInfo = new SiteInfo
{
Zone = 2,
Environment = "Contaminated"
}
},
},
};
buildings.ForEach(b => context.Buildings.Add(b));
var offices = new List<Office>
{
new Office
{
BuildingId = buildings[0].BuildingId,
Number = "1/1221"
},
new Office
{
BuildingId = buildings[0].BuildingId,
Number = "1/1223"
},
new Office
{
BuildingId = buildings[0].BuildingId,
Number = "2/1458"
},
new Office
{
BuildingId = buildings[0].BuildingId,
Number = "2/1789"
},
};
offices.ForEach(o => context.Offices.Add(o));
new List<Employee>
{
new CurrentEmployee
{
EmployeeId = 1,
FirstName = "Rowan",
LastName = "Miller",
LeaveBalance = 45,
Office = offices[0]
},
new CurrentEmployee
{
EmployeeId = 2,
FirstName = "Arthur",
LastName = "Vickers",
LeaveBalance = 62,
Office = offices[1]
},
new PastEmployee
{
EmployeeId = 3,
FirstName = "John",
LastName = "Doe",
TerminationDate = new DateTime(2006, 1, 23)
},
}.ForEach(e => context.Employees.Add(e));
new List<Whiteboard>
{
new Whiteboard
{
AssetTag = "WB1973",
iD = new byte[] { 1, 9, 7, 3 },
Office = offices[0]
},
new Whiteboard
{
AssetTag = "WB1977",
iD = new byte[] { 1, 9, 7, 7 },
Office = offices[0]
},
new Whiteboard
{
AssetTag = "WB1970",
iD = new byte[] { 1, 9, 7, 0 },
Office = offices[2]
},
}.ForEach(w => context.Whiteboards.Add(w));
}
}
}
|
