// DELETE parties/values/id public void Delete(int id) { DatabaseOperations db = new DatabaseOperations(); MySqlCommand command = new MySqlCommand("DELETE FROM Parties WHERE PartieId=@Id"); command.Parameters.AddWithValue("@Id", id); db.ExecuteQuery(command); }
// POST classRooms/values public void Post([FromBody] ClassRoom data) { DatabaseOperations db = new DatabaseOperations(); MySqlCommand command = new MySqlCommand("INSERT INTO ClassRooms(Name, CreationTime) VALUES(@Name, @CreationTime)"); command.Parameters.AddWithValue("@Name", data.Name); command.Parameters.AddWithValue("@CreationTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); db.ExecuteQuery(command); }
// POST notifications/values public void Post([FromBody] Notification data) { DatabaseOperations db = new DatabaseOperations(); MySqlCommand command = new MySqlCommand("INSERT INTO Notifications(Title, Message, CreationTime) VALUES(@Title, @Message, @CreationTime)"); command.Parameters.AddWithValue("@Title", data.Title); command.Parameters.AddWithValue("@Message", data.Message); command.Parameters.AddWithValue("@CreationTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); db.ExecuteQuery(command); }
// POST studentClasses/values public void Post([FromBody] StudentClasse data) { DatabaseOperations db = new DatabaseOperations(); MySqlCommand command = new MySqlCommand("INSERT INTO StudentClasses(StudentId, ClasseId, CreationTime) VALUES(@StudentId, @ClasseId, @CreationTime)"); command.Parameters.AddWithValue("@StudentId", data.StudentId); command.Parameters.AddWithValue("@ClasseId", data.ClasseId); command.Parameters.AddWithValue("@CreationTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); db.ExecuteQuery(command); }
// POST candidats/values public void Post([FromBody] Candidat data) { DatabaseOperations db = new DatabaseOperations(); MySqlCommand command = new MySqlCommand("INSERT INTO Candidats(Nume, Descriere, Functie, CreationTime) VALUES(@Nume, @Descriere, @Functie, @CreationTime)"); command.Parameters.AddWithValue("@Nume", data.Nume); command.Parameters.AddWithValue("@Descriere", data.Descriere); command.Parameters.AddWithValue("@Functie", data.Functie); command.Parameters.AddWithValue("@CreationTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); db.ExecuteQuery(command); }
// POST tokenUsers/values public void Post([FromBody] TokenUser data) { DatabaseOperations db = new DatabaseOperations(); MySqlCommand command = new MySqlCommand("INSERT INTO TokenUsers(Username, Password, Type, CreationTime) VALUES(@Username, @Password, @Type, @CreationTime)"); command.Parameters.AddWithValue("@Username", data.Username); command.Parameters.AddWithValue("@Password", data.Password); command.Parameters.AddWithValue("@Type", data.Type); command.Parameters.AddWithValue("@CreationTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); db.ExecuteQuery(command); }
// POST cards/values public void Post([FromBody] Card data) { DatabaseOperations db = new DatabaseOperations(); MySqlCommand command = new MySqlCommand("INSERT INTO Cards(PlayerId, Type, Number, CreationTime) VALUES(@PlayerId, @Type, @Number, @CreationTime)"); command.Parameters.AddWithValue("@PlayerId", data.PlayerId); command.Parameters.AddWithValue("@Type", data.Type); command.Parameters.AddWithValue("@Number", data.Number); command.Parameters.AddWithValue("@CreationTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); db.ExecuteQuery(command); }
// 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 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 marks/values public void Post([FromBody] Mark data) { DatabaseOperations db = new DatabaseOperations(); MySqlCommand command = new MySqlCommand("INSERT INTO Marks(ClasseId, StudentId, TeacherId, Value, Date, CreationTime) VALUES(@ClasseId, @StudentId, @TeacherId, @Value, @Date, @CreationTime)"); command.Parameters.AddWithValue("@ClasseId", data.ClasseId); command.Parameters.AddWithValue("@StudentId", data.StudentId); command.Parameters.AddWithValue("@TeacherId", data.TeacherId); command.Parameters.AddWithValue("@Value", data.Value); command.Parameters.AddWithValue("@Date", data.Date); 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); }