public override void UpdateExample(TransliterationExample example, string word)
{
Refresh();
SqlCommand cmd = new SqlCommand(
string.Format("UPDATE TransExamples SET Word=N'{0}', Transliteration=N'{1}', Disabled='{2}' " +
"WHERE LangId1='{3}' AND LangId2='{4}' AND Word=N'{5}'",
Normalize(example.Source), Normalize(example.Destination), example.Disabled,
this.srcLanguage.Code, this.dstLanguage.Code, Normalize(word)),
connection);
if (cmd.ExecuteNonQuery() != 1)
{
throw new Exception("SQL UPDATE did not affect 1 row");
}
}
public override void CreateExample(TransliterationExample example)
{
Refresh();
SqlCommand cmd = new SqlCommand(
"INSERT INTO TransExamples (LangId1, LangId2, Word, Transliteration, Disabled) " +
string.Format("VALUES ('{0}', '{1}', N'{2}', N'{3}', '{4}')",
this.srcLanguage.Code, this.dstLanguage.Code,
Normalize(example.Source),
Normalize(example.Destination ?? string.Empty),
example.Disabled),
connection);
if (cmd.ExecuteNonQuery() != 1)
{
throw new Exception("SQL INSERT did not affect 1 column");
}
}
public override List <TransliterationExample> ListExamples(bool enabledOnly = false)
{
Refresh();
SqlCommand cmd = new SqlCommand("SELECT * FROM TransExamples WHERE LangId1='"
+ srcLanguage.Code + "' AND LangId2='" + dstLanguage.Code + "'" +
(enabledOnly ? " AND Disabled='FALSE'" : string.Empty),
connection);
SqlDataReader reader = cmd.ExecuteReader();
List <TransliterationExample> list = new List <TransliterationExample>();
while (reader.Read())
{
TransliterationExample rule = new TransliterationExample()
{
Source = reader.GetString(2),
Destination = reader.GetString(3),
Disabled = reader.GetBoolean(4)
};
list.Add(rule);
}
reader.Close();
return(list);
}
public override void UpdateExample(TransliterationExample example, string word)
{
throw new NotImplementedException();
}
public override void CreateExample(TransliterationExample example)
{
throw new NotImplementedException();
}
public abstract void UpdateExample(TransliterationExample example, string word);
public abstract void CreateExample(TransliterationExample example);