void Start()
{
Student_DAO studentDAO = new Student_DAO();
//display all students
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Displaying all students...");
Console.ResetColor();
List <Student> students = studentDAO.Db_Get_All_Students();
foreach (Student student in students)
{
Console.WriteLine(student);
}
Console.ReadKey();
//display all teachers
Teacher_DAO teacherDAO = new Teacher_DAO();
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Displaying all teachers...");
Console.ResetColor();
List <Teacher> teachers = teacherDAO.Db_Get_All_Teachers();
foreach (Teacher teacher in teachers)
{
Console.WriteLine(teacher);
}
Console.ReadKey();
//display all rooms
Room_DAO roomDAO = new Room_DAO();
//display all students
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Displaying all rooms...");
Console.ResetColor();
List <Room> rooms = roomDAO.Db_Get_All_Rooms();
foreach (Room room in rooms)
{
Console.WriteLine(room);
}
Console.ReadKey();
}
//Delete room
public static void DeleteRoom(string id)
{
Room_DAO.DeleteRoom(id);
}
//Find room by id
public static DataTable FindRoomById(string id)
{
return(Room_DAO.FindRoomById(id));
}
//Edit info room
public static void EditRoom(Room_DTO room)
{
Room_DAO.EditRoom(room);
}
//Add a room
public static void AddRoom(Room_DTO room)
{
Room_DAO.AddRoom(room);
}
//Show all rooms
public static DataTable ListRoom()
{
return(Room_DAO.ListRoom());
}
public List <Room> getRoomsOverview()
{
Room_DAO room_DAO = new Room_DAO();
return(room_DAO.getAllRoomsWithUsers());
}
