public Comment GetCommentByUser(int gameId, string userId)
{
Comment comment = new Comment();
using (_connection)
{
_connection.Open();
string selectString = "SELECT * FROM COMMENT WHERE GameId = @GameId AND UserId = @UserId";
command.CommandText = selectString;
command.Parameters.Add("@GameId", gameId);
command.Parameters.Add("@UserId", userId);
SqlDataReader reader = command.ExecuteReader();
if (!reader.HasRows) return null;
while (reader.Read())
{
comment.CommentText = reader["CommentText"].ToString();
}
reader.Close();
_connection.Close();
}
return comment;
}
public List<Comment> GetAllCommentsForGame(int gameId)
{
List<Comment> commentList = new List<Comment>();
using (_connection)
{
_connection.Open();
string selectString = "SELECT * FROM COMMENT where GameId = @GameId";
command.CommandText = selectString;
command.Parameters.Add("@GameId",gameId);
SqlDataReader reader = command.ExecuteReader();
if (!reader.HasRows) return null;
while (reader.Read())
{
Comment comment = new Comment();
comment.UserId = reader["UserId"].ToString();
comment.CommentText = reader["CommentText"].ToString();
commentList.Add(comment);
}
reader.Close();
_connection.Close();
}
return commentList;
}
public void DeleteComment(Comment comment)
{
using (_connection)
{
_connection.Open();
string deleteString = @"DELETE FROM COMMENT WHERE GameId = @GameId AND UserId = @UserId";
command.CommandText = deleteString;
command.Parameters.Add("@GameId", comment.GameId);
command.Parameters.Add("@UserId", comment.UserId);
command.ExecuteNonQuery();
_connection.Close();
}
}
public void InsertComment(Comment comment)
{
using (_connection)
{
_connection.Open();
string insertString = @"INSERT INTO COMMENT(UserId,GameId,CommentText) VALUES(@UserId,@GameId,@CommentText)";
command.CommandText = insertString;
command.Parameters.Add("@UserId", comment.UserId);
command.Parameters.Add("@GameId", comment.GameId);
command.Parameters.Add("@CommentText", comment.CommentText);
command.ExecuteNonQuery();
_connection.Close();
}
}
public void UpdateComment(Comment comment)
{
using (_connection)
{
_connection.Open();
string insertString = @"UPDATE COMMENT SET
CommentText = @CommentText
WHERE GameId = @GameId AND UserId = @UserId";
command.CommandText = insertString;
command.Parameters.Add("@GameId", comment.GameId);
command.Parameters.Add("@CommentText", comment.CommentText);
command.Parameters.Add("@UserId", comment.UserId);
command.ExecuteNonQuery();
_connection.Close();
}
}