public void Update(int OrderNoteId, int OrderId, string Note, string CreatedBy, DateTime CreatedOn, string ModifiedBy, DateTime ModifiedOn)
{
OrderNote item = new OrderNote();
item.OrderNoteId = OrderNoteId;
item.OrderId = OrderId;
item.Note = Note;
item.CreatedBy = CreatedBy;
item.CreatedOn = CreatedOn;
item.ModifiedBy = ModifiedBy;
item.ModifiedOn = ModifiedOn;
item.MarkOld();
item.Save(UserName);
}
public bool Destroy(object OrderNoteId)
{
return(OrderNote.Destroy(OrderNoteId) == 1);
}
public bool Delete(object OrderNoteId)
{
return(OrderNote.Delete(OrderNoteId) == 1);
}
/// <summary>
/// Charges the specified order.
/// </summary>
/// <param name="order">The order.</param>
/// <param name="userName">Name of the user.</param>
/// <returns></returns>
public static Transaction Charge(Order order, string userName)
{
//update the order with IP
order.IPAddress = HttpContext.Current.Request.UserHostAddress == "::1" || HttpContext.Current.Request.UserHostAddress == "127.0.0.1" ? "127.0.0.1" : HttpContext.Current.Request.UserHostAddress;
PaymentService paymentService = new PaymentService();
Transaction transaction = paymentService.Charge(order);
order.OrderStatusDescriptorId = (int)OrderStatus.ReceivedPaymentProcessingOrder;
order.OrderTypeId = (int)OrderType.Purchase;
order.Save(userName);
Guid userGuid = new Guid(Membership.GetUser(userName).ProviderUserKey.ToString());
try {
//Add an OrderNote
OrderNote orderNote = new OrderNote();
orderNote.OrderId = order.OrderId;
orderNote.Note = Strings.ResourceManager.GetString(ORDER_CHARGED);
orderNote.Save(userName);
Sku sku;
DownloadCollection downloadCollection;
DownloadAccessControlCollection downloadAccessControlCollection;
DownloadAccessControl downloadAccessControl;
foreach (OrderItem orderItem in order.OrderItemCollection)
{
//Adjust the Inventory
sku = new Sku(SKU, orderItem.Sku);
sku.Inventory = sku.Inventory - orderItem.Quantity;
sku.Save(SYSTEM);
ProductCache.RemoveSKUFromCache(orderItem.Sku);
//Add access control for orderitems
downloadCollection = new ProductController().FetchAssociatedDownloadsByProductIdAndForPurchase(orderItem.ProductId);
if (downloadCollection.Count > 0)
{
foreach (Download download in downloadCollection)
{
Query query = new Query(DownloadAccessControl.Schema).
AddWhere(DownloadAccessControl.Columns.UserId, Comparison.Equals, userGuid).
AddWhere(DownloadAccessControl.Columns.DownloadId, Comparison.Equals, download.DownloadId);
downloadAccessControlCollection = new DownloadAccessControlController().FetchByQuery(query);
if (downloadAccessControlCollection.Count == 0)
{
downloadAccessControl = new DownloadAccessControl();
downloadAccessControl.DownloadId = download.DownloadId;
downloadAccessControl.UserId = userGuid;
downloadAccessControl.Save(SYSTEM);
}
}
}
}
//Send out the messages
//Send these last in case something happens with the email
MessageService messageService = new MessageService();
messageService.SendOrderReceivedNotificationToCustomer(order);
messageService.SendOrderReceivedNotificationToMerchant(order);
}
catch (Exception ex) {
//swallow the exception here because the transaction is saved
//and, while this is an inconvenience, it's not critical
Logger.Error(typeof(OrderController).Name + ".Charge", ex);
}
return(transaction);
}
/// <summary>
/// Refunds the specified transaction.
/// </summary>
/// <param name="transaction">The transaction.</param>
/// <param name="refundedOrder">The refunded order.</param>
/// <param name="userName">Name of the user.</param>
public static void RefundStandard(Transaction transaction, Order refundedOrder, string userName)
{
Order order = new Order(transaction.OrderId);
Transaction refundTransaction = new Transaction();
//refundTransaction.OrderId = transaction.OrderId;
refundTransaction.TransactionTypeDescriptorId = (int)TransactionType.Refund;
refundTransaction.PaymentMethod = PAYPAL;
refundTransaction.GatewayName = PAYPAL_STANDARD;
refundTransaction.GatewayResponse = SUCCESS;
refundTransaction.GatewayTransactionId = CoreUtility.GenerateRandomString(16);
refundTransaction.GrossAmount = refundedOrder.Total;
refundTransaction.NetAmount = 0.00M;
refundTransaction.FeeAmount = 0.00M;
refundTransaction.TransactionDate = DateTime.Now;
//refundTransaction.Save(userName);
refundedOrder.Save(userName);
//set the orderid for the refund
foreach (OrderItem orderItem in refundedOrder.OrderItemCollection)
{
orderItem.OrderId = refundedOrder.OrderId;
}
refundedOrder.OrderItemCollection.SaveAll(userName);
//set the orderId to the refunded orderId
refundTransaction.OrderId = refundedOrder.OrderId;
refundTransaction.Save(userName);
Guid userGuid = new Guid(Membership.GetUser(order.UserName).ProviderUserKey.ToString());
DownloadCollection downloadCollection;
foreach (OrderItem orderItem in refundedOrder.OrderItemCollection)
{
//put the stock back
Sku sku = new Sku(Sku.Columns.SkuX, orderItem.Sku);
sku.Inventory = sku.Inventory + orderItem.Quantity;
sku.Save(userName);
ProductCache.RemoveSKUFromCache(orderItem.Sku);
//remove the access control
downloadCollection = new ProductController().FetchAssociatedDownloadsByProductIdAndForPurchase(orderItem.ProductId);
if (downloadCollection.Count > 0)
{
foreach (Download download in downloadCollection)
{
new DownloadAccessControlController().Delete(userGuid, download.DownloadId);
}
}
}
if (refundedOrder.Total == order.Total)
{
order.OrderStatusDescriptorId = (int)OrderStatus.OrderFullyRefunded;
}
else
{
order.OrderStatusDescriptorId = (int)OrderStatus.OrderPartiallyRefunded;
}
order.Save(userName);
//Add an OrderNote
OrderNote orderNote = new OrderNote();
orderNote.OrderId = order.OrderId;
orderNote.Note = Strings.ResourceManager.GetString(ORDER_REFUNDED);
orderNote.Save(userName);
//send off the notifications
MessageService messageService = new MessageService();
messageService.SendOrderRefundToCustomer(refundedOrder);
}