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); } } } }