public static void Discipline(string str, TeacherInfo teacher) { var disp = Db.Disciplines.AddDisciplinesRow(str); Db.AcceptChanges(); var temp = Db.DiscipTeachers.NewDiscipTeachersRow(); temp.ID_Teacher = teacher.ID_Teacher; temp.ID_Discipline = disp.ID_Discipline; Db.DiscipTeachers.AddDiscipTeachersRow(temp); Db.AcceptChanges(); }
public static DisciplineInfo[] GetDisciplinesFromTwoTeacher(TeacherInfo teacher1, TeacherInfo teacher2) { if (teacher1 == null) { return(null); } var disp1 = (Db.DiscipTeachers.Where(d => d.ID_Teacher == teacher1.ID_Teacher) .Select(d => new DisciplineInfo(d.DisciplinesRow))).ToArray(); if (teacher2 == null) { return(null); } var disp2 = (Db.DiscipTeachers.Where(d => d.ID_Teacher == teacher2.ID_Teacher) .Select(d => new DisciplineInfo(d.DisciplinesRow))).ToArray(); return(disp1.Intersect(disp2, new MyDisciplineComparer()).ToArray()); }
public AddParaTeacher( TeacherInfo teacherInfo, IEnumerable<ScheduleInfo> scheduleInfos, int para, int dayWeek, int idPeriod, string text, bool edit) { InitializeComponent(); Text = text; IDTeacher = teacherInfo.ID_Teacher; Para = para; DayWeek = dayWeek; IDPeriod = idPeriod; if (IDPeriod != 1 && IDPeriod != 2) { checkBox2.Visible = false; Size = new Size(431, 238); } Sched = edit ? new List<ScheduleInfo>(scheduleInfos) : new List<ScheduleInfo>(); if (edit) { var locAll = Model.GetAll.Location(); var dispAll = Model.GetDisciplinesFromTeacher(teacherInfo); var facAll = Model.GetAll.Fuculty(); var loc = (from a in locAll where a.ID_Location == Sched.First().ID_Location select a).Single(); var disp = (from a in dispAll where a.ID_Discipline == Sched.First().ID_Discipline select a).Single(); var fac = (from a in facAll where a.ID_Faculty == Sched.First().ID_Faculty select a).Single(); Location.Items.AddRange(locAll); Location.SelectedItem = loc; Disp.Items.AddRange(dispAll); Disp.SelectedItem = disp; Faculty.Items.AddRange(facAll); Faculty.SelectedItem = fac; var auAll = Model.GetAuditoriumsFromLocation(loc); var au = (from a in auAll where a.ID_Auditorium == Sched.First().ID_Auditorium select a).Single(); Aud.Items.Clear(); Aud.Items.AddRange(auAll); Aud.Enabled = true; Aud.SelectedItem = au; try { var temp = Sched.First().GroupName.Substring(Sched.First().GroupName.Length - 2, 1); Curs.SelectedIndex = Convert.ToInt32(temp) - 1; } catch (Exception) { } for (int i = 0; i < List.Items.Count; i++) foreach (var list in Sched) if (((GroupInfo)List.Items[i]).ID_Group == list.ID_Group) List.SetItemChecked(i, true); } else { var loc = Model.GetAll.Location(); Location.Items.AddRange(loc); if (loc.Count() == 1) Location.SelectedIndex = 0; var disp = Model.GetDisciplinesFromTeacher(teacherInfo); Disp.Items.AddRange(disp); if (disp.Count() == 1) Disp.SelectedIndex = 0; var fac = Model.GetAll.Fuculty(); Faculty.Items.AddRange(fac); if (fac.Count() == 1) Faculty.SelectedIndex = 0; } }
public AddParaTeacher( TeacherInfo teacherInfo, IEnumerable <ScheduleInfo> scheduleInfos, int para, int dayWeek, int idPeriod, string text, bool edit) { InitializeComponent(); Text = text; IDTeacher = teacherInfo.ID_Teacher; Para = para; DayWeek = dayWeek; IDPeriod = idPeriod; if (IDPeriod != 1 && IDPeriod != 2) { checkBox2.Visible = false; Size = new Size(431, 238); } Sched = edit ? new List <ScheduleInfo>(scheduleInfos) : new List <ScheduleInfo>(); if (edit) { var locAll = Model.GetAll.Location(); var dispAll = Model.GetDisciplinesFromTeacher(teacherInfo); var facAll = Model.GetAll.Fuculty(); var loc = (from a in locAll where a.ID_Location == Sched.First().ID_Location select a).Single(); var disp = (from a in dispAll where a.ID_Discipline == Sched.First().ID_Discipline select a).Single(); var fac = (from a in facAll where a.ID_Faculty == Sched.First().ID_Faculty select a).Single(); Location.Items.AddRange(locAll); Location.SelectedItem = loc; Disp.Items.AddRange(dispAll); Disp.SelectedItem = disp; Faculty.Items.AddRange(facAll); Faculty.SelectedItem = fac; var auAll = Model.GetAuditoriumsFromLocation(loc); var au = (from a in auAll where a.ID_Auditorium == Sched.First().ID_Auditorium select a).Single(); Aud.Items.Clear(); Aud.Items.AddRange(auAll); Aud.Enabled = true; Aud.SelectedItem = au; try { var temp = Sched.First().GroupName.Substring(Sched.First().GroupName.Length - 2, 1); Curs.SelectedIndex = Convert.ToInt32(temp) - 1; } catch (Exception) { } for (int i = 0; i < List.Items.Count; i++) { foreach (var list in Sched) { if (((GroupInfo)List.Items[i]).ID_Group == list.ID_Group) { List.SetItemChecked(i, true); } } } } else { var loc = Model.GetAll.Location(); Location.Items.AddRange(loc); if (loc.Count() == 1) { Location.SelectedIndex = 0; } var disp = Model.GetDisciplinesFromTeacher(teacherInfo); Disp.Items.AddRange(disp); if (disp.Count() == 1) { Disp.SelectedIndex = 0; } var fac = Model.GetAll.Fuculty(); Faculty.Items.AddRange(fac); if (fac.Count() == 1) { Faculty.SelectedIndex = 0; } } }