/// <summary>
/// Seed function to seed that db with some classes and enroled student.
/// </summary>
public void Seed()
{
_db.Database.ExecuteSqlCommand("TRUNCATE TABLE Courses");
_db.Database.ExecuteSqlCommand("TRUNCATE TABLE Students");
_db.Database.ExecuteSqlCommand("TRUNCATE TABLE CourseTemplates");
_db.Database.ExecuteSqlCommand("TRUNCATE TABLE CourseEnrolments");
_db.Database.ExecuteSqlCommand("TRUNCATE TABLE CourseWaitinglists");
// _db.Courses.AddRange(new List<Course>
// {
// new Course { TemplateID = "T-514-VEFT", Semester = "20143", StartDate = new DateTime(2014, 8, 15), EndDate = new DateTime(2014, 11, 19), MaxStudents = 5 },
// new Course { TemplateID = "T-514-VEFT", Semester = "20153", StartDate = new DateTime(2015, 8, 17), EndDate = new DateTime(2015, 11, 21), MaxStudents = 10 },
// new Course { TemplateID = "T-111-PROG", Semester = "20143", StartDate = new DateTime(2014, 8, 15), EndDate = new DateTime(2014, 11, 19), MaxStudents = 5 }
// });
// _db.SaveChanges();
_db.CourseTemplates.AddRange(new List <CourseTemplate>
{
new CourseTemplate {
TemplateID = "T-514-VEFT", Name = "Vefþjónustur"
}
// new CourseTemplate { TemplateID = "T-111-PROG", Name = "Forritun" },
});
_db.SaveChanges();
_db.Students.AddRange(new List <Student>
{
// new Student { SSN = "1234567890", Name = "Jón Jónsson" },
// new Student { SSN = "9876543210", Name = "Guðrún Jónsdóttir" },
// new Student { SSN = "6543219870", Name = "Gunnar Sigurðsson" },
// new Student { SSN = "4567891230", Name = "Jóna Halldórsdóttir" },
new Student {
SSN = "1234567890", Name = "Herp McDerpsson 1"
},
new Student {
SSN = "1234567891", Name = "Herpina Derpy 1"
},
new Student {
SSN = "1234567892", Name = "Herp McDerpsson 2"
},
new Student {
SSN = "1234567893", Name = "Herpina Derpy 2"
},
new Student {
SSN = "1234567894", Name = "Herp McDerpsson 3"
},
new Student {
SSN = "1234567895", Name = "Herpina Derpy 3"
},
new Student {
SSN = "1234567896", Name = "Herp McDerpsson 4"
},
new Student {
SSN = "1234567897", Name = "Herpina Derpy 4"
},
new Student {
SSN = "1234567898", Name = "Herp McDerpsson 5"
},
new Student {
SSN = "1234567899", Name = "Herpina Derpy 5"
}
});
_db.SaveChanges();
// _db.CourseEnrolments.AddRange(new List<CourseEnrolment>
// {
// new CourseEnrolment { CourseID = 1, StudentID = 1, Active = true },
// new CourseEnrolment { CourseID = 1, StudentID = 2, Active = true },
// new CourseEnrolment { CourseID = 2, StudentID = 3, Active = true },
// new CourseEnrolment { CourseID = 2, StudentID = 4, Active = true },
// new CourseEnrolment { CourseID = 3, StudentID = 1, Active = true },
// new CourseEnrolment { CourseID = 3, StudentID = 2, Active = true },
// new CourseEnrolment { CourseID = 1, StudentID = 5, Active = false },
// new CourseEnrolment { CourseID = 2, StudentID = 6, Active = false },
// new CourseEnrolment { CourseID = 3, StudentID = 7, Active = false }
// });
// _db.SaveChanges();
}
public void AddCourse(Courses courses)
{
_schoolDb.Set <Courses>().Add(courses);
_schoolDb.SaveChanges();
}
public int CreateSubject(Subjects subjects)
{
context.Subjects.Add(subjects);
return(context.SaveChanges());
}
//TODO: individual and all select shall work properly
/// <summary>
/// multiple delete - individual and all select shall work properly
/// </summary>
/// <param name="courseIdToDelete"></param>
/// <returns></returns>
public ActionResult MultipleDelete(IEnumerable <int> courseIdToDelete)
{
db.courses.RemoveRange(db.courses.Where(x => courseIdToDelete.Contains(x.CourseId)).ToList());
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void Initialise(SchoolDbContext context)
{
context.Database.EnsureCreated();//要创建数据库
if (context.Students.Any())
{
return;
}
#region 添加种子学生信息
var students = new Student[] {
new Student {
RealName = "乔峰", EnrollmnetDate = DateTime.Parse("2011-08-26")
},
new Student {
RealName = "段誉", EnrollmnetDate = DateTime.Parse("2012-08-26")
},
new Student {
RealName = "虚竹", EnrollmnetDate = DateTime.Parse("2011-08-26")
},
new Student {
RealName = "令狐冲", EnrollmnetDate = DateTime.Parse("2013-07-26")
},
new Student {
RealName = "张无忌", EnrollmnetDate = DateTime.Parse("2015-08-26")
},
new Student {
RealName = "杨过", EnrollmnetDate = DateTime.Parse("2014-08-26")
},
new Student {
RealName = "黄蓉", EnrollmnetDate = DateTime.Parse("2011-08-26")
},
};
foreach (var student in students)
{
context.Students.Add(student);
}
context.SaveChanges();
#endregion
#region 添加种子老师信息
var instructors = new Instructor[] {
new Instructor {
RealName = "孔子", HireDate = DateTime.Parse("1993-08-12")
},
new Instructor {
RealName = "墨子", HireDate = DateTime.Parse("1994-08-12")
},
new Instructor {
RealName = "荀子", HireDate = DateTime.Parse("1995-08-12")
},
new Instructor {
RealName = "鬼谷子", HireDate = DateTime.Parse("1996-08-12")
},
new Instructor {
RealName = "孟子", HireDate = DateTime.Parse("1997-08-12")
},
new Instructor {
RealName = "朱熹", HireDate = DateTime.Parse("1998-08-12")
},
new Instructor {
RealName = "庄子", HireDate = DateTime.Parse("1999-08-12")
},
};
foreach (var i in instructors)
{
context.Instructors.Add(i);
}
context.SaveChanges();
#endregion
#region 添加部门的种子数据
var departments = new Department[]
{
new Department {
Name = "声乐", Budget = 350000, StartDate = DateTime.Parse("2013-09-04"), InstructorId = instructors.Single(i => i.RealName == "墨子").Id
},
new Department {
Name = "杂技", Budget = 350000, StartDate = DateTime.Parse("2014-09-04"), InstructorId = instructors.Single(i => i.RealName == "孔子").Id
},
new Department {
Name = "学说", Budget = 350000, StartDate = DateTime.Parse("2015-09-04"), InstructorId = instructors.Single(i => i.RealName == "庄子").Id
},
new Department {
Name = "兵法", Budget = 350000, StartDate = DateTime.Parse("2016-09-04"), InstructorId = instructors.Single(i => i.RealName == "荀子").Id
}
};
foreach (var d in departments)
{
context.Departments.Add(d);
}
context.SaveChanges();
#endregion
#region 添加种子课程
var courses = new Course[] {
new Course {
Id = 10010, Title = "政治", Credits = 6, DepartmentId = departments.Single(d => d.Name == "声乐").Id
},
new Course {
Id = 10011, Title = "历史", Credits = 4, DepartmentId = departments.Single(d => d.Name == "杂技").Id
},
new Course {
Id = 10012, Title = "语文", Credits = 4, DepartmentId = departments.Single(d => d.Name == "杂技").Id
},
new Course {
Id = 10013, Title = "地理", Credits = 4, DepartmentId = departments.Single(d => d.Name == "兵法").Id
},
};
foreach (var course in courses)
{
context.Courses.Add(course);
}
context.SaveChanges();
#endregion
#region 添加办公室分配的种子数据
var officeAssignments = new OfficeAssignment[]
{
new OfficeAssignment {
InstructorId = instructors.Single(i => i.RealName == "墨子").Id, Location = "逸夫楼17"
},
new OfficeAssignment {
InstructorId = instructors.Single(i => i.RealName == "孔子").Id, Location = "逸夫楼18"
},
new OfficeAssignment {
InstructorId = instructors.Single(i => i.RealName == "庄子").Id, Location = "逸夫楼19"
},
};
foreach (var o in officeAssignments)
{
context.OfficeAssignments.Add(o);
}
context.SaveChanges();
#endregion
#region 添加课程老师的种子数据
var courseInstrutors = new CourseAssignment[]
{
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "政治").Id, InstructorId = instructors.Single(i => i.RealName == "孟子").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "政治").Id, InstructorId = instructors.Single(i => i.RealName == "孔子").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "语文").Id, InstructorId = instructors.Single(i => i.RealName == "庄子").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "历史").Id, InstructorId = instructors.Single(i => i.RealName == "庄子").Id
},
};
foreach (var c in courseInstrutors)
{
context.CourseAssignments.Add(c);
}
context.SaveChanges();
#endregion
#region 添加招生信息种子数据
var enrollments = new Enrollment[]
{
new Enrollment {
StudentId = students.Single(s => s.RealName == "乔峰").Id, CourseId = courses.Single(c => c.Title == "政治").Id, Grade = CourseGrade.A
},
new Enrollment {
StudentId = students.Single(s => s.RealName == "乔峰").Id, CourseId = courses.Single(c => c.Title == "历史").Id, Grade = CourseGrade.A
},
new Enrollment {
StudentId = students.Single(s => s.RealName == "段誉").Id, CourseId = courses.Single(c => c.Title == "语文").Id, Grade = CourseGrade.B
},
new Enrollment {
StudentId = students.Single(s => s.RealName == "虚竹").Id, CourseId = courses.Single(c => c.Title == "地理").Id, Grade = CourseGrade.C
},
};
foreach (var e in enrollments)
{
context.Enrollments.Add(e);
}
context.SaveChanges();
#endregion
}
private void CreateHostRoleAndUsers()
{
// Admin role for host
var adminRoleForHost = _context.Roles.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == null && r.Name == StaticRoleNames.Host.Admin);
if (adminRoleForHost == null)
{
adminRoleForHost = _context.Roles.Add(new Role(null, StaticRoleNames.Host.Admin, StaticRoleNames.Host.Admin)
{
IsStatic = true, IsDefault = true
}).Entity;
_context.SaveChanges();
}
// Grant all permissions to admin role for host
var grantedPermissions = _context.Permissions.IgnoreQueryFilters()
.OfType <RolePermissionSetting>()
.Where(p => p.TenantId == null && p.RoleId == adminRoleForHost.Id)
.Select(p => p.Name)
.ToList();
var permissions = PermissionFinder
.GetAllPermissions(new AppAuthorizationProvider(true))
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Host) &&
!grantedPermissions.Contains(p.Name))
.ToList();
if (permissions.Any())
{
_context.Permissions.AddRange(
permissions.Select(permission => new RolePermissionSetting
{
TenantId = null,
Name = permission.Name,
IsGranted = true,
RoleId = adminRoleForHost.Id
})
);
_context.SaveChanges();
}
// Admin user for host
var adminUserForHost = _context.Users.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == null && u.UserName == AbpUserBase.AdminUserName);
if (adminUserForHost == null)
{
var user = new User
{
TenantId = null,
UserName = AbpUserBase.AdminUserName,
Name = "admin",
Surname = "admin",
EmailAddress = "*****@*****.**",
IsEmailConfirmed = true,
IsActive = true
};
user.Password = new PasswordHasher <User>(new OptionsWrapper <PasswordHasherOptions>(new PasswordHasherOptions())).HashPassword(user, "123qwe");
user.SetNormalizedNames();
adminUserForHost = _context.Users.Add(user).Entity;
_context.SaveChanges();
// Assign Admin role to admin user
_context.UserRoles.Add(new UserRole(null, adminUserForHost.Id, adminRoleForHost.Id));
_context.SaveChanges();
// User account of admin user
_context.UserAccounts.Add(new UserAccount
{
TenantId = null,
UserId = adminUserForHost.Id,
UserName = AbpUserBase.AdminUserName,
EmailAddress = adminUserForHost.EmailAddress
});
_context.SaveChanges();
}
}
/// <summary>
/// 数据库初始化静态方法.
/// </summary>
/// <param name="context"></param>
public static void Initialize(SchoolDbContext context)
{
// 确保数据库已经创建.
context.Database.EnsureCreated();
// 添加种子数据.
if (!context.Students.Any())
{
var students = new Student[] {
new Student()
{
Name = "LancerComet",
EnrollmentDate = DateTime.Parse("2017-12-11")
},
new Student()
{
Name = "Wch",
EnrollmentDate = DateTime.Parse("2017-12-11")
}
};
foreach (Student item in students)
{
context.Students.Add(item);
}
context.SaveChanges();
}
if (!context.Courses.Any())
{
var courses = new Course[] {
new Course()
{
Id = 1, Title = "Chinese", Credits = 2
},
new Course()
{
Id = 2, Title = "English", Credits = 2
},
new Course()
{
Id = 3, Title = "Math", Credits = 2
},
new Course()
{
Id = 4, Title = "Physics", Credits = 1
},
new Course()
{
Id = 5, Title = "Chemical", Credits = 1
}
};
foreach (Course item in courses)
{
context.Courses.Add(item);
}
context.SaveChanges();
}
if (!context.Enrollments.Any())
{
// 如果 Enrollments 创建失败, 请检查学生 ID 是否和上方一致.
var enrollments = new Enrollment[] {
new Enrollment()
{
StudentId = 11, CourseId = 1, Grade = CourseGrade.B
},
new Enrollment()
{
StudentId = 11, CourseId = 2, Grade = CourseGrade.A
},
new Enrollment()
{
StudentId = 11, CourseId = 3, Grade = CourseGrade.C
},
new Enrollment()
{
StudentId = 12, CourseId = 1, Grade = CourseGrade.D
},
new Enrollment()
{
StudentId = 12, CourseId = 4, Grade = CourseGrade.E
},
new Enrollment()
{
StudentId = 12, CourseId = 5, Grade = CourseGrade.F
}
};
foreach (Enrollment item in enrollments)
{
context.Enrollments.Add(item);
}
context.SaveChanges();
}
}
public int CreateStudent(Students students)
{
context.Students.Add(students);
return(context.SaveChanges());
}
public void Add(Department department)
{
_schoolDb.Set <Department>().Add(department);
_schoolDb.SaveChanges();
}
/// <summary>
/// 初始化数据
/// </summary>
/// <param name="context"></param>
public static void Initialize(SchoolDbContext context)
{
context.Database.EnsureCreated();
if (context.Students.Any())
{
return;
}
//Student
var students = new Student[] {
new Student {
Id = 1, StuName = "小王", EnrollmentDate = Convert.ToDateTime("2017-09-09")
},
new Student {
Id = 2, StuName = "小李", EnrollmentDate = Convert.ToDateTime("2017-09-09")
},
new Student {
Id = 3, StuName = "小张", EnrollmentDate = Convert.ToDateTime("2017-09-09")
},
new Student {
Id = 4, StuName = "小刘", EnrollmentDate = Convert.ToDateTime("2017-09-09")
},
new Student {
Id = 5, StuName = "小陈", EnrollmentDate = Convert.ToDateTime("2017-09-09")
}
};
foreach (Student item in students)
{
context.Students.Add(item);
}
context.SaveChanges();
//Course
var courses = new Course[] {
new Course {
ID = 2001, Title = "语文", Credits = 3
},
new Course {
ID = 2002, Title = "英语", Credits = 3
},
new Course {
ID = 2003, Title = "政治", Credits = 4
},
new Course {
ID = 2004, Title = "生物", Credits = 4
},
new Course {
ID = 2005, Title = "历史", Credits = 5
}
};
foreach (Course item in courses)
{
context.Courses.Add(item);
}
context.SaveChanges();
//Enrollment
//Course
var Enrollments = new Enrollment[] {
new Enrollment {
EnrollmentId = 5001, StudentId = 1, CourseId = 2001, Grade = CourseGrade.A
},
new Enrollment {
EnrollmentId = 5002, StudentId = 2, CourseId = 2002, Grade = CourseGrade.B
},
new Enrollment {
EnrollmentId = 5003, StudentId = 3, CourseId = 2003, Grade = CourseGrade.C
},
new Enrollment {
EnrollmentId = 5004, StudentId = 4, CourseId = 2004, Grade = CourseGrade.D
},
new Enrollment {
EnrollmentId = 5005, StudentId = 5, CourseId = 2005, Grade = CourseGrade.E
}
};
foreach (Enrollment item in Enrollments)
{
context.Enrollments.Add(item);
}
context.SaveChanges();
}
public int CreateCourse(Courses courses)
{
context.Courses.Add(courses);
return(context.SaveChanges());
}
public int CreateStudent(Student item)
{
_context.Student.Add(item);
_context.SaveChanges();
return(item.StudentID);
}
public void Save()
{
_context.SaveChanges();
}
public int Commit()
{
return(_context.SaveChanges());
}
public IActionResult Index()
{
//haal de cursus op met id 1
var courseInDb = _schoolDbContext
.Courses
.SingleOrDefault(c => c.Id == 2);
//haal alle cursussen op
var courses = _schoolDbContext.Courses.ToList();
foreach (var course in courses)
{
Console.WriteLine($"{course.Id}-{course.CourseName}");
}
//selectie op basis van voorwaarden
//vb haal alle cursussen die beginnen met WB
//linq Where
var coursesWb = _schoolDbContext
.Courses
.Where(c => c.CourseName.Contains("WB"))
.OrderBy(c => c.CourseName)
.ToList();
foreach (var courseWb in coursesWb)
{
Console.WriteLine($"{courseWb.Id}-{courseWb.CourseName}");
}
//selectie van veld(en)
//bv enkel de courseName = enkel veld
var courseOnlyTitle = _schoolDbContext
.Courses
.OrderBy(c => c.CourseName)
.Select(c => c.CourseName)//vanaf hier = lijst van string
.ToList();
//select van 2(of meer) velden
//gebruik anoniem object
//vb Id en Coursename
var coursesTitleId = _schoolDbContext
.Courses
.OrderBy(c => c.CourseName)
.Select(c => new { c.CourseName, c.Id })
.ToList();
//ophalen gerelateerde data
//gebruik de include method
//(rechtreeks gerelateerd)
//ThenInclude (onrechtstreeks gerelateerd)
//haal courses met hun teachers op
var coursesTeachers = _schoolDbContext
.Courses
.Include(c => c.Teachers) //join CoursesTeachers
.ThenInclude(ct => ct.Teacher)
.OrderBy(c => c.CourseName) //join met Taachers
.ToList();
foreach (var coursesTeacher in coursesTeachers)
{
Console.WriteLine($"{coursesTeacher?.CourseName}");
foreach (var teacher in coursesTeacher?.Teachers)
{
Console.Write($"{teacher?.Teacher?.TeacherName} ");
}
}
//toevoegen van data
//single object(zonder gerelateerde data)
//var newTeacher = new Teacher();
//newTeacher.TeacherName = "Siegfried Deerdeyn";
//change tracker
// _schoolDbContext.Teachers.Add(newTeacher);
//maak een nieuwe teacher
//maak een nieuwe cursus
//voeg ze toe aan CourseTeachers
//var newTeacher = new Teacher
//{ TeacherName = "Willie Schokkelé",YearlyWage=20000 };
//var newCourse = new Course { CourseName = "CIA", Duration = 20 };
//var courseTeacher = new CoursesTeachers
//{ Course = newCourse, Teacher = newTeacher };
////toevoegen aan de databasecontext
//_schoolDbContext.CoursesTeachers.Add(courseTeacher);
var teacherCourse = new CoursesTeachers
{
CourseId = 1 /*WBA*/, TeacherId = 4/*William Schokkelé*/
};
//toevoegen aan chnge tracker
_schoolDbContext.CoursesTeachers.Add(teacherCourse);
//opslaan gebeurt op het einde
_schoolDbContext.SaveChanges();
return(View());
}
public ActionResult Create(AdmissionVM viewModel, HttpPostedFileBase StudentImage, HttpPostedFileBase Document)
{
using (var dbTransaction = db.Database.BeginTransaction())
{
try
{
#region validation
//if (!ModelState.IsValid)
//{
// var studentClass = db.StudentClass.Select(c => new
// {
// Id = c.Id,
// Name = c.ClassName.Name + " || " + c.Shift.Name + " ||" + c.Section.Name
// }).OrderBy(o => o.Name).ToList();
// ViewBag.SessionId = new SelectList(db.Session, "Id", "Name");
// ViewBag.GuardianTypeId = new SelectList(db.GuardianType, "Id", "Name");
// ViewBag.StudentClassId = new SelectList(studentClass, "Id", "Name");
// ViewBag.GroupId = new SelectList(db.Group, "Id", "Name");
// return View();
//}
#endregion
#region Create Students
var student = new Student
{
Name = viewModel.StudentName,
FatherName = viewModel.FatherName,
MotherName = viewModel.MotherName,
DateOfBirth = viewModel.DateOfBirth,
Email = viewModel.StudentEmail,
PresentAddress = viewModel.PresentAddress,
ParmanentAddress = viewModel.ParmanentAddress,
Religion = viewModel.Religion,
Gender = viewModel.Gender
};
if (StudentImage != null && StudentImage.ContentLength > 0)
{
using (var reader = new System.IO.BinaryReader(StudentImage.InputStream))
{
student.Image = reader.ReadBytes(StudentImage.ContentLength);
}
}
db.Student.Add(student);
db.SaveChanges();
int studentId = student.Id;
#endregion
#region Create Guardian
if (viewModel.GuardianName != null)
{
var guardian = new Guardian
{
Name = viewModel.GuardianName,
Email = viewModel.GuardianEmail,
Phone = viewModel.GuardianPhone,
NID = viewModel.NID,
GuardianTypeId = viewModel.GuardianTypeId,
StudentId = studentId
};
db.Guardian.Add(guardian);
db.SaveChanges();
}
#endregion
#region Create Admission
if (viewModel.SessionId != 0)
{
var admission = new Admission
{
AdmissionDate = viewModel.AdmissionDate,
SessionId = viewModel.SessionId,
PreviousSchool = viewModel.PreviousSchool,
PreviousSchoolAddrs = viewModel.PreviousSchoolAddrs,
StudentClassId = viewModel.StudentClassId,
GroupId = viewModel.GroupId,
StudentId = studentId
};
if (Document != null && Document.ContentLength > 0)
{
using (var reader = new System.IO.BinaryReader(Document.InputStream))
{
admission.PreviousSchoolDocument = reader.ReadBytes(Document.ContentLength);
}
}
db.Admission.Add(admission);
db.SaveChanges();
}
#endregion
#region update Admission Account
if (viewModel.ClassFeeId != 0)
{
var amount = db.ClassFee.Where(i => i.Id == viewModel.ClassFeeId).Select(a => a.AdmissionFee).FirstOrDefault();
var prevBalance = db.AccountList.Where(n => n.Name == "Admission").Select(c => c.CurrentBalance).FirstOrDefault();
var newBalance = prevBalance + amount;
ap.UpdateAccountListBalance(1000, newBalance);
}
#endregion
dbTransaction.Commit();
return(RedirectToAction("Index", "Students"));
}
catch (Exception ex)
{
#region catch
string abc = ex.Message + ex.InnerException;
dbTransaction.Rollback();
var studentClass = db.StudentClass.Select(c => new
{
Id = c.Id,
Name = c.ClassName.Name + " || " + c.Shift.Name + " ||" + c.Section.Name
}).OrderBy(o => o.Name).ToList();
ViewBag.SessionId = new SelectList(db.Session, "Id", "Name");
ViewBag.GuardianTypeId = new SelectList(db.GuardianType, "Id", "Name");
ViewBag.StudentClassId = new SelectList(studentClass, "Id", "Name");
ViewBag.GroupId = new SelectList(db.Group, "Id", "Name");
return(RedirectToAction("Create"));
#endregion
}
}
}
public int CreateProgram(Programs program)
{
context.Programs.Add(program);
return(context.SaveChanges());
}
public static void Initialize(SchoolDbContext context)
{
context.Database.EnsureCreated();
// 检查是否有学生信息
if (context.Students.Any())
{
return; //返回，不执行。
}
var students = new Student[]
{
new Student {
RealName = "龙傲天", EnrollmentDate = DateTime.Parse("2005-09-01")
},
new Student {
RealName = "王尼玛", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
RealName = "张全蛋", EnrollmentDate = DateTime.Parse("2003-09-01")
},
new Student {
RealName = "叶良辰", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
RealName = "和珅", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
RealName = "纪晓岚", EnrollmentDate = DateTime.Parse("2001-09-01")
},
new Student {
RealName = "李逍遥", EnrollmentDate = DateTime.Parse("2003-09-01")
},
new Student {
RealName = "王小虎", EnrollmentDate = DateTime.Parse("2005-09-01")
}
};
foreach (Student s in students)
{
context.Students.Add(s);
}
context.SaveChanges();
var courses = new Course[]
{
new Course {
CourseId = 1050, Title = "数学", Credits = 3
},
new Course {
CourseId = 4022, Title = "政治", Credits = 3
},
new Course {
CourseId = 4041, Title = "物理", Credits = 3
},
new Course {
CourseId = 1045, Title = "化学", Credits = 4
},
new Course {
CourseId = 3141, Title = "生物", Credits = 4
},
new Course {
CourseId = 2021, Title = "英语", Credits = 3
},
new Course {
CourseId = 2042, Title = "历史", Credits = 4
}
};
foreach (Course c in courses)
{
context.Courses.Add(c);
}
context.SaveChanges();
var enrollments = new Enrollment[]
{
new Enrollment {
StudentId = 1, CourseId = 1050, Grade = CourseGrade.A
},
new Enrollment {
StudentId = 1, CourseId = 4022, Grade = CourseGrade.C
},
new Enrollment {
StudentId = 1, CourseId = 4041, Grade = CourseGrade.B
},
new Enrollment {
StudentId = 2, CourseId = 1045, Grade = CourseGrade.B
},
new Enrollment {
StudentId = 2, CourseId = 3141, Grade = CourseGrade.F
},
new Enrollment {
StudentId = 2, CourseId = 2021, Grade = CourseGrade.F
},
new Enrollment {
StudentId = 3, CourseId = 1050
},
new Enrollment {
StudentId = 4, CourseId = 1050
},
new Enrollment {
StudentId = 4, CourseId = 4022, Grade = CourseGrade.F
},
new Enrollment {
StudentId = 5, CourseId = 4041, Grade = CourseGrade.C
},
new Enrollment {
StudentId = 6, CourseId = 1045
},
new Enrollment {
StudentId = 7, CourseId = 3141, Grade = CourseGrade.A
},
};
foreach (Enrollment e in enrollments)
{
context.Enrollments.Add(e);
}
context.SaveChanges();
}
public void Add(Enrollment _Enrollment)
{
context.Enrollments.Add(_Enrollment);
context.SaveChanges();
}
public static void Initialize(SchoolDbContext context)
{
context.Database.EnsureCreated();
// 检查是否有学生信息
if (context.Students.Any())
{
return; //返回，不执行。
}
#region 添加种子学生信息
var students = new[]
{
new Student {
RealName = "龙傲天", EnrollmentDate = DateTime.Parse("2005-09-01")
},
new Student {
RealName = "王尼玛", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
RealName = "张全蛋", EnrollmentDate = DateTime.Parse("2003-09-01")
},
new Student {
RealName = "叶良辰", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
RealName = "和珅", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
RealName = "纪晓岚", EnrollmentDate = DateTime.Parse("2001-09-01")
},
new Student {
RealName = "李逍遥", EnrollmentDate = DateTime.Parse("2003-09-01")
},
new Student {
RealName = "王小虎", EnrollmentDate = DateTime.Parse("2005-09-01")
}
};
foreach (var s in students)
{
context.Students.Add(s);
}
context.SaveChanges();
#endregion
#region 添加种子老师信息
var instructors = new[]
{
new Instructor
{
RealName = "孔子",
HireDate = DateTime.Parse("1995-03-11")
},
new Instructor
{
RealName = "墨子",
HireDate = DateTime.Parse("2003-03-11")
},
new Instructor
{
RealName = "荀子",
HireDate = DateTime.Parse("1990-03-11")
},
new Instructor
{
RealName = "鬼谷子",
HireDate = DateTime.Parse("1985-03-11")
},
new Instructor
{
RealName = "孟子",
HireDate = DateTime.Parse("2003-03-11")
},
new Instructor
{
RealName = "朱熹",
HireDate = DateTime.Parse("2003-03-11")
}
};
foreach (var i in instructors)
{
context.Instructors.Add(i);
}
context.SaveChanges();
#endregion
#region 添加部门的种子的数据
var departments = new[]
{
new Department
{
Name = "论语",
Budget = 350000,
StartDate = DateTime.Parse("2017-09-01"),
InstructorId = instructors.Single(i => i.RealName == "孟子").Id
},
new Department
{
Name = "兵法",
Budget = 100000,
StartDate = DateTime.Parse("2017-09-01"),
InstructorId = instructors.Single(i => i.RealName == "鬼谷子").Id
},
new Department
{
Name = "文言文",
Budget = 350000,
StartDate = DateTime.Parse("2017-09-01"),
InstructorId = instructors.Single(i => i.RealName == "朱熹").Id
},
new Department
{
Name = "世界和平",
Budget = 100000,
StartDate = DateTime.Parse("2017-09-01"),
InstructorId = instructors.Single(i => i.RealName == "墨子").Id
}
};
foreach (var d in departments)
{
context.Departments.Add(d);
}
context.SaveChanges();
#endregion
var courses = new[]
{
new Course
{
CourseId = 1050,
Title = "数学",
Credits = 3,
DepartmentId = departments.Single(s => s.Name == "兵法").Id
},
new Course
{
CourseId = 4022,
Title = "政治",
Credits = 3,
DepartmentId = departments.Single(s => s.Name == "文言文").Id
},
new Course
{
CourseId = 4041,
Title = "物理",
Credits = 3,
DepartmentId = departments.Single(s => s.Name == "兵法").Id
},
new Course
{
CourseId = 1045,
Title = "化学",
Credits = 4,
DepartmentId = departments.Single(s => s.Name == "世界和平").Id
},
new Course
{
CourseId = 3141,
Title = "生物",
Credits = 4,
DepartmentId = departments.Single(s => s.Name == "论语").Id
},
new Course
{
CourseId = 2021,
Title = "英语",
Credits = 3,
DepartmentId = departments.Single(s => s.Name == "论语").Id
},
new Course
{
CourseId = 2042,
Title = "历史",
Credits = 4,
DepartmentId = departments.Single(s => s.Name == "文言文").Id
}
};
foreach (var c in courses)
{
context.Courses.Add(c);
}
context.SaveChanges();
#region 办公室分配的种子数据
var officeAssignments = new[]
{
new OfficeAssignment
{
InstructorId = instructors.Single(i => i.RealName == "孟子").Id,
Location = "逸夫楼 17"
},
new OfficeAssignment
{
InstructorId = instructors.Single(i => i.RealName == "朱熹").Id,
Location = "青霞路 27"
},
new OfficeAssignment
{
InstructorId = instructors.Single(i => i.RealName == "墨子").Id,
Location = "天府楼 304"
}
};
foreach (var o in officeAssignments)
{
context.OfficeAssignments.Add(o);
}
context.SaveChanges();
#endregion
#region 课程老师的种子数据
var courseInstructors = new[]
{
new CourseAssignment
{
CourseId = courses.Single(c => c.Title == "数学").CourseId,
InstructorId = instructors.Single(i => i.RealName == "鬼谷子").Id
},
new CourseAssignment
{
CourseId = courses.Single(c => c.Title == "数学").CourseId,
InstructorId = instructors.Single(i => i.RealName == "墨子").Id
},
new CourseAssignment
{
CourseId = courses.Single(c => c.Title == "政治").CourseId,
InstructorId = instructors.Single(i => i.RealName == "朱熹").Id
},
new CourseAssignment
{
CourseId = courses.Single(c => c.Title == "化学").CourseId,
InstructorId = instructors.Single(i => i.RealName == "墨子").Id
},
new CourseAssignment
{
CourseId = courses.Single(c => c.Title == "生物").CourseId,
InstructorId = instructors.Single(i => i.RealName == "孟子").Id
},
new CourseAssignment
{
CourseId = courses.Single(c => c.Title == "英语").CourseId,
InstructorId = instructors.Single(i => i.RealName == "孟子").Id
},
new CourseAssignment
{
CourseId = courses.Single(c => c.Title == "物理").CourseId,
InstructorId = instructors.Single(i => i.RealName == "鬼谷子").Id
},
new CourseAssignment
{
CourseId = courses.Single(c => c.Title == "历史").CourseId,
InstructorId = instructors.Single(i => i.RealName == "朱熹").Id
}
};
foreach (var ci in courseInstructors)
{
context.CourseAssignments.Add(ci);
}
context.SaveChanges();
#endregion
var enrollments = new[]
{
new Enrollment
{
StudentId = students.Single(s => s.RealName == "龙傲天").Id,
CourseId = courses.Single(c => c.Title == "数学").CourseId,
Grade = CourseGrade.A
},
new Enrollment
{
StudentId = students.Single(s => s.RealName == "龙傲天").Id,
CourseId = courses.Single(c => c.Title == "政治").CourseId,
Grade = CourseGrade.C
},
new Enrollment
{
StudentId = students.Single(s => s.RealName == "龙傲天").Id,
CourseId = courses.Single(c => c.Title == "物理").CourseId,
Grade = CourseGrade.D
},
new Enrollment
{
StudentId = students.Single(s => s.RealName == "王尼玛").Id,
CourseId = courses.Single(c => c.Title == "物理").CourseId,
Grade = CourseGrade.F
},
new Enrollment
{
StudentId = students.Single(s => s.RealName == "王尼玛").Id,
CourseId = courses.Single(c => c.Title == "化学").CourseId
},
new Enrollment
{
StudentId = students.Single(s => s.RealName == "王尼玛").Id,
CourseId = courses.Single(c => c.Title == "生物").CourseId
},
new Enrollment
{
StudentId = students.Single(s => s.RealName == "叶良辰").Id,
CourseId = courses.Single(c => c.Title == "英语").CourseId,
Grade = CourseGrade.A
}, new Enrollment
{
StudentId = students.Single(s => s.RealName == "叶良辰").Id,
CourseId = courses.Single(c => c.Title == "历史").CourseId,
Grade = CourseGrade.D
},
new Enrollment
{
StudentId = students.Single(s => s.RealName == "张全蛋").Id,
CourseId = courses.Single(c => c.Title == "英语").CourseId,
Grade = CourseGrade.B
},
new Enrollment
{
StudentId = students.Single(s => s.RealName == "张全蛋").Id,
CourseId = courses.Single(c => c.Title == "数学").CourseId,
Grade = CourseGrade.A
},
new Enrollment
{
StudentId = students.Single(s => s.RealName == "纪晓岚").Id,
CourseId = courses.Single(c => c.Title == "英语").CourseId
},
new Enrollment
{
StudentId = students.Single(s => s.RealName == "王小虎").Id,
CourseId = courses.Single(c => c.Title == "生物").CourseId
},
new Enrollment
{
StudentId = students.Single(s => s.RealName == "和珅").Id,
CourseId = courses.Single(c => c.Title == "物理").CourseId,
Grade = CourseGrade.A
},
new Enrollment
{
StudentId = students.Single(s => s.RealName == "和珅").Id,
CourseId = courses.Single(c => c.Title == "英语").CourseId
}
};
foreach (var e in enrollments)
{
context.Enrollments.Add(e);
}
context.SaveChanges();
}
private void CreateRolesAndUsers()
{
// Admin role
var adminRole = _context.Roles.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == _tenantId && r.Name == StaticRoleNames.Tenants.Admin);
if (adminRole == null)
{
adminRole = _context.Roles.Add(new Role(_tenantId, StaticRoleNames.Tenants.Admin, StaticRoleNames.Tenants.Admin)
{
IsStatic = true
}).Entity;
_context.SaveChanges();
}
// Grant all permissions to admin role
var grantedPermissions = _context.Permissions.IgnoreQueryFilters()
.OfType <RolePermissionSetting>()
.Where(p => p.TenantId == _tenantId && p.RoleId == adminRole.Id)
.Select(p => p.Name)
.ToList();
var permissions = PermissionFinder
.GetAllPermissions(new AppAuthorizationProvider(true))
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Tenant) &&
!grantedPermissions.Contains(p.Name))
.ToList();
if (permissions.Any())
{
_context.Permissions.AddRange(
permissions.Select(permission => new RolePermissionSetting
{
TenantId = _tenantId,
Name = permission.Name,
IsGranted = true,
RoleId = adminRole.Id
})
);
_context.SaveChanges();
}
// Admin user
var adminUser = _context.Users.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == _tenantId && u.UserName == AbpUserBase.AdminUserName);
if (adminUser == null)
{
adminUser = User.CreateTenantAdminUser(_tenantId, "*****@*****.**");
adminUser.Password = new PasswordHasher <User>(new OptionsWrapper <PasswordHasherOptions>(new PasswordHasherOptions())).HashPassword(adminUser, "123qwe");
adminUser.IsEmailConfirmed = true;
adminUser.IsActive = true;
_context.Users.Add(adminUser);
_context.SaveChanges();
// Assign Admin role to admin user
_context.UserRoles.Add(new UserRole(_tenantId, adminUser.Id, adminRole.Id));
_context.SaveChanges();
// User account of admin user
if (_tenantId == 1)
{
_context.UserAccounts.Add(new UserAccount
{
TenantId = _tenantId,
UserId = adminUser.Id,
UserName = AbpUserBase.AdminUserName,
EmailAddress = adminUser.EmailAddress
});
_context.SaveChanges();
}
}
// CreateSuperAdminsFromDb(adminRole);
}
public void Create(Student student)
{
_context.Students.Add(student);
_context.SaveChanges();
}
public void AddRequest(Request request)
{
_context.Requests.Add(request);
_context.SaveChanges();
}