public NumberTranslation Add(NumberTranslation numberTranslation)
{
var sql = $"INSERT INTO `number_translations` (`from_number`,`to_number`,`description`) VALUES ('{numberTranslation.FromNumber}','{numberTranslation.ToNumber}','{numberTranslation.Description}')";
new SQLiteCommand(sql, _connection).ExecuteNonQuery();
var id = (long)new SQLiteCommand("SELECT last_insert_rowid()", _connection).ExecuteScalar();
numberTranslation.Id = id;
return(numberTranslation);
}
public void Update(NumberTranslation numberTranslation)
{
var sql = $"UPDATE `number_translations` SET `from_number`={numberTranslation.FromNumber}, `to_number`='{numberTranslation.ToNumber}',`description`='{numberTranslation.Description}' WHERE `id`='{numberTranslation.Id}'";
new SQLiteCommand(sql, _connection).ExecuteNonQuery();
}
public void Delete(NumberTranslation numberTranslation)
{
var sql = $"DELETE FROM `number_translations` WHERE `id` = {numberTranslation.Id}";
new SQLiteCommand(sql, _connection).ExecuteNonQuery();
}
