public void createRubric(Rubric rubric) { NpgsqlConnection connection = DBConnectionService.getFreeConnection(); NpgsqlCommand command = new NpgsqlCommand(createRubricCommand, connection); command.Parameters.AddWithValue("@title", NpgsqlTypes.NpgsqlDbType.Text, rubric.title); command.Parameters.AddWithValue("@parentID", NpgsqlTypes.NpgsqlDbType.Integer, rubric.parentID); int result = command.ExecuteNonQuery(); DBConnectionService.returnConnection(connection); }
public void updateRubric(Rubric user) { RubricsRepository.Singleton.updateRubric(user); }
public void createRubric(Rubric user) { RubricsRepository.Singleton.createRubric(user); }
public void updateRubric(Rubric rubric) { NpgsqlConnection connection = DBConnectionService.getFreeConnection(); NpgsqlCommand command = new NpgsqlCommand(updateRubricCommand, connection); command.Parameters.AddWithValue("@id", NpgsqlTypes.NpgsqlDbType.Integer, rubric.id); command.Parameters.AddWithValue("@title", NpgsqlTypes.NpgsqlDbType.Text, rubric.title); command.Parameters.AddWithValue("@parentID", NpgsqlTypes.NpgsqlDbType.Text, rubric.parentID); int result = command.ExecuteNonQuery(); if (result != 1) { throw new Exception("Error on rubric update"); } DBConnectionService.returnConnection(connection); }