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