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