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));
}
