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!");
}
