public ViewFeedbackAdmin() { this.InitializeComponent(); CustomerReview cr = new CustomerReview(); ReviewList.ItemsSource = cr.GetReviews((App.Current as App).ConnectionString); }
public ObservableCollection <CustomerReview> GetReviews(string connectionString) { const string GetReviewsQuery = "select * from Reviews"; var reviews = new ObservableCollection <CustomerReview>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); if (conn.State == System.Data.ConnectionState.Open) { using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = GetReviewsQuery; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var review = new CustomerReview(); review.ReviewID = reader.GetInt32(0); review.FirstName = reader.GetString(1); review.LastName = reader.GetString(2); review.Email = reader.GetString(3); review.Review = reader.GetString(4); reviews.Add(review); } } } } } return(reviews); }catch (Exception ex) { Debug.WriteLine(ex.Message); } return(null); }