protected void btnProcessPayment_Click(object sender, EventArgs e)
{
if ((PaymentGatewayProvider != null) && (orderId > 0))
{
OrderInfo order = OrderInfoProvider.GetOrders()
.WhereEquals("OrderID", orderId)
.FirstObject;
CustomerInfo customer = CustomerInfoProvider.GetCustomers()
.WhereEquals("CustomerID", order.OrderCustomerID)
.FirstObject;
//AddressInfo address = AddressInfoProvider.GetAddresses()
// .WhereEquals("AddressCustomerID", order.OrderBillingAddress)
// .FirstObject;
try
{
ltrPayPalForm.Text = GeneratePayPalToken(order, customer);
}
catch (Exception ex)
{
Response.Write(ex.InnerException);
}
}
}
private void DeleteOrder()
{
// Prepare the parameters
//string where = "CustomerLastName LIKE N'My New Registered%'";
CustomerInfo customer = null;
// Get the customer
DataSet customers = CustomerInfoProvider.GetCustomers(null, null);
if (!DataHelper.DataSourceIsEmpty(customers))
{
// Create object from DataRow
customer = new CustomerInfo(customers.Tables[0].Rows[0]);
}
if (customer != null)
{
// string whereOrder = "OrderCustomerID='" + customer.CustomerID + "'";
// Get the order
DataSet orders = OrderInfoProvider.GetOrders(null, null);
if (!DataHelper.DataSourceIsEmpty(orders))
{
// Create object from DataRow
// OrderInfo order = new OrderInfo(orders.Tables[0].Rows[0]);
foreach (DataRow userDr in orders.Tables[0].Rows)
{
OrderInfo order = new OrderInfo(userDr);
// Delete the order
OrderInfoProvider.DeleteOrderInfo(order);
}
}
}
}
private void DeleteCustomer()
{
// Prepare the parameters
// string where = "CustomerLastName LIKE N'My New%'";
// Delete user
// UserInfo user = UserInfoProvider.GetUserInfo("My new user");
// UserInfoProvider.DeleteUser(user);
// Get the data
DataSet customers = CustomerInfoProvider.GetCustomers(null, null);
if (!DataHelper.DataSourceIsEmpty(customers))
{
foreach (DataRow customerDr in customers.Tables[0].Rows)
{
// Create object from DataRow
CustomerInfo deleteCustomer = new CustomerInfo(customerDr);
// Delete the customer
CustomerInfoProvider.DeleteCustomerInfo(deleteCustomer);
}
//return true;
}
//return false;
}
/// <summary>
/// Checks whether the suer is already a customer or not
/// </summary>
/// <param name="userID">user id</param>
/// <returns>customer id</returns>
private int IsUserCustomer(int userID)
{
try
{
CustomerInfo customer = CustomerInfoProvider.GetCustomers()
.WhereEquals("CustomerUserID", userID)
.FirstOrDefault();
if (!DataHelper.DataSourceIsEmpty(customer))
{
return(customer.CustomerID);
}
}
catch (Exception ex)
{
EventLogProvider.LogException("CreateAddress.ascx.cs", "CreateCustomer()", ex);
}
return(default(int));
}
private string GetAndBulkUpdateAddresses(int aid, int cid, int oid)
{
// Prepare the parameters
string where = "AddressID LIKE '" + aid + "'";
// Get the data
DataSet addresses = AddressInfoProvider.GetAddresses(where, null);
if (!DataHelper.DataSourceIsEmpty(addresses))
{
// Loop through the individual items
foreach (DataRow addressDr in addresses.Tables[0].Rows)
{
// Create object from DataRow
AddressInfo modifyAddress = new AddressInfo(addressDr);
// Update the properties
modifyAddress.AddressName = modifyAddress.AddressName.ToUpper();
string a2 = modifyAddress.AddressLine2;
if (!string.IsNullOrEmpty(a2))
{
a2 = a2 + "<br/>";
}
int pid = modifyAddress.AddressCountryID;
string pays = string.Empty;
string wherec = "CountryID LIKE'" + pid + "'";
DataSet country = CMS.Globalization.CountryInfoProvider.GetCountries(wherec, null);
string customerv = string.Empty;
string wherecu = "CustomerID LIKE '" + cid + "'";
string whereo = "OrderID LIKE '" + oid + "'";
string ordern = string.Empty;
string invoice = string.Empty;
CustomerInfo customer = null;
//get order info
DataSet orders = OrderInfoProvider.GetOrders(whereo, null);
if (!DataHelper.DataSourceIsEmpty(orders))
{
// Create object from DataRow
OrderInfo order = new OrderInfo(orders.Tables[0].Rows[0]);
// Update the property
ordern = "Commande " + order.OrderID.ToString();
invoice = order.GetStringValue("facture", string.Empty);
if (!string.IsNullOrEmpty(invoice))
{
invoice = "Facture " + invoice + "<br/>";
}
}
// Get the customer
DataSet customers = CustomerInfoProvider.GetCustomers(wherecu, null);
if (!DataHelper.DataSourceIsEmpty(customers))
{
// Create object from DataRow
customer = new CustomerInfo(customers.Tables[0].Rows[0]);
customerv = customer.CustomerLastName + " " + customer.CustomerFirstName;
}
if (!DataHelper.DataSourceIsEmpty(country))
{
// Loop through the individual items
foreach (DataRow countryDr in country.Tables[0].Rows)
{
CountryInfo ci = new CountryInfo(countryDr);
pays = GetString(ci.CountryName);
}
}
string result = "<br /><table border=\"0\" cellpadding=\"20\" cellspacing=\"0\" width=\"630px\"><tbody><tr><td valign=\"top\"><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tbody><tr><td><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"630px\"><tbody><tr><td align=\"left\" colspan=\"2\"><img src=\"http://www.servranx.com/App_Themes/Servranx/images/logonb.png\" width=\"300\" /><br /><div align=\"left\" style=\"font-size:13px ; border-left:3px solid black; padding-left:8px\"><p>Sprl Servranx<br />23-25, rue Gustave Biot - B-1050 Bruxelles<br />T�l. 00 32 (0)2 649 18 40<br />Fax 00 32 (0)2 649 12 10<br />[email protected]<br /><strong>www.servranx.com</strong><br />TVA BE 0450 834 519<br />Comptes bancaires :<br />ING 310-0529195-49<br />IBAN BE97 3100 5291 9549 <br />BIC : BBRUBEBB<br /> </p></div></td><td align=\"left\" style=\"text-align: left;\" width=\"351\"><div align=\"left\" style=\"border:2px solid black; padding:15px;font-weight:bold; font-size:17px;margin-top:50px\"><span style=\"font-size: 14px;text-transform:uppercase\">" + ordern + "<br/>" + invoice + " ADRESSE DE LIVRAISON<br/><br/><br/>" + customerv + "<br/>" + modifyAddress.GetValue("AddressNumber") + " " + modifyAddress.AddressLine1 + "<br/>" + a2 + modifyAddress.AddressZip + " " + modifyAddress.AddressCity + "<br/>" + pays + "</span></div></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table><br />";
return(result);
// Update the address
// AddressInfoProvider.SetAddressInfo(modifyAddress);
}
//return true;
}
return(string.Empty);
}
private void GenerateEcommerceData(int siteID)
{
var siteName = SiteInfoProvider.GetSiteName(siteID);
var currencyInfo = CurrencyInfoProvider.GetCurrencies(siteID)
.Where("CurrencyIsMain", QueryOperator.Equals, 1).TopN(1).FirstOrDefault();
var list1 = PaymentOptionInfoProvider.GetPaymentOptions(siteID).ToList();
var list2 = ShippingOptionInfoProvider.GetShippingOptions(siteID).ToList();
var orderStatusList = OrderStatusInfoProvider.GetOrderStatuses(siteID).ToDictionary(status => status.StatusName);
var manufacturerExceptionList = new List <int>
{
ManufacturerInfoProvider.GetManufacturerInfo("Aerobie", siteName).ManufacturerID,
//ManufacturerInfoProvider.GetManufacturerInfo("Chemex", siteName).ManufacturerID,
//ManufacturerInfoProvider.GetManufacturerInfo("Espro", siteName).ManufacturerID
};
var list3 = SKUInfoProvider.GetSKUs(siteID).ToList().Where(sku =>
{
if (sku.IsProduct)
{
return(!manufacturerExceptionList.Contains(sku.SKUManufacturerID));
}
return(false);
}).ToList();
int num1;
IList <int> intList;
if (CustomerInfoProvider.GetCustomers().WhereEquals("CustomerSiteID", siteID).Count < 50)
{
num1 = customerNames.Length;
intList = new List <int>();
for (var index = 0; index < num1; ++index)
{
intList.Add(GenerateCustomer(customerNames[index], siteID).CustomerID);
}
}
else
{
intList = DataHelper.GetIntegerValues(CustomerInfoProvider.GetCustomers().Column("CustomerID")
.WhereEquals("CustomerSiteID", siteID).WhereNotEquals("CustomerEmail", "alex").Tables[0],
"CustomerID");
num1 = intList.Count;
}
var num2 = 0;
var num3 = 0;
for (var index1 = 0; index1 <= 30; ++index1)
{
++num2;
var num4 = 0;
if (index1 > 5)
{
num4 = rand.Next(-1, 2);
}
for (var index2 = 0; index2 < num2 / 2 + num4; ++index2)
{
var orderStatusInfo = index1 >= 25
? index1 >= 29 ? orderStatusList["New"] : orderStatusList["InProgress"]
: orderStatusList["Completed"];
var orderInfo = new OrderInfo
{
OrderCustomerID = intList[num3 % num1],
OrderCurrencyID = currencyInfo.CurrencyID,
OrderSiteID = siteID,
OrderStatusID = orderStatusInfo.StatusID,
OrderIsPaid = "Completed".Equals(orderStatusInfo.StatusName, StringComparison.Ordinal) ||
(uint)rand.Next(0, 2) > 0U,
OrderShippingOptionID = list2[rand.Next(list2.Count)].ShippingOptionID,
OrderPaymentOptionID = list1[rand.Next(list1.Count)].PaymentOptionID,
OrderGrandTotal = decimal.Zero,
OrderGrandTotalInMainCurrency = decimal.Zero,
OrderTotalPrice = decimal.Zero,
OrderTotalPriceInMainCurrency = decimal.Zero,
OrderTotalShipping = new decimal(10),
OrderTotalTax = new decimal(10)
};
OrderInfoProvider.SetOrderInfo(orderInfo);
var orderItems = GenerateOrderItems(orderInfo, list3);
GenerateOrderAddress(orderInfo.OrderID, GetRandomCountryId(), AddressType.Billing);
GenerateOrderAddress(orderInfo.OrderID, GetRandomCountryId(), AddressType.Shipping);
orderInfo.OrderDate = DateTime.Now.AddDays(index1 - 30);
orderInfo.OrderTotalPrice = orderItems;
orderInfo.OrderTotalPriceInMainCurrency = orderItems;
orderInfo.OrderGrandTotal = orderItems;
orderInfo.OrderGrandTotalInMainCurrency = orderItems;
var cartInfoFromOrder = ShoppingCartInfoProvider.GetShoppingCartInfoFromOrder(orderInfo.OrderID);
orderInfo.OrderInvoiceNumber = OrderInfoProvider.GenerateInvoiceNumber(cartInfoFromOrder);
orderInfo.OrderInvoice = ShoppingCartInfoProvider.GetOrderInvoice(cartInfoFromOrder);
OrderInfoProvider.SetOrderInfo(orderInfo);
++num3;
}
}
if (UserInfoProvider.GetUserInfo("alex") != null)
{
return;
}
var customerInfo = new CustomerInfo
{
CustomerEmail = "*****@*****.**",
CustomerFirstName = "Alexander",
CustomerLastName = "Adams",
CustomerSiteID = siteID,
CustomerCompany = "Alex & Co. Ltd",
CustomerTaxRegistrationID = "12S379BDF798",
CustomerOrganizationID = "WRQ7987VRG79"
};
CustomerInfoProvider.SetCustomerInfo(customerInfo);
var userInfo = CustomerInfoProvider.RegisterCustomer(customerInfo, "", "alex");
var roleInfo = RoleInfoProvider.GetRoleInfo("SilverPartner", siteID);
if (roleInfo != null)
{
UserInfoProvider.AddUserToRole(userInfo.UserID, roleInfo.RoleID);
}
for (var index = 0; index < 5; ++index)
{
var cart = new ShoppingCartInfo();
cart.ShoppingCartCulture = CultureHelper.GetDefaultCultureCode(siteName);
cart.ShoppingCartCurrencyID = currencyInfo.CurrencyID;
cart.ShoppingCartSiteID = siteID;
cart.ShoppingCartCustomerID = customerInfo.CustomerID;
cart.ShoppingCartBillingAddress = GenerateAddress(GetRandomCountryId(), customerInfo.CustomerID);
cart.ShoppingCartShippingAddress = GenerateAddress(GetRandomCountryId(), customerInfo.CustomerID);
cart.User = userInfo;
ShoppingCartInfoProvider.SetShoppingCartInfo(cart);
ShoppingCartInfoProvider.SetShoppingCartItem(cart,
new ShoppingCartItemParameters(list3.ElementAt(rand.Next(list3.Count)).SKUID, rand.Next(5)));
cart.Evaluate();
ShoppingCartInfoProvider.SetOrder(cart);
}
}
public int GetUserIDByCustomerID(int customerID)
{
return(CustomerInfoProvider.GetCustomers().WhereEquals("CustomerID", customerID).FirstOrDefault()?.CustomerUserID ?? 0);
}
