public void updateMessage ( Message message) { string sql = "UPDATE `SmsApplicatie`.`messages` " + "SET numberReceiver=:numberReceiver, message=:message, sendAt=:sendAt, contactId=:contactId" + "where id=:id"; MySqlCommand statement = this.databaseConnection.CreateCommand (); statement.CommandText = sql; statement.Prepare (); statement.Parameters.AddWithValue ( "numberReceiver", message.getNumberReceiver() ); statement.Parameters.AddWithValue ( "message", message.getMessageBody() ); statement.Parameters.AddWithValue ( "sendAt", message.getSendAt() ); statement.Parameters.AddWithValue ( "contactId", message.getContactId() ); statement.Parameters.AddWithValue ( "id", message.getId() ); }
public void deleteMessage ( Message message) { string sql = "DELETE FROM `SmsApplicatie`.`messages` WHERE id=:id"; MySqlCommand statement = this.databaseConnection.CreateCommand (); statement.CommandText = sql; statement.Prepare (); statement.Parameters.AddWithValue ( "id", message.getId() ); if ( statement.ExecuteNonQuery () > 0 ) { throw new ApplicationException ("Can not delete message with id: " + message.getId()); } }