// POST users/values
public void Post([FromBody] User data)
{
DatabaseOperations db = new DatabaseOperations();
MySqlCommand command = new MySqlCommand("INSERT INTO Users(FirstName, LastName, Email, Type, CreationTime) VALUES(@FirstName, @LastName, @Email, @Type, @CreationTime)");
command.Parameters.AddWithValue("@FirstName", data.FirstName);
command.Parameters.AddWithValue("@LastName", data.LastName);
command.Parameters.AddWithValue("@Email", data.Email);
command.Parameters.AddWithValue("@Type", data.Type);
command.Parameters.AddWithValue("@CreationTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
db.ExecuteQuery(command);
}
// POST absente/values
public void Post([FromBody] Absente data)
{
DatabaseOperations db = new DatabaseOperations();
MySqlCommand command = new MySqlCommand("INSERT INTO Absente(ClasseId, StudentId, TeacherId, Date, CreationTime) VALUES(@ClasseId, @StudentId, @TeacherId, @Date, @CreationTime)");
command.Parameters.AddWithValue("@ClasseId", data.ClasseId);
command.Parameters.AddWithValue("@StudentId", data.StudentId);
command.Parameters.AddWithValue("@TeacherId", data.TeacherId);
command.Parameters.AddWithValue("@Date", data.Date);
command.Parameters.AddWithValue("@CreationTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
db.ExecuteQuery(command);
}
// POST tokens/values
public void Post([FromBody] Token data)
{
DatabaseOperations db = new DatabaseOperations();
MySqlCommand command = new MySqlCommand("INSERT INTO Tokens(TokenUserId, Value, Address, LastUpdate, CreationTime) VALUES(@TokenUserId, @Value, @Address, @LastUpdate, @CreationTime)");
command.Parameters.AddWithValue("@TokenUserId", data.TokenUserId);
command.Parameters.AddWithValue("@Value", data.Value);
command.Parameters.AddWithValue("@Address", data.Address);
command.Parameters.AddWithValue("@LastUpdate", data.LastUpdate);
command.Parameters.AddWithValue("@CreationTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
db.ExecuteQuery(command);
}
// POST candidates/values
public void Post([FromBody] Candidate data)
{
DatabaseOperations db = new DatabaseOperations();
MySqlCommand command = new MySqlCommand("INSERT INTO Candidates(Name, Email, Password, Description, Role, CreationTime) VALUES(@Name, @Email, @Password, @Description, @Role, @CreationTime)");
command.Parameters.AddWithValue("@Name", data.Name);
command.Parameters.AddWithValue("@Email", data.Email);
command.Parameters.AddWithValue("@Password", data.Password);
command.Parameters.AddWithValue("@Description", data.Description);
command.Parameters.AddWithValue("@Role", data.Role);
command.Parameters.AddWithValue("@CreationTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
db.ExecuteQuery(command);
}
// PUT candidates/valuesd
public void PUT([FromBody] Candidate data)
{
DatabaseOperations db = new DatabaseOperations();
MySqlCommand command = new MySqlCommand("UPDATE Candidates SET Name=@Name, Email=@Email, Password=@Password, Description=@Description, Role=@Role WHERE CandidateId=@Id");
command.Parameters.AddWithValue("@Id", data.CandidateId);
command.Parameters.AddWithValue("@Name", data.Name);
command.Parameters.AddWithValue("@Email", data.Email);
command.Parameters.AddWithValue("@Password", data.Password);
command.Parameters.AddWithValue("@Description", data.Description);
command.Parameters.AddWithValue("@Role", data.Role);
command.Parameters.AddWithValue("@CreationTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
db.ExecuteQuery(command);
}
// GET classRooms/values
public IEnumerable <ClassRoom> Get()
{
MySqlDataReader reader = new DatabaseOperations().GetReader("SELECT * FROM ClassRooms");
List <ClassRoom> list = new List <ClassRoom>();
while (reader.Read())
{
list.Add(new ClassRoom(
(int)reader["ClassRoomId"],
(string)reader["Name"],
(DateTime)reader["CreationTime"]
));
}
return(list);
}
// GET notifications/values
public IEnumerable <Notification> Get()
{
MySqlDataReader reader = new DatabaseOperations().GetReader("SELECT * FROM Notifications");
List <Notification> list = new List <Notification>();
while (reader.Read())
{
list.Add(new Notification(
(int)reader["NotificationId"],
(string)reader["Title"],
(DateTime)reader["CreationTime"]
));
}
return(list);
}
// GET parties/values
public IEnumerable <Partie> Get()
{
MySqlDataReader reader = new DatabaseOperations().GetReader("SELECT * FROM Parties");
List <Partie> list = new List <Partie>();
while (reader.Read())
{
list.Add(new Partie(
(int)reader["PartieId"],
(string)reader["Name"],
(int)reader["Position"],
(DateTime)reader["CreationTime"]
));
}
return(list);
}
// GET players/values
public IEnumerable <Player> Get()
{
MySqlDataReader reader = new DatabaseOperations().GetReader("SELECT * FROM Players");
List <Player> list = new List <Player>();
while (reader.Read())
{
list.Add(new Player(
(int)reader["PlayerId"],
(string)reader["Name"],
(int)reader["Type"],
(DateTime)reader["CreationTime"]
));
}
return(list);
}
// GET students/values
public IEnumerable <Student> Get()
{
MySqlDataReader reader = new DatabaseOperations().GetReader("SELECT * FROM Students");
List <Student> list = new List <Student>();
while (reader.Read())
{
list.Add(new Student(
(int)reader["StudentId"],
(string)reader["Name"],
(string)reader["Email"],
(DateTime)reader["CreationTime"]
));
}
return(list);
}
// GET studentClasses/values
public IEnumerable <StudentClasse> Get()
{
MySqlDataReader reader = new DatabaseOperations().GetReader("SELECT * FROM StudentClasses");
List <StudentClasse> list = new List <StudentClasse>();
while (reader.Read())
{
list.Add(new StudentClasse(
(int)reader["StudentClasseId"],
(int)reader["StudentId"],
(int)reader["ClasseId"],
(DateTime)reader["CreationTime"]
));
}
return(list);
}
// GET candidats/values
public IEnumerable <Candidat> Get()
{
MySqlDataReader reader = new DatabaseOperations().GetReader("SELECT * FROM Candidats");
List <Candidat> list = new List <Candidat>();
while (reader.Read())
{
list.Add(new Candidat(
(int)reader["CandidatId"],
(string)reader["Nume"],
(string)reader["Descriere"],
(string)reader["Functie"],
(DateTime)reader["CreationTime"]
));
}
return(list);
}
// GET cards/values
public IEnumerable <Card> Get()
{
MySqlDataReader reader = new DatabaseOperations().GetReader("SELECT * FROM Cards");
List <Card> list = new List <Card>();
while (reader.Read())
{
list.Add(new Card(
(int)reader["CardId"],
(int)reader["PlayerId"],
(int)reader["Type"],
(int)reader["Number"],
(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 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);
}
