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