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 static void AddResource(string name, string link, ResourceType resourceType = ResourceType.Other) { using (var db = new StudentSystemContext()) { db.Resources.Add(new Resource { Name = name, Link = link, ResourceTypes = resourceType }); db.SaveChanges(); } }
public static void AddHomework(string contentUrl, FileType fileType, DateTime date) { using (var db = new StudentSystemContext()) { db.Homeworks.Add(new Homework { ContentUrl = contentUrl, FileType = fileType, Date = date }); db.SaveChanges(); } }
public static void AddCourse(string name, string desctiption, DateTime startDate, DateTime endDate, decimal price = 0.0m) { using (var db = new StudentSystemContext()) { db.Courses.Add(new Course { Name = name, Description = desctiption, StartDate = startDate, EndDate = endDate, Price = price }); db.SaveChanges(); } }
public static void AddStudent(string firstName, string lastName, DateTime birthDate, string phoneNumber = null) { using (var db = new StudentSystemContext()) { db.Students.Add(new Student { FirstName = firstName, LastName = lastName, BirthDate = birthDate, PhoneNumber = phoneNumber, RegistrationDate = DateTime.Now }); db.SaveChanges(); } }
static void Main() { Database.SetInitializer(new MigrateDatabaseToLatestVersion<StudentSystemContext, Configuration>()); using (var db = new StudentSystemContext()) { var student = new Student { Name = "Ivan Bojinov", Number = "987654321" }; db.Students.Add(student); var course = new Course { Name = "C# Intermediate", Description = "Writing more advanced programs in C#" }; db.Courses.Add(course); db.SaveChanges(); } Console.WriteLine("Saved!"); }
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!"); }
public static void Main() { Database.SetInitializer( new MigrateDatabaseToLatestVersion <StudentSystemContext, Configuration>()); var db = new StudentSystemContext(); var student = new Student { FirstName = "Ivan", LastName = "Ivanov", Number = 13532 }; var course = new Course { Name = "JS", Description = "JS", Materials = "www.telerik" }; var homework = new Homework { Content = "Done", TimeSent = DateTime.Now, StudentId = 2, CourseId = 2 }; db.Homeworks.Add(homework); student.Courses.Add(course); db.Students.Add(student); db.Courses.Add(course); db.SaveChanges(); Console.WriteLine(db.Students.Count()); Console.WriteLine(db.Courses.Count()); }
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 StudentCoursesConnect(int averageCoursesPerStudent) { Console.WriteLine("Create students - courses relations."); var db = new StudentSystemContext(); var students = db.Students.Select(s => s).ToList(); var courses = db.Courses.Select(c => c).ToList(); var coursesCount = courses.Count(); foreach (var student in students) { var numberOfCoursesForCurrentStudent = RandomGenerator.GetInt(averageCoursesPerStudent - 5, averageCoursesPerStudent + 5); for (int i = 0; i < numberOfCoursesForCurrentStudent; i++) { student.Courses.Add(courses[RandomGenerator.GetInt(0, coursesCount - 1)]); } Console.Write("."); } db.SaveChanges(); Console.WriteLine("Student Courses relation process 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!"); }