public EnvironmentalQuestion Select(int index)
{
OracleCommand command = new OracleCommand();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "SELECT * FROM ENVIRONMENTALQUESTIONS " +
"WHERE id=:id";
OracleParameter id = new OracleParameter();
id.ParameterName = ":id";
id.DbType = System.Data.DbType.Int32;
id.Value = index;
command.Parameters.Add(id);
command.Connection = this.getConnection();
EnvironmentalQuestion question = null;
OracleDataReader reader = command.ExecuteReader();
if (reader.Read())
{
question = new EnvironmentalQuestion();
question.Text = reader["text"].ToString();
question.Score = int.Parse(reader["score"].ToString());
//TODO a valaszok listava alakitasa kell meg
question.Answers = new List <EnvironmentalAnswer>();
}
return(question);
}
public void EnvironmentalQuestionsAll()
{
EnvironmentalQuestion expected = new EnvironmentalQuestion();
expected.Text = "test";
expected.Score = 2;
expected.Answers = new List <EnvironmentalAnswer>()
{
new EnvironmentalAnswer("valasz1", false),
new EnvironmentalAnswer("valasz2", false),
new EnvironmentalAnswer("valasz3", true),
new EnvironmentalAnswer("valasz4", false)
};
EnvironmentalQuestionsManager manager = new EnvironmentalQuestionsManager();
EnvironmentalQuestion actual = manager.Select(2);
Assert.AreEqual(expected, actual);
}
public List <EnvironmentalQuestion> SelectAll()
{
List <EnvironmentalQuestion> list = new List <EnvironmentalQuestion>();
OracleCommand command = new OracleCommand();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "SELECT * FROM ENVIRONMENTALQUESTIONS q INNER JOIN MATHANSWERS a ON (q.id=a.question_id)";
command.Connection = this.getConnection();
using (OracleDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
EnvironmentalQuestion record = new EnvironmentalQuestion();
record.Text = reader["question"].ToString();
record.Score = (int)reader["pont"];
record.Answers.Add(new EnvironmentalAnswer(reader["answer"].ToString(), (bool)reader["is_correct"]));
list.Add(record);
}
}
return(list);
}
public bool Insert(EnvironmentalQuestion question)
{
OracleCommand command = new OracleCommand();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "INSERT INTO ENVIRONMENTALQUESTIONS(question, pont) VALUES(:text, :score);";
OracleParameter text = new OracleParameter();
text.ParameterName = ":text";
text.DbType = System.Data.DbType.String;
text.Value = question.Text;
command.Parameters.Add(text);
OracleParameter score = new OracleParameter();
score.ParameterName = ":score";
score.DbType = System.Data.DbType.String;
score.Value = question.Score;
command.Parameters.Add(score);
command.Connection = getConnection();
return(command.ExecuteNonQuery() == -1);
}
