public KanjiMessage GetKanjiForId(KanjiForIdRequest request)
{
var result = new KanjiMessage();
using (IDatabaseClient client = OpenDatabaseClient()) {
client.SelectCommand = String.Format(SQL_KANJI_ID_SELECT, request.Id.ToString());
DataTable data = client.Read();
if (data.Rows.Count > 0) {
var row = data.Rows[0];
result.Id = Convert.ToInt32(row["Id"]);
result.Literal = row["Literal"].ToString();
result.OnYomi = row["OnYomi"].ToString();
result.KunYomi = row["KunYomi"].ToString();
result.Meaning = row["Meaning"].ToString();
result.Jlpt = (JLPT)Enum.Parse(typeof(JLPT), row["JLPT"].ToString());
result.StrokeCount = Convert.ToInt32(row["StrokeCount"]);
} else {
result.Id = 0;
result.Jlpt = JLPT.Undefined;
}
}
return result;
}
public KanjiForIdResponse Execute(KanjiForIdRequest request)
{
return new KanjiForIdResponse() { Kanji = DataGateway.Instance.GetKanjiForId(request) };
}