private void PullTransactionsFromShopify(ShopifyOrder orderRecord)
{
var transactionsJson = _orderApi.RetrieveTransactions(orderRecord.ShopifyOrderId);
var transactions = transactionsJson.DeserializeFromJson <TransactionList>();
var order = _shopifyJsonService.RetrieveOrder(orderRecord.ShopifyOrderId);
foreach (var transaction in transactions.transactions)
{
var transactionRecord = _orderRepository.RetrieveTransaction(transaction.id);
if (transactionRecord != null)
{
transactionRecord.LastUpdated = DateTime.UtcNow;
_orderRepository.SaveChanges();
continue;
}
using (var dbTransaction = _orderRepository.BeginTransaction())
{
var record = new ShopifyTransaction();
if (transaction.kind == TransactionKind.Refund)
{
record.IsSyncableToPayment = true;
var refund = order.RefundByTransaction(transaction.id);
if (refund != null)
{
record.ShopifyRefundId = refund.id;
record.IsPureCancel = refund.IsPureCancel;
}
}
if (transaction.kind == TransactionKind.Capture || transaction.kind == TransactionKind.Sale)
{
record.IsSyncableToPayment = true;
}
record.ShopifyOrderId = transaction.order_id;
record.ShopifyTransactionId = transaction.id;
record.ShopifyStatus = transaction.status;
record.ShopifyKind = transaction.kind;
record.ShopifyGateway = transaction.gateway;
record.ShopifyAmount = transaction.amount;
record.ShopifyOrderMonsterId = orderRecord.MonsterId;
record.DateCreated = DateTime.UtcNow;
record.LastUpdated = DateTime.UtcNow;
_logService.Log(LogBuilder.DetectedNewShopifyTransaction(record));
_orderRepository.InsertTransaction(record);
_shopifyJsonService.Upsert(
ShopifyJsonType.Transaction, transaction.id, transaction.SerializeToJson());
dbTransaction.Commit();
}
}
orderRecord.NeedsTransactionGet = false;
_orderRepository.SaveChanges();
}
public ActionResult IgnoreOrder(long shopifyOrderId, bool ignore)
{
var order = _shopifyOrderRepository.RetrieveOrder(shopifyOrderId);
order.Ignore = ignore;
_shopifyOrderRepository.SaveChanges();
return(JsonNetResult.Success());
}
private void UpsertOrderAndCustomer(Order order)
{
var monsterCustomerRecord = _shopifyCustomerPull.UpsertCustomer(order.customer);
using (var transaction = _orderRepository.BeginTransaction())
{
var existingOrder = _orderRepository.RetrieveOrder(order.id);
if (existingOrder == null)
{
var newOrder = new ShopifyOrder();
newOrder.ShopifyOrderId = order.id;
newOrder.ShopifyOrderNumber = order.name;
newOrder.ShopifyTotalPrice = order.total_price;
newOrder.ShopifyFinancialStatus = order.financial_status;
newOrder.ShopifyFulfillmentStatus = order.fulfillment_status;
newOrder.ShopifyIsCancelled = order.IsCancelled;
newOrder.ShopifyAreAllItemsRefunded = order.AreAllLineItemsRefunded;
newOrder.ShopifyTotalQuantity = order.NetOrderedQuantity;
newOrder.NeedsOrderPut = false;
newOrder.NeedsTransactionGet = true;
newOrder.ErrorCount = 0;
newOrder.Ignore = false;
newOrder.CustomerMonsterId = monsterCustomerRecord.MonsterId;
newOrder.DateCreated = DateTime.UtcNow;
newOrder.LastUpdated = DateTime.UtcNow;
_executionLogService.Log(LogBuilder.DetectedNewShopifyOrder(newOrder));
_orderRepository.InsertOrder(newOrder);
}
else
{
existingOrder.ShopifyTotalPrice = order.total_price;
existingOrder.ShopifyFinancialStatus = order.financial_status;
existingOrder.ShopifyFulfillmentStatus = order.fulfillment_status;
existingOrder.ShopifyIsCancelled = order.IsCancelled;
existingOrder.ShopifyAreAllItemsRefunded = order.AreAllLineItemsRefunded;
existingOrder.ShopifyTotalQuantity = order.NetOrderedQuantity;
if (existingOrder.StatusChangeDetected(order))
{
existingOrder.NeedsOrderPut = true;
}
existingOrder.NeedsTransactionGet = true;
existingOrder.LastUpdated = DateTime.UtcNow;
_executionLogService.Log(LogBuilder.DetectedUpdateShopifyOrder(existingOrder));
_orderRepository.SaveChanges();
}
_shopifyJsonService.Upsert(ShopifyJsonType.Order, order.id, order.SerializeToJson());
transaction.Commit();
}
}
public ShopifyCustomer UpsertCustomer(Customer customer)
{
using (var transaction = _orderRepository.BeginTransaction())
{
var existingCustomer = _orderRepository.RetrieveCustomer(customer.id);
if (existingCustomer == null)
{
var newCustomer = new ShopifyCustomer();
newCustomer.ShopifyCustomerId = customer.id;
newCustomer.ShopifyPrimaryEmail = customer.email;
newCustomer.DateCreated = DateTime.UtcNow;
newCustomer.LastUpdated = DateTime.UtcNow;
newCustomer.NeedsCustomerPut = true;
_orderRepository.InsertCustomer(newCustomer);
_shopifyJsonService.Upsert(ShopifyJsonType.Customer, customer.id, customer.SerializeToJson());
transaction.Commit();
return(newCustomer);
}
else
{
existingCustomer.ShopifyPrimaryEmail = customer.email;
existingCustomer.NeedsCustomerPut = true;
existingCustomer.LastUpdated = DateTime.UtcNow;
_orderRepository.SaveChanges();
_shopifyJsonService.Upsert(ShopifyJsonType.Customer, customer.id, customer.SerializeToJson());
transaction.Commit();
return(existingCustomer);
}
}
}
private void CorrectFulfillmentWithUnknownRef(string shipmentNbr)
{
var salesOrderShipment = _syncOrderRepository.RetrieveSoShipment(shipmentNbr);
if (!salesOrderShipment.HasSyncWithUnknownNbr())
{
return;
}
var fulfillmentRecord = salesOrderShipment.ShopifyFulfillment;
var shopifyOrder =
_shopifyJsonService.RetrieveOrder(
salesOrderShipment.AcumaticaSalesOrder.ShopifyOrder.ShopifyOrderId);
var matches =
shopifyOrder
.fulfillments
.Where(x => x.tracking_number == salesOrderShipment.AcumaticaTrackingNbr)
.ToList();
if (!matches.Any())
{
var content = LogBuilder.ShopifyFulfillmentWithUnknownRefNoMatches(salesOrderShipment);
_logService.Log(content);
_syncOrderRepository.SetErrorCountToMaximum(shopifyOrder.id);
return;
}
if (matches.Count() > 1)
{
var content = LogBuilder.ShopifyFulfillmentWithUnknownRefTooManyMatches(salesOrderShipment);
_logService.Log(content);
_syncOrderRepository.SetErrorCountToMaximum(shopifyOrder.id);
return;
}
fulfillmentRecord.Ingest(matches.First());
fulfillmentRecord.DateCreated = DateTime.UtcNow;
fulfillmentRecord.LastUpdated = DateTime.UtcNow;
_logService.Log(LogBuilder.FillingUnknownShopifyFulfillmentRef(salesOrderShipment, fulfillmentRecord));
_shopifyOrderRepository.SaveChanges();
}