public void DataBase_Seed()
{
using (var ctx = new DbCourseCtx())
{
for (var i = 0; i < 30; i++)
{
ctx.Students.Add(new Student {
StudentName = "Name " + i, StudentSurname = "Surname " + i
});
}
ctx.SaveChanges();
for (var i = 0; i < 10; i++)
{
ctx.Lessons.Add(new Lesson {
LessonName = "Lesson " + i
});
}
ctx.SaveChanges();
for (var i = 0; i < 15; i++)
{
ctx.ClassRooms.Add(new ClassRoom {
ClassRoomName = "Class " + i
});
}
ctx.SaveChanges();
}
}
public async Task <ActionResult> Index()
{
List <StudentViewModels> studentsViewModels = new List <StudentViewModels>();
using (var ctx = new DbCourseCtx())
{
var students = await Student.GetAll(ctx);
studentsViewModels = students.Select(student =>
new StudentViewModels()
{
IdStudent = student.IdStudent,
Name = student.Name,
SurName = student.SurName,
Username = student.IdStudent.ToString().PadLeft(7, '0'),
}).ToList();
}
return(View(studentsViewModels));
}
public void DataBase_Scheduler()
{
using (var ctx = new DbCourseCtx())
{
foreach (var r in ctx.ClassRooms)
{
foreach (var l in ctx.Lessons)
{
foreach (var s in ctx.Students)
{
ctx.ClassRoom_Student.Add(new ClassRoom_Student
{
IdClassRoom = r.IdClassRoom,
IdLesson = l.IdLesson,
IdStudent = s.IdStudent,
});
}
}
}
ctx.SaveChanges();
}
}
