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