public List<Question> GetQuestionByCatalogue(Catalogue Catalogue)
{
List<Question> QuestionList = new List<Question>();
string query = "SELECT q.Question_ID, q.Question_Title, q.Question_Name, q.Question_Type, c.Catalogue_Name"
+ " FROM Question q "
+ " INNER JOIN Catalogue c ON c.Catalogue_ID = q.Catalogue_ID"
+ " WHERE q.Catalogue_ID='"+Catalogue.IDCatalogue+"'";
DataTable dt = DA.SelectDatabase(query);
int i=1;
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
Question Question = new Question();
Question.IDQuestion = Convert.ToInt32(item["Question_ID"]);
Question.QuestionTitle = item["Question_Title"].ToString();
Question.NameQuestion = item["Question_Name"].ToString();
Question.TypeQuestion = item["Question_Type"].ToString();
Question.NameCatalogue = item["Catalogue_Name"].ToString();
Question.Sequence = i;
QuestionList.Add(Question);
i++;
}
}
return QuestionList;
}