public int GetRegisteredTeachersCount(Subjects subject)
{
EducationDatabaseEntities ent = new EducationDatabaseEntities();
ISubjectsUsersRepository suRepo = new SubjectsUsersRepository(ent);
return(suRepo.GetAll().Where(x => x.SubjectId == subject.Id).Where(x => x.Users.UserType == "Teacher").Count());
}
public void RegisterUserToSubject(Users user, Subjects subject)
{
EducationDatabaseEntities ent = new EducationDatabaseEntities();
ISubjectsUsersRepository suRepo = new SubjectsUsersRepository(ent);
bool allowOperation = (suRepo.GetAll().Where(x => x.UserId == user.Id).Where(x => x.SubjectId == subject.Id).Count() > 0); // Szerepel már benne?
if (allowOperation)
{
suRepo.Add(new SubjectsUsers()
{
EnrollDate = DateTime.Now,
SubjectId = subject.Id,
UserId = user.Id
});
}
}
public string GetSubjectTeacherName(Subjects subject)
{
SubjectsUsers subjUser = new SubjectsUsers();
subjUser = GetAll().Where(u => u.SubjectId == subject.Id).FirstOrDefault();
EducationDatabaseEntities ent = new EducationDatabaseEntities();
ITeachersRepository teacherRepo = new TeachersRepository(ent);
IUsersRepository userRepo = new UsersRepository(ent);
Teachers teacher = new Teachers();
teacher = teacherRepo.GetAll().Where(t => t.UserId == subjUser.UserId).FirstOrDefault();
if (teacher != null)
{
Users CurrentUser = userRepo.GetAll().Where(u => u.Id == teacher.UserId).FirstOrDefault();
string name = $"{CurrentUser.FirstName} {CurrentUser.MiddleName} {CurrentUser.LastName}";
return(name);
}
return(null);
}
private EducationDatabaseEntities getEntities()
{
EducationDatabaseEntities ent = new EducationDatabaseEntities();
return(ent);
}
