/// <summary> /// Update entity in adoxio_spddatarows /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='adoxioSpddatarowid'> /// key: adoxio_spddatarowid /// </param> /// <param name='body'> /// New property values /// </param> /// <param name='cancellationToken'> /// The cancellation token. /// </param> public static async Task UpdateAsync(this ISpddatarows operations, string adoxioSpddatarowid, MicrosoftDynamicsCRMadoxioSpddatarow body, CancellationToken cancellationToken = default(CancellationToken)) { (await operations.UpdateWithHttpMessagesAsync(adoxioSpddatarowid, body, null, cancellationToken).ConfigureAwait(false)).Dispose(); }
/// <summary> /// Add new entity to adoxio_spddatarows /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='body'> /// New entity /// </param> /// <param name='prefer'> /// Required in order for the service to return a JSON representation of the /// object. /// </param> public static MicrosoftDynamicsCRMadoxioSpddatarow Create(this ISpddatarows operations, MicrosoftDynamicsCRMadoxioSpddatarow body, string prefer = "return=representation") { return(operations.CreateAsync(body, prefer).GetAwaiter().GetResult()); }
/// <summary> /// Add new entity to adoxio_spddatarows /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='body'> /// New entity /// </param> /// <param name='prefer'> /// Required in order for the service to return a JSON representation of the /// object. /// </param> /// <param name='cancellationToken'> /// The cancellation token. /// </param> public static async Task <MicrosoftDynamicsCRMadoxioSpddatarow> CreateAsync(this ISpddatarows operations, MicrosoftDynamicsCRMadoxioSpddatarow body, string prefer = "return=representation", CancellationToken cancellationToken = default(CancellationToken)) { using (var _result = await operations.CreateWithHttpMessagesAsync(body, prefer, null, cancellationToken).ConfigureAwait(false)) { return(_result.Body); } }
/// <summary> /// Update entity in adoxio_spddatarows /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='adoxioSpddatarowid'> /// key: adoxio_spddatarowid /// </param> /// <param name='body'> /// New property values /// </param> public static void Update(this ISpddatarows operations, string adoxioSpddatarowid, MicrosoftDynamicsCRMadoxioSpddatarow body) { operations.UpdateAsync(adoxioSpddatarowid, body).GetAwaiter().GetResult(); }
/// <summary> /// Update entity in adoxio_spddatarows /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='adoxioSpddatarowid'> /// key: adoxio_spddatarowid of adoxio_spddatarow /// </param> /// <param name='body'> /// New property values /// </param> /// <param name='customHeaders'> /// Headers that will be added to request. /// </param> public static HttpOperationResponse UpdateWithHttpMessages(this ISpddatarows operations, string adoxioSpddatarowid, MicrosoftDynamicsCRMadoxioSpddatarow body, Dictionary <string, List <string> > customHeaders = null) { return(operations.UpdateWithHttpMessagesAsync(adoxioSpddatarowid, body, customHeaders, CancellationToken.None).ConfigureAwait(false).GetAwaiter().GetResult()); }
/// <summary> /// Add new entity to adoxio_spddatarows /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='body'> /// New entity /// </param> /// <param name='prefer'> /// Required in order for the service to return a JSON representation of the /// object. /// </param> /// <param name='customHeaders'> /// Headers that will be added to request. /// </param> public static HttpOperationResponse <MicrosoftDynamicsCRMadoxioSpddatarow> CreateWithHttpMessages(this ISpddatarows operations, MicrosoftDynamicsCRMadoxioSpddatarow body, string prefer = "return=representation", Dictionary <string, List <string> > customHeaders = null) { return(operations.CreateWithHttpMessagesAsync(body, prefer, customHeaders, CancellationToken.None).ConfigureAwait(false).GetAwaiter().GetResult()); }
/// <summary> /// Update entity in adoxio_spddatarows /// </summary> /// <param name='adoxioSpddatarowid'> /// key: adoxio_spddatarowid of adoxio_spddatarow /// </param> /// <param name='body'> /// New property values /// </param> /// <param name='customHeaders'> /// Headers that will be added to request. /// </param> /// <param name='cancellationToken'> /// The cancellation token. /// </param> /// <exception cref="HttpOperationException"> /// Thrown when the operation returned an invalid status code /// </exception> /// <exception cref="ValidationException"> /// Thrown when a required parameter is null /// </exception> /// <exception cref="System.ArgumentNullException"> /// Thrown when a required parameter is null /// </exception> /// <return> /// A response object containing the response body and response headers. /// </return> public async Task <HttpOperationResponse> UpdateWithHttpMessagesAsync(string adoxioSpddatarowid, MicrosoftDynamicsCRMadoxioSpddatarow body, Dictionary <string, List <string> > customHeaders = null, CancellationToken cancellationToken = default(CancellationToken)) { if (adoxioSpddatarowid == null) { throw new ValidationException(ValidationRules.CannotBeNull, "adoxioSpddatarowid"); } if (body == null) { throw new ValidationException(ValidationRules.CannotBeNull, "body"); } // Tracing bool _shouldTrace = ServiceClientTracing.IsEnabled; string _invocationId = null; if (_shouldTrace) { _invocationId = ServiceClientTracing.NextInvocationId.ToString(); Dictionary <string, object> tracingParameters = new Dictionary <string, object>(); tracingParameters.Add("adoxioSpddatarowid", adoxioSpddatarowid); tracingParameters.Add("body", body); tracingParameters.Add("cancellationToken", cancellationToken); ServiceClientTracing.Enter(_invocationId, this, "Update", tracingParameters); } // Construct URL var _baseUrl = Client.BaseUri.AbsoluteUri; var _url = new System.Uri(new System.Uri(_baseUrl + (_baseUrl.EndsWith("/") ? "" : "/")), "adoxio_spddatarows({adoxio_spddatarowid})").ToString(); _url = _url.Replace("{adoxio_spddatarowid}", System.Uri.EscapeDataString(adoxioSpddatarowid)); // Create HTTP transport objects var _httpRequest = new HttpRequestMessage(); HttpResponseMessage _httpResponse = null; _httpRequest.Method = new HttpMethod("PATCH"); _httpRequest.RequestUri = new System.Uri(_url); // Set Headers if (customHeaders != null) { foreach (var _header in customHeaders) { if (_httpRequest.Headers.Contains(_header.Key)) { _httpRequest.Headers.Remove(_header.Key); } _httpRequest.Headers.TryAddWithoutValidation(_header.Key, _header.Value); } } // Serialize Request string _requestContent = null; if (body != null) { _requestContent = Microsoft.Rest.Serialization.SafeJsonConvert.SerializeObject(body, Client.SerializationSettings); _httpRequest.Content = new StringContent(_requestContent, System.Text.Encoding.UTF8); _httpRequest.Content.Headers.ContentType = System.Net.Http.Headers.MediaTypeHeaderValue.Parse("application/json; charset=utf-8"); } // Set Credentials if (Client.Credentials != null) { cancellationToken.ThrowIfCancellationRequested(); await Client.Credentials.ProcessHttpRequestAsync(_httpRequest, cancellationToken).ConfigureAwait(false); } // Send Request if (_shouldTrace) { ServiceClientTracing.SendRequest(_invocationId, _httpRequest); } cancellationToken.ThrowIfCancellationRequested(); _httpResponse = await Client.HttpClient.SendAsync(_httpRequest, cancellationToken).ConfigureAwait(false); if (_shouldTrace) { ServiceClientTracing.ReceiveResponse(_invocationId, _httpResponse); } HttpStatusCode _statusCode = _httpResponse.StatusCode; cancellationToken.ThrowIfCancellationRequested(); string _responseContent = null; if ((int)_statusCode != 204) { var ex = new HttpOperationException(string.Format("Operation returned an invalid status code '{0}'", _statusCode)); if (_httpResponse.Content != null) { _responseContent = await _httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false); } else { _responseContent = string.Empty; } ex.Request = new HttpRequestMessageWrapper(_httpRequest, _requestContent); ex.Response = new HttpResponseMessageWrapper(_httpResponse, _responseContent); if (_shouldTrace) { ServiceClientTracing.Error(_invocationId, ex); } _httpRequest.Dispose(); if (_httpResponse != null) { _httpResponse.Dispose(); } throw ex; } // Create Result var _result = new HttpOperationResponse(); _result.Request = _httpRequest; _result.Response = _httpResponse; if (_shouldTrace) { ServiceClientTracing.Exit(_invocationId, _result); } return(_result); }
/// <summary> /// Hangfire job to send an export to SPD. /// </summary> public void SendExportJob(PerformContext hangfireContext) { hangfireContext.WriteLine("Starting SPD Export Job."); _logger.LogError("Starting SPD Export Job."); Type type = typeof(MicrosoftDynamicsCRMadoxioSpddatarow); var csvList = new List <List <string> >(); var headers = new List <string>(); var headerDefinition = GetExportHeadersWorker(); headerDefinition.ForEach(h => { headers.Add($"\"{h.Value}\""); }); csvList.Add(headers); string filter = $"adoxio_isexport eq true and adoxio_exporteddate eq null"; List <MicrosoftDynamicsCRMadoxioSpddatarow> result = null; try { result = _dynamics.Spddatarows.Get(filter: filter).Value.ToList(); } catch (OdataerrorException odee) { hangfireContext.WriteLine("Error getting SPD data rows"); hangfireContext.WriteLine("Request:"); hangfireContext.WriteLine(odee.Request.Content); hangfireContext.WriteLine("Response:"); hangfireContext.WriteLine(odee.Response.Content); _logger.LogError("Error getting SPD data rows"); _logger.LogError("Request:"); _logger.LogError(odee.Request.Content); _logger.LogError("Response:"); _logger.LogError(odee.Response.Content); // fail if we can't get results. throw (odee); } var batch = GetBatchNumber().ToString(); Dictionary <string, string> countryCodeMap = GetCountryCodeMap(); Dictionary <string, string> provinceMap = GetProviceCodeMap(); batch = AddZeroPadding(batch); if (result != null && result.Count > 0) { foreach (var row in result) { var item = new List <string>(); foreach (var header in headerDefinition) { string newValue = "\"\""; try { string value = row[header.Key]?.ToString(); if (value != null) { // replace country code with the country name if (header.Key.ToLower().Contains("country") && countryCodeMap.ContainsKey(value.ToUpper())) { value = countryCodeMap[value?.ToUpper()]; } // replace province code with the province name if (header.Key.ToLower().Contains("provstate") && provinceMap.ContainsKey(value.ToUpper())) { value = provinceMap[value.ToUpper()]; } // Figaro can't parse TRUE / FALSE; Convert to YES / NO. if (header.Key.ToLower().Contains("self-disclosure")) { if (row.AdoxioSelfdisclosure == true) { value = "YES"; } else { value = "NO"; } } newValue = $"\"{value.ToString()}\""; } } catch (Exception e) { _logger.LogError("Exception occured during SPD export."); _logger.LogError($"Field is {header.Key}"); _logger.LogError(e.Message); } item.Add(newValue); } csvList.Add(item); } var csv = new StringBuilder(); csvList.ForEach(row => { var line = String.Join(",", row); csv.AppendLine(line); }); var datePart = DateTime.Now.ToString("yyyyMMdd_HHmmss"); var attachmentName = $@"{batch}_Request_Worker_{datePart}.csv"; //File.WriteAllText($@".\{attachmentName}", csv.ToString()); if (SendSPDEmail(csv.ToString(), attachmentName)) { hangfireContext.WriteLine("Sent SPD email. Now updating Dynamics..."); _logger.LogError("Sent SPD email. Now updating Dynamics..."); //update exporteddate in dynamics var exportDate = DateTime.Now; result.ForEach(row => { var patchApplication = new MicrosoftDynamicsCRMadoxioSpddatarow() { AdoxioExporteddate = exportDate }; try { if (row.AdoxioSpddatarowid != null) // skip test data { _dynamics.Spddatarows.Update(row.AdoxioSpddatarowid, patchApplication); } } catch (OdataerrorException odee) { hangfireContext.WriteLine("Error updating application"); hangfireContext.WriteLine("Request:"); hangfireContext.WriteLine(odee.Request.Content); hangfireContext.WriteLine("Response:"); hangfireContext.WriteLine(odee.Response.Content); _logger.LogError("Error updating application"); _logger.LogError("Request:"); _logger.LogError(odee.Request.Content); _logger.LogError("Response:"); _logger.LogError(odee.Response.Content); // fail if we can't create. throw (odee); } }); hangfireContext.WriteLine("Dynamics update complete."); _logger.LogError("Dynamics update complete."); } else { hangfireContext.WriteLine("Error sending SPD email."); _logger.LogError("Error sending SPD email."); } } else { hangfireContext.WriteLine("No data to send, sending a null email."); _logger.LogError("No data to send, sending a null email."); SendSPDNoResultsEmail(batch); } hangfireContext.WriteLine("End of SPD Export Job."); _logger.LogError("End of SPD Export Job."); }
/// <summary> /// Hangfire job to send an export to SPD. /// </summary> public void SendExportJob(PerformContext hangfireContext) { hangfireContext.WriteLine("Starting SPD Export Job."); Type type = typeof(MicrosoftDynamicsCRMadoxioSpddatarow); var csvList = new List <List <string> >(); var headers = new List <string>(); var headerDefinition = GetExportHeadersWorker(); headerDefinition.ForEach(h => { headers.Add($"\"{h.Value}\""); }); csvList.Add(headers); string filter = $"adoxio_isexport eq true and adoxio_exporteddate eq null"; List <MicrosoftDynamicsCRMadoxioSpddatarow> result = null; try { result = _dynamics.Spddatarows.Get(filter: filter).Value.ToList(); } catch (OdataerrorException odee) { hangfireContext.WriteLine("Error getting SPD data rows"); hangfireContext.WriteLine("Request:"); hangfireContext.WriteLine(odee.Request.Content); hangfireContext.WriteLine("Response:"); hangfireContext.WriteLine(odee.Response.Content); // fail if we can't get results. throw (odee); } var batch = GetBatchNumber().ToString(); batch = AddZeroPadding(batch); if (result != null && result.Count > 0) { foreach (var row in result) { var item = new List <string>(); foreach (var h in headerDefinition) { try { object value = row[h.Key]; if (value != null) { item.Add($"\"{value.ToString()}\""); } else { item.Add("\"\""); } } catch (Exception) { item.Add("\"\"");; } } csvList.Add(item); } var csv = new StringBuilder(); csvList.ForEach(row => { var line = String.Join(",", row); csv.AppendLine(line); }); var datePart = DateTime.Now.ToString("yyyyMMdd_HHmmss"); var attachmentName = $@"{batch}_Request_Worker_{datePart}.csv"; //File.WriteAllText($@".\{attachmentName}", csv.ToString()); if (SendSPDEmail(csv.ToString(), attachmentName)) { hangfireContext.WriteLine("Sent SPD email. Now updating Dynamics..."); //update exporteddate in dynamics var exportDate = DateTime.Now; result.ForEach(row => { var patchApplication = new MicrosoftDynamicsCRMadoxioSpddatarow() { AdoxioExporteddate = exportDate }; try { if (row.AdoxioSpddatarowid != null) // skip test data { _dynamics.Spddatarows.Update(row.AdoxioSpddatarowid, patchApplication); } } catch (OdataerrorException odee) { hangfireContext.WriteLine("Error updating application"); hangfireContext.WriteLine("Request:"); hangfireContext.WriteLine(odee.Request.Content); hangfireContext.WriteLine("Response:"); hangfireContext.WriteLine(odee.Response.Content); // fail if we can't create. throw (odee); } }); hangfireContext.WriteLine("Dynamics update complete."); } else { hangfireContext.WriteLine("Error sending SPD email."); } } else { hangfireContext.WriteLine("No data to send, sending a null email."); SendSPDNoResultsEmail(batch); } hangfireContext.WriteLine("End of SPD Export Job."); }