/// <summary> /// 获取班级列表 /// </summary> /// <param name="search"></param> /// <returns></returns> public List <DtoSchoolClass> GetSchoolClassList(DtoSchoolClassSearch search) { var list = SchoolClassRepository.GetSchoolClassList(search); SetSchoolClassSchedule(list); return(list); }
public void oneTimeSetUp() { var connection = DbConnectionFactory.CreateTransient(); this.ctx = new ApplicationDbContext(connection); this.repo = new SchoolClassRepository(ctx); new DatabaseSeeder().CreateDependenciesAndSeed(ctx);//heavy duty }
public AddModel( ExamRepository exams, TeacherRepository teachers, SchoolClassRepository schoolClasses, SubjectRepository subjects, IMapper mapper) { _exams = exams; _teachers = teachers; _schoolClasses = schoolClasses; _subjects = subjects; _mapper = mapper; }
public UnitOfWork(LogDbContext dbContext) { _dbContext = dbContext; Classes = new SchoolClassRepository(dbContext); Users = new UserRepository(dbContext); Students = new StudentRepository(dbContext); Teachers = new TeacherRepository(dbContext); Parents = new ParentRepository(dbContext); Subjects = new SubjectRepository(dbContext); SchoolGrades = new SchoolGradeRepository(dbContext); Messages = new MessageRepository(dbContext); Advertisements = new AdvertisementRepository(dbContext); Files = new FileRepository(dbContext); Questions = new QuestionRepository(dbContext); QuestionAnswers = new QuestionAnswerRepository(dbContext); Tests = new TestRepository(dbContext); }
public MemoryStream GenerateCSV() { MemoryStream outStream = new MemoryStream(); StreamWriter writer = new StreamWriter(outStream); // Headings writer.Write("SchoolCode" + delimiter); writer.Write("CourseCode" + delimiter); writer.Write("CourseName" + delimiter); writer.Write("CreditValue" + delimiter); writer.Write("GradeLower" + delimiter); writer.Write("GradeUpper"); writer.Write(Environment.NewLine); // HIGH SCHOOL CLASSES ONLY // - Or more specifically, courses that offer more than zero credits // Get all classes // Make a list of all courses offered SchoolClassRepository classRepository = new SchoolClassRepository(_dbConnectionString); CourseRepository courseRepository = new CourseRepository(_dbConnectionString); SchoolRepository schoolRepo = new SchoolRepository(_dbConnectionString); List <Course> coursesWithCredits = courseRepository.GetAll().Where(x => x.Credits > 0 && x.CurrentlyOffered).ToList(); foreach (School school in schoolRepo.GetAll().Where(x => x.IsHighSchool)) { foreach (Course course in coursesWithCredits) { writer.Write(stringContainer + school.GovernmentID + stringContainer + delimiter); writer.Write(stringContainer + course.CourseCode + stringContainer + delimiter); writer.Write(stringContainer + course.Name + stringContainer + delimiter); writer.Write(stringContainer + course.Credits + stringContainer + delimiter); writer.Write(stringContainer + course.LowGrade + stringContainer + delimiter); writer.Write(stringContainer + course.HighGrade + stringContainer); writer.Write(Environment.NewLine); } } writer.Flush(); outStream.Flush(); return(outStream); }
static void Main(string[] args) { SchoolClassRepository schoolClassRepository = new SchoolClassRepository(); SchoolClass schoolClass = schoolClassRepository.GetById(2); Console.WriteLine($"Klasse! ID: {schoolClass.Id}, Raum: {schoolClass.RoomNumber}"); PupilRepository pupilRepository = new PupilRepository(); Pupil pupil = pupilRepository.GetById(3); Console.WriteLine($"Schüler! ID: {pupil.Id}, Name: {pupil.FirstName} {pupil.LastName}"); RepositoryBase <SchoolClass> schoolClassRepositoryGeneric = new RepositoryBase <SchoolClass>(); SchoolClass schoolClassGeneric = schoolClassRepositoryGeneric.GetById(2); Console.WriteLine($"Klasse! ID: {schoolClassGeneric.Id}, Raum: {schoolClassGeneric.RoomNumber}"); RepositoryBase <Pupil> pupilRepositoryGeneric = new RepositoryBase <Pupil>(); Pupil pupilGeneric = pupilRepositoryGeneric.GetById(3); Console.WriteLine($"Schüler! ID: {pupilGeneric.Id}, Name: {pupilGeneric.FirstName} {pupilGeneric.LastName}"); }
private bool SaveSchoolClass(Yw_SchoolClass schoolClass) { bool result = false; if (schoolClass.Ycc_Id > 0) { //var old = SchoolClassRepository.Get(schoolClass.Ycc_Id); //if (old != null) //{ // schoolClass.Ycc_CreateTime = old.Ycc_CreateTime; // schoolClass.Ycc_Creator = old.Ycc_Creator; // result = SchoolClassRepository.Update(schoolClass); //} result = SchoolClassRepository.Update(schoolClass); } else { var id = SchoolClassRepository.Insert(schoolClass); schoolClass.Ycc_Id = id; result = id > 0; } return(result); }
public MemoryStream GenerateCSV() { MemoryStream outStream = new MemoryStream(); StreamWriter writer = new StreamWriter(outStream); // Headings writer.Write("School_id" + delimiter); writer.Write("Staff_id" + delimiter); writer.Write("Staff_email" + delimiter); writer.Write("First_name" + delimiter); writer.Write("Last_name" + delimiter); writer.Write("Department" + delimiter); writer.Write("Title" + delimiter); writer.Write("Username" + delimiter); writer.Write("Password" + delimiter); writer.Write(Environment.NewLine); StaffRepository _staffRepo = new StaffRepository(_dbConnectionString); List <StaffMember> allStaff = _staffRepo.GetAll(); List <string> seenTeacherCertNumbers = new List <string>(); // Get all sections SchoolClassRepository screpo = new SchoolClassRepository(_dbConnectionString); List <SchoolClass> sections = screpo.GetAll(); // Get all teacher assignments TeacherAssignmentRepository teacherAssignmentRepo = new TeacherAssignmentRepository(_dbConnectionString); List <TeacherAssignment> allTeachingAssignments = teacherAssignmentRepo.GetAll(); // Sort teacher assignments into a dictionary for easier consumption // Only send up classes that have teachers assigned Dictionary <int, List <TeacherAssignment> > assignmentsByClassID = new Dictionary <int, List <TeacherAssignment> >(); foreach (TeacherAssignment ta in allTeachingAssignments) { if (ta.Class != null) { if (!assignmentsByClassID.ContainsKey(ta.Class.iClassID)) { assignmentsByClassID.Add(ta.Class.iClassID, new List <TeacherAssignment>()); } if (ta.Teacher.TeachingCertificateNumber.Length > 0) { assignmentsByClassID[ta.Class.iClassID].Add(ta); } } } // Now make a list of teachers we need Dictionary <int, StaffMember> activeTeachers = new Dictionary <int, StaffMember>(); foreach (int classID in assignmentsByClassID.Keys) { foreach (TeacherAssignment ta in assignmentsByClassID[classID]) { if (ta.Teacher != null) { if (!activeTeachers.ContainsKey(ta.Teacher.iStaffId)) { activeTeachers.Add(ta.Teacher.iStaffId, ta.Teacher); } } } } // Now find all the teachers who aren't on the above list List <StaffMember> activeStaffWithoutClasses = new List <StaffMember>(); foreach (StaffMember teacher in allStaff) { if ((!activeTeachers.ContainsKey(teacher.iStaffId)) && teacher.IsEnabled) { activeStaffWithoutClasses.Add(teacher); } } // Now make the CSV foreach (StaffMember staff in activeStaffWithoutClasses) { if (!string.IsNullOrEmpty(staff.EmailAddress)) { string schoolID = staff.School.DAN; if (staff.School.isFake) { schoolID = "DEFAULT_DISTRICT_OFFICE"; } writer.Write(stringContainer + schoolID + stringContainer + delimiter); // School id writer.Write(stringContainer + staff.EmailAddress + stringContainer + delimiter); // Staff id writer.Write(stringContainer + staff.EmailAddress + stringContainer + delimiter); // staff email writer.Write(stringContainer + staff.FirstName + stringContainer + delimiter); // firstname writer.Write(stringContainer + staff.LastName + stringContainer + delimiter); // lastname writer.Write(stringContainer + "" + stringContainer + delimiter); // department writer.Write(stringContainer + "" + stringContainer + delimiter); // title writer.Write(stringContainer + staff.EmailAddress + stringContainer + delimiter); // username writer.Write(stringContainer + "" + stringContainer + delimiter); // password writer.Write(Environment.NewLine); } } writer.Flush(); outStream.Flush(); return(outStream); }
public MemoryStream GenerateCSV() { MemoryStream outStream = new MemoryStream(); StreamWriter writer = new StreamWriter(outStream); // Headings writer.Write("School_id" + delimiter); writer.Write("Teacher_id" + delimiter); writer.Write("Teacher_number" + delimiter); writer.Write("State_teacher_id" + delimiter); writer.Write("Teacher_email" + delimiter); writer.Write("First_name" + delimiter); writer.Write("Middle_name" + delimiter); writer.Write("Last_name" + delimiter); writer.Write("Title" + delimiter); writer.Write("Username" + delimiter); writer.Write("Password" + delimiter); writer.Write(Environment.NewLine); StaffRepository _staffRepo = new StaffRepository(_dbConnectionString); List <StaffMember> staff = _staffRepo.GetAll(); List <string> seenTeacherCertNumbers = new List <string>(); // Get all sections SchoolClassRepository screpo = new SchoolClassRepository(_dbConnectionString); List <SchoolClass> sections = screpo.GetAll(); // Get all teacher assignments TeacherAssignmentRepository teacherAssignmentRepo = new TeacherAssignmentRepository(_dbConnectionString); List <TeacherAssignment> allTeachingAssignments = teacherAssignmentRepo.GetAll(); // Sort teacher assignments into a dictionary for easier consumption // Only send up classes that have teachers assigned Dictionary <int, List <TeacherAssignment> > assignmentsByClassID = new Dictionary <int, List <TeacherAssignment> >(); foreach (TeacherAssignment ta in allTeachingAssignments) { if (ta.Class != null) { if (!assignmentsByClassID.ContainsKey(ta.Class.iClassID)) { assignmentsByClassID.Add(ta.Class.iClassID, new List <TeacherAssignment>()); } if (ta.Teacher.TeachingCertificateNumber.Length > 0) { assignmentsByClassID[ta.Class.iClassID].Add(ta); } } } // Now make a list of teachers we need Dictionary <int, StaffMember> activeTeachers = new Dictionary <int, StaffMember>(); foreach (int classID in assignmentsByClassID.Keys) { foreach (TeacherAssignment ta in assignmentsByClassID[classID]) { if (ta.Teacher != null) { if (!activeTeachers.ContainsKey(ta.Teacher.iStaffId)) { activeTeachers.Add(ta.Teacher.iStaffId, ta.Teacher); } } } } // Now make the CSV foreach (StaffMember teacher in activeTeachers.Values) { if ((teacher.School.DAN != "0") && (teacher.School.DAN.Length > 1) && (!string.IsNullOrEmpty(teacher.TeachingCertificateNumber) && (!seenTeacherCertNumbers.Contains(teacher.TeachingCertificateNumber)))) { seenTeacherCertNumbers.Add(teacher.TeachingCertificateNumber); writer.Write(stringContainer + teacher.School.DAN + stringContainer + delimiter); // School id writer.Write(stringContainer + teacher.TeachingCertificateNumber + stringContainer + delimiter); // Teacher id writer.Write(stringContainer + teacher.TeachingCertificateNumber + stringContainer + delimiter); // Teacher number writer.Write(stringContainer + "" + stringContainer + delimiter); // State teacher id writer.Write(stringContainer + teacher.EmailAddress + stringContainer + delimiter); // teacher email writer.Write(stringContainer + teacher.FirstName + stringContainer + delimiter); // firstname writer.Write(stringContainer + "" + stringContainer + delimiter); // middlename writer.Write(stringContainer + teacher.LastName + stringContainer + delimiter); // lastname writer.Write(stringContainer + "" + stringContainer + delimiter); // title writer.Write(stringContainer + teacher.EmailAddress + stringContainer + delimiter); // username writer.Write(stringContainer + "" + stringContainer + delimiter); // password writer.Write(Environment.NewLine); } } writer.Flush(); outStream.Flush(); return(outStream); }
public MemoryStream GenerateCSV() { MemoryStream outStream = new MemoryStream(); StreamWriter writer = new StreamWriter(outStream); // Headings writer.Write("School_id" + delimiter); writer.Write("Section_id" + delimiter); writer.Write("Teacher_id" + delimiter); writer.Write("Teacher_2_id" + delimiter); writer.Write("Teacher_3_id" + delimiter); writer.Write("Teacher_4_id" + delimiter); writer.Write("Teacher_5_id" + delimiter); writer.Write("Teacher_6_id" + delimiter); writer.Write("Teacher_7_id" + delimiter); writer.Write("Teacher_8_id" + delimiter); writer.Write("Teacher_9_id" + delimiter); writer.Write("Teacher_10_id" + delimiter); writer.Write("Name" + delimiter); writer.Write("Section_number" + delimiter); writer.Write("Grade" + delimiter); writer.Write("Course_name" + delimiter); writer.Write("Course_number" + delimiter); writer.Write("Course_description" + delimiter); writer.Write("Period" + delimiter); writer.Write("Subject" + delimiter); writer.Write("Term_name" + delimiter); writer.Write("Term_start" + delimiter); writer.Write("Term_end" + delimiter); writer.Write(Environment.NewLine); SchoolClassRepository screpo = new SchoolClassRepository(_dbConnectionString); List <SchoolClass> sections = screpo.GetAll(); TeacherAssignmentRepository teacherAssignmentRepo = new TeacherAssignmentRepository(_dbConnectionString); List <TeacherAssignment> allTeachingAssignments = teacherAssignmentRepo.GetAll(); // Sort teacher assignments into a dictionary for easier consumption // Only send up classes that have teachers assigned Dictionary <int, List <TeacherAssignment> > assignmentsByClassID = new Dictionary <int, List <TeacherAssignment> >(); // Don't send empty classes, so get enrolment counts for each class StudentClassEnrolmentRepository enrolmentRepo = new StudentClassEnrolmentRepository(_dbConnectionString); Dictionary <int, int> enrolmentCountsByClassID = enrolmentRepo.GetEnrolmentCountsByClassID(); foreach (TeacherAssignment ta in allTeachingAssignments) { if (ta.Class != null) { if (!assignmentsByClassID.ContainsKey(ta.Class.iClassID)) { assignmentsByClassID.Add(ta.Class.iClassID, new List <TeacherAssignment>()); } if (ta.Teacher.TeachingCertificateNumber.Length > 0) { assignmentsByClassID[ta.Class.iClassID].Add(ta); } } } foreach (SchoolClass sc in sections) { if (enrolmentCountsByClassID.ContainsKey(sc.iClassID)) { if (enrolmentCountsByClassID[sc.iClassID] > 0) { if (assignmentsByClassID.ContainsKey(sc.iClassID)) { List <TeacherAssignment> thisClassAssignments = assignmentsByClassID[sc.iClassID]; if (thisClassAssignments.Count > 0) { writer.Write(stringContainer + sc.School.DAN + stringContainer + delimiter); // School id writer.Write(stringContainer + sc.iClassID + stringContainer + delimiter); // Section id writer.Write(stringContainer + (thisClassAssignments.Count >= 1 ? thisClassAssignments[0].Teacher.TeachingCertificateNumber.ToString() : string.Empty) + stringContainer + delimiter); // Teacher 1 writer.Write(stringContainer + (thisClassAssignments.Count >= 2 ? thisClassAssignments[1].Teacher.TeachingCertificateNumber.ToString() : string.Empty) + stringContainer + delimiter); // Teacher 2 writer.Write(stringContainer + (thisClassAssignments.Count >= 3 ? thisClassAssignments[2].Teacher.TeachingCertificateNumber.ToString() : string.Empty) + stringContainer + delimiter); // Teacher 3 writer.Write(stringContainer + (thisClassAssignments.Count >= 4 ? thisClassAssignments[3].Teacher.TeachingCertificateNumber.ToString() : string.Empty) + stringContainer + delimiter); // Teacher 4 writer.Write(stringContainer + (thisClassAssignments.Count >= 5 ? thisClassAssignments[4].Teacher.TeachingCertificateNumber.ToString() : string.Empty) + stringContainer + delimiter); // Teacher 5 writer.Write(stringContainer + (thisClassAssignments.Count >= 6 ? thisClassAssignments[5].Teacher.TeachingCertificateNumber.ToString() : string.Empty) + stringContainer + delimiter); // Teacher 6 writer.Write(stringContainer + (thisClassAssignments.Count >= 7 ? thisClassAssignments[6].Teacher.TeachingCertificateNumber.ToString() : string.Empty) + stringContainer + delimiter); // Teacher 7 writer.Write(stringContainer + (thisClassAssignments.Count >= 8 ? thisClassAssignments[7].Teacher.TeachingCertificateNumber.ToString() : string.Empty) + stringContainer + delimiter); // Teacher 8 writer.Write(stringContainer + (thisClassAssignments.Count >= 9 ? thisClassAssignments[8].Teacher.TeachingCertificateNumber.ToString() : string.Empty) + stringContainer + delimiter); // Teacher 9 writer.Write(stringContainer + (thisClassAssignments.Count >= 10 ? thisClassAssignments[9].Teacher.TeachingCertificateNumber.ToString() : string.Empty) + stringContainer + delimiter); // Teacher 10 writer.Write(stringContainer + sc.Name + stringContainer + delimiter); // Name writer.Write(stringContainer + sc.Section + stringContainer + delimiter); // Section number writer.Write(stringContainer + "" + stringContainer + delimiter); // Grade writer.Write(stringContainer + sc.Course.Name + stringContainer + delimiter); // Course Name writer.Write(stringContainer + sc.Course.CourseCode + stringContainer + delimiter); // Course Number writer.Write(stringContainer + "" + stringContainer + delimiter); // Course Description writer.Write(stringContainer + "" + stringContainer + delimiter); // Period writer.Write(stringContainer + "" + stringContainer + delimiter); // Subject writer.Write(stringContainer + "" + stringContainer + delimiter); // Term name writer.Write(stringContainer + "" + stringContainer + delimiter); // Term start writer.Write(stringContainer + "" + stringContainer + delimiter); // Term end writer.Write(Environment.NewLine); } } } } } writer.Flush(); outStream.Flush(); return(outStream); }
/// <summary> /// 根据课程id查班级 /// </summary> /// <param name="courseId"></param> /// <param name="schoolId"></param> /// <returns></returns> public List <Yw_SchoolClass> GetSchoolClassByCourseId(int courseId, int schoolId) { return(SchoolClassRepository.GetSchoolClassByCourseId(courseId, schoolId)); }
public Yw_SchoolClass GetSchoolClass(int classId) { return(SchoolClassRepository.Get(classId)); }
public bool IncrementStudentCount(int classId, int count, int oper) { return(SchoolClassRepository.IncrementStudentCount(classId, count, oper)); }