public async Task Handle(PushMessage message)
{
Planning planning = await _dbContext.Plannings.FirstOrDefaultAsync(x => x.Id == message.PlanningId);
if (planning != null)
{
await using MicrotingDbContext microtingDbContext = _sdkCore.DbContextHelper.GetDbContext();
List <PlanningSite> planningSites =
await _dbContext.PlanningSites.Where(x => x.PlanningId == message.PlanningId && x.WorkflowState != Constants.WorkflowStates.Removed).ToListAsync();
foreach (PlanningSite planningSite in planningSites)
{
Site site = await microtingDbContext.Sites.FirstOrDefaultAsync(x => x.Id == planningSite.SiteId);
if (site != null)
{
PlanningNameTranslation planningNameTranslation =
await _dbContext.PlanningNameTranslation.FirstAsync(x =>
x.PlanningId == planning.Id &&
x.LanguageId == site.LanguageId);
var folder = await GetTopFolderName((int)planning.SdkFolderId !, microtingDbContext);
string body = "";
if (folder != null)
{
planning.SdkFolderId = microtingDbContext.Folders.First(y => y.Id == planning.SdkFolderId).Id;
FolderTranslation folderTranslation =
await microtingDbContext.FolderTranslations.SingleAsync(x =>
x.FolderId == folder.Id && x.LanguageId == site.LanguageId);
body = $"{folderTranslation.Name} ({site.Name};{DateTime.Now:dd.MM.yyyy})";
}
PlanningCaseSite planningCaseSite = await _dbContext.PlanningCaseSites.FirstOrDefaultAsync(x =>
x.PlanningId == planningSite.PlanningId &&
x.MicrotingSdkSiteId == planningSite.SiteId &&
x.Status != 100 &&
x.WorkflowState == Constants.WorkflowStates.Created);
Log.LogEvent($"[DBG] ItemsPlanningService PushMessageHandler.Handle : Sending push message body: {body}, title : {planningNameTranslation.Name} to site.id : {site.Id}");
Case @case =
await microtingDbContext.Cases.FirstAsync(x =>
x.Id == planningCaseSite.MicrotingSdkCaseId);
await _sdkCore.SendPushMessage(site.Id, planningNameTranslation.Name, body, (int)@case.MicrotingUid !);
}
}
planning.PushMessageSent = true;
await planning.Update(_dbContext);
}
}
public async Task Handle(eFormCompleted message)
{
await using MicrotingDbContext sdkDbContext = _sdkCore.DbContextHelper.GetDbContext();
Console.WriteLine($"Checking PlanningCaseSites with MicrotingSdkCaseId == {message.caseId}");
Console.WriteLine($"Checking Cases with Id == {message.caseId}");
Console.WriteLine($"Checking Cases with MicrotingCheckUid == {message.CheckId}");
var planningCaseSite =
await _dbContext.PlanningCaseSites.FirstOrDefaultAsync(x => x.MicrotingSdkCaseId == message.caseId);
var dbCase = await sdkDbContext.Cases.FirstOrDefaultAsync(x => x.Id == message.caseId) ?? await sdkDbContext.Cases.FirstOrDefaultAsync(x => x.MicrotingCheckUid == message.CheckId);
if (planningCaseSite == null)
{
Console.WriteLine($"Checking CheckListSites with MicrotingUid == {message.MicrotingUId}");
var checkListSite = await sdkDbContext.CheckListSites.FirstOrDefaultAsync(x =>
x.MicrotingUid == message.MicrotingUId);
if (checkListSite != null)
{
Console.WriteLine($"Checking PlanningCaseSites with MicrotingCheckListSitId == {checkListSite.Id}");
planningCaseSite =
await _dbContext.PlanningCaseSites.FirstOrDefaultAsync(x =>
x.MicrotingCheckListSitId == checkListSite.Id);
}
}
if (planningCaseSite != null)
{
Planning planning =
await _dbContext.Plannings.FirstAsync(x => x.Id == planningCaseSite.PlanningId);
Site site = await sdkDbContext.Sites.FirstAsync(x => x.Id == dbCase.SiteId);
Language language = await sdkDbContext.Languages.FirstAsync(x => x.Id == site.LanguageId);
if (dbCase.MicrotingUid != null && dbCase.MicrotingCheckUid != null)
{
ReplyElement theCase =
await _sdkCore.CaseRead((int)dbCase.MicrotingUid, (int)dbCase.MicrotingCheckUid, language);
if (planning.RepeatType == RepeatType.Day && planning.RepeatEvery == 0)
{
var planningCase =
await _dbContext.PlanningCases.FirstOrDefaultAsync(x =>
x.Id == planningCaseSite.PlanningCaseId);
if (planningCase != null && planningCase.Status != 100)
{
planningCase.Status = 100;
planningCase.MicrotingSdkCaseDoneAt = theCase.DoneAt;
planningCase.MicrotingSdkCaseId = dbCase.Id;
planningCase.DoneByUserId = theCase.DoneById;
planningCase.DoneByUserName = site.Name;
planningCase.MicrotingSdkeFormId = (int)dbCase.CheckListId;
planningCase.WorkflowState = Constants.WorkflowStates.Processed;
planningCase = await SetFieldValue(planningCase, theCase.Id, language);
await planningCase.Update(_dbContext);
}
else
{
if (planningCase == null || planningCase.MicrotingSdkCaseId != dbCase.Id)
{
planningCase = new PlanningCase
{
Status = 100,
MicrotingSdkCaseDoneAt = theCase.DoneAt,
MicrotingSdkCaseId = dbCase.Id,
DoneByUserId = theCase.DoneById,
DoneByUserName = site.Name,
WorkflowState = Constants.WorkflowStates.Processed,
MicrotingSdkeFormId = (int)dbCase.CheckListId,
PlanningId = planning.Id
};
await planningCase.Create(_dbContext);
planningCase = await SetFieldValue(planningCase, theCase.Id, language);
await planningCase.Update(_dbContext);
}
}
}
else
{
planningCaseSite.Status = 100;
planningCaseSite = await SetFieldValue(planningCaseSite, theCase.Id, language);
planningCaseSite.MicrotingSdkCaseDoneAt = theCase.DoneAt;
planningCaseSite.DoneByUserId = theCase.DoneById;
var worker = await sdkDbContext.Workers.SingleAsync(x => x.Id == planningCaseSite.DoneByUserId);
planningCaseSite.DoneByUserName = $"{worker.FirstName} {worker.LastName}";
await planningCaseSite.Update(_dbContext);
var planningCase =
await _dbContext.PlanningCases.SingleOrDefaultAsync(x =>
x.Id == planningCaseSite.PlanningCaseId);
if (planningCase.Status != 100)
{
planningCase.Status = 100;
planningCase.MicrotingSdkCaseDoneAt = theCase.DoneAt;
planningCase.MicrotingSdkCaseId = dbCase.Id;
planningCase.DoneByUserId = theCase.DoneById;
planningCase.DoneByUserName = site.Name;
planningCase.WorkflowState = Constants.WorkflowStates.Processed;
// planningCase.DoneByUserName = $"{site.Result.FirstName} {site.Result.LastName}";
planningCase = await SetFieldValue(planningCase, theCase.Id, language);
await planningCase.Update(_dbContext);
}
planning.DoneInPeriod = true;
await planning.Update(_dbContext);
await RetractFromMicroting(planningCase.Id);
}
}
}
}
