public void ImportCourses(int numberOfCourses)
{
var db = new StudentSystemContext();
Console.Write("Importing Courses");
for (int i = 0; i < numberOfCourses; i++)
{
var course = new Course()
{
Name = RandomGenerator.GetString(10, 100),
Description = RandomGenerator.GetString(100, 1000)
};
db.Courses.Add(course);
if (i % 50 == 0)
{
Console.Write(".");
db.SaveChanges();
db.Dispose();
db = new StudentSystemContext();
}
}
db.SaveChanges();
Console.WriteLine(" Completed!");
}
public void ImportStudents(int numberOfStudents)
{
Console.Write("Importing Students");
var db = new StudentSystemContext();
for (int i = 0; i < numberOfStudents; i++)
{
var student = new Student()
{
Name = RandomGenerator.GetString(2, 50),
Number = RandomGenerator.GetInt(7000000, 8000000)
};
db.Students.Add(student);
if (i % 50 == 0)
{
Console.Write(".");
db.SaveChanges();
db.Dispose();
db = new StudentSystemContext();
}
}
db.SaveChanges();
Console.WriteLine(" Completed!");
}
public void ImportMaterials(int averageMaterialsInCourse)
{
var db = new StudentSystemContext();
Console.Write("Importing Materials");
var courseIds = db.Courses.Select(c => c.Id).ToList();
var counter = 0;
foreach (var id in courseIds)
{
var numberOfMaterialsForCurrentCourse = RandomGenerator
.GetInt(averageMaterialsInCourse - 5, averageMaterialsInCourse + 5);
for (int j = 0; j < numberOfMaterialsForCurrentCourse; j++)
{
var material = new Material()
{
Name = RandomGenerator.GetString(10, 80),
Content = RandomGenerator.GetString(100, 3000),
CourseId = id
};
db.Materials.Add(material);
counter++;
}
if (counter > 100)
{
Console.Write(".");
db.SaveChanges();
db.Dispose();
db = new StudentSystemContext();
counter = 0;
}
}
db.SaveChanges();
Console.WriteLine(" Completed!");
}
public void ImportHomeWorks(int numberOfHomeworks)
{
Console.Write("Importing Homework");
var db = new StudentSystemContext();
var studentIds = db.Students.Select(s => s.Id).ToList();
var studentsCount = studentIds.Count();
var counter = 0;
while (numberOfHomeworks > 0)
{
var student = db.Students.Find(studentIds[RandomGenerator.GetInt(0, studentsCount - 1)]);
if (student != null && student.Courses.Count != 0)
{
var homework = new Homework()
{
Content = RandomGenerator.GetString(20, 1000),
TimeSent = RandomGenerator.GetDate(new DateTime(2014, RandomGenerator.GetInt(1, 12), RandomGenerator.GetInt(1, 28)), DateTime.Now)
};
student.Homeworks.Add(homework);
var studentCoursesIds = student.Courses.Select(c => c.Id).ToList();
db.Courses.Find(studentCoursesIds[RandomGenerator.GetInt(0, studentCoursesIds.Count - 1)]).Homeworks.Add(homework);
counter++;
numberOfHomeworks--;
}
if (counter > 100)
{
db.SaveChanges();
db.Dispose();
db = new StudentSystemContext();
Console.Write(".");
counter = 0;
}
}
db.SaveChanges();
Console.WriteLine(" Completed!");
}
internal static void Main()
{
var db = new StudentSystemContext();
db.Database.Delete();
db.Database.Create();
// Add students
Console.Write("\nAdding students");
for (int i = 0; i < 10000; i++)
{
db.Students.Add(
new Student()
{
Name = RandomGenerator.RandomString(RandomGenerator.RandomInt(2, 50)),
Number = RandomGenerator.RandomInt(1, 1000000)
});
if (i % 250 == 0)
{
Console.Write(".");
db.SaveChanges();
db.Dispose();
db = new StudentSystemContext();
}
}
// Add courses
Console.Write("\nAdding courses");
for (int i = 0; i < 10000; i++)
{
db.Courses.Add(
new Course()
{
Name = RandomGenerator.RandomString(RandomGenerator.RandomInt(2, 100)),
Description = RandomGenerator.RandomString(RandomGenerator.RandomInt(20, 1000))
});
if (i % 250 == 0)
{
Console.Write(".");
db.SaveChanges();
db.Dispose();
db = new StudentSystemContext();
}
}
// Get all student and courses ids
var studentIds = db.Students.Select(x => x.Id).ToList();
var courseIds = db.Courses.Select(x => x.Id).ToList();
// Add homeworks
Console.Write("\nAdding homeworks");
for (int i = 0; i < 10000; i++)
{
db.Homeworks.Add(
new Homework()
{
Content = RandomGenerator.RandomString(RandomGenerator.RandomInt(20, 1000)),
TimeSpendMinutes = RandomGenerator.RandomInt(5, 500),
StudentId = studentIds[RandomGenerator.RandomInt(0, studentIds.Count)],
CourseId = courseIds[RandomGenerator.RandomInt(0, courseIds.Count)]
});
if (i % 250 == 0)
{
Console.Write(".");
db.SaveChanges();
db.Dispose();
db = new StudentSystemContext();
}
}
}
