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(); }