public Dictionary<bool, int> GetLikes(Guid postId, Guid accountId)
{
var queryString =
"SELECT [dbo].posts.rating, [dbo].Likes.likeid " +
"FROM [dbo].posts, [dbo].Likes " +
"WHERE ([dbo].posts.postid = @postid) AND " +
"([dbo].Likes.accountid = @accountid) AND ([dbo].Likes.postid = @postid);";
using (SqlConnection connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand(queryString, connection);
command.Parameters.AddWithValue("accountid", accountId);
command.Parameters.AddWithValue("postid", postId);
connection.Open();
var reader = command.ExecuteReader();
Dictionary<bool, int> toReturn;
Guid guid = Guid.Empty;
int rating = 0;
while (reader.Read())
{
rating = (int)reader[0];
guid = (Guid)reader[1];
}
if ((guid != Guid.Empty) && (rating >= 0))
{
toReturn = new Dictionary<bool, int>();
toReturn.Add(true, rating);
return toReturn;
}
else
{
toReturn = new Dictionary<bool, int>();
toReturn.Add(false, rating);
return toReturn;
}
}
}