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(); } }