public async Task Seed()
{
var playlists = CreatePlaylistSeed();
_context.AddRange(playlists);
await _context.SaveChangesAsync();
}
public async Task Seed()
{
var coupons = GetCouponFromJson();
if (!_context.Coupons.Any())
{
// add static data for course arrtribute
_context.AddRange(coupons);
await _context.SaveChangesAsync();
}
}
public static void Seed()
{
var context = new CourseContext();
if (context.Database.GetPendingMigrations().Count() == 0)
{
if (context.School.Count() == 0)
{
context.School.AddRange(Schools);
context.Course.AddRange(Courses);
context.City.AddRange(Cities);
context.State.AddRange(States);
context.Country.AddRange(Countries);
context.Language.AddRange(Languages);
context.Time.AddRange(Times);
context.SImage.AddRange(SImages);
context.SaveChanges();
context.AddRange(CourseLanguages);
context.AddRange(CourseTimes);
context.AddRange(BranchCountries);
context.AddRange(BranchStates);
context.AddRange(BranchCities);
context.AddRange(BranchAccommodations);
context.AddRange(BranchBImages);
context.AddRange(SchoolSImages);
context.AddRange(BranchCourses);
context.AddRange(CountryStates);
context.AddRange(StateCities);
context.AddRange(CountryCities);
context.AddRange(BranchCountries);
context.AddRange(SchoolBranches);
context.SaveChanges();
}
}
}
public async Task Seed()
{
// step 1: setup the Course Attribute
var entityAttributeTypes = CreateEntityAttributeTypeSeed();
if (!_context.EntityAttributeTypes.Any())
{
// add static data for course arrtribute
_context.AddRange(entityAttributeTypes);
await _context.SaveChangesAsync();
}
// step 2: setup the Entity Attribute values
var entityAttributes = CreateEntityAttributeSeed();
if (!_context.EntityAttributes.Any())
{
// TODO: Move the transaction block out!!!
// must to use transaction + SET IDENTITY_INSERT ON to preset Id for entityAttribute datas
using (var transaction = _context.Database.BeginTransaction())
{
_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [course].[EntityAttributes] ON");
_context.AddRange(entityAttributes);
await _context.SaveChangesAsync();
_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [course].[EntityAttributes] OFF");
transaction.Commit();
}
}
//// step 3: setup the courses
var user = await _userRepository.GetUserByUserNameAsync("yaduolmailinatorcom");
if (user == null)
{
return;
}
//var courses = CreateCourseSeed(user);
var courses = new List <Course>
{
// K12
GetCourseSeed(user, "K12/K12_Calculus_AP.json"),
GetCourseSeed(user, "K12/K12_Chemistry_11.json"),
GetCourseSeed(user, "K12/K12_Chemistry_AP.json"),
GetCourseSeed(user, "K12/K12_Chemistry_IB.json"),
GetCourseSeed(user, "K12/K12_Chemistry_SAT.json"),
GetCourseSeed(user, "K12/K12_MATH_SAT.json"),
GetCourseSeed(user, "K12/K12_MYP1_IB.json"),
GetCourseSeed(user, "K12/K12_MYP2_IB.json"),
GetCourseSeed(user, "K12/K12_MYP3_IB.json"),
GetCourseSeed(user, "K12/K12_MYP4_IB.json"),
GetCourseSeed(user, "K12/K12_MYP5_IB.json"),
GetCourseSeed(user, "K12/K12_MYP5_PLUS_IB.json"),
GetCourseSeed(user, "K12/K12_Physics_AP.json"),
GetCourseSeed(user, "K12/K12_Physics_IB.json"),
GetCourseSeed(user, "K12/K12_Physics_SAT.json"),
// College
// SFU
GetCourseSeed(user, "College/SFU/Sfu_BUEC_232.json"),
GetCourseSeed(user, "College/SFU/Sfu_BUEC_333.json"),
GetCourseSeed(user, "College/SFU/Sfu_BUS_200.json"),
GetCourseSeed(user, "College/SFU/Sfu_BUS_251.json"),
GetCourseSeed(user, "College/SFU/Sfu_CHEM_110.json"),
GetCourseSeed(user, "College/SFU/Sfu_CMPT_120.json"),
GetCourseSeed(user, "College/SFU/Sfu_CMPT_165.json"),
GetCourseSeed(user, "College/SFU/Sfu_ECON_103.json"),
GetCourseSeed(user, "College/SFU/Sfu_ECON_105.json"),
GetCourseSeed(user, "College/SFU/Sfu_LING_111.json"),
GetCourseSeed(user, "College/SFU/Sfu_MATH_100.json"),
GetCourseSeed(user, "College/SFU/Sfu_MATH_157.json"),
GetCourseSeed(user, "College/SFU/Sfu_PHIL_105.json"),
GetCourseSeed(user, "College/SFU/Sfu_PHIL_110.json"),
GetCourseSeed(user, "College/SFU/Sfu_STAT_203.json"),
// UBC
GetCourseSeed(user, "College/UBC/Ubc_CHEM_111.json"),
GetCourseSeed(user, "College/UBC/Ubc_CHEM_121.json"),
GetCourseSeed(user, "College/UBC/Ubc_COMM_204.json"),
GetCourseSeed(user, "College/UBC/Ubc_ECON_101.json"),
GetCourseSeed(user, "College/UBC/Ubc_LPI.json"),
GetCourseSeed(user, "College/UBC/Ubc_MATH_100.json"),
GetCourseSeed(user, "College/UBC/Ubc_MATH_101.json"),
GetCourseSeed(user, "College/UBC/Ubc_MATH_102.json"),
GetCourseSeed(user, "College/UBC/Ubc_PSYC_101.json"),
GetCourseSeed(user, "College/UBC/Ubc_STAT_200.json"),
// Certifications
GetCourseSeed(user, "Cer/CFA_1.json"),
GetCourseSeed(user, "Cer/CFA_2.json"),
GetCourseSeed(user, "Cer/CPA_1.json"),
GetCourseSeed(user, "Cer/CPA_2.json"),
GetCourseSeed(user, "Cer/CSC_Volume_1.json"),
GetCourseSeed(user, "Cer/CSC_Volume_2.json"),
GetCourseSeed(user, "Cer/NCA_1.json"),
GetCourseSeed(user, "Cer/NCA_2.json"),
GetCourseSeed(user, "Cer/Realtor_1.json")
};
if (!_context.Courses.Any())
{
// add courses
_context.AddRange(courses);
await _context.SaveChangesAsync();
}
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new CourseContext(
serviceProvider.GetRequiredService <
DbContextOptions <CourseContext> >()))
{
if (context.Courses.Any())
{
return;
}
var locations = new Location[]
{
new Location
{
Country = "USA",
State = "PA",
City = "Philadelphia",
ZipCode = 19103
},
new Location
{
Country = "USA",
State = "PA",
City = "Pittsburgh",
ZipCode = 15213
},
new Location
{
Country = "USA",
State = "PA",
City = "Pittsburgh",
ZipCode = 15068
},
new Location
{
Country = "USA",
State = "PA",
City = "Philadelphia",
ZipCode = 19130
},
new Location
{
Country = "USA",
State = "NY",
City = "New York City",
ZipCode = 17890
},
new Location
{
Country = "USA",
State = "NJ",
City = "Newark",
ZipCode = 18909
}
};
context.AddRange(locations);
context.SaveChanges();
var courses = new Course[]
{
new Course {
Name = "Cabin Greens", LocationId = 1, Type = CourseType.Executive, Par = 72, DateFounded = DateTime.Parse("02/12/1989")
},
new Course {
Name = "Saxonburg Golf Club", LocationId = 2, Type = CourseType.Links, Par = 72, DateFounded = DateTime.Parse("03/17/1949")
},
new Course {
Name = "Sewickly Golf Club", LocationId = 3, Type = CourseType.Links, Par = 72, DateFounded = DateTime.Parse("12/22/1933")
},
new Course {
Name = "Buffalo Golf Course", LocationId = 4, Type = CourseType.PitchAndPutt, Par = 36, DateFounded = DateTime.Parse("10/02/1889")
},
new Course {
Name = "Fox Chapel Country Club", LocationId = 3, Type = CourseType.Links, Par = 72, DateFounded = DateTime.Parse("05/05/1895")
},
};
context.AddRange(courses);
context.SaveChanges();
InitializeSomeHoles(context);
context.SaveChanges();
InitializeRoundsOfGolf(context);
context.SaveChanges();
IntializeGolfers(context);
context.SaveChanges();
//InitializeLocations(context);
//context.SaveChanges();
//InitializeCourses(context);
//context.SaveChanges();
}
}