public List <Department> GetDepartments() { using (var db = new ScheduleKSTUContext()) { return(db.Department.ToList()); } }
public List <Semesters> GetSemesters() { using (var db = new ScheduleKSTUContext()) { return(db.Semesters.ToList()); } }
public List <Schedule> GetAuditoriumSchedule(short auditoriumId) { using (var db = new ScheduleKSTUContext()) { return(db.Schedule.Where(s => s.AuditoriumId == auditoriumId && s.SemesterId == GetCurrentSemester().Id).ToList()); } }
public List <Group> GetGroups() { using (var db = new ScheduleKSTUContext()) { return(db.Group.ToList()); } }
public List <Hour> GetHours() { using (var db = new ScheduleKSTUContext()) { return(db.Hour.ToList()); } }
public List <Schedule> GetFacultySchedule(int facultyId) { using (var db = new ScheduleKSTUContext()) { return(db.Schedule.ToList()); } }
public List <Criteria> GetCriteria() { using (var db = new ScheduleKSTUContext()) { return(db.Criteria.ToList()); } }
public List <Faculty> GetFaculties() { using (var db = new ScheduleKSTUContext()) { return(db.Faculty.ToList()); } }
public List <Timetable.DomainCore.Domain.DayOfWeek> GetDaysOfWeek() { using (var db = new ScheduleKSTUContext()) { return(db.DayOfWeek.ToList()); } }
public List <Course> GetCourses() { using (var db = new ScheduleKSTUContext()) { return(db.Course.ToList()); } }
public List <Schedule> GetTeacherSchedule(Raschasovka load) { using (var db = new ScheduleKSTUContext()) { List <Schedule> scheduleList = db.Schedule .Include(s => s.ScheduleWeeks) .Where(s => s.TeacherId == load.TeacherId && s.SemesterId == GetCurrentSemester().Id).ToList(); List <Schedule> teachersFree = new List <Schedule>(); foreach (var s in scheduleList) { //weeksContains = !load.RaschasovkaWeeks.Where(rw => rw.HoursForWeek != 0).Select(w => new Week { Id = w.WeekId }).Except(s.ScheduleWeeks.Select(sw => new Week //{ // Id = sw.WeekId, //})).Any(); var set = new HashSet <int>(load.RaschasovkaWeeks.Where(rw => rw.HoursForWeek != 0).Select(w => (int)w.WeekId)); var set2 = s.ScheduleWeeks.Select(sw => (int)sw.WeekId); var equals = set.SetEquals(set2); if (equals == false && set.Count() == set2.Count()) { teachersFree.Add(s); } } scheduleList = scheduleList.Except(teachersFree).ToList(); return(scheduleList); } }
public bool InsertGenTeachers(List <RateData> teachers) { using (var db = new ScheduleKSTUContext()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { ///////!!!!!!! db.Database.ExecuteSqlCommand("Delete From Gen_Teachers"); try { foreach (RateData teach in teachers) { db.GenTeachers.Add(new GenTeachers { TeacherId = teach.Id, Rate = teach.Rate + 1 }); } db.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } } return(true); }
public List <TimeslotsWeight> GetTimeslotsWeight() { using (var db = new ScheduleKSTUContext()) { return(db.Set <TimeslotsWeight>().FromSql("dbo.GetTimeslotsWeight").AsNoTracking().ToList()); } }
public List <TableWeight> GetSubjectClassWeight() { using (var db = new ScheduleKSTUContext()) { return(db.Set <TableWeight>().FromSql("dbo.GetSubjectClassWeight").AsNoTracking().ToList()); } }
public Faculty GetFacultie(int id) { using (var db = new ScheduleKSTUContext()) { return(db.Faculty.FirstOrDefault(f => f.Id == id)); } }
public List <Week> GetWeeks() { using (var db = new ScheduleKSTUContext()) { return(db.Week.ToList()); } }
public Week GetWeekNumber(byte id) { using (var db = new ScheduleKSTUContext()) { return(db.Week.FirstOrDefault(w => w.Id == id)); } }
public List <Raschasovka> GetLoad() { using (var db = new ScheduleKSTUContext()) { return(db.Raschasovka.ToList()); } }
public List <Teacher> GetTeachers() { using (var db = new ScheduleKSTUContext()) { return(db.Teacher.ToList()); } }
public int AddScheduleTimeslot(Raschasovka load, TimeslotsCriteriaWeight timeslot) { using (var db = new ScheduleKSTUContext()) { Schedule schedule; using (var dbContextTransaction = db.Database.BeginTransaction()) { try { schedule = new Schedule { GroupId = load.GroupId, TeacherId = load.TeacherId, SubjectId = load.SubjectId, SubjectTypeId = load.SubjectTypeId, SemesterId = GetCurrentSemester().Id, HourId = timeslot.HourId, DayOfWeekId = timeslot.DayId, AuditoriumId = timeslot.AuditoriumId, }; db.Schedule.Add(schedule); db.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } return(schedule.Id); } }
public List <Auditorium> GetAuditoriums() { using (var db = new ScheduleKSTUContext()) { return(db.Auditorium.ToList()); } }
public bool AddScheduleWeeks(int scheduleId, int loadId) { using (var db = new ScheduleKSTUContext()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { List <ScheduleWeeks> scheduleWeeks = db.RaschasovkaWeeks.Where(rw => rw.RaschasovkaId == loadId && rw.HoursForWeek != 0) .Select(rw => new ScheduleWeeks { ScheduleId = scheduleId, WeekId = rw.WeekId }).ToList(); db.ScheduleWeeks.AddRange(scheduleWeeks); db.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); throw; } } } return(true); }
public List <SubjectType> GetSubjectTypes() { using (var db = new ScheduleKSTUContext()) { return(db.SubjectType.ToList()); } }
public bool InsertGenTimeslots(List <CriteriaRate> timeslots, int i) { using (var db = new ScheduleKSTUContext()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { ///////!!!!!!! db.Database.ExecuteSqlCommand("Delete From Gen_Timeslots"); try { foreach (CriteriaRate cr in timeslots) { db.GenTimeslots.Add(new GenTimeslots { AuditoriumId = cr.timeslots.AuditoriumId, DayId = cr.timeslots.DayId, HourId = cr.timeslots.HourId, Rate = cr.Rate + 1 }); } db.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } } return(true); }
/* * Load * */ public List <Raschasovka> GetFlawsFromLoad() { using (var db = new ScheduleKSTUContext()) { return(db.Raschasovka.Where(load => load.Potok != null).ToList()); } }
public byte GetCurrentWeek() { using (var db = new ScheduleKSTUContext()) { return(db.Week.FirstOrDefault().Id); } }
public List <Raschasovka> GetGroupsLoadForCurrentSemester() { using (var db = new ScheduleKSTUContext()) { return(db.Raschasovka.Where(load => load.Semester.Id == GetSemesterByName("Весенний").Id) .Include(l => l.RaschasovkaWeeks) .OrderBy(load => load.Course.Number).ToList()); } }
/* * Semester * */ public Semesters GetSemesterByName(string semesterName) { using (var db = new ScheduleKSTUContext()) { Semesters semester = db.Semesters.FirstOrDefault(sem => sem.Name == semesterName); return(new Semesters { Id = semester.Id, Name = semester.Name }); } }
//public List<TeachersLoadWeight> GetTeachersLoadRate() //{ // int i = 0; // var GenList = db.Raschasovka.GroupBy(r => new { r.TeacherId, r.TotalHoursForSemestr }) // .Select(r => new TeachersLoadRate { Id = 0, Rate = r.Count() + r.Key.TotalHoursForSemestr, TeacherId = r.Key.TeacherId, TotalHours = r.Key.TotalHoursForSemestr }).ToList(); // foreach (var item in GenList) // item.Id = ++i; // InsertGenTeachers(GenList.Select(l=>new RateData {Id = l.Id, Rate = l.Rate }).ToList()); // return GenList.Join(GetTeachersWeight(), l => l.Id, w => w.Id, (l, w) => new TeachersLoadWeight { TeacherId = l.TeacherId, TotalHours = l.TotalHours, Weight = w.Weight }).ToList(); //} public List <RateData> GetTeachersLoadRate() { //return db.Raschasovka.GroupBy(r => new { r.TeacherId, r.TotalHoursForSemestr }) // .Select(r => new RateData { Rate = r.Count() + r.Key.TotalHoursForSemestr, Id = r.Key.TeacherId }).ToList(); using (var db = new ScheduleKSTUContext()) { return(db.Raschasovka.GroupBy(r => r.TeacherId) .Select(r => new RateData { Rate = r.Count(), Id = r.Key }).ToList()); } }
/* * * Faculties * */ public List <Faculty> GetFacultiesView() { using (var db = new ScheduleKSTUContext()) { return(db.Faculty.Select(f => new Faculty { Id = f.Id, FullName = f.FullName, Name = f.Name }).ToList()); } }