private void UpdateSites() { _logger.Information("Updating Sites"); SiteDal dal = new SiteDal(_configuration, _logger); DateTime?lastUpdate = dal.GetLastAdded(); if (lastUpdate == null || lastUpdate.Value.Year == 0) { InitialiseSites(); } else { IEnumerable <SiteModel> siteModels = new SOAPHelper(_autotaskApiUsername, _autotaskApiPassword, _autotaskApiIntegrationCode, _autotaskApiUrl, _logger) .RetrieveNewSites(lastUpdate.Value); if (siteModels != null && siteModels.Count() > 0) { _logger.Information($"{siteModels.Count()} new Sites found"); } { foreach (SiteModel site in siteModels) { Domain.Enums.CRUDEnums.ActionResult actionResult = dal.Put(site).GetAwaiter().GetResult(); } } } }
private void UpdateTickets() { _logger.Information("Updating Tickets"); TicketDal dal = new TicketDal(_configuration, _logger); DateTime? lastUpdate = dal.GetLastUpdated(); if (lastUpdate == null || lastUpdate.Value.Year == 0) { _logger.Information("No tickets found trying initalisation"); InitialiseTickets(); } else { IEnumerable <TicketModel> ticketModels = new SOAPHelper(_autotaskApiUsername, _autotaskApiPassword, _autotaskApiIntegrationCode, _autotaskApiUrl, _logger) .RetriveUpdatedTickets(lastUpdate.Value); if (ticketModels != null && ticketModels.Count() > 0) { _logger.Information($"{ticketModels.Count()} updated Tickets found"); Domain.Enums.CRUDEnums.ActionResult actionResult = dal.PutOrPost(ticketModels).GetAwaiter().GetResult(); } } }
private void InitialiseTypes() { _logger.Information("Initialising Types"); DatabaseHelper databaseHelper = new DatabaseHelper(_remoteAutoTaskDatabaseConnection); Domain.Enums.CRUDEnums.ActionResult actionResult = Domain.Enums.CRUDEnums.ActionResult.Success; TypesDal dal = new TypesDal(_configuration); try { IEnumerable <PriorityTypePOCO> priorityTypePOCOs = databaseHelper.GetPriorityType(); if (priorityTypePOCOs != null && priorityTypePOCOs.Count() > 0) { _logger.Information($"{priorityTypePOCOs.Count()} Priority Types Found"); IEnumerable <PriorityTypeModel> priorityTypes = from priority in priorityTypePOCOs select new PriorityTypeModel() { Id = priority.Priority_Id, IsActive = priority.Is_Active, Name = priority.Priority_Name, SortOrder = priority.Sort_Order }; actionResult = dal.AddOrReplacePriorityTypes(priorityTypes).GetAwaiter().GetResult(); _logger.Information("Priority Types Inserted"); } } catch (Exception ex) { _logger.Error(ex, "Failed intialising Priority Types"); } try { IEnumerable <TicketTypePOCO> ticketTypePOCOs = databaseHelper.GetTicketType(); if (ticketTypePOCOs != null && ticketTypePOCOs.Count() > 0) { _logger.Information($"{ticketTypePOCOs.Count()} Ticket Types Found"); IEnumerable <TicketTypeModel> ticketTypes = from ticketTypePOCO in ticketTypePOCOs select new TicketTypeModel() { Id = ticketTypePOCO.Task_Type_Id, Name = ticketTypePOCO.Task_Type_Name }; actionResult = dal.AddOrReplaceTicketType(ticketTypes).GetAwaiter().GetResult(); _logger.Information("Ticket Types Inserted"); } } catch (Exception ex) { _logger.Error(ex, "Failed intialising Ticket Types"); } try { IEnumerable <TaskStatusPOCO> taskStatusPOCOs = databaseHelper.GetTaskStatus(); if (taskStatusPOCOs != null && taskStatusPOCOs.Count() > 0) { _logger.Information($"{taskStatusPOCOs.Count()} Task Statuses Found"); IEnumerable <TaskStatusModel> taskStatuses = from taskStatusPOCO in taskStatusPOCOs select new TaskStatusModel() { Id = taskStatusPOCO.Task_Status_Id, IsActive = taskStatusPOCO.Is_Active, IsSystem = taskStatusPOCO.Is_System, ServiceLevelAgreementEventTypeCode = taskStatusPOCO.Service_Level_Agreement_Event_Type_Code, SortOrder = taskStatusPOCO.Sort_Order, TaskStatusName = taskStatusPOCO.Task_Status_Name }; actionResult = dal.AddOrReplaceTaskStatuss(taskStatuses).GetAwaiter().GetResult(); _logger.Information("Task Statuses Inserted"); } } catch (Exception ex) { _logger.Error(ex, "Failed intialising Task Statuses"); } databaseHelper = null; }