public static void AddSubjects(MarksContext db)
{
if (!db.Subjects.Any())
{
List <string> teachers = new List <string>();
List <Subject> subjects = new List <Subject>();
teachers.Add("Горячковская Анна Николаевна");
teachers.Add("Мазурова Оксана Валерьевна");
teachers.Add("Валенда Наталья Анатольевна");
teachers.Add("Лановой Алексей Феликсович");
teachers.Add("Мельникова Роксана Валерьевна");
teachers.Add("Бабий Андрей Степанович");
subjects.Add(new Subject
{
Abbreviation = "Фил",
Course = 2,
Credits = 5,
Name = "Философия",
Teacher = teachers[0]
});
subjects.Add(new Subject
{
Abbreviation = "БД",
Course = 2,
Credits = 5,
Name = "Базы данных",
Teacher = teachers[1]
});
subjects.Add(new Subject
{
Abbreviation = "ОИГ",
Course = 2,
Credits = 5,
Name = "Основы игровой графики",
Teacher = teachers[2]
});
subjects.Add(new Subject
{
Abbreviation = "АКОКС",
Course = 2,
Credits = 5,
Name = "Архитектура компьютера и организация компьютерных сетей",
Teacher = teachers[3]
});
subjects.Add(new Subject
{
Abbreviation = "ЧМВ",
Course = 2,
Credits = 5,
Name = "Человеко-машинное взаимодействие",
Teacher = teachers[4]
});
subjects.Add(new Subject
{
Abbreviation = "ТВМСиЭМПИ",
Course = 2,
Credits = 5,
Name = "Теория вероятностейб математическая статистика и эмпирические методы программной инженерии",
Teacher = teachers[5]
});
subjects.Add(new Subject
{
Abbreviation = "БД (курс)",
Course = 2,
Credits = 5,
Name = "Базы данных (курсовой проект)",
Teacher = teachers[1]
});
db.Subjects.AddRange(subjects);
db.SaveChanges();
}
}
public static void AddMarks(MarksContext db)
{
if (!db.Marks.Any())
{
Student st = db.Students.ToList().Find(x => x.Name.Contains("Шопинський"));
Student st2 = db.Students.ToList().Find(x => x.Name.Contains("Майборода Володимир"));
Student st3 = db.Students.ToList().Find(x => x.Name.Contains("Надточій Євген"));
Semester sem = db.Semesters.First();
List <Subject> subj = db.Subjects.ToList();
List <Mark> marks = new List <Mark>();
marks.Add(new Mark
{
Value = 96,
Student = st,
Semester = sem,
Subject = subj[0]
});
marks.Add(new Mark
{
Value = 96,
Student = st,
Semester = sem,
Subject = subj[1]
});
marks.Add(new Mark
{
Value = 96,
Student = st,
Semester = sem,
Subject = subj[2]
});
marks.Add(new Mark
{
Value = 98,
Student = st,
Semester = sem,
Subject = subj[3]
});
marks.Add(new Mark
{
Value = 96,
Student = st,
Semester = sem,
Subject = subj[4]
});
marks.Add(new Mark
{
Value = 98,
Student = st,
Semester = sem,
Subject = subj[5]
});
marks.Add(new Mark
{
Value = 100,
Student = st,
Semester = sem,
Subject = subj[6]
});
//
marks.Add(new Mark
{
Value = 88,
Student = st2,
Semester = sem,
Subject = subj[0]
});
marks.Add(new Mark
{
Value = 92,
Student = st2,
Semester = sem,
Subject = subj[1]
});
marks.Add(new Mark
{
Value = 90,
Student = st2,
Semester = sem,
Subject = subj[2]
});
marks.Add(new Mark
{
Value = 90,
Student = st2,
Semester = sem,
Subject = subj[3]
});
marks.Add(new Mark
{
Value = 75,
Student = st2,
Semester = sem,
Subject = subj[4]
});
marks.Add(new Mark
{
Value = 95,
Student = st2,
Semester = sem,
Subject = subj[5]
});
marks.Add(new Mark
{
Value = 96,
Student = st2,
Semester = sem,
Subject = subj[6]
});
//
marks.Add(new Mark
{
Value = 72,
Student = st3,
Semester = sem,
Subject = subj[0]
});
marks.Add(new Mark
{
Value = 90,
Student = st3,
Semester = sem,
Subject = subj[1]
});
marks.Add(new Mark
{
Value = 92,
Student = st3,
Semester = sem,
Subject = subj[3]
});
marks.Add(new Mark
{
Value = 65,
Student = st3,
Semester = sem,
Subject = subj[4]
});
marks.Add(new Mark
{
Value = 84,
Student = st3,
Semester = sem,
Subject = subj[5]
});
marks.Add(new Mark
{
Value = 88,
Student = st3,
Semester = sem,
Subject = subj[6]
});
db.Marks.AddRange(marks);
db.SaveChanges();
}
}
public static void FillDbFromPDF(MarksContext context)
{
if (!context.Students.Any())
{
Semester sem1 = new Semester
{
Season = "Осінь",
Year = 2016
};
Semester sem2 = new Semester
{
Season = "Весна",
Year = 2017
};
context.Semesters.AddRange(sem1, sem2);
context.SaveChanges();
string[] dirs = Directory.GetDirectories("wwwroot\\pdf");
var students = new List <Student>();
var groups = new List <Group>();
var ratings = new List <Rating>();
for (int k = 0; k < dirs.Length; k++)
{
string[] paths = Directory.GetFiles(dirs[k]);
for (int i = 0; i < paths.Length; i++)
{
PDFParser parser = new PDFParser(paths[i]);
List <Group> listg = parser.Groups;
List <StudentData> list = parser.Students;
context.Groups.AddRange(listg);
context.SaveChanges();
for (int j = 0; j < list.Count; j++)
{
Student s = new Student
{
Name = list[j].Name,
Group = context.Groups.First(p => p.Name == list[j].Group),
IsBudgetary = list[j].Info == "контракт" ? false : true
};
students.Add(s);
Rating r = new Rating
{
Student = s,
Semester = sem1,
Value = list[j].Rating,
Bonus = 0,
Note = list[j].Info
};
ratings.Add(r);
}
}
}
context.Students.AddRange(students);
context.Ratings.AddRange(ratings);
context.SaveChanges();
}
}