private void BindCommande() { var customer = CustomerInfoProvider.GetCustomerInfoByUserID(MembershipContext.AuthenticatedUser.UserID); if (customer == null) { return; } var customerID = customer.CustomerID; var filtre = String.Format("OrderCustomerID = {0}", customerID); try { var ds = OrderInfoProvider.GetOrderList(filtre, "OrderDate DESC"); rptCommande.DataSource = ds.Tables[0]; rptCommande.DataBind(); } catch (Exception ex) { lbInfo.Visible = true; lbInfo.Text = ex.Message; } }
public static List <AddressInfo> GetAdresses(bool billing, bool shipping, ShoppingCartInfo cart) { List <AddressInfo> Result = new List <AddressInfo>(); if (ECommerceContext.CurrentCustomer == null) { return(Result); } //if customer have no [AddressEnabled] int idCustomer = ECommerceContext.CurrentCustomer.CustomerID; SqlConnection con3 = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString"].ConnectionString); con3.Open(); var stringQuery = "select count(AddressID) as NbAdress from COM_Address WHERE COM_Address.AddressEnabled = 'true' AND COM_Address.AddressCustomerID = " + idCustomer; SqlCommand cmd3 = new SqlCommand(stringQuery, con3); int nb = (int)cmd3.ExecuteScalar(); if (nb == 0) { Result = null; return(Result); } string where = string.Empty, orderby = string.Empty; AddressInfo ai; DataSet ds, dsoi = null; if (billing) { ai = AddressInfoProvider.GetAddressInfo(cart.ShoppingCartBillingAddressID); if (ai == null) { where = string.Format("OrderCustomerID={0}", ECommerceContext.CurrentCustomer.CustomerID.ToString()); orderby = "OrderID DESC"; dsoi = OrderInfoProvider.GetOrderList(where, orderby); if (!DataHelper.DataSourceIsEmpty(dsoi)) { foreach (DataRow drow in dsoi.Tables[0].Rows) { OrderInfo oi = new OrderInfo(drow); AddressInfo bai = AddressInfoProvider.GetAddressInfo(oi.OrderBillingAddressID); if (bai.AddressEnabled && bai.AddressIsBilling) { ai = bai; cart.ShoppingCartBillingAddressID = bai.AddressID; break; } } } } if (ai == null) { where = string.Format("AddressCustomerID={0} AND AddressIsBilling=1", ECommerceContext.CurrentCustomer.CustomerID.ToString()); orderby = "AddressID"; ds = AddressInfoProvider.GetAddresses(where, orderby); if (!DataHelper.DataSourceIsEmpty(ds)) { ai = new AddressInfo(ds.Tables[0].Rows[0]); cart.ShoppingCartBillingAddressID = ai.AddressID; } } Result.Add(ai); } if (shipping) { ai = AddressInfoProvider.GetAddressInfo(cart.ShoppingCartShippingAddressID); if (ai == null) { if (DataHelper.DataSourceIsEmpty(dsoi)) { // where = string.Format("OrderCustomerID={0}", ECommerceContext.CurrentCustomer.CustomerID.ToString()); where = string.Format("OrderCustomerID={0} ", ECommerceContext.CurrentCustomer.CustomerID.ToString()); orderby = "OrderID DESC"; dsoi = OrderInfoProvider.GetOrderList(where, orderby); } if (!DataHelper.DataSourceIsEmpty(dsoi)) { foreach (DataRow drow in dsoi.Tables[0].Rows) { OrderInfo oi = new OrderInfo(drow); AddressInfo sai = AddressInfoProvider.GetAddressInfo(oi.OrderShippingAddressID); if (sai.AddressEnabled && sai.AddressIsShipping) { ai = sai; cart.ShoppingCartShippingAddressID = sai.AddressID; break; } } } } if (ai == null) { where = string.Format("AddressCustomerID={0} AND AddressIsShipping=1", ECommerceContext.CurrentCustomer.CustomerID.ToString()); orderby = "AddressID"; ds = AddressInfoProvider.GetAddresses(where, orderby); if (!DataHelper.DataSourceIsEmpty(ds)) { ai = new AddressInfo(ds.Tables[0].Rows[0]); cart.ShoppingCartShippingAddressID = ai.AddressID; } else { // NO SHIPPING ADDRESS DEFINED- PICK FIRST BILLING ADDRESS AddressInfo ai_shipping = AddressInfoProvider.GetAddressInfo(cart.ShoppingCartBillingAddressID); ai_shipping.AddressIsShipping = true; AddressInfoProvider.SetAddressInfo(ai_shipping); // where = string.Format("AddressCustomerID={0} AND AddressIsShipping=1", ECommerceContext.CurrentCustomer.CustomerID.ToString()); where = string.Format("AddressCustomerID={0} AND AddressIsShipping=1", ECommerceContext.CurrentCustomer.CustomerID.ToString()); ds = AddressInfoProvider.GetAddresses(where, orderby); if (!DataHelper.DataSourceIsEmpty(ds)) { ai = new AddressInfo(ds.Tables[0].Rows[0]); cart.ShoppingCartShippingAddressID = ai.AddressID; } } } Result.Add(ai); } return(Result); }