private async Task <List <TeamsMessage> > GetAllReplies(string teamsId, string channelId, string messageId)
{
var authority = ServiceHelper.Authority;
var resource = ServiceHelper.GraphResource;
var authService = new AuthService(authority);
var authResult = await authService.AuthenticateSilently(resource);
var graphService = new GraphService();
var teamsMessages = await graphService.GetRepliesToMessage(authResult.AccessToken, teamsId, channelId, messageId);
return(teamsMessages.Where(x => x.From.Application == null && !string.IsNullOrEmpty(MicrosoftTeamsChannelHelper.StripMentionAndHtml(x.Body.Content))).ToList());
}
private async Task HandleMarkedAnswerFromCard(Microsoft.Bot.Connector.Activity activity)
{
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
// Handle answer payload
var adaptiveCardAnswerJson = activity.Value.ToString();
var adaptiveCardAnswer = JsonConvert.DeserializeObject <AdaptiveCardAnswerSubmit>(adaptiveCardAnswerJson);
string selectedReplyJson = adaptiveCardAnswer.Answer;
string questionId = adaptiveCardAnswer.QuestionId;
if (string.IsNullOrEmpty(selectedReplyJson))
{
Microsoft.Bot.Connector.Activity newReply = activity.CreateReply();
newReply.Text = "There seems to be an issue saving the answer.";
await connector.Conversations.ReplyToActivityAsync(activity.Conversation.Id, activity.ReplyToId, newReply);
}
else
{
var selectedReply = JsonConvert.DeserializeObject <TeamsMessage>(selectedReplyJson);
var question = SQLService.GetQuestion(Convert.ToInt32(questionId));
// get user details
var channelData = activity.GetChannelData <Microsoft.Bot.Connector.Teams.Models.TeamsChannelData>();
var members = await connector.Conversations.GetConversationMembersAsync(channelData.Team.Id);
var teamsMembers = members.AsTeamsChannelAccounts();
var currentUser = teamsMembers.Where(x => x.ObjectId == activity.From.Properties["aadObjectId"].ToString()).FirstOrDefault();
var studentUPN = currentUser.UserPrincipalName;
var isUserAdmin = SQLService.IsUserAdmin(studentUPN);
string teamId = channelData.Team.Id;
TeamDetails teamDetails;
try
{
teamDetails = connector.GetTeamsConnectorClient().Teams.FetchTeamDetails(teamId);
}
catch (Exception e)
{
teamDetails = connector.GetTeamsConnectorClient().Teams.FetchTeamDetails(teamId);
Trace.TraceError(e.ToString());
}
var teamName = teamDetails.Name;
var courseID = SQLService.GetCourseIDByName(teamName.Trim());
// check if user can set question status
if (isUserAdmin || (studentUPN == question.OriginalPoster.Email) || (studentUPN == question.OriginalPoster.UserName))
{
var selectedReplyUser = teamsMembers.Where(x => x.ObjectId == selectedReply.From.User.Id).FirstOrDefault();
var answeredBy = SQLService.GetUser(selectedReplyUser.UserPrincipalName);
// update question model
question.QuestionStatus = Constants.QUESTION_STATUS_ANSWERED;
question.QuestionAnswered = DateTime.Now;
question.AnswerText = MicrosoftTeamsChannelHelper.StripMentionAndHtml(selectedReply.Body.Content);
question.AnswerPoster = answeredBy;
SQLService.CreateOrUpdateQuestion(question);
// update old activity
Microsoft.Bot.Connector.Activity updatedReply = activity.CreateReply();
var card = new AdaptiveCard();
var answer = new AdaptiveTextBlock("Answer: " + question.AnswerText.ReplaceLinksWithMarkdown());
answer.Weight = AdaptiveTextWeight.Bolder;
answer.Size = AdaptiveTextSize.Medium;
answer.Wrap = true;
var marked = new AdaptiveTextBlock($"Marked as " + question.QuestionStatus + " by " + currentUser.Name);
marked.Wrap = true;
var answered = new AdaptiveTextBlock("Answered by: " + question.AnswerPoster.FullName);
answered.Weight = AdaptiveTextWeight.Bolder;
answered.Wrap = true;
card.Body.Add(answer);
card.Body.Add(answered);
card.Body.Add(marked);
Attachment attachment = new Attachment()
{
ContentType = AdaptiveCard.ContentType,
Content = card,
};
updatedReply.Attachments.Add(attachment);
await connector.Conversations.UpdateActivityAsync(activity.Conversation.Id, activity.ReplyToId, updatedReply);
var predictiveQnAService = new PredictiveQnAService(courseID);
var res = await predictiveQnAService.AddQnAPair(question.QuestionText, question.AnswerText);
}
}
}
private async Task <HttpResponseMessage> HandleSelectAnswerFromMessageAction(Microsoft.Bot.Connector.Activity activity)
{
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
TeamsMessage selectedReply = JsonConvert.DeserializeObject <TeamsMessage>(JsonConvert.SerializeObject((activity.Value as dynamic)["messagePayload"]));
if (selectedReply.From.User == null)
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
var question = SQLService.GetQuestionByMessageId(selectedReply.ReplyToId);
if (question == null)
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
// get user details
var channelData = activity.GetChannelData <Microsoft.Bot.Connector.Teams.Models.TeamsChannelData>();
var members = await connector.Conversations.GetConversationMembersAsync(channelData.Team.Id);
var teamsMembers = members.AsTeamsChannelAccounts();
var currentUser = teamsMembers.Where(x => x.ObjectId == activity.From.Properties["aadObjectId"].ToString()).FirstOrDefault();
var studentUPN = currentUser.UserPrincipalName;
var isUserAdmin = SQLService.IsUserAdmin(studentUPN);
// check if user can set question status
if (isUserAdmin || (studentUPN == question.OriginalPoster.Email) || (studentUPN == question.OriginalPoster.UserName))
{
var selectedReplyUser = teamsMembers.Where(x => x.ObjectId == selectedReply.From.User.Id).FirstOrDefault();
var answeredBy = SQLService.GetUser(selectedReplyUser.UserPrincipalName);
// update question model
question.QuestionStatus = Constants.QUESTION_STATUS_ANSWERED;
question.QuestionAnswered = DateTime.Now;
question.AnswerText = MicrosoftTeamsChannelHelper.StripMentionAndHtml(selectedReply.Body.Content);
question.AnswerPoster = answeredBy;
SQLService.CreateOrUpdateQuestion(question);
Microsoft.Bot.Connector.Activity updatedReply = activity.CreateReply();
var card = new AdaptiveCard();
var answerBlock = new AdaptiveTextBlock("Answer: " + question.AnswerText.ReplaceLinksWithMarkdown());
answerBlock.Weight = AdaptiveTextWeight.Bolder;
answerBlock.Size = AdaptiveTextSize.Medium;
answerBlock.Wrap = true;
var markedBlock = new AdaptiveTextBlock($"Marked as " + question.QuestionStatus + " by " + currentUser.Name);
markedBlock.Wrap = true;
var answeredBlock = new AdaptiveTextBlock("Answered by: " + question.AnswerPoster.FullName);
answeredBlock.Weight = AdaptiveTextWeight.Bolder;
answeredBlock.Wrap = true;
card.Body.Add(answerBlock);
card.Body.Add(answeredBlock);
card.Body.Add(markedBlock);
Attachment attachment = new Attachment()
{
ContentType = AdaptiveCard.ContentType,
Content = card,
};
updatedReply.Attachments.Add(attachment);
if (question.AnswerCardActivityId == null)
{
var r = await connector.Conversations.ReplyToActivityAsync(updatedReply.Conversation.Id, updatedReply.ReplyToId, updatedReply);
question.AnswerCardActivityId = r.Id;
SQLService.CreateOrUpdateQuestion(question);
}
else
{
updatedReply.ReplyToId = question.AnswerCardActivityId;
var r = await connector.Conversations.UpdateActivityAsync(updatedReply.Conversation.Id, updatedReply.ReplyToId, updatedReply);
question.AnswerCardActivityId = r.Id;
SQLService.CreateOrUpdateQuestion(question);
}
}
var baseUrl = ServiceHelper.BaseUrl;
var taskInfo = new Models.TaskInfo();
taskInfo.Title = "Select Answer";
taskInfo.Height = 300;
taskInfo.Width = 400;
taskInfo.Url = baseUrl + @"/home/selectanswer?json=" + "Answer Updated";
Models.TaskEnvelope taskEnvelope = new Models.TaskEnvelope
{
Task = new Models.Task()
{
Type = Models.TaskType.Continue,
TaskInfo = taskInfo,
},
};
return(Request.CreateResponse(HttpStatusCode.OK, taskEnvelope));
}
private async Task HandleSelectAnswerFromCard(Microsoft.Bot.Connector.Activity activity)
{
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
// get question details
int questionId = Convert.ToInt32((activity.Value as dynamic)["questionId"]);
var question = SQLService.GetQuestion(questionId);
// get user details
var channelData = activity.GetChannelData <Microsoft.Bot.Connector.Teams.Models.TeamsChannelData>();
var members = await connector.Conversations.GetConversationMembersAsync(channelData.Team.Id);
var teamsMembers = members.AsTeamsChannelAccounts();
var currentUser = teamsMembers.Where(x => x.ObjectId == activity.From.Properties["aadObjectId"].ToString()).FirstOrDefault();
var studentUPN = currentUser.UserPrincipalName;
// var isUserAdmin = SharePointServices.IsUserAdmin(studentUPN);
var isUserAdmin = SQLService.IsUserAdmin(studentUPN);
// check if user can set question status
if (isUserAdmin || (studentUPN == question.OriginalPoster.Email) || (studentUPN == question.OriginalPoster.UserName))
{
// find replies
string teamId = (activity.ChannelData as dynamic)["team"]["id"].ToString();
string channelId = (activity.ChannelData as dynamic)["channel"]["id"].ToString();
var conversationId = activity.Conversation.Id;
string messageId = conversationId.Split('=')[1];
// update old activity
Microsoft.Bot.Connector.Activity updatedReply = activity.CreateReply();
var replies = await GetAllReplies(question.GroupId, channelId, messageId);
var adaptiveCardChoices = new List <AdaptiveChoice>();
if (replies != null && replies.Count > 0)
{
foreach (var reply in replies)
{
adaptiveCardChoices.Add(new AdaptiveChoice()
{
Title = MicrosoftTeamsChannelHelper.StripMentionAndHtml(reply.Body.Content),
Value = JsonConvert.SerializeObject(reply),
});
}
var bodyTextBlock = new AdaptiveTextBlock()
{
Text = "Select an answer"
};
var bodyChoice = new AdaptiveChoiceSetInput()
{
Id = "Answer",
Style = AdaptiveChoiceInputStyle.Compact,
IsMultiSelect = false,
Choices = adaptiveCardChoices,
};
var adaptiveCardAnswerSubmit = new AdaptiveCardAnswerSubmit(Constants.ACTIVITY_MARKED_ANSWERED, bodyChoice.Value, questionId.ToString());
var adaptiveCardAnswerString = JsonConvert.SerializeObject(adaptiveCardAnswerSubmit);
var actionJson = "{\"type\":\"" + Constants.ACTIVITY_SELECT_ANSWER + "\",\"questionId\": \"" + questionId.ToString() + "\"}";
var adaptiveCard = new AdaptiveCard()
{
Actions = new List <AdaptiveAction>()
{
new AdaptiveSubmitAction()
{
Title = "Save",
DataJson = adaptiveCardAnswerString,
},
new AdaptiveSubmitAction()
{
Title = "Refresh",
DataJson = actionJson,
},
},
};
adaptiveCard.Body.Add(bodyTextBlock);
adaptiveCard.Body.Add(bodyChoice);
var attachment = new Attachment()
{
ContentType = AdaptiveCard.ContentType,
Content = adaptiveCard,
};
updatedReply.Attachments.Add(attachment);
try
{
// await connector.Conversations.UpdateActivityAsync(updatedReply);
updatedReply.Id = activity.ReplyToId;
var response = await connector.Conversations.UpdateActivityAsync(activity.Conversation.Id, activity.ReplyToId, updatedReply);
}
catch (Exception e)
{
Trace.TraceError(e.ToString());
}
}
}
}