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