Exemple #1
0
        private IEnumerable <IFeedback> ImportFeedback(int oldId)
        {
            string queryString = $"SELECT [ID],[FeedbackID],[TransactionsID] FROM [dbo].[TransactionsToFeedbacks] WHERE [TransactionsID] = {oldId}";

            var items = new List <IFeedback>();

            //Load from db
            using (var connection = new SqlConnection(SourceConnectionString))
            {
                connection.Open();

                using (var command = new SqlCommand(queryString, connection))
                {
                    using (var reader = command.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            var id = int.Parse(reader["FeedbackID"].ToString());

                            items.Add(FeedbackItems.FirstOrDefault(f => f.OldId == id));
                        }
                    }
                }
            }

            return(items);
        }
 public void Handle(DisplayFeedbackEvent message)
 {
     lock (FeedbackItems)
     {
         FeedbackItems.Add(message.Message);
     }
 }