public static void GetPCMD() { SqlConnection conn = GetConnection(); string selStrng = "SELECT * FROM PostCommentRelation "; SqlCommand selCmd = new SqlCommand(selStrng, conn); try { conn.Open(); SqlDataReader reader = selCmd.ExecuteReader(); while (reader.Read()) { if (reader["IsDeleted"].ToString() == "False") { PostCommentRelation pcr = new PostCommentRelation(Comment.Items[new Guid(reader["CommentId"].ToString())]); //pcr.Post = Post.Items[new Guid(reader["PostId"].ToString())]; //pcr.Comment = Comment.Items[new Guid(reader["CommentId"].ToString())]; string isDel = reader["IsDeleted"].ToString(); if (isDel == "True") pcr.IsDeleted = true; else pcr.IsDeleted = false; PostCommentRelation.Items.Add(pcr.Id, pcr); } } reader.Close(); } catch (SqlException ex) { throw ex; } finally { conn.Close(); } }
public static void SaveToDB(PostCommentRelation pcr) { string insString = "INSERT INTO PostCommentRelation (PostId, CommentID) VALUES (@postid, @commentid)"; SqlConnection conn = GetConnection(); SqlCommand insCmd = new SqlCommand(insString, conn); insCmd.Parameters.AddWithValue("@postid", pcr.Post.Id.ToString()); insCmd.Parameters.AddWithValue("@commentid", pcr.Comment.Id.ToString()); try { conn.Open(); insCmd.ExecuteNonQuery(); } catch (SqlException ex) { throw ex; } finally { conn.Close(); } }
public static void AddCommentToDB(Comment cmnt) { string insString = "INSERT INTO Comment (ID, Title, Body, DateAdded, PostId) VALUES (@id, @title, @body, @added, @postId)"; SqlConnection conn = GetConnection(); SqlCommand insCmd = new SqlCommand(insString, conn); insCmd.Parameters.AddWithValue("@id", cmnt.Id.ToString()); insCmd.Parameters.AddWithValue("@title", cmnt.Title); insCmd.Parameters.AddWithValue("@body", cmnt.Body); var date = cmnt.CommentedDate.ToString("yyyy-MM-dd HH:mm:ss"); insCmd.Parameters.AddWithValue("@added", date); insCmd.Parameters.AddWithValue("@postId", cmnt.getPost().Id); try { conn.Open(); insCmd.ExecuteNonQuery(); } catch (SqlException ex) { throw ex; } finally { conn.Close(); } PostCommentRelation PCR = new PostCommentRelation(cmnt); PstCmntRelationManager.SaveToDB(PCR); }