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 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(); } }
void GetCurrentSubjects(University_Teacher obj) { if (obj != null) { using (_ujc = new UniversityEntities()) { var _teach = _ujc.University_Teacher.Where(s => s.Teacher_ID == obj.Teacher_ID).FirstOrDefault(); CurrentSubjects = new ObservableCollection <University_Subject>(_teach.University_Subject.ToList()); } } }
private void EditTeacherFromDB(University_Teacher obj) { EditEnabled = true; EditButtonName = "Save"; AllowAddButton = false; BlockGrid = false; _editTeacher = new Command <University_Teacher>(SaveEditedTeacherToDB, (t) => !string.IsNullOrWhiteSpace(Tname) && !string.IsNullOrWhiteSpace(Tlname) && Tbdate != null && !string.IsNullOrWhiteSpace(Tlogin) && !string.IsNullOrWhiteSpace(Tpwd)); RaisePropertyChanged("EditTeacher"); }
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(); } }