/// <summary>
/// Save Reflection Recursion data in Table Storage.
/// </summary>
/// <param name="taskInfo">This parameter is a ViewModel.</param>
/// <returns>Null.</returns>
public async Task SaveRecurssionDataAsync(TaskInfo taskInfo)
{
_telemetry.TrackEvent("SaveRecurssionDataAsync");
try
{
RecurssionDataRepository recurssionDataRepository = new RecurssionDataRepository(_configuration, _telemetry);
RecurssionDataEntity recurssionEntity = new RecurssionDataEntity
{
RecurssionID = taskInfo.recurssionID,
PartitionKey = PartitionKeyNames.RecurssionDataTable.RecurssionDataPartition,
RowKey = taskInfo.recurrsionRowKey,
ReflectionRowKey = taskInfo.reflectionRowKey,
QuestionRowKey = taskInfo.questionRowKey,
ReflectionID = taskInfo.reflectionID,
RecursstionType = taskInfo.recurssionType,
CustomRecurssionTypeValue = taskInfo.customRecurssionTypeValue,
CreatedDate = DateTime.Now,
ExecutionDate = taskInfo.executionDate,
ExecutionTime = taskInfo.executionTime,
RecurssionEndDate = taskInfo.executionDate.AddDays(60),
NextExecutionDate = taskInfo.nextExecutionDate,
ScheduleId = taskInfo.scheduleId
};
await recurssionDataRepository.CreateOrUpdateAsync(recurssionEntity);
}
catch (Exception ex)
{
_telemetry.TrackException(ex);
}
}
/// <summary>
/// Get the data from the Recurrence able storage based on the email id.
/// </summary>
/// <param name="email">email id of the creator of the reflection.</param>
/// <returns>RecurssionScreenData model.</returns>
public async Task <List <RecurssionScreenData> > GetRecurrencePostsDataAsync(string email)
{
_telemetry.TrackEvent("GetRecurrencePostsDataAsync");
try
{
ReflectionDataRepository reflectionDataRepository = new ReflectionDataRepository(_configuration, _telemetry);
QuestionsDataRepository questionsDataRepository = new QuestionsDataRepository(_configuration, _telemetry);
RecurssionDataRepository recurssionDataRepository = new RecurssionDataRepository(_configuration, _telemetry);
List <ReflectionDataEntity> allActiveRefs = await reflectionDataRepository.GetAllActiveReflection(email);
List <Guid?> allActiveRefIDs = allActiveRefs.Select(c => c.ReflectionID).ToList();
List <Guid?> allActiveQuestionIDs = allActiveRefs.Select(c => c.QuestionID).ToList();
List <QuestionsDataEntity> allQuestionsData = await questionsDataRepository.GetAllQuestionData(allActiveQuestionIDs);
List <RecurssionDataEntity> allRecurssionData = await recurssionDataRepository.GetAllRecurssionData(allActiveRefIDs);
List <RecurssionScreenData> screenData = new List <RecurssionScreenData>();
foreach (var rec in allRecurssionData)
{
RecurssionScreenData recurssionScreenData = new RecurssionScreenData();
recurssionScreenData.RefID = rec.ReflectionID;
var reflection = await reflectionDataRepository.GetReflectionData(rec.ReflectionID);
recurssionScreenData.CreatedBy = reflection.CreatedBy;
recurssionScreenData.RefCreatedDate = reflection.RefCreatedDate;
recurssionScreenData.Privacy = reflection.Privacy;
recurssionScreenData.Question = allQuestionsData.Where(c => c.QuestionID.ToString() == reflection.QuestionID.ToString()).Select(d => d.Question).FirstOrDefault().ToString();
recurssionScreenData.ExecutionDate = rec.ExecutionDate;
recurssionScreenData.ExecutionTime = rec.ExecutionTime;
recurssionScreenData.NextExecutionDate = rec.NextExecutionDate;
recurssionScreenData.RecurssionType = rec.RecursstionType;
recurssionScreenData.CustomRecurssionTypeValue = rec.CustomRecurssionTypeValue;
recurssionScreenData.ScheduleId = rec.ScheduleId;
if (recurssionScreenData.RecurssionType != null && recurssionScreenData.NextExecutionDate != null)
{
screenData.Add(recurssionScreenData);
}
}
return(screenData);
}
catch (Exception ex)
{
_telemetry.TrackException(ex);
return(null);
}
}
/// <summary>
/// Delete recurrence data based on the reflection id
/// </summary>
/// <param name="reflectionId">reflectionId.</param>
/// <returns>Null.</returns>
public async Task DeleteRecurrsionDataAsync(Guid reflectionId)
{
try
{
_telemetry.TrackEvent("DeleteRecurrsionDataAsync");
ReflectionDataRepository reflectionDataRepository = new ReflectionDataRepository(_configuration, _telemetry);
RecurssionDataRepository recurssionDataRepository = new RecurssionDataRepository(_configuration, _telemetry);
var reflection = await reflectionDataRepository.GetReflectionData(reflectionId);
var recurssion = await recurssionDataRepository.GetRecurssionData(reflection.RecurrsionID);
await recurssionDataRepository.DeleteAsync(recurssion);
await reflectionDataRepository.DeleteAsync(reflection);
}
catch (Exception ex)
{
_telemetry.TrackException(ex);
}
}
/// <summary>
/// Save Edit Recursion Data Async.
/// </summary>
/// <param name="reflection">reflection.</param>
/// <returns>.</returns>
public async Task SaveEditRecurssionDataAsync(RecurssionScreenData reflection)
{
try
{
_telemetry.TrackEvent("SaveEditRecurssionDataAsync");
ReflectionDataRepository reflectionDataRepository = new ReflectionDataRepository(_configuration, _telemetry);
RecurssionDataRepository recurssionDataRepository = new RecurssionDataRepository(_configuration, _telemetry);
var reflectiondata = await reflectionDataRepository.GetReflectionData(reflection.RefID);
var recurssion = await recurssionDataRepository.GetRecurssionData(reflectiondata.RecurrsionID);
ReflectionDataEntity reflectionDataEntity = new ReflectionDataEntity();
RecurssionDataEntity recurssionDataEntity = new RecurssionDataEntity();
var reflectionid = Guid.NewGuid();
var recurrsionid = Guid.NewGuid();
reflectionDataEntity = reflectiondata;
reflectionDataEntity.ReflectionID = reflectionid;
reflectionDataEntity.RefCreatedDate = DateTime.Now;
reflectionDataEntity.RecurrsionID = recurrsionid;
reflectionDataEntity.RowKey = Guid.NewGuid().ToString();
await reflectionDataRepository.CreateAsync(reflectionDataEntity);
recurssionDataEntity = recurssion;
recurssionDataEntity.ReflectionID = reflectionid;
recurssionDataEntity.CreatedDate = DateTime.Now;
recurssionDataEntity.RecurssionID = recurrsionid;
recurssionDataEntity.RecursstionType = reflection.RecurssionType;
recurssionDataEntity.CustomRecurssionTypeValue = reflection.CustomRecurssionTypeValue;
recurssionDataEntity.RowKey = Guid.NewGuid().ToString();
recurssionDataEntity.NextExecutionDate = reflection.NextExecutionDate;
await recurssionDataRepository.CreateAsync(recurssionDataEntity);
recurssion.NextExecutionDate = null;
await recurssionDataRepository.CreateOrUpdateAsync(recurssion);
}
catch (Exception ex)
{
_telemetry.TrackException(ex);
}
}
/// <summary>
/// Get the calculated next execution date time.
/// </summary>
/// <param name="recurssionEntity">recurssionEntity.</param>
/// <returns>Calculated next execution date time.</returns>
public DateTime?GetCalculatedNextExecutionDateTimeAsync(RecurssionDataEntity recurssionEntity)
{
_telemetry.TrackEvent("UpdateRecurssionDataNextExecutionDateTimeAsync");
DateTime?calculatedNextExecutionDate = null;
try
{
DateTime nextExecutionDate = Convert.ToDateTime(recurssionEntity.NextExecutionDate);
RecurssionDataRepository recurssionDataRepository = new RecurssionDataRepository(_configuration, _telemetry);
switch (recurssionEntity.RecursstionType.ToLower().Trim())
{
case "daily":
DateTime?nextExecutionDay = DateTime.Now.AddDays(1);
calculatedNextExecutionDate = recurssionEntity.RecurssionEndDate >= nextExecutionDay ? nextExecutionDay : null;
break;
case "every weekday":
DateTime?nextWeekDay = GetNextWeekday();
calculatedNextExecutionDate = recurssionEntity.RecurssionEndDate >= nextWeekDay ? nextWeekDay : null;
break;
case "weekly":
DateTime?nextWeeklyday = GetNextWeeklyday(nextExecutionDate.DayOfWeek);
calculatedNextExecutionDate = recurssionEntity.RecurssionEndDate >= nextWeeklyday ? nextWeeklyday : null;
break;
case "monthly":
DateTime?nextMonthlyday = nextExecutionDate.AddMonths(1);
calculatedNextExecutionDate = recurssionEntity.RecurssionEndDate >= nextMonthlyday ? nextMonthlyday : null;
break;
case "does not repeat":
calculatedNextExecutionDate = null;
break;
case "custom":
if (recurssionEntity.CustomRecurssionTypeValue.Contains("week"))
{
var selectedweeks = new List <string>();
weekdays.ForEach(x =>
{
if (recurssionEntity.CustomRecurssionTypeValue.Contains(x))
{
selectedweeks.Add(x);
}
});
if (selectedweeks.Count == 1)
{
goto case "weekly";
}
else if (selectedweeks.Count == 5 && selectedweeks.IndexOf("Saturday") == -1 && selectedweeks.IndexOf("Sunday") == -1)
{
goto case "every weekday";
}
else
{
var weekindex = selectedweeks.IndexOf(nextExecutionDate.DayOfWeek.ToString());
if ((weekindex + 1) < selectedweeks.Count)
{
int addDays = weekdays.IndexOf(selectedweeks[weekindex + 1]) - weekdays.IndexOf(selectedweeks[weekindex]);
DateTime?nextcustomweeklyday = DateTime.Now.AddDays(addDays);
calculatedNextExecutionDate = recurssionEntity.RecurssionEndDate >= nextcustomweeklyday ? nextcustomweeklyday : null;
}
}
break;
}
if (recurssionEntity.CustomRecurssionTypeValue.Contains("month"))
{
if (recurssionEntity.CustomRecurssionTypeValue.Contains("Day"))
{
goto case "monthly";
}
else
{
break;
}
}
else
{
DateTime?nextcustomdailyday = DateTime.Now.AddDays(1);
calculatedNextExecutionDate = recurssionEntity.RecurssionEndDate >= nextcustomdailyday ? nextcustomdailyday : null;
break;
}
default:
break;
}
}
catch (Exception ex)
{
_telemetry.TrackException(ex);
}
return(calculatedNextExecutionDate);
}
/// <summary>
/// On message activity sync.
/// </summary>
/// <param name="turnContext">turnContext.</param>
/// <param name="cancellationToken">cancellationToken.</param>
/// <returns>.</returns>
protected override async Task OnMessageActivityAsync(ITurnContext <IMessageActivity> turnContext, CancellationToken cancellationToken)
{
_telemetry.TrackEvent("OnMessageActivityAsync");
try
{
FeedbackDataRepository feedbackDataRepository = new FeedbackDataRepository(_configuration, _telemetry);
ReflectionDataRepository reflectionDataRepository = new ReflectionDataRepository(_configuration, _telemetry);
RecurssionDataRepository recurssionDataRepository = new RecurssionDataRepository(_configuration, _telemetry);
QuestionsDataRepository questiondatarepository = new QuestionsDataRepository(_configuration, _telemetry);
if (turnContext.Activity.Value != null)
{
var response = JsonConvert.DeserializeObject <UserfeedbackInfo>(turnContext.Activity.Value.ToString());
var reply = Activity.CreateMessageActivity();
if (response.type == ReflectConstants.SaveFeedBack)
{
var name = (turnContext.Activity.From.Name).Split();
response.userName = name[0] + ' ' + name[1];
response.emailId = await _dbHelper.GetUserEmailId(turnContext);
// Check if this is user's second feedback
FeedbackDataEntity feebackData = await feedbackDataRepository.GetReflectionFeedback(response.reflectionId, response.emailId);
if (feebackData != null && response.emailId == feebackData.FeedbackGivenBy)
{
feebackData.Feedback = response.feedbackId;
await feedbackDataRepository.CreateOrUpdateAsync(feebackData);
}
else
{
await _dbHelper.SaveReflectionFeedbackDataAsync(response);
}
try
{
// Check if message id is present in reflect data
ReflectionDataEntity reflectData = await reflectionDataRepository.GetReflectionData(response.reflectionId);
QuestionsDataEntity question = await questiondatarepository.GetQuestionData(reflectData.QuestionID);
Dictionary <int, List <FeedbackDataEntity> > feedbacks = await feedbackDataRepository.GetReflectionFeedback(response.reflectionId);
var adaptiveCard = _cardHelper.FeedBackCard(feedbacks, response.reflectionId, question.Question);
TaskInfo taskInfo = new TaskInfo();
taskInfo.question = question.Question;
taskInfo.postCreateBy = reflectData.CreatedBy;
taskInfo.privacy = reflectData.Privacy;
taskInfo.reflectionID = reflectData.ReflectionID;
Attachment attachment = new Attachment()
{
ContentType = AdaptiveCard.ContentType,
Content = adaptiveCard
};
reply.Attachments.Add(attachment);
if (reflectData.MessageID == null)
{
var result = turnContext.SendActivityAsync(reply, cancellationToken);
reflectData.MessageID = result.Result.Id;
// update message-id in reflection table
await reflectionDataRepository.InsertOrMergeAsync(reflectData);
}
else
{
reply.Id = reflectData.MessageID;
await turnContext.UpdateActivityAsync(reply);
}
}
catch (System.Exception e)
{
_telemetry.TrackException(e);
Console.WriteLine(e.Message.ToString());
}
}
}
else
{
await turnContext.SendActivityAsync(MessageFactory.Text($"Hello from Olga."), cancellationToken);
}
}
catch (Exception ex)
{
_telemetry.TrackException(ex);
}
}
/// <summary>
/// On Teams Task Module Fetch Async.
/// </summary>
/// <param name="turnContext">turnContext.</param>
/// <param name="taskModuleRequest">taskModuleRequest.</param>
/// <param name="cancellationToken">cancellationToken.</param>
/// <returns>.</returns>
protected override async Task <TaskModuleResponse> OnTeamsTaskModuleFetchAsync(ITurnContext <IInvokeActivity> turnContext, TaskModuleRequest taskModuleRequest, CancellationToken cancellationToken)
{
_telemetry.TrackEvent("OnTeamsTaskModuleFetchAsync");
try
{
ReflctionData reldata = JsonConvert.DeserializeObject <ReflctionData>(taskModuleRequest.Data.ToString());
FeedbackDataRepository feedbackDataRepository = new FeedbackDataRepository(_configuration, _telemetry);
ReflectionDataRepository reflectionDataRepository = new ReflectionDataRepository(_configuration, _telemetry);
RecurssionDataRepository recurssionDataRepository = new RecurssionDataRepository(_configuration, _telemetry);
QuestionsDataRepository questiondatarepository = new QuestionsDataRepository(_configuration, _telemetry);
var response = new UserfeedbackInfo();
var name = (turnContext.Activity.From.Name).Split();
response.userName = name[0] + ' ' + name[1];
response.emailId = await _dbHelper.GetUserEmailId(turnContext);
var reflectionid = reldata.datajson.ReflectionId;
var feedbackId = reldata.datajson.FeedbackId;
response.reflectionId = reflectionid;
response.feedbackId = feedbackId;
// Check if this is user's second feedback
FeedbackDataEntity feebackData = await feedbackDataRepository.GetReflectionFeedback(response.reflectionId, response.emailId);
TaskInfo taskInfo = new TaskInfo();
if (response.feedbackId != 0)
{
if (feebackData != null && response.emailId == feebackData.FeedbackGivenBy)
{
feebackData.Feedback = response.feedbackId;
await feedbackDataRepository.CreateOrUpdateAsync(feebackData);
}
else
{
await _dbHelper.SaveReflectionFeedbackDataAsync(response);
}
try
{
// Check if message id is present in reflect data
ReflectionDataEntity reflectData = await reflectionDataRepository.GetReflectionData(response.reflectionId);
QuestionsDataEntity question = await questiondatarepository.GetQuestionData(reflectData.QuestionID);
Dictionary <int, List <FeedbackDataEntity> > feedbacks = await feedbackDataRepository.GetReflectionFeedback(response.reflectionId);
var adaptiveCard = _cardHelper.FeedBackCard(feedbacks, response.reflectionId, question.Question);
taskInfo.question = question.Question;
taskInfo.postCreateBy = reflectData.CreatedBy;
taskInfo.privacy = reflectData.Privacy;
taskInfo.reflectionID = reflectData.ReflectionID;
Attachment attachment = new Attachment()
{
ContentType = AdaptiveCard.ContentType,
Content = adaptiveCard,
};
var reply = Activity.CreateMessageActivity();
reply.Attachments.Add(attachment);
if (reflectData.MessageID == null)
{
var result = turnContext.SendActivityAsync(reply, cancellationToken);
reflectData.MessageID = result.Result.Id;
// update messageid in reflection table
await reflectionDataRepository.InsertOrMergeAsync(reflectData);
}
else
{
reply.Id = reflectData.MessageID;
await turnContext.UpdateActivityAsync(reply);
}
}
catch (System.Exception e)
{
_telemetry.TrackException(e);
Console.WriteLine(e.Message.ToString());
}
}
return(new TaskModuleResponse
{
Task = new TaskModuleContinueResponse
{
Value = new TaskModuleTaskInfo()
{
Height = 600,
Width = 600,
Title = "Track how you're feeling every day.",
Url = reldata.data.URL + reflectionid + '/' + feedbackId + '/' + response.userName,
},
},
});
}
catch (Exception ex)
{
_telemetry.TrackException(ex);
return(null);
}
}
/// <summary>
/// RunJob.
/// </summary>
/// <param name="state">state.</param>
private async void RunJob(object state)
{
_telemetry.TrackEvent("RunJob");
try
{
ChannelAccount channelAccount = new ChannelAccount(_configuration["MicrosoftAppId"]);
Attachment attachment = new Attachment();
TeamsChannelData channelData = new TeamsChannelData()
{
Notification = new NotificationInfo(true)
};
RecurssionDataRepository recurssionDataRepository = new RecurssionDataRepository(_configuration, _telemetry);
ReflectionDataRepository reflectionDataRepository = new ReflectionDataRepository(_configuration, _telemetry);
QuestionsDataRepository questiondatarepository = new QuestionsDataRepository(_configuration, _telemetry);
var recurssionData = await recurssionDataRepository.GetAllRecurssionData();
foreach (RecurssionDataEntity recurssionDataEntity in recurssionData)
{
var reflectionData = await reflectionDataRepository.GetReflectionData(recurssionDataEntity.ReflectionID);
var question = await questiondatarepository.GetQuestionData(reflectionData.QuestionID);
TaskInfo taskInfo = new TaskInfo();
taskInfo.question = question.Question;
taskInfo.postCreateBy = reflectionData.CreatedBy;
taskInfo.privacy = reflectionData.Privacy;
taskInfo.reflectionID = reflectionData.ReflectionID;
var newPostCard = _cardHelper.CreateNewReflect(taskInfo);
Attachment newPostCardAttachment = new Attachment()
{
ContentType = AdaptiveCard.ContentType,
Content = newPostCard
};
var PostCardFeedback = _cardHelper.FeedBackCard(new Dictionary <int, List <FeedbackDataEntity> >(), taskInfo.reflectionID, taskInfo.question);;
Attachment PostCardFeedbackAttachment = new Attachment()
{
ContentType = AdaptiveCard.ContentType,
Content = PostCardFeedback
};
var proactiveNotification = await new ProactiveMessageHelper(_configuration).SendChannelNotification(channelAccount, reflectionData.ServiceUrl, reflectionData.ChannelID, "", newPostCardAttachment);
if (proactiveNotification.IsSuccessful && proactiveNotification.MessageId != null)
{
reflectionData.ReflectMessageId = proactiveNotification.MessageId.Split("=")[1];
var feedbackproactivemessage = await new ProactiveMessageHelper(_configuration).SendChannelNotification(channelAccount, reflectionData.ServiceUrl, reflectionData.ChannelID, "", PostCardFeedbackAttachment, reflectionData.ReflectMessageId);
if (feedbackproactivemessage.IsSuccessful && proactiveNotification.MessageId != null)
{
reflectionData.MessageID = feedbackproactivemessage.MessageId;
await _dbHelper.UpdateReflectionMessageIdAsync(reflectionData);
}
}
var calculatedNextExecutionDateTime = _dbHelper.GetCalculatedNextExecutionDateTimeAsync(recurssionDataEntity);
recurssionDataEntity.NextExecutionDate = null;
await recurssionDataRepository.CreateOrUpdateAsync(recurssionDataEntity);
if (calculatedNextExecutionDateTime != null)
{
ReflectionDataEntity newreflectionDataEntity = new ReflectionDataEntity();
RecurssionDataEntity newRecurssionDataEntity = new RecurssionDataEntity();
var reflectionid = Guid.NewGuid();
var recurrsionid = Guid.NewGuid();
newreflectionDataEntity = reflectionData;
newreflectionDataEntity.RowKey = Guid.NewGuid().ToString();
newreflectionDataEntity.ReflectionID = reflectionid;
newreflectionDataEntity.RefCreatedDate = DateTime.Now;
newreflectionDataEntity.RecurrsionID = recurrsionid;
await reflectionDataRepository.CreateAsync(newreflectionDataEntity);
newRecurssionDataEntity = recurssionDataEntity;
newRecurssionDataEntity.RowKey = Guid.NewGuid().ToString();
newRecurssionDataEntity.ReflectionID = reflectionid;
newRecurssionDataEntity.CreatedDate = DateTime.Now;
newRecurssionDataEntity.RecurssionID = recurrsionid;
newRecurssionDataEntity.NextExecutionDate = calculatedNextExecutionDateTime;
await recurssionDataRepository.CreateAsync(newRecurssionDataEntity);
}
}
}
catch (Exception ex)
{
_telemetry.TrackException(ex);
}
}
