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