public static void Auditorium(string number, int capacity, int comp, string quality, string projector, LocationInfo local) { var loc = Db.Location.FindByID_Location(local.ID_Location); Db.Auditoriums.AddAuditoriumsRow(number, capacity, comp, quality, projector, loc); Db.AcceptChanges(); }
public static void Teacher(TeacherInfo teacher) { var temp = (from a in Db.DiscipTeachers where a.ID_Teacher == teacher.ID_Teacher select a.DisciplinesRow).ToArray(); foreach (var t in temp) { Db.Disciplines.RemoveDisciplinesRow(t); } foreach (var row in Db.DiscipTeachers.Where(a => a.TeachersRow.Name == teacher.Name).ToArray()) { Db.DiscipTeachers.RemoveDiscipTeachersRow(row); } foreach (var row in Db.Schedule.Where(a => a.TeachersRow.Name == teacher.Name).ToArray()) { Db.Schedule.RemoveScheduleRow(row); } foreach (var row in Db.ScheduleException.Where(a => a.TeachersRow.Name == teacher.Name).ToArray()) { Db.ScheduleException.RemoveScheduleExceptionRow(row); } Db.Teachers.RemoveTeachersRow(Db.Teachers.Single(a => a.ID_Teacher == teacher.ID_Teacher)); Db.AcceptChanges(); }
public static void Group() { Db.Group.Clear(); Db.Schedule.Clear(); Db.ScheduleException.Clear(); Db.AcceptChanges(); }
public static void Education(EducationInfo edu, string newValue) { var d = Db.Education.Single(a => a.ID_Education == edu.ID_Education); d.Name = newValue; Db.AcceptChanges(); }
public static void Auditorium() { Db.Auditoriums.Clear(); Db.Schedule.Clear(); Db.ScheduleException.Clear(); Db.AcceptChanges(); }
public static void Location(LocationInfo loc, string newValue) { var d = Db.Location.Single(a => a.ID_Location == loc.ID_Location); d.Name = newValue; Db.AcceptChanges(); }
public static void Discipline(DisciplineInfo disp, string newValue) { var d = Db.Disciplines.Single(a => a.ID_Discipline == disp.ID_Discipline); d.Name = newValue; Db.AcceptChanges(); }
public static void Teacher(TeacherInfo teacher, string newValue) { var teach = Db.Teachers.Single(a => a.ID_Teacher == teacher.ID_Teacher); teach.Name = newValue; Db.AcceptChanges(); }
public static void Discipline() { Db.Disciplines.Clear(); Db.DiscipTeachers.Clear(); Db.Schedule.Clear(); Db.ScheduleException.Clear(); Db.AcceptChanges(); }
public static void Location(LocationInfo loc) { foreach (var info in GetAuditoriumsFromLocation(loc)) { Auditorium(info); } Db.Location.RemoveLocationRow(Db.Location.Single(a => a.ID_Location == loc.ID_Location)); Db.AcceptChanges(); }
public static void Education(EducationInfo edu) { foreach (var row in GetGroupFromEducation(edu)) { Group(row); } Db.Education.RemoveEducationRow(Db.Education.Single(a => a.ID_Education == edu.ID_Education)); Db.AcceptChanges(); }
public static void Faculty(FacultyInfo faculty, string newValue) { var fac = (from a in Db.Faculty where a.ID_Faculty == faculty.ID_Faculty select a).Single(); fac.Name = newValue; Db.AcceptChanges(); }
public static void Faculty(FacultyInfo faculty) { foreach (GroupInfo f in GetGroupFromFaculty(faculty)) { Group(f); } Db.Faculty.RemoveFacultyRow(Db.Faculty.Single(a => a.ID_Faculty == faculty.ID_Faculty)); Db.AcceptChanges(); }
public static void Abridgement(AbridgementInfo abridgementInfo) { var temp = (from a in Db.Abridgement where a.ID == abridgementInfo.ID select a).Single(); Db.Abridgement.RemoveAbridgementRow(temp); Db.AcceptChanges(); }
public static void Group(string str, FacultyInfo faculty, EducationInfo edu) { var temp = Db.Group.NewGroupRow(); temp.Name = str; temp.ID_Education = edu.ID_Education; temp.ID_Faculty = faculty.ID_Faculty; Db.Group.AddGroupRow(temp); Db.AcceptChanges(); }
public static void Auditorium(AuditoriumInfo aud, string number, int capacity, int comp, string quality, string projector) { var temp = Db.Auditoriums.Single(a => a.ID_Auditorium == aud.ID_Auditorium); temp.Number = number; temp.Capacity = capacity; temp.NumbComp = comp; temp.QualityComp = quality; temp.AvailabilityProjector = projector; Db.AcceptChanges(); }
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 void ScheduleWeekAuditorium(int ID_Period, int ID_Auditorium) { var temp = (from a in Db.Schedule where a.ID_Auditorium == ID_Auditorium && a.ID_Period == ID_Period select a).ToArray(); foreach (var t in temp) { Db.Schedule.RemoveScheduleRow(t); } Db.AcceptChanges(); }
public static void ScheduleWeekTeacher(int ID_Period, int ID_Teacher) { var temp = (from a in Db.Schedule where a.ID_Period == ID_Period && a.ID_Teacher == ID_Teacher select a).ToArray(); foreach (var t in temp) { Db.Schedule.RemoveScheduleRow(t); } Db.AcceptChanges(); }
public static void Group(GroupInfo groupp) { foreach (var row in Db.Schedule.Where(a => a.GroupRow.Name == groupp.Name).ToArray()) { Db.Schedule.RemoveScheduleRow(row); } foreach (var row in Db.ScheduleException.Where(a => a.GroupRow.Name == groupp.Name).ToArray()) { Db.ScheduleException.RemoveScheduleExceptionRow(row); } Db.Group.RemoveGroupRow(Db.Group.Single(a => a.ID_Group == groupp.ID_Group)); Db.AcceptChanges(); }
public static void Auditorium(AuditoriumInfo aud) { foreach (var row in Db.Schedule.Where(a => a.AuditoriumsRow.ID_Auditorium == aud.ID_Auditorium).ToArray()) { Db.Schedule.RemoveScheduleRow(row); } foreach (var row in Db.ScheduleException.Where(a => a.AuditoriumsRow.ID_Auditorium == aud.ID_Auditorium).ToArray()) { Db.ScheduleException.RemoveScheduleExceptionRow(row); } Db.Auditoriums.RemoveAuditoriumsRow(Db.Auditoriums.Single(a => a.ID_Auditorium == aud.ID_Auditorium)); Db.AcceptChanges(); }
public static void ScheduleDayGroup(int ID_Period, int ID_Group, int DayWeek) { var temp = (from a in Db.Schedule where a.ID_Period == ID_Period && a.ID_Group == ID_Group && a.DayWeek == DayWeek select a).ToArray(); foreach (var t in temp) { Db.Schedule.RemoveScheduleRow(t); } Db.AcceptChanges(); }
public static void Group(GroupInfo groupp, string newValue, EducationInfo eduNew) { var d = Db.Group.Single(a => a.ID_Group == groupp.ID_Group); if (d.Name != newValue) { d.Name = newValue; } if (d.ID_Education != eduNew.ID_Education) { d.ID_Education = eduNew.ID_Education; } Db.AcceptChanges(); }
public static void Schedule(int ID_Period, int ID_Teacher, int Para, int DayWeek) { var temp = (from a in Db.Schedule where a.ID_Period == ID_Period && a.ID_Teacher == ID_Teacher && a.Para == Para && a.DayWeek == DayWeek select a).ToArray(); foreach (var schedule in temp) { Db.Schedule.RemoveScheduleRow(schedule); } Db.AcceptChanges(); }
public static void Schedule(int ID_Auditorium, int ID_Discipline, int ID_Group, int ID_Period, int ID_Teacher, int Para, int DayWeek) { var schedule = Db.Schedule.NewScheduleRow(); schedule.ID_Auditorium = ID_Auditorium; schedule.ID_Discipline = ID_Discipline; schedule.ID_Group = ID_Group; schedule.ID_Period = ID_Period; schedule.ID_Teacher = ID_Teacher; schedule.Para = Para; schedule.DayWeek = DayWeek; Db.Schedule.AddScheduleRow(schedule); Db.AcceptChanges(); }
public static void Discipline(DisciplineInfo dis) { foreach (var row in Db.DiscipTeachers.Where(a => a.DisciplinesRow.Name == dis.Name).ToArray()) { Db.DiscipTeachers.RemoveDiscipTeachersRow(row); } foreach (var row in Db.Schedule.Where(a => a.DisciplinesRow.Name == dis.Name).ToArray()) { Db.Schedule.RemoveScheduleRow(row); } foreach (var row in Db.ScheduleException.Where(a => a.DisciplinesRow.Name == dis.Name).ToArray()) { Db.ScheduleException.RemoveScheduleExceptionRow(row); } Db.Disciplines.RemoveDisciplinesRow(Db.Disciplines.Single(a => a.ID_Discipline == dis.ID_Discipline)); Db.AcceptChanges(); }
public static void Schedule(int ID, int ID_Discipline, int ID_Group, int ID_Auditorium) { var temp = (from a in Db.Schedule where a.ID == ID select a).Single(); var t = Db.Schedule.NewScheduleRow(); t.ID_Auditorium = ID_Auditorium; t.ID_Discipline = ID_Discipline; t.ID_Group = ID_Group; t.ID_Period = temp.ID_Period; t.ID_Teacher = temp.ID_Teacher; t.Para = temp.Para; t.DayWeek = temp.DayWeek; Db.Schedule.RemoveScheduleRow(temp); Db.Schedule.AddScheduleRow(t); Db.AcceptChanges(); }
public static void ScheduleException() { Db.ScheduleException.Clear(); Db.AcceptChanges(); }
public static void Abridgement() { Db.Abridgement.Clear(); Db.AcceptChanges(); }
public static void Schedule() { Db.Schedule.Clear(); Db.AcceptChanges(); }