public List<Question> findQuestion(string usernameF,Subject subject, Department department)
{
logger.Debug("findQuestion()");
List<Question> questionList = new List<Question>();
string query = "";
if(usernameF != "all")
query = "select Q.id as question_id,Q.question,Q.create_date,A.id as user_id,Q.level_range,A.username from question Q " +
"inner join account A on A.id = Q.account_id " +
"inner join subject_department SD on Q.subject_department_id = SD.id where SD.subject_id = " + subject.Id + " and SD.department_id = " + department.Id + " and A.username = '******'; ";
else
query = "select Q.id as question_id,Q.question,Q.create_date,A.id as user_id,Q.level_range,A.username from question Q " +
"inner join account A on A.id = Q.account_id " +
"inner join subject_department SD on Q.subject_department_id = SD.id where SD.subject_id = " + subject.Id + " and SD.department_id = " + department.Id + " ; ";
MysqlConnector mysql = new MysqlConnector(CurrentUserInfo.USERNAME,
CurrentUserInfo.PASSWORD,
CurrentUserInfo.HOSTNAME,
CurrentUserInfo.PORT,
CurrentUserInfo.DATABASE);
mysql.initializeConnection();
mysql.openMysqlConnection();
//Question Fields
int question_id;
string question_descr;
int level_question;
DateTime date_question;
//Account Fields
int account_id;
string username;
//Questions
using (MySqlCommand cmd = new MySqlCommand(query, mysql.MysqlConnection))
{
using (MySqlDataReader reader = cmd.ExecuteReader())
{
if (reader != null)
{
while (reader.Read())
{
question_id = reader.GetInt32(0);
question_descr = reader.GetString(1);
date_question = reader.GetDateTime(2).Date;
Debug.Write("NOWWWWWWWWWW");
Debug.Write(date_question.ToString("MM/dd/yyyy"));
account_id = reader.GetInt32(3);
level_question = reader.GetInt32(4);
username = reader.GetString(5);
questionList.Add(new Question() { Id = question_id, Question_descr = question_descr, Account = new Account() { Username = username }, Subject = subject, Department = department, Level = level_question, Date = date_question });
}
}
} // reader closed and disposed up here
} // command disposed here
mysql.closeMysqlConnection();
//Answer of Above Questions
if (questionList.Any())
{
mysql.openMysqlConnection();
setAnsersForIndividualQuestion(questionList, mysql);
mysql.closeMysqlConnection();
}
//Debug
foreach (Question question in questionList)
{
Debug.WriteLine(question.Question_descr);
foreach (Answer answer in question.AnswerList)
Debug.WriteLine(answer.Answer_descr);
}
return questionList;
}
private List<Question> loadQuestionData(string username, Subject subject, Department department)
{
List<Question> questionList;
IQuestionDao questionDao = new QuestionDaoImpl();
questionList = questionDao.findQuestion(username, subject, department);
return questionList;
}
public List<Question> findQuestion(Account account, Subject subject, Department department)
{
throw new NotImplementedException();
}