public int AddBillingAddress(OrderDetailsCollection orderData, SqlTransaction tran, int addressID) { try { List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>(); parameter.Add(new KeyValuePair<string, object>("@AddressID", addressID)); parameter.Add(new KeyValuePair<string, object>("@IsDefault", orderData.ObjBillingAddressInfo.IsDefaultBilling)); parameter.Add(new KeyValuePair<string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair<string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair<string, object>("@CultureName", orderData.ObjCommonInfo.CultureName)); parameter.Add(new KeyValuePair<string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); SQLHandler sqlH = new SQLHandler(); int billingAddressID = sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_Aspx_UserBillingAddress", parameter, "@UserBillingAddressID"); return addressID; } catch (Exception ex) { throw ex; } }
public static void ParseIPN(int orderID, string transID, string status, int storeID, int portalID, string userName, int customerID, string sessionCode) { MoneybookersHandler ph = new MoneybookersHandler(); try { OrderDetailsCollection ot = new OrderDetailsCollection(); OrderDetailsInfo odinfo = new OrderDetailsInfo(); CartManageSQLProvider cms = new CartManageSQLProvider(); CommonInfo cf = new CommonInfo(); cf.StoreID = storeID; cf.PortalID = portalID; cf.AddedBy = userName; // UpdateOrderDetails AspxOrderDetails objad = new AspxOrderDetails(); SQLHandler sqlH = new SQLHandler(); // use split to split array we already have using "=" as delimiter // WcfSession ws = new WcfSession(); odinfo.OrderID = orderID;//ws.GetSessionVariable("OrderID"); odinfo.ResponseReasonText = status; odinfo.TransactionID = transID; ot.ObjOrderDetails = odinfo; ot.ObjCommonInfo = cf; odinfo.OrderStatusID = 8; objad.UpdateOrderDetails(ot); // UpdateItemQuantity } catch (Exception ex) { throw ex; } }
public void UpdateItemQuantity(OrderDetailsCollection orderData) { try { if (orderData.ObjOrderDetails.CouponCode != null && System.Web.HttpContext.Current.Session["CouponApplied"] != null) { ReduceCouponUsed(orderData.ObjOrderDetails.CouponCode.Trim(), orderData.ObjCommonInfo.StoreID, orderData.ObjCommonInfo.PortalID, orderData.ObjCommonInfo.AddedBy, orderData.ObjOrderDetails.OrderID); } foreach (OrderItemInfo objItems in orderData.LstOrderItemsInfo) { if (objItems.IsDownloadable != true) { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair <string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair <string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); parameter.Add(new KeyValuePair <string, object>("@ItemID", objItems.ItemID)); parameter.Add(new KeyValuePair <string, object>("@Quantity", objItems.Quantity)); parameter.Add(new KeyValuePair <string, object>("@OrderID", orderData.ObjOrderDetails.OrderID)); parameter.Add(new KeyValuePair <string, object>("@CostVariantsIDs", objItems.Variants)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("[dbo].[usp_Aspx_UpdateItemQuantitybyOrder]", parameter); } } } catch (Exception ex) { throw ex; } }
public void ParseIPN(int orderId, string transId, string status, int storeId, int portalId, string userName, int customerId, string sessionCode) { var ph = new PayPalHandler(); try { var ot = new OrderDetailsCollection(); var odinfo = new OrderDetailsInfo(); var cms = new CartManageSQLProvider(); var cf = new CommonInfo {StoreID = storeId, PortalID = portalId, AddedBy = userName}; // UpdateOrderDetails var sqlH = new SQLHandler(); // use split to split array we already have using "=" as delimiter // WcfSession ws = new WcfSession(); odinfo.OrderID = orderId;//ws.GetSessionVariable("OrderID"); odinfo.ResponseReasonText = status; odinfo.TransactionID = transId; ot.ObjOrderDetails = odinfo; ot.ObjCommonInfo = cf; odinfo.OrderStatusID = 8; AspxOrderController.UpdateOrderDetails(ot); } catch (Exception ex) { throw ex; } }
//single public void AddOrderItems(OrderDetailsCollection orderData, SqlTransaction tran, int orderID, int shippingAddressID) { try { foreach (OrderItemInfo objItems in orderData.LstOrderItemsInfo) { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("@OrderID", orderID)); parameter.Add(new KeyValuePair <string, object>("@UserShippingAddressID", shippingAddressID)); parameter.Add(new KeyValuePair <string, object>("@ShippingMethodID", objItems.ShippingMethodID)); parameter.Add(new KeyValuePair <string, object>("@ItemID", objItems.ItemID)); parameter.Add(new KeyValuePair <string, object>("@Price", objItems.Price)); parameter.Add(new KeyValuePair <string, object>("@Quantity", objItems.Quantity)); parameter.Add(new KeyValuePair <string, object>("@Weight", objItems.Weight)); parameter.Add(new KeyValuePair <string, object>("@Remarks", objItems.Remarks)); parameter.Add(new KeyValuePair <string, object>("@ShippingRate", objItems.ShippingRate)); parameter.Add(new KeyValuePair <string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair <string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair <string, object>("@CultureName", orderData.ObjCommonInfo.CultureName)); parameter.Add(new KeyValuePair <string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); parameter.Add(new KeyValuePair <string, object>("@CostVariants", objItems.Variants)); parameter.Add(new KeyValuePair <string, object>("@RewardedPoints", objItems.RewardedPoints)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[usp_Aspx_OrderItem]", parameter); } } catch (Exception ex) { throw ex; } }
public static PayPalHandler ParseIPN(int orderID, string transID, string status, int storeID, int portalID, string userName, int customerID, string sessionCode) { PayPalHandler ph = new PayPalHandler(); try { OrderDetailsCollection ot = new OrderDetailsCollection(); OrderDetailsInfo odinfo = new OrderDetailsInfo(); CartManageSQLProvider cms = new CartManageSQLProvider(); CommonInfo cf = new CommonInfo(); cf.StoreID = storeID; cf.PortalID = portalID; cf.AddedBy = userName; // UpdateOrderDetails AspxOrderDetails objad = new AspxOrderDetails(); SQLHandler sqlH = new SQLHandler(); // use split to split array we already have using "=" as delimiter // WcfSession ws = new WcfSession(); odinfo.OrderID = orderID;//ws.GetSessionVariable("OrderID"); odinfo.ResponseReasonText = status; odinfo.TransactionID = transID; ot.ObjOrderDetails = odinfo; ot.ObjCommonInfo = cf; odinfo.OrderStatusID = 8; objad.UpdateOrderDetails(ot); return(ph); } catch (Exception ex) { throw ex; } }
public int AddBillingAddress(OrderDetailsCollection orderData, OracleTransaction tran, int addressID) { try { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("AddressID", addressID)); parameter.Add(new KeyValuePair <string, object>("IsDefault", orderData.ObjBillingAddressInfo.IsDefaultBilling)); parameter.Add(new KeyValuePair <string, object>("StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair <string, object>("PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair <string, object>("CultureName", orderData.ObjCommonInfo.CultureName)); parameter.Add(new KeyValuePair <string, object>("AddedBy", orderData.ObjCommonInfo.AddedBy)); OracleHandler sqlH = new OracleHandler(); int billingAddressID = sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_Aspx_UserBillingAddress", parameter, "UserBillingAddressID"); return(addressID); } catch (Exception ex) { throw ex; } }
public static void UpdateItemQuantity(OrderDetailsCollection orderData) { try { if (orderData.Coupons.Count > 0) { foreach (var coupon in orderData.Coupons) { ReduceCouponUsed(coupon, orderData.ObjCommonInfo.StoreID, orderData.ObjCommonInfo.PortalID, orderData.ObjCommonInfo.AddedBy, orderData.ObjOrderDetails.OrderID); } } foreach (OrderItemInfo objItems in orderData.LstOrderItemsInfo) { if (objItems.IsDownloadable != true) { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair <string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair <string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); parameter.Add(new KeyValuePair <string, object>("@ItemID", objItems.ItemID)); parameter.Add(new KeyValuePair <string, object>("@Quantity", objItems.Quantity)); parameter.Add(new KeyValuePair <string, object>("@OrderID", orderData.ObjOrderDetails.OrderID)); parameter.Add(new KeyValuePair <string, object>("@CostVariantsIDs", objItems.Variants)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("[dbo].[usp_Aspx_UpdateItemQuantitybyOrder]", parameter); } } } catch (Exception e) { throw e; } }
public static int AddShippingAddress(OrderDetailsCollection orderData, SqlTransaction tran, int addressID) { try { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("@AddressID", addressID)); parameter.Add(new KeyValuePair <string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair <string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair <string, object>("@CultureName", orderData.ObjCommonInfo.CultureName)); parameter.Add(new KeyValuePair <string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); SQLHandler sqlH = new SQLHandler(); int shippingAddressID = sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_Aspx_UserShippingAddress", parameter, "@ShippingAddressID"); return(shippingAddressID); } catch (Exception e) { throw e; } }
public int AddOrder(OrderDetailsCollection orderData, SqlTransaction tran, int billingAddressID, int paymentMethodId) { try { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("@InvoiceNumber", orderData.ObjOrderDetails.InvoiceNumber)); if (orderData.ObjOrderDetails.CustomerID == 0) { parameter.Add(new KeyValuePair <string, object>("@SessionCode", orderData.ObjOrderDetails.SessionCode)); parameter.Add(new KeyValuePair <string, object>("@CustomerID", 0)); } else { parameter.Add(new KeyValuePair <string, object>("@SessionCode", "")); parameter.Add(new KeyValuePair <string, object>("@CustomerID", orderData.ObjOrderDetails.CustomerID)); } parameter.Add(new KeyValuePair <string, object>("@TransactionID", orderData.ObjOrderDetails.TransactionID)); parameter.Add(new KeyValuePair <string, object>("@GrandTotal", orderData.ObjOrderDetails.GrandTotal)); parameter.Add(new KeyValuePair <string, object>("@DiscountAmount", orderData.ObjOrderDetails.DiscountAmount)); parameter.Add(new KeyValuePair <string, object>("@CouponCode", orderData.ObjOrderDetails.CouponCode)); parameter.Add(new KeyValuePair <string, object>("@PurchaseOrderNumber", orderData.ObjOrderDetails.PurchaseOrderNumber)); parameter.Add(new KeyValuePair <string, object>("@PaymentGateTypeID", orderData.ObjOrderDetails.PaymentGatewayTypeID)); parameter.Add(new KeyValuePair <string, object>("@PaymentGateSubTypeID", orderData.ObjOrderDetails.PaymentGatewaySubTypeID)); parameter.Add(new KeyValuePair <string, object>("@ClientIPAddress", orderData.ObjOrderDetails.ClientIPAddress)); parameter.Add(new KeyValuePair <string, object>("@UserBillingAddressID", billingAddressID)); parameter.Add(new KeyValuePair <string, object>("@PaymentMethodID", paymentMethodId)); parameter.Add(new KeyValuePair <string, object>("@OrderStatusID", orderData.ObjOrderDetails.OrderStatusID)); parameter.Add(new KeyValuePair <string, object>("@IsGuestUser", orderData.ObjOrderDetails.IsGuestUser)); parameter.Add(new KeyValuePair <string, object>("@TaxTotal", orderData.ObjOrderDetails.TaxTotal)); parameter.Add(new KeyValuePair <string, object>("@CurrencyCode", orderData.ObjOrderDetails.CurrencyCode)); parameter.Add(new KeyValuePair <string, object>("@ResponseCode", orderData.ObjOrderDetails.ResponseCode)); parameter.Add(new KeyValuePair <string, object>("@ResponseReasonCode", orderData.ObjOrderDetails.ResponseReasonCode)); parameter.Add(new KeyValuePair <string, object>("@ResponseReasonText", orderData.ObjOrderDetails.ResponseReasonText)); parameter.Add(new KeyValuePair <string, object>("@Remarks", orderData.ObjOrderDetails.Remarks)); parameter.Add(new KeyValuePair <string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair <string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair <string, object>("@CultureName", orderData.ObjCommonInfo.CultureName)); parameter.Add(new KeyValuePair <string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); SQLHandler sqlH = new SQLHandler(); int orderID = sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[usp_Aspx_OrderDetails]", parameter, "@OrderID"); return(orderID); } catch (Exception ex) { throw ex; } }
//multiple public static void AddOrderItemsList(OrderDetailsCollection orderData, SqlTransaction tran, int orderID) { try { AspxOrderProvider.AddOrderItemsList(orderData, tran, orderID); } catch (Exception e) { throw e; } }
public static void UpdateItemQuantity(OrderDetailsCollection orderData) { try { AspxOrderProvider.UpdateItemQuantity(orderData); } catch (Exception e) { throw e; } }
//single public static void AddOrderItems(OrderDetailsCollection orderData, OracleTransaction tran, int orderID, int shippingAddressID) { try { AspxOrderProvider.AddOrderItems(orderData, tran, orderID, shippingAddressID); } catch (Exception e) { throw e; } }
public static int AddAddress(OrderDetailsCollection orderData, SqlTransaction tran) { try { int addressID = AspxOrderProvider.AddAddress(orderData, tran); return(addressID); } catch (Exception e) { throw e; } }
public static int AddShippingAddress(OrderDetailsCollection orderData, SqlTransaction tran) { try { int shippingAddressID = AspxOrderProvider.AddShippingAddress(orderData, tran); return shippingAddressID; } catch (Exception e) { throw e; } }
public static int AddPaymentInfo(OrderDetailsCollection orderData, SqlTransaction tran) { try { int paymentMethodID = AspxOrderProvider.AddPaymentInfo(orderData, tran); return paymentMethodID; } catch (Exception e) { throw e; } }
public static int AddBillingAddress(OrderDetailsCollection orderData, SqlTransaction tran, int addressID) { try { int billingAddressID = AspxOrderProvider.AddBillingAddress(orderData, tran, addressID); return billingAddressID; } catch (Exception e) { throw e; } }
public static int AddOrderWithMultipleCheckOut(OrderDetailsCollection orderData, OracleTransaction tran, int paymentMethodId) { try { int orderID = AspxOrderProvider.AddOrderWithMultipleCheckOut(orderData, tran, paymentMethodId); return(orderID); } catch (Exception e) { throw e; } }
public static int AddOrder(OrderDetailsCollection orderData, OracleTransaction tran, int billingAddressID, int paymentMethodId) { try { int orderID = AspxOrderProvider.AddOrder(orderData, tran, billingAddressID, paymentMethodId); return(orderID); } catch (Exception e) { throw e; } }
public static int AddShippingAddress(OrderDetailsCollection orderData, OracleTransaction tran) { try { int shippingAddressID = AspxOrderProvider.AddShippingAddress(orderData, tran); return(shippingAddressID); } catch (Exception e) { throw e; } }
public static int AddPaymentInfo(OrderDetailsCollection orderData, OracleTransaction tran) { try { int paymentMethodID = AspxOrderProvider.AddPaymentInfo(orderData, tran); return(paymentMethodID); } catch (Exception e) { throw e; } }
public static int AddBillingAddress(OrderDetailsCollection orderData, OracleTransaction tran, int addressID) { try { int billingAddressID = AspxOrderProvider.AddBillingAddress(orderData, tran, addressID); return(billingAddressID); } catch (Exception e) { throw e; } }
//single public static void AddOrderItems(OrderDetailsCollection orderData, SqlTransaction tran, int orderID, int shippingAddressID) { try { foreach (OrderItemInfo objItems in orderData.LstOrderItemsInfo) { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("@OrderID", orderID)); if (orderData.ObjOrderDetails.IsGuestUser) { parameter.Add(new KeyValuePair <string, object>("@UserShippingAddressID", shippingAddressID)); } else { parameter.Add(new KeyValuePair <string, object>("@UserShippingAddressID", objItems.ShippingAddressID > 0 ? shippingAddressID : 0)); } parameter.Add(new KeyValuePair <string, object>("@ShippingMethodID", objItems.ShippingMethodID)); parameter.Add(new KeyValuePair <string, object>("@ItemID", objItems.ItemID)); parameter.Add(new KeyValuePair <string, object>("@Price", objItems.Price)); parameter.Add(new KeyValuePair <string, object>("@Quantity", objItems.Quantity)); parameter.Add(new KeyValuePair <string, object>("@Weight", objItems.Weight)); parameter.Add(new KeyValuePair <string, object>("@Remarks", objItems.Remarks)); parameter.Add(new KeyValuePair <string, object>("@ShippingRate", objItems.ShippingRate)); parameter.Add(new KeyValuePair <string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair <string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair <string, object>("@CultureName", orderData.ObjCommonInfo.CultureName)); parameter.Add(new KeyValuePair <string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); parameter.Add(new KeyValuePair <string, object>("@CostVariants", objItems.Variants)); parameter.Add(new KeyValuePair <string, object>("@RewardedPoints", objItems.RewardedPoints)); //allow null parameter.Add(new KeyValuePair <string, object>("@KitDescription", objItems.KitDescription)); parameter.Add(new KeyValuePair <string, object>("@KitData", objItems.KitData)); //parameter.Add(new KeyValuePair<string, object>("@AddressID", orderData.ObjShippingAddressInfo.AddressID)); //parameter.Add(new KeyValuePair<string, object>("@Country", orderData.ObjShippingAddressInfo.Country)); //parameter.Add(new KeyValuePair<string, object>("@State", orderData.ObjShippingAddressInfo.State)); //parameter.Add(new KeyValuePair<string, object>("@zip", orderData.ObjShippingAddressInfo.Zip)); //parameter.Add(new KeyValuePair<string, object>("@CustmerID", orderData.ObjOrderDetails.CustomerID)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[usp_Aspx_OrderItem]", parameter); } } catch (Exception e) { throw e; } }
public static int AddOrderWithMultipleCheckOut(OrderDetailsCollection orderData, OracleTransaction tran, int paymentMethodId) { try { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("InvoiceNumber", orderData.ObjOrderDetails.InvoiceNumber)); parameter.Add(new KeyValuePair <string, object>("TransactionID", orderData.ObjOrderDetails.TransactionID)); parameter.Add(new KeyValuePair <string, object>("SessionCode", "")); parameter.Add(new KeyValuePair <string, object>("CustomerID", orderData.ObjOrderDetails.CustomerID)); parameter.Add(new KeyValuePair <string, object>("GrandTotal", orderData.ObjOrderDetails.GrandTotal)); parameter.Add(new KeyValuePair <string, object>("DiscountAmount", orderData.ObjOrderDetails.DiscountAmount)); parameter.Add(new KeyValuePair <string, object>("CouponDiscountAmount", orderData.ObjOrderDetails.CouponDiscountAmount)); string couponCode = String.Join(",", orderData.Coupons.Select(c => c.Key).ToList()); parameter.Add(new KeyValuePair <string, object>("CouponCode", couponCode)); parameter.Add(new KeyValuePair <string, object>("RewardDiscountAmount", orderData.ObjOrderDetails.RewardDiscountAmount)); parameter.Add(new KeyValuePair <string, object>("UsedRewardPoints", orderData.ObjOrderDetails.UsedRewardPoints)); parameter.Add(new KeyValuePair <string, object>("PurchaseOrderNumber", orderData.ObjOrderDetails.PurchaseOrderNumber)); parameter.Add(new KeyValuePair <string, object>("PaymentGateTypeID", orderData.ObjOrderDetails.PaymentGatewayTypeID)); parameter.Add(new KeyValuePair <string, object>("PaymentGateSubTypeID", orderData.ObjOrderDetails.PaymentGatewaySubTypeID)); parameter.Add(new KeyValuePair <string, object>("ClientIPAddress", orderData.ObjOrderDetails.ClientIPAddress)); parameter.Add(new KeyValuePair <string, object>("UserBillingAddressID", orderData.ObjOrderDetails.UserBillingAddressID)); parameter.Add(new KeyValuePair <string, object>("PaymentMethodID", paymentMethodId)); parameter.Add(new KeyValuePair <string, object>("OrderStatusID", orderData.ObjOrderDetails.OrderStatusID)); parameter.Add(new KeyValuePair <string, object>("IsGuestUser", "false")); parameter.Add(new KeyValuePair <string, object>("TaxTotal", orderData.ObjOrderDetails.TaxTotal)); parameter.Add(new KeyValuePair <string, object>("CurrencyCode", orderData.ObjOrderDetails.CurrencyCode)); parameter.Add(new KeyValuePair <string, object>("ResponseCode", orderData.ObjOrderDetails.ResponseCode)); parameter.Add(new KeyValuePair <string, object>("ResponseReasonCode", orderData.ObjOrderDetails.ResponseReasonCode)); parameter.Add(new KeyValuePair <string, object>("ResponseReasonText", orderData.ObjOrderDetails.ResponseReasonText)); parameter.Add(new KeyValuePair <string, object>("Remarks", orderData.ObjOrderDetails.Remarks)); parameter.Add(new KeyValuePair <string, object>("StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair <string, object>("PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair <string, object>("CultureName", orderData.ObjCommonInfo.CultureName)); parameter.Add(new KeyValuePair <string, object>("AddedBy", orderData.ObjCommonInfo.AddedBy)); OracleHandler sqlH = new OracleHandler(); int orderID = sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_Aspx_OrderDetails", parameter, "OrderID"); return(orderID); } catch (Exception e) { throw e; } }
public static string Parse(int orderId, string transId, string invoice, string POrderno, int responseCode, int responsereasonCode, string responsetext, AspxCommonInfo aspxCommonObj) { try { OrderDetailsCollection ot = new OrderDetailsCollection(); OrderDetailsInfo odinfo = new OrderDetailsInfo(); CartManageSQLProvider cms = new CartManageSQLProvider(); CommonInfo cf = new CommonInfo(); cf.StoreID = aspxCommonObj.StoreID; cf.PortalID = aspxCommonObj.PortalID; cf.AddedBy = aspxCommonObj.UserName; // UpdateOrderDetails odinfo.OrderID = orderId; odinfo.TransactionID = odinfo.ResponseCode.ToString(transId); odinfo.InvoiceNumber = Convert.ToString(invoice); odinfo.PurchaseOrderNumber = Convert.ToString(POrderno); odinfo.ResponseCode = Convert.ToInt32(responseCode); odinfo.ResponseReasonCode = Convert.ToInt32(responsereasonCode); odinfo.ResponseReasonText = Convert.ToString(responsetext); ot.ObjOrderDetails = odinfo; ot.ObjCommonInfo = cf; //GIFT CARD PURCHAGE PAYMENT COMPLETED odinfo.OrderStatusID = 3; AspxOrderController.UpdateOrderDetails(ot); if (HttpContext.Current.Session["OrderCollection"] != null) { var orderdata2 = new OrderDetailsCollection(); orderdata2 = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; AspxOrderController.UpdateItemQuantity(orderdata2); IssueGiftCard(orderdata2.LstOrderItemsInfo, orderId, true, aspxCommonObj); } HttpContext.Current.Session.Remove("OrderID"); cms.ClearCartAfterPayment(aspxCommonObj); return("This transaction has been approved"); } catch (Exception e) { throw e; } }
public static string Parse(string transId, string invoice, string POrderno, int responseCode, int responsereasonCode, string responsetext, int storeID, int portalID, string userName, int customerID, string sessionCode) { try { OrderDetailsCollection ot = new OrderDetailsCollection(); OrderDetailsInfo odinfo = new OrderDetailsInfo(); CartManageSQLProvider cms = new CartManageSQLProvider(); CommonInfo cf = new CommonInfo(); cf.StoreID = storeID; cf.PortalID = portalID; cf.AddedBy = userName; // UpdateOrderDetails AspxOrderDetails objad = new AspxOrderDetails(); SQLHandler sqlH = new SQLHandler(); WcfSession ws = new WcfSession(); odinfo.OrderID = ws.GetSessionVariable("OrderID"); odinfo.TransactionID = odinfo.ResponseCode.ToString(transId); odinfo.InvoiceNumber = Convert.ToString(invoice); odinfo.PurchaseOrderNumber = Convert.ToString(POrderno); odinfo.ResponseCode = Convert.ToInt32(responseCode); odinfo.ResponseReasonCode = Convert.ToInt32(responsereasonCode); odinfo.ResponseReasonText = Convert.ToString(responsetext); ot.ObjOrderDetails = odinfo; ot.ObjCommonInfo = cf; odinfo.OrderStatusID = 8; objad.UpdateOrderDetails(ot); if (HttpContext.Current.Session["OrderCollection"] != null) { OrderDetailsCollection orderdata2 = new OrderDetailsCollection(); orderdata2 = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; objad.UpdateItemQuantity(orderdata2); } ws.ClearSessionVariable("OrderID"); cms.ClearCartAfterPayment(customerID, sessionCode, storeID, portalID); return "This transaction has been approved"; } catch (Exception ex) { throw ex; } }
public int AddBillingAddress(OrderDetailsCollection orderData, OracleTransaction tran) { try { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("CustomerID", orderData.ObjOrderDetails.CustomerID)); parameter.Add(new KeyValuePair <string, object>("SessionCode", orderData.ObjOrderDetails.SessionCode)); parameter.Add(new KeyValuePair <string, object>("FirstName", orderData.ObjBillingAddressInfo.FirstName)); parameter.Add(new KeyValuePair <string, object>("LastName", orderData.ObjBillingAddressInfo.LastName)); parameter.Add(new KeyValuePair <string, object>("Email", orderData.ObjBillingAddressInfo.EmailAddress)); parameter.Add(new KeyValuePair <string, object>("Company", orderData.ObjBillingAddressInfo.CompanyName)); parameter.Add(new KeyValuePair <string, object>("Address1", orderData.ObjBillingAddressInfo.Address)); parameter.Add(new KeyValuePair <string, object>("Address2", orderData.ObjBillingAddressInfo.Address2)); parameter.Add(new KeyValuePair <string, object>("City", orderData.ObjBillingAddressInfo.City)); parameter.Add(new KeyValuePair <string, object>("State", orderData.ObjBillingAddressInfo.State)); parameter.Add(new KeyValuePair <string, object>("Country", orderData.ObjBillingAddressInfo.Country)); parameter.Add(new KeyValuePair <string, object>("Zip", orderData.ObjBillingAddressInfo.Zip)); parameter.Add(new KeyValuePair <string, object>("Phone", orderData.ObjBillingAddressInfo.Phone)); parameter.Add(new KeyValuePair <string, object>("Mobile", orderData.ObjBillingAddressInfo.Mobile)); parameter.Add(new KeyValuePair <string, object>("Fax", orderData.ObjBillingAddressInfo.Fax)); parameter.Add(new KeyValuePair <string, object>("WebSite", orderData.ObjBillingAddressInfo.WebSite)); parameter.Add(new KeyValuePair <string, object>("UserName", orderData.ObjBillingAddressInfo.EmailAddress)); parameter.Add(new KeyValuePair <string, object>("IsDefault", orderData.ObjBillingAddressInfo.IsDefaultBilling)); parameter.Add(new KeyValuePair <string, object>("StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair <string, object>("PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair <string, object>("CultureName", orderData.ObjCommonInfo.CultureName)); parameter.Add(new KeyValuePair <string, object>("AddedBy", orderData.ObjCommonInfo.AddedBy)); OracleHandler sqlH = new OracleHandler(); int billingAddressID = sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_Aspx_BillingAddress", parameter, "UserBillingAddressID"); return(billingAddressID); } catch (Exception ex) { throw ex; } }
public static string Parse(string transId, string invoice, string POrderno, int responseCode, int responsereasonCode, string responsetext, int storeID, int portalID, string userName, int customerID, string sessionCode) { try { OrderDetailsCollection ot = new OrderDetailsCollection(); OrderDetailsInfo odinfo = new OrderDetailsInfo(); CartManageSQLProvider cms = new CartManageSQLProvider(); CommonInfo cf = new CommonInfo(); cf.StoreID = storeID; cf.PortalID = portalID; cf.AddedBy = userName; // UpdateOrderDetails AspxOrderDetails objad = new AspxOrderDetails(); SQLHandler sqlH = new SQLHandler(); WcfSession ws = new WcfSession(); odinfo.OrderID = ws.GetSessionVariable("OrderID"); odinfo.TransactionID = odinfo.ResponseCode.ToString(transId); odinfo.InvoiceNumber = Convert.ToString(invoice); odinfo.PurchaseOrderNumber = Convert.ToString(POrderno); odinfo.ResponseCode = Convert.ToInt32(responseCode); odinfo.ResponseReasonCode = Convert.ToInt32(responsereasonCode); odinfo.ResponseReasonText = Convert.ToString(responsetext); ot.ObjOrderDetails = odinfo; ot.ObjCommonInfo = cf; odinfo.OrderStatusID = 8; objad.UpdateOrderDetails(ot); if (HttpContext.Current.Session["OrderCollection"] != null) { OrderDetailsCollection orderdata2 = new OrderDetailsCollection(); orderdata2 = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; objad.UpdateItemQuantity(orderdata2); } ws.ClearSessionVariable("OrderID"); cms.ClearCartAfterPayment(customerID, sessionCode, storeID, portalID); return("This transaction has been approved"); } catch (Exception ex) { throw ex; } }
public static int AddAddress(OrderDetailsCollection orderData, SqlTransaction tran) { try { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("@FirstName", orderData.ObjBillingAddressInfo.FirstName)); parameter.Add(new KeyValuePair <string, object>("@LastName", orderData.ObjBillingAddressInfo.LastName)); parameter.Add(new KeyValuePair <string, object>("@CustomerID", orderData.ObjOrderDetails.CustomerID)); parameter.Add(new KeyValuePair <string, object>("@SessionCode", orderData.ObjOrderDetails.SessionCode)); parameter.Add(new KeyValuePair <string, object>("@Email", orderData.ObjBillingAddressInfo.EmailAddress)); parameter.Add(new KeyValuePair <string, object>("@Company", orderData.ObjBillingAddressInfo.CompanyName)); parameter.Add(new KeyValuePair <string, object>("@Address1", orderData.ObjBillingAddressInfo.Address)); parameter.Add(new KeyValuePair <string, object>("@Address2", orderData.ObjBillingAddressInfo.Address2)); parameter.Add(new KeyValuePair <string, object>("@City", orderData.ObjBillingAddressInfo.City)); parameter.Add(new KeyValuePair <string, object>("@State", orderData.ObjBillingAddressInfo.State)); parameter.Add(new KeyValuePair <string, object>("@Country", orderData.ObjBillingAddressInfo.Country)); parameter.Add(new KeyValuePair <string, object>("@Zip", orderData.ObjBillingAddressInfo.Zip)); parameter.Add(new KeyValuePair <string, object>("@Phone", orderData.ObjBillingAddressInfo.Phone)); parameter.Add(new KeyValuePair <string, object>("@Mobile", orderData.ObjBillingAddressInfo.Mobile)); parameter.Add(new KeyValuePair <string, object>("@Fax", orderData.ObjBillingAddressInfo.Fax)); parameter.Add(new KeyValuePair <string, object>("@UserName", orderData.ObjBillingAddressInfo.EmailAddress)); parameter.Add(new KeyValuePair <string, object>("@WebSite", orderData.ObjBillingAddressInfo.WebSite)); parameter.Add(new KeyValuePair <string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair <string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair <string, object>("@CultureName", orderData.ObjCommonInfo.CultureName)); parameter.Add(new KeyValuePair <string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); SQLHandler sqlH = new SQLHandler(); int addressID = sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_Aspx_UserAddress", parameter, "@AddressID"); return(addressID); } catch (Exception e) { throw e; } }
public int AddAddress(OrderDetailsCollection orderData, SqlTransaction tran) { try { List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>(); parameter.Add(new KeyValuePair<string, object>("@FirstName", orderData.ObjBillingAddressInfo.FirstName)); parameter.Add(new KeyValuePair<string, object>("@LastName", orderData.ObjBillingAddressInfo.LastName)); parameter.Add(new KeyValuePair<string, object>("@CustomerID", orderData.ObjOrderDetails.CustomerID)); parameter.Add(new KeyValuePair<string, object>("@SessionCode", orderData.ObjOrderDetails.SessionCode)); parameter.Add(new KeyValuePair<string, object>("@Email", orderData.ObjBillingAddressInfo.EmailAddress)); parameter.Add(new KeyValuePair<string, object>("@Company", orderData.ObjBillingAddressInfo.CompanyName)); parameter.Add(new KeyValuePair<string, object>("@Address1", orderData.ObjBillingAddressInfo.Address)); parameter.Add(new KeyValuePair<string, object>("@Address2", orderData.ObjBillingAddressInfo.Address2)); parameter.Add(new KeyValuePair<string, object>("@City", orderData.ObjBillingAddressInfo.City)); parameter.Add(new KeyValuePair<string, object>("@State", orderData.ObjBillingAddressInfo.State)); parameter.Add(new KeyValuePair<string, object>("@Country", orderData.ObjBillingAddressInfo.Country)); parameter.Add(new KeyValuePair<string, object>("@Zip", orderData.ObjBillingAddressInfo.Zip)); parameter.Add(new KeyValuePair<string, object>("@Phone", orderData.ObjBillingAddressInfo.Phone)); parameter.Add(new KeyValuePair<string, object>("@Mobile", orderData.ObjBillingAddressInfo.Mobile)); parameter.Add(new KeyValuePair<string, object>("@Fax", orderData.ObjBillingAddressInfo.Fax)); parameter.Add(new KeyValuePair<string, object>("@UserName", orderData.ObjBillingAddressInfo.EmailAddress)); parameter.Add(new KeyValuePair<string, object>("@WebSite", orderData.ObjBillingAddressInfo.WebSite)); parameter.Add(new KeyValuePair<string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair<string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair<string, object>("@CultureName", orderData.ObjCommonInfo.CultureName)); parameter.Add(new KeyValuePair<string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); SQLHandler sqlH = new SQLHandler(); int addressID = sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_Aspx_UserAddress", parameter, "@AddressID"); return addressID; } catch (Exception ex) { throw ex; } }
public static void UpdateOrderDetails(OrderDetailsCollection orderData) { try { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("@TransactionID", orderData.ObjOrderDetails.TransactionID)); parameter.Add(new KeyValuePair <string, object>("@OrderStatusID", orderData.ObjOrderDetails.OrderStatusID)); parameter.Add(new KeyValuePair <string, object>("@ResponseCode", orderData.ObjOrderDetails.ResponseCode)); parameter.Add(new KeyValuePair <string, object>("@ResponseReasonCode", orderData.ObjOrderDetails.ResponseReasonCode)); parameter.Add(new KeyValuePair <string, object>("@ResponseReasonText", orderData.ObjOrderDetails.ResponseReasonText)); parameter.Add(new KeyValuePair <string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair <string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair <string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); parameter.Add(new KeyValuePair <string, object>("@OrderID", orderData.ObjOrderDetails.OrderID)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("[dbo].[usp_Aspx_UpdateOrderDetails]", parameter); } catch (Exception e) { throw e; } }
public static string ParseForMobile(string transId, OrderInfo orderInfo, string POrderno, int responseCode, int responsereasonCode, string responsetext) { try { var ot = new OrderDetailsCollection(); var odinfo = new OrderDetailsInfo(); var cms = new CartManageSQLProvider(); var cf = new CommonInfo {StoreID = orderInfo.StoreId, PortalID = orderInfo.PortalId, AddedBy = orderInfo.AddedBy}; // UpdateOrderDetails odinfo.OrderID = orderInfo.OrderId; odinfo.TransactionID = odinfo.ResponseCode.ToString(transId); odinfo.InvoiceNumber = orderInfo.InvoiceNumber; odinfo.PurchaseOrderNumber = Convert.ToString(POrderno); odinfo.ResponseCode = Convert.ToInt32(responseCode); odinfo.ResponseReasonCode = Convert.ToInt32(responsereasonCode); odinfo.ResponseReasonText = Convert.ToString(responsetext); ot.ObjOrderDetails = odinfo; ot.ObjCommonInfo = cf; odinfo.OrderStatusID = 8; AspxOrderController.UpdateOrderDetails(ot); AspxCommonInfo aspxCommonObj = new AspxCommonInfo(); aspxCommonObj.CustomerID = orderInfo.CustomerId; aspxCommonObj.SessionCode = orderInfo.SessionCode; aspxCommonObj.StoreID = orderInfo.StoreId; aspxCommonObj.PortalID = orderInfo.PortalId; cms.ClearCartAfterPayment(aspxCommonObj); return "This transaction has been approved"; } catch (Exception ex) { throw ex; } }
public void UpdateOrderDetails(OrderDetailsCollection orderData) { try { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); // parameter.Add(new KeyValuePair<string, object>("@InvoiceNumber", DateTime.Now.ToString("yyyyMMddhhmmss"))); parameter.Add(new KeyValuePair <string, object>("TransactionID", orderData.ObjOrderDetails.TransactionID)); parameter.Add(new KeyValuePair <string, object>("OrderStatusID", orderData.ObjOrderDetails.OrderStatusID)); parameter.Add(new KeyValuePair <string, object>("ResponseCode", orderData.ObjOrderDetails.ResponseCode)); parameter.Add(new KeyValuePair <string, object>("ResponseReasonCode", orderData.ObjOrderDetails.ResponseReasonCode)); parameter.Add(new KeyValuePair <string, object>("ResponseReasonText", orderData.ObjOrderDetails.ResponseReasonText)); parameter.Add(new KeyValuePair <string, object>("StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair <string, object>("PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair <string, object>("AddedBy", orderData.ObjCommonInfo.AddedBy)); parameter.Add(new KeyValuePair <string, object>("OrderID", orderData.ObjOrderDetails.OrderID)); OracleHandler sqlH = new OracleHandler(); sqlH.ExecuteNonQuery("usp_Aspx_UpdateOrderDetails", parameter); } catch (Exception ex) { throw ex; } }
public static string Parse(string transId, string invoice, string POrderno, int responseCode, int responsereasonCode, string responsetext, AspxCommonInfo aspxCommonObj) { try { var ot = new OrderDetailsCollection(); var odinfo = new OrderDetailsInfo(); var cms = new CartManageSQLProvider(); var cf = new CommonInfo {StoreID = aspxCommonObj.StoreID, PortalID = aspxCommonObj.PortalID, AddedBy = aspxCommonObj.UserName}; // UpdateOrderDetails odinfo.OrderID =int.Parse(HttpContext.Current.Session["OrderID"].ToString()); odinfo.TransactionID = odinfo.ResponseCode.ToString(transId); odinfo.InvoiceNumber = Convert.ToString(invoice); odinfo.PurchaseOrderNumber = Convert.ToString(POrderno); odinfo.ResponseCode = Convert.ToInt32(responseCode); odinfo.ResponseReasonCode = Convert.ToInt32(responsereasonCode); odinfo.ResponseReasonText = Convert.ToString(responsetext); ot.ObjOrderDetails = odinfo; ot.ObjCommonInfo = cf; odinfo.OrderStatusID = 8; AspxOrderController.UpdateOrderDetails(ot); if (HttpContext.Current.Session["OrderCollection"] != null) { var orderdata2 = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; AspxOrderController.UpdateItemQuantity(orderdata2); } HttpContext.Current.Session.Remove("OrderID"); cms.ClearCartAfterPayment(aspxCommonObj); return "This transaction has been approved"; } catch (Exception ex) { throw ex; } }
public int AddOrderDetails(OrderDetailsCollection orderData) { SQLHandler sqlH = new SQLHandler(); SqlTransaction tran; tran = (SqlTransaction)sqlH.GetTransaction(); //AspxCommerceSession sn = new AspxCommerceSession(); orderData.Coupons = CheckOutSessions.Get<List<CouponSession>>("CouponSession"); if (orderData.ObjOrderDetails.InvoiceNumber == null || orderData.ObjOrderDetails.InvoiceNumber == "") { orderData.ObjOrderDetails.InvoiceNumber = DateTime.Now.ToString("yyyyMMddhhmmss"); } try { int billingAddressID = 0; int shippingAddressId = 0; int orderID = 0; if (orderData.ObjOrderDetails.IsMultipleCheckOut == false) { if (int.Parse(orderData.ObjBillingAddressInfo.AddressID) == 0 && int.Parse(orderData.ObjShippingAddressInfo.AddressID) == 0) { billingAddressID = AspxOrderController.AddBillingAddress(orderData, tran); if (!orderData.ObjOrderDetails.IsShippingAddressRequired) { shippingAddressId = AspxOrderController.AddShippingAddress(orderData, tran); } } else { billingAddressID = AspxOrderController.AddBillingAddress(orderData, tran, int.Parse(orderData.ObjBillingAddressInfo.AddressID)); if (!orderData.ObjOrderDetails.IsDownloadable && !orderData.ObjOrderDetails.IsShippingAddressRequired) { shippingAddressId = AspxOrderController.AddShippingAddress(orderData, tran, int.Parse(orderData.ObjShippingAddressInfo.AddressID)); } } } int paymentMethodID = AspxOrderController.AddPaymentInfo(orderData, tran); if (billingAddressID > 0) { orderID = AspxOrderController.AddOrder(orderData, tran, billingAddressID, paymentMethodID); //sn.SetSessionVariable("OrderID", orderID); SetSessionVariable("OrderID", orderID); orderData.ObjOrderDetails.OrderID = orderID; SetSessionVariable("OrderCollection", orderData); } else { orderID = AspxOrderController.AddOrderWithMultipleCheckOut(orderData, tran, paymentMethodID); //sn.SetSessionVariable("OrderID", orderID); SetSessionVariable("OrderID", orderID); orderData.ObjOrderDetails.OrderID = orderID; SetSessionVariable("OrderCollection", orderData); } foreach (OrderTaxInfo item in orderData.ObjOrderTaxInfo) { int itemID = item.ItemID; int taxManageRuleID = item.TaxManageRuleID; decimal taxSubTotal = item.TaxSubTotal; int storeID = item.StoreID; int portalID = item.PortalID; string addedBy = item.AddedBy; string costVariantValueIDs = item.CostVariantsValueIDs; OrderTaxRuleMapping(itemID, orderID, taxManageRuleID, taxSubTotal, storeID, portalID, addedBy, costVariantValueIDs); } if (shippingAddressId > 0) AspxOrderController.AddOrderItems(orderData, tran, orderID, shippingAddressId); else AspxOrderController.AddOrderItemsList(orderData, tran, orderID); //add every paymentgateway // GiftCardController.IssueGiftCard(orderData.LstOrderItemsInfo, orderData.ObjCommonInfo.StoreID, // orderData.ObjCommonInfo.PortalID,orderData.ObjCommonInfo.AddedBy, orderData.ObjCommonInfo.CultureName); tran.Commit(); return orderID; } catch (SqlException sqlEX) { throw new ArgumentException(sqlEX.Message); } catch (Exception ex) { tran.Rollback(); throw ex; } }
public int SaveOrderDetails(OrderDetailsCollection orderDetail) { try { if (orderDetail.ObjOrderDetails.OrderStatusID == 0) orderDetail.ObjOrderDetails.OrderStatusID = 7; int orderID = AddOrderDetails(orderDetail); return orderID; } catch (Exception ex) { throw ex; } }
public static int AddOrder(OrderDetailsCollection orderData, SqlTransaction tran, int billingAddressID, int paymentMethodId) { try { int orderID = AspxOrderProvider.AddOrder(orderData, tran, billingAddressID, paymentMethodId); return orderID; } catch (Exception e) { throw e; } }
public void ParseAfterIPN(string postData, AspxCommonInfo aspxCommonObj, string templateName, string addressPath) { var ph = new PayPalHandler(); string transId = string.Empty; string orderStatus = string.Empty; try { //split response into string array using whitespace delimeter String[] stringArray = postData.Split('\n'); // NOTE: /* * loop is set to start at 1 rather than 0 because first string in array will be single word SUCCESS or FAIL Only used to verify post data */ var ot = new OrderDetailsCollection(); var odinfo = new OrderDetailsInfo(); var cms = new CartManageSQLProvider(); var cf = new CommonInfo {StoreID = aspxCommonObj.StoreID, PortalID = aspxCommonObj.PortalID, AddedBy = aspxCommonObj.UserName}; // UpdateOrderDetails var sqlH = new SQLHandler(); // use split to split array we already have using "=" as delimiter int i; for (i = 1; i < stringArray.Length - 1; i++) { String[] stringArray1 = stringArray[i].Split('='); String sKey = stringArray1[0]; String sValue = HttpUtility.UrlDecode(stringArray1[1]); // set string vars to hold variable names using a switch switch (sKey) { case "payment_status": odinfo.ResponseReasonText = Convert.ToString(sValue); orderStatus = Convert.ToString(sValue); break; case "mc_fee": // ph.PaymentFee = Convert.ToDouble(sValue); break; case "payer_email": // ph.PayerEmail = Convert.ToString(sValue); break; case "Tx Token": // ph.TxToken = Convert.ToString(sValue); break; case "txn_id": odinfo.TransactionID = Convert.ToString(sValue); transId = Convert.ToString(sValue); break; } } ot.ObjCommonInfo = cf; //odinfo.OrderStatusID = 8; //objad.UpdateOrderDetails(ot); if (odinfo.ResponseReasonText.ToLower().Trim() == "completed") { if (HttpContext.Current.Session["OrderCollection"] != null) { var orderdata2 = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; AspxOrderController.UpdateItemQuantity(orderdata2); } } cms.ClearCartAfterPayment(aspxCommonObj); //invoice transID if (HttpContext.Current.Session["OrderCollection"] != null) { var orderdata = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; orderdata.ObjOrderDetails.OrderStatus = orderStatus; EmailTemplate.SendEmailForOrder(aspxCommonObj.PortalID, orderdata, addressPath, templateName, transId); } HttpContext.Current.Session.Remove("OrderCollection"); } catch (Exception ex) { throw ex; } }
public int AddPaymentInfo(OrderDetailsCollection orderData, SqlTransaction tran) { try { List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>(); parameter.Add(new KeyValuePair<string, object>("@PaymentMethodName", orderData.ObjPaymentInfo.PaymentMethodName)); parameter.Add(new KeyValuePair<string, object>("@PaymentMethodCode", orderData.ObjPaymentInfo.PaymentMethodCode)); if (orderData.ObjPaymentInfo.PaymentMethodCode == "CC") { parameter.Add(new KeyValuePair<string, object>("@CardNumber", orderData.ObjPaymentInfo.CardNumber)); parameter.Add(new KeyValuePair<string, object>("@TransactionType", orderData.ObjPaymentInfo.TransactionType)); parameter.Add(new KeyValuePair<string, object>("@CardType", orderData.ObjPaymentInfo.CardType)); parameter.Add(new KeyValuePair<string, object>("@CardCode", orderData.ObjPaymentInfo.CardCode)); parameter.Add(new KeyValuePair<string, object>("@ExpireDate", orderData.ObjPaymentInfo.ExpireDate)); parameter.Add(new KeyValuePair<string, object>("@AccountNumber", "")); parameter.Add(new KeyValuePair<string, object>("@RoutingNumber", "")); parameter.Add(new KeyValuePair<string, object>("@AccountType", "")); parameter.Add(new KeyValuePair<string, object>("@BankName", "")); parameter.Add(new KeyValuePair<string, object>("@AccountHolderName", "")); parameter.Add(new KeyValuePair<string, object>("@ChequeType", "")); parameter.Add(new KeyValuePair<string, object>("@ChequeNumber", "")); parameter.Add(new KeyValuePair<string, object>("@RecurringBillingStatus", false)); } else if (orderData.ObjPaymentInfo.PaymentMethodCode == "ECHECK") { parameter.Add(new KeyValuePair<string, object>("@CardNumber", "")); parameter.Add(new KeyValuePair<string, object>("@TransactionType", "")); parameter.Add(new KeyValuePair<string, object>("@CardType", "")); parameter.Add(new KeyValuePair<string, object>("@CardCode", "")); parameter.Add(new KeyValuePair<string, object>("@ExpireDate", "")); parameter.Add(new KeyValuePair<string, object>("@AccountNumber", orderData.ObjPaymentInfo.AccountNumber)); parameter.Add(new KeyValuePair<string, object>("@RoutingNumber", orderData.ObjPaymentInfo.RoutingNumber)); parameter.Add(new KeyValuePair<string, object>("@AccountType", orderData.ObjPaymentInfo.AccountType)); parameter.Add(new KeyValuePair<string, object>("@BankName", orderData.ObjPaymentInfo.BankName)); parameter.Add(new KeyValuePair<string, object>("@AccountHolderName", orderData.ObjPaymentInfo.AccountHolderName)); parameter.Add(new KeyValuePair<string, object>("@ChequeType", orderData.ObjPaymentInfo.ChequeType)); parameter.Add(new KeyValuePair<string, object>("@ChequeNumber", orderData.ObjPaymentInfo.ChequeNumber)); parameter.Add(new KeyValuePair<string, object>("@RecurringBillingStatus", orderData.ObjPaymentInfo.RecurringBillingStatus)); } else { parameter.Add(new KeyValuePair<string, object>("@CardNumber", "")); parameter.Add(new KeyValuePair<string, object>("@TransactionType", "")); parameter.Add(new KeyValuePair<string, object>("@CardType", "")); parameter.Add(new KeyValuePair<string, object>("@CardCode", "")); parameter.Add(new KeyValuePair<string, object>("@ExpireDate", "")); parameter.Add(new KeyValuePair<string, object>("@AccountNumber", "")); parameter.Add(new KeyValuePair<string, object>("@RoutingNumber", "")); parameter.Add(new KeyValuePair<string, object>("@AccountType", "")); parameter.Add(new KeyValuePair<string, object>("@BankName", "")); parameter.Add(new KeyValuePair<string, object>("@AccountHolderName", "")); parameter.Add(new KeyValuePair<string, object>("@ChequeType", "")); parameter.Add(new KeyValuePair<string, object>("@ChequeNumber", "")); parameter.Add(new KeyValuePair<string, object>("@RecurringBillingStatus", orderData.ObjPaymentInfo.RecurringBillingStatus)); } parameter.Add(new KeyValuePair<string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair<string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair<string, object>("@CultureName", orderData.ObjCommonInfo.CultureName)); parameter.Add(new KeyValuePair<string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); SQLHandler sqlH = new SQLHandler(); int paymentMethodID = sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[usp_Aspx_PaymentInfo]", parameter, "@PaymentMethodID"); return paymentMethodID; } catch (Exception ex) { throw ex; } }
public static int AddPaymentInfo(OrderDetailsCollection orderData, SqlTransaction tran) { try { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("@PaymentMethodName", orderData.ObjPaymentInfo.PaymentMethodName)); parameter.Add(new KeyValuePair <string, object>("@PaymentMethodCode", orderData.ObjPaymentInfo.PaymentMethodCode)); if (orderData.ObjPaymentInfo.PaymentMethodCode == "CC") { parameter.Add(new KeyValuePair <string, object>("@CardNumber", orderData.ObjPaymentInfo.CardNumber)); parameter.Add(new KeyValuePair <string, object>("@TransactionType", orderData.ObjPaymentInfo.TransactionType)); parameter.Add(new KeyValuePair <string, object>("@CardType", orderData.ObjPaymentInfo.CardType)); parameter.Add(new KeyValuePair <string, object>("@CardCode", orderData.ObjPaymentInfo.CardCode)); parameter.Add(new KeyValuePair <string, object>("@ExpireDate", orderData.ObjPaymentInfo.ExpireDate)); parameter.Add(new KeyValuePair <string, object>("@AccountNumber", "")); parameter.Add(new KeyValuePair <string, object>("@RoutingNumber", "")); parameter.Add(new KeyValuePair <string, object>("@AccountType", "")); parameter.Add(new KeyValuePair <string, object>("@BankName", "")); parameter.Add(new KeyValuePair <string, object>("@AccountHolderName", "")); parameter.Add(new KeyValuePair <string, object>("@ChequeType", "")); parameter.Add(new KeyValuePair <string, object>("@ChequeNumber", "")); parameter.Add(new KeyValuePair <string, object>("@RecurringBillingStatus", false)); } else if (orderData.ObjPaymentInfo.PaymentMethodCode == "ECHECK") { parameter.Add(new KeyValuePair <string, object>("@CardNumber", "")); parameter.Add(new KeyValuePair <string, object>("@TransactionType", "")); parameter.Add(new KeyValuePair <string, object>("@CardType", "")); parameter.Add(new KeyValuePair <string, object>("@CardCode", "")); parameter.Add(new KeyValuePair <string, object>("@ExpireDate", "")); parameter.Add(new KeyValuePair <string, object>("@AccountNumber", orderData.ObjPaymentInfo.AccountNumber)); parameter.Add(new KeyValuePair <string, object>("@RoutingNumber", orderData.ObjPaymentInfo.RoutingNumber)); parameter.Add(new KeyValuePair <string, object>("@AccountType", orderData.ObjPaymentInfo.AccountType)); parameter.Add(new KeyValuePair <string, object>("@BankName", orderData.ObjPaymentInfo.BankName)); parameter.Add(new KeyValuePair <string, object>("@AccountHolderName", orderData.ObjPaymentInfo.AccountHolderName)); parameter.Add(new KeyValuePair <string, object>("@ChequeType", orderData.ObjPaymentInfo.ChequeType)); parameter.Add(new KeyValuePair <string, object>("@ChequeNumber", orderData.ObjPaymentInfo.ChequeNumber)); parameter.Add(new KeyValuePair <string, object>("@RecurringBillingStatus", orderData.ObjPaymentInfo.RecurringBillingStatus)); } else { parameter.Add(new KeyValuePair <string, object>("@CardNumber", "")); parameter.Add(new KeyValuePair <string, object>("@TransactionType", "")); parameter.Add(new KeyValuePair <string, object>("@CardType", "")); parameter.Add(new KeyValuePair <string, object>("@CardCode", "")); parameter.Add(new KeyValuePair <string, object>("@ExpireDate", "")); parameter.Add(new KeyValuePair <string, object>("@AccountNumber", "")); parameter.Add(new KeyValuePair <string, object>("@RoutingNumber", "")); parameter.Add(new KeyValuePair <string, object>("@AccountType", "")); parameter.Add(new KeyValuePair <string, object>("@BankName", "")); parameter.Add(new KeyValuePair <string, object>("@AccountHolderName", "")); parameter.Add(new KeyValuePair <string, object>("@ChequeType", "")); parameter.Add(new KeyValuePair <string, object>("@ChequeNumber", "")); parameter.Add(new KeyValuePair <string, object>("@RecurringBillingStatus", orderData.ObjPaymentInfo.RecurringBillingStatus)); } parameter.Add(new KeyValuePair <string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair <string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair <string, object>("@CultureName", orderData.ObjCommonInfo.CultureName)); parameter.Add(new KeyValuePair <string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); SQLHandler sqlH = new SQLHandler(); int paymentMethodID = sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[usp_Aspx_PaymentInfo]", parameter, "@PaymentMethodID"); return(paymentMethodID); } catch (Exception e) { throw e; } }
public void AddOrderDetails(OrderDetailsCollection OrderData) { SQLHandler sqlH = new SQLHandler(); SqlTransaction tran; tran = (SqlTransaction)sqlH.GetTransaction(); WcfSession sn = new WcfSession(); try { AspxOrderDetails ObjOrderDetails = new AspxOrderDetails(); int billingAddressID = 0; int shippingAddressId = 0; int orderID = 0; if (OrderData.ObjOrderDetails.IsMultipleCheckOut == false) { if (OrderData.ObjBillingAddressInfo.IsBillingAsShipping == true) { if (int.Parse(OrderData.ObjBillingAddressInfo.AddressID) == 0 && int.Parse(OrderData.ObjShippingAddressInfo.AddressID) == 0) { int addressID = ObjOrderDetails.AddAddress(OrderData, tran); billingAddressID = ObjOrderDetails.AddBillingAddress(OrderData, tran, addressID); shippingAddressId = ObjOrderDetails.AddShippingAddress(OrderData, tran, addressID); } } else { if (int.Parse(OrderData.ObjBillingAddressInfo.AddressID) == 0) billingAddressID = ObjOrderDetails.AddBillingAddress(OrderData, tran); if (int.Parse(OrderData.ObjShippingAddressInfo.AddressID) == 0) shippingAddressId = ObjOrderDetails.AddShippingAddress(OrderData, tran); } } int paymentMethodID = ObjOrderDetails.AddPaymentInfo(OrderData, tran); if (billingAddressID > 0) { orderID = ObjOrderDetails.AddOrder(OrderData, tran, billingAddressID, paymentMethodID); sn.SetSessionVariable("OrderID", orderID); } else { orderID = ObjOrderDetails.AddOrderWithMultipleCheckOut(OrderData, tran, paymentMethodID); sn.SetSessionVariable("OrderID", orderID); } if (shippingAddressId > 0) ObjOrderDetails.AddOrderItems(OrderData, tran, orderID, shippingAddressId); else ObjOrderDetails.AddOrderItemsList(OrderData, tran, orderID); tran.Commit(); } catch (SqlException sqlEX) { throw new ArgumentException(sqlEX.Message); } catch (Exception ex) { tran.Rollback(); throw ex; } }
//single public void AddOrderItems(OrderDetailsCollection orderData, SqlTransaction tran,int orderID,int shippingAddressID) { try { foreach (OrderItemInfo objItems in orderData.LstOrderItemsInfo) { List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>(); parameter.Add(new KeyValuePair<string, object>("@OrderID", orderID)); parameter.Add(new KeyValuePair<string, object>("@UserShippingAddressID", shippingAddressID)); parameter.Add(new KeyValuePair<string, object>("@ShippingMethodID", objItems.ShippingMethodID)); parameter.Add(new KeyValuePair<string, object>("@ItemID", objItems.ItemID)); parameter.Add(new KeyValuePair<string, object>("@Price", objItems.Price)); parameter.Add(new KeyValuePair<string, object>("@Quantity", objItems.Quantity)); parameter.Add(new KeyValuePair<string, object>("@Weight", objItems.Weight)); parameter.Add(new KeyValuePair<string, object>("@Remarks", objItems.Remarks)); parameter.Add(new KeyValuePair<string, object>("@ShippingRate", objItems.ShippingRate)); parameter.Add(new KeyValuePair<string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair<string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair<string, object>("@CultureName", orderData.ObjCommonInfo.CultureName)); parameter.Add(new KeyValuePair<string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); parameter.Add(new KeyValuePair<string, object>("@CostVariants", objItems.Variants)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[usp_Aspx_OrderItem]", parameter); } } catch (Exception ex) { throw ex; } }
//single public static void AddOrderItems(OrderDetailsCollection orderData, SqlTransaction tran, int orderID, int shippingAddressID) { try { AspxOrderProvider.AddOrderItems(orderData, tran, orderID, shippingAddressID); } catch (Exception e) { throw e; } }
public void AddOrderDetails(OrderDetailsCollection orderData) { SQLHandler sqlH = new SQLHandler(); SqlTransaction tran; tran = (SqlTransaction)sqlH.GetTransaction(); //AspxCommerceSession sn = new AspxCommerceSession(); if (orderData.ObjOrderDetails.InvoiceNumber == null || orderData.ObjOrderDetails.InvoiceNumber == "") { orderData.ObjOrderDetails.InvoiceNumber = DateTime.Now.ToString("yyyyMMddhhmmss"); } try { AspxOrderDetails ObjOrderDetails = new AspxOrderDetails(); int billingAddressID = 0; int shippingAddressId = 0; int orderID = 0; if (orderData.ObjOrderDetails.IsMultipleCheckOut == false) { if (orderData.ObjBillingAddressInfo.IsBillingAsShipping == true) { if (int.Parse(orderData.ObjBillingAddressInfo.AddressID) == 0 && int.Parse(orderData.ObjShippingAddressInfo.AddressID) == 0) { int addressID = ObjOrderDetails.AddAddress(orderData, tran); billingAddressID = ObjOrderDetails.AddBillingAddress(orderData, tran, addressID); shippingAddressId = ObjOrderDetails.AddShippingAddress(orderData, tran, addressID); } } else { if (int.Parse(orderData.ObjBillingAddressInfo.AddressID) == 0) billingAddressID = ObjOrderDetails.AddBillingAddress(orderData, tran); if (int.Parse(orderData.ObjShippingAddressInfo.AddressID) == 0) { if (!orderData.ObjOrderDetails.IsDownloadable) { shippingAddressId = ObjOrderDetails.AddShippingAddress(orderData, tran); } } } } int paymentMethodID = ObjOrderDetails.AddPaymentInfo(orderData, tran); if (billingAddressID > 0) { orderID = ObjOrderDetails.AddOrder(orderData, tran, billingAddressID, paymentMethodID); //sn.SetSessionVariable("OrderID", orderID); SetSessionVariable("OrderID", orderID); orderData.ObjOrderDetails.OrderID = orderID; SetSessionVariable("OrderCollection", orderData); } else { orderID = ObjOrderDetails.AddOrderWithMultipleCheckOut(orderData, tran, paymentMethodID); //sn.SetSessionVariable("OrderID", orderID); SetSessionVariable("OrderID", orderID); orderData.ObjOrderDetails.OrderID = orderID; SetSessionVariable("OrderCollection", orderData); } if (shippingAddressId > 0) ObjOrderDetails.AddOrderItems(orderData, tran, orderID, shippingAddressId); else ObjOrderDetails.AddOrderItemsList(orderData, tran, orderID); tran.Commit(); } catch (SqlException sqlEX) { throw new ArgumentException(sqlEX.Message); } catch (Exception ex) { tran.Rollback(); throw ex; } }
public static int AddOrderWithMultipleCheckOut(OrderDetailsCollection orderData, SqlTransaction tran, int paymentMethodId) { try { int orderID = AspxOrderProvider.AddOrderWithMultipleCheckOut(orderData, tran, paymentMethodId); return orderID; } catch (Exception e) { throw e; } }
public static PayPalHandler ParseAfterIPN(string postData, int storeID, int portalID, string userName, int customerID, string sessionCode, string TemplateName, string addressPath) { String sKey, sValue; PayPalHandler ph = new PayPalHandler(); string transID = string.Empty; try { //split response into string array using whitespace delimeter String[] StringArray = postData.Split('\n'); // NOTE: /* * loop is set to start at 1 rather than 0 because first * string in array will be single word SUCCESS or FAIL * Only used to verify post data */ OrderDetailsCollection ot = new OrderDetailsCollection(); OrderDetailsInfo odinfo = new OrderDetailsInfo(); CartManageSQLProvider cms = new CartManageSQLProvider(); CommonInfo cf = new CommonInfo(); cf.StoreID = storeID; cf.PortalID = portalID; cf.AddedBy = userName; // UpdateOrderDetails AspxOrderDetails objad = new AspxOrderDetails(); SQLHandler sqlH = new SQLHandler(); // use split to split array we already have using "=" as delimiter WcfSession ws = new WcfSession(); odinfo.OrderID = ws.GetSessionVariable("OrderID"); int i; for (i = 1; i < StringArray.Length - 1; i++) { String[] StringArray1 = StringArray[i].Split('='); sKey = StringArray1[0]; sValue = HttpUtility.UrlDecode(StringArray1[1]); // set string vars to hold variable names using a switch switch (sKey) { case "payment_status": odinfo.ResponseReasonText = Convert.ToString(sValue); break; case "mc_fee": // ph.PaymentFee = Convert.ToDouble(sValue); break; case "payer_email": // ph.PayerEmail = Convert.ToString(sValue); break; case "Tx Token": // ph.TxToken = Convert.ToString(sValue); break; case "txn_id": odinfo.TransactionID = Convert.ToString(sValue); transID = Convert.ToString(sValue); break; } } ot.ObjOrderDetails = odinfo; ot.ObjCommonInfo = cf; //odinfo.OrderStatusID = 8; //objad.UpdateOrderDetails(ot); if (odinfo.ResponseReasonText.ToLower().Trim() == "completed") { if (HttpContext.Current.Session["OrderCollection"] != null) { OrderDetailsCollection orderdata2 = new OrderDetailsCollection(); orderdata2 = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; objad.UpdateItemQuantity(orderdata2); } } ws.ClearSessionVariable("OrderID"); cms.ClearCartAfterPayment(customerID, sessionCode, storeID, portalID); //invoice transID if (HttpContext.Current.Session["OrderCollection"] != null) { OrderDetailsCollection orderdata = new OrderDetailsCollection(); orderdata = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; EmailTemplate.SendEmailForOrder(portalID, orderdata, addressPath, TemplateName, transID); } ws.ClearSessionVariable("OrderCollection"); return(ph); } catch (Exception ex) { throw ex; } }
public static PayPalHandler Parse(string postData, int storeID, int portalID, string userName, int customerID, string sessionCode) { String sKey, sValue; PayPalHandler ph = new PayPalHandler(); string transID = string.Empty; try { //split response into string array using whitespace delimeter String[] StringArray = postData.Split('\n'); // NOTE: /* * loop is set to start at 1 rather than 0 because first * string in array will be single word SUCCESS or FAIL * Only used to verify post data */ OrderDetailsCollection ot = new OrderDetailsCollection(); OrderDetailsInfo odinfo = new OrderDetailsInfo(); CartManageSQLProvider cms = new CartManageSQLProvider(); CommonInfo cf = new CommonInfo(); cf.StoreID = storeID; cf.PortalID = portalID; cf.AddedBy = userName; // UpdateOrderDetails AspxOrderDetails objad = new AspxOrderDetails(); SQLHandler sqlH = new SQLHandler(); // use split to split array we already have using "=" as delimiter WcfSession ws = new WcfSession(); odinfo.OrderID = ws.GetSessionVariable("OrderID"); int i; for (i = 1; i < StringArray.Length - 1; i++) { String[] StringArray1 = StringArray[i].Split('='); sKey = StringArray1[0]; sValue = HttpUtility.UrlDecode(StringArray1[1]); // set string vars to hold variable names using a switch switch (sKey) { case "payment_status": odinfo.ResponseReasonText = Convert.ToString(sValue); break; case "mc_fee": // ph.PaymentFee = Convert.ToDouble(sValue); break; case "payer_email": // ph.PayerEmail = Convert.ToString(sValue); break; case "Tx Token": // ph.TxToken = Convert.ToString(sValue); break; case "txn_id": odinfo.TransactionID = Convert.ToString(sValue); transID = Convert.ToString(sValue); break; } } // odinfo.InvoiceNumber = DateTime.Now.ToString("yyyyMMddhhmmss"); ot.ObjOrderDetails = odinfo; ot.ObjCommonInfo = cf; odinfo.OrderStatusID = 8; objad.UpdateOrderDetails(ot); if (HttpContext.Current.Session["OrderCollection"] != null) { OrderDetailsCollection orderdata2 = new OrderDetailsCollection(); orderdata2 = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; objad.UpdateItemQuantity(orderdata2); } ws.ClearSessionVariable("OrderID"); cms.ClearCartAfterPayment(customerID, sessionCode, storeID, portalID); //invoice transID if (HttpContext.Current.Session["OrderCollection"] != null) { //StringBuilder emailbody = new StringBuilder(); //emailbody.Append("<div style=\"width:600px;min-height:auto;background-color:#f2f2f2;color:#707070;font:13px/24px Verdana,Geneva,sans-serif;\"><div style=\"color:#49B8F4; font-size:20px;margin:auto 0; font-family:Verdana,Geneva,sans-serif;\"> <label>Thank you for Order </label></div>"); //OrderDetailsCollection orderdata = new OrderDetailsCollection(); //orderdata = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; //emailbody.Append("<p> <strong>Dear </strong> " + orderdata.ObjBillingAddressInfo.FirstName.ToString() + "</p>"); ////if customer is registered // if (orderdata.ObjCommonInfo.AddedBy.ToString().ToLower() == "anonymoususer" && orderdata.ObjOrderDetails.CustomerID ==0) //{ // emailbody.Append("<div> You have ordered items from <strong>AspxCommerce</strong>. <br /> Thanks for using <strong>AspxCommerce</strong>. You can now ship any items. To see all the transaction details, log in to your <b>AspxCommerce</b> <a href=" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/Register.aspx?session="+sessionCode +"" + ">account</a>.<br /> It may take a few moments for this transaction to appear in your account.<br /></div> "); //} //else //{//if customer is guest..send session code // emailbody.Append("<div> You have ordered items from <strong>AspxCommerce</strong>. <br /> Thanks for using <strong>AspxCommerce</strong>. You can now ship any items. To see all the transaction details, Please Resister and log in to your <b>AspxCommerce</b> <a href=" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/Login.aspx" + ">account</a>.<br /> It may take a few moments for this transaction to appear in your account.<br /></div>"); //} //emailbody.Append("<div> <strong>Your Order Details </strong><br /> Transaction ID: <strong >" + odinfo.TransactionID.ToString() + "</strong><br />Invoice No: <strong>" + odinfo.InvoiceNumber.ToString() + "</strong><br />Paymenet System Used: <strong>" + orderdata.ObjPaymentInfo.PaymentMethodName + "</strong><br /> </div> "); //emailbody.Append("<div> If you having Issuses with transaction or any further inquiry then you can mail [email protected].</div><div> Please do not reply to this email. This mail is automatic generated after you have ordered .</div><div>Thank You, <br /><a href=\"" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "\"><img src=\"" + "http://www.aspxcommerce.com" + "/Templates/AspxCommerce/images/aspxcommerce.png\" alt=\"AspxCommerce Team\"/></a></div></div>"); //string body = emailbody.ToString(); //SageFrameConfig pagebase = new SageFrameConfig(); //string emailSuperAdmin = pagebase.GetSettingsByKey(SageFrameSettingKeys.SuperUserEmail);//"*****@*****.**"; //string emailSiteAdmin = pagebase.GetSettingsByKey(SageFrameSettingKeys.SiteAdminEmailAddress); //MailHelper.SendMailNoAttachment("*****@*****.**", orderdata.ObjBillingAddressInfo.EmailAddress.ToString(), "Your Order Details", body, emailSuperAdmin, emailSiteAdmin); //ws.ClearSessionVariable("OrderCollection"); string sendEmailFrom = StoreSetting.GetStoreSettingValueByKey(StoreSetting.SendEcommerceEmailsFrom, storeID, portalID, "en-US"); string sendOrderNotice = StoreSetting.GetStoreSettingValueByKey(StoreSetting.SendOrderNotification, storeID, portalID, "en-US"); if (sendOrderNotice.ToLower() == "true") { StringBuilder emailbody = new StringBuilder(); OrderDetailsCollection orderdata = new OrderDetailsCollection(); orderdata = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; emailbody.Append("<table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"5\" bgcolor=\"#e0e0e0\" style=\"font: 12px Arial,Helvetica,sans-serif;\"> <tr><td align=\"center\" valign=\"top\"><table width=\"680\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr> <td><img src=\"" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/blank.gif\" width=\"1\" height=\"10\" alt=\" \" /></td></tr><tr><td><table width=\"680\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr> <td width=\"300\">"); emailbody.Append("<a href=\"http://www.aspxcommerce.com\" target=\"_blank\" style=\"outline: none; border: none;\"> <img src=\"http://www.aspxcommerce.com/Templates/AspxCommerce/images/aspxcommerce.png\" width=\"143\" height=\"62\" alt=\"AspxCommerce\" title=\"AspxCommerce\" /></a></td><td width=\"191\" align=\"left\" valign=\"middle\">"); emailbody.Append(" </td><td width=\"189\" align=\"right\" valign=\"middle\"><b style=\"padding: 0 20px 0 0; text-shadow: 1px 1px 0 #fff;\">" + DateTime.Now.ToString("dd MMMM yyyy ") + "</b>"); emailbody.Append("</td> </tr></table> </td> </tr> <tr> <td bgcolor=\"#fff\"><div style=\"border:1px solid #c7c7c7; background:#fff; padding:20px\"> <img src=\"" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/blank.gif\" width=\"1\" height=\"10\" alt=\" \" /><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#FFFFFF\"> <tr> <td> <p style=\"font-family: Arial, Helvetica, sans-serif; font-size: 17px; line-height: 16px;color: #278ee6; margin: 0; padding: 0 0 5px 0; font-weight: bold;\"> "); emailbody.Append(" Dear " + orderdata.ObjBillingAddressInfo.FirstName.ToString() + "</p> <p style=\"font-family: Arial, Helvetica, sans-serif; font-size: 13px; line-height: 16px; color: #393939; margin: 0; padding: 0 0 10px 0; font-weight: bold;\"> Thank you for Order</p>"); emailbody.Append("<p style=\"font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 18px; color: #393939; margin: 0; padding: 8px 0 15px 0; font-weight: normal;\">You have ordered items from <span style=\"font-weight: bold; font-size: 11px;\">AspxCommerce</span>.<br />"); emailbody.Append("Thanks for using <span style=\"font-weight: bold; font-size: 11px;\">AspxCommerce</span>. You can now ship any items. To see all the transaction details,"); // emailbody.Append(" Please Register and log in to your <span style=\"font-weight: bold; font-size: 11px;\">AspxCommerce</span>"); string account = ""; if (orderdata.ObjCommonInfo.AddedBy.ToString().ToLower() == "anonymoususer" && orderdata.ObjOrderDetails.CustomerID == 0) { // future login process for annoymoususr emailbody.Append("Please Register and log in to your <span style=\"font-weight: bold; font-size: 11px;\">AspxCommerce</span>"); account = "<a href=" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/User-Registration.aspx" + ">account</a>"; } else { emailbody.Append(" Please log in to your <span style=\"font-weight: bold; font-size: 11px;\">AspxCommerce</span>"); account = "<a href=" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/Login.aspx" + ">account</a>"; } emailbody.Append(" " + account + ".<br /> It may take a few moments for this transaction to appear in your account</p> </td></tr> </table><div style=\"border: 1px solid #cfcfcf; background: #f1f1f1; padding: 10px\"><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"> <tr> <td><h3 style=\"font-size: 15px; font-family: Arial, Helvetica, sans-serif; line-height: 20px; font-weight: bold; margin: 0; text-transform: capitalize; color: #000; text-shadow: 1px 1px 0 #fff;\"> Your Order Details</h3></td></tr><tr><td><img src=\"" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/blank.gif\" width=\"1\" height=\"10\" alt=\" \" /></td>"); emailbody.Append(" </tr><tr><td bgcolor=\"#fff\"><div style=\"border: 1px solid #c7c7c7; background: #fff; padding: 10px\">"); emailbody.Append("<div style=\"border: 1px solid #cfcfcf; background: #f1f1f1; padding: 10px\">"); emailbody.Append("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">"); emailbody.Append("<tr> <td height=\"25\" style=\"border-bottom: 1px solid #fff;\">"); emailbody.Append("<h3 style=\"font-size: 15px; font-family: Arial, Helvetica, sans-serif; line-height: 20px;"); emailbody.Append("font-weight: bold; margin: 0; text-transform: capitalize; color: #000; text-shadow: 1px 1px 0 #fff;\">Order Information</h3>"); emailbody.Append("</td></tr><tr> <td> <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">"); emailbody.Append(" <tr><td width=\"120\" height=\"20\"><span style=\"font-family: Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold;\">"); emailbody.Append(" Merchant:</span> </td> <td>"); // merchant Name emailbody.Append("Aspx Commerce"); emailbody.Append(" </td> <td width=\"150\" style=\"font-family: Arial, Helvetica, sans-serif; font-size: 11px;"); emailbody.Append(" font-weight: bold; border-left: 1px solid #fff; padding-left: 20px;\"> Customer Id: <td>"); // customer ID emailbody.Append("" + customerID.ToString() + ""); emailbody.Append(" </td> </tr> <tr> <td height=\"20\"> <span style=\"font-family: Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold;\">"); emailbody.Append(" Description:</span> </td> <td> Order Remarks</td> <td style=\"font-family: Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold;"); emailbody.Append(" border-left: 1px solid #fff; padding-left: 20px;\"> Phone No: </td> <td>"); // customer Phone No emailbody.Append("" + orderdata.ObjBillingAddressInfo.Phone.ToString() + ""); emailbody.Append(" </td> </tr> <td height=\"20\"><span style=\"font-family: Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold;\">"); emailbody.Append(" Invoice Number:</span> </td><td>"); // invoice no emailbody.Append("" + orderdata.ObjOrderDetails.InvoiceNumber.ToString() + ""); // emailbody.Append("" + invoice + ""); emailbody.Append(" </td> <td style=\"font-family: Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold; border-left: 1px solid #fff; padding-left: 20px;\">"); emailbody.Append(" </td><td> </td></tr></table> </td> </tr> </table> </div>"); emailbody.Append(" <div style=\"border: 1px solid #cfcfcf; background: #f1f1f1; padding: 0; margin: 10px 0 0 0;\">"); emailbody.Append(" <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">"); emailbody.Append(" <tr> <td width=\"300\" style=\"background: #e0e0e0;\"> <h2 style=\"margin: 0; padding: 0; font-weight: bold; font-family: Arial, Helvetica, sans-serif;"); emailbody.Append(" font-size: 15px; padding: 3px 0 3px 10px; text-shadow: 1px 1px 0 #fff;\">"); emailbody.Append(" Billing Information</h2> </td><td style=\"background: #e0e0e0; border-left: 1px solid #fff;\">"); emailbody.Append(" <h2 style=\"margin: 0; padding: 0; font-weight: bold; font-family: Arial, Helvetica, sans-serif;"); emailbody.Append(" font-size: 15px; padding: 3px 0 3px 10px; text-shadow: 1px 1px 0 #fff;\">"); emailbody.Append(" Shipping Information</h2> </td></tr><tr><td valign=\"top\"> <p style=\"margin: 0; padding: 10px; font-family: Arial, Helvetica, sans-serif; font-weight: normal;"); emailbody.Append(" line-height: 18px; font-size: 12px;\">"); //Milson Munakami<br /> // Bd<br /> // sda<br /> // Dsad, Alberta 3232<br /> // Afghanistan<br /> // [email protected]<br /> // +000 000 0000<br /> // Fax: 2222222</p> // </td> string billing = orderdata.ObjBillingAddressInfo.FirstName.ToString() + " " + orderdata.ObjBillingAddressInfo.LastName.ToString() + "<br />"; if (orderdata.ObjBillingAddressInfo.CompanyName != null) { billing += orderdata.ObjBillingAddressInfo.CompanyName.ToString() + "<br />"; } billing += orderdata.ObjBillingAddressInfo.City.ToString() + ", " + orderdata.ObjBillingAddressInfo.Address.ToString() + "<br />" + orderdata.ObjBillingAddressInfo.Country.ToString() + "<br />" + orderdata.ObjBillingAddressInfo.EmailAddress.ToString() + "<br />" + orderdata.ObjBillingAddressInfo.Phone.ToString() + "<br />" + "<p>"; emailbody.Append("" + billing + ""); emailbody.Append("</td><td style=\"border-left: 1px solid #fff;\" valign=\"top\"> <p style=\"margin: 0; padding: 10px; font-family: Arial, Helvetica, sans-serif; font-weight: normal;"); emailbody.Append("line-height: 18px; font-size: 12px;\">"); //Milson Munakami<br /> // Bd<br /> // sda<br /> // Dsad, Alberta 3232<br /> // Afghanistan<br /> // [email protected]<br /> // +000 000 0000<br /> // Fax: 2222222</p> if (!orderdata.ObjOrderDetails.IsDownloadable) { if (orderdata.ObjOrderDetails.IsMultipleCheckOut == false) { string shipping = orderdata.ObjShippingAddressInfo.FirstName.ToString() + " " + orderdata.ObjShippingAddressInfo.LastName.ToString() + "<br />"; if (orderdata.ObjShippingAddressInfo.CompanyName != null) { shipping += orderdata.ObjShippingAddressInfo.CompanyName.ToString() + "<br />"; } shipping += orderdata.ObjShippingAddressInfo.City.ToString() + ", " + orderdata.ObjShippingAddressInfo.Address.ToString() + "<br />" + orderdata.ObjShippingAddressInfo.Country.ToString() + "<br />" + orderdata.ObjShippingAddressInfo.EmailAddress.ToString() + "<br />" + orderdata.ObjShippingAddressInfo.Phone.ToString() + "<br />" + "<p>"; emailbody.Append("" + shipping + ""); } else { emailbody.Append("Multiple addresses<br />Plese log in to view."); } } emailbody.Append("</td> </tr> </table></div><div style=\"border: 1px solid #cfcfcf; background: #f1f1f1; padding: 0; margin: 10px 0 0 0;\">"); emailbody.Append("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">"); emailbody.Append("<tr><td style=\"background: #e0e0e0;\" colspan=\"2\"><h2 style=\"margin: 0; padding: 0; font-weight: bold; font-family: Arial, Helvetica, sans-serif;"); emailbody.Append("font-size: 15px; padding: 3px 0 3px 10px; text-shadow: 1px 1px 0 #fff;\">"); // card type Visa emailbody.Append("" + orderdata.ObjPaymentInfo.PaymentMethodName.ToString() + ""); // emailbody.Append("" + orderdata.ObjPaymentInfo.CardType.ToString() + ""); emailbody.Append("</h2> </td></tr><tr><td style=\"padding: 5px 10px;\"><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">"); emailbody.Append("<tr><td width=\"100\" height=\"20\" style=\"width: 200\"> <p style=\"font-family: Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold;"); emailbody.Append(" margin: 0; padding: 0;\"> Date/Time:</p></td><td>"); // order date emailbody.Append("" + DateTime.Now.ToString("dddd, dd MMMM yyyy") + ""); emailbody.Append("</td></tr><tr><td height=\"20\"><p style=\"font-family: Arial, Helvetica, sans-serif; font-size: 11px; font-weight: bold;"); emailbody.Append(" margin: 0; padding: 0;\">Transaction Id:</p> </td> <td>"); // transaction ID emailbody.Append("" + transID + ""); //emailbody.Append("" + transID + ""); emailbody.Append("</td> </tr></table> </td> </tr> </table></div></div> </td> </tr> </table> </div>"); emailbody.Append(" <p style=\"font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: normal; color: #000;\">"); emailbody.Append(" if you having Issues with transaction or any further inquiry then you can mail <a"); emailbody.Append("href=\"mailto:[email protected]\" style=\"color: #278ee6;\">[email protected]</a></p>"); emailbody.Append("<p style=\"margin: 0; padding: 5px 0 0 0; font: bold 11px Arial, Helvetica, sans-serif; color: #666;\">"); emailbody.Append("Please do not reply to this email. This mail is automatic generated after you have ordered.</a><br />"); emailbody.Append("<br /> Thank You,<br /> <span style=\"font-weight: normal; font-size: 12px; font-family: Arial, Helvetica, sans-serif;\">"); emailbody.Append("AXPXCommerce Team </span> </p> </div> </td> </tr>"); emailbody.Append(" <tr> <td> <img src=\"" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/blank.gif\" width=\"1\" height=\"20\" alt=\" \" /> </td>"); emailbody.Append("</tr> <tr> <td align=\"center\" valign=\"top\"> <p style=\"font-size: 11px; color: #4d4d4d\">"); emailbody.Append(" © " + DateTime.Now.Year.ToString() + " AspxCommerce. All Rights Reserved.</p></td> </tr> <tr>"); emailbody.Append(" <td align=\"center\" valign=\"top\"> <img src=\"" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/blank.gif\" width=\"1\" height=\"10\" alt=\" \" />"); emailbody.Append(" </td> </tr> </table></div> </td> </tr> </table>"); string body = emailbody.ToString(); SageFrameConfig pagebase = new SageFrameConfig(); string emailSuperAdmin = pagebase.GetSettingsByKey(SageFrameSettingKeys.SuperUserEmail);//"*****@*****.**"; string emailSiteAdmin = pagebase.GetSettingsByKey(SageFrameSettingKeys.SiteAdminEmailAddress); MailHelper.SendMailNoAttachment(sendEmailFrom, orderdata.ObjBillingAddressInfo.EmailAddress.ToString(), "Your Order Details", body, emailSuperAdmin, emailSiteAdmin); } ws.ClearSessionVariable("OrderCollection"); } return(ph); } catch (Exception ex) { throw ex; } }
public void ParseAfterIPNMobile(OrderInfo orderInfo,List<CouponSession> coupons,List<OrderItem> itemsInfo,string postData,UserAddressInfo billingAddress,UserAddressInfo shippingAddress, string templateName, string addressPath) { string transId = string.Empty; try { String[] stringArray = postData.Split('\n'); var ot = new OrderDetailsCollection(); var odinfo = new OrderDetailsInfo(); var cms = new CartManageSQLProvider(); var cf = new CommonInfo {StoreID = orderInfo.StoreId, PortalID = orderInfo.PortalId, AddedBy = orderInfo.AddedBy}; // UpdateOrderDetails var sqlH = new SQLHandler(); // use split to split array we already have using "=" as delimiter int i; for (i = 1; i < stringArray.Length - 1; i++) { String[] stringArray1 = stringArray[i].Split('='); String sKey = stringArray1[0]; String sValue = HttpUtility.UrlDecode(stringArray1[1]); // set string vars to hold variable names using a switch switch (sKey) { case "payment_status": odinfo.ResponseReasonText = Convert.ToString(sValue); break; case "mc_fee": // ph.PaymentFee = Convert.ToDouble(sValue); break; case "payer_email": // ph.PayerEmail = Convert.ToString(sValue); break; case "Tx Token": // ph.TxToken = Convert.ToString(sValue); break; case "txn_id": odinfo.TransactionID = Convert.ToString(sValue); transId = Convert.ToString(sValue); break; } } ot.ObjCommonInfo = cf; //odinfo.OrderStatusID = 8; var orderInfo = (OrderInfo) HttpContext.Current.Session["OrderCollection"]; UpdateItemQuantityAndCoupon(orderInfo, itemsInfo, coupons, orderInfo.StoreId, orderInfo.PortalId, orderInfo.AddedBy); AspxCommonInfo aspxCommonObj = new AspxCommonInfo(); aspxCommonObj.CustomerID = orderInfo.CustomerId; aspxCommonObj.SessionCode = orderInfo.SessionCode; aspxCommonObj.StoreID = orderInfo.StoreId; aspxCommonObj.PortalID = orderInfo.PortalId; cms.ClearCartAfterPayment(aspxCommonObj); EmailTemplate.SendEmailForOrderMobile(orderInfo, billingAddress, shippingAddress, addressPath, templateName, transId); } catch (Exception ex) { throw ex; } }
public string SendPaymentInfoAIM(OrderDetailsCollection OrderDetail, string TemplateName, string addressPath) { WebClient objRequest = new WebClient(); System.Collections.Specialized.NameValueCollection objInf = new System.Collections.Specialized.NameValueCollection(30); string strError; //OrderDetail.ObjOrderDetails.CustomerID = int.Parse(Crypto.GenerateCustomerID()); OrderDetail.ObjOrderDetails.InvoiceNumber = Crypto.GenerateInvoiceNumber(); OrderDetail.ObjOrderDetails.PurchaseOrderNumber = Crypto.GeneratePurchaseOrderNumber(); //merchant generated field objInf.Add("x_version", OrderDetail.ObjOrderDetails.Version); objInf.Add("x_delim_data", OrderDetail.ObjOrderDetails.DelimData); objInf.Add("x_login", OrderDetail.ObjOrderDetails.APILogin); objInf.Add("x_tran_key", OrderDetail.ObjOrderDetails.TransactionKey); objInf.Add("x_relay_response", OrderDetail.ObjOrderDetails.RelayResponse); objInf.Add("x_delim_char", OrderDetail.ObjOrderDetails.DelimChar); objInf.Add("x_encap_char", OrderDetail.ObjOrderDetails.EncapeChar); objInf.Add("x_invoice_num", OrderDetail.ObjOrderDetails.InvoiceNumber); objInf.Add("x_cust_id", OrderDetail.ObjOrderDetails.CustomerID.ToString()); objInf.Add("x_po_num", OrderDetail.ObjOrderDetails.PurchaseOrderNumber); //for (int i = 0; i < arr; i++) //{ //} // Billing Address objInf.Add("x_first_name", OrderDetail.ObjBillingAddressInfo.FirstName); objInf.Add("x_last_name", OrderDetail.ObjBillingAddressInfo.LastName); objInf.Add("x_company", OrderDetail.ObjBillingAddressInfo.CompanyName); objInf.Add("x_email", OrderDetail.ObjBillingAddressInfo.EmailAddress); objInf.Add("x_address", OrderDetail.ObjBillingAddressInfo.Address); objInf.Add("x_city", OrderDetail.ObjBillingAddressInfo.City); objInf.Add("x_state", OrderDetail.ObjBillingAddressInfo.State); objInf.Add("x_zip", OrderDetail.ObjBillingAddressInfo.Zip); objInf.Add("x_country", OrderDetail.ObjBillingAddressInfo.Country); objInf.Add("x_phone", OrderDetail.ObjBillingAddressInfo.Phone); objInf.Add("x_fax", OrderDetail.ObjBillingAddressInfo.Fax); objInf.Add("x_email_customer", OrderDetail.ObjOrderDetails.IsEmailCustomer); if (OrderDetail.ObjOrderDetails.IsMultipleCheckOut == false) { //shipping address objInf.Add("x_ship_to_first_name", OrderDetail.ObjShippingAddressInfo.FirstName); objInf.Add("x_ship_to_last_name", OrderDetail.ObjShippingAddressInfo.LastName); objInf.Add("x_ship_to_company", OrderDetail.ObjShippingAddressInfo.CompanyName); objInf.Add("x_ship_to_address", OrderDetail.ObjShippingAddressInfo.Address); objInf.Add("x_ship_to_city", OrderDetail.ObjShippingAddressInfo.City); objInf.Add("x_ship_to_state", OrderDetail.ObjShippingAddressInfo.State); objInf.Add("x_ship_to_zip", OrderDetail.ObjShippingAddressInfo.Zip); objInf.Add("x_ship_to_country", OrderDetail.ObjShippingAddressInfo.Country); } // Card Details objInf.Add("x_card_num", OrderDetail.ObjPaymentInfo.CardNumber); objInf.Add("x_card_type", OrderDetail.ObjPaymentInfo.CardType); objInf.Add("x_exp_date", OrderDetail.ObjPaymentInfo.ExpireDate); if (OrderDetail.ObjPaymentInfo.PaymentMethodCode=="CC") { // Authorization code of the card (CCV) objInf.Add("x_card_code", OrderDetail.ObjPaymentInfo.CardCode.ToString()); objInf.Add("x_method", OrderDetail.ObjPaymentInfo.PaymentMethodCode); objInf.Add("x_type", OrderDetail.ObjPaymentInfo.TransactionType); string amount = Regex.Replace(OrderDetail.ObjOrderDetails.GrandTotal.ToString("0.00"), @"[A-Z]", String.Empty); objInf.Add("x_amount", amount); objInf.Add("x_description", OrderDetail.ObjOrderDetails.Remarks); objInf.Add("x_test_request", OrderDetail.ObjOrderDetails.IsTest); } else { //bank objInf.Add("x_bank_aba_code", OrderDetail.ObjPaymentInfo.RoutingNumber); objInf.Add("x_bank_acct_num", OrderDetail.ObjPaymentInfo.AccountNumber); objInf.Add("x_bank_acct_type", OrderDetail.ObjPaymentInfo.AccountType); objInf.Add("x_bank_name", OrderDetail.ObjPaymentInfo.BankName); objInf.Add("x_bank_acct_name", OrderDetail.ObjPaymentInfo.AccountHolderName); objInf.Add("x_echeck_type", OrderDetail.ObjPaymentInfo.ChequeType); objInf.Add("x_bank_check_number", OrderDetail.ObjPaymentInfo.ChequeNumber); } // Currency setting. Check the guide for other supported currencies objInf.Add("x_currency_code", OrderDetail.ObjOrderDetails.CurrencyCode); objRequest.BaseAddress ="https://test.authorize.net/gateway/transact.dll"; try { // POST request byte[] objRetBytes; string[] objRetVals; objRetBytes = objRequest.UploadValues(objRequest.BaseAddress, "POST", objInf); objRetVals = System.Text.Encoding.ASCII.GetString(objRetBytes).Split(",".ToCharArray()); // Process Return Values OrderDetail.ObjOrderDetails.ResponseCode = int.Parse(objRetVals[0].Trim(char.Parse("|"))); OrderDetail.ObjOrderDetails.ResponseReasonCode = int.Parse(objRetVals[2].Trim(char.Parse("|"))); if (objRetVals[0].Trim(char.Parse("|")) == "1") { // Returned Authorisation Code //response.AuthorizationCode = objRetVals[4].Trim(char.Parse("|")); // Returned Transaction ID OrderDetail.ObjOrderDetails.TransactionID = Convert.ToString(objRetVals[6].Trim(char.Parse("|"))); strError = "Transaction completed successfully."; // AspxCommerceWebService asws = new AspxCommerceWebService(); AspxCoreController asws = new AspxCoreController(); OrderDetail.ObjOrderDetails.OrderStatusID = 8; OrderDetail.ObjOrderDetails.TransactionID = Convert.ToString(objRetVals[6].Trim(char.Parse("|"))); asws.AddOrderDetails(OrderDetail); CartManageSQLProvider cms = new CartManageSQLProvider(); AspxCommonInfo aspxCommonObj = new AspxCommonInfo(); aspxCommonObj.CustomerID = OrderDetail.ObjOrderDetails.CustomerID; aspxCommonObj.SessionCode = OrderDetail.ObjOrderDetails.SessionCode; aspxCommonObj.StoreID = OrderDetail.ObjCommonInfo.StoreID; aspxCommonObj.PortalID = OrderDetail.ObjCommonInfo.PortalID; cms.ClearCartAfterPayment(aspxCommonObj); } else { // Error! strError = objRetVals[3].Trim(char.Parse("|")) + " (" + objRetVals[2].Trim(char.Parse("|")) + ")"; if (objRetVals[2].Trim(char.Parse("|")) == "44") { // CCV transaction decline strError += "Our Card Code Verification (CCV) returned " + "the following error: "; switch (objRetVals[38].Trim(char.Parse("|"))) { case "N": strError += "Card Code does not match."; break; case "P": strError += "Card Code was not processed."; break; case "S": strError += "Card Code should be on card but was not indicated."; break; case "U": strError += "Issuer was not certified for Card Code."; break; } } if (objRetVals[2].Trim(char.Parse("|")) == "45") { if (strError.Length > 1) strError += "<br />n"; // AVS transaction decline strError += "Our Address Verification System (AVS) " + "returned the following error: "; switch (objRetVals[5].Trim(char.Parse("|"))) { case "A": strError += " the zip code entered does not match " + "the billing address."; break; case "B": strError += " no information was provided for the AVS check."; break; case "E": strError += " a general error occurred in the AVS system."; break; case "G": strError += " the credit card was issued by a non-US bank."; break; case "N": strError += " neither the entered street address nor zip " + "code matches the billing address."; break; case "P": strError += " AVS is not applicable for this transaction."; break; case "R": strError += " please retry the transaction; the AVS system " + "was unavailable or timed out."; break; case "S": strError += " the AVS service is not supported by your " + "credit card issuer."; break; case "U": strError += " address information is unavailable for the " + "credit card."; break; case "W": strError += " the 9 digit zip code matches, but the " + "street address does not."; break; case "Z": strError += " the zip code matches, but the address does not."; break; } } } } catch (Exception ex) { strError = ex.Message; } OrderDetail.ObjOrderDetails.ResponseReasonText = strError; return OrderDetail.ObjOrderDetails.ResponseReasonText; }
public int AddOrder(OrderDetailsCollection orderData, SqlTransaction tran,int billingAddressID,int paymentMethodId) { try { List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>(); parameter.Add(new KeyValuePair<string, object>("@InvoiceNumber", orderData.ObjOrderDetails.InvoiceNumber)); if (orderData.ObjOrderDetails.CustomerID == 0) { parameter.Add(new KeyValuePair<string, object>("@SessionCode", orderData.ObjOrderDetails.SessionCode)); parameter.Add(new KeyValuePair<string, object>("@CustomerID", 0)); } else { parameter.Add(new KeyValuePair<string, object>("@SessionCode", "")); parameter.Add(new KeyValuePair<string, object>("@CustomerID", orderData.ObjOrderDetails.CustomerID)); } parameter.Add(new KeyValuePair<string, object>("@TransactionID", orderData.ObjOrderDetails.TransactionID)); parameter.Add(new KeyValuePair<string, object>("@GrandTotal", orderData.ObjOrderDetails.GrandTotal)); parameter.Add(new KeyValuePair<string, object>("@DiscountAmount", orderData.ObjOrderDetails.DiscountAmount)); parameter.Add(new KeyValuePair<string, object>("@CouponCode", orderData.ObjOrderDetails.CouponCode)); parameter.Add(new KeyValuePair<string, object>("@PurchaseOrderNumber", orderData.ObjOrderDetails.PurchaseOrderNumber)); parameter.Add(new KeyValuePair<string, object>("@PaymentGateTypeID", orderData.ObjOrderDetails.PaymentGatewayTypeID)); parameter.Add(new KeyValuePair<string, object>("@PaymentGateSubTypeID", orderData.ObjOrderDetails.PaymentGatewaySubTypeID)); parameter.Add(new KeyValuePair<string, object>("@ClientIPAddress", orderData.ObjOrderDetails.ClientIPAddress)); parameter.Add(new KeyValuePair<string, object>("@UserBillingAddressID", billingAddressID)); parameter.Add(new KeyValuePair<string, object>("@PaymentMethodID", paymentMethodId)); parameter.Add(new KeyValuePair<string, object>("@OrderStatusID", orderData.ObjOrderDetails.OrderStatusID)); parameter.Add(new KeyValuePair<string, object>("@IsGuestUser", orderData.ObjOrderDetails.IsGuestUser)); parameter.Add(new KeyValuePair<string, object>("@TaxTotal", orderData.ObjOrderDetails.TaxTotal)); parameter.Add(new KeyValuePair<string, object>("@CurrencyCode", orderData.ObjOrderDetails.CurrencyCode)); parameter.Add(new KeyValuePair<string, object>("@ResponseCode", orderData.ObjOrderDetails.ResponseCode)); parameter.Add(new KeyValuePair<string, object>("@ResponseReasonCode", orderData.ObjOrderDetails.ResponseReasonCode)); parameter.Add(new KeyValuePair<string, object>("@ResponseReasonText", orderData.ObjOrderDetails.ResponseReasonText)); parameter.Add(new KeyValuePair<string, object>("@Remarks", orderData.ObjOrderDetails.Remarks)); parameter.Add(new KeyValuePair<string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair<string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair<string, object>("@CultureName", orderData.ObjCommonInfo.CultureName)); parameter.Add(new KeyValuePair<string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); SQLHandler sqlH = new SQLHandler(); int orderID = sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[usp_Aspx_OrderDetails]", parameter, "@OrderID"); return orderID; } catch (Exception ex) { throw ex; } }
public static void SendEmailForOrder(int portalID, OrderDetailsCollection orderdata, string addressPath, string templateName, string transID) { StoreSettingConfig ssc = new StoreSettingConfig(); SageFrameConfig pagebase = new SageFrameConfig(); // sendEmailFrom = ssc.GetStoreSettingsByKey(StoreSetting.SendEcommerceEmailsFrom, storeID, portalID, "en-US"); string sendOrderNotice = ssc.GetStoreSettingsByKey(StoreSetting.SendOrderNotification, orderdata.ObjCommonInfo.StoreID, portalID, orderdata.ObjCommonInfo.CultureName); string logosrc = ssc.GetStoreSettingsByKey(StoreSetting.StoreLogoURL, orderdata.ObjCommonInfo.StoreID, portalID, orderdata.ObjCommonInfo.CultureName); string inquiry = ssc.GetStoreSettingsByKey(StoreSetting.SendEcommerceEmailsFrom, orderdata.ObjCommonInfo.StoreID, portalID, orderdata.ObjCommonInfo.CultureName); string storeName = ssc.GetStoreSettingsByKey(StoreSetting.StoreName, orderdata.ObjCommonInfo.StoreID, portalID, orderdata.ObjCommonInfo.CultureName); if (bool.Parse(sendOrderNotice)) { List<MessageManagementInfo> template = MessageManagementController.GetMessageTemplateByMessageTemplateTypeID( SystemSetting.ORDER_PLACED, portalID); foreach (MessageManagementInfo messageToken in template) { string messageTemplate = messageToken.Body; if (template != null) { string[] tokens = GetAllToken(messageTemplate); foreach (string token in tokens) { switch (token) { case "%OrderRemarks%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjOrderDetails.Remarks); break; case "%InvoiceNo%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjOrderDetails.InvoiceNumber); break; case "%OrderStatus%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjOrderDetails.OrderStatus); break; case "%OrderID%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjOrderDetails.OrderID.ToString ()); break; case "%BillingAddress%": string billing = orderdata.ObjBillingAddressInfo.FirstName.ToString() + " " + orderdata.ObjBillingAddressInfo.LastName.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">"; if (orderdata.ObjBillingAddressInfo.CompanyName != null) { billing += orderdata.ObjBillingAddressInfo.CompanyName.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">"; } billing += orderdata.ObjBillingAddressInfo.City.ToString() + ", " + orderdata.ObjBillingAddressInfo.Address.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">" + orderdata.ObjBillingAddressInfo.Country.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">" + orderdata.ObjBillingAddressInfo.EmailAddress.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">" + orderdata.ObjBillingAddressInfo.Phone.ToString(); messageTemplate = messageTemplate.Replace(token, billing); break; case "%ShippingAddress%": string shipping = ""; if (!orderdata.ObjOrderDetails.IsDownloadable) { if (orderdata.ObjOrderDetails.IsMultipleCheckOut == false) { shipping = orderdata.ObjShippingAddressInfo.FirstName.ToString() + " " + orderdata.ObjShippingAddressInfo.LastName.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">"; if (orderdata.ObjShippingAddressInfo.CompanyName != null) { shipping += orderdata.ObjShippingAddressInfo.CompanyName.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">"; } shipping += orderdata.ObjShippingAddressInfo.City.ToString() + ", " + orderdata.ObjShippingAddressInfo.Address.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">" + orderdata.ObjShippingAddressInfo.Country.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">" + orderdata.ObjShippingAddressInfo.EmailAddress.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">" + orderdata.ObjShippingAddressInfo.Phone.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">"; } else { shipping = "Multiple addresses<br />Plese log in to view." + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">"; } } else { shipping = "Your Ordered Item is Downloadable Item." + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">"; } messageTemplate = messageTemplate.Replace(token, shipping); break; case "%UserFirstName%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjBillingAddressInfo.FirstName); break; case "%UserLastName%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjBillingAddressInfo.LastName); break; case "%TransactionID%": messageTemplate = messageTemplate.Replace(token, transID); break; case "%PaymentMethodName%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjPaymentInfo.PaymentMethodName); break; case "%DateTimeDay%": messageTemplate = messageTemplate.Replace(token, DateTime.Now.ToString("dddd, dd MMMM yyyy")); break; case "%DateYear%": messageTemplate = messageTemplate.Replace(token, DateTime.Now.Year.ToString()); break; case "%CustomerID%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjOrderDetails.CustomerID. ToString()); break; case "%PhoneNo%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjBillingAddressInfo.Phone); break; case "%AccountLogin%": string account = ""; if (orderdata.ObjCommonInfo.AddedBy.ToString().ToLower() == "anonymoususer" && orderdata.ObjOrderDetails.CustomerID == 0) { // future login process for annoymoususr account += "Please Register and log in to your <span style=\"font-weight: bold; font-size: 11px;\">AspxCommerce</span>"; account += "<a style=\"color: rgb(39, 142, 230);\" href=" + addressPath + "User-Registration.aspx" + ">account</a>"; } else { account += " Please log in to your <span style=\"font-weight: bold; font-size: 11px;\">AspxCommerce</span>"; account += " <a style=\"color: rgb(39, 142, 230);\" href=" + addressPath + "Login.aspx" + ">account</a>"; } messageTemplate = messageTemplate.Replace(token, account); break; case "%LogoSource%": // string src = " http://" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/Templates/" + templateName + "/images/aspxcommerce.png"; string src = " http://" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/" + logosrc; messageTemplate = messageTemplate.Replace(token, src); break; case "%DateTime%": messageTemplate = messageTemplate.Replace(token, DateTime.Now.ToString("dd MMMM yyyy ")); break; case "%InquiryEmail%": string x = "<a target=\"_blank\" style=\"text-decoration: none;color: #226ab7;font-style: italic;\" href=\"mailto:" + inquiry + "\" >" + inquiry + "</a>"; messageTemplate = messageTemplate.Replace(token, x); break; case "%StoreName%": messageTemplate = messageTemplate.Replace(token, storeName); break; } } // return messageTemplate; string emailStoreAdmin = ssc.GetStoreSettingsByKey(StoreSetting.SendEcommerceEmailsFrom, orderdata.ObjCommonInfo.StoreID , portalID, orderdata.ObjCommonInfo.CultureName); string emailSuperAdmin = pagebase.GetSettingsByKey(SageFrameSettingKeys.SuperUserEmail); string emailSiteAdmin = pagebase.GetSettingsByKey(SageFrameSettingKeys.SiteAdminEmailAddress); MailHelper.SendMailNoAttachment(emailStoreAdmin, orderdata.ObjBillingAddressInfo.EmailAddress, messageToken.Subject, messageTemplate, emailSiteAdmin, emailSuperAdmin); } } } }
public void UpdateOrderDetails(OrderDetailsCollection orderData) { try { List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>(); // parameter.Add(new KeyValuePair<string, object>("@InvoiceNumber", DateTime.Now.ToString("yyyyMMddhhmmss"))); parameter.Add(new KeyValuePair<string, object>("@TransactionID", orderData.ObjOrderDetails.TransactionID)); parameter.Add(new KeyValuePair<string, object>("@OrderStatusID", orderData.ObjOrderDetails.OrderStatusID)); parameter.Add(new KeyValuePair<string, object>("@ResponseCode", orderData.ObjOrderDetails.ResponseCode)); parameter.Add(new KeyValuePair<string, object>("@ResponseReasonCode", orderData.ObjOrderDetails.ResponseReasonCode)); parameter.Add(new KeyValuePair<string, object>("@ResponseReasonText", orderData.ObjOrderDetails.ResponseReasonText)); parameter.Add(new KeyValuePair<string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair<string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair<string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); parameter.Add(new KeyValuePair<string, object>("@OrderID", orderData.ObjOrderDetails.OrderID)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("[dbo].[usp_Aspx_UpdateOrderDetails]", parameter); } catch (Exception ex) { throw ex; } }
public void UpdateItemQuantity(OrderDetailsCollection orderData) { try { if (orderData.ObjOrderDetails.CouponCode != null && System.Web.HttpContext.Current.Session["CouponApplied"] != null) { ReduceCouponUsed(orderData.ObjOrderDetails.CouponCode.Trim(), orderData.ObjCommonInfo.StoreID, orderData.ObjCommonInfo.PortalID, orderData.ObjCommonInfo.AddedBy); } foreach (OrderItemInfo objItems in orderData.LstOrderItemsInfo) { if (objItems.IsDownloadable != true) { List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>(); parameter.Add(new KeyValuePair<string, object>("@StoreID", orderData.ObjCommonInfo.StoreID)); parameter.Add(new KeyValuePair<string, object>("@PortalID", orderData.ObjCommonInfo.PortalID)); parameter.Add(new KeyValuePair<string, object>("@AddedBy", orderData.ObjCommonInfo.AddedBy)); parameter.Add(new KeyValuePair<string, object>("@ItemID", objItems.ItemID)); parameter.Add(new KeyValuePair<string, object>("@Quantity", objItems.Quantity)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery("[dbo].[usp_Aspx_UpdateItemQuantitybyOrder]", parameter); } } } catch (Exception ex) { throw ex; } }
public void SaveOrderDetails(OrderDetailsCollection orderDetail) { try { orderDetail.ObjOrderDetails.OrderStatusID = 7; AddOrderDetails(orderDetail); } catch (Exception ex) { throw ex; } }
private static void HandleNewOrderNotification(GCheckout.AutoGen.NewOrderNotification inputNewOrderNotification) { try { if (inputNewOrderNotification.shoppingcart.merchantprivatedata != null && inputNewOrderNotification.shoppingcart.merchantprivatedata.Any != null && inputNewOrderNotification.shoppingcart.merchantprivatedata.Any.Length > 0) { //Retrieve data from MerchantPrivateData GCheckout.AutoGen.anyMultiple oneAnyMultiple = inputNewOrderNotification.shoppingcart.merchantprivatedata; System.Xml.XmlNode[] oneXmlNodeArray = oneAnyMultiple.Any; foreach (XmlNode xn in oneXmlNodeArray) { if (xn.Name == "OrderID") { orderID = Int32.Parse(xn.InnerText.ToString()); } if (xn.Name == "userName") { userName = xn.InnerText.ToString(); } if (xn.Name == "amount") { totalAmount = decimal.Parse(xn.InnerText.ToString()); } if (xn.Name == "selectedCurrency") { selectedCurrency = xn.InnerText.ToString(); } if (xn.Name == "portalID") { portalID = int.Parse(xn.InnerText.ToString()); } if (xn.Name == "customerID") { customerID = int.Parse(xn.InnerText.ToString()); } if (xn.Name == "itemIds") { itemIds = xn.InnerText.ToString(); } if (xn.Name == "storeID") { storeID = int.Parse(xn.InnerText.ToString()); } if (xn.Name == "couponCode") { couponCode = xn.InnerText.ToString(); } if (xn.Name == "sessionCode") { sessionCode = xn.InnerText.ToString(); } if (xn.Name == "pgID") { pgID = int.Parse(xn.InnerText.ToString()); } if (xn.Name == "MerchantID") { MerchantID = xn.InnerText.ToString(); } if (xn.Name == "MerchantKey") { MerchantID = xn.InnerText.ToString(); } } paymentStatus = GCNotificationStatus.Succeeded.ToString(); transID = inputNewOrderNotification.googleordernumber; if (paymentStatus == "Succeeded") { TransactionLogInfo tinfo = new TransactionLogInfo(); TransactionLog Tlog = new TransactionLog(); OrderDetailsCollection odc = new OrderDetailsCollection(); tinfo.ResponseReasonText = "Succeeded"; tinfo.OrderID = orderID; tinfo.StoreID = storeID; tinfo.PortalID = portalID; tinfo.AddedBy = userName; tinfo.CustomerID = customerID; tinfo.SessionCode = sessionCode; tinfo.PaymentGatewayID = pgID; tinfo.PaymentStatus = paymentStatus; tinfo.PayerEmail = ""; tinfo.CreditCard = ""; tinfo.TotalAmount = totalAmount; tinfo.TransactionID = transID; tinfo.RecieverEmail = ""; tinfo.CurrencyCode = selectedCurrency; Tlog.SaveTransactionLog(tinfo); GoogleCheckOutHandler.ParseIPN(orderID, transID, paymentStatus, storeID, portalID, userName, customerID, sessionCode); GoogleCheckOutHandler.UpdateItemQuantity(itemIds, couponCode, storeID, portalID, userName); CartManageSQLProvider cms = new CartManageSQLProvider(); AspxCommonInfo aspxCommonObj = new AspxCommonInfo(); aspxCommonObj.CustomerID = customerID; aspxCommonObj.SessionCode = sessionCode; aspxCommonObj.StoreID = storeID; aspxCommonObj.PortalID = portalID; aspxCommonObj.CultureName = null; aspxCommonObj.UserName = null; cms.ClearCartAfterPayment(aspxCommonObj); } } } catch (Exception ex) { throw ex; } // TODO: Process the MerchantPrivateData if provided foreach (GCheckout.AutoGen.Item oneItem in inputNewOrderNotification.shoppingcart.items) { // TODO: Get MerchantItemId from shopping cart item (oneItem.merchantitemid) and process it } // TODO: Add custom processing for this notification type }
protected void SendConfrimMessage() { try { if (Session["OrderID"] != null) { const int responseCode = 1; const string responsereasontext = "Transaction occured successfully"; const int responsereasonCode = 1; string paymentmethod = string.Empty; var orderdata2 = new OrderDetailsCollection(); if (HttpContext.Current.Session["OrderCollection"] != null) { orderdata2 = (OrderDetailsCollection)HttpContext.Current.Session["OrderCollection"]; } string invoice = orderdata2.ObjOrderDetails.InvoiceNumber; var random = new Random(); string purchaseorderNo = (random.Next(0, 1000)).ToString(); string timeStamp = ((int)(DateTime.UtcNow - new DateTime(2011, 1, 1)).TotalSeconds).ToString(); string transID = (random.Next(9999999, 111111111)).ToString(); lblTransaction.Text = transID; lblInvoice.Text = invoice; lblPaymentMethod.Text = "Gift Card"; lblPaymentStatus.Text = "Successfull"; lblDateTime.Text = DateTime.Now.ToString("dddd, dd MMMM yyyy "); lblOrderNo.Text = "#" + Session["OrderID"].ToString(); AspxCommonInfo aspxCommonObj = new AspxCommonInfo(); aspxCommonObj.StoreID = GetStoreID; aspxCommonObj.PortalID = GetPortalID; aspxCommonObj.UserName = GetUsername; aspxCommonObj.CustomerID = GetCustomerID; aspxCommonObj.SessionCode = HttpContext.Current.Session.SessionID; aspxCommonObj.CultureName = GetCurrentCultureName; string result = AspxGiftCardController.Parse(orderdata2.ObjOrderDetails.OrderID,transID, invoice, purchaseorderNo, responseCode, responsereasonCode, responsereasontext, aspxCommonObj); AspxGiftCardController.IssueGiftCard(orderdata2.LstOrderItemsInfo, orderdata2.ObjOrderDetails.OrderID, true, aspxCommonObj); if (orderdata2.GiftCardDetail != null && CheckOutSessions.Get<List<GiftCardUsage>>("UsedGiftCard").Count > 0) { AspxGiftCardController.UpdateGiftCardUsage(orderdata2.GiftCardDetail, orderdata2.ObjCommonInfo.StoreID, orderdata2.ObjCommonInfo.PortalID, orderdata2.ObjOrderDetails.OrderID, orderdata2.ObjCommonInfo.AddedBy, orderdata2.ObjCommonInfo.CultureName); } lblerror.Text = result; lblerror.Text = GetSageMessage("Payment", "PaymentProcessed"); var tinfo = new TransactionLogInfo(); var tlog = new TransactionLog(); tinfo.TransactionID = transID; tinfo.AuthCode = ""; tinfo.TotalAmount = orderdata2.ObjOrderDetails.GrandTotal* currencyRate; tinfo.ResponseCode = responseCode.ToString(); tinfo.ResponseReasonText = responsereasontext; tinfo.OrderID = orderdata2.ObjOrderDetails.OrderID; tinfo.StoreID = orderdata2.ObjCommonInfo.StoreID; tinfo.PortalID = orderdata2.ObjCommonInfo.PortalID; tinfo.AddedBy = orderdata2.ObjCommonInfo.AddedBy; tinfo.CustomerID = orderdata2.ObjOrderDetails.CustomerID; tinfo.SessionCode = orderdata2.ObjOrderDetails.SessionCode; tinfo.PaymentGatewayID = orderdata2.ObjOrderDetails.PaymentGatewayTypeID; tinfo.PaymentStatus = "Processed"; tinfo.CreditCard = ""; tinfo.CurrencyCode = SelectedCurrency; tlog.SaveTransactionLog(tinfo); CheckOutHelper cHelper = new CheckOutHelper(); cHelper.ClearSessions(); if (Session["OrderCollection"] != null) { var orderdata = (OrderDetailsCollection)Session["OrderCollection"]; try { orderdata.ObjOrderDetails.OrderStatus = "Processed"; EmailTemplate.SendEmailForOrder(GetPortalID, orderdata, _addressPath, TemplateName, transID); } catch (Exception ex) { lblerror.Text = ""; lblerror.Text= GetSageMessage("Payment", "EmailSendOrderProblem"); ProcessException(ex); } Session.Remove("OrderCollection"); } } else { Response.Redirect(_sageRedirectPath, false); } } catch (Exception ex) { ProcessException(ex); } }
public static void SendEmailForOrder(int portalID, OrderDetailsCollection orderdata, string addressPath, string templateName, string transID) { StoreSettingConfig ssc = new StoreSettingConfig(); // sendEmailFrom = ssc.GetStoreSettingsByKey(StoreSetting.SendEcommerceEmailsFrom, storeID, portalID, "en-US"); string sendOrderNotice = ssc.GetStoreSettingsByKey(StoreSetting.SendOrderNotification, orderdata.ObjCommonInfo.StoreID, portalID, orderdata.ObjCommonInfo.CultureName); string logosrc = ssc.GetStoreSettingsByKey(StoreSetting.StoreLogoURL, orderdata.ObjCommonInfo.StoreID, portalID, orderdata.ObjCommonInfo.CultureName); string inquiry = ssc.GetStoreSettingsByKey(StoreSetting.SendEcommerceEmailTo, orderdata.ObjCommonInfo.StoreID, portalID, orderdata.ObjCommonInfo.CultureName); string storeName = ssc.GetStoreSettingsByKey(StoreSetting.StoreName, orderdata.ObjCommonInfo.StoreID, portalID, orderdata.ObjCommonInfo.CultureName); if (bool.Parse(sendOrderNotice)) { MessageTemplateDataContext dbMessageTemplate = new MessageTemplateDataContext(SystemSetting.SageFrameConnectionString); MessageTokenDataContext messageTokenDB = new MessageTokenDataContext(SystemSetting.SageFrameConnectionString); SageFrameConfig pagebase = new SageFrameConfig(); var template = dbMessageTemplate.sp_MessageTemplateByMessageTemplateTypeID(SystemSetting.ORDER_PLACED, portalID).SingleOrDefault(); string messageTemplate = template.Body; if (template != null) { string[] tokens = GetAllToken(messageTemplate); foreach (string token in tokens) { switch (token) { case "%OrderRemarks%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjOrderDetails.Remarks); break; case "%InvoiceNo%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjOrderDetails.InvoiceNumber); break; case "%OrderID%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjOrderDetails.OrderID.ToString()); break; case "%BillingAddress%": string billing = orderdata.ObjBillingAddressInfo.FirstName.ToString() + " " + orderdata.ObjBillingAddressInfo.LastName.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">"; if (orderdata.ObjBillingAddressInfo.CompanyName != null) { billing += orderdata.ObjBillingAddressInfo.CompanyName.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">"; } billing += orderdata.ObjBillingAddressInfo.City.ToString() + ", " + orderdata.ObjBillingAddressInfo.Address.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">" + orderdata.ObjBillingAddressInfo.Country.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">" + orderdata.ObjBillingAddressInfo.EmailAddress.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">" + orderdata.ObjBillingAddressInfo.Phone.ToString(); messageTemplate = messageTemplate.Replace(token, billing); break; case "%ShippingAddress%": string shipping = ""; if (!orderdata.ObjOrderDetails.IsDownloadable) { if (orderdata.ObjOrderDetails.IsMultipleCheckOut == false) { shipping = orderdata.ObjShippingAddressInfo.FirstName.ToString() + " " + orderdata.ObjShippingAddressInfo.LastName.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">"; if (orderdata.ObjShippingAddressInfo.CompanyName != null) { shipping += orderdata.ObjShippingAddressInfo.CompanyName.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">"; } shipping += orderdata.ObjShippingAddressInfo.City.ToString() + ", " + orderdata.ObjShippingAddressInfo.Address.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">" + orderdata.ObjShippingAddressInfo.Country.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">" + orderdata.ObjShippingAddressInfo.EmailAddress.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">" + orderdata.ObjShippingAddressInfo.Phone.ToString() + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">"; } else { shipping = "Multiple addresses<br />Plese log in to view." + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">"; } } else { shipping = "Your Ordered Item is Downloadable Item." + "</td></tr><tr><td height=\"32\" style=\"border-bottom:thin dashed #d1d1d1; padding:10px 0 5px 10px; font:normal 12px Arial, Helvetica, sans-serif\">"; } messageTemplate = messageTemplate.Replace(token, shipping); break; case "%UserFirstName%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjBillingAddressInfo.FirstName); break; case "%UserLastName%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjBillingAddressInfo.LastName); break; case "%TransactionID%": messageTemplate = messageTemplate.Replace(token, transID); break; case "%PaymentMethodName%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjPaymentInfo.PaymentMethodName); break; case "%DateTimeDay%": messageTemplate = messageTemplate.Replace(token, DateTime.Now.ToString("dddd, dd MMMM yyyy")); break; case "%DateYear%": messageTemplate = messageTemplate.Replace(token, DateTime.Now.Year.ToString()); break; case "%CustomerID%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjOrderDetails.CustomerID.ToString()); break; case "%PhoneNo%": messageTemplate = messageTemplate.Replace(token, orderdata.ObjBillingAddressInfo.Phone); break; case "%AccountLogin%": string account = ""; if (orderdata.ObjCommonInfo.AddedBy.ToString().ToLower() == "anonymoususer" && orderdata.ObjOrderDetails.CustomerID == 0) { // future login process for annoymoususr account += "Please Register and log in to your <span style=\"font-weight: bold; font-size: 11px;\">AspxCommerce</span>"; account += "<a style=\"color: rgb(39, 142, 230);\" href=" + addressPath + "User-Registration.aspx" + ">account</a>"; } else { account += " Please log in to your <span style=\"font-weight: bold; font-size: 11px;\">AspxCommerce</span>"; account += " <a style=\"color: rgb(39, 142, 230);\" href=" + addressPath + "Login.aspx" + ">account</a>"; } messageTemplate = messageTemplate.Replace(token, account); break; case "%LogoSource%": // string src = " http://" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/Templates/" + templateName + "/images/aspxcommerce.png"; string src = " http://" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/" + logosrc; messageTemplate = messageTemplate.Replace(token, src); break; case "%DateTime%": messageTemplate = messageTemplate.Replace(token, DateTime.Now.ToString("dd MMMM yyyy ")); break; case "%InquiryEmail%": string x = "<a target=\"_blank\" style=\"text-decoration: none;color: #226ab7;font-style: italic;\" href=\"mailto:" + inquiry + "\" >" + inquiry + "</a>"; messageTemplate = messageTemplate.Replace(token, x); break; case "%StoreName%": messageTemplate = messageTemplate.Replace(token, storeName); break; } } // return messageTemplate; MailHelper.SendMailNoAttachment(template.MailFrom, orderdata.ObjBillingAddressInfo.EmailAddress, template.Subject, messageTemplate, string.Empty, string.Empty); } } }