public Room GetRoomWithStudents(int id) { _logger.LogInfo($"Geting room with students by Id {id}"); Room room = null; var query = @"SELECT * FROM [Rooms] WHERE [Id] = @IdParameter"; var studentsForThisRoom = GetStudentsByRoomId(id); try { using (var reader = _dbConnection.ExecuteReader(query, new { IdParameter = id })) { while (reader.Read()) { room = new Room() { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), FreePlaces = Convert.ToInt32(reader["FreePlaces"]), TotalPlaces = Convert.ToInt32(reader["TotalPlaces"]), Faculty = _facultyService.GetFacultyById(Convert.ToInt32(reader["FacultyId"])), Students = studentsForThisRoom }; } } } catch (Exception e) { Console.WriteLine(e.Message); } return(room); }
public List <Administrator> GetAdministrators() { _logger.LogInfo("Gettting Administrators"); var query = "SELECT * FROM [Administrators]"; var administrators = new List <Administrator>(); using (var reader = _dbConnection.ExecuteReader(query)) { while (reader.Read()) { Faculty faculty = null; if (reader["FacultyId"] != DBNull.Value) { faculty = _facultyService.GetFacultyById(Convert.ToInt32(reader["FacultyId"])); } administrators.Add(new Administrator() { Id = Convert.ToInt32(reader["Id"]), Email = reader["Email"].ToString(), PhoneNumber = reader["PhoneNumber"].ToString(), Faculty = faculty, FullName = reader["FullName"].ToString(), User = _userService.GetUserById(Convert.ToInt32(reader["UserId"])) }); } } return(administrators); }
public ActionResult Update(short id) { var facultyInDb = _facultyService.GetFacultyById(id); if (facultyInDb == null) { return(HttpNotFound()); } var facultyDto = Mapper.Map <Faculty, FacultyDto>(facultyInDb); var universityDtos = new List <UniversityDto>(); var universitiesInDb = _universityService.GetUniversities(); foreach (var university in universitiesInDb) { universityDtos.Add(Mapper.Map <University, UniversityDto>(university)); } var universityOfThisFaculty = _universityService.GetUniversityByFacultyId(id); var viewModel = new FacultyFormViewModel { FacultyDto = facultyDto, UniversityDtos = universityDtos, UniversityId = universityOfThisFaculty != null ? universityOfThisFaculty.Id : (short)0 }; return(View(viewModel)); }
public void TestGetFacultyById() { var mockFacultiesSet = CreateMockFacultySet(); mockFacultiesSet.Setup(x => x.Include(It.IsAny <string>())).Returns(mockFacultiesSet.Object); _mockStudentExchangeDataContext.Setup(c => c.Faculties).Returns(mockFacultiesSet.Object); var result = _facultyService.GetFacultyById(1L); Assert.AreSame(_facultySet.ToList().Find(f => f.Id == 1L), result); }
public List <Student> GetStudents() { _logger.LogInfo($"Getting students"); var query = "SELECT * FROM [Students]"; var students = new List <Student>(); using (var reader = _dbConnection.ExecuteReader(query)) { while (reader.Read()) { Faculty faculty = null; Group group = null; Room room = null; if (reader["FacultyId"] != DBNull.Value) { faculty = _facultyService.GetFacultyById(Convert.ToInt32(reader["FacultyId"])); } if (reader["GroupId"] != DBNull.Value) { group = _groupService.GetGroupById(Convert.ToInt32(reader["GroupId"])); } if (reader["RoomId"] != DBNull.Value) { room = _roomService.GetSimpleRoomById(Convert.ToInt32(reader["RoomId"])); } students.Add(new Student() { Id = Convert.ToInt32(reader["Id"]), Email = reader["Email"].ToString(), PhoneNumber = reader["PhoneNumber"].ToString(), Faculty = faculty, FullName = reader["FullName"].ToString(), StudentCategory = _studentCategoryService.GetStudentCategoryById(Convert.ToInt32(reader["CategoryId"])), User = _userService.GetUserById(Convert.ToInt32(reader["UserId"])), Group = group, Room = room, StudentCardId = reader["StudentCardId"].ToString(), StudyYear = Convert.ToInt32(reader["StudyYear"]) }); } } return(students); }
public List <Group> GetGroups() { _logger.LogInfo("Getting Groups"); var query = "SELECT * FROM [Groups]"; var groups = new List <Group>(); using (var reader = _dbConnection.ExecuteReader(query)) { while (reader.Read()) { groups.Add(new Group() { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), Faculty = _facultyService.GetFacultyById(Convert.ToInt32(reader["FacultyId"])) }); } } return(groups); }
public Faculty GetFacultyById(int facultyId) { _logger.LogInfo("API HttpGet api/faculties/{facultyId}"); try { return(_facultyService.GetFacultyById(facultyId)); } catch (System.Exception e) { _logger.LogError("API HttpGet api/faculties/{facultyId} " + e.Message); throw e; } }
public IActionResult Index() { var students = _studentService.GetStudents(); foreach (var st in students) { st.Faculty = _facultyService.GetFacultyById(st.FacultyId); } var faculties = _facultyService.GetFaculties(); ViewModel viewModel = new ViewModel { Students = students, Faculties = faculties }; // viewModel.Students = students; // viewModel.Faculties = faculties; // var students = _context.Students.ToList(); // students.Add(new Student{Id = 1, Name = "Phan Vu", Age=22, Address="Gia Lai"}); // students.Add(new Student{Id = 2, Name = "Phan Vu1", Age=22, Address="Gia Lai"}); // students.Add(new Student{Id = 3, Name = "Phan Vu2", Age=22, Address="Gia Lai"}); //Viewbag.students //ViewData["students"] = students; return(View(viewModel)); }
public Faculty Get(long id) { return(_facultyService.GetFacultyById(id)); }