private static async Task AddPromptsFromGmmsToArive(Move move, int jobId, string regNumber) { var legacyPromptEntity = await WaterDbAccess.RetrievePrompts(move.RegNumber); if (legacyPromptEntity == null || legacyPromptEntity.Count == 0) { Trace.WriteLine($"{regNumber}, , No Available prompts found in GMMS"); return; } foreach (var prompt in legacyPromptEntity) { var adObj = await SungateApi.GetADName(_httpClient, NameTranslator.repo.GetValueOrDefault(prompt.ENTERED_BY), regNumber); if (adObj != null && adObj.Count > 0) { prompt.ENTERED_BY = adObj.FirstOrDefault().email; } else { Console.WriteLine($"{regNumber}, Can't get Prompt created User So defaulting it to [email protected]"); Trace.WriteLine($"{regNumber}, , Can't get Prompt created User So defaulting it to [email protected]"); prompt.ENTERED_BY = "*****@*****.**"; } prompt.JobId = jobId; } var workflowTasks = legacyPromptEntity.ToWorkFlowTask(); await TaskDbAccess.AddPrompts(workflowTasks, regNumber, jobId); }
internal static async Task CreateNotes(HttpClient httpClient, List <CreateJobNoteRequest> createJobNoteRequests, int jobId, string regNumber) { Console.WriteLine($"Adding {createJobNoteRequests.Count} Notes to Task"); Trace.WriteLine($"{regNumber}, , Adding {createJobNoteRequests.Count} Notes to Task"); //string url = "Notes"; //TODO: figure out why this isn't working string url = $"Notes/jobs/{jobId}"; foreach (var createJobNote in createJobNoteRequests) { createJobNote.JobId = jobId; createJobNote.ReferenceId = jobId; var noteId = await PostToTaskApi(httpClient, url, createJobNote); var note = JsonConvert.DeserializeObject <NoteResponseModel>(noteId); //call taskdb and update the datecreated TaskDbAccess.ChangeDateCreated(note.Id, createJobNote.DateCreated, regNumber); } }
private static async Task AddNotesFromGmmsToArive(Move move, int jobId, string regNumber) { var notesEntity = await WaterDbAccess.RetrieveNotesForMove(move.RegNumber); if (notesEntity == null) { Trace.WriteLine($"{regNumber}, , No Available notes found in GMMS"); return; } foreach (var note in notesEntity) { var adObj = await SungateApi.GetADName(_httpClient, NameTranslator.repo.GetValueOrDefault(note.ENTERED_BY), regNumber); if (adObj != null && adObj.Count > 0) { note.ENTERED_BY = adObj.FirstOrDefault().email; } else { note.ENTERED_BY = "*****@*****.**"; } } var createJobNoteRequests = notesEntity.ToNotesModel(); foreach (var noteobj in createJobNoteRequests) { if (!noteobj.Category.Equals("serviceboard")) { noteobj.DisplayId = regNumber; } noteobj.ReferenceId = jobId; } await TaskDbAccess.AddNotes(createJobNoteRequests, jobId, regNumber); //await TaskApi.CreateNotes(_httpClient, createJobNoteRequests, jobId, regNumber); }
private static async Task Main(string[] args) { loadAllRecords = true; SetConsoleWriteLine(); SetMovesToImport(loadAllRecords); await RetrieveJobsAccountAndVendor(); Trace.WriteLine($"GMMS REG Number, Arive Job# , Log text "); int counter = 0; var jobId = 0; //Normal Import foreach (var regNumber in movesToImport) { try { Console.WriteLine("-----------------------------------------------------------------------------------"); Console.WriteLine($"Processing { ++counter} records of {movesToImport.Count} to import"); Trace.WriteLine($"{regNumber}, , "); Trace.WriteLine($"{regNumber}, , -----------------------------------------------------------------------------------"); await SungateApi.setApiAccessTokenAsync(_httpClient); var move = await WaterDbAccess.RetrieveWaterRecords(regNumber); if (move == null) { continue; } //Add the job jobId = await addStorageJob(move, regNumber); //update datecreated on the job JobsDbAccess.ChangeDateCreated(jobId, move.DateEntered.GetValueOrDefault(DateTime.UtcNow), regNumber); //Add JobContacts await addJobContacts(move, jobId, regNumber); //Add SuperService var result = await JobsApi.CreateStorageSSO(_httpClient, jobId, regNumber); var ssoId = result.Id; var serviceOrders = await JobsDbAccess.GetServiceOrderForJobs(jobId, regNumber); // ORIGIN var oaVendor = _vendor.Find(v => v.Accounting_SI_Code.Equals(move.OriginAgent.VendorNameId)); await JobsApi.UpdateOriginMilestone(_httpClient, serviceOrders.FirstOrDefault(so => so.ServiceId == 24).Id, oaVendor, move, jobId, regNumber); // DESTINATION var daVendor = _vendor.Find(v => v.Accounting_SI_Code.Equals(move.DestinationAgent.VendorNameId)); await JobsApi.UpdateDestinationMilestone(_httpClient, serviceOrders.FirstOrDefault(so => so.ServiceId == 26).Id, daVendor, move, jobId, regNumber); var legacyInsuranceClaims = await WaterDbAccess.RetrieveInsuranceClaims(move.RegNumber); // STORAGE var transfereeEntity = await JobsDbAccess.GetJobsTransfereeId(jobId); await updateStorageJob(move, jobId, serviceOrders, regNumber, transfereeEntity, legacyInsuranceClaims, ssoId); // INSURANCE await JobsApi.UpdateICtMilestone(_httpClient, serviceOrders.FirstOrDefault(so => so.ServiceId == 27).Id, move, jobId, legacyInsuranceClaims, regNumber); #region JobCost var superServiceOrderId = serviceOrders.FirstOrDefault(so => so.ServiceId == 29).SuperServiceOrderId; try { if (move.READY_TO_ACCRUE_DATE != null) { await JobsDbAccess.LockJC(jobId, regNumber, superServiceOrderId, move.READY_TO_ACCRUE_DATE.Value); await JobsDbAccess.MarkAsPosted(superServiceOrderId, DateTime.Now, true, regNumber, move.ACCRUED_DATE); //await JobsDbAccess.MarkAllAsVoid(superServiceOrderId, regNumber); } } catch (Exception ex) { Console.WriteLine("Error while trying to change JC status manually"); Trace.WriteLine($"{regNumber}, , Error while trying to change JC status manually"); Trace.WriteLine($"{regNumber}, , {ex.Message}"); } #endregion JobCost //Add Notes await AddNotesFromGmmsToArive(move, jobId, regNumber); //Add Prompts await AddPromptsFromGmmsToArive(move, jobId, regNumber); decimal percentage = (decimal)(counter * 100) / movesToImport.Count; Console.WriteLine($"{ Math.Round(percentage, 2)}% Completed "); Trace.WriteLine($"{regNumber}, , EndTime: {DateTime.Now}"); } catch (Exception ex) { Trace.WriteLine($"{regNumber}, , *** ERROR ***"); if (ex.InnerException != null) { Trace.WriteLine($"{regNumber}, , {ex.InnerException.Message}"); } else { Trace.WriteLine($"{regNumber}, , {ex.Message}"); } Console.WriteLine($"**** ERROR ****"); Console.WriteLine($"{ex.Message}"); } Trace.Flush(); } //Remove Prompts from MigrationScript TaskDbAccess.RemovePrompts(); }