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(); }