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