public async Task <IActionResult> GetInvoice(string id)
{
ViewModels.Invoice result = null;
// query the Dynamics system to get the invoice record.
if (string.IsNullOrEmpty(id))
{
return(new NotFoundResult());
}
else
{
// get the current user.
string temp = _httpContextAccessor.HttpContext.Session.GetString("UserSettings");
UserSettings userSettings = JsonConvert.DeserializeObject <UserSettings>(temp);
Guid adoxio_legalentityid = new Guid(id);
MicrosoftDynamicsCRMinvoice invoice = await _dynamicsClient.GetInvoiceById(adoxio_legalentityid);
if (invoice == null)
{
return(new NotFoundResult());
}
// setup the related account.
if (invoice._accountidValue != null)
{
Guid accountId = Guid.Parse(invoice._accountidValue);
invoice.CustomeridAccount = await _dynamicsClient.GetAccountById(accountId);
}
result = invoice.ToViewModel();
}
return(Json(result));
}
public async Task <IActionResult> UpdateInvoice([FromBody] ViewModels.Invoice item, string id)
{
if (id != item.id)
{
return(BadRequest());
}
// get the invoice.
Guid adoxio_legalentityid = new Guid(id);
MicrosoftDynamicsCRMinvoice invoice = await _dynamicsClient.GetInvoiceById(adoxio_legalentityid);
if (invoice == null)
{
return(new NotFoundResult());
}
// we are doing a patch, so wipe out the record.
invoice = new MicrosoftDynamicsCRMinvoice();
// copy values over from the data provided
invoice.CopyValues(item);
await _dynamicsClient.Invoices.UpdateAsync(adoxio_legalentityid.ToString(), invoice);
return(Json(invoice.ToViewModel()));
}
public async Task <IActionResult> GetInvoice(string id)
{
if (TestUtility.InUnitTestMode())
{
ViewModels.Invoice result = null;
// query the Dynamics system to get the invoice record.
if (string.IsNullOrEmpty(id))
{
return(new NotFoundResult());
}
// get the current user.
UserSettings userSettings = UserSettings.CreateFromHttpContext(_httpContextAccessor);
Guid adoxio_legalentityid = new Guid(id);
MicrosoftDynamicsCRMinvoice invoice = await _dynamicsClient.GetInvoiceById(adoxio_legalentityid);
if (invoice == null)
{
return(new NotFoundResult());
}
// setup the related account.
if (invoice._accountidValue != null)
{
Guid accountId = Guid.Parse(invoice._accountidValue);
invoice.CustomeridAccount = await _dynamicsClient.GetAccountByIdAsync(accountId);
}
result = invoice.ToViewModel();
return(new JsonResult(result));
}
return(new NotFoundResult());
}
public async Task <IActionResult> CreateInvoice([FromBody] ViewModels.Invoice item)
{
if (TestUtility.InUnitTestMode())
{
// create a new invoice.
MicrosoftDynamicsCRMinvoice invoice = new MicrosoftDynamicsCRMinvoice();
// get the current user.
string temp = _httpContextAccessor.HttpContext.Session.GetString("UserSettings");
UserSettings userSettings = JsonConvert.DeserializeObject <UserSettings>(temp);
// check that the session is setup correctly.
userSettings.Validate();
// copy received values to Dynamics LegalEntity
invoice.CopyValues(item);
try
{
invoice = await _dynamicsClient.Invoices.CreateAsync(invoice);
}
catch (OdataerrorException odee)
{
_logger.LogError("Error creating invoice");
_logger.LogError("Request:");
_logger.LogError(odee.Request.Content);
_logger.LogError("Response:");
_logger.LogError(odee.Response.Content);
throw new Exception("Unable to create invoice");
}
// setup navigation properties.
MicrosoftDynamicsCRMinvoice patchEntity = new MicrosoftDynamicsCRMinvoice();
Guid accountId = Guid.Parse(userSettings.AccountId);
var userAccount = await _dynamicsClient.GetAccountById(accountId);
patchEntity.CustomerIdAccountODataBind = _dynamicsClient.GetEntityURI("accounts", accountId.ToString());
// patch the record.
try
{
await _dynamicsClient.Invoices.UpdateAsync(invoice.Invoiceid, patchEntity);
// setup the view model.
invoice.CustomeridAccount = userAccount;
}
catch (OdataerrorException odee)
{
_logger.LogError("Error patching invoice");
_logger.LogError(odee.Request.RequestUri.ToString());
_logger.LogError("Request:");
_logger.LogError(odee.Request.Content);
_logger.LogError("Response:");
_logger.LogError(odee.Response.Content);
}
return(Json(invoice.ToViewModel()));
}
return(new NotFoundResult());
}
public async Task <IActionResult> CreateInvoice([FromBody] ViewModels.Invoice item)
{
if (TestUtility.InUnitTestMode())
{
// create a new invoice.
MicrosoftDynamicsCRMinvoice invoice = new MicrosoftDynamicsCRMinvoice();
// get the current user.
UserSettings userSettings = UserSettings.CreateFromHttpContext(_httpContextAccessor);
// check that the session is setup correctly.
userSettings.Validate();
// copy received values to Dynamics LegalEntity
invoice.CopyValues(item);
try
{
invoice = await _dynamicsClient.Invoices.CreateAsync(invoice);
}
catch (HttpOperationException httpOperationException)
{
_logger.LogError(httpOperationException, "Error creating invoice");
throw new Exception("Unable to create invoice");
}
// setup navigation properties.
MicrosoftDynamicsCRMinvoice patchEntity = new MicrosoftDynamicsCRMinvoice();
Guid accountId = Guid.Parse(userSettings.AccountId);
var userAccount = await _dynamicsClient.GetAccountByIdAsync(accountId);
patchEntity.CustomerIdAccountODataBind = _dynamicsClient.GetEntityURI("accounts", accountId.ToString());
// patch the record.
try
{
await _dynamicsClient.Invoices.UpdateAsync(invoice.Invoiceid, patchEntity);
// setup the view model.
invoice.CustomeridAccount = userAccount;
}
catch (HttpOperationException httpOperationException)
{
_logger.LogError(httpOperationException, "Error patching invoice");
}
return(new JsonResult(invoice.ToViewModel()));
}
return(new NotFoundResult());
}
public async Task <IActionResult> VerifyWorkerPaymentStatus(string workerId)
{
MicrosoftDynamicsCRMadoxioWorker worker = await GetDynamicsWorker(workerId);
if (worker == null)
{
return(NotFound());
}
// load the invoice for this application
string invoiceId = worker._adoxioInvoiceValue;
_logger.LogError("Found invoice for application = " + invoiceId);
MicrosoftDynamicsCRMinvoice invoice = await _dynamicsClient.GetInvoiceById(Guid.Parse(invoiceId));
var ordernum = invoice.AdoxioTransactionid;
var orderamt = invoice.Totalamount;
var response = await _bcep.ProcessPaymentResponse(ordernum, workerId);
response["invoice"] = invoice.Invoicenumber;
foreach (var key in response.Keys)
{
_logger.LogError(">>>>>" + key + ":" + response[key]);
}
/*
* - if the invoice status is not "New", skip
* - we will update the Invoice status to "Complete" (if paid) or "Cancelled" (if payment was rejected)
* - if payment is successful, we will also set the Application "Payment Received" to "Y" and "Method" to "Credit Card"
*/
if (invoice.Statecode == (int?)Adoxio_invoicestates.New || invoice.Statecode == null)
{
_logger.LogError("Processing invoice with status New");
ViewModels.Invoice vmi = invoice.ToViewModel();
MicrosoftDynamicsCRMinvoice invoice2 = new MicrosoftDynamicsCRMinvoice();
invoice2.CopyValues(vmi);
ViewModels.Worker workerVM = worker.ToViewModel();
var patchWorker = new MicrosoftDynamicsCRMadoxioWorker();
patchWorker.CopyValues(workerVM);
// if payment was successful:
var pay_status = response["trnApproved"];
if (pay_status == "1")
{
_logger.LogError("Transaction approved");
// set invoice status to Complete
invoice2.Statecode = (int?)Adoxio_invoicestates.Paid;
invoice2.Statuscode = (int?)Adoxio_invoicestatuses.Paid;
invoice2.AdoxioReturnedtransactionid = response["trnId"];
_dynamicsClient.Invoices.Update(invoice2.Invoiceid, invoice2);
// set the Application payment status
patchWorker.AdoxioPaymentreceived = 1;
patchWorker.AdoxioPaymentreceiveddate = DateTime.UtcNow;
//patchWorker.AdoxioPaymentmethod = (int?)Adoxio_paymentmethods.CC;
//patchWorker.AdoxioAppchecklistpaymentreceived = (int?)ViewModels.GeneralYesNo.Yes;
_dynamicsClient.Workers.Update(workerId, patchWorker);
patchWorker = await GetDynamicsWorker(workerId);
}
// if payment failed:
else
{
_logger.LogError("Transaction NOT approved");
// set invoice status to Cancelled
invoice2.Statecode = (int?)Adoxio_invoicestates.Cancelled;
invoice2.Statuscode = (int?)Adoxio_invoicestatuses.Cancelled;
_dynamicsClient.Invoices.Update(invoice2.Invoiceid, invoice2);
// set the Application invoice status back to No
patchWorker.AdoxioInvoicetrigger = (int?)ViewModels.GeneralYesNo.No;
// don't clear the invoice, leave the previous "Cancelled" so we can report status
//adoxioApplication2._adoxioInvoiceValue = null;
//adoxioApplication2.AdoxioInvoice = null;
_dynamicsClient.Workers.Update(workerId, patchWorker);
patchWorker = await GetDynamicsWorker(workerId);
}
}
else
{
// that can happen if we are re-validating a completed invoice (paid or cancelled)
_logger.LogError("Invoice status is not New, skipping updates ...");
}
return(Json(response));
}