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