// GET users/values public IEnumerable <User> Get() { MySqlDataReader reader = new DatabaseOperations().GetReader("SELECT * FROM Users"); List <User> list = new List <User>(); while (reader.Read()) { list.Add(new User( (int)reader["UserId"], (string)reader["FirstName"], (string)reader["LastName"], (string)reader["Email"], (int)reader["Type"], (DateTime)reader["CreationTime"] )); } return(list); }
// GET tokens/values public IEnumerable <Token> Get() { MySqlDataReader reader = new DatabaseOperations().GetReader("SELECT * FROM Tokens"); List <Token> list = new List <Token>(); while (reader.Read()) { list.Add(new Token( (int)reader["TokenId"], (int)reader["TokenUserId"], (NOT_EXISTING)reader["Value"], (string)reader["Address"], (DateTime)reader["LastUpdate"], (DateTime)reader["CreationTime"] )); } return(list); }
// GET absente/values public IEnumerable <Absente> Get() { MySqlDataReader reader = new DatabaseOperations().GetReader("SELECT * FROM Absente"); List <Absente> list = new List <Absente>(); while (reader.Read()) { list.Add(new Absente( (int)reader["AbsenteId"], (int)reader["ClasseId"], (int)reader["StudentId"], (int)reader["TeacherId"], (DateTime)reader["Date"], (DateTime)reader["CreationTime"] )); } return(list); }
// GET marks/values public IEnumerable <Mark> Get() { MySqlDataReader reader = new DatabaseOperations().GetReader("SELECT * FROM Marks"); List <Mark> list = new List <Mark>(); while (reader.Read()) { list.Add(new Mark( (int)reader["MarkId"], (int)reader["ClasseId"], (int)reader["StudentId"], (int)reader["TeacherId"], (int)reader["Value"], (DateTime)reader["Date"], (DateTime)reader["CreationTime"] )); } return(list); }
// GET candidates/values public IEnumerable <Candidate> Get() { MySqlDataReader reader = new DatabaseOperations().GetReader("SELECT * FROM Candidates"); List <Candidate> list = new List <Candidate>(); while (reader.Read()) { list.Add(new Candidate( (int)reader["CandidateId"], (string)reader["Name"], (string)reader["Email"], (string)reader["Password"], (string)reader["Description"], (string)reader["Role"], (DateTime)reader["CreationTime"] )); } return(list); }