public ActionResult Details(int id)
{
WordMain word = Kit.Instance.Words.GetWordById(id);
List <WordInflection> inflectedWords = Kit.Instance.WordInflections.GetAllInflectedWorsdByLexemId(id);
ViewData["inflectedWords"] = inflectedWords;
return(View(word));
}
public WordMain GetWordOfTheDay(DateTime date)
{
WordMain word = null;
_dbRead.Execute(
"WordOfTheDayGet",
new[]
{
new SqlParameter("@created", date)
},
r => word = new WordMain()
{
FormNoAcc = Read <string>(r, "FormNoAcc"),
lexemId = Read <int>(r, "lexemId")
});
return(word);
}
public WordMain GetWordById(int id)
{
WordMain word = null;
_dbRead.Execute(
"WordsMainGetById",
new[] {
new SqlParameter("@lexemId", id)
},
r => word = new WordMain()
{
id = Read <int>(r, "id"),
FormNoAcc = Read <string>(r, "FormNoAcc"),
Frequency = Read <double>(r, "Frequency"),
ModelNr = Read <string>(r, "ModelNr"),
ModelType = Read <string>(r, "ModelType"),
Pronunciation = Read <string>(r, "Pronunciation"),
lexemId = Read <int>(r, "lexemId"),
description = Read <string>(r, "ModelDescription")
});
return(word);
}
public WordMain GetRandomMainWord(double frequency, int wordLength)
{
WordMain word = null;
_dbRead.Execute(
"WordMainGetRandomLexem",
new[]
{
new SqlParameter("@frequency", (float)frequency),
new SqlParameter("@wordLength", wordLength)
},
r => word = new WordMain()
{
id = Read <int>(r, "id"),
FormNoAcc = Read <string>(r, "FormNoAcc"),
Frequency = Read <double>(r, "Frequency"),
ModelNr = Read <string>(r, "ModelNr"),
ModelType = Read <string>(r, "ModelType"),
Pronunciation = Read <string>(r, "Pronunciation"),
lexemId = Read <int>(r, "lexemId")
});
return(word);
}
