/// <summary>
/// Deprecated Method for adding a new object to the teachers EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToteachers(teacher teacher)
{
base.AddObject("teachers", teacher);
}
private void dgTeachers_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (this.dgTeachers.SelectedItem != null)
{
this.currentTeacher = this.dgTeachers.SelectedItem as teacher;
}
else
{
this.currentTeacher = null;
}
}
public List<dynamic> GetDepartmentsByTeacher(teacher t)
{
CheckConnection();
try
{
return t.ref_teacher_department.Select(x => x.department).ToList<dynamic>();
}
catch (Exception ex)
{
throw new DBException(ErrorTypes.UnexpectedException, ex);
}
}
/// <summary>
/// Create a new teacher object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="personId">Initial value of the PersonId property.</param>
public static teacher Createteacher(global::System.Int64 id, global::System.Int64 personId)
{
teacher teacher = new teacher();
teacher.Id = id;
teacher.PersonId = personId;
return teacher;
}
public void DeleteDepartmentFromTeacher(teacher t, dynamic d)
{
CheckConnection();
try
{
lock (locker)
{
ref_teacher_department dr = t.ref_teacher_department.FirstOrDefault(x => x.department.Id == d.Id);
db.ref_teacher_department.DeleteObject(dr);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new DBException(ErrorTypes.UnexpectedException, ex);
}
}
public void DeleteSubjectFromTeacher(teacher t, dynamic s)
{
CheckConnection();
try
{
lock (locker)
{
ref_teacher_subject r = t.ref_teacher_subject.FirstOrDefault(x => x.subject.Id == s.Subject.Id);
db.ref_teacher_subject.DeleteObject(r);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new DBException(ErrorTypes.UnexpectedException, ex);
}
}
public void AddDepartmentToTeacher(teacher t, dynamic d)
{
CheckConnection();
try
{
lock (locker)
{
ref_teacher_department dr = ref_teacher_department.Createref_teacher_department(0, d.Id, t.Id);
db.ref_teacher_department.AddObject(dr);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new DBException(ErrorTypes.UnexpectedException, ex);
}
}
public void AddSubjectToTeacher(teacher t, dynamic s)
{
CheckConnection();
try
{
lock (locker)
{
ref_teacher_subject r = ref_teacher_subject.Createref_teacher_subject(0, s.Subject.Id, t.Id);
db.ref_teacher_subject.AddObject(r);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new DBException(ErrorTypes.UnexpectedException, ex);
}
}
public void DeleteTeacher(teacher t)
{
CheckConnection();
try
{
lock (locker)
{
t.person.IsDeleted = true;
foreach (var i in t.ref_teacher_department)
db.ref_teacher_department.DeleteObject(i);
foreach (var i in t.ref_teacher_subject)
db.DeleteObject(i);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new DBException(ErrorTypes.UnexpectedException, ex);
}
}
public void EditTeacher(teacher t, person p)
{
CheckConnection();
try
{
lock (locker)
{
EditPerson(t.person, p.First_Name, p.Last_Name, p.Middle_Name, p.Birthday, p.H_Phone, p.M_Phone, p.Address, p.Email, p.SomeInformation, p.Photo);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new DBException(ErrorTypes.UnexpectedException, ex);
}
}
public List<dynamic> GetSubjectsByTeacher(teacher t)
{
CheckConnection();
try
{
lock (locker)
{
IEnumerable<dynamic> lst = from i in t.ref_teacher_subject
select new
{
Subject = i.subject
};
return lst.ToList();
}
}
catch (Exception ex)
{
throw new DBException(ErrorTypes.UnexpectedException, ex);
}
}