• Главная
• TRManager
• UtilityDB

C# Класс TRManager.UtilityDB

Показать файл Открыть проект

Открытые методы

Метод	Описание
addFullIncident ( int ticket_ID, int student_ID, int teacher_ID, System.DateTime arrival, String comment, System.DateTime leave ) : System.Boolean	Adds an Complete incident to the database.
addIncident ( int ticket_ID, int student_ID, int teacher_ID, System.DateTime arrival, String comment ) : System.Boolean	Adds an incident to the database.
getAllIncidents ( ) : List
getClass ( String className ) : Class	Gets a class object by ClassName.
getClass ( int class_ID ) : Class	Gets a class object by Class_ID.
getClassTable ( ) : List	Gets the class table for export.
getClassTeacher ( String className ) : Teacher	Gets a teacher object by className.
getClasses ( ) : List	Gets a list of all classes.
getCommentTable ( ) : List
getExportData ( ) : List	Gets all incidents combined with related data for export.
getIncident ( int incident_ID ) : Incident	Gets an incident object by Incident_ID.
getIncidentTable ( ) : List	Gets the incident table for export.
getMaxTicket_ID ( ) : String	Gets the maximum ticket_ identifier.
getOpenIncidents ( ) : List	Gets a list of the open incidents.
getOpenIncidents ( List StudentIDs, List TeacherIDs, int TicketID ) : List
getReturnerTicketID ( int StudentID ) : int	Gets the teacher table for export.
getStudent ( int student_ID ) : Student	Gets a student object.
getStudent ( string givenName, string surname ) : Student	Gets a student object by givenName and surname of the student.
getStudentFilter ( string name ) : List
getStudentIncidents ( int student_ID ) : List
getStudentTable ( ) : List	Gets the student table for export.
getStudents ( int class_ID ) : List	Gets the students of a class by Class_ID.
getStudents ( string className ) : List	Gets a list of student objects by the name of the class.
getTeacher ( String initials ) : Teacher	Gets a teacher objectby the initials.
getTeacher ( String givenName, String surname ) : Teacher	Gets a teacher objectby the full name.
getTeacher ( int teacher_ID ) : Teacher	Gets a teacher object by Teacher_ID.
getTeacherFilter ( String filter ) : List
getTeacherTable ( ) : List
incidentIsOpen ( int inc_id ) : System.Boolean
setAdminPassword ( String pass ) : System.Boolean	Set Admin-Password in DB
setLeaveTime ( Incident i ) : System.Boolean	Sets the leave time of an incident to the current time.
validateAdmin ( String pass ) : System.Boolean	Validate Admin-Password

Приватные методы

Метод	Описание
closeconnection ( ) : void	Closes the connection to the database.
openconnection ( ) : void	Opens the connection to the database.

Описание методов