public IActionResult CreateMajor(Major major,string college)
{
var cid = DB.Colleges
.Where(x => x.Title == college)
.Single();
var oldmajor = DB.Majors
.Where(x => x.Title == major.Title)
.SingleOrDefault();
if (oldmajor != null)
{
return Content("error");
}
else
{
DB.Majors.Add(major);
major.CollegeId = cid.Id;
DB.SaveChanges();
var log = new Log
{
UserId = User.Current.Id,
Roles = Roles.系主任,
Operation = Operation.添加专业,
Time = DateTime.Now,
Number = major.Id,
};
DB.Logs.Add(log);
DB.SaveChanges();
return Content("success");
}
}
public IActionResult EditMajor(int id,Major major)
{
var oldmajor = DB.Majors
.Where(x => x.Id == id)
.SingleOrDefault();
if (oldmajor == null)
{
return RedirectToAction("Error","Home");
}
else
{
oldmajor.Title = major.Title;
var log = new Log
{
UserId = User.Current.Id,
Roles = Roles.系主任,
Operation = Operation.编辑专业,
Time = DateTime.Now,
Number = oldmajor.Id,
};
DB.Logs.Add(log);
DB.SaveChanges();
return Content("success");
}
}
public async static Task InitDB(IServiceProvider services)
{
var DB = services.GetRequiredService<EMContext>();
var userManager = services.GetRequiredService<UserManager<User>>();
var roleManager = services.GetRequiredService<RoleManager<IdentityRole<long>>>();
if (DB.Database != null && DB.Database.EnsureCreated())
{
//初始化用户角色
await roleManager.CreateAsync(new IdentityRole<long> { Name = "系主任" });
await roleManager.CreateAsync(new IdentityRole<long> { Name = "指导老师" });
await roleManager.CreateAsync(new IdentityRole<long> { Name = "学生" });
var headteacher = new User { UserName = "******",Email="*****@*****.**" };
await userManager.CreateAsync(headteacher, "123456");
await userManager.AddToRoleAsync(headteacher, "系主任");
var teacher = new User { UserName = "******", Email = "*****@*****.**" };
await userManager.CreateAsync(teacher, "123456");
await userManager.AddToRoleAsync(teacher, "指导老师");
var teacher1 = new User { UserName = "******", Email = "*****@*****.**" };
await userManager.CreateAsync(teacher1, "123456");
await userManager.AddToRoleAsync(teacher1, "指导老师");
var teacher2 = new User { UserName = "******", Email = "*****@*****.**" };
await userManager.CreateAsync(teacher2, "123456");
await userManager.AddToRoleAsync(teacher2, "指导老师");
var teacher3 = new User { UserName = "******", Email = "*****@*****.**" };
await userManager.CreateAsync(teacher3, "123456");
await userManager.AddToRoleAsync(teacher3, "指导老师");
var guest = new User { UserName = "******", Email = "*****@*****.**" };
await userManager.CreateAsync(guest, "123456");
await userManager.AddToRoleAsync(guest, "学生");
//初始化计控学院
var college = new College { Title = "计算机与控制工程学院" };
DB.Colleges.Add(college);
//初始化计控学院专业
var major1 = new Major { CollegeId = college.Id, Title = "软件工程" };
DB.Majors.Add(major1);
var major2 = new Major { CollegeId = college.Id, Title = "计算机科学与应用" };
DB.Majors.Add(major2);
var major3 = new Major { CollegeId = college.Id, Title = "自动化" };
DB.Majors.Add(major3);
var major4 = new Major { CollegeId = college.Id, Title = "电气工程及其自动化" };
DB.Majors.Add(major4);
var major5 = new Major { CollegeId = college.Id, Title = "计算机网络工程" };
DB.Majors.Add(major5);
//初始化软件工程专业公告
var announcement = new Announcement
{
Title = "请提交毕业设计题目",
Content = "请提交毕业设计题目",
CreateTime = DateTime.Now,
MajorId=major1.Id,
};
DB.Announcements.Add(announcement);
DB.SaveChanges();
var teacherzhang = new Teacher
{ Name = "张老师",
Number = 2012023110,
CreateTime = DateTime.Now,
UserId=headteacher.Id,
CollegeId = college.Id,
MajorId = major1.Id
};
DB.Teachers.Add(teacherzhang);
var teacherjin = new Teacher
{
Name = "金老师",
Number = 2012023112,
CreateTime = DateTime.Now,
UserId = teacher1.Id,
CollegeId = college.Id,
MajorId = major1.Id
};
DB.Teachers.Add(teacherjin);
var teacherwu = new Teacher
{
Name = "吴老师",
Number = 2012023113,
CreateTime = DateTime.Now,
UserId = teacher2.Id,
CollegeId = college.Id,
MajorId = major1.Id
};
DB.Teachers.Add(teacherwu);
var teacherliang = new Teacher
{
Name = "梁老师",
Number = 2012023110,
CreateTime = DateTime.Now,
UserId = teacher3.Id,
CollegeId = college.Id,
MajorId = major1.Id
};
DB.Teachers.Add(teacherliang);
var teacherfdd = new Teacher
{
Name = "王老师",
Number = 2012023111,
CreateTime = DateTime.Now,
UserId = teacher.Id,
CollegeId = college.Id,
MajorId = major1.Id,
};
DB.Teachers.Add(teacherfdd);
var studentdu = new Student
{
Name = "杜晨勇",
Number = 2012023009,
CreateTime = DateTime.Now,
UserId = guest.Id,
CollegeId = college.Id,
MajorId = major1.Id,
IsGraduate=IsGraduate.否,
};
DB.Students.Add(studentdu);
DB.SaveChanges();
var log1 = new Log {
Roles = Roles.系主任,
Operation = Operation.添加系主任,
Time = DateTime.Now,
Number = teacherzhang.Id,
UserId = headteacher.Id
};
DB.Logs.Add(log1);
var log2 = new Log {
Roles = Roles.系主任,
Operation = Operation.添加老师,
Time = DateTime.Now,
Number = teacherfdd.Id,
UserId = headteacher.Id
};
DB.Logs.Add(log2);
var log3 = new Log {
Roles = Roles.系主任,
Operation = Operation.添加学生,
Time = DateTime.Now,
Number = studentdu.Id,
UserId = headteacher.Id
};
DB.Logs.Add(log3);
var log4 = new Log
{
Roles = Roles.系主任,
Operation = Operation.添加系统公告,
Time = DateTime.Now,
Number=announcement.Id,
UserId = headteacher.Id
};
DB.Logs.Add(log4);
var log5 = new Log
{
Roles = Roles.系主任,
Operation = Operation.添加专业,
Time = DateTime.Now,
Number = major2.Id,
UserId = headteacher.Id
};
DB.Logs.Add(log5);
var log6 = new Log
{
Roles = Roles.系主任,
Operation = Operation.添加专业,
Time = DateTime.Now,
Number = major3.Id,
UserId = headteacher.Id
};
DB.Logs.Add(log6);
var log7 = new Log
{
Roles = Roles.系主任,
Operation = Operation.添加专业,
Time = DateTime.Now,
Number = major4.Id,
UserId = headteacher.Id
};
DB.Logs.Add(log7);
var log8 = new Log
{
Roles = Roles.系主任,
Operation = Operation.添加专业,
Time = DateTime.Now,
Number = major5.Id,
UserId = headteacher.Id
};
DB.Logs.Add(log8);
var log9 = new Log
{
Roles = Roles.系主任,
Operation = Operation.添加专业,
Time = DateTime.Now,
Number = major1.Id,
UserId = headteacher.Id
};
DB.Logs.Add(log9);
var log10 = new Log
{
Roles = Roles.系主任,
Operation = Operation.添加老师,
Time = DateTime.Now,
Number = teacherjin.Id,
UserId = headteacher.Id
};
DB.Logs.Add(log10);
var log11 = new Log
{
Roles = Roles.系主任,
Operation = Operation.添加老师,
Time = DateTime.Now,
Number = teacherwu.Id,
UserId = headteacher.Id
};
DB.Logs.Add(log11);
var log12 = new Log
{
Roles = Roles.系主任,
Operation = Operation.添加老师,
Time = DateTime.Now,
Number = teacherliang.Id,
UserId = headteacher.Id
};
DB.Logs.Add(log12);
}
DB.SaveChanges();
}