public void SetUp() { examManager = new ExamManager(); userAdapter = new UserTableAdapter(); examAdapter = new examTableAdapter(); UEAdapter = new user_examTableAdapter(); userId = Convert.ToInt32(userAdapter.InsertUser("test", "123", "ceshiyuan", "male", "158", "*****@*****.**", null)); examId = Convert.ToInt32(examAdapter.InsertExam("computer", "easy", 4, 20, 60, 80, DateTime.Parse("2015-10-01"), DateTime.Parse("2015-09-01"), DateTime.Parse("2015-09-01"), 0, "Mario", 60, 0, 0)); ueId = Convert.ToInt32(UEAdapter.InsertUserExamResult(userId, examId, -1, "Do it")); }
public void InsertExamResultById(int userId, int examId, double score, string isPassed) { try { user_examTableAdapter adapter = new user_examTableAdapter(); adapter.InsertExamResultByUserIdAndExamId(score, isPassed, userId, examId); } catch (Exception e) { Log4NetHelper.WriteErrorLog(typeof(ExamManager), e); } }
public void TestInsertExamResultById() { examManager.InsertExamResultById(userId, examId, 100, "Pass"); user_examTableAdapter adapter = new user_examTableAdapter(); var table = adapter.QueryExamResult(ueId); foreach (var item in table) { Assert.AreEqual("Pass", item.is_pass); Assert.AreEqual(100, item.score); } }
public void InsertExanResultById(int userId, int examId, double score, string isPassed) { user_examTableAdapter adapter = new user_examTableAdapter(); adapter.InsertExamResultByUserIdAndExamId(score, isPassed, userId, examId); }