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