protected void SetContextToNewCustomer()
{
SearchCustomerPanel.Visible = false;
CustomerIDPanel.Visible = false;
CustomerID.Text = String.Empty;
FirstName.Text = String.Empty;
LastName.Text = String.Empty;
EMail.Text = String.Empty;
Phone.Text = String.Empty;
RadioButtonList1.SelectedIndex = 0;
Over13.Checked = true;
BillingFirstName.Text = String.Empty;
BillingLastName.Text = String.Empty;
BillingPhone.Text = String.Empty;
BillingCompany.Text = String.Empty;
BillingResidenceType.ClearSelection();
BillingResidenceType.SelectedIndex = 1;
BillingAddress1.Text = String.Empty;
BillingAddress2.Text = String.Empty;
BillingSuite.Text = String.Empty;
BillingCity.Text = String.Empty;
BillingState.ClearSelection();
BillingState.SelectedIndex = 0;
BillingZip.Text = String.Empty;
BillingCountry.ClearSelection();
BillingCountry.SelectedIndex = 0;
ShippingFirstName.Text = String.Empty;
ShippingLastName.Text = String.Empty;
ShippingPhone.Text = String.Empty;
ShippingCompany.Text = String.Empty;
ShippingResidenceType.ClearSelection();
ShippingResidenceType.SelectedIndex = 1;
ShippingAddress1.Text = String.Empty;
ShippingAddress2.Text = String.Empty;
ShippingSuite.Text = String.Empty;
ShippingCity.Text = String.Empty;
ShippingCountry.ClearSelection();
ShippingCountry.SelectedIndex = -1;
ShippingState.ClearSelection();
ShippingState.SelectedIndex = -1;
ShippingZip.Text = String.Empty;
try
{
AffiliateList.SelectedIndex = -1;
AffiliateList.ClearSelection();
}
catch { }
try
{
CustomerLevelList.SelectedIndex = -1;
CustomerLevelList.ClearSelection();
}
catch { }
CreateCustomer.Visible = true;
UseCustomer.Visible = false;
UpdateCustomer.Visible = false;
CreateNewCustomerPanel.Visible = true;
CustomerStatsPanel.Visible = false;
ImpersonationPanel.Visible = false;
Panel3.Visible = false;
Panel2.Visible = false;
}
protected void SetContextToCustomerID(int iCustomerID)
{
CustomerID.Text = iCustomerID.ToString();
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader rs = DB.GetRS("select * from Customer with (NOLOCK) where deleted=0 and IsAdmin=0 and CustomerID=" + iCustomerID.ToString(), conn))
{
if (rs.Read())
{
FirstName.Text = DB.RSField(rs, "FirstName");
LastName.Text = DB.RSField(rs, "LastName");
EMail.Text = DB.RSField(rs, "EMail").ToLowerInvariant().Trim();
Phone.Text = DB.RSField(rs, "Phone");
Over13.Checked = DB.RSFieldBool(rs, "Over13Checked");
RadioButtonList1.SelectedIndex = CommonLogic.IIF(DB.RSFieldBool(rs, "OkToEMail"), 0, 1);
Address BillingAddress = new Address();
BillingAddress.LoadByCustomer(iCustomerID, AddressTypes.Billing);
BillingFirstName.Text = BillingAddress.FirstName;
BillingLastName.Text = BillingAddress.LastName;
BillingPhone.Text = BillingAddress.Phone;
BillingCompany.Text = BillingAddress.Company;
try
{
BillingResidenceType.ClearSelection();
if (BillingAddress.ResidenceType != ResidenceTypes.Unknown)
{
BillingResidenceType.Items.FindByValue(((int)BillingAddress.ResidenceType).ToString()).Selected = true;
}
}
catch { }
BillingAddress1.Text = BillingAddress.Address1;
BillingAddress2.Text = BillingAddress.Address2;
BillingSuite.Text = BillingAddress.Suite;
BillingCity.Text = BillingAddress.City;
try
{
BillingState.SelectedIndex = -1;
BillingState.ClearSelection();
BillingState.Items.FindByValue(BillingAddress.State).Selected = true;
}
catch { }
BillingZip.Text = BillingAddress.Zip;
try
{
BillingCountry.SelectedIndex = -1;
BillingCountry.ClearSelection();
BillingCountry.Items.FindByValue(BillingAddress.Country).Selected = true;
}
catch { }
Address ShippingAddress = new Address();
ShippingAddress.LoadByCustomer(iCustomerID, AddressTypes.Shipping);
ShippingFirstName.Text = ShippingAddress.FirstName;
ShippingLastName.Text = ShippingAddress.LastName;
ShippingPhone.Text = ShippingAddress.Phone;
ShippingCompany.Text = ShippingAddress.Company;
try
{
ShippingResidenceType.ClearSelection();
if (ShippingAddress.ResidenceType != ResidenceTypes.Unknown)
{
ShippingResidenceType.Items.FindByValue(((int)ShippingAddress.ResidenceType).ToString()).Selected = true;
}
}
catch { }
ShippingAddress1.Text = ShippingAddress.Address1;
ShippingAddress2.Text = ShippingAddress.Address2;
ShippingSuite.Text = ShippingAddress.Suite;
ShippingCity.Text = ShippingAddress.City;
try
{
ShippingState.SelectedIndex = -1;
ShippingState.ClearSelection();
ShippingState.Items.FindByValue(ShippingAddress.State).Selected = true;
}
catch { }
ShippingZip.Text = ShippingAddress.Zip;
try
{
ShippingCountry.SelectedIndex = -1;
ShippingCountry.ClearSelection();
ShippingCountry.Items.FindByValue(ShippingAddress.Country).Selected = true;
}
catch { }
try
{
AffiliateList.SelectedIndex = -1;
AffiliateList.ClearSelection();
AffiliateList.Items.FindByValue(DB.RSFieldInt(rs, "AffiliateID").ToString()).Selected = true;
}
catch { }
try
{
CustomerLevelList.SelectedIndex = -1;
CustomerLevelList.ClearSelection();
CustomerLevelList.Items.FindByValue(DB.RSFieldInt(rs, "CustomerLevelID").ToString()).Selected = true;
}
catch { }
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Response.CacheControl = "private";
Response.Expires = 0;
Response.AddHeader("pragma", "no-cache");
/****************************************************************************/
// * WARNING TO DEVELOPERS
// * The redirect below is a SAFETY feature. Removing the redirect will not
// * enable ML-only features on a lower version of AspDotNetStorefront.
// * Attempting to do so can very easily result in a partially implemented
// * feature, invalid or incomplete data in your DB, and other serious
// * conditions that will cause your store to be non-functional.
// *
// * If you break your store attempting to enable ML-only features in PRO or
// * Standard, our staff cannot help you fix it, and it will also invalidate
// * your AspDotNetStorefront License.
/***************************************************************************/
if (AppLogic.ProductIsMLExpress())
{
Response.Redirect(AppLogic.AdminLinkUrl("restrictedfeature.aspx"));
}
m_OrderNumber = CommonLogic.QueryStringUSInt("OrderNumber");
GetJavaScriptFunctions();
if (!IsPostBack)
{
saveOrderNumber.Text = m_OrderNumber.ToString();
if (AppLogic.AppConfigBool("PhoneOrder.EMailIsOptional"))
{
valRegExValEmail.Enabled = false;
}
BillingState.ClearSelection();
BillingState.Items.Clear();
ShippingState.ClearSelection();
ShippingState.Items.Clear();
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader rs = DB.GetRS("select * from State with (NOLOCK) order by DisplayOrder,Name", conn))
{
ShippingState.DataValueField = "Abbreviation";
ShippingState.DataTextField = "Name";
ShippingState.DataSource = rs;
ShippingState.DataBind();
}
}
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader rs = DB.GetRS("select * from State with (NOLOCK) order by DisplayOrder,Name", conn))
{
BillingState.DataValueField = "Abbreviation";
BillingState.DataTextField = "Name";
BillingState.DataSource = rs;
BillingState.DataBind();
}
}
ShippingCountry.ClearSelection();
ShippingCountry.Items.Clear();
BillingCountry.ClearSelection();
BillingCountry.Items.Clear();
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader rs = DB.GetRS("select * from Country with (NOLOCK) order by DisplayOrder,Name", conn))
{
ShippingCountry.DataValueField = "Name";
ShippingCountry.DataTextField = "Name";
ShippingCountry.DataSource = rs;
ShippingCountry.DataBind();
}
}
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader rs = DB.GetRS("select * from Country with (NOLOCK) order by DisplayOrder,Name", conn))
{
BillingCountry.DataValueField = "Name";
BillingCountry.DataTextField = "Name";
BillingCountry.DataSource = rs;
BillingCountry.DataBind();
}
}
AffiliateList.ClearSelection();
AffiliateList.Items.Clear();
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader rs = DB.GetRS("select AffiliateID,Name,DisplayOrder from Affiliate with (NOLOCK) union select 0,'--N/A--', 0 from Affiliate with (NOLOCK) order by DisplayOrder,Name", conn))
{
AffiliateList.DataSource = rs;
AffiliateList.DataBind();
if (AffiliateList.Items.Count == 0)
{
AffiliateList.Visible = false;
AffiliatePrompt.Visible = false;
}
}
}
CustomerLevelList.ClearSelection();
CustomerLevelList.Items.Clear();
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader dr = DB.GetRS("select CustomerLevelID,Name,DisplayOrder from CustomerLevel with (NOLOCK) union select 0,'--N/A--', 0 from CustomerLevel with (NOLOCK) order by DisplayOrder,Name", conn))
{
while (dr.Read())
{
CustomerLevelList.Items.Add(new ListItem(DB.RSFieldByLocale(dr, "Name", LocaleSetting), DB.RSFieldInt(dr, "CustomerLevelID").ToString()));
}
}
}
ThisCustomer.ThisCustomerSession.ClearVal("IGD_EDITINGORDER");
// are we order editing?
if (m_OrderNumber != 0)
{
ThisCustomer.ThisCustomerSession["IGD_EDITINGORDER"] = m_OrderNumber.ToString();
// setup cart to match order:
DB.ExecuteSQL("aspdnsf_EditOrder " + m_OrderNumber.ToString());
Button89.Visible = true;
Button90.Visible = true;
Button91.Visible = true;
helpphone.Visible = false;
helporderedit.Visible = true;
backtoorderlink.NavigateUrl = AppLogic.AdminLinkUrl("orders.aspx") + "?ordernumber=" + m_OrderNumber.ToString();
content.Visible = false;
SearchCustomerPanel.Visible = false;
txtordernumber.Text = m_OrderNumber.ToString();
Order ord = new Order(m_OrderNumber);
// use customer as is:
TopPanel.Visible = false;
SearchCustomerPanel.Visible = false;
CreateNewCustomerPanel.Visible = false;
CustomerStatsPanel.Visible = true;
CreateCustomer.Visible = false;
UseCustomer.Visible = false;
UpdateCustomer.Visible = false;
SetContextToCustomerID(ord.CustomerID);
UsingCustomerID.Text = CustomerID.Text;
UsingFirstName.Text = FirstName.Text;
UsingLastName.Text = LastName.Text;
UsingEMail.Text = EMail.Text.ToLowerInvariant().Trim();
SetToImpersonationPageContext(ord.CustomerID, "../shoppingcart.aspx", false);
}
}
else
{
m_OrderNumber = System.Int32.Parse(saveOrderNumber.Text);
}
bool RequireEmail = !(AppLogic.AppConfigBool("PasswordIsOptionalDuringCheckout") && !AppLogic.AppConfigBool("AnonCheckoutReqEmail"));
RequiredEmailValidator.Enabled = RequireEmail;
lblRequiredEmailAsterix.Visible = RequireEmail;
}
protected void Page_Load(object sender, EventArgs e)
{
Response.CacheControl = "private";
Response.Expires = 0;
Response.AddHeader("pragma", "no-cache");
m_OrderNumber = CommonLogic.QueryStringUSInt("OrderNumber");
GetJavaScriptFunctions();
if (!IsPostBack)
{
saveOrderNumber.Text = m_OrderNumber.ToString();
if (AppLogic.AppConfigBool("PhoneOrder.EMailIsOptional"))
{
valRegExValEmail.Enabled = false;
}
BillingState.ClearSelection();
BillingState.Items.Clear();
ShippingState.ClearSelection();
ShippingState.Items.Clear();
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader rs = DB.GetRS("select * from State with (NOLOCK) order by DisplayOrder,Name", conn))
{
ShippingState.DataValueField = "Abbreviation";
ShippingState.DataTextField = "Name";
ShippingState.DataSource = rs;
ShippingState.DataBind();
}
}
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader rs = DB.GetRS("select * from State with (NOLOCK) order by DisplayOrder,Name", conn))
{
BillingState.DataValueField = "Abbreviation";
BillingState.DataTextField = "Name";
BillingState.DataSource = rs;
BillingState.DataBind();
}
}
ShippingCountry.ClearSelection();
ShippingCountry.Items.Clear();
BillingCountry.ClearSelection();
BillingCountry.Items.Clear();
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader rs = DB.GetRS("select * from Country with (NOLOCK) order by DisplayOrder,Name", conn))
{
ShippingCountry.DataValueField = "Name";
ShippingCountry.DataTextField = "Name";
ShippingCountry.DataSource = rs;
ShippingCountry.DataBind();
}
}
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader rs = DB.GetRS("select * from Country with (NOLOCK) order by DisplayOrder,Name", conn))
{
BillingCountry.DataValueField = "Name";
BillingCountry.DataTextField = "Name";
BillingCountry.DataSource = rs;
BillingCountry.DataBind();
}
}
AffiliateList.ClearSelection();
AffiliateList.Items.Clear();
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader rs = DB.GetRS("select AffiliateID,Name,DisplayOrder from Affiliate with (NOLOCK) union select 0,'--N/A--', 0 from Affiliate with (NOLOCK) order by DisplayOrder,Name", conn))
{
AffiliateList.DataSource = rs;
AffiliateList.DataBind();
if (AffiliateList.Items.Count == 0)
{
AffiliateList.Visible = false;
AffiliatePrompt.Visible = false;
}
}
}
CustomerLevelList.ClearSelection();
CustomerLevelList.Items.Clear();
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader dr = DB.GetRS("select CustomerLevelID,Name,DisplayOrder from CustomerLevel with (NOLOCK) union select 0,'--N/A--', 0 from CustomerLevel with (NOLOCK) order by DisplayOrder,Name", conn))
{
while (dr.Read())
{
CustomerLevelList.Items.Add(new ListItem(DB.RSFieldByLocale(dr, "Name", LocaleSetting), DB.RSFieldInt(dr, "CustomerLevelID").ToString()));
}
}
}
ThisCustomer.ThisCustomerSession.ClearVal("IGD_EDITINGORDER");
// are we order editing?
if (m_OrderNumber != 0)
{
ThisCustomer.ThisCustomerSession["IGD_EDITINGORDER"] = m_OrderNumber.ToString();
// setup cart to match order:
DB.ExecuteSQL("aspdnsf_EditOrder " + m_OrderNumber.ToString());
Button89.Visible = true;
Button90.Visible = true;
Button91.Visible = true;
helpphone.Visible = false;
helporderedit.Visible = true;
backtoorderlink.NavigateUrl = AppLogic.AdminLinkUrl("orders.aspx") + "?ordernumber=" + m_OrderNumber.ToString();
content.Visible = false;
SearchCustomerPanel.Visible = false;
txtordernumber.Text = m_OrderNumber.ToString();
Order ord = new Order(m_OrderNumber);
// use customer as is:
TopPanel.Visible = false;
SearchCustomerPanel.Visible = false;
CreateNewCustomerPanel.Visible = false;
CustomerStatsPanel.Visible = true;
CreateCustomer.Visible = false;
UseCustomer.Visible = false;
UpdateCustomer.Visible = false;
SetContextToCustomerID(ord.CustomerID);
UsingCustomerID.Text = CustomerID.Text;
UsingFirstName.Text = FirstName.Text;
UsingLastName.Text = LastName.Text;
UsingEMail.Text = EMail.Text.ToLowerInvariant().Trim();
SetToImpersonationPageContext(ord.CustomerID, "../shoppingcart.aspx", false);
}
}
else
{
m_OrderNumber = System.Int32.Parse(saveOrderNumber.Text);
}
bool RequireEmail = !(AppLogic.AppConfigBool("PasswordIsOptionalDuringCheckout") && !AppLogic.AppConfigBool("AnonCheckoutReqEmail"));
RequiredEmailValidator.Enabled = RequireEmail;
lblRequiredEmailAsterix.Visible = RequireEmail;
}