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