public List <OrderRow> get_by_order_id(Int32 id = 0)
{
// Create the list to return
List <OrderRow> posts = OrderRow.GetByOrderId(id);
// Return the list
return(posts);
} // End of the get_by_order_id method
public ActionResult print(Int32 id = 0)
{
// Get the current domain
Domain currentDomain = Tools.GetCurrentDomain();
ViewBag.CurrentDomain = currentDomain;
// Check if the administrator is authorized
if (Administrator.IsAuthorized(new string[] { "Administrator", "Editor", "Translator" }) == true)
{
ViewBag.AdminSession = true;
}
else if (Administrator.IsAuthorized(Administrator.GetAllAdminRoles()) == true)
{
ViewBag.AdminSession = true;
ViewBag.AdminErrorCode = 1;
ViewBag.TranslatedTexts = StaticText.GetAll(currentDomain.back_end_language, "id", "ASC");
return View("index");
}
else
{
// Redirect the user to the start page
return RedirectToAction("index", "admin_login");
}
// Get the default admin language id
Int32 adminLanguageId = currentDomain.back_end_language;
// Get the order
Order order = Order.GetOneById(id);
// Check if the order is null
if (order == null)
{
return RedirectToAction("index");
}
// Set form data
ViewBag.CurrentDomain = currentDomain;
ViewBag.Order = order;
ViewBag.OrderRows = OrderRow.GetByOrderId(order.id);
ViewBag.InvoiceCountry = Country.GetOneById(order.invoice_country_id, adminLanguageId);
ViewBag.DeliveryCountry = Country.GetOneById(order.delivery_country_id, adminLanguageId);
ViewBag.PaymentOption = PaymentOption.GetOneById(order.payment_option, adminLanguageId);
ViewBag.Company = Company.GetOneById(order.company_id);
ViewBag.TranslatedTexts = StaticText.GetAll(adminLanguageId, "id", "ASC");
ViewBag.CultureInfo = Tools.GetCultureInfo(Language.GetOneById(currentDomain.back_end_language));
// Return the view
return View();
} // End of the print method
} // End of the Add method
/// <summary>
/// Add customer files
/// </summary>
/// <param name="order">A reference to the order</param>
public static void AddCustomerFiles(Order order)
{
// Get the current domain
Domain domain = Tools.GetCurrentDomain();
// Get the order rows
List<OrderRow> orderRows = OrderRow.GetByOrderId(order.id);
// Get the customer
Customer customer = Customer.GetOneById(order.customer_id);
// Loop all of the order rows
for (int i = 0; i < orderRows.Count; i++)
{
// Get the product
Product product = Product.GetOneById(orderRows[i].product_id, domain.back_end_language);
// Continue if the product is null
if (product == null) { continue; }
// Check if the product has a downloadable files
if (product.downloadable_files == true)
{
// Create the customer file
CustomerFile customerFile = new CustomerFile();
customerFile.customer_id = customer.id;
customerFile.product_id = product.id;
customerFile.language_id = customer.language_id;
customerFile.order_date = order.order_date;
// Check if the file already exists
CustomerFile savedFile = CustomerFile.GetOneById(customerFile.customer_id, customerFile.product_id, customerFile.language_id);
if (savedFile == null)
{
// Add the customer file
CustomerFile.Add(customerFile);
}
}
}
} // End of the AddCustomerFiles method
} // End of the UpdatePaymentStatus method
/// <summary>
/// Respond to an updated order status
/// </summary>
/// <param name="order"></param>
/// <param name="paymentOption"></param>
/// <param name="orderStatus"></param>
/// <returns></returns>
private string UpdateOrderStatus(Order order, PaymentOption paymentOption, string orderStatus)
{
// Create the string to return
string error_message = "";
// Get the current domain
Domain domain = Tools.GetCurrentDomain();
// Get webshop settings
KeyStringList webshopSettings = WebshopSetting.GetAllFromCache();
// Check the order status
if (orderStatus == "order_status_delivered")
{
if(paymentOption.connection == 102) // Payson invoice
{
// Get credentials
string paysonEmail = webshopSettings.Get("PAYSON-EMAIL");
string userId = webshopSettings.Get("PAYSON-AGENT-ID");
string md5Key = webshopSettings.Get("PAYSON-MD5-KEY");
bool paysonTest = false;
bool.TryParse(webshopSettings.Get("PAYSON-TEST"), out paysonTest);
// Create the api
PaysonIntegration.PaysonApi paysonApi = new PaysonIntegration.PaysonApi(userId, md5Key, null, paysonTest);
// Update the order
PaysonIntegration.Data.PaymentUpdateData paymentUpdateData = new PaysonIntegration.Data.PaymentUpdateData(order.payment_token, PaysonIntegration.Utils.PaymentUpdateAction.ShipOrder);
PaysonIntegration.Response.PaymentUpdateResponse paymentUpdateResponse = paysonApi.MakePaymentUpdateRequest(paymentUpdateData);
// Check if the response is successful
if (paymentUpdateResponse != null && paymentUpdateResponse.Success == false)
{
// Set error messages
foreach (string key in paymentUpdateResponse.ErrorMessages)
{
error_message += "• " + "Payson: " + paymentUpdateResponse.ErrorMessages[key] + "<br/>";
}
}
}
else if(paymentOption.connection == 301) // Svea invoice
{
// Get the order rows
List<OrderRow> orderRows = OrderRow.GetByOrderId(order.id);
// Create the payment configuration
SveaSettings sveaConfiguration = new SveaSettings();
// Create the order builder
Webpay.Integration.CSharp.Order.Handle.DeliverOrderBuilder inoviceBuilder = Webpay.Integration.CSharp.WebpayConnection.DeliverOrder(sveaConfiguration);
// Add order rows
for (int i = 0; i < orderRows.Count; i++)
{
// Get the unit
Unit unit = Unit.GetOneById(orderRows[i].unit_id, domain.back_end_language);
// Create an order item
Webpay.Integration.CSharp.Order.Row.OrderRowBuilder orderItem = new Webpay.Integration.CSharp.Order.Row.OrderRowBuilder();
orderItem.SetArticleNumber(orderRows[i].product_code);
orderItem.SetName(orderRows[i].product_name);
orderItem.SetQuantity(orderRows[i].quantity);
orderItem.SetUnit(unit.unit_code);
orderItem.SetAmountExVat(orderRows[i].unit_price);
orderItem.SetVatPercent(orderRows[i].vat_percent * 100);
// Add the order item
inoviceBuilder.AddOrderRow(orderItem);
}
// Get the order id
Int64 sveaOrderId = 0;
Int64.TryParse(order.payment_token, out sveaOrderId);
// Set invoice values
inoviceBuilder.SetOrderId(sveaOrderId);
inoviceBuilder.SetNumberOfCreditDays(15);
inoviceBuilder.SetInvoiceDistributionType(Webpay.Integration.CSharp.Util.Constant.InvoiceDistributionType.POST);
inoviceBuilder.SetCountryCode(SveaSettings.GetSveaCountryCode(order.country_code));
// Make the request to send the invoice
Webpay.Integration.CSharp.WebpayWS.DeliverOrderEuResponse deliverOrderResponse = inoviceBuilder.DeliverInvoiceOrder().DoRequest();
// Check if the response is successful
if (deliverOrderResponse.Accepted == false)
{
// Set error messages
error_message += "• " + "Svea code: " + deliverOrderResponse.ResultCode.ToString() + "<br/>";
error_message += "• " + "Svea message: " + deliverOrderResponse.ErrorMessage + "<br/>";
}
}
else if (paymentOption.connection >= 400 && paymentOption.connection <= 499) // Payex
{
// Check the transaction
Dictionary<string, string> payexResponse = PayExManager.CheckTransaction(order, webshopSettings);
// Get response variables
string error_code = payexResponse.ContainsKey("error_code") == true ? payexResponse["error_code"] : "";
string description = payexResponse.ContainsKey("description") == true ? payexResponse["description"] : "";
string parameter_name = payexResponse.ContainsKey("parameter_name") == true ? payexResponse["parameter_name"] : "";
string transaction_status = payexResponse.ContainsKey("transaction_status") == true ? payexResponse["transaction_status"] : "";
string transaction_number = payexResponse.ContainsKey("transaction_number") == true ? payexResponse["transaction_number"] : "";
// Check if the response was successful
if (error_code.ToUpper() == "OK")
{
if(transaction_status == "3") // Authorize
{
// Capture the transaction
payexResponse = PayExManager.CaptureTransaction(order);
// Get response variables
error_code = payexResponse.ContainsKey("error_code") == true ? payexResponse["error_code"] : "";
description = payexResponse.ContainsKey("description") == true ? payexResponse["description"] : "";
parameter_name = payexResponse.ContainsKey("parameter_name") == true ? payexResponse["parameter_name"] : "";
transaction_status = payexResponse.ContainsKey("transaction_status") == true ? payexResponse["transaction_status"] : "";
transaction_number = payexResponse.ContainsKey("transaction_number") == true ? payexResponse["transaction_number"] : "";
string transaction_number_original = payexResponse.ContainsKey("transaction_number_original") == true ? payexResponse["transaction_number_original"] : "";
if(error_code.ToUpper() != "OK" || transaction_status != "6")
{
// Set error messages
error_message += "• " + "Payex code: " + error_code + "<br/>";
error_message += "• " + "Payex message: " + description + "<br/>";
error_message += "• " + "Payex parameter: " + parameter_name + "<br/>";
error_message += "• " + "Payex status: " + transaction_status + "<br/>";
error_message += "• " + "Payex number (original): " + transaction_number + "<br/>";
}
else
{
// Update the transaction number for the order
Order.SetPaymentToken(order.id, transaction_number);
}
}
}
else
{
// Set error messages
error_message += "• " + "Payex code: " + error_code + "<br/>";
error_message += "• " + "Payex message: " + description + "<br/>";
error_message += "• " + "Payex parameter: " + parameter_name + "<br/>";
error_message += "• " + "Payex status: " + transaction_status + "<br/>";
error_message += "• " + "Payex number: " + transaction_number + "<br/>";
}
}
}
else if (orderStatus == "order_status_cancelled")
{
if(paymentOption.connection >= 100 && paymentOption.connection <= 199) // Payson
{
// Get credentials
string paysonEmail = webshopSettings.Get("PAYSON-EMAIL");
string userId = webshopSettings.Get("PAYSON-AGENT-ID");
string md5Key = webshopSettings.Get("PAYSON-MD5-KEY");
bool paysonTest = false;
bool.TryParse(webshopSettings.Get("PAYSON-TEST"), out paysonTest);
// Create the api
PaysonIntegration.PaysonApi paysonApi = new PaysonIntegration.PaysonApi(userId, md5Key, null, paysonTest);
// Get details about the payment status
PaysonIntegration.Response.PaymentDetailsResponse paysonResponse = paysonApi.MakePaymentDetailsRequest(new PaysonIntegration.Data.PaymentDetailsData(order.payment_token));
// Get the type and status of the payment
PaysonIntegration.Utils.PaymentType? paymentType = paysonResponse.PaymentDetails.PaymentType;
PaysonIntegration.Utils.PaymentStatus? paymentStatus = paysonResponse.PaymentDetails.PaymentStatus;
PaysonIntegration.Utils.InvoiceStatus? invoiceStatus = paysonResponse.PaymentDetails.InvoiceStatus;
// Payment update
PaysonIntegration.Data.PaymentUpdateData paymentUpdateData = null;
PaysonIntegration.Response.PaymentUpdateResponse paymentUpdateResponse = null;
if (paymentType == PaysonIntegration.Utils.PaymentType.Direct && paymentStatus == PaysonIntegration.Utils.PaymentStatus.Completed)
{
// Refund the payment
paymentUpdateData = new PaysonIntegration.Data.PaymentUpdateData(order.payment_token, PaysonIntegration.Utils.PaymentUpdateAction.Refund);
paymentUpdateResponse = paysonApi.MakePaymentUpdateRequest(paymentUpdateData);
}
else if (paymentType == PaysonIntegration.Utils.PaymentType.Invoice && invoiceStatus == PaysonIntegration.Utils.InvoiceStatus.OrderCreated)
{
// Cancel the order
paymentUpdateData = new PaysonIntegration.Data.PaymentUpdateData(order.payment_token, PaysonIntegration.Utils.PaymentUpdateAction.CancelOrder);
paymentUpdateResponse = paysonApi.MakePaymentUpdateRequest(paymentUpdateData);
}
else if (paymentType == PaysonIntegration.Utils.PaymentType.Invoice && (invoiceStatus == PaysonIntegration.Utils.InvoiceStatus.Shipped
|| invoiceStatus == PaysonIntegration.Utils.InvoiceStatus.Done))
{
// Credit the order
paymentUpdateData = new PaysonIntegration.Data.PaymentUpdateData(order.payment_token, PaysonIntegration.Utils.PaymentUpdateAction.CreditOrder);
paymentUpdateResponse = paysonApi.MakePaymentUpdateRequest(paymentUpdateData);
}
// Check if there was any errors
if (paymentUpdateResponse != null && paymentUpdateResponse.Success == false)
{
// Set error messages
foreach (string key in paymentUpdateResponse.ErrorMessages)
{
error_message += "• " + "Payson: " + paymentUpdateResponse.ErrorMessages[key] + "<br/>";
}
}
}
else if(paymentOption.connection == 201) // PayPal
{
// Get credentials
string paypalClientId = webshopSettings.Get("PAYPAL-CLIENT-ID");
string paypalClientSecret = webshopSettings.Get("PAYPAL-CLIENT-SECRET");
string paypalMode = webshopSettings.Get("PAYPAL-MODE");
Dictionary<string, string> config = new Dictionary<string, string> { { "mode", paypalMode } };
try
{
// Create the credential token
PayPal.OAuthTokenCredential tokenCredential = new PayPal.OAuthTokenCredential(paypalClientId, paypalClientSecret, config);
// Create the api context
PayPal.APIContext paypalContext = new PayPal.APIContext(tokenCredential.GetAccessToken());
paypalContext.Config = config;
// Look up the sale
PayPal.Api.Payments.Sale sale = PayPal.Api.Payments.Sale.Get(paypalContext, order.payment_token);
if (sale.state == "completed")
{
// Refund the payment
paypalContext.HTTPHeaders = null;
PayPal.Api.Payments.Refund refund = sale.Refund(paypalContext, new PayPal.Api.Payments.Refund());
if(refund.state != "completed")
{
error_message += "• " + "PayPal: " + refund.state;
}
}
else
{
error_message += "• " + "PayPal: " + sale.state;
}
}
catch (Exception ex)
{
error_message += "• PayPal: " + ex.Message;
}
}
else if(paymentOption.connection == 301) // Svea invoice
{
// Create the payment configuration
SveaSettings sveaConfiguration = new SveaSettings();
// Get the order id
Int64 sveaOrderId = 0;
Int64.TryParse(order.payment_token, out sveaOrderId);
// Cancel the order
Webpay.Integration.CSharp.Order.Handle.CloseOrderBuilder closeOrder = Webpay.Integration.CSharp.WebpayConnection.CloseOrder(sveaConfiguration);
closeOrder.SetOrderId(sveaOrderId);
closeOrder.SetCountryCode(SveaSettings.GetSveaCountryCode(order.country_code));
Webpay.Integration.CSharp.WebpayWS.CloseOrderEuResponse closeOrderResponse = closeOrder.CloseInvoiceOrder().DoRequest();
// Check if the response is successful
if (closeOrderResponse.Accepted == false)
{
// Set error messages
error_message += "• " + "Svea code: " + closeOrderResponse.ResultCode.ToString() + "<br/>";
error_message += "• " + "Svea message: " + closeOrderResponse.ErrorMessage + "<br/>";
}
}
else if(paymentOption.connection >= 400 && paymentOption.connection <= 499) // Payex
{
// Check the transaction
Dictionary<string, string> payexResponse = PayExManager.CheckTransaction(order, webshopSettings);
// Get response variables
string error_code = payexResponse.ContainsKey("error_code") == true ? payexResponse["error_code"] : "";
string description = payexResponse.ContainsKey("description") == true ? payexResponse["description"] : "";
string parameter_name = payexResponse.ContainsKey("parameter_name") == true ? payexResponse["parameter_name"] : "";
string transaction_status = payexResponse.ContainsKey("transaction_status") == true ? payexResponse["transaction_status"] : "";
string transaction_number = payexResponse.ContainsKey("transaction_number") == true ? payexResponse["transaction_number"] : "";
// Check if the response was successful
if(error_code.ToUpper() == "OK")
{
// Check if we should cancel or credit the order
if(transaction_status == "3") // Authorize
{
// Cancel the transaction
payexResponse = PayExManager.CancelTransaction(order, webshopSettings);
// Get response variables
error_code = payexResponse.ContainsKey("error_code") == true ? payexResponse["error_code"] : "";
description = payexResponse.ContainsKey("description") == true ? payexResponse["description"] : "";
parameter_name = payexResponse.ContainsKey("parameter_name") == true ? payexResponse["parameter_name"] : "";
transaction_status = payexResponse.ContainsKey("transaction_status") == true ? payexResponse["transaction_status"] : "";
transaction_number = payexResponse.ContainsKey("transaction_number") == true ? payexResponse["transaction_number"] : "";
if(error_code.ToUpper() != "OK" || transaction_status != "4")
{
// Set error messages
error_message += "• " + "Payex code: " + error_code + "<br/>";
error_message += "• " + "Payex message: " + description + "<br/>";
error_message += "• " + "Payex parameter: " + parameter_name + "<br/>";
error_message += "• " + "Payex status: " + transaction_status + "<br/>";
error_message += "• " + "Payex number: " + transaction_number + "<br/>";
}
}
else if(transaction_status == "0" || transaction_status == "6") // Sale or capture
{
// Get the order rows
List<OrderRow> orderRows = OrderRow.GetByOrderId(order.id);
// Credit the transaction
payexResponse = PayExManager.CreditTransaction(order, orderRows, webshopSettings);
// Get response variables
error_code = payexResponse.ContainsKey("error_code") == true ? payexResponse["error_code"] : "";
description = payexResponse.ContainsKey("description") == true ? payexResponse["description"] : "";
parameter_name = payexResponse.ContainsKey("parameter_name") == true ? payexResponse["parameter_name"] : "";
transaction_status = payexResponse.ContainsKey("transaction_status") == true ? payexResponse["transaction_status"] : "";
transaction_number = payexResponse.ContainsKey("transaction_number") == true ? payexResponse["transaction_number"] : "";
if (error_code.ToUpper() != "OK" || transaction_status != "2")
{
// Set error messages
error_message += "• " + "Payex code: " + error_code + "<br/>";
error_message += "• " + "Payex message: " + description + "<br/>";
error_message += "• " + "Payex parameter: " + parameter_name + "<br/>";
error_message += "• " + "Payex status: " + transaction_status + "<br/>";
error_message += "• " + "Payex number: " + transaction_number + "<br/>";
}
}
}
else
{
// Set error messages
error_message += "• " + "Payex code: " + error_code + "<br/>";
error_message += "• " + "Payex message: " + description + "<br/>";
error_message += "• " + "Payex parameter: " + parameter_name + "<br/>";
error_message += "• " + "Payex status: " + transaction_status + "<br/>";
error_message += "• " + "Payex number: " + transaction_number + "<br/>";
}
}
}
// Return the error message
return error_message;
} // End of the UpdateOrderStatus method
