public GroupsInFaculty AddGroupsInFaculty(GroupsInFaculty groupsInFaculty)
{
using (var context = new ScheduleContext(ConnectionString))
{
groupsInFaculty.GroupsInFacultyId = 0;
groupsInFaculty.StudentGroup = context.StudentGroups.FirstOrDefault(gif => gif.StudentGroupId == groupsInFaculty.StudentGroup.StudentGroupId);
groupsInFaculty.Faculty = context.Faculties.FirstOrDefault(gif => gif.FacultyId == groupsInFaculty.Faculty.FacultyId);
context.GroupsInFaculties.Add(groupsInFaculty);
context.SaveChanges();
return groupsInFaculty;
}
}
public ConfigOption FindConfigOption(string key)
{
using (var context = new ScheduleContext(ConnectionString))
{
return context.Config.FirstOrDefault(op => op.Key == key);
}
}
public Faculty FindFaculty(string name)
{
using (var context = new ScheduleContext(ConnectionString))
{
return context.Faculties.FirstOrDefault(f => f.Name == name);
}
}
public void ClearAllExams()
{
using (var context = new ScheduleContext(ConnectionString))
{
var examIds = context.Exams.Select(e => e.ExamId).ToList();
foreach (var examId in examIds)
{
RemoveExam(examId);
}
}
}
public Auditorium FindAuditorium(string name)
{
using (var context = new ScheduleContext(ConnectionString))
{
return context.Auditoriums.FirstOrDefault(a => a.Name == name);
}
}
public Teacher AddTeacher(Teacher teacher)
{
using (var context = new ScheduleContext(ConnectionString))
{
teacher.TeacherId = 0;
context.Teachers.Add(teacher);
context.SaveChanges();
return teacher;
}
}
public void AddTeacherForDisciplineRange(IEnumerable<TeacherForDiscipline> teacherForDisciplineList)
{
using (var context = new ScheduleContext(ConnectionString))
{
foreach (var teacherForDiscipline in teacherForDisciplineList)
{
teacherForDiscipline.TeacherForDisciplineId = 0;
context.TeacherForDiscipline.Add(teacherForDiscipline);
}
context.SaveChanges();
}
}
public Lesson AddLessonWOLog(Lesson lesson)
{
using (var context = new ScheduleContext(ConnectionString))
{
lesson.LessonId = 0;
lesson.TeacherForDiscipline = context.TeacherForDiscipline.FirstOrDefault(tfd => tfd.TeacherForDisciplineId == lesson.TeacherForDiscipline.TeacherForDisciplineId);
lesson.Calendar = context.Calendars.FirstOrDefault(c => c.CalendarId == lesson.Calendar.CalendarId);
lesson.Ring = context.Rings.FirstOrDefault(r => r.RingId == lesson.Ring.RingId);
lesson.Auditorium = context.Auditoriums.FirstOrDefault(a => a.AuditoriumId == lesson.Auditorium.AuditoriumId);
context.Lessons.Add(lesson);
context.SaveChanges();
return lesson;
}
}
public LogEvent AddLogEvent(LogEvent logEvent)
{
using (var context = new ScheduleContext(ConnectionString))
{
logEvent.OldExam = context.Exams.FirstOrDefault(e => e.ExamId == logEvent.OldExam.ExamId);
logEvent.NewExam = context.Exams.FirstOrDefault(e => e.ExamId == logEvent.NewExam.ExamId);
context.EventLog.Add(logEvent);
context.SaveChanges();
return logEvent;
}
}
public void AddLessonLogEventRange(IEnumerable<LessonLogEvent> lessonLogEventList)
{
using (var context = new ScheduleContext(ConnectionString))
{
foreach (var lessonLogEvent in lessonLogEventList)
{
lessonLogEvent.LessonLogEventId = 0;
lessonLogEvent.OldLesson = context.Lessons.FirstOrDefault(l => l.LessonId == lessonLogEvent.OldLesson.LessonId);
lessonLogEvent.NewLesson = context.Lessons.FirstOrDefault(l => l.LessonId == lessonLogEvent.NewLesson.LessonId);
context.LessonLog.Add(lessonLogEvent);
}
context.SaveChanges();
}
}
public void AddLessonRange(IEnumerable<Lesson> lessonList)
{
using (var context = new ScheduleContext(ConnectionString))
{
foreach (var lesson in lessonList)
{
lesson.LessonId = 0;
lesson.TeacherForDiscipline = context.TeacherForDiscipline.FirstOrDefault(tfd => tfd.TeacherForDisciplineId == lesson.TeacherForDiscipline.TeacherForDisciplineId);
lesson.Calendar = context.Calendars.FirstOrDefault(c => c.CalendarId == lesson.Calendar.CalendarId);
lesson.Ring = context.Rings.FirstOrDefault(r => r.RingId == lesson.Ring.RingId);
lesson.Auditorium = context.Auditoriums.FirstOrDefault(a => a.AuditoriumId == lesson.Auditorium.AuditoriumId);
context.Lessons.Add(lesson);
}
context.SaveChanges();
}
}
public LessonLogEvent AddLessonLogEvent(LessonLogEvent lessonLogEvent)
{
using (var context = new ScheduleContext(ConnectionString))
{
lessonLogEvent.LessonLogEventId = 0;
lessonLogEvent.OldLesson = (lessonLogEvent.OldLesson == null) ? null : context.Lessons.FirstOrDefault(l => l.LessonId == lessonLogEvent.OldLesson.LessonId);
lessonLogEvent.NewLesson = (lessonLogEvent.NewLesson == null) ? null : context.Lessons.FirstOrDefault(l => l.LessonId == lessonLogEvent.NewLesson.LessonId);
context.LessonLog.Add(lessonLogEvent);
context.SaveChanges();
return lessonLogEvent;
}
}
public Lesson AddLesson(Lesson lesson, string publicComment = "", string hiddenComment = "")
{
using (var context = new ScheduleContext(ConnectionString))
{
lesson.LessonId = 0;
lesson.TeacherForDiscipline = context.TeacherForDiscipline.FirstOrDefault(tfd => tfd.TeacherForDisciplineId == lesson.TeacherForDiscipline.TeacherForDisciplineId);
lesson.Calendar = context.Calendars.FirstOrDefault(c => c.CalendarId == lesson.Calendar.CalendarId);
lesson.Ring = context.Rings.FirstOrDefault(r => r.RingId == lesson.Ring.RingId);
lesson.Auditorium = context.Auditoriums.FirstOrDefault(a => a.AuditoriumId == lesson.Auditorium.AuditoriumId);
context.Lessons.Add(lesson);
context.LessonLog.Add(
new LessonLogEvent
{
OldLesson = null,
NewLesson = lesson,
DateTime = DateTime.Now,
PublicComment = publicComment,
HiddenComment = hiddenComment
}
);
context.SaveChanges();
return lesson;
}
}
public void AddGroupsInFacultyRange(IEnumerable<GroupsInFaculty> groupsInFacultiesList)
{
using (var context = new ScheduleContext(ConnectionString))
{
foreach (var groupsInFaculty in groupsInFacultiesList)
{
groupsInFaculty.GroupsInFacultyId = 0;
groupsInFaculty.StudentGroup = context.StudentGroups.FirstOrDefault(gif => gif.StudentGroupId == groupsInFaculty.StudentGroup.StudentGroupId);
groupsInFaculty.Faculty = context.Faculties.FirstOrDefault(gif => gif.FacultyId == groupsInFaculty.Faculty.FacultyId);
context.GroupsInFaculties.Remove(groupsInFaculty);
}
context.SaveChanges();
}
}
public StudentsInGroups AddStudentsInGroups(StudentsInGroups studentsInGroups)
{
using (var context = new ScheduleContext(ConnectionString))
{
studentsInGroups.StudentsInGroupsId = 0;
studentsInGroups.Student = context.Students.FirstOrDefault(s => s.StudentId == studentsInGroups.Student.StudentId);
studentsInGroups.StudentGroup = context.StudentGroups.FirstOrDefault(sg => sg.StudentGroupId == studentsInGroups.StudentGroup.StudentGroupId);
context.StudentsInGroups.Add(studentsInGroups);
context.SaveChanges();
return studentsInGroups;
}
}
public Ring AddRing(Ring ring)
{
using (var context = new ScheduleContext(ConnectionString))
{
ring.RingId = 0;
context.Rings.Add(ring);
context.SaveChanges();
return ring;
}
}
public void AddStudentsInGroupsRange(IEnumerable<StudentsInGroups> studentsInGroupsList)
{
using (var context = new ScheduleContext(ConnectionString))
{
foreach (var studentsInGroups in studentsInGroupsList)
{
studentsInGroups.StudentsInGroupsId = 0;
context.StudentsInGroups.Add(studentsInGroups);
}
context.SaveChanges();
}
}
public void AddRingRange(IEnumerable<Ring> ringList)
{
using (var context = new ScheduleContext(ConnectionString))
{
foreach (var ring in ringList)
{
ring.RingId = 0;
context.Rings.Add(ring);
}
context.SaveChanges();
}
}
public TeacherForDiscipline AddTeacherForDiscipline(TeacherForDiscipline teacherForDiscipline)
{
using (var context = new ScheduleContext(ConnectionString))
{
teacherForDiscipline.TeacherForDisciplineId = 0;
teacherForDiscipline.Teacher = context.Teachers.FirstOrDefault(t => t.TeacherId == teacherForDiscipline.Teacher.TeacherId);
teacherForDiscipline.Discipline = context.Disciplines.FirstOrDefault(d => d.DisciplineId == teacherForDiscipline.Discipline.DisciplineId);
context.TeacherForDiscipline.Add(teacherForDiscipline);
context.SaveChanges();
return teacherForDiscipline;
}
}
public ScheduleNote AddScheduleNote(ScheduleNote sNote)
{
using (var context = new ScheduleContext(ConnectionString))
{
sNote.ScheduleNoteId = 0;
sNote.Lesson.TeacherForDiscipline = context.TeacherForDiscipline.FirstOrDefault(tfd => tfd.TeacherForDisciplineId == sNote.Lesson.TeacherForDiscipline.TeacherForDisciplineId);
sNote.Lesson.Calendar = context.Calendars.FirstOrDefault(c => c.CalendarId == sNote.Lesson.Calendar.CalendarId);
sNote.Lesson.Ring = context.Rings.FirstOrDefault(r => r.RingId == sNote.Lesson.Ring.RingId);
sNote.Lesson.Auditorium = context.Auditoriums.FirstOrDefault(a => a.AuditoriumId == sNote.Lesson.Auditorium.AuditoriumId);
context.ScheduleNotes.Add(sNote);
context.SaveChanges();
return sNote;
}
}
public void AddTeacherRange(IEnumerable<Teacher> teacherList)
{
using (var context = new ScheduleContext(ConnectionString))
{
foreach (var teacher in teacherList)
{
teacher.TeacherId = 0;
context.Teachers.Add(teacher);
}
context.SaveChanges();
}
}
public void AddScheduleNoteRange(IEnumerable<ScheduleNote> scheduleNoteList)
{
using (var context = new ScheduleContext(ConnectionString))
{
foreach (var sNote in scheduleNoteList)
{
sNote.ScheduleNoteId = 0;
context.ScheduleNotes.Add(sNote);
}
context.SaveChanges();
}
}
public void ClearExamLogs()
{
using (var context = new ScheduleContext(ConnectionString))
{
var logIds = context.EventLog.Select(le => le.LogEventId).ToList();
foreach (var logId in logIds)
{
RemoveLogEvent(logId);
}
}
}
public Student AddStudent(Student student)
{
using (var context = new ScheduleContext(ConnectionString))
{
student.StudentId = 0;
context.Students.Add(student);
context.SaveChanges();
return student;
}
}
public Calendar FindCalendar(DateTime date)
{
using (var context = new ScheduleContext(ConnectionString))
{
return context.Calendars.FirstOrDefault(c => c.Date == date);
}
}
public StudentGroup AddStudentGroup(StudentGroup studentGroup)
{
using (var context = new ScheduleContext(ConnectionString))
{
studentGroup.StudentGroupId = 0;
context.StudentGroups.Add(studentGroup);
context.SaveChanges();
return studentGroup;
}
}
public Discipline FindDiscipline(string name, int semester, int attestation, int auditoriumHours, int lectureHours, int practicalHours, string groupName)
{
using (var context = new ScheduleContext(ConnectionString))
{
return context.Disciplines.Include(d => d.StudentGroup).FirstOrDefault(
d => d.Name == name &&
d.Semester == semester &&
d.Attestation == attestation &&
d.AuditoriumHours == auditoriumHours &&
d.LectureHours == lectureHours &&
d.PracticalHours == practicalHours &&
d.StudentGroup.Name == groupName);
}
}
public void AddStudentRange(IEnumerable<Student> studentList)
{
using (var context = new ScheduleContext(ConnectionString))
{
foreach (var student in studentList)
{
student.StudentId = 0;
context.Students.Add(student);
}
context.SaveChanges();
}
}
public GroupsInFaculty FindGroupsInFaculty(StudentGroup sg, Faculty f)
{
using (var context = new ScheduleContext(ConnectionString))
{
return context.GroupsInFaculties
.Include(gif => gif.StudentGroup)
.Include(gif => gif.Faculty)
.FirstOrDefault(gif => gif.StudentGroup.StudentGroupId == sg.StudentGroupId &&
gif.Faculty.FacultyId == f.FacultyId);
}
}
public void AddFacultyRange(IEnumerable<Faculty> facultyList)
{
using (var context = new ScheduleContext(ConnectionString))
{
foreach (var faculty in facultyList)
{
faculty.FacultyId = 0;
context.Faculties.Add(faculty);
}
context.SaveChanges();
}
}