private void dgSubjects_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (this.dgSubjects.SelectedItem != null)
{
this.currentSubject = this.dgSubjects.SelectedItem as subject;
List<dynamic> teas = null;
if (this.chbSubst.IsChecked.HasValue && this.chbSubst.IsChecked.Value)
{
teas = DBModel.Instance.GetAllTeachers();
}
else
{
teas = DBModel.Instance.GetTeachersBySubject(this.currentSubject);
}
this.dgTeachers.ItemsSource = teas;
}
else
{
this.currentSubject = null;
this.dgTeachers.ItemsSource = null;
}
}
/// <summary>
/// Create a new subject object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="fullName">Initial value of the FullName property.</param>
/// <param name="isDeleted">Initial value of the IsDeleted property.</param>
public static subject Createsubject(global::System.Int64 id, global::System.String fullName, global::System.Boolean isDeleted)
{
subject subject = new subject();
subject.Id = id;
subject.FullName = fullName;
subject.IsDeleted = isDeleted;
return subject;
}
/// <summary>
/// Deprecated Method for adding a new object to the subjects EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTosubjects(subject subject)
{
base.AddObject("subjects", subject);
}
public List<dynamic> GetTeachersBySubject(subject s, bool includeDeleted = false)
{
CheckConnection();
try
{
lock (locker)
{
return s.ref_teacher_subject.Where(x => x.teacher.person.IsDeleted == includeDeleted).Select(t => t.teacher).ToList<dynamic>();
}
}
catch (Exception ex)
{
throw new DBException(ErrorTypes.UnexpectedException, ex);
}
}
public void DeleteSubject(subject s)
{
CheckConnection();
try
{
lock (locker)
{
s.IsDeleted = true;
ref_subject_department d = s.ref_subject_department.FirstOrDefault();
while(d != null)
{
db.ref_subject_department.DeleteObject(d);
d = s.ref_subject_department.FirstOrDefault();
}
ref_subject_group g = s.ref_subject_group.FirstOrDefault();
while (g != null)
{
db.ref_subject_group.DeleteObject(g);
g = s.ref_subject_group.FirstOrDefault();
}
ref_teacher_subject t = s.ref_teacher_subject.FirstOrDefault();
while (t != null)
{
db.ref_teacher_subject.DeleteObject(t);
t = s.ref_teacher_subject.FirstOrDefault();
}
// foreach (var i in s.ref_subject_department)
// db.ref_subject_department.DeleteObject(i);
//foreach (var i in s.ref_subject_group)
// db.ref_subject_group.DeleteObject(i);
//foreach (var i in s.ref_teacher_subject)
// db.ref_teacher_subject.DeleteObject(i);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new DBException(ErrorTypes.UnexpectedException, ex);
}
}
public void EditSubject(subject s, string newShortName, string newFullName)
{
CheckConnection();
try
{
lock (locker)
{
s.ShortName = newShortName;
s.FullName = newFullName;
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new DBException(ErrorTypes.UnexpectedException, ex);
}
}
public ref_subject_group FindSubjectOfGroup(studentsgroup gr, subject s)
{
CheckConnection();
try
{
lock (locker)
{
return db.ref_subject_group.FirstOrDefault(i => i.GroupId == gr.Id && i.SubjectId == s.Id);
}
}
catch (Exception ex)
{
throw new DBException(ErrorTypes.UnexpectedException, ex);
}
}
public void AddSubjectToGroup(studentsgroup gr, subject s)
{
CheckConnection();
try
{
lock (locker)
{
ref_subject_group r = ref_subject_group.Createref_subject_group(0, gr.Id, s.Id);
db.ref_subject_group.AddObject(r);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new DBException(ErrorTypes.UnexpectedException, ex);
}
}