private static async Task Seed_Database(IEnrollmentRepository repository)
{
if ((await repository.CountAsync <LookUpsModel, LookUps>()) > 0)
{
return;//database has been seeded
}
XmlDocument xDoc = new XmlDocument();
xDoc.Load(Path.Combine(Directory.GetCurrentDirectory(), "DropDowns.xml"));
IList <LookUpsModel> lookUps = xDoc.SelectNodes("//list")
.OfType <XmlElement>()
.SelectMany
(
e => e.ChildNodes.OfType <XmlElement>()
.Where(c => c.Name == "item")
.Select
(
i =>
{
if (new HashSet <string> {
"isVeteran", "receivedGed", "creditHoursAtCmc", "yesNo"
}.Contains(e.Attributes["id"].Value))
{
return new LookUpsModel
{
ListName = e.Attributes["id"].Value,
EntityState = LogicBuilder.Domain.EntityStateType.Added,
BooleanValue = bool.Parse(i.Attributes["name"].Value),
Text = i.Attributes["value"].Value,
Order = 0
}
}
;
else
{
return new LookUpsModel
{
ListName = e.Attributes["id"].Value,
EntityState = LogicBuilder.Domain.EntityStateType.Added,
Value = i.Attributes["name"].Value,
Text = i.Attributes["value"].Value,
Order = 0
}
};
}
)
).ToList();
await repository.SaveGraphsAsync <LookUpsModel, LookUps>(lookUps);
UserModel[] users = new UserModel[]
{
new UserModel
{
UserName = "******",
Residency = new ResidencyModel
{
CitizenshipStatus = "US",
DriversLicenseNumber = "NC12345",
DriversLicenseState = "NC",
EntityState = LogicBuilder.Domain.EntityStateType.Added,
HasValidDriversLicense = true,
ImmigrationStatus = "AA",
ResidentState = "AR",
StatesLivedIn = new List <StateLivedInModel>
{
new StateLivedInModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added, State = "OH"
},
new StateLivedInModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added, State = "TN"
}
}
},
Academic = new AcademicModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
AttendedPriorColleges = true,
FromDate = new DateTime(2010, 10, 10),
ToDate = new DateTime(2014, 10, 10),
GraduationStatus = "H",
EarnedCreditAtCmc = true,
LastHighSchoolLocation = "NC",
NcHighSchoolName = "NCSCHOOL1",
Institutions = new List <InstitutionModel>
{
new InstitutionModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
HighestDegreeEarned = "BD",
StartYear = "2015",
EndYear = "2018",
InstitutionName = "I1",
InstitutionState = "floridaInstitutions",
MonthYearGraduated = new DateTime(2020, 10, 10)
}
}
},
Admissions = new AdmissionsModel
{
EnteringStatus = "1",
EnrollmentTerm = "FA",
EnrollmentYear = "2021",
ProgramType = "degreePrograms",
Program = "degreeProgram1",
EntityState = LogicBuilder.Domain.EntityStateType.Added
},
Certification = new CertificationModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
CertificateStatementChecked = true,
DeclarationStatementChecked = true,
PolicyStatementsChecked = true
},
ContactInfo = new ContactInfoModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
HasFormerName = true,
FormerFirstName = "John",
FormerMiddleName = "Michael",
FormerLastName = "Smith",
DateOfBirth = new DateTime(2003, 10, 10),
SocialSecurityNumber = "111-22-3333",
Gender = "M",
Race = "AN",
Ethnicity = "HIS",
EnergencyContactFirstName = "Jackson",
EnergencyContactLastName = "Zamarano",
EnergencyContactRelationship = "Father",
EnergencyContactPhoneNumber = "704-333-4444"
},
MoreInfo = new MoreInfoModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
ReasonForAttending = "C1",
OverallEducationalGoal = "E1",
IsVeteran = true,
MilitaryStatus = "A",
VeteranType = "H",
MilitaryBranch = "AF"
},
Personal = new PersonalModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
FirstName = "Michael",
MiddleName = "Jackson",
LastName = "Smith",
PrimaryEmail = "*****@*****.**",
Address1 = "First Street",
City = "Dallas",
State = "GA",
ZipCode = "30060",
CellPhone = "770-840-8756",
},
EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new UserModel
{
UserName = "******",
Residency = new ResidencyModel
{
CitizenshipStatus = "RA",
CountryOfCitizenship = "AA",
DriversLicenseNumber = "GA12345",
DriversLicenseState = "GA",
EntityState = LogicBuilder.Domain.EntityStateType.Added,
HasValidDriversLicense = true,
ImmigrationStatus = "BB",
ResidentState = "AR",
StatesLivedIn = new List <StateLivedInModel>
{
new StateLivedInModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added, State = "GA"
},
new StateLivedInModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added, State = "TN"
}
}
},
Academic = new AcademicModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
AttendedPriorColleges = true,
FromDate = new DateTime(2010, 10, 10),
ToDate = new DateTime(2014, 10, 10),
GraduationStatus = "CSD",
EarnedCreditAtCmc = false,
LastHighSchoolLocation = "NC",
NcHighSchoolName = "NCSCHOOL1",
Institutions = new List <InstitutionModel>
{
new InstitutionModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
HighestDegreeEarned = "CT",
StartYear = "2016",
EndYear = "2019",
InstitutionName = "I1",
InstitutionState = "floridaInstitutions",
MonthYearGraduated = new DateTime(2020, 10, 10)
}
}
},
Admissions = new AdmissionsModel
{
EnteringStatus = "1",
EnrollmentTerm = "FA",
EnrollmentYear = "2021",
ProgramType = "degreePrograms",
Program = "degreeProgram1",
EntityState = LogicBuilder.Domain.EntityStateType.Added
},
Certification = new CertificationModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
CertificateStatementChecked = true,
DeclarationStatementChecked = true,
PolicyStatementsChecked = true
},
ContactInfo = new ContactInfoModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
HasFormerName = false,
DateOfBirth = new DateTime(2003, 10, 10),
SocialSecurityNumber = "000-11-2222",
Gender = "F",
Race = "BL",
Ethnicity = "NHS",
EnergencyContactFirstName = "Jack",
EnergencyContactLastName = "Spratt",
EnergencyContactRelationship = "Father",
EnergencyContactPhoneNumber = "704-222-3333"
},
MoreInfo = new MoreInfoModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
ReasonForAttending = "C2",
OverallEducationalGoal = "E2",
IsVeteran = true,
MilitaryStatus = "A",
VeteranType = "G",
MilitaryBranch = "Army"
},
Personal = new PersonalModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
FirstName = "Mike",
MiddleName = "Tyson",
LastName = "Smith",
PrimaryEmail = "*****@*****.**",
Address1 = "Second Street",
City = "Dallas",
State = "GA",
ZipCode = "30060",
CellPhone = "770-855-0050",
},
EntityState = LogicBuilder.Domain.EntityStateType.Added
}
};
await repository.SaveGraphsAsync <UserModel, User>(users);
}
private static async Task Seed_Database(IEnrollmentRepository repository)
{
if ((await repository.CountAsync <LookUpsModel, LookUps>()) > 0)
{
return;//database has been seeded
}
XmlDocument xDoc = Path.Combine(Directory.GetCurrentDirectory(), "DropDowns.xml").LoadXmlDocument();
IList <LookUpsModel> lookUps = xDoc.SelectNodes("//list")
.OfType <XmlElement>()
.SelectMany
(
e => e.ChildNodes.OfType <XmlElement>()
.Where(c => c.Name == "item")
.Select
(
i => new LookUpsModel
{
ListName = e.Attributes["id"].Value,
EntityState = LogicBuilder.Domain.EntityStateType.Added,
Value = i.Attributes["name"].Value,
Text = i.Attributes["value"].Value,
Order = 0
}
)
).ToList();
await repository.SaveGraphsAsync <LookUpsModel, LookUps>(lookUps);
UserModel[] users = new UserModel[]
{
new UserModel
{
UserName = "******",
Residency = new ResidencyModel
{
CitizenshipStatus = "US",
CountryOfCitizenship = "US",
DriversLicenseNumber = "NC12345",
DriversLicenseState = "NC",
EntityState = LogicBuilder.Domain.EntityStateType.Added,
HasValidDriversLicense = true,
ImmigrationStatus = "AA",
ResidentState = "AR",
StatesLivedIn = new List <StateLivedInModel>
{
new StateLivedInModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added, State = "OH"
},
new StateLivedInModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added, State = "TN"
}
}
},
EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new UserModel
{
UserName = "******",
Residency = new ResidencyModel
{
CitizenshipStatus = "RA",
CountryOfCitizenship = "AA",
DriversLicenseNumber = "GA12345",
DriversLicenseState = "DA",
EntityState = LogicBuilder.Domain.EntityStateType.Added,
HasValidDriversLicense = true,
ImmigrationStatus = "BB",
ResidentState = "AR",
StatesLivedIn = new List <StateLivedInModel>
{
new StateLivedInModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added, State = "GA"
},
new StateLivedInModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added, State = "TN"
}
}
},
EntityState = LogicBuilder.Domain.EntityStateType.Added
}
};
await repository.SaveGraphsAsync <UserModel, User>(users);
}
