/// <summary>
/// Binds the address data to controls
/// </summary>
/// <param name="itemID">item id of the address data</param>
private void BindAddressData(int itemID)
{
try
{
AddressInfo addressData = AddressInfoProvider.GetAddresses()
.WhereEquals("AddressID", itemID)
.FirstOrDefault();
if (!DataHelper.DataSourceIsEmpty(addressData))
{
txtAddressLine1.Text = addressData.AddressLine1;
txtAddressLine2.Text = addressData.AddressLine2;
txtCity.Text = addressData.AddressCity;
txtZipcode.Text = addressData.AddressZip;
txtName.Text = addressData.AddressPersonalName;
txtTelephone.Text = addressData.AddressPhone;
uniSelectorCountry.Value = addressData.AddressCountryID;
uniSelectorState.Value = addressData.AddressStateID;
txtEmail.Text = addressData.GetStringValue("Email", string.Empty);
txtComapnyName.Text = addressData.GetStringValue("CompanyName", string.Empty);
ddlAddressType.Value = addressData.GetStringValue("AddressTypeID", string.Empty);
if (addressData.AddressStateID <= 0)
{
uniSelectorState.Enabled = false;
}
}
}
catch (Exception ex)
{
EventLogProvider.LogException("CreateAddress.ascx.cs", "BindAddressData()", ex);
}
}
/// <summary>
/// Load data of editing address.
/// </summary>
/// <param name="addressObj">Address object</param>
protected void LoadData(AddressInfo addressObj)
{
txtAddressZip.Text = addressObj.AddressZip;
txtAddressDeliveryPhone.Text = addressObj.AddressPhone;
txtPersonalName.Text = addressObj.AddressPersonalName;
//txtAddressName.Text = addressObj.AddressName;
txtAddressLine1.Text = addressObj.AddressLine1;
chkAddressEnabled.Checked = addressObj.AddressEnabled;
txtAddressLine2.Text = addressObj.AddressLine2;
txtAddressCity.Text = addressObj.AddressCity;
txtnum.Text = addressObj.GetStringValue("AddressNumber", string.Empty);
ucCountrySelector.CountryID = addressObj.AddressCountryID;
ucCountrySelector.StateID = addressObj.AddressStateID;
}
/// <summary>
/// Load data of editing address.
/// </summary>
/// <param name="addressObj">Address object</param>
protected void LoadData(AddressInfo addressObj)
{
txtAddressZip.Text = addressObj.AddressZip;
txtAddressDeliveryPhone.Text = addressObj.AddressPhone;
txtPersonalName.Text = addressObj.AddressPersonalName;
//txtAddressName.Text = addressObj.AddressName;
txtAddressLine1.Text = addressObj.AddressLine1;
chkAddressEnabled.Checked = addressObj.AddressEnabled;
txtAddressLine2.Text = addressObj.AddressLine2;
txtAddressCity.Text = addressObj.AddressCity;
txtnum.Text = addressObj.GetStringValue("AddressNumber", string.Empty);
//drpAddressType.SelectedValue = AddressInfoProvider.GetAddressString(addressObj.AddressType);
chkAddressIsBilling.Checked = addressObj.AddressIsBilling;
chkAddressIsShipping.Checked = addressObj.AddressIsShipping;
chkAddressIsCompany.Checked = addressObj.AddressIsCompany;
ucCountrySelector.CountryID = addressObj.AddressCountryID;
ucCountrySelector.StateID = addressObj.AddressStateID;
}
private void sendconf2(UserInfo ui, string emailtype, string[,] macros)
{
SiteInfo currentSite = SiteContext.CurrentSite;
ContextResolver resolver = MacroContext.CurrentResolver;
EventLogProvider ev = new EventLogProvider();
bool requiresConfirmation = SettingsKeyInfoProvider.GetBoolValue(currentSite.SiteName + ".CMSRegistrationEmailConfirmation");
bool requiresAdminApprove = false;
bool SendWelcomeEmail = true;
#region "Welcome Emails (confirmation, waiting for approval)"
bool error = false;
// EventLogProvider ev = new EventLogProvider();
// EmailTemplateInfo template = null;
string emailSubject = null;
string templateName = null;
EmailTemplateInfo template = null;
// Send welcome message with username and password, with confirmation link, user must confirm registration
template = EmailTemplateProvider.GetEmailTemplate("E-commerce-OrderNotificationToCustomerBO", currentSite.SiteName);
emailSubject = EmailHelper.GetSubject(template, "Votre commande: " + ShoppingCart.Order.OrderID);
//mail type
if (template != null)
{
EventLogProvider p = new EventLogProvider();
p.LogEvent("I", DateTime.Now, "test 11", "code BO");
// Set resolver
resolver.SourceParameters = macros;
// Email message
EmailMessage email = new EmailMessage();
email.EmailFormat = EmailFormatEnum.Default;
email.Recipients = ShoppingCart.Customer.CustomerEmail;
p.LogEvent("I", DateTime.Now, "MAIL: " + ShoppingCart.Customer.CustomerEmail, "code BO");
email.From = SettingsKeyInfoProvider.GetStringValue(currentSite.SiteName + ".CMSStoreSendEmailsFrom");//EmailHelper.GetSender(template, SettingsKeyProvider.GetStringValue(currentSite.SiteName + ".CMSStoreSendEmailsTo"));
p.LogEvent("I", DateTime.Now, "MAIL: " + SettingsKeyInfoProvider.GetStringValue(currentSite.SiteName + ".CMSStoreSendEmailsTo"), "code BO");
//string templatetext = template.TemplateText.Replace("\r\n\t\tVotre compte 2MAD a �t� cr��. Veuillez valider votre inscription en cliquant sur le lien ci-dessous. <br />\r\n<a href=\"{%confirmaddress%}\">{%confirmaddress%}</a>\r\n<br />\r\n<br />\r\nVos identifiants :", " ");
int n = ShoppingCart.ShoppingCartBillingAddressID; //ECommerceContext.CurrentShoppingCart.ShoppingCartBillingAddressID
//take address info
SqlConnection con3 = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString"].ConnectionString);
con3.Open();
var stringQuery = "select * from COM_Address WHERE AddressID = " + n;
SqlCommand cmd3 = new SqlCommand(stringQuery, con3);
IDataReader reader = cmd3.ExecuteReader();
AddressInfo ai2 = new AddressInfo();
var temp = "";
while (reader.Read())
{
ai2.AddressLine1 = Convert.ToString(reader.GetValue(2));
ai2.AddressLine2 = Convert.ToString(reader.GetValue(3));
temp = ai2.GetStringValue(Convert.ToString(reader.GetValue(17)), Convert.ToString(reader.GetValue(17)));
ai2.AddressZip = Convert.ToString(reader.GetValue(5));
ai2.AddressCity = Convert.ToString(reader.GetValue(4));
ai2.AddressCountryID = Convert.ToInt32(reader.GetValue(8));
}
con3.Dispose();
// Take country name
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString"].ConnectionString);
con.Open();
var stringQuery2 = " select CountryName from CMS_Country where CountryID = " + ai2.AddressCountryID;
SqlCommand cmd2 = new SqlCommand(stringQuery2, con);
string c = (string)cmd2.ExecuteScalar();
con.Dispose();
// take sous total {%(TotalPrice-TotalShipping).Format(Currency.CurrencyFormatString)#%}
var s1 = ShoppingCart.TotalPrice - ShoppingCart.TotalShipping;
string s = CurrencyInfoProvider.GetFormattedPrice(s1, ShoppingCart.Currency).ToString();
// take frais d'envoi {%TotalShipping.Format(Currency.CurrencyFormatString)#%}
var fr = ShoppingCart.TotalShipping;
string frais = CurrencyInfoProvider.GetFormattedPrice(fr, ShoppingCart.Currency).ToString();
// take {%TotalPrice.Format(Currency.CurrencyFormatString)#%}
var pr = ShoppingCart.TotalPrice;
string prix = CurrencyInfoProvider.GetFormattedPrice(pr, ShoppingCart.Currency).ToString();
// take items
string panier = "<table cellpadding='0' cellspacing='0'> <tbody>";
foreach (ShoppingCartItemInfo item in ShoppingCart.CartItems)
{
var t1 = item.TotalPrice;
string total = CurrencyInfoProvider.GetFormattedPrice(t1, ShoppingCart.Currency).ToString();
panier = panier + "<tr valign='top'>";
panier = panier + "<td style='background-color:#e4e4e4;padding:8px 10px;margin-bottom:10px;display:block'> <table cellpadding='0' cellspacing='0'> <tbody> <tr valign='middle'> <td style='color:#3c3341;font-size:11px;font-family:Arial,Helvetica,sans-serif;text-transform:uppercase;border-right:#b3b3b3 1px solid' width='265' height='30'>" + item.SKU.SKUName + "</td> <td style='background-color:#fff;color:#241d29;font-size:16px;font-family:Arial,Helvetica,sans-serif;font-weight:bold;text-align:center;margin:0 10px;display:block;vertical-align:middle;line-height:30px' width='37' height='30'>" + item.CartItemUnits + "</td><td style='color:#241d29;font-size:16px;font-family:Arial,Helvetica,sans-serif;text-transform:uppercase;font-weight:bold;border-left:#b3b3b3 1px solid;text-align:center' width='70' height='30'> " + total + "</td></tr></tbody></table></td>";
panier = panier + "</tr>";
}
panier = panier + "</tbody> </table >";
string templatetext = template.TemplateText.Replace("#number", ShoppingCart.Order.OrderInvoiceNumber).Replace("#facturation", "<b>" + ShoppingCart.Customer.CustomerFirstName + " " + ShoppingCart.Customer.CustomerLastName + "</b><br/>" + temp + " " + ai2.AddressLine1 + "<br/>" + ai2.AddressLine2 + "<br/>" + ai2.AddressZip + " " + ai2.AddressCity + "<br/>" + c).Replace("#shipping", ShoppingCart.ShippingOption.ShippingOptionDisplayName).Replace("#payment", ShoppingCart.PaymentOption.PaymentOptionDisplayName).Replace("#soustotal", s).Replace("#prixtotal", prix).Replace("#fraisdenvoi", frais).Replace("#items", panier);
email.Body = resolver.ResolveMacros(templatetext);
resolver.EncodeResolvedValues = false;
email.PlainTextBody = resolver.ResolveMacros(template.TemplatePlainText);
email.Subject = resolver.ResolveMacros(emailSubject);
//email.CcRecipients = "*****@*****.**";
//p.LogEvent("I",DateTime.Now,"mail admin"+ShoppingCart,"code BO");
email.CcRecipients = template.TemplateCc;
email.BccRecipients = template.TemplateBcc;
try
{
MetaFileInfoProvider.ResolveMetaFileImages(email, template.TemplateID, EmailObjectType.EMAILTEMPLATE, MetaFileInfoProvider.OBJECT_CATEGORY_TEMPLATE);
// Send the e-mail immediately
EmailSender.SendEmail(currentSite.SiteName, email, true);
p.LogEvent("I", DateTime.Now, "after try ttt", "code BO");
}
catch (Exception ex)
{
ev.LogEvent("E", "EMAIL NON ENVOYE", ex);
}
}
#endregion
}
protected void rptAdressItemDataBound(object sender, RepeaterItemEventArgs e)
{
System.Globalization.CultureInfo currentUI = System.Globalization.CultureInfo.CurrentUICulture;
AjaxControlToolkit.ConfirmButtonExtender cbe = new AjaxControlToolkit.ConfirmButtonExtender();
cbe = (AjaxControlToolkit.ConfirmButtonExtender)e.Item.FindControl("ConfirmButtonDelete");
if (cbe != null)
{
cbe.ConfirmText = GetString("msgconfirm");
}
var drv = (System.Data.DataRowView)e.Item.DataItem;
if (drv != null)
{
int currentAdressID = ValidationHelper.GetInteger(drv["AddressID"], 0);
if (currentAdressID > 0)
{
AddressInfo ai = AddressInfoProvider.GetAddressInfo(currentAdressID);
if (ai != null)
{
var ltlAdress = e.Item.FindControl("ltlAdress") as Literal;
if (ltlAdress != null)
{
int countryID = ai.AddressCountryID;
ltlAdress.Text = string.Format("{0}, {1}", ai.AddressName, MacroContext.CurrentResolver.ResolveMacros(CountryInfoProvider.GetCountryInfo(countryID).CountryDisplayName));
}
var txtnumero = e.Item.FindControl("txtnumero") as TextBox;
if (txtnumero != null)
{
txtnumero.Text = ai.GetStringValue("AddressNumber", string.Empty).Trim();
txtnumero.ToolTip = GetString("numerorue");
}
var wmnumero = e.Item.FindControl("wmnumero") as AjaxControlToolkit.TextBoxWatermarkExtender;
if (wmnumero != null)
{
wmnumero.WatermarkText = GetString("numerorue");
}
var txtadresse1 = e.Item.FindControl("txtadresse1") as TextBox;
if (txtadresse1 != null)
{
txtadresse1.Text = ai.AddressLine1.Trim();
txtadresse1.ToolTip = GetString("adresse1");
}
var wmadresse1 = e.Item.FindControl("wmadresse1") as AjaxControlToolkit.TextBoxWatermarkExtender;
if (wmadresse1 != null)
{
wmadresse1.WatermarkText = GetString("adresse1");
}
var txtadresse2 = e.Item.FindControl("txtadresse2") as TextBox;
if (txtadresse2 != null)
{
txtadresse2.Text = ai.AddressLine2.Trim() == string.Empty ? string.Empty : ai.AddressLine2.Trim();
txtadresse2.ToolTip = GetString("adresse2");
}
var wmadresse2 = e.Item.FindControl("wmadresse2") as AjaxControlToolkit.TextBoxWatermarkExtender;
if (wmadresse2 != null)
{
wmadresse2.WatermarkText = GetString("adresse2");
}
var txtcp = e.Item.FindControl("txtcp") as TextBox;
if (txtcp != null)
{
txtcp.Text = ai.AddressZip.Trim();
txtcp.ToolTip = GetString("cp");
}
var wmcp = e.Item.FindControl("wmcp") as AjaxControlToolkit.TextBoxWatermarkExtender;
if (wmcp != null)
{
wmcp.WatermarkText = GetString("cp");
}
var txtville = e.Item.FindControl("txtville") as TextBox;
if (txtville != null)
{
txtville.Text = ai.AddressCity.Trim();
txtville.ToolTip = GetString("ville");
}
var wmville = e.Item.FindControl("wmville") as AjaxControlToolkit.TextBoxWatermarkExtender;
if (wmville != null)
{
wmville.WatermarkText = GetString("ville");
}
var txtCountry = e.Item.FindControl("txtCountry") as TextBox;
if (txtCountry != null)
{
txtCountry.Text = MacroContext.CurrentResolver.ResolveMacros(
GetString(CountryInfoProvider.GetCountryInfo(ai.AddressCountryID).CountryDisplayName));
}
var chkShippingAddr = e.Item.FindControl("chkShippingAddr") as CheckBox;
if (chkShippingAddr != null)
{
chkShippingAddr.Checked = ai.AddressIsShipping;
}
var chkBillingAddr = e.Item.FindControl("chkBillingAddr") as CheckBox;
if (chkBillingAddr != null)
{
chkBillingAddr.Checked = ai.AddressIsBilling;
}
}
}
}
}
protected void rptAdressItemCommand(object source, RepeaterCommandEventArgs e)
{
// Get AddressId from the row
int AddressId = ValidationHelper.GetInteger(e.CommandArgument, 0);
// Delete selected address
if (e.CommandName.Equals("Remove"))
{
int idShoppingCart = 0;
// EventLogProvider ev = new EventLogProvider();
// test du nombre d'adresse
int idCustomer = ECommerceContext.CurrentCustomer.CustomerID;
string where, orderby;
where = "AddressEnabled = 1 AND AddressCustomerID = " + idCustomer;
orderby = "AddressID";
InfoDataSet <AddressInfo> listadresse = AddressInfoProvider.GetAddresses(where, orderby);
if (listadresse.Tables[0].Rows.Count <= 1)
{
return;
}
else
{
// Delete AddressInfo object from database if address not used for order
if ((OrderBillingAddress(AddressId) == 0) && (OrderShippingAddress(AddressId) == 0))
{
SqlConnection con4 = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString"].ConnectionString);
var query = "Select ShoppingCartID from COM_ShoppingCart where ShoppingCartShippingAddressID = " + AddressId;
SqlCommand cmd2 = new SqlCommand(query, con4);
// ev.LogEvent("I", DateTime.Now, "ds billig&shipping=0", "code");
con4.Open();
try
{
idShoppingCart = (int)cmd2.ExecuteScalar();
// ev.LogEvent("I", DateTime.Now, "dans try " + idShoppingCart, "code");
}
catch (Exception ex)
{
}
con4.Close();
if (idShoppingCart != 0)
{
var query2 = "Delete from COM_ShoppingCartSKU WHERE ShoppingCartID = " + idShoppingCart;
SqlCommand cmd1 = new SqlCommand(query2, con4);
cmd1.ExecuteScalar();
var stringQuery = "Delete from COM_ShoppingCart WHERE ShoppingCartShippingAddressID = " + AddressId;
SqlCommand cmd3 = new SqlCommand(stringQuery, con4);
cmd3.ExecuteScalar();
con4.Dispose();
}
if (Session["newAddress"] != null)
{
int temp2 = Int32.Parse(Session["newAddress"].ToString());
if (temp2 != 0)
{
if (temp2 == AddressId)
{
Session["newAddress"] = null;
}
}
}
AddressInfoProvider.DeleteAddressInfo(AddressId);
//ev.LogEvent("I", DateTime.Now, "button delete enabled true", "code");
//
int id1 = ECommerceContext.CurrentCustomer.CustomerID;
}
// Disable AddressInfo object from database if address used for order
else
{
SqlConnection con3 = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString"].ConnectionString);
// con3.Open();
// ev.LogEvent("I", DateTime.Now, "iD = " + AddressId, "code");
var query = "Select ShoppingCartID from COM_ShoppingCart where ShoppingCartShippingAddressID = " + AddressId;
SqlCommand cmd2 = new SqlCommand(query, con3);
// ev.LogEvent("I", DateTime.Now, "test", "code");
con3.Open();
try
{
idShoppingCart = (int)cmd2.ExecuteScalar();
con3.Dispose();
}
catch (Exception ex)
{
}
con3.Close();
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString"].ConnectionString);
// ev.LogEvent("I", DateTime.Now, "idShoppingCart = " + idShoppingCart, "code");
if (idShoppingCart != 0)
{
connect.Open();
var query2 = "Delete from COM_ShoppingCartSKU WHERE ShoppingCartID = " + idShoppingCart;
SqlCommand cmd1 = new SqlCommand(query2, connect);
cmd1.ExecuteScalar();
var stringQuery = "Delete from COM_ShoppingCart WHERE ShoppingCartShippingAddressID = " + AddressId;
SqlCommand cmd3 = new SqlCommand(stringQuery, connect);
cmd3.ExecuteScalar();
connect.Close();
Response.Redirect("~/Special-Page/Mon-compte.aspx");
}
// ev.LogEvent("I", DateTime.Now, "btn delet enabled false", "code");
AddressInfo UpdateAdress = AddressInfoProvider.GetAddressInfo(AddressId);
CustomerInfo uc = ECommerceContext.CurrentCustomer;
UpdateAdress.AddressEnabled = false;
UpdateAdress.AddressCustomerID = mCustomerId;
AddressInfoProvider.SetAddressInfo(UpdateAdress);
AddressId = UpdateAdress.AddressID;
}
}
ReloadDataAdress();
// PnlInsertAdress.Visible = false;
}
// Update selected adress
if (e.CommandName.Equals("Update"))
{
// lblErrorAdress
var lblErrorAdress = e.Item.FindControl("lblErrorAdress") as Label;
// chkShippingAddr
var chkShippingAddr = e.Item.FindControl("chkShippingAddr") as CheckBox;
// chkBillingAddr
var chkBillingAddr = e.Item.FindControl("chkBillingAddr") as CheckBox;
if (!chkBillingAddr.Checked && !chkShippingAddr.Checked)
{
lblErrorAdress.Text = "V�rifier le type d'adresse";
lblErrorAdress.Visible = true;
return;
}
int AddressID = Convert.ToInt32(e.CommandArgument);
AddressInfo ai = AddressInfoProvider.GetAddressInfo(AddressID);
string s = ai.AddressZip;
// txtnumero
var txtnumero = e.Item.FindControl("txtnumero") as TextBox;
if (txtnumero != null)
{
ai.SetValue("AddressNumber", txtnumero.Text);
}
// txtadresse1
var txtadresse1 = e.Item.FindControl("txtadresse1") as TextBox;
if (txtadresse1 != null)
{
ai.AddressLine1 = txtadresse1.Text;
}
// txtadresse2
var txtadresse2 = e.Item.FindControl("txtadresse2") as TextBox;
if (txtadresse2 != null)
{
ai.AddressLine2 = txtadresse2.Text;
}
// txtcp
TextBox txtcp = e.Item.FindControl("txtcp") as TextBox;
if (txtcp != null)
{
ai.AddressZip = txtcp.Text;
// Response.Write("<script>alert('This is Alert " + txtcp.Text + " " + DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss.fff tt") + "');</script>");
}
// txtville
var txtville = e.Item.FindControl("txtville") as TextBox;
if (txtville != null)
{
ai.AddressCity = txtville.Text;
}
// chkShippingAddr
if (chkShippingAddr != null)
{
ai.AddressIsShipping = chkShippingAddr.Checked;
}
// chkBillingAddr
if (chkBillingAddr != null)
{
ai.AddressIsBilling = chkBillingAddr.Checked;
}
CustomerInfo uc = ECommerceContext.CurrentCustomer;
string mCustomerName = string.Format("{0} {1}", uc.CustomerFirstName, uc.CustomerLastName);
// Set the properties
ai.AddressName = string.Format("{0}, {4} {1} - {2} {3}", mCustomerName, ai.AddressLine1, ai.AddressZip, ai.AddressCity, ai.GetStringValue("AddressNumber", string.Empty));
AddressInfoProvider.SetAddressInfo(ai);
// Update page here
ReloadDataAdress();
}
}