public static void Main(string[] args)
{
exam_answer_detailTableAdapter adapter = new exam_answer_detailTableAdapter();
OesDAL.QuestionDS.exam_answer_detailDataTable tableAdapter = adapter.FindUserAnswer(2, 1);
var rs = from s in tableAdapter select new { s.user_answer };
foreach (var item in rs)
{
Console.WriteLine(item.user_answer);
}
}
public QuestionDS.exam_answer_detailDataTable FindUserAnswer(int userId, int examId)
{
try
{
exam_answer_detailTableAdapter adapter = new exam_answer_detailTableAdapter();
return(adapter.FindUserAnswer(userId, examId));
}
catch (Exception e)
{
Log4NetHelper.WriteErrorLog(typeof(QuestionManager), e);
}
return(null);
}
public int QueryHaveAnsweredQuestionNumber(int userId, int examId)
{
try
{
exam_answer_detailTableAdapter detailAdapter = new exam_answer_detailTableAdapter();
return(Convert.ToInt32(detailAdapter.QueryHaveAnsweredQuestionNumber(userId, examId)));
}
catch (Exception e)
{
Log4NetHelper.WriteErrorLog(typeof(QuestionManager), e);
}
return(0);
}
public void SetUp()
{
questionManager = new QuestionManager();
questionAdapter = new questionTableAdapter();
examAdapter = new examTableAdapter();
eqAdapter = new EQTableAdapter();
userAdapter = new UserTableAdapter();
answerAdapter = new exam_answer_detailTableAdapter();
questionId = Convert.ToInt32(questionAdapter.InsertQuestion("how do you do?", "a", "b", "c", "d", "a", DateTime.Now, DateTime.Now, 0));
examId = Convert.ToInt32(examAdapter.InsertExam("computer", "easy", 4, 20, 60, 80, DateTime.Parse("2015-09-01"), DateTime.Parse("2015-09-01"),
DateTime.Parse("2015-09-01"), 0, "Mario", 60, 0, 0));
eqId = Convert.ToInt32(eqAdapter.InsertEQ(examId, questionId, "how do you do?", "a", "b", "c", "d", "a", 0));
}
/// <summary>
/// Save user answer
/// </summary>
/// <param name="userId"></param>
/// <param name="examId"></param>
/// <param name="questionId"></param>
/// <param name="userAnswer"></param>
public int InsertUserAnswer(int userId, int examId, int questionId, string userAnswer)
{
int answerId = 0;
try
{
exam_answer_detailTableAdapter adapter = new exam_answer_detailTableAdapter();
answerId = Convert.ToInt32(adapter.InsertUserAnswer(userId, examId, questionId, userAnswer));
}
catch (Exception e)
{
Log4NetHelper.WriteErrorLog(typeof(QuestionManager), e);
}
return(answerId);
}
public void InsertUserAnswer(int userId, int examId, int questionId, string userAnswer)
{
exam_answer_detailTableAdapter adapter = new exam_answer_detailTableAdapter();
adapter.InsertUserAnswer(userId, examId, questionId, userAnswer);
}
public QuestionDS.exam_answer_detailDataTable FindUserAnswer(int userId, int examId)
{
exam_answer_detailTableAdapter adapter = new exam_answer_detailTableAdapter();
return(adapter.FindUserAnswer(userId, examId));
}
public int QueryHaveAnsweredQuestionNumber(int userId, int examId)
{
exam_answer_detailTableAdapter detailAdapter = new exam_answer_detailTableAdapter();
return(Convert.ToInt32(detailAdapter.QueryHaveAnsweredQuestionNumber(userId, examId)));
}
