//מחזיר את כל המורות public List <Teacher> GetTeachers() { using (HomeWorkProjectEntities2 db = new HomeWorkProjectEntities2()) { return(db.Teacher.ToList()); } }
public List <StudyGroup> GetStudyGroup() { using (HomeWorkProjectEntities2 db = new HomeWorkProjectEntities2()) { return(db.StudyGroup.ToList()); } }
//מחזיר את כל ש"ב public List <HwToStydyClassOnDate> GetHW() { using (HomeWorkProjectEntities2 db = new HomeWorkProjectEntities2()) { return(db.HwToStydyClassOnDate.ToList()); } }
//מחזיר תלמיד לפי תז public Student GetStudent(string TZ) { using (HomeWorkProjectEntities2 db = new HomeWorkProjectEntities2()) { return(db.Student.FirstOrDefault(student => student.studentTz == TZ)); } }
//מחזיר את כל התלמידים public List <Student> GetStudents() { using (HomeWorkProjectEntities2 db = new HomeWorkProjectEntities2()) { return(db.Student.ToList()); } }
//מחזיר מורה לפי שם וסיסמא public Teacher GetTeacher(string Name, string password) { using (HomeWorkProjectEntities2 db = new HomeWorkProjectEntities2()) { Teacher t = new Teacher(); t = db.Teacher.FirstOrDefault(teacher => teacher.teacherFirstName == Name && teacher.teacherPassword == password); return(t); } }
//שליפת כיתות למורה public List <string> GetStudyClassForTeacher(int teacherID) { List <string> list = new List <string>(); using (HomeWorkProjectEntities2 db = new HomeWorkProjectEntities2()) { var q = db.getListClassesForTeacher(teacherID).ToList(); foreach (var item in q) { list.Add(item); } } return(list); }
//מוסיף ש"ב public int AddHw(HwToStydyClassOnDate hw) { try { using (HomeWorkProjectEntities2 db = new HomeWorkProjectEntities2()) { db.HwToStydyClassOnDate.Add(hw); db.SaveChanges(); return(1); } } catch (Exception) { return(0); } }
//הוספת תלמידה -צריך להוסיף לכיתת לימוד public int AddStudentDAL(Student s) { using (HomeWorkProjectEntities2 db = new HomeWorkProjectEntities2()) { try { db.Student.Add(s); db.SaveChanges(); return(1); } catch (Exception) { return(0); } } }
public void AddHW(HwToStydyClassOnDate hw) { try { using (HomeWorkProjectEntities2 db = new HomeWorkProjectEntities2()) { db.HwToStydyClassOnDate.Add(hw); db.SaveChanges(); //return 1; //return teacher.id?? } } catch (Exception) { //return 0; } }
//מוסיף מורה חדשה public int AddTeacher(Teacher teacher) { try { using (HomeWorkProjectEntities2 db = new HomeWorkProjectEntities2()) { db.Teacher.Add(teacher); db.SaveChanges(); return(1); //return teacher.id?? } } catch (Exception e) { //Console.WriteLine(e); return(0); } }
//מחזיר את התלמידים וסטטוס הכנה לפי כיתה public List <StatusStudentByClass> StatusByClass(string studyGroupClass) { List <StatusStudentByClass> list = new List <StatusStudentByClass>(); using (HomeWorkProjectEntities2 db = new HomeWorkProjectEntities2()) { var q = db.StatusStudentByClass(studyGroupClass).ToList(); var q2 = db.s(studyGroupClass).ToList(); foreach (var item in q2) { StatusStudentByClass status = new StatusStudentByClass(); status.StudentId = item.studentId; status.StudentFirstName = item.studentFirstName; status.StudentLastName = item.studentLastName; status.StatusOfPreparation = (bool)item.statusOfPreparation; //status.StudyGroupClass = item.studyGroupClass; list.Add(status); } } return(list); }
//מחזיר את התלמידים וסטטוס הכנה לפי מקצוע public List <StatusesStudentHomeWork> StatusPupil(string proffesion) { List <StatusesStudentHomeWork> list = new List <StatusesStudentHomeWork>(); using (HomeWorkProjectEntities2 db = new HomeWorkProjectEntities2()) { var q = db.StatusPupilByDay(proffesion).ToList(); var q2 = db.p(proffesion).ToList(); foreach (var item in q2) { StatusesStudentHomeWork status = new StatusesStudentHomeWork(); status.StudentId = item.studentId; status.StudentFirstName = item.studentFirstName; status.StudentLastName = item.studentLastName; status.StatusOfPreparation = (bool)item.statusOfPreparation; //status.ProfessionDescription = item.professionDescription; list.Add(status); } } return(list); }
//מחזיר שב לתלמיד להיום public List <HwForStudentForToday> GetHwForToday(int id) { List <HwForStudentForToday> list = new List <HwForStudentForToday>(); using (HomeWorkProjectEntities2 db = new HomeWorkProjectEntities2()) { var q3 = db.HwS(id).ToList(); foreach (var item in q3) { HwForStudentForToday hw = new HwForStudentForToday(); hw.HwDate = (DateTime)item.hwToStydyClassOnDate_Date; hw.HwDescription = item.hwDescription; hw.Deadline = (DateTime)item.deadline; hw.DurationOfPreparation = (int)item.durationOfPreparation; hw.VerificationQuestion = item.verificationQuestion; hw.VerificationAnswer = (int)item.verificationAnswer; hw.professionDescription = item.professionDescription; list.Add(hw); } } return(list); }