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