public static FeedBackCollection GetFeedBackPublicCollectionOfArticle(Guid articleId) { FeedBackCollection result = new FeedBackCollection(); using (SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PSCPortalConnectionString"].ConnectionString)) { SqlCommand command = new SqlCommand(); command.Connection = connection; connection.Open(); command.Parameters.AddWithValue("@ArticleId", articleId); command.CommandText = @" SELECT * from ArticleFeedBack where IsPublish=1 and ArticleId=@ArticleId "; using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { result.Add(new FeedBack(reader)); } } } return(result); }
public static FeedBackCollection GetFeedBackUnPublicCollection() { FeedBackCollection result = new FeedBackCollection(); using (SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PSCPortalConnectionString"].ConnectionString)) { SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = @" SELECT * from ArticleFeedBack where IsPublish=0" ; connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { result.Add(new FeedBack(reader)); } } } return(result); }