public IEnumerable <LoadFlowDTO> GetLoadFlows() { IEnumerable <LoadFlow> getListLoad = Database.LoadFlows.GetAll().ToList(); List <LoadFlowDTO> getListLoadDTOs = new List <LoadFlowDTO>(); foreach (LoadFlow item in getListLoad) { ContentOfThePlan contentOfThePlan = Database.ContentOfThePlans.Get(item.ContentOfThePlanId); int numberOfStudent = 0; List <Subgroup> getList = Database.Subgroups.GetAll().Where(c => c.LectureFlowId == item.LectureFlowId).ToList(); for (int i = 0; i < getList.Count(); i++) { numberOfStudent += getList[i].NumberOfStudents; } //var a = getList.Where(c => c.LectureFlowId == item.LectureFlowId); int hourСredit = 0; int houreExam = 0; if (contentOfThePlan.Reporting == "Зачет") { //contentOfThePlan.NumberOfHoursOfPractice += 2; hourСredit += 2; } else { //contentOfThePlan.NumberOfHoursOfPractice += (20 * subgroup.NumberOfStudents)/60 ; houreExam += (20 * numberOfStudent) / 60; } getListLoadDTOs.Add(new LoadFlowDTO { Id = item.Id, Name = Database.Employees.Get(item.EmployeeId).LastName + " " + Database.Employees.Get(item.EmployeeId).Patronymic, Title = Database.LectureFlows.Get(item.LectureFlowId).Title, //NumberOfStudents = Database.Subgroups.Get(item.SubgroupId).NumberOfStudents, NumberOfHoursOfLectures = Database.ContentOfThePlans.Get(item.ContentOfThePlanId).NumberOfHoursOfLectures, //NumberOfHoursOfPractice = contentOfThePlan.NumberOfHoursOfPractice, /*Database.ContentOfThePlans.Get(item.ContentOfThePlanId).NumberOfHoursOfPractice,*/ NumberOfHoursOfOffset = hourСredit, NumberOfHoursOfExamination = houreExam, Reporting = Database.ContentOfThePlans.Get(item.ContentOfThePlanId).Reporting, DisciplineId = Database.ContentOfThePlans.Get(item.ContentOfThePlanId).DisciplineId, DisciplineName = Database.Disciplines.Get(Database.ContentOfThePlans.Get(item.ContentOfThePlanId).DisciplineId).Name, //DisciplineName = Database.ContentOfThePlans.Get(item.ContentOfThePlanId) }); } return(getListLoadDTOs); }
public void CreateContentOfThePlan(ContentOfThePlanDTO contentOfThePlanDTO) { if (contentOfThePlanDTO == null) { throw new ValidationException("Введите данные", ""); } ContentOfThePlan contentOfThePlan = new ContentOfThePlan { NumberOfHoursOfLectures = contentOfThePlanDTO.NumberOfHoursOfLectures, NumberOfHoursOfPractice = contentOfThePlanDTO.NumberOfHoursOfPractice, Reporting = contentOfThePlanDTO.Reporting, SemesterNumber = contentOfThePlanDTO.SemesterNumber, AcademicPlanId = contentOfThePlanDTO.AcademicPlanId, DisciplineId = contentOfThePlanDTO.DisciplineId }; Database.ContentOfThePlans.Create(contentOfThePlan); Database.Save(); }
public IEnumerable <LoadSubgroupDTO> GetLoads() { IEnumerable <LoadSubgroup> getListLoad = Database.LoadSubgroups.GetAll().ToList(); List <LoadSubgroupDTO> getListLoadDTOs = new List <LoadSubgroupDTO>(); foreach (LoadSubgroup item in getListLoad) { ContentOfThePlan contentOfThePlan = Database.ContentOfThePlans.Get(item.ContentOfThePlanId); Subgroup subgroup = Database.Subgroups.Get(item.SubgroupId); int hourСredit = 0; int houreExam = 0; if (contentOfThePlan.Reporting == "Зачет") { //contentOfThePlan.NumberOfHoursOfPractice += 2; hourСredit += 2; } else { //contentOfThePlan.NumberOfHoursOfPractice += (20 * subgroup.NumberOfStudents)/60 ; houreExam += (20 * subgroup.NumberOfStudents) / 60; } getListLoadDTOs.Add(new LoadSubgroupDTO { Id = item.Id, Name = Database.Employees.Get(item.EmployeeId).LastName + " " + Database.Employees.Get(item.EmployeeId).Patronymic, GroupNumber = Database.Subgroups.Get(item.SubgroupId).GroupNumber, //NumberOfStudents = Database.Subgroups.Get(item.SubgroupId).NumberOfStudents, //NumberOfHoursOfLectures = Database.ContentOfThePlans.Get(item.ContentOfThePlanId).NumberOfHoursOfLectures, NumberOfHoursOfPractice = contentOfThePlan.NumberOfHoursOfPractice, /*Database.ContentOfThePlans.Get(item.ContentOfThePlanId).NumberOfHoursOfPractice,*/ NumberOfHoursOfOffset = hourСredit, NumberOfHoursOfExamination = houreExam, //Reporting = Database.ContentOfThePlans.Get(item.ContentOfThePlanId).Reporting, DisciplineId = Database.ContentOfThePlans.Get(item.ContentOfThePlanId).DisciplineId, DisciplineName = Database.Disciplines.Get(Database.ContentOfThePlans.Get(item.ContentOfThePlanId).DisciplineId).Name, //DisciplineName = Database.ContentOfThePlans.Get(item.ContentOfThePlanId) }); } return(getListLoadDTOs); }