public static void Initialize(FamilyFinancesContext context)
{
//context.Database.EnsureCreated();
// Look for any students.
if (context.PurchaseCategories.Any())
{
return; // DB has been seeded
}
// PurchaseCategory
var purchaseCategories = new PurchaseCategory[]
{
new PurchaseCategory {
Name = "Продукты"
},
new PurchaseCategory {
Name = "Коммунальные"
},
new PurchaseCategory {
Name = "Здоровье"
},
new PurchaseCategory {
Name = "Заправки"
},
new PurchaseCategory {
Name = "Дача"
}
};
foreach (PurchaseCategory pc in purchaseCategories)
{
context.PurchaseCategories.Add(pc);
}
context.SaveChanges();
// Pay Source Types
var paySources = new PaySource[]
{
new PaySource {
Name = "ДК", FullName = "XXXX XXXX XXXX 0256", ValidThru = "08/22"
},
new PaySource {
Name = "КК", FullName = "XXXX XXXX XXXX 3348", ValidThru = "11/20"
},
new PaySource {
Name = "Счет", FullName = "Мастер счет в рублях"
},
new PaySource {
Name = "Наличные"
},
};
foreach (PaySource ps in paySources)
{
context.PaySources.Add(ps);
}
context.SaveChanges();
// Expences
var expences = new Expense[]
{
new Expense {
TimeStamp = DateTime.Parse("2020-07-03"), Sum = Decimal.Parse("569.70"),
Purchase = "Дикси", PaySource = paySources.Single(x => x.Name == "ДК"), Category = purchaseCategories.Single(x => x.Name == "Продукты")
},
new Expense {
TimeStamp = DateTime.Parse("2020-07-03"), Sum = Decimal.Parse("110.00"),
Purchase = "Колобок", PaySource = paySources.Single(x => x.Name == "ДК"), Category = purchaseCategories.Single(x => x.Name == "Продукты")
},
new Expense {
TimeStamp = DateTime.Parse("2020-07-06"), Sum = Decimal.Parse("100.00"),
Purchase = "На даче", PaySource = paySources.Single(x => x.Name == "Наличные"), Category = purchaseCategories.Single(x => x.Name == "Продукты")
},
new Expense {
TimeStamp = DateTime.Parse("2020-07-06"), Sum = Decimal.Parse("164.00"),
Purchase = "Колобок", PaySource = paySources.Single(x => x.Name == "КК"), Category = purchaseCategories.Single(x => x.Name == "Продукты")
}
};
foreach (Expense e in expences)
{
context.Expenses.Add(e);
}
context.SaveChanges();
/*
* var instructors = new Instructor[]
* {
* new Instructor { FirstMidName = "Kim", LastName = "Abercrombie",
* HireDate = DateTime.Parse("1995-03-11") },
* new Instructor { FirstMidName = "Fadi", LastName = "Fakhouri",
* HireDate = DateTime.Parse("2002-07-06") },
* new Instructor { FirstMidName = "Roger", LastName = "Harui",
* HireDate = DateTime.Parse("1998-07-01") },
* new Instructor { FirstMidName = "Candace", LastName = "Kapoor",
* HireDate = DateTime.Parse("2001-01-15") },
* new Instructor { FirstMidName = "Roger", LastName = "Zheng",
* HireDate = DateTime.Parse("2004-02-12") }
* };
*
* foreach (Instructor i in instructors)
* {
* context.Instructors.Add(i);
* }
* context.SaveChanges();
*
* var departments = new Department[]
* {
* new Department { Name = "English", Budget = 350000,
* StartDate = DateTime.Parse("2007-09-01"),
* InstructorID = instructors.Single( i => i.LastName == "Abercrombie").ID },
* new Department { Name = "Mathematics", Budget = 100000,
* StartDate = DateTime.Parse("2007-09-01"),
* InstructorID = instructors.Single( i => i.LastName == "Fakhouri").ID },
* new Department { Name = "Engineering", Budget = 350000,
* StartDate = DateTime.Parse("2007-09-01"),
* InstructorID = instructors.Single( i => i.LastName == "Harui").ID },
* new Department { Name = "Economics", Budget = 100000,
* StartDate = DateTime.Parse("2007-09-01"),
* InstructorID = instructors.Single( i => i.LastName == "Kapoor").ID }
* };
*
* foreach (Department d in departments)
* {
* context.Departments.Add(d);
* }
* context.SaveChanges();
*
* var courses = new Course[]
* {
* new Course {CourseID = 1050, Title = "Chemistry", Credits = 3,
* DepartmentID = departments.Single( s => s.Name == "Engineering").DepartmentID
* },
* new Course {CourseID = 4022, Title = "Microeconomics", Credits = 3,
* DepartmentID = departments.Single( s => s.Name == "Economics").DepartmentID
* },
* new Course {CourseID = 4041, Title = "Macroeconomics", Credits = 3,
* DepartmentID = departments.Single( s => s.Name == "Economics").DepartmentID
* },
* new Course {CourseID = 1045, Title = "Calculus", Credits = 4,
* DepartmentID = departments.Single( s => s.Name == "Mathematics").DepartmentID
* },
* new Course {CourseID = 3141, Title = "Trigonometry", Credits = 4,
* DepartmentID = departments.Single( s => s.Name == "Mathematics").DepartmentID
* },
* new Course {CourseID = 2021, Title = "Composition", Credits = 3,
* DepartmentID = departments.Single( s => s.Name == "English").DepartmentID
* },
* new Course {CourseID = 2042, Title = "Literature", Credits = 4,
* DepartmentID = departments.Single( s => s.Name == "English").DepartmentID
* },
* };
*
* foreach (Course c in courses)
* {
* context.Courses.Add(c);
* }
* context.SaveChanges();
*
* var officeAssignments = new OfficeAssignment[]
* {
* new OfficeAssignment {
* InstructorID = instructors.Single( i => i.LastName == "Fakhouri").ID,
* Location = "Smith 17" },
* new OfficeAssignment {
* InstructorID = instructors.Single( i => i.LastName == "Harui").ID,
* Location = "Gowan 27" },
* new OfficeAssignment {
* InstructorID = instructors.Single( i => i.LastName == "Kapoor").ID,
* Location = "Thompson 304" },
* };
*
* foreach (OfficeAssignment o in officeAssignments)
* {
* context.OfficeAssignments.Add(o);
* }
* context.SaveChanges();
*
* var courseInstructors = new CourseAssignment[]
* {
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Kapoor").ID
* },
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Harui").ID
* },
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Microeconomics" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Zheng").ID
* },
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Macroeconomics" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Zheng").ID
* },
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Calculus" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Fakhouri").ID
* },
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Trigonometry" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Harui").ID
* },
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Composition" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID
* },
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Literature" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID
* },
* };
*
* foreach (CourseAssignment ci in courseInstructors)
* {
* context.CourseAssignments.Add(ci);
* }
* context.SaveChanges();
*
* var enrollments = new Enrollment[]
* {
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Alexander").ID,
* CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID,
* Grade = Grade.A
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Alexander").ID,
* CourseID = courses.Single(c => c.Title == "Microeconomics" ).CourseID,
* Grade = Grade.C
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Alexander").ID,
* CourseID = courses.Single(c => c.Title == "Macroeconomics" ).CourseID,
* Grade = Grade.B
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Alonso").ID,
* CourseID = courses.Single(c => c.Title == "Calculus" ).CourseID,
* Grade = Grade.B
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Alonso").ID,
* CourseID = courses.Single(c => c.Title == "Trigonometry" ).CourseID,
* Grade = Grade.B
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Alonso").ID,
* CourseID = courses.Single(c => c.Title == "Composition" ).CourseID,
* Grade = Grade.B
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Anand").ID,
* CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Anand").ID,
* CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID,
* Grade = Grade.B
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Barzdukas").ID,
* CourseID = courses.Single(c => c.Title == "Chemistry").CourseID,
* Grade = Grade.B
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Li").ID,
* CourseID = courses.Single(c => c.Title == "Composition").CourseID,
* Grade = Grade.B
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Justice").ID,
* CourseID = courses.Single(c => c.Title == "Literature").CourseID,
* Grade = Grade.B
* }
* };
*
* foreach (Enrollment e in enrollments)
* {
* var enrollmentInDataBase = context.Enrollments.Where(
* s =>
* s.Student.ID == e.StudentID &&
* s.Course.CourseID == e.CourseID).SingleOrDefault();
* if (enrollmentInDataBase == null)
* {
* context.Enrollments.Add(e);
* }
* }
* context.SaveChanges();
*/
}
