public static void ImportStudents()
{
var db = new StudentsDbContext();
Console.Write("Adding Homeworks");
var courseIds = db.Courses.Select(c => c.Id).ToList();
for (int i = 0; i < DefaultAddingNumber; i++)
{
var studentToAdd = new Student()
{
FirstName = RandomGenerator.GetRandomString(5, 15),
LastName = RandomGenerator.GetRandomString(5, 15),
Age = RandomGenerator.GetRandomNumber(20, 30)
};
if (courseIds.Count > 0)
{
var uniqueCourseIds = new HashSet<int>();
var numberOfCoursesPerStudent = RandomGenerator.GetRandomNumber(1, Math.Min(10, courseIds.Count));
while (uniqueCourseIds.Count != numberOfCoursesPerStudent)
{
uniqueCourseIds.Add(courseIds[RandomGenerator.GetRandomNumber(0, courseIds.Count - 1)]);
}
foreach (var uniqueCourseId in uniqueCourseIds)
{
var course = db.Courses.Find(uniqueCourseId);
studentToAdd.Courses.Add(course);
}
}
db.Students.Add(studentToAdd);
}
db.SaveChanges();
}
public void GenerateStudents(StudentsDbContext data, int count)
{
for (int i = 0; i < count; i++)
{
var student = new Student
{
Name = random.GetRandomString(random.GetRandomNumber(5, 50)),
Number = random.GetRandomNumber(10, 1000)
};
data.Students.Add(student);
}
}
public void GenerateCourses(StudentsDbContext data, int count)
{
for (int i = 0; i < count; i++)
{
var course = new Course
{
Name = random.GetRandomString(random.GetRandomNumber(5, 50)),
Description = random.GetRandomString(random.GetRandomNumber(5, 50))
};
data.Courses.Add(course);
}
}
public void GenerateHomeworks(StudentsDbContext data, int count)
{
var studentsIds = data.Students.Select(s => s.StudentId).ToList();
var coursesIds = data.Courses.Select(c => c.CourseId).ToList();
for (int i = 0; i < count; i++)
{
var homework = new Homework
{
Content = random.GetRandomString(random.GetRandomNumber(5, 50)),
TimeSent = DateTime.Now.AddDays(-random.GetRandomNumber(60, 360)),
StudentId = studentsIds[random.GetRandomNumber(0, studentsIds.Count - 1)],
CourseId = coursesIds[random.GetRandomNumber(0, coursesIds.Count - 1)]
};
data.Homework.Add(homework);
}
}
public static void ImportCourses()
{
var db = new StudentsDbContext();
Console.Write("Adding Homeworks");
for (int i = 0; i < DefaultAddingNumber; i++)
{
var courseToAdd = new Course()
{
Name = RandomGenerator.GetRandomString(5, 20),
Description = RandomGenerator.GetRandomString(5, 20)
};
db.Courses.Add(courseToAdd);
db.SaveChanges();
}
db.SaveChanges();
}
public static void ImportHomeworks()
{
var db = new StudentsDbContext();;
Console.Write("Adding Homeworks");
var courseIds = db.Courses.Select(c => c.Id).ToList();
var studentIds = db.Students.Select(s => s.Id).ToList();
for (int i = 0; i < DefaultAddingNumber; i++)
{
var homeworkToAdd = new Homework()
{
Content = RandomGenerator.GetRandomString(1, 100),
TimeSent = null,
CourseId = courseIds[RandomGenerator.GetRandomNumber(0, courseIds.Count - 1)],
StudentId = studentIds[RandomGenerator.GetRandomNumber(0, studentIds.Count - 1)]
};
db.Homeworks.Add(homeworkToAdd);
}
db.SaveChanges();
}
