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