private static void InitializeContext(EduPartnerDbContext context)
{
var parent = new Parent
{
Id = Guid.NewGuid(),
Name = "Ali bin Abu",
Email = "*****@*****.**",
Password = "******",
Address = "1, Jalan 2, 40000 Shah Alam, Selangor"
};
context.Parents.Add(parent);
var childOne = new Child
{
Id = Guid.NewGuid(),
Name = "Ahmad bin Ali",
DateOfBirth = new DateTime(2013, 1, 1),
Parent = parent
};
var childTwo = new Child
{
Id = Guid.NewGuid(),
Name = "Aishah binti Ali",
DateOfBirth = new DateTime(2010, 1, 1),
Parent = parent
};
context.Children.AddRange(childOne, childTwo);
var teacherOne = new Teacher
{
Id = Guid.NewGuid(),
Name = "Fatimah binti Zaid",
PhoneNumber = "60192223333"
};
var teacherTwo = new Teacher
{
Id = Guid.NewGuid(),
Name = "Abdul Aziz bin Rahim",
PhoneNumber = "60123334444"
};
var teacherThree = new Teacher
{
Id = Guid.NewGuid(),
Name = "Siti Hawa binti Aiman",
PhoneNumber = "60164445555"
};
context.Teachers.AddRange(teacherOne, teacherTwo, teacherThree);
var mathSubject = new Subject
{
Id = Guid.NewGuid(),
Name = "Mathematics",
MonthlyFee = 150.00m,
Teachers = new List <Teacher> {
teacherOne
}
};
var scienceSubject = new Subject
{
Id = Guid.NewGuid(),
Name = "Science",
MonthlyFee = 170.00m,
Teachers = new List <Teacher> {
teacherTwo, teacherThree
}
};
context.Subjects.AddRange(mathSubject, scienceSubject);
var enrollment = new Enrollment
{
Id = Guid.NewGuid(),
Child = childOne,
Subject = mathSubject,
Teacher = teacherOne,
TimeslotDayOfWeek = DayOfWeek.Monday,
TimeslotTime = new DateTime(2020, 1, 1, 14, 0, 0),
IsHomeTutoring = false
};
context.Enrollments.Add(enrollment);
var invoice = new Invoice
{
Id = Guid.NewGuid(),
Date = new DateTime(2020, 4, 1),
Items = new List <InvoiceItem>
{
new InvoiceItem
{
Id = Guid.NewGuid(),
Details = "Ahmad bin Ali - Mathematics - March 2020 - Mondays 2pm",
Amount = 150.00m
}
},
Status = InvoiceStatus.Due
};
context.Invoices.Add(invoice);
context.SaveChanges();
}
public static void ResetContext(EduPartnerDbContext context)
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
InitializeContext(context);
}
