private void EditStudentFromDB(University_Student obj) { var childWindow = new EditStudentWindow() { DataContext = this, Title="Edit Student" }; CloseCommand = new Action(() => childWindow.Close()); StudentName = obj.First_Name; StudentLastName = obj.Last_Name; StudentEmail = obj.Email; StudentBirthdate = obj.Birthday; if (obj.Photo == null) StudentPhoto = null; else StudentPhoto = ByteToImage(obj.Photo); ButtonName = "Edit"; SaveButton = new Command<object>(UpdateStudent, (s)=>!string.IsNullOrWhiteSpace(StudentName) && !string.IsNullOrWhiteSpace(StudentLastName)&& StudentBirthdate!=null); childWindow.ShowDialog(); }
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 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 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 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 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(); } }
private bool CanSaveStudentState(University_Student obj) { int tmpMark=0; bool pars = int.TryParse(StudentMark,out tmpMark); return CanPutStudentMark()||(pars&&tmpMark>=0&&tmpMark<=5); }