public Common.DTO.DicEntity getByWord(String Word)
{
Common.DTO.DicEntity dicEntity = DataAccess.Dictionery.instance.getByWord(Word);
if (dicEntity == null & Word.EndsWith("s"))
{
dicEntity = DataAccess.Dictionery.instance.getByWord(Word.Substring(0, Word.Length - 1));
}
if (dicEntity == null & Word.EndsWith("ed"))
{
dicEntity = DataAccess.Dictionery.instance.getByWord(Word.Substring(0, Word.Length - 1));
if (dicEntity == null)
{
dicEntity = DataAccess.Dictionery.instance.getByWord(Word.Substring(0, Word.Length - 2));
}
}
if (dicEntity == null & Word.EndsWith("ing"))
{
dicEntity = DataAccess.Dictionery.instance.getByWord(Word.Substring(0, Word.Length - 3));
}
if (dicEntity == null)
{
dicEntity = new Common.DTO.DicEntity()
{
Word = Word, Meaning = ""
}
}
;
return(dicEntity);
}
public void AddWord(Common.DTO.DicEntity dic)
{
SQLiteCommand Comm = new SQLiteCommand("INSERT INTO Dictionary(\"Word\",\"Meaning\") VALUES ('" + dic.Word + "','" + dic.Meaning + "');", Conn);
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
Comm.ExecuteNonQuery();
Conn.Close();
}
public void AddWord(Common.DTO.DicEntity dic)
{
try
{
if (!IsContainsWord(dic.Word))
{
dic.Word = dic.Word.Replace("'", "''");
dic.Meaning = dic.Meaning.Replace("'", "''");
DataAccess.Dictionery.instance.AddWord(dic);
}
}
catch (Exception ex)
{
// Tof
}
}
