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