public static void PostListOfAttendenceState(List <AttendenceViewModel> attendenceViewModel)
{
using (var context = new FinalSchool())
{
var CN = attendenceViewModel[0].CourseName;
var courseAtt = context.Courses.FirstOrDefault(x => x.Name == CN);
var te = attendenceViewModel[0].TeacherSNN;
Teacher teacher = context.Teachers.FirstOrDefault(x => x.TeacherId == te);
var session = new Session
{
CourseId = courseAtt.CourseId,
StartDate = DateTime.Now,
TeacherId = teacher.TeacherId,
};
context.Sessions.Add(session);
context.SaveChanges();
foreach (var item in attendenceViewModel)
{
var attendence = new Attendence()
{
StudentId = item.StudentSNN,
IsAttended = item.IsAttended,
SessionId = session.SessionId,
};
context.Attendences.Add(attendence);
}
context.SaveChanges();
}
}
public static void ChangeAttendenceState(AttendenceViewModel attendenceViewModel)
{
using (var context = new FinalSchool())
{
var studentAtt = context.Students.FirstOrDefault(x => x.StudentId == attendenceViewModel.StudentSNN);
var courseAtt = context.Courses.FirstOrDefault(x => x.Name == attendenceViewModel.CourseName);
var teacher = context.Teachers.FirstOrDefault(x => x.FName == attendenceViewModel.TeacherName);
var session = new Session
{
Course = courseAtt,
CourseId = courseAtt.CourseId,
StartDate = DateTime.Now,
Teacher = teacher,
TeacherId = teacher.TeacherId,
};
context.Sessions.Add(session);
context.SaveChanges();
var attendence = new Attendence()
{
Student = studentAtt,
StudentId = studentAtt.StudentId,
IsAttended = attendenceViewModel.IsAttended,
Session = session,
SessionId = session.SessionId,
};
context.Attendences.Add(attendence);
context.SaveChanges();
}
}
public static string Edit(StudentViewModel studentViewModel)
{
using (var context = new FinalSchool())
{
var classroom = context.ClassRooms.FirstOrDefault(x => x.Name == studentViewModel.ClassName);
var level = context.Levels.FirstOrDefault(x => x.Name == studentViewModel.LevelName);
var student = context.Students.FirstOrDefault(ww => ww.StudentId == studentViewModel.StudentSNN);
student.Age = studentViewModel.Age;
student.City = studentViewModel.City;
student.Email = studentViewModel.Email;
student.FName = studentViewModel.FName;
student.Gender = studentViewModel.Gender;
student.LName = studentViewModel.LName;
student.Street = studentViewModel.Street;
student.StudentId = studentViewModel.StudentSNN;
student.Phone = studentViewModel.Phone;
student.ClassRoom = classroom;
student.ClassRoom.Level = level;
student.Password = studentViewModel.Password;
var parent = new Parent()
{
FName = studentViewModel.ParentFName,
LName = studentViewModel.LName,
};
context.Parents.Add(parent);
context.SaveChanges();
student.Parent = parent;
context.SaveChanges();
return(student.StudentId);
}
}
public static void PostOne(TeacherViewModel teacherModel)
{
using (var context = new FinalSchool())
{
var teacher = new Teacher()
{
TeacherId = teacherModel.TeacherSNN,
FName = teacherModel.FName,
Age = teacherModel.Age,
City = teacherModel.City,
Street = teacherModel.Street,
LName = teacherModel.LName,
Email = teacherModel.Email,
Gender = teacherModel.Gender,
Password = teacherModel.Password,
Phone = teacherModel.Phone,
};
context.Teachers.Add(teacher);
foreach (var item in teacherModel.CourseName)
{
var CourseId = context.Courses.FirstOrDefault(w => w.Name == item).CourseId;
var teacherCourse = new TeacherCourse()
{
TeacherId = teacher.TeacherId,
CourseId = CourseId
};
context.TeacherCourses.Add(teacherCourse);
}
context.SaveChanges();
}
}
public static string Create(StudentViewModel studentViewModel)
{
using (var context = new FinalSchool())
{
var classRoomStudent = context.ClassRooms.FirstOrDefault(x => x.Name == studentViewModel.ClassName);
var stulevel = context.Levels.FirstOrDefault(x => x.Name == studentViewModel.LevelName);
var studentParent = new Parent()
{
FName = studentViewModel.ParentFName,
LName = studentViewModel.ParentLName,
ParentSNN = studentViewModel.ParentSNN,
};
var student = new Student()
{
Age = studentViewModel.Age,
City = studentViewModel.City,
Email = studentViewModel.Email,
FName = studentViewModel.FName,
Gender = studentViewModel.Gender,
LName = studentViewModel.LName,
Street = studentViewModel.Street,
StudentId = studentViewModel.StudentSNN,
Phone = studentViewModel.Phone,
Parent = studentParent,
ClassRoom = classRoomStudent,
Password = studentViewModel.Password
};
student.ClassRoom.Level = stulevel;
context.Students.Add(student);
context.SaveChanges();
return(student.StudentId);
}
}
public static void PutOne(TeacherViewModel teacherModel)
{
using (var context = new FinalSchool())
{
var id = teacherModel.TeacherSNN;
foreach (var item in teacherModel.CourseName)
{
var CourseId = context.Courses.FirstOrDefault(w => w.Name == item).CourseId;
var teacherCourse = context.TeacherCourses.Find(id);
teacherCourse.TeacherId = id;
teacherCourse.CourseId = CourseId;
}
var teacher = context.Teachers.FirstOrDefault(x => x.TeacherId == teacherModel.TeacherSNN);
teacher.TeacherId = teacherModel.TeacherSNN;
teacher.FName = teacherModel.FName;
teacher.Email = teacherModel.Email;
teacher.Password = teacherModel.Password;
teacher.LName = teacherModel.LName;
teacher.Gender = teacherModel.Gender;
teacher.Street = teacherModel.Street;
teacher.City = teacherModel.City;
teacher.Phone = teacherModel.Phone;
teacher.Age = teacherModel.Age;
context.SaveChanges();
}
}
public static void Delete(string id)
{
using (var context = new FinalSchool())
{
context.Students.Remove(context.Students.Find(id));
context.SaveChanges();
}
}
public static void DeleteOne(int id)
{
using (var context = new FinalSchool())
{
var exam = context.Exams.Find(id);
context.Exams.Remove(exam);
context.SaveChanges();
}
}
public static void DeleteOne(string id)
{
using (var context = new FinalSchool())
{
var teacher = context.Teachers.Find(id);
context.Teachers.Remove(teacher);
context.SaveChanges();
}
}
public static void DeleteOne(int id)
{
using (var context = new FinalSchool())
{
var level = context.Levels.Find(id);
context.Levels.Remove(level);
context.SaveChanges();
}
}
public static void DeleteOne(int id)
{
using (var context = new FinalSchool())
{
var classRoom = context.ClassRooms.Find(id);
context.ClassRooms.Remove(classRoom);
context.SaveChanges();
}
}
public static void PutOne(int id, LevelViewModel levelModel)
{
using (var context = new FinalSchool())
{
var level = context.Levels.Find(id);
level.Name = levelModel.Name;
context.SaveChanges();
}
}
public static void PutOne(CourseViewModel courseViewModel)
{
using (var context = new FinalSchool())
{
var course = context.Courses.FirstOrDefault(w => w.CourseId == courseViewModel.CourseId);
var level = context.Levels.FirstOrDefault(x => x.Name == courseViewModel.LevelName);
course.Name = courseViewModel.Name;
course.LevelId = level.LevelId;
context.SaveChanges();
}
}
public static void PutOne(ClassRoomViewModel classRoomModel)
{
using (var context = new FinalSchool())
{
var classRoom = context.ClassRooms.Find(classRoomModel.ClassId);
classRoom.Name = classRoomModel.Name;
// classRoom.LevelId = classRoomModel.LevelId;
classRoom.ClassRoomId = classRoomModel.ClassId;
classRoom.Level.Name = classRoomModel.LevelName;
context.SaveChanges();
}
}
public static void PutOne(ExamViewModel examViewModel)
{
using (var context = new FinalSchool())
{
var courseId = context.Courses.FirstOrDefault(x => x.Name == examViewModel.CourseName).CourseId;
var exam = context.Exams.Find(examViewModel.ExamId);
exam.ExamName = examViewModel.ExamName;
exam.CourseId = courseId;
exam.MaxExamDegree = examViewModel.MaxExamDegree;
context.SaveChanges();
}
}
public static int PostOne(LevelViewModel levelModel)
{
using (var context = new FinalSchool())
{
var level = new Level()
{
Name = levelModel.Name, LevelId = levelModel.LevelId
};
context.Levels.Add(level);
context.SaveChanges();
return(level.LevelId);
}
}
public static int DeleteOne(int id)
{
using (var context = new FinalSchool())
{
var course = context.Courses.Find(id);
if (course != null)
{
context.Courses.Remove(course);
context.SaveChanges();
}
return(course.CourseId);
}
}
public static int PostOne(CourseViewModel courseViewModel)
{
using (var context = new FinalSchool())
{
var level = context.Levels.FirstOrDefault(x => x.Name == courseViewModel.LevelName);
var course = new Course()
{
Name = courseViewModel.Name,
LevelId = level.LevelId
};
context.Courses.Add(course);
context.SaveChanges();
return(course.CourseId);
}
}
public static int PostOne(ExamViewModel examViewModel)
{
using (var context = new FinalSchool())
{
var courseId = context.Courses.FirstOrDefault(w => w.Name == examViewModel.CourseName).CourseId;
var exam = new Exam()
{
ExamName = examViewModel.ExamName,
MaxExamDegree = examViewModel.MaxExamDegree,
CourseId = courseId,
};
context.Exams.Add(exam);
context.SaveChanges();
return(exam.ExamId);
}
}
public static int PostOne(ClassRoomViewModel classRoomModel)
{
using (var context = new FinalSchool())
{
var levelId = context.Levels.FirstOrDefault(x => x.Name == classRoomModel.LevelName).LevelId;
var classRoom = new ClassRoom()
{
Name = classRoomModel.Name,
LevelId = levelId,
ClassRoomId = classRoomModel.ClassId,
};
context.ClassRooms.Add(classRoom);
context.SaveChanges();
return(classRoom.ClassRoomId);
}
}
public static void Create(List <ResultViewModel> resultViewModels)
{
int examId = resultViewModels[0].ExamId;
var results = new List <Result>();
foreach (var res in resultViewModels)
{
var result = new Result
{
ExamId = examId,
StudentId = res.StudentId,
StudentResult = res.StudentResult
};
results.Add(result);
}
using (var context = new FinalSchool())
{
context.Results.AddRange(results);
context.SaveChanges();
}
}