public void LanguageDAOConstructorTest()
{
/*Context*/
LanguageDAO lang_context = new LanguageDAO();
AccountDAO acc_context = new AccountDAO();
/*Insert*/
AccountDTO acc = new AccountDTO();
acc.userName = "******";
acc.password = "******";
acc.accountType = "administrator";
acc.status = "active";
acc_context.presist(acc);
LanguageDTO lang = new LanguageDTO();
lang.userName = "******";
lang.languageName = "english";
lang.speak = "Yes";
lang.write = "Yes";
lang.reads = "Yes";
lang_context.presist(lang);
Assert.AreEqual(lang.speak, lang_context.find("john", "english").speak);
/*Update*/
lang.speak = "No";
lang_context.merge(lang);
Assert.AreEqual("No", lang_context.find("john", "english").speak);
/*Delete*/
lang_context.removeByUserId("john", "english");
Assert.AreEqual(lang_context.isFound("john", "english"), false);
acc_context.removeByUserId("john");
}
public void LanguageDAO_Test()
{
LanguageDAO lang_context = new LanguageDAO();
AccountDAO acc_context = new AccountDAO();
/*Insert*/
AccountDTO acc = new AccountDTO();
acc.userName = "******";
acc.password = "******";
acc.accountType = "administrator";
acc.status = "active";
acc_context.presist(acc);
LanguageDTO lang = new LanguageDTO();
lang.userName = "******";
lang.languageName = "english";
lang.speak = "no";
lang.write = "Yes";
lang.reads = "Yes";
lang_context.presist(lang);
Assert.AreEqual("no", lang_context.find("griddy", "english").speak);
/*Update*/
/*lang.speak = "X";
lang_context.merge(lang);
string str = lang_context.find("griddy", "english").speak;
//Assert.AreEqual("X", str);
/*Delete*/
lang_context.removeByUserId("griddy", "english");
Assert.AreEqual(false, lang_context.isFound("griddy", "english"));
acc_context.removeByUserId("griddy");
}
public bool isUniqueLanguage(String username, String language)
{
bool isUnique = false;
LanguageDAO dao = new LanguageDAO();
try
{
return (!dao.isFound(username, language));
}
catch (InvalidOperationException ioe)
{
isUnique = true;
}
return isUnique;
}
