public List <Lesson> getAllLesson() { using (var SC = new DAL.Model.MVC_Sc()) { var lesson = SC.Lessons.ToList(); return(lesson); } }
public List <Student> getStudentLessonbyStudentId(int id) { using (var SC = new DAL.Model.MVC_Sc()) { var stLesson = SC.Students.Include("StudentLessons").Include("StudentLessons.Lesson").Where(x => x.Id == id).ToList(); return(stLesson); } }
public List <Class> getAllClass() { using (var SC = new DAL.Model.MVC_Sc()) { var clas = SC.Classes.ToList(); return(clas); } }
public List <Teacher> getAllTeacher() { using (var SC = new DAL.Model.MVC_Sc()) { var teacher = SC.Teachers.ToList(); return(teacher); } }
public List <Teacher> getTeacherLesson(int id) { using (var SC = new DAL.Model.MVC_Sc()) { var Lessonteacher = SC.Teachers.Include("TeacherLessons").Include("TeacherLessons.Lesson").Where(z => z.Id == id).ToList(); return(Lessonteacher); } }
public Student getStudentbyId(int id) { using (var SC = new DAL.Model.MVC_Sc()) { var student = SC.Students.FirstOrDefault(x => x.Id == id); return(student); } }
public List <Student> getAllStudent() { using (var SC = new DAL.Model.MVC_Sc()) { var studentList = SC.Students.ToList(); return(studentList); } }
public List <Class> ClassStudent(int id) { using (var SC = new DAL.Model.MVC_Sc()) { var ClassStudent = SC.Classes.Include("StudentClasses").Include("StudentClasses.Student").Where(x => x.Id == id).ToList(); return(ClassStudent); } }
public List <Lesson> getLessonTeacher(int id) { using (var SC = new DAL.Model.MVC_Sc()) { var Lessonteacher = SC.Lessons.Include("TeacherLessons").Include("TeacherLessons.Teacher").Where(x => x.Id == id).ToList(); return(Lessonteacher); } }
public bool CreateLesson(string lname) { using (var SC = new DAL.Model.MVC_Sc()) { Lesson S = new Lesson(); S.LessonName = lname; SC.Lessons.Add(S); SC.SaveChanges(); return(true); } }
public bool CreateClass(string cname) { using (var SC = new DAL.Model.MVC_Sc()) { Class C = new Class(); C.Name = cname; SC.Classes.Add(C); SC.SaveChanges(); return(true); } }
public bool CreateTeacher(string tname) { using (var SC = new DAL.Model.MVC_Sc()) { Teacher T = new Teacher(); T.Name = tname; SC.Teachers.Add(T); SC.SaveChanges(); return(true); } }
public Student addStudent(string name, string surname) { using (var SC = new DAL.Model.MVC_Sc()) { Student S = new Student(); S.Name = name; S.Surname = surname; S = SC.Students.Add(S); SC.SaveChanges(); return(S); } }
public bool CreateStudent(string name, string surname, string clas) { using (var SC = new DAL.Model.MVC_Sc()) { Student S = new Student(); S = addStudent(name, surname); var C = SC.Classes.Where(z => z.Name == clas).FirstOrDefault(); StudentClass SClas = new StudentClass(); SClas.ClassId = C.Id; SClas.StudentId = S.Id; SC.StudentClasses.Add(SClas); SC.SaveChanges(); return(true); } }
public bool addTeacherLessons(int name, int lname) { using (var SC = new DAL.Model.MVC_Sc()) { var cek = SC.TeacherLessons.Where(x => x.TeacherId == lname).Where(x => x.LessonId == lname).FirstOrDefault(); if (cek == null) { TeacherLesson sl = new TeacherLesson(); sl.LessonId = lname; sl.TeacherId = name; SC.TeacherLessons.Add(sl); SC.SaveChanges(); return(true); } return(false); } }
public bool addTeacherClass(int name, int cname) { using (var SC = new DAL.Model.MVC_Sc()) { var cek = SC.TeacherClasses.Where(x => x.TeacherId == name).Where(x => x.ClassId == cname).FirstOrDefault(); if (cek == null) { TeacherClass tc = new TeacherClass(); tc.ClassId = cname; tc.TeacherId = name; SC.TeacherClasses.Add(tc); SC.SaveChanges(); return(true); } return(false); } }
// GET: School public ActionResult Index() { try { using (var SC = new DAL.Model.MVC_Sc()) { Models.SchoolModel SM = new Models.SchoolModel(); Ws.WebService1 ws = new Ws.WebService1(); var DB = DAL.SchoolDB.getInstance(); var studentListWs = ws.getAllStudent(); List <Models.Student> S = new List <Models.Student>(); foreach (var item in studentListWs) { S.Add(new Models.Student { Id = item.Id, Name = item.Name, Surname = item.Surname }); } SM.St = S; var Lesson = DB.getAllLesson(); List <Models.Lesson> L = new List <Models.Lesson>(); foreach (var item in Lesson) { L.Add (new Models.Lesson { Id = item.Id, Name = item.LessonName }); } SM.Ls = L; var Class = DB.getAllClass(); List <Models.Class> C = new List <Models.Class>(); foreach (var item in Class) { C.Add(new Models.Class { Id = item.Id, Name = item.Name } ); } SM.C = C; var Teacher = DB.getAllTeacher(); List <Models.Teacher> t = new List <Models.Teacher>(); foreach (var item in Teacher) { t.Add(new Models.Teacher { Id = item.Id, Name = item.Name } ); } SM.Tc = t; return(View(SM)); } } catch (Exception) { throw; } }