protected void Page_Load(object sender, EventArgs e) { changeRegex(null, null); if (master == null) { master = (IdeaHeaderAndSide)this.Page.Master; } if (!IsPostBack) { if (Session["ID_Cust"] == null) { createMode(); } else { editMode(); loadCustomer(Convert.ToInt32(Session["ID_Cust"])); if (!string.IsNullOrEmpty(Request.QueryString["mode"])) { checkoutMode(); } } //birthDate.Value = DateTime.Now.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (master == null) { master = (IdeaHeaderAndSide)this.Master; } if (!IsPostBack) { string IdCat = Request.QueryString["categoryID"]; string keyword = Request.QueryString["search"]; string validate = Request.QueryString["validate"]; if (!string.IsNullOrEmpty(validate)) { tryValidate(validate); } if (!string.IsNullOrEmpty(IdCat)) { SeeLabel.Text = "Category: " + Request.QueryString["categoryName"]; getProducts(IdCat); } else if (!string.IsNullOrEmpty(keyword)) { SeeLabel.Text = "Search: " + keyword; DisplaySearchByKeywords(keyword, Request.QueryString["inclusion"]); } if (string.IsNullOrEmpty(keyword) && string.IsNullOrEmpty(IdCat)) { SeeLabel.Text = "Featured Ideas:"; SqlJacknife.stapleRepeater("Prods_Get_Featured", rptProducts, lblNoResults); } } }
protected void btnUpdate_Click(object sender, EventArgs e) { if (master.getCartId() == -1) { return; } try { foreach (GridViewRow row in grdCartItems.Rows) { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@ID_Cart", master.getCartId(), 0, SqlDbType.Int, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@ID_Pr", (row.Cells[0].Text), 4, SqlDbType.Char, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@qty", Convert.ToInt32(((TextBox)(row.Cells[2].FindControl("Quantity"))).Text), 0, SqlDbType.Int, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@remove", ((CheckBox)(row.Cells[4].FindControl("chkRemove"))).Checked, 0, SqlDbType.Bit, ParameterDirection.Input)); SqlJacknife.SendCommand("spUpdateCartItems", parms); } LoadCart(); if (grdCartItems.Rows.Count != 0) { master.messageSuccess("Cart updated!"); } else { master.messageNormal("You don't have any item in your cart"); } } catch (Exception ex) { master.messageLoggedError(ex.Message); IdeaHeaderAndSide.logMessage("IdeaShop-CartPage: Update Cart", ex.Message); } }
protected void loadCustomer(int id) { try { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@ID_Cust", id, 20, SqlDbType.Int, ParameterDirection.Input)); DataTable dt = SqlJacknife.GetDataTable("Get_Customer", parms); lblId.Text = "Id :" + dt.Rows[0]["ID_Cust"].ToString(); fname.Text = dt.Rows[0]["FName"].ToString(); mname.Text = dt.Rows[0]["MName"].ToString(); lname.Text = dt.Rows[0]["LName"].ToString(); username.Text = dt.Rows[0]["UserName"].ToString(); birthDate.Value = dt.Rows[0]["DOB"].ToString().Split(' ')[0]; phone.Text = dt.Rows[0]["Phone"].ToString(); email.Text = dt.Rows[0]["Email"].ToString(); address.Text = dt.Rows[0]["Street"].ToString(); city.Text = dt.Rows[0]["City"].ToString(); sOrP.Text = dt.Rows[0]["State"].ToString(); zip.Text = dt.Rows[0]["ZIP"].ToString(); country.Text = dt.Rows[0]["Country"].ToString(); password.Text = dt.Rows[0]["Password"].ToString(); } catch (Exception ex) { master.messageLoggedError(ex.Message); IdeaHeaderAndSide.logMessage("IdeaShop-Account Editor: Retrieving customer data", ex.Message); } }
/// <summary> /// This finally deletes the selected category /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnConfirm_Click(object sender, EventArgs e) { try { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@ID_Cat", ddlCategories.SelectedValue, 4, SqlDbType.Char, ParameterDirection.Input)); SqlJacknife.SendCommand("Categ_Delete", parms, CommandType.StoredProcedure); Label lblMasterMessage = this.Page.Master.FindControl("lblMessage") as Label; lblMasterMessage.Text = "Category Deleted"; getCategories(); IdeaHeaderAndSide master = (IdeaHeaderAndSide)this.Master; master.getCategories(); btnCancel.Visible = false; btnConfirm.Visible = false; btnNew.Visible = true; btnSave.Visible = true; btnDelete.Visible = true; master.messageSuccess("Category deleted"); //Response.Redirect("default.aspx?messageSuccess=Category+Deleted!"); } catch { master.messageError("Cannot delete Categories containing products"); } }
/// <summary> /// Saves or updates the category /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { // Check if the name is null or empty if (string.IsNullOrEmpty(cat_name.Text.Trim())) { IdeaHeaderAndSide leMaster = (IdeaHeaderAndSide)this.Master; leMaster.messageError("Please enter a title!"); } Label lblMasterMessage = this.Page.Master.FindControl("lblMessage") as Label; String idOutput = ""; if (ddlCategories.Visible == false) { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@ID_Cat", idOutput, 4, SqlDbType.Char, ParameterDirection.Output)); parms.Add(new SqlJacknife.ParmStruct("@cat_name", cat_name.Text, 30, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@description", description.Text, 200, SqlDbType.VarChar, ParameterDirection.Input)); SqlJacknife.SendCommand("Categ_Add", parms, CommandType.StoredProcedure); this.master.messageSuccess("Category Added"); } else if (ddlCategories.Visible == true) { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@ID_Cat", ddlCategories.SelectedValue, 30, SqlDbType.Int, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@cat_name", cat_name.Text, 30, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@description", description.Text, 200, SqlDbType.VarChar, ParameterDirection.Input)); SqlJacknife.SendCommand("Categ_Update", parms, CommandType.StoredProcedure); this.master.messageSuccess("Category Updated"); } getCategories(); //IdeaHeaderAndSide master = (IdeaHeaderAndSide)this.Master; master.getCategories(); }
public void LoadUpAccount(int Id) { try { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@ID_Cust", Id, 0, SqlDbType.Int, ParameterDirection.Input)); DataTable dt = SqlJacknife.GetDataTable("RetrieveAccountByID", parms); lblID.Text = Id.ToString(); username.Text = dt.Rows[0]["username"].ToString(); password.Text = dt.Rows[0]["password"].ToString(); fname.Text = dt.Rows[0]["fname"].ToString(); lname.Text = dt.Rows[0]["lname"].ToString(); birthDate.Value = dt.Rows[0]["dob"].ToString().Split(' ')[0]; mname.Text = dt.Rows[0]["mname"].ToString(); phone.Text = dt.Rows[0]["phone"].ToString(); email.Text = dt.Rows[0]["email"].ToString(); country.SelectedValue = dt.Rows[0]["country"].ToString(); city.Text = dt.Rows[0]["city"].ToString(); sOrP.Text = dt.Rows[0]["state"].ToString(); address.Text = dt.Rows[0]["street"].ToString(); zip.Text = dt.Rows[0]["zip"].ToString(); } catch (Exception x) { master.messageLoggedError(x.Message); IdeaHeaderAndSide.logMessage("AccountEditorInfoLoad", x.Message); } }
protected void Page_Load(object sender, EventArgs e) { changeRegex(null, null); if (master == null) { master = this.Page.Master as IdeaHeaderAndSide; } master.userIsAdmin("default.aspx"); foreach (Control ctrl in whereAllThingsAreIn.Controls) { if (ctrl is TextBox) { (ctrl as TextBox).Enabled = false; } } foreach (Control ctrl in addressDiv.Controls) { if (ctrl is TextBox) { (ctrl as TextBox).Enabled = false; } } if (!IsPostBack) { int id = Convert.ToInt32(Request.QueryString["IDCust"]); if (Request.QueryString["IDCust"] != null) { LoadUpAccount(id); } LoadDDLCustomers(); } }
public void sendEmail() { String url = "http://*****:*****@noreply", "Order Confirmed!", message); }
protected void Page_Load(object sender, EventArgs e) { if (master == null) { master = this.Page.Master as IdeaHeaderAndSide; } if (!IsPostBack) { LoadCart(); } }
protected void Page_Load(object sender, EventArgs e) { if (master == null) { master = (IdeaHeaderAndSide)this.Master; } if (master.userIsAdmin()) { Response.Redirect("default.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (master == null) { master = (IdeaHeaderAndSide)this.Master; } master.userIsAdmin("default.aspx"); if (!IsPostBack) { LoadImages(); } }
protected void CreateAccount() { using (SqlConnection conn = new SqlConnection(cnnString)) { conn.Open(); SqlTransaction trans = conn.BeginTransaction(); try { String validCode = generateGarble(8); String message = "Hello, " + fname.Text + ",</br> Please follow the link to validate your account" + "<p><a href = 'http://*****:*****@ID_cust", null, 0, SqlDbType.Int, ParameterDirection.Output)); parms.Add(new SqlJacknife.ParmStruct("@fname", fname.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@mname", mname.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@lname", lname.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@username", username.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@password", password.Text, 50, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@dob", ExtractBirthday(), 0, SqlDbType.Date, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@street", address.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@city", city.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@state", sOrP.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@zip", zip.Text, 10, SqlDbType.NVarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@country", country.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@phone", phone.Text, 10, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@email", email.Text, 50, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@Validate", validCode, 8, SqlDbType.Char, ParameterDirection.Input)); string ID = SqlJacknife.SendCommandGetString("CreateCustomer", parms); if (ID != "0") { master.messageSuccess("Account Created Successfully, ID: " + ID.ToString()); trans.Commit(); } IdeaHeaderAndSide.sendEmail(email.Text, "ideaShopRobot@noreply", "One last step, " + fname.Text, message); } catch (Exception ex) { master.messageLoggedError(ex.Message); IdeaHeaderAndSide.logMessage("IdeaShop-Account Editor: Create Account", ex.Message); trans.Rollback(); } } }
protected void Page_Load(object sender, EventArgs e) { if (master == null) { master = (IdeaHeaderAndSide)this.Master; } if (!IsPostBack) { DeleteAllInTrueTemp(); } master.userIsAdmin("default.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (master == null) { master = (IdeaHeaderAndSide)this.Master; } if (!IsPostBack) { LoadImages(); btnDontDelete.Visible = false; btnRealDelete.Visible = false; } master.userIsAdmin("default.aspx"); }
Dictionary <String, String> descriptions;//This doesn't work :( protected void Page_Load(object sender, EventArgs e) { if (descriptions == null) { descriptions = new Dictionary <string, string>(); } if (master == null) { master = (IdeaHeaderAndSide)this.Master; } master.userIsAdmin("default.aspx"); if (!IsPostBack) { getCategories(); } }
private void tryValidate(String validate) { try { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@Validate", validate, 8, SqlDbType.Char, ParameterDirection.Input)); DataTable dt = SqlJacknife.GetDS("ValidateCustomer", parms).Tables[0]; String fname = dt.Rows[0]["fname"].ToString(); String confirmMessage = "Hello " + fname + ",</br>" + "Your account has been verified and you may now purchase ideas!</br></br>" + "- The Last Braincell Team"; master.messageSuccess(dt.Rows[0]["UserName"].ToString() + " has been validated!"); IdeaHeaderAndSide.sendEmail(dt.Rows[0]["Email"].ToString(), "ideaShopRobot@noreply", "You're In!", confirmMessage); } catch (Exception ex) { master.messageError(ex.Message); } }
protected void btnArchive_Click(object sender, EventArgs e) { try { using (SqlConnection cnn = new SqlConnection(cnnString)) { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@ID_Cust", lblID.Text, 0, SqlDbType.Int, ParameterDirection.Input)); if (SqlJacknife.SendCommand("ArchiveAccount", parms) != 0) { master.messageSuccess("Account is Archived"); } } } catch (Exception ex) { master.messageLoggedError(ex.Message); IdeaHeaderAndSide.logMessage("IdeaShop-Account Editor Admin: Archive Account", ex.Message); } }
protected void UpdateAccount(int id) { using (SqlConnection conn = new SqlConnection(cnnString)) { conn.Open(); SqlTransaction trans = conn.BeginTransaction(); try { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@ID_cust", id, 0, SqlDbType.Int, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@fname", fname.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@mname", mname.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@lname", lname.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@username", username.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@password", password.Text, 50, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@dob", birthDate.Value, 0, SqlDbType.Date, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@street", address.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@city", city.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@state", sOrP.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@zip", zip.Text, 10, SqlDbType.NVarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@country", country.Text, 20, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@phone", phone.Text, 10, SqlDbType.VarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@email", email.Text, 50, SqlDbType.VarChar, ParameterDirection.Input)); if (SqlJacknife.SendCommand("UpdateAccountUser", parms) != 0) { master.messageSuccess("Account Updated Successfully"); trans.Commit(); } } catch (Exception ex) { master.messageLoggedError(ex.Message); IdeaHeaderAndSide.logMessage("IdeaShop-Account Editor: Update Account", ex.Message); trans.Rollback(); } } }
private void LoadCart() { if (master.getCartId() == -1)//(Request.Cookies["ID_Cart"] == null) { Response.Redirect("default.aspx?messageError=Your cart is empty!"); return; } try { DataTable dt; List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); int cartID = 0; cartID = master.getCartId(); //Convert.ToInt32(Request.Cookies["ID_Cart"].Value); parms.Add(new SqlJacknife.ParmStruct("@ID_Cart", cartID, 0, SqlDbType.Int, ParameterDirection.Input)); dt = SqlJacknife.GetDS("spLoadCartItems", parms).Tables[0]; if (dt.Rows.Count != 0) { grdCartItems.DataSource = dt; grdCartItems.DataBind(); double subtotal = 0; foreach (GridViewRow row in grdCartItems.Rows) { subtotal += Convert.ToDouble(((Label)(row.Cells[3].FindControl("lblSubTotal"))).Text.Substring(1)); } lblSubtotal.Text = subtotal.ToString("c"); double tax = subtotal * 0.15; double shipping = 0; if (subtotal <= 75 && subtotal >= 35) { shipping = 12; } else if (subtotal < 35) { shipping = 7; } lblSubtotal.Text = subtotal.ToString("c"); lblTax.Text = tax.ToString("c"); lblShipping.Text = shipping.ToString("c"); lblTotal.Text = (subtotal + tax + shipping).ToString("c"); //double subtotal = Convert.ToDouble(grdCartItems.Rows[0].Cells[4].Text.Replace("$","")); } else { grdCartItems.DataSource = dt; grdCartItems.DataBind(); lblSubtotal.Text = 0.ToString("c"); lblTax.Text = 0.ToString("c"); lblShipping.Text = 0.ToString("c"); lblTotal.Text = 0.ToString("c"); Response.Cookies.Remove("ID_Cart"); Response.Cookies["ID_Cart"].Expires = DateTime.Today.AddDays(-1); Response.Redirect("default.aspx?messageError=Your cart is empty!"); } } catch (Exception ex) { master.messageLoggedError(ex.Message); IdeaHeaderAndSide.logMessage("IdeaShop-CartPage: Load Cart", ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { master = (IdeaHeaderAndSide)this.Master; }