/// <summary> /// Update entity in adoxio_cannabisproductadmins /// </summary> /// <param name='adoxioCannabisproductadminid'> /// key: adoxio_cannabisproductadminid of adoxio_cannabisproductadmin /// </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 adoxioCannabisproductadminid, MicrosoftDynamicsCRMadoxioCannabisproductadmin body, Dictionary <string, List <string> > customHeaders = null, CancellationToken cancellationToken = default(CancellationToken)) { if (adoxioCannabisproductadminid == null) { throw new ValidationException(ValidationRules.CannotBeNull, "adoxioCannabisproductadminid"); } 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("adoxioCannabisproductadminid", adoxioCannabisproductadminid); 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_cannabisproductadmins({adoxio_cannabisproductadminid})").ToString(); _url = _url.Replace("{adoxio_cannabisproductadminid}", System.Uri.EscapeDataString(adoxioCannabisproductadminid)); // 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); }
public static MonthlyReport ToViewModel(this MicrosoftDynamicsCRMadoxioCannabismonthlyreport dynamicsMonthlyReport, IDynamicsClient dynamicsClient) { if (dynamicsMonthlyReport == null) { return(null); } MonthlyReport monthlyReportVM = new MonthlyReport() { licenseId = dynamicsMonthlyReport._adoxioLicenceidValue, licenseNumber = dynamicsMonthlyReport.AdoxioLicencenumber, reportingPeriodMonth = dynamicsMonthlyReport.AdoxioReportingperiodmonth, reportingPeriodYear = dynamicsMonthlyReport.AdoxioReportingperiodyear, statusCode = dynamicsMonthlyReport.Statuscode, employeesManagement = dynamicsMonthlyReport.AdoxioEmployeesmanagement, employeesAdministrative = dynamicsMonthlyReport.AdoxioEmployeesadministrative, employeesSales = dynamicsMonthlyReport.AdoxioEmployeessales, employeesProduction = dynamicsMonthlyReport.AdoxioEmployeesproduction, employeesOther = dynamicsMonthlyReport.AdoxioEmployeesother, inventorySalesReports = new List <InventorySalesReport>() }; monthlyReportVM.monthlyReportId = dynamicsMonthlyReport.AdoxioCannabismonthlyreportid; // fetch the establishment and get name and address Guid?adoxioEstablishmentId = null; if (!string.IsNullOrEmpty(dynamicsMonthlyReport._adoxioEstablishmentidValue)) { adoxioEstablishmentId = Guid.Parse(dynamicsMonthlyReport._adoxioEstablishmentidValue); } if (adoxioEstablishmentId != null) { var establishment = dynamicsClient.Establishments.GetByKey(adoxioEstablishmentId.ToString()); monthlyReportVM.establishmentName = establishment.AdoxioName; monthlyReportVM.establishmentAddressCity = establishment.AdoxioAddresscity; monthlyReportVM.establishmentAddressPostalCode = establishment.AdoxioAddresspostalcode; } IEnumerable <MicrosoftDynamicsCRMadoxioCannabisinventoryreport> inventoryReports = dynamicsClient.GetInventoryReportsForMonthlyReport(dynamicsMonthlyReport.AdoxioCannabismonthlyreportid); foreach (var inventoryReport in inventoryReports) { MicrosoftDynamicsCRMadoxioCannabisproductadmin product = dynamicsClient.Cannabisproductadmins.GetByKey(inventoryReport._adoxioProductidValue); InventorySalesReport inv = new InventorySalesReport() { product = product.AdoxioName, ProductDescription = product.AdoxioDescription, ProductDisplayOrder = product.AdoxioDisplayorder, inventoryReportId = inventoryReport.AdoxioCannabisinventoryreportid, openingInventory = inventoryReport.AdoxioOpeninginventory, domesticAdditions = inventoryReport.AdoxioQtyreceiveddomestic, returnsAdditions = inventoryReport.AdoxioQtyreceivedreturns, otherAdditions = inventoryReport.AdoxioQtyreceivedother, domesticReductions = inventoryReport.AdoxioQtyshippeddomestic, returnsReductions = inventoryReport.AdoxioQtyshippedreturned, destroyedReductions = inventoryReport.AdoxioQtydestroyed, lostReductions = inventoryReport.AdoxioQtyloststolen, otherReductions = inventoryReport.AdoxioOtherreductions, closingNumber = inventoryReport.AdoxioClosinginventory, closingValue = (inventoryReport.AdoxioValueofclosinginventory != null) ? inventoryReport.AdoxioValueofclosinginventory.Value : 0, totalSalesToConsumerQty = Convert.ToInt32(inventoryReport.AdoxioPackagedunitsnumber), totalSalesToConsumerValue = (inventoryReport.AdoxioTotalvalue != null) ? inventoryReport.AdoxioTotalvalue.Value : 0, totalSalesToRetailerQty = Convert.ToInt32(inventoryReport.AdoxioPackagedunitsnumberretailer), totalSalesToRetailerValue = (inventoryReport.AdoxioTotalvalueretailer != null) ? inventoryReport.AdoxioTotalvalueretailer.Value : 0 }; if (product.AdoxioName != "Seeds" && product.AdoxioName != "Vegetative Cannabis") { inv.closingWeight = (inventoryReport.AdoxioWeightofclosinginventory != null) ? inventoryReport.AdoxioWeightofclosinginventory.Value : 0; } if (product.AdoxioName == "Seeds") { inv.totalSeeds = inventoryReport.AdoxioTotalnumberseeds; } monthlyReportVM.inventorySalesReports.Add(inv); } return(monthlyReportVM); }
public void PopulateProduct(MicrosoftDynamicsCRMadoxioCannabisinventoryreport inventoryReport, MicrosoftDynamicsCRMadoxioCannabisproductadmin product) { switch (product.AdoxioName) { case "Seeds": SeedsPackagedOpeningInventory = inventoryReport.AdoxioOpeninginventory ?? 0; SeedsPackagedAdditionsReceivedDomestic = inventoryReport.AdoxioQtyreceiveddomestic ?? 0; SeedsPackagedAdditionsReceivedReturned = inventoryReport.AdoxioQtyreceivedreturns ?? 0; SeedsPackagedAdditionsOther = inventoryReport.AdoxioQtyreceivedother ?? 0; SeedsPackagedReductionsShippedDomestic = inventoryReport.AdoxioQtyshippeddomestic ?? 0; SeedsPackagedReductionsShippedReturned = inventoryReport.AdoxioQtyshippedreturned ?? 0; SeedsPackagedReductionsDestroyed = inventoryReport.AdoxioQtydestroyed ?? 0; SeedsPackagedReductionsLostStolen = inventoryReport.AdoxioQtyloststolen ?? 0; SeedsPackagedReductionsOther = inventoryReport.AdoxioOtherreductions ?? 0; SeedsPackagedClosingInventoryTotal = inventoryReport.AdoxioClosinginventory ?? 0; SeedsPackagedClosingInventoryTotalValue = inventoryReport.AdoxioValueofclosinginventory != null ? (double)inventoryReport.AdoxioValueofclosinginventory : 0; SeedsPackagedClosingTotalSeeds = inventoryReport.AdoxioTotalnumberseeds ?? 0; BCSeedsPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; BCSeedsTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; SeedsPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; SeedsTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; break; case "Vegetative Cannabis": VegetativeCannabisPackagedOpeningInventory = inventoryReport.AdoxioOpeninginventory ?? 0; VegetativeCannabisPackagedAdditionsReceivedDomestic = inventoryReport.AdoxioQtyreceiveddomestic ?? 0; VegetativeCannabisPackagedAdditionsReceivedReturned = inventoryReport.AdoxioQtyreceivedreturns ?? 0; VegetativeCannabisPackagedAdditionsOther = inventoryReport.AdoxioQtyreceivedother ?? 0; VegetativeCannabisPackagedReductionsShippedDomestic = inventoryReport.AdoxioQtyshippeddomestic ?? 0; VegetativeCannabisPackagedReductionsShippedReturned = inventoryReport.AdoxioQtyshippedreturned ?? 0; VegetativeCannabisPackagedReductionsDestroyed = inventoryReport.AdoxioQtydestroyed ?? 0; VegetativeCannabisPackagedReductionsLostStolen = inventoryReport.AdoxioQtyloststolen ?? 0; VegetativeCannabisPackagedReductionsOther = inventoryReport.AdoxioOtherreductions ?? 0; VegetativeCannabisPackagedClosingInventoryTotal = inventoryReport.AdoxioClosinginventory ?? 0; VegetativeCannabisPackagedClosingInventoryTotalValue = inventoryReport.AdoxioValueofclosinginventory != null ? (double)inventoryReport.AdoxioValueofclosinginventory : 0; BCVegetativeCannabisPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; BCVegetativeCannabisTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; VegetativeCannabisPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; VegetativeCannabisTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; break; case "Fresh Cannabis": FreshCannabisPackagedOpeningInventory = inventoryReport.AdoxioOpeninginventory ?? 0; FreshCannabisPackagedAdditionsReceivedDomestic = inventoryReport.AdoxioQtyreceiveddomestic ?? 0; FreshCannabisPackagedAdditionsReceivedReturned = inventoryReport.AdoxioQtyreceivedreturns ?? 0; FreshCannabisPackagedAdditionsOther = inventoryReport.AdoxioQtyreceivedother ?? 0; FreshCannabisPackagedReductionsShippedDomestic = inventoryReport.AdoxioQtyshippeddomestic ?? 0; FreshCannabisPackagedReductionsShippedReturned = inventoryReport.AdoxioQtyshippedreturned ?? 0; FreshCannabisPackagedReductionsDestroyed = inventoryReport.AdoxioQtydestroyed ?? 0; FreshCannabisPackagedReductionsLostStolen = inventoryReport.AdoxioQtyloststolen ?? 0; FreshCannabisPackagedReductionsOther = inventoryReport.AdoxioOtherreductions ?? 0; FreshCannabisPackagedClosingInventory = inventoryReport.AdoxioClosinginventory ?? 0; FreshCannabisPackagedClosingInventoryValue = inventoryReport.AdoxioValueofclosinginventory != null ? (double)inventoryReport.AdoxioValueofclosinginventory : 0; FreshCannabisPackagedClosingInventoryWeight = inventoryReport.AdoxioWeightofclosinginventory != null ? (double)inventoryReport.AdoxioWeightofclosinginventory : 0; BCFreshCannabisPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; BCFreshCannabisTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; FreshCannabisPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; FreshCannabisTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; break; case "Dried Cannabis": DriedCannabisPackagedOpeningInventory = inventoryReport.AdoxioOpeninginventory ?? 0; DriedCannabisPackagedAdditionsReceivedDomestic = inventoryReport.AdoxioQtyreceiveddomestic ?? 0; DriedCannabisPackagedAdditionsReceivedReturned = inventoryReport.AdoxioQtyreceivedreturns ?? 0; DriedCannabisPackagedAdditionsOther = inventoryReport.AdoxioQtyreceivedother ?? 0; DriedCannabisPackagedReductionsShippedDomestic = inventoryReport.AdoxioQtyshippeddomestic ?? 0; DriedCannabisPackagedReductionsShippedReturned = inventoryReport.AdoxioQtyshippedreturned ?? 0; DriedCannabisPackagedReductionsDestroyed = inventoryReport.AdoxioQtydestroyed ?? 0; DriedCannabisPackagedReductionsLostStolen = inventoryReport.AdoxioQtyloststolen ?? 0; DriedCannabisPackagedReductionsOther = inventoryReport.AdoxioOtherreductions ?? 0; DriedCannabisPackagedClosingInventory = inventoryReport.AdoxioClosinginventory ?? 0; DriedCannabisPackagedClosingInventoryValue = inventoryReport.AdoxioValueofclosinginventory != null ? (double)inventoryReport.AdoxioValueofclosinginventory : 0; DriedCannabisPackagedClosingInventoryWeight = inventoryReport.AdoxioWeightofclosinginventory != null ? (double)inventoryReport.AdoxioWeightofclosinginventory : 0; BCDriedCannabisPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; BCDriedCannabisTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; DriedCannabisPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; DriedCannabisTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; break; case "Edibles - Solids": SolidEdiblesPackagedOpeningInventory = inventoryReport.AdoxioOpeninginventory ?? 0; SolidEdiblesPackagedAdditionsReceivedDomestic = inventoryReport.AdoxioQtyreceiveddomestic ?? 0; SolidEdiblesPackagedAdditionsReceivedReturned = inventoryReport.AdoxioQtyreceivedreturns ?? 0; SolidEdiblesPackagedAdditionsOther = inventoryReport.AdoxioQtyreceivedother ?? 0; SolidEdiblesPackagedReductionsShippedDomestic = inventoryReport.AdoxioQtyshippeddomestic ?? 0; SolidEdiblesPackagedReductionsShippedReturned = inventoryReport.AdoxioQtyshippedreturned ?? 0; SolidEdiblesPackagedReductionsDestroyed = inventoryReport.AdoxioQtydestroyed ?? 0; SolidEdiblesPackagedReductionsLostStolen = inventoryReport.AdoxioQtyloststolen ?? 0; SolidEdiblesPackagedReductionsOther = inventoryReport.AdoxioOtherreductions ?? 0; SolidEdiblesPackagedClosingInventory = inventoryReport.AdoxioClosinginventory ?? 0; SolidEdiblesPackagedClosingInventoryValue = inventoryReport.AdoxioValueofclosinginventory != null ? (double)inventoryReport.AdoxioValueofclosinginventory : 0; SolidEdiblesPackagedClosingInventoryWeight = inventoryReport.AdoxioWeightofclosinginventory != null ? (double)inventoryReport.AdoxioWeightofclosinginventory : 0; BCSolidEdiblesPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; BCSolidEdiblesTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; SolidEdiblesPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; SolidEdiblesTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; break; case "Edibles - Non-Solids": NonSolidEdiblesPackagedOpeningInventory = inventoryReport.AdoxioOpeninginventory ?? 0; NonSolidEdiblesPackagedAdditionsReceivedDomestic = inventoryReport.AdoxioQtyreceiveddomestic ?? 0; NonSolidEdiblesPackagedAdditionsReceivedReturned = inventoryReport.AdoxioQtyreceivedreturns ?? 0; NonSolidEdiblesPackagedAdditionsOther = inventoryReport.AdoxioQtyreceivedother ?? 0; NonSolidEdiblesPackagedReductionsShippedDomestic = inventoryReport.AdoxioQtyshippeddomestic ?? 0; NonSolidEdiblesPackagedReductionsShippedReturned = inventoryReport.AdoxioQtyshippedreturned ?? 0; NonSolidEdiblesPackagedReductionsDestroyed = inventoryReport.AdoxioQtydestroyed ?? 0; NonSolidEdiblesPackagedReductionsLostStolen = inventoryReport.AdoxioQtyloststolen ?? 0; NonSolidEdiblesPackagedReductionsOther = inventoryReport.AdoxioOtherreductions ?? 0; NonSolidEdiblesPackagedClosingInventory = inventoryReport.AdoxioClosinginventory ?? 0; NonSolidEdiblesPackagedClosingInventoryValue = inventoryReport.AdoxioValueofclosinginventory != null ? (double)inventoryReport.AdoxioValueofclosinginventory : 0; NonSolidEdiblesPackagedClosingInventoryWeight = inventoryReport.AdoxioWeightofclosinginventory != null ? (double)inventoryReport.AdoxioWeightofclosinginventory : 0; BCNonSolidEdiblesPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; BCNonSolidEdiblesTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; NonSolidEdiblesPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; NonSolidEdiblesTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; break; case "Extracts - Inhaled": InhaledExtractsPackagedOpeningInventory = inventoryReport.AdoxioOpeninginventory ?? 0; InhaledExtractsPackagedAdditionsReceivedDomestic = inventoryReport.AdoxioQtyreceiveddomestic ?? 0; InhaledExtractsPackagedAdditionsReceivedReturned = inventoryReport.AdoxioQtyreceivedreturns ?? 0; InhaledExtractsPackagedAdditionsOther = inventoryReport.AdoxioQtyreceivedother ?? 0; InhaledExtractsPackagedReductionsShippedDomestic = inventoryReport.AdoxioQtyshippeddomestic ?? 0; InhaledExtractsPackagedReductionsShippedReturned = inventoryReport.AdoxioQtyshippedreturned ?? 0; InhaledExtractsPackagedReductionsDestroyed = inventoryReport.AdoxioQtydestroyed ?? 0; InhaledExtractsPackagedReductionsLostStolen = inventoryReport.AdoxioQtyloststolen ?? 0; InhaledExtractsPackagedReductionsOther = inventoryReport.AdoxioOtherreductions ?? 0; InhaledExtractsPackagedClosingInventory = inventoryReport.AdoxioClosinginventory ?? 0; InhaledExtractsPackagedClosingInventoryValue = inventoryReport.AdoxioValueofclosinginventory != null ? (double)inventoryReport.AdoxioValueofclosinginventory : 0; InhaledExtractsPackagedClosingInventoryWeight = inventoryReport.AdoxioWeightofclosinginventory != null ? (double)inventoryReport.AdoxioWeightofclosinginventory : 0; BCInhaledExtractsPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; BCInhaledExtractsTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; InhaledExtractsPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; InhaledExtractsTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; break; case "Extracts - Ingested": IngestedExtractsPackagedOpeningInventory = inventoryReport.AdoxioOpeninginventory ?? 0; IngestedExtractsPackagedAdditionsReceivedDomestic = inventoryReport.AdoxioQtyreceiveddomestic ?? 0; IngestedExtractsPackagedAdditionsReceivedReturned = inventoryReport.AdoxioQtyreceivedreturns ?? 0; IngestedExtractsPackagedAdditionsOther = inventoryReport.AdoxioQtyreceivedother ?? 0; IngestedExtractsPackagedReductionsShippedDomestic = inventoryReport.AdoxioQtyshippeddomestic ?? 0; IngestedExtractsPackagedReductionsShippedReturned = inventoryReport.AdoxioQtyshippedreturned ?? 0; IngestedExtractsPackagedReductionsDestroyed = inventoryReport.AdoxioQtydestroyed ?? 0; IngestedExtractsPackagedReductionsLostStolen = inventoryReport.AdoxioQtyloststolen ?? 0; IngestedExtractsPackagedReductionsOther = inventoryReport.AdoxioOtherreductions ?? 0; IngestedExtractsPackagedClosingInventory = inventoryReport.AdoxioClosinginventory ?? 0; IngestedExtractsPackagedClosingInventoryValue = inventoryReport.AdoxioValueofclosinginventory != null ? (double)inventoryReport.AdoxioValueofclosinginventory : 0; IngestedExtractsPackagedClosingInventoryWeight = inventoryReport.AdoxioWeightofclosinginventory != null ? (double)inventoryReport.AdoxioWeightofclosinginventory : 0; BCIngestedExtractsPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; BCIngestedExtractsTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; IngestedExtractsPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; IngestedExtractsTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; break; case "Extracts - Other": OtherExtractsPackagedOpeningInventory = inventoryReport.AdoxioOpeninginventory ?? 0; OtherExtractsPackagedAdditionsReceivedDomestic = inventoryReport.AdoxioQtyreceiveddomestic ?? 0; OtherExtractsPackagedAdditionsReceivedReturned = inventoryReport.AdoxioQtyreceivedreturns ?? 0; OtherExtractsPackagedAdditionsOther = inventoryReport.AdoxioQtyreceivedother ?? 0; OtherExtractsPackagedReductionsShippedDomestic = inventoryReport.AdoxioQtyshippeddomestic ?? 0; OtherExtractsPackagedReductionsShippedReturned = inventoryReport.AdoxioQtyshippedreturned ?? 0; OtherExtractsPackagedReductionsDestroyed = inventoryReport.AdoxioQtydestroyed ?? 0; OtherExtractsPackagedReductionsLostStolen = inventoryReport.AdoxioQtyloststolen ?? 0; OtherExtractsPackagedReductionsOther = inventoryReport.AdoxioOtherreductions ?? 0; OtherExtractsPackagedClosingInventory = inventoryReport.AdoxioClosinginventory ?? 0; OtherExtractsPackagedClosingInventoryValue = inventoryReport.AdoxioValueofclosinginventory != null ? (double)inventoryReport.AdoxioValueofclosinginventory : 0; OtherExtractsPackagedClosingInventoryWeight = inventoryReport.AdoxioWeightofclosinginventory != null ? (double)inventoryReport.AdoxioWeightofclosinginventory : 0; BCOtherExtractsPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; BCOtherExtractsTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; OtherExtractsPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; OtherExtractsTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; break; case "Topicals": TopicalsPackagedOpeningInventory = inventoryReport.AdoxioOpeninginventory ?? 0; TopicalsPackagedAdditionsReceivedDomestic = inventoryReport.AdoxioQtyreceiveddomestic ?? 0; TopicalsPackagedAdditionsReceivedReturned = inventoryReport.AdoxioQtyreceivedreturns ?? 0; TopicalsPackagedAdditionsOther = inventoryReport.AdoxioQtyreceivedother ?? 0; TopicalsPackagedReductionsShippedDomestic = inventoryReport.AdoxioQtyshippeddomestic ?? 0; TopicalsPackagedReductionsShippedReturned = inventoryReport.AdoxioQtyshippedreturned ?? 0; TopicalsPackagedReductionsDestroyed = inventoryReport.AdoxioQtydestroyed ?? 0; TopicalsPackagedReductionsLostStolen = inventoryReport.AdoxioQtyloststolen ?? 0; TopicalsPackagedReductionsOther = inventoryReport.AdoxioOtherreductions ?? 0; TopicalsPackagedClosingInventory = inventoryReport.AdoxioClosinginventory ?? 0; TopicalsPackagedClosingInventoryValue = inventoryReport.AdoxioValueofclosinginventory != null ? (double)inventoryReport.AdoxioValueofclosinginventory : 0; TopicalsPackagedClosingInventoryWeight = inventoryReport.AdoxioWeightofclosinginventory != null ? (double)inventoryReport.AdoxioWeightofclosinginventory : 0; BCTopicalsPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; BCTopicalsTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; TopicalsPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; TopicalsTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; break; case "Other": OtherPackagedOpeningInventory = inventoryReport.AdoxioOpeninginventory ?? 0; OtherPackagedAdditionsReceivedDomestic = inventoryReport.AdoxioQtyreceiveddomestic ?? 0; OtherPackagedAdditionsReceivedReturned = inventoryReport.AdoxioQtyreceivedreturns ?? 0; OtherPackagedAdditionsOther = inventoryReport.AdoxioQtyreceivedother ?? 0; OtherPackagedReductionsShippedDomestic = inventoryReport.AdoxioQtyshippeddomestic ?? 0; OtherPackagedReductionsShippedReturned = inventoryReport.AdoxioQtyshippedreturned ?? 0; OtherPackagedReductionsDestroyed = inventoryReport.AdoxioQtydestroyed ?? 0; OtherPackagedReductionsLostStolen = inventoryReport.AdoxioQtyloststolen ?? 0; OtherPackagedReductionsOther = inventoryReport.AdoxioOtherreductions ?? 0; OtherPackagedClosingInventory = inventoryReport.AdoxioClosinginventory ?? 0; OtherPackagedClosingInventoryValue = inventoryReport.AdoxioValueofclosinginventory != null ? (double)inventoryReport.AdoxioValueofclosinginventory : 0; OtherPackagedClosingInventoryWeight = inventoryReport.AdoxioWeightofclosinginventory != null ? (double)inventoryReport.AdoxioWeightofclosinginventory : 0; BCOtherPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; BCOtherTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; OtherPackagedUnitsSold = inventoryReport.AdoxioPackagedunitsnumber != null ? (double)inventoryReport.AdoxioPackagedunitsnumber : 0; OtherTotalValueSold = inventoryReport.AdoxioTotalvalue != null ? (double)inventoryReport.AdoxioTotalvalue : 0; break; } }
/// <summary> /// Generate a csv with the federal tracking report for a given reporting period /// </summary> /// <returns></returns> public async Task GenerateFederalTrackingReport(PerformContext hangfireContext) { try { MicrosoftDynamicsCRMadoxioCannabismonthlyreport previousReport = _dynamicsClient.Cannabismonthlyreports.Get(top: 1, orderby: new List <string> { "adoxio_csvexportid desc" }).Value.FirstOrDefault(); int currentExportId = (previousReport != null && previousReport.AdoxioCsvexportid != null) ? (int)previousReport.AdoxioCsvexportid + 1 : 1; // Submitted reports string filter = $"statuscode eq {(int)MonthlyReportStatus.Submitted}"; var dynamicsMonthlyReports = _dynamicsClient.Cannabismonthlyreports.Get(filter: filter); List <FederalReportingMonthlyExport> monthlyReports = new List <FederalReportingMonthlyExport>(); foreach (MicrosoftDynamicsCRMadoxioCannabismonthlyreport report in dynamicsMonthlyReports.Value) { FederalReportingMonthlyExport export = new FederalReportingMonthlyExport() { ReportingPeriodMonth = report.AdoxioReportingperiodmonth, ReportingPeriodYear = report.AdoxioReportingperiodyear, RetailerDistributor = report.AdoxioRetailerdistributor?.ToString() ?? "1", CompanyName = report.AdoxioEstablishmentnametext, SiteID = report.AdoxioSiteidnumber, City = report.AdoxioCity, PostalCode = report.AdoxioPostalcode, ManagementEmployees = report.AdoxioEmployeesmanagement ?? 0, AdministrativeEmployees = report.AdoxioEmployeesadministrative ?? 0, SalesEmployees = report.AdoxioEmployeessales ?? 0, ProductionEmployees = report.AdoxioEmployeesproduction ?? 0, OtherEmployees = report.AdoxioEmployeesother ?? 0 }; filter = $"_adoxio_monthlyreportid_value eq {report.AdoxioCannabismonthlyreportid}"; var invResp = _dynamicsClient.Cannabisinventoryreports.Get(filter: filter); foreach (MicrosoftDynamicsCRMadoxioCannabisinventoryreport inventoryReport in invResp.Value) { MicrosoftDynamicsCRMadoxioCannabisproductadmin product = _dynamicsClient.Cannabisproductadmins.GetByKey(inventoryReport._adoxioProductidValue); export.PopulateProduct(inventoryReport, product); } monthlyReports.Add(export); MicrosoftDynamicsCRMadoxioCannabismonthlyreport patchRecord = new MicrosoftDynamicsCRMadoxioCannabismonthlyreport() { AdoxioCsvexportdate = DateTime.UtcNow, AdoxioCsvexportid = currentExportId, Statuscode = (int)MonthlyReportStatus.Closed }; _dynamicsClient.Cannabismonthlyreports.Update(report.AdoxioCannabismonthlyreportid, patchRecord); } hangfireContext.WriteLine($"Found {monthlyReports.Count} monthly reports to export."); _logger.LogInformation($"Found {monthlyReports.Count} monthly reports to export."); if (monthlyReports.Count > 0) { string filePath = ""; using (var mem = new MemoryStream()) using (var writer = new StreamWriter(mem)) using (var csv = new CsvWriter(writer)) { csv.Configuration.RegisterClassMap <FederalReportingMonthlyExportMap>(); csv.WriteRecords(monthlyReports); writer.Flush(); mem.Position = 0; string filename = $"{currentExportId.ToString("0000")}_{DateTime.Now.ToString("yyy-MM-dd")}-CannabisTrackingReport.csv"; string sharepointFilename = await _sharepoint.UploadFile(filename, DOCUMENT_LIBRARY, "", mem, "text/csv"); string url = _sharepoint.GetServerRelativeURL(DOCUMENT_LIBRARY, ""); } hangfireContext.WriteLine($"Successfully exported Federal Reporting CSV {currentExportId}."); _logger.LogInformation($"Successfully exported Federal Reporting CSV {currentExportId}."); } } catch (HttpOperationException httpOperationException) { hangfireContext.WriteLine("Error creating federal tracking CSV"); _logger.LogError(httpOperationException, "Error creating federal tracking CSV"); } catch (SharePointRestException e) { hangfireContext.WriteLine("Error saving csv to sharepoint"); _logger.LogError(e, "Error saving csv to sharepoint"); } }
/// <summary> /// Update entity in adoxio_cannabisproductadmins /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='adoxioCannabisproductadminid'> /// key: adoxio_cannabisproductadminid of adoxio_cannabisproductadmin /// </param> /// <param name='body'> /// New property values /// </param> /// <param name='cancellationToken'> /// The cancellation token. /// </param> public static async Task UpdateAsync(this ICannabisproductadmins operations, string adoxioCannabisproductadminid, MicrosoftDynamicsCRMadoxioCannabisproductadmin body, CancellationToken cancellationToken = default(CancellationToken)) { (await operations.UpdateWithHttpMessagesAsync(adoxioCannabisproductadminid, body, null, cancellationToken).ConfigureAwait(false)).Dispose(); }
/// <summary> /// Update entity in adoxio_cannabisproductadmins /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='adoxioCannabisproductadminid'> /// key: adoxio_cannabisproductadminid of adoxio_cannabisproductadmin /// </param> /// <param name='body'> /// New property values /// </param> /// <param name='customHeaders'> /// Headers that will be added to request. /// </param> public static HttpOperationResponse UpdateWithHttpMessages(this ICannabisproductadmins operations, string adoxioCannabisproductadminid, MicrosoftDynamicsCRMadoxioCannabisproductadmin body, Dictionary <string, List <string> > customHeaders = null) { return(operations.UpdateWithHttpMessagesAsync(adoxioCannabisproductadminid, body, customHeaders, CancellationToken.None).ConfigureAwait(false).GetAwaiter().GetResult()); }
/// <summary> /// Update entity in adoxio_cannabisproductadmins /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='adoxioCannabisproductadminid'> /// key: adoxio_cannabisproductadminid of adoxio_cannabisproductadmin /// </param> /// <param name='body'> /// New property values /// </param> public static void Update(this ICannabisproductadmins operations, string adoxioCannabisproductadminid, MicrosoftDynamicsCRMadoxioCannabisproductadmin body) { operations.UpdateAsync(adoxioCannabisproductadminid, body).GetAwaiter().GetResult(); }
/// <summary> /// Add new entity to adoxio_cannabisproductadmins /// </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 <MicrosoftDynamicsCRMadoxioCannabisproductadmin> CreateWithHttpMessages(this ICannabisproductadmins operations, MicrosoftDynamicsCRMadoxioCannabisproductadmin body, string prefer = "return=representation", Dictionary <string, List <string> > customHeaders = null) { return(operations.CreateWithHttpMessagesAsync(body, prefer, customHeaders, CancellationToken.None).ConfigureAwait(false).GetAwaiter().GetResult()); }
/// <summary> /// Add new entity to adoxio_cannabisproductadmins /// </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 <MicrosoftDynamicsCRMadoxioCannabisproductadmin> CreateAsync(this ICannabisproductadmins operations, MicrosoftDynamicsCRMadoxioCannabisproductadmin 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> /// Add new entity to adoxio_cannabisproductadmins /// </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 MicrosoftDynamicsCRMadoxioCannabisproductadmin Create(this ICannabisproductadmins operations, MicrosoftDynamicsCRMadoxioCannabisproductadmin body, string prefer = "return=representation") { return(operations.CreateAsync(body, prefer).GetAwaiter().GetResult()); }
public async Task ExportFederalReports(PerformContext hangfireContext) { // Get any new exports that have been created string filter = "adoxio_exportcompleted eq null"; MicrosoftDynamicsCRMadoxioFederalreportexportCollection exports = _dynamicsClient.Federalreportexports.Get(filter: filter); if (exports.Value.Count > 0) { MicrosoftDynamicsCRMadoxioFederalreportexport export = exports.Value.FirstOrDefault(); string exportId = export.AdoxioFederalreportexportid; MicrosoftDynamicsCRMadoxioFederalreportexport patchExport = new MicrosoftDynamicsCRMadoxioFederalreportexport(); patchExport.AdoxioExporttriggered = DateTime.UtcNow; _dynamicsClient.Federalreportexports.Update(exportId, patchExport); try { // Gather submitted reports filter = $"statuscode eq {(int)MonthlyReportStatus.Submitted}"; var dynamicsMonthlyReports = _dynamicsClient.Cannabismonthlyreports.Get(filter: filter); List <FederalReportingMonthlyExport> monthlyReports = new List <FederalReportingMonthlyExport>(); hangfireContext.WriteLine($"Found {dynamicsMonthlyReports.Value.Count} monthly reports to export."); _logger.LogInformation($"Found {dynamicsMonthlyReports.Value.Count} monthly reports to export."); foreach (MicrosoftDynamicsCRMadoxioCannabismonthlyreport report in dynamicsMonthlyReports.Value) { FederalReportingMonthlyExport exportVM = new FederalReportingMonthlyExport() { ReportingPeriodMonth = report.AdoxioReportingperiodmonth, ReportingPeriodYear = report.AdoxioReportingperiodyear, RetailerDistributor = report.AdoxioRetailerdistributor?.ToString() ?? "1", CompanyName = report.AdoxioEstablishmentnametext, SiteID = report.AdoxioSiteidnumber, City = report.AdoxioCity, PostalCode = report.AdoxioPostalcode, ManagementEmployees = report.AdoxioEmployeesmanagement ?? 0, AdministrativeEmployees = report.AdoxioEmployeesadministrative ?? 0, SalesEmployees = report.AdoxioEmployeessales ?? 0, ProductionEmployees = report.AdoxioEmployeesproduction ?? 0, OtherEmployees = report.AdoxioEmployeesother ?? 0 }; // Get inventory reports for those submitted reports filter = $"_adoxio_monthlyreportid_value eq {report.AdoxioCannabismonthlyreportid}"; var invResp = _dynamicsClient.Cannabisinventoryreports.Get(filter: filter); foreach (MicrosoftDynamicsCRMadoxioCannabisinventoryreport inventoryReport in invResp.Value) { MicrosoftDynamicsCRMadoxioCannabisproductadmin product = _dynamicsClient.Cannabisproductadmins.GetByKey(inventoryReport._adoxioProductidValue); exportVM.PopulateProduct(inventoryReport, product); } monthlyReports.Add(exportVM); MicrosoftDynamicsCRMadoxioCannabismonthlyreport patchRecord = new MicrosoftDynamicsCRMadoxioCannabismonthlyreport() { AdoxioFederalReportExportIdODateBind = _dynamicsClient.GetEntityURI("adoxio_federalreportexports", exportId), Statuscode = (int)MonthlyReportStatus.Closed }; _dynamicsClient.Cannabismonthlyreports.Update(report.AdoxioCannabismonthlyreportid, patchRecord); } if (monthlyReports.Count > 0) { string filename = $"{export.AdoxioExportnumber}_{DateTime.Now.ToString("yyy-MM-dd")}-CannabisTrackingReport.csv"; Regex illegalInFileName = new Regex(@"[#%*<>?{}~¿""]"); filename = illegalInFileName.Replace(filename, ""); illegalInFileName = new Regex(@"[&:/\\|]"); filename = illegalInFileName.Replace(filename, "-"); using (var mem = new MemoryStream()) using (var writer = new StreamWriter(mem)) using (var csv = new CsvWriter(writer)) { csv.Configuration.RegisterClassMap <FederalReportingMonthlyExportMap>(); csv.WriteRecords(monthlyReports); writer.Flush(); mem.Position = 0; string folderName = null; MicrosoftDynamicsCRMsharepointdocumentlocation?documentLocation = null; if (export.AdoxioFederalreportexportSharePointDocumentLocations != null) { documentLocation = export.AdoxioFederalreportexportSharePointDocumentLocations.FirstOrDefault(); folderName = documentLocation.Relativeurl; } if (folderName == null) { folderName = export.GetDocumentFolderName(); await CreateFederalReportDocumentLocation(export, DOCUMENT_LIBRARY, folderName); } byte[] data = mem.ToArray(); //call the web service var uploadRequest = new Services.FileManager.UploadFileRequest() { ContentType = "text/csv", Data = ByteString.CopyFrom(data), EntityName = "federal_report", FileName = filename, FolderName = folderName }; bool folderResult = CreateFolder(folderName); if (folderResult) { var uploadResult = _fileManagerClient.UploadFile(uploadRequest); } else { hangfireContext.WriteLine($"Failed to create sharepoint folder for federal report."); _logger.LogInformation($"Failed to create sharepoint folder for federal report."); } } hangfireContext.WriteLine($"Successfully exported Federal Reporting CSV {export.AdoxioExportnumber}."); _logger.LogInformation($"Successfully exported Federal Reporting CSV {export.AdoxioExportnumber}."); } patchExport.AdoxioExportcompleted = DateTime.UtcNow; _dynamicsClient.Federalreportexports.Update(exportId, patchExport); } catch (HttpOperationException httpOperationException) { hangfireContext.WriteLine("Error creating federal tracking CSV"); _logger.LogError(httpOperationException, "Error creating federal tracking CSV"); } } }