/// <summary>
/// Called when the purchase order payment is captured, we want to update the notification description and created date
/// </summary>
/// <param name="purchOrder"></param>
/// <returns></returns>
public static bool ProcessPurchaseOrderPaymentCaptured(PurchaseOrderDetails purchOrder)
{
try
{
Notification Notif = DashboardNotificationDAO.Load(purchOrder.Id);
string UpdateText = String.Format("Purchase order shipment needs updated in order to notify customer. Order placed on {0} UTC with a total of {1} spent.", purchOrder.PayPalOrderDetails.OrderPlacedDateUtc.ToString("g"), (purchOrder.PayPalOrderDetails.BaseAmount + purchOrder.PayPalOrderDetails.TaxAmount + purchOrder.PayPalOrderDetails.ShippingAmount).ToString("C"));
//arleady exists
if (Notif != null && !string.IsNullOrWhiteSpace(Notif.Id))
{
return DashboardNotificationDAO.Update(purchOrder.Id, UpdateText);
}
//else save a new one
else
{
Notification NewNotification = GenerateNewNotification(purchOrder.Id, UpdateText);
return DashboardNotificationDAO.Save(NewNotification);
}
}
catch (Exception e)
{
CompanyCommons.Logging.WriteLog("Chimera.Core.Notifications.PurchaseOrder.ProcessPurchaseOrderPaymentCaptured()" + e.Message);
}
return false;
}
/// <summary>
/// After a new purchase order is final and saved, we need to substract the stock levels from the actual product.
/// </summary>
/// <param name="purchOrder"></param>
public static void ProcessNewOrderStockLevels(SettingGroup paypalSettings, PurchaseOrderDetails purchOrder)
{
try
{
if (purchOrder != null && purchOrder.PurchasedProductList != null && purchOrder.PurchasedProductList.Count > 0)
{
foreach (var PurchProd in purchOrder.PurchasedProductList)
{
Product Prod = ProductDAO.LoadByBsonId(PurchProd.Id);
if (Prod != null)
{
Prod.UpdateStock(PurchProd);
ProductDAO.Save(Prod);
Chimera.Core.Notifications.ProductStock.ProcessPurchasedProduct(paypalSettings, Prod);
}
}
}
}
catch (Exception e)
{
CompanyCommons.Logging.WriteLog("Chimera.Core.PurchaseOrders.ProductStock.ProcessNewOrderStockLevels()" + e.Message);
}
}
/// <summary>
/// Called to send the emails whenever a new order is processed.
/// </summary>
/// <param name="settingGroupList"></param>
/// <param name="paypalPurchaseOrder"></param>
public static void SendNewEcommerceOrderEmails(List<SettingGroup> settingGroupList, PurchaseOrderDetails paypalPurchaseOrder)
{
try
{
SettingGroup EmailSettings = settingGroupList.Where(e => e.GroupKey.Equals(SettingGroupKeys.EMAIL_SETTINGS)).FirstOrDefault();
SettingGroup TemplateSettings = settingGroupList.Where(e => e.GroupKey.Equals(SettingGroupKeys.TEMPLATE_CUSTOM_SETTINGS)).FirstOrDefault();
List<AdminUser> AdminUserList = new List<AdminUser>();
try
{
if (!string.IsNullOrWhiteSpace(EmailSettings.GetSettingVal(EmailSettingKeys.NewOrderEmailAdminUsers)))
{
AdminUserList = AdminUserDAO.LoadByMultipleIds(EmailSettings.GetSettingVal(EmailSettingKeys.NewOrderEmailAdminUsers).Split(',').ToList());
}
}
catch (Exception e)
{
//do nothing, just in case the setting got jacked up somehow we still want to send the customer's email.
}
Chimera.Emails.Ecommerce.SendNewEcommerceOrderEmails(AdminUserList, paypalPurchaseOrder, EmailSettings.GetSettingVal(EmailSettingKeys.CustomerOrderFinishedEmail), EmailSettings.GetSettingVal(EmailSettingKeys.SenderEmailAddress), TemplateSettings.GetSettingVal("WebsiteTitle"));
}
catch (Exception e)
{
CompanyCommons.Logging.WriteLog("Chimera.Core.PurchaseOrders.Email.SendNewEcommerceOrderEmails()" + e.Message);
}
}
/// <summary>
/// The purchase order has shipped, delete the notification.
/// </summary>
/// <param name="purchOrder"></param>
/// <returns></returns>
public static bool ProcessPurchaseOrderShipped(PurchaseOrderDetails purchOrder)
{
try
{
return DashboardNotificationDAO.Delete(purchOrder.Id);
}
catch (Exception e)
{
CompanyCommons.Logging.WriteLog("Chimera.Core.Notifications.PurchaseOrder.ProcessPurchaseOrderShipped()" + e.Message);
}
return false;
}
/// <summary>
/// Called when a new purchase order is added to the system
/// </summary>
/// <param name="purchOrder"></param>
/// <returns></returns>
public static bool ProcessNewPurchaseOrder(PurchaseOrderDetails purchOrder)
{
try
{
Notification NewNotification = GenerateNewNotification(purchOrder.Id, String.Format("New purchase order requires PayPal payment captured. Order placed on {0} UTC with a total of {1} spent.", purchOrder.PayPalOrderDetails.OrderPlacedDateUtc.ToString("g"), (purchOrder.PayPalOrderDetails.BaseAmount + purchOrder.PayPalOrderDetails.TaxAmount + purchOrder.PayPalOrderDetails.ShippingAmount).ToString("C")));
return DashboardNotificationDAO.Save(NewNotification);
}
catch (Exception e)
{
CompanyCommons.Logging.WriteLog("Chimera.Core.Notifications.PurchaseOrder.ProcessNewPurchaseOrder()" + e.Message);
}
return false;
}
public ActionResult InitCheckout(string shippingMethod)
{
try
{
List<ShoppingCartProduct> ShoppingCartList = SiteContext.ShoppingCartProductList;
SettingGroup PayPalSettings = SettingGroupDAO.LoadSettingGroupByName(SettingGroupKeys.PAYPAL_PURCHASE_SETTINGS);
//create auth header obj
AuthHeader PayPalAuthHeader = Chimera.Core.PurchaseOrders.PayPalAuthHeader.GetAuthHeaderFromSetting(PayPalSettings);
//create authorization obj
Authorization PayPalAuthorization = new Authorization();
string BaseWebsiteURL = CM.AppSettings["BaseWebsiteURL"];
PayPalAuthorization.StoreImageURL = PayPalSettings.GetSettingVal(PayPalSettingKeys.PayPal_HDRIMG);
PayPalAuthorization.SuccessOrderURL = BaseWebsiteURL + "Order/PayPalSuccess";
PayPalAuthorization.CancelOrderURL = BaseWebsiteURL + "Order/PayPalCancel";
//create purchase order details obj
PurchaseOrderDetails PurchaseOrder = new PurchaseOrderDetails(shippingMethod, ShoppingCartList, Helpers.ShippingMethod.GetGlobalShippingMethodDictionary(null, PayPalSettings)[shippingMethod], PayPalSettings.GetSettingVal(PayPalSettingKeys.GlobalTaxAmount));
//call paypal API to get new order details
OrderDetails AuthOrderDetails = CompanyCommons.Ecommerce.PayPal.Functions.Execute.Authorization(PayPalAuthHeader, PayPalAuthorization, PurchaseOrder.PayPalOrderDetails, PurchaseOrder.CreatePayPalItemDescriptions());
if (AuthOrderDetails != null)
{
//store purchase order object into session
PurchaseOrder.PayPalOrderDetails = AuthOrderDetails;
//add updated info to session
SiteContext.PayPalPurchaseOrder = PurchaseOrder;
//redirect to paypal
return Redirect(CompanyCommons.Ecommerce.PayPal.Functions.Execute.GetAuthorizationRedirectURL(PayPalSettings.GetSettingVal(PayPalSettingKeys.PayPal_REDIRECT), AuthOrderDetails));
}
//if we got this far the call the paypal's API failed
}
catch (Exception e)
{
CompanyCommons.Logging.WriteLog("ChimeraWebsite.Controllers.OrderController.InitCheckout() " + e.Message);
}
//TODO: return 404 page instead?
return RedirectToAction("Index", "Home");
}
/// <summary>
/// Called when a new PayPal order is finished, we need to email the necessary admin users and the customer.
/// </summary>
/// <param name="notifyAdminUserList">the list of admin users that should be notified of the new order</param>
/// <param name="purchaseOrderDetails">the order details</param>
/// <param name="customerEmailSettingName">the name of the email to use the customer should see</param>
/// <param name="emailSender">the email address that should be listed as the sender</param>
/// <returns>bool if all emails sent</returns>
public static bool SendNewEcommerceOrderEmails(List<AdminUser> notifyAdminUserList, PurchaseOrderDetails purchaseOrderDetails, string customerEmailSettingName, string emailSender, string websiteTitle)
{
string EmailsSent = string.Empty;
try
{
Dictionary<string, string> ValuesToReplace = new Dictionary<string, string>();
ValuesToReplace.Add("[WEBSITE_TITLE]", websiteTitle);
ValuesToReplace.Add("[FIRSTNAME]", purchaseOrderDetails.PayPalOrderDetails.CustomerInfo.FirstName);
ValuesToReplace.Add("[LASTNAME]", purchaseOrderDetails.PayPalOrderDetails.CustomerInfo.LastName);
ValuesToReplace.Add("[ORDER_CONFIRM_NUMBER]", purchaseOrderDetails.Id);
ValuesToReplace.Add("[ORDER_DATE]", purchaseOrderDetails.PayPalOrderDetails.OrderPlacedDateUtc.ToString("g") + " UTC");
ValuesToReplace.Add("[ORDER_DETAILS_TABLE]", GenerateOrderDetailsTable(purchaseOrderDetails));
ValuesToReplace.Add("[EMAIL_ADDRESS]", purchaseOrderDetails.PayPalOrderDetails.CustomerInfo.Email);
ValuesToReplace.Add("[SHIPPING_NAME]", purchaseOrderDetails.PayPalOrderDetails.CustomerInfo.ShipToName);
ValuesToReplace.Add("[STREET_ADDRESS]", purchaseOrderDetails.PayPalOrderDetails.CustomerInfo.ShipToStreet);
ValuesToReplace.Add("[STREET_ADDRESS_TWO]", purchaseOrderDetails.PayPalOrderDetails.CustomerInfo.ShipToStreet_Two);
ValuesToReplace.Add("[CITY]", purchaseOrderDetails.PayPalOrderDetails.CustomerInfo.ShipToCity);
ValuesToReplace.Add("[STATE]", purchaseOrderDetails.PayPalOrderDetails.CustomerInfo.ShipToState);
ValuesToReplace.Add("[POSTAL_CODE]", purchaseOrderDetails.PayPalOrderDetails.CustomerInfo.ShipToZip);
ValuesToReplace.Add("[SELECTED SHIPPING METHOD]", purchaseOrderDetails.PayPalOrderDetails.ShippingMethodType);
//email the customer
try
{
if (!CompanyCommons.Email.SendEmailBasedOnFile("CustomerNewOrder_" + customerEmailSettingName + ".html", purchaseOrderDetails.PayPalOrderDetails.CustomerInfo.Email, emailSender, ValuesToReplace, null, EMAIL_MODULE_NAME))
{
EmailsSent += "FAIL";
}
}
catch (Exception e)
{
CompanyCommons.Logging.WriteLog("Chimera.Emails.Ecommerce.SendNewEcommerceEmails() Unable to send email: " + customerEmailSettingName + ".html " + e.Message);
}
//email admin users
try
{
if (notifyAdminUserList != null && notifyAdminUserList.Count > 0)
{
foreach (var AdminUser in notifyAdminUserList)
{
if (!string.IsNullOrWhiteSpace(AdminUser.Email))
{
if(!CompanyCommons.Email.SendEmailBasedOnFile("AdminUsersNewOrder.html", AdminUser.Email, emailSender, ValuesToReplace, null, EMAIL_MODULE_NAME))
{
EmailsSent += "FAIL";
}
}
}
}
}
catch (Exception e)
{
CompanyCommons.Logging.WriteLog("Chimera.Emails.Ecommerce.SendNewEcommerceEmails() Unable to send email: AdminUsersNewOrder.html " + e.Message);
}
}
catch (Exception e)
{
CompanyCommons.Logging.WriteLog("Chimera.Emails.Ecommerce.SendNewEcommerceEmails() Unable to send emails: " + e.Message);
}
return string.IsNullOrWhiteSpace(EmailsSent);
}
/// <summary>
/// Generate the html table that displays the list of products.
/// </summary>
/// <param name="purchaseOrderDetails">the order details</param>
/// <returns>string containing all the html</returns>
private static string GenerateOrderDetailsTable(PurchaseOrderDetails purchaseOrderDetails)
{
string FinalTableHTML = string.Empty;
try
{
FinalTableHTML = "<table cellpadding='0' width='100%' cellspacing='0' border='0' style='border-left: 1px solid #d6d6d6; border-right: 1px solid #d6d6d6;'>";
if (purchaseOrderDetails.PurchasedProductList != null && purchaseOrderDetails.PurchasedProductList.Count > 0)
{
FinalTableHTML += "<tr>";
FinalTableHTML += "<th style='font-weight: bold; vertical-align: middle; background-color: #f4f4f4; border-top: 1px solid #d6d6d6; border-bottom: 1px solid #d6d6d6; font-size: 11px; text-align: left; padding: 10px 0px; padding-left: 5px;'>ITEM DESCRIPTION</th>";
FinalTableHTML += "<th style='font-weight: bold; vertical-align: middle; background-color: #f4f4f4; border-top: 1px solid #d6d6d6; border-bottom: 1px solid #d6d6d6; font-size: 11px; text-align: left; padding: 10px 0px; width: 130px;'>ITEM PRICE</th>";
FinalTableHTML += "<th style='font-weight: bold; vertical-align: middle; background-color: #f4f4f4; border-top: 1px solid #d6d6d6; border-bottom: 1px solid #d6d6d6; font-size: 11px; text-align: left; padding: 10px 0px; width: 105px;'>QUANTITY</th>";
FinalTableHTML += "<th style='font-weight: bold; vertical-align: middle; background-color: #f4f4f4; border-top: 1px solid #d6d6d6; border-bottom: 1px solid #d6d6d6; font-size: 11px; text-align: center; padding: 10px 0px; width: 105px;'>TOTAL PRICE</th>";
FinalTableHTML += "</tr>";
int NumberOfItems = 0;
foreach (var PurchProd in purchaseOrderDetails.PurchasedProductList)
{
//html for the item list
FinalTableHTML += "<tr>";
FinalTableHTML += "<td style='font-size: 11px; text-align: left; border-bottom: 1px solid #d6d6d6; vertical-align: top; padding-top: 20px; padding-bottom: 20px; padding-left: 5px;'>";
FinalTableHTML += "<div style='font-weight: bold; text-transform: uppercase; color: #000; text-decoration: none;'>" + PurchProd.Name + "</div>";
FinalTableHTML += "<br>";
if (PurchProd.SelectedCheckoutProperties != null && PurchProd.SelectedCheckoutProperties.Count > 0)
{
FinalTableHTML += "<ul style='margin: 0;padding: 0;list-style: none;'>";
foreach (var SelectedProp in PurchProd.SelectedCheckoutProperties)
{
FinalTableHTML += "<li style='list-style: none;'><span style='text-transform: uppercase; font-weight: bold;display: inline;float: left;width: 60px;'>" + SelectedProp.Key + ":</span>" + SelectedProp.Value + "</li>";
}
FinalTableHTML += "</ul>";
}
FinalTableHTML += "</td>";
FinalTableHTML += "<td style='text-align: left;border-bottom: 1px solid #d6d6d6;vertical-align: top;padding-top: 20px;padding-bottom: 20px;font-size: 12px;'>";
FinalTableHTML += PurchProd.PurchasePrice.ToString("C");
FinalTableHTML += "</td>";
FinalTableHTML += "<td style='text-align: left;border-bottom: 1px solid #d6d6d6;vertical-align: top;padding-top: 20px;padding-bottom: 20px;font-size: 12px;'>";
FinalTableHTML += PurchProd.Quantity;
FinalTableHTML += "</td>";
FinalTableHTML += "<td style='text-align: center;border-bottom: 1px solid #d6d6d6;border-left: 1px solid #d6d6d6;vertical-align: top;padding-top: 20px;color: #000; font-size: 12px;'>";
FinalTableHTML += (PurchProd.Quantity * PurchProd.PurchasePrice).ToString("C");
FinalTableHTML += "</td>";
FinalTableHTML += "</tr>";
NumberOfItems += PurchProd.Quantity;
}
//now html for the subtotal costs
FinalTableHTML += "<tr>";
FinalTableHTML += "<td style='text-align: right;padding-right: 10px;background-color: #f4f4f4;padding-bottom: 5px;padding-top: 5px; font-size: 12px;' colspan='3'>SUBTOTAL ( " + NumberOfItems;
if (NumberOfItems == 1)
{
FinalTableHTML += " item";
}
else
{
FinalTableHTML += " items";
}
FinalTableHTML += " ):</td>";
FinalTableHTML += "<td style='color: #000;text-align: right;padding-right: 20px;width: 105px;background-color: #f4f4f4;padding-bottom: 5px;padding-top: 5px; font-size: 12px;'>" + purchaseOrderDetails.PayPalOrderDetails.BaseAmount.ToString("C") + "</td>";
FinalTableHTML += "</tr>";
FinalTableHTML += "<tr>";
FinalTableHTML += "<td style='text-align: right;padding-right: 10px;background-color: #f4f4f4;padding-bottom: 5px;padding-top: 5px; font-size: 12px;' colspan='3'>TAX:</td>";
FinalTableHTML += "<td style='color: #000;text-align: right;padding-right: 20px;width: 105px;background-color: #f4f4f4;padding-bottom: 5px;padding-top: 5px; font-size: 12px;'>" + purchaseOrderDetails.PayPalOrderDetails.TaxAmount.ToString("C") + "</td>";
FinalTableHTML += "</tr>";
FinalTableHTML += "<tr>";
FinalTableHTML += "<td style='text-align: right;padding-right: 10px;background-color: #f4f4f4;padding-bottom: 5px;padding-top: 5px; font-size: 12px;' colspan='3'>S & H:</td>";
FinalTableHTML += "<td style='color: #000;text-align: right;padding-right: 20px;width: 105px;background-color: #f4f4f4;padding-bottom: 5px;padding-top: 5px; font-size: 12px;'>" + purchaseOrderDetails.PayPalOrderDetails.ShippingAmount.ToString("C") + "</td>";
FinalTableHTML += "</tr>";
FinalTableHTML += "<tr>";
FinalTableHTML += "<td style='text-align: right;padding-right: 10px;padding-bottom: 15px;padding-top: 15px;border-top: 1px solid #d6d6d6;background: #d9eefa;color: #2c5987;font-weight: bold;border-bottom: 1px solid #d6d6d6;' colspan='3'>GRAND TOTAL:</td>";
FinalTableHTML += "<td style='text-align: right;padding-right: 20px;width: 105px;padding-bottom: 15px;padding-top: 15px;border-top: 1px solid #d6d6d6;font: 24px Georgia, \"Times New Roman\", serif;background: #d9eefa;color: #2c5987;border-bottom: 1px solid #d6d6d6;'>" + (purchaseOrderDetails.PayPalOrderDetails.ShippingAmount + purchaseOrderDetails.PayPalOrderDetails.TaxAmount + purchaseOrderDetails.PayPalOrderDetails.BaseAmount).ToString("C") + "</td>";
FinalTableHTML += "</tr>";
}
FinalTableHTML += "</table>";
}
catch (Exception e)
{
CompanyCommons.Logging.WriteLog("Chimera.Emails.Ecommerce.GenerateOrderDetailsTable(): " + e.Message);
}
return FinalTableHTML;
}
/// <summary>
///
/// </summary>
/// <param name="purchaseOrderDetails">the order details</param>
/// <param name="customerEmailSettingName">the name of the email to use the customer should see</param>
/// <param name="emailSender">the email address that should be listed as the sender</param>
/// <param name="websiteTitle">The name of the website sending the email</param>
/// <returns></returns>
public static bool SendOrderShippedEmail(PurchaseOrderDetails purchaseOrderDetails, string customerEmailSettingName, string emailSender, string websiteTitle)
{
string EmailsSent = string.Empty;
try
{
Dictionary<string, string> ValuesToReplace = new Dictionary<string, string>();
ValuesToReplace.Add("[WEBSITE_TITLE]", websiteTitle);
ValuesToReplace.Add("[FIRSTNAME]", purchaseOrderDetails.PayPalOrderDetails.CustomerInfo.FirstName);
ValuesToReplace.Add("[LASTNAME]", purchaseOrderDetails.PayPalOrderDetails.CustomerInfo.LastName);
ValuesToReplace.Add("[ORDER_CONFIRM_NUMBER]", purchaseOrderDetails.Id);
ValuesToReplace.Add("[ORDER_DATE]", purchaseOrderDetails.PayPalOrderDetails.OrderPlacedDateUtc.ToString("g") + " UTC");
ValuesToReplace.Add("[ORDER_DETAILS_TABLE]", GenerateOrderDetailsTable(purchaseOrderDetails));
ValuesToReplace.Add("[SELECTED SHIPPING METHOD]", "<br/><br/>Your order is being shipped by: " + purchaseOrderDetails.PayPalOrderDetails.ShippingMethodType);
string TrackingLink = CompanyCommons.PhysicalShipping.GenerateTrackingLink(purchaseOrderDetails.PayPalOrderDetails.ShippingMethodType, purchaseOrderDetails.PayPalOrderDetails.ShippingTrackingNumber);
if(!string.IsNullOrWhiteSpace(TrackingLink))
{
TrackingLink = "<br/><br/>Click the link below to view shipping progress:<br/><br/><a href=\"" + TrackingLink + "\">" + TrackingLink + "</a>";
}
ValuesToReplace.Add("[TRACKING_NUMBER]", "<br/><br/>Tracking Number: " + purchaseOrderDetails.PayPalOrderDetails.ShippingTrackingNumber + TrackingLink);
CompanyCommons.Email.SendEmailBasedOnFile("CustomerOrderShipped_" + customerEmailSettingName + ".html", purchaseOrderDetails.PayPalOrderDetails.CustomerInfo.Email, emailSender, ValuesToReplace, null, EMAIL_MODULE_NAME);
}
catch (Exception e)
{
CompanyCommons.Logging.WriteLog("Chimera.Emails.Ecommerce.SendNewEcommerceEmails() Unable to send emails: " + e.Message);
}
return string.IsNullOrWhiteSpace(EmailsSent);
}
/// <summary>
/// Add a new customer order
/// </summary>
/// <param name="order">The order to save or update</param>
/// <returns>bool if successful</returns>
public static bool Save(PurchaseOrderDetails order)
{
return Execute.Save<PurchaseOrderDetails>(COLLECTION_NAME, order);
}
