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);
}