private void LoadStudents() { LoadRoomInfo(); Student student = new StudentAccess().GetStudent(txtStudentId.Text); LoadStatus(); UIUtil.FillStudent(txtStudentName, txtStudentMail, txtStudentPhone, lbAvailable, student); if (student == null) { return; } lbAvailable.Text = "Not checked in yet"; lbAvailable.ForeColor = Color.Orange; if (student.Id.Length > 0 && new StudentAccess().isStudentAvailable(txtStudentId.Text)) { UIUtil.FillStatus(txtElec, txtWater, txtExtra, txtExtraInfo, txtInfo, checkComplete, null); } else { lbAvailable.Text = "Found!"; lbAvailable.ForeColor = Color.Green; LoadRoomInfo(); } }
private List <Student> GetStudentsSortedById() { StudentAccess context = new StudentAccess(); SortStudents studentsSort = new SortStudents(); List <Student> sortedStudents = studentsSort.GenerateSortedList(context.GetAll()); return(sortedStudents); }
public Admin(string FirstName, string LastName, string ID) : base(FirstName, LastName) { adminID = ID; IoC.RegisterObject <IDBAccess, DBAccess>(); IoC.RegisterObject <ISubject, Subject>(); IoC.RegisterObject <IGroup, Group>(); dbAccess = new DBAccess(); teacherAccess = new TeacherAccess(dbAccess); groupAccess = new GroupAccess(dbAccess); subjectAccess = new SubjectAccess(dbAccess); accountAccess = new AccountAccess(dbAccess); studentAccess = new StudentAccess(dbAccess); }
private void LoadStatus() { string studentID = txtStudentId.Text; int month; int year; StudentStatus status = null; try { studentID = txtStudentId.Text; month = int.Parse(cbMonth.Text); year = int.Parse(cbYear.Text); status = new StudentAccess().GetStudentStatus(studentID, month, year); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { btnUpdate.Enabled = UIUtil.FillStatus(txtElec, txtWater, txtExtra, txtExtraInfo, txtInfo, checkComplete, status); } }
public void OnGet() { int userID = Convert.ToInt32(HttpContext.User.Claims.Where(claim => claim.Type == "ID").Select(c => c.Value).FirstOrDefault()); AccountAccess accountAccess = new AccountAccess(new DBAccess()); int id = accountAccess.GetUserId(userID, "student"); StudentAccess studentAccess = new StudentAccess(new DBAccess()); Logic.Users.Student student = studentAccess.GetStudentByID(id); studentController = new StudentController(student); subjects = studentController.GetSubjectsOfStudent(); exams = studentController.GetExamsOfStudent(); foreach (Exam exam in exams) { Result result = studentController.GetResultsOfStudent(exam.id); if (result == null) { results.Add(new Result(exam, student, new List <AnsweredQuestion>())); } } }
private void AddStudentToDB(Student aStudent) { StudentAccess context = new StudentAccess(); context.Add(aStudent); }
public StudentService() { this.studentAccess = new StudentAccess(); }
private void LoadYears() { List <int> years = StudentAccess.GenerateYear(); cbYear.DataSource = years; }