/// <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.");
}
