public static List <CSMUserReview> GetReviews(Guid CSMItemId) { List <CSMUserReview> reviews = new List <CSMUserReview>(); string sql = " SELECT ReviewId, " + " MemberId, " + " CSMItemId, " + " Rating, " + " RatedGradeId, " + " GradeAppropriateness, " + " Created, " + " LastModified, " + " TelligentCommentId, " + " ReviewTitle " + " FROM CSMUserReviews " + " WHERE (CSMItemId = @CSMId)"; try { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["membership"].ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@CSMId", CSMItemId); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { CSMUserReview review = new CSMUserReview(); review.ReviewId = reader.GetGuid(0); review.MemberId = reader.GetGuid(1); review.CSMItemId = reader.GetGuid(2); review.Rating = reader.GetInt32(3); review.RatedGradeId = reader.GetGuid(4); review.GradeAppropriateness = reader.GetInt32(5); review.Created = reader.GetDateTime(6); review.LastModified = reader.GetDateTime(7); review.TelligentCommentId = reader.GetGuid(8); review.ReviewTitle = reader.GetString(9); review.UserReviewIssues = GetSkills(review.ReviewId); reviews.Add(review); } } } } } catch (Exception ex) { throw ex; } return(reviews); }
public static List<CSMUserReview> GetReviews(Guid CSMItemId) { List<CSMUserReview> reviews = new List<CSMUserReview>(); string sql = " SELECT ReviewId, " + " MemberId, " + " CSMItemId, " + " Rating, " + " RatedGradeId, " + " GradeAppropriateness, " + " Created, " + " LastModified, " + " TelligentCommentId, " + " ReviewTitle " + " FROM CSMUserReviews " + " WHERE (CSMItemId = @CSMId)"; try { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["membership"].ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@CSMId", CSMItemId); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { CSMUserReview review = new CSMUserReview(); review.ReviewId = reader.GetGuid(0); review.MemberId = reader.GetGuid(1); review.CSMItemId = reader.GetGuid(2); review.Rating = reader.GetInt32(3); review.RatedGradeId = reader.GetGuid(4); review.GradeAppropriateness = reader.GetInt32(5); review.Created = reader.GetDateTime(6); review.LastModified = reader.GetDateTime(7); review.TelligentCommentId = reader.GetGuid(8); review.ReviewTitle = reader.GetString(9); review.UserReviewIssues = GetSkills(review.ReviewId); reviews.Add(review); } } } } } catch (Exception ex) { throw ex; } return reviews; }
public static bool InsertNewReview(CSMUserReview review) { bool success = false; review.ReviewId = Guid.NewGuid(); string commentId = CommunityHelper.PostComment(review.BlogId, review.BlogPostId, review.ReviewBody, review.UserScreenName); string sql = "INSERT INTO [CSMUserReviews] " + "([ReviewId] " + ",[MemberId] " + ",[CSMItemId] " + ",[Rating] " + ",[RatedGradeId] " + ",[GradeAppropriateness] " + ",[Created] " + ",[LastModified] " + ",[TelligentCommentId] " + ",[ReviewTitle] " + ",[IThinkItIs]) " + "VALUES " + "(@ReviewId, " + "@MemberId, " + "@CSMId, " + "@ReviewRating, " + "@GradeId, " + "@GradeNumber, " + "CURRENT_TIMESTAMP, " + "CURRENT_TIMESTAMP, " + "@CommentId, " + "@ReviewTitle, " + "@IThinkItIs) "; try { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["membership"].ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@CSMId", review.CSMItemId); cmd.Parameters.AddWithValue("@MemberId", review.MemberId); cmd.Parameters.AddWithValue("@GradeId", review.RatedGradeId); cmd.Parameters.AddWithValue("@ReviewRating", review.Rating); cmd.Parameters.AddWithValue("@CommentId", commentId); cmd.Parameters.AddWithValue("@ReviewId", review.ReviewId); cmd.Parameters.AddWithValue("@ReviewTitle", review.ReviewTitle); cmd.Parameters.AddWithValue("@IThinkItIs", review.IThinkItIs); cmd.Parameters.AddWithValue("@GradeNumber", review.GradeAppropriateness); cmd.ExecuteNonQuery(); success = true; } if (success) { InsertAllIssues(review.UserReviewIssues, review.ReviewId); } } } catch (Exception ex) { throw ex; } success = true; return success; }
public static bool InsertNewReview(CSMUserReview review) { bool success = false; review.ReviewId = Guid.NewGuid(); string commentId = CommunityHelper.PostComment(review.BlogId, review.BlogPostId, review.ReviewBody, review.UserScreenName); string sql = "INSERT INTO [CSMUserReviews] " + "([ReviewId] " + ",[MemberId] " + ",[CSMItemId] " + ",[Rating] " + ",[RatedGradeId] " + ",[GradeAppropriateness] " + ",[Created] " + ",[LastModified] " + ",[TelligentCommentId] " + ",[ReviewTitle] " + ",[IThinkItIs]) " + "VALUES " + "(@ReviewId, " + "@MemberId, " + "@CSMId, " + "@ReviewRating, " + "@GradeId, " + "@GradeNumber, " + "CURRENT_TIMESTAMP, " + "CURRENT_TIMESTAMP, " + "@CommentId, " + "@ReviewTitle, " + "@IThinkItIs) "; try { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["membership"].ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@CSMId", review.CSMItemId); cmd.Parameters.AddWithValue("@MemberId", review.MemberId); cmd.Parameters.AddWithValue("@GradeId", review.RatedGradeId); cmd.Parameters.AddWithValue("@ReviewRating", review.Rating); cmd.Parameters.AddWithValue("@CommentId", commentId); cmd.Parameters.AddWithValue("@ReviewId", review.ReviewId); cmd.Parameters.AddWithValue("@ReviewTitle", review.ReviewTitle); cmd.Parameters.AddWithValue("@IThinkItIs", review.IThinkItIs); cmd.Parameters.AddWithValue("@GradeNumber", review.GradeAppropriateness); cmd.ExecuteNonQuery(); success = true; } if (success) { InsertAllIssues(review.UserReviewIssues, review.ReviewId); } } } catch (Exception ex) { throw ex; } success = true; return(success); }