public int Insert(params object[] values)
{
IDbManager dbMgr = new SqliteDbManager();
return(dbMgr.Execute("INSERT INTO localization (key, text, language_id) VALUES (@key, @text, @lang_id);", new SqliteParameter("@key", values[0]),
new SqliteParameter("@text", values[1]), new SqliteParameter("@lang_id", values[2])));
}
public int Update(params object[] values)
{
IDbManager dbMgr = new SqliteDbManager();
return(dbMgr.Execute("UPDATE localization SET text = @text WHERE key = @key AND language_id = @lang_id;", new SqliteParameter("@text", values[0]), new SqliteParameter("@key", values[1]), new SqliteParameter("@lang_id", values[2])));
}
public int Delete(params object[] values)
{
IDbManager dbMgr = new SqliteDbManager();
return(dbMgr.Execute("DELETE FROM localization WHERE key = @key;", new SqliteParameter("@key", values[0])));
}
public int Update(Language value)
{
IDbManager dbMgr = new SqliteDbManager();
return(dbMgr.Execute("UPDATE languages SET name = @name WHERE language_id = @id;", new SqliteParameter("@id", value.ID), new SqliteParameter("@name", value.Name)));
}
public int Insert(Language value)
{
IDbManager dbMgr = new SqliteDbManager();
return(dbMgr.Execute("INSERT INTO languages (language_id, name) VALUES (@id, @name);", new SqliteParameter("@id", value.ID), new SqliteParameter("@name", value.Name)));
}
public int Delete(Language value)
{
IDbManager dbMgr = new SqliteDbManager();
return(dbMgr.Execute("DELETE FROM languages WHERE language_id = @id AND name = @name;", new SqliteParameter("@id", value.ID), new SqliteParameter("@name", value.Name)));
}
