public List <object[]> Read(params object[] values)
{
IDbManager dbMgr = new SqliteDbManager();
if (values.Length == 1)
{
return(dbMgr.Read("SELECT key, text FROM localization WHERE language_id = @lang_id;", new SqliteParameter("@lang_id", values[0])));
}
else if (values.Length == 1)
{
return(dbMgr.Read("SELECT text FROM localization WHERE key = @key AND language_id = @lang_id;", new SqliteParameter("@key", values[0]), new SqliteParameter("@lang_id", values[1])));
}
return(new List <object[]>());
}
public List <Language> ReadAll()
{
List <Language> languages = new List <Language>();
IDbManager dbMgr = new SqliteDbManager();
List <object[]> values = dbMgr.Read("SELECT * FROM languages;");
foreach (object[] row in values)
{
languages.Add(new Language(int.Parse(row[0].ToString()), row[1].ToString()));
}
return(languages);
}
public List <object[]> ReadAll()
{
IDbManager dbMgr = new SqliteDbManager();
return(dbMgr.Read("SELECT * FROM localization;"));
}
