private void AddSubjectFromList(University_Subject obj) { using (_ujc = new UniversityEntities()) { var currsubj = _ujc.University_Subject.Where(s => s.Subject_ID == obj.Subject_ID).FirstOrDefault(); var currgroup = _ujc.University_Group.Where(t => t.Group_ID == SelectedGroup.Group_ID).FirstOrDefault(); currgroup.University_Subject.Add(currsubj); _ujc.SaveChanges(); GetCurrentSubjects(SelectedGroup); GetAllSubjects(); } }
private void AddStudentToGroup (University_Student parameter) { using (_ujc = new UniversityEntities()) { var _selstud = _ujc.University_Student.Where(s=>s.Student_ID == parameter.Student_ID).FirstOrDefault(); var _group = _ujc.University_Group.Where(gr => gr.Group_ID == SelectedGroup.Group_ID).FirstOrDefault(); _group.University_Student.Add(_selstud); _ujc.SaveChanges(); } GetAllStudents(); GetCurrentStudents(SelectedGroup); }
private void EditGroupFromDB(University_Group obj) { try { using (_ujc = new UniversityEntities()) { var _group = _ujc.University_Group.Where(s => s.Group_ID == obj.Group_ID).FirstOrDefault(); _group.Group_Name = GroupNameEdit; _ujc.SaveChanges(); } } catch { } finally { RefreshIt(); } }
private void AddNewGroupToDB(string obj) { try { using (_ujc = new UniversityEntities()) { University_Group _group = new University_Group(); _group.Group_Name = obj; _ujc.University_Group.Add(_group); _ujc.SaveChanges(); } } catch { } finally { RefreshIt(); } }
void AddNewSubjectToDB(object parameter) { using (_ujc = new UniversityEntities()) { _ujc.University_Subject.Add(new University_Subject() {Subject_Name = NewSubject }); _ujc.SaveChanges(); } NewSubject = null; UpdateSubjects(); }
//Command Methods private void DeleteGroupFromDB(University_Group obj) { try { using (_ujc = new UniversityEntities()) { var _group = _ujc.University_Group.Where(s => s.Group_ID == obj.Group_ID).FirstOrDefault(); _ujc.University_Group.Remove(_group); _ujc.SaveChanges(); } } finally { RefreshIt(); } }
private void SaveEditedTeacherToDB(University_Teacher obj) { try { using (_ujc = new UniversityEntities()) { var _teach = _ujc.University_Teacher.Where(s => s.Teacher_ID == SelectedTeacher.Teacher_ID).Single(); _teach.First_Name = Tname; _teach.Last_Name = Tlname; _teach.Birthday = Tbdate; _teach.Email = Temail; if (Tphoto != null) { _teach.Photo = ImageToByte(Tphoto); } _teach.Login = Tlogin; _teach.Password = Tpwd; _ujc.SaveChanges(); } } finally { EditEnabled = false; EditButtonName = "Edit"; _editTeacher = new Command<University_Teacher>(EditTeacherFromDB, (S) => SelectedTeacher != null); RaisePropertyChanged("EditTeacher"); AllowAddButton = true; BlockGrid = true; RefreshIt(); } }
private void UpdateStudent(object parameter) { using (_ujc = new UniversityEntities()) { //try { University_Student tmp = _ujc.University_Student.Single((st) => st.Student_ID == SelectedStudent.Student_ID); tmp.First_Name = StudentName; tmp.Last_Name = StudentLastName; tmp.Birthday = StudentBirthdate; tmp.Email = StudentEmail; if (StudentPhoto!=null) { tmp.Photo = ImageToByte(StudentPhoto); } else tmp.Photo = ImageToByte(new BitmapImage(new Uri(@"G:\Универ\GoogleDrive_oldan\Bionic Final Project\UniversityJournal\UniversityJournal\bin\Debug\no_img.jpg"))); _ujc.SaveChanges(); UpdateStudentsList(); CloseCommand(); } //catch { } } }
private void AddLessonToSchedule(object parameter) { using (_ujc = new UniversityEntities()) { var _newLes = new University_Schedule(); _newLes.Day_of_week = SelectedDay; _newLes.LessonNo = SelectedLessonNo; _newLes.Group_ID = SelectedGroup.Group_ID; _newLes.Subject_ID = SelectedSubject.Subject_ID; _newLes.Teacher_ID = SelectedTeacher.Teacher_ID; _ujc.University_Schedule.Add(_newLes); _ujc.SaveChanges(); } SelectedLessonNo = 0; RaisePropertyChanged("SelecteLessonNo"); SelectedDay = null; OnSelectedLessonNo(); UpdateSchedule(); }
private void SaveNewTeacherToDB(object obj) { try { using (_ujc = new UniversityEntities()) { University_Teacher _teach = new University_Teacher(); _teach.First_Name = Tname; _teach.Last_Name = Tlname; _teach.Birthday = Tbdate; _teach.Email = Temail; if (Tphoto != null) { _teach.Photo = ImageToByte(Tphoto); } _teach.Login = Tlogin; _teach.Password = Tpwd; _ujc.University_Teacher.Add(_teach); _ujc.SaveChanges(); } } catch { } finally { EditEnabled = false; AddButtonName = "Add New..."; _addNewTeacher = new Command<object>(AddNewTeacherToDB); RaisePropertyChanged("AddNewTeacher"); BlockGrid = true; RefreshIt(); } }
private void DeleteLessonFromSchedule(Schedule parameter) { using (_ujc = new UniversityEntities()) { var _delLes = _ujc.University_Schedule.Where(s => s.Lesson_ID == parameter.Lesson_ID).FirstOrDefault(); _ujc.University_Schedule.Remove(_delLes); _ujc.SaveChanges(); } UpdateSchedule(); }
private void EditSubjectFromDB(University_Subject obj) { using (_ujc = new UniversityEntities()) { var subj = _ujc.University_Subject.Where(s => s.Subject_ID == obj.Subject_ID).FirstOrDefault(); if (subj != null) { subj.Subject_Name = CurrentSubject; _ujc.SaveChanges(); } UpdateSubjects(); } }
void DeleteSubjectFromDB(University_Subject parameter) { using (_ujc = new UniversityEntities()) { var tmp = _ujc.University_Subject.Where(s => s.Subject_ID == parameter.Subject_ID).FirstOrDefault(); if (tmp != null) { _ujc.University_Subject.Remove(tmp); _ujc.SaveChanges(); SelectedSubject = null; UpdateSubjects(); } } }
private void RemoveStudentFromGroup(University_Student obj) { using (_ujc = new UniversityEntities()) { var currstud = _ujc.University_Student.Where(s => s.Student_ID == obj.Student_ID).FirstOrDefault(); var currgroup = _ujc.University_Group.Where(t => t.Group_ID == SelectedGroup.Group_ID).FirstOrDefault(); currgroup.University_Student.Remove(currstud); _ujc.SaveChanges(); GetAllStudents(); GetCurrentStudents(SelectedGroup); } }
private void DeleteTeacherFromDB(University_Teacher obj) { try { using (_ujc = new UniversityEntities()) { var _teach = _ujc.University_Teacher.Where(s => s.Teacher_ID == obj.Teacher_ID).FirstOrDefault(); _ujc.University_Teacher.Remove(_teach); _ujc.SaveChanges(); } } finally { RefreshIt(); } }
private void DeleteStudentFromDB(University_Student obj) { _ujc = new UniversityEntities(); var removestud = _ujc.University_Student.Single((s) => s.Student_ID == SelectedStudent.Student_ID); _ujc.University_Student.Remove(removestud); _ujc.SaveChanges(); UpdateStudentsList(); }
private void RemoveSubjectFromList(University_Subject obj) { using (_ujc = new UniversityEntities()) { var currsubj = _ujc.University_Subject.Where(s => s.Subject_ID == obj.Subject_ID).FirstOrDefault(); var currteach = _ujc.University_Teacher.Where(t => t.Teacher_ID == SelectedTeacher.Teacher_ID).FirstOrDefault(); currteach.University_Subject.Remove(currsubj); _ujc.SaveChanges(); GetCurrentSubjects(SelectedTeacher); GetAllSubjects(); } }
private void AddStudent(object parameter) { using (_ujc = new UniversityEntities()) { try { University_Student tmp = new University_Student(); tmp.First_Name = StudentName; tmp.Last_Name = StudentLastName; tmp.Birthday = StudentBirthdate; tmp.Email = StudentEmail; if (StudentPhoto == null) tmp.Photo = null; else tmp.Photo = ImageToByte(StudentPhoto); _ujc.University_Student.Add(tmp); _ujc.SaveChanges(); UpdateStudentsList(); CloseCommand(); } catch { } } }
private void SaveStudentPresenceAndMark(University_Student obj) { using (_ujc = new UniversityEntities()) { var _StudState = _ujc.University_StudentPresence .Where(ls => ls.LessonID == SelectedLesson.Lesson_ID) .Where(st => st.StudentID == SelectedStudent.Student_ID) .Where(dt => dt.Date == LessonDate.Date).FirstOrDefault(); if (_StudState != null) { _StudState.Present = StudentPresent; _StudState.Mark = Convert.ToInt32(StudentMark); } else { University_StudentPresence tmp = new University_StudentPresence(); tmp.LessonID = SelectedLesson.Lesson_ID; tmp.StudentID = SelectedStudent.Student_ID; tmp.Date = LessonDate.Date; tmp.Present = StudentPresent; tmp.Mark = Convert.ToInt32(StudentMark); _ujc.University_StudentPresence.Add(tmp); } _ujc.SaveChanges(); SaveInfo = String.Format("Information about {0} {1} has been saved", SelectedStudent.Last_Name, SelectedStudent.First_Name); OnSelectedLessonChange(); } }