protected void btnCheckout_Click(object sender, EventArgs e) { if (grdCartItems.Rows.Count != 0) { if (Session["UserName"] != null) { if (Session["Validated"].ToString() != "True")//Don't let the unvalidated buy anything. { master.messageError("Please validate your account to continue this transaction!"); } else { Response.Redirect("AccountEditor.aspx?mode=cart"); } } else { master.messageError("Please log in or create an account to continue."); } } else { master.messageError("Please add a product to the cart to proceed."); } }
protected void DeleteClick(object sender, EventArgs e) { try { String myFace = ((Button)sender).Text; if (myFace.IndexOf("Confirm") != -1) { //Put delete method here. ImageAccess db = new ImageAccess(); db.Delete_Image(Convert.ToInt32(ViewState["ID_Img"])); txtAltText.Text = ""; txtName.Text = ""; lblFileName.Text = ""; LoadImages(); btnDelete.Visible = true; btnDontDelete.Visible = btnRealDelete.Visible = false; } else if (myFace.IndexOf("Cancel") != -1) { master.messageNormal("Delete Canceled"); btnDelete.Visible = true; btnDontDelete.Visible = btnRealDelete.Visible = false; } else { btnDelete.Visible = false; btnDontDelete.Visible = btnRealDelete.Visible = true; } }catch (Exception x) { master.messageError(x.Message); } }
protected void LoadImages() { try { ImageAccess imgDB = new ImageAccess(); DataTable images = new DataTable(); images = imgDB.Load_Unverified(Convert.ToInt32(Session["ID_Adm"])); if (images.Rows.Count != 0) { rptItems.DataSource = images; rptItems.DataBind(); } else { rptItems.DataSource = null; rptItems.DataBind(); master.messageNormal("There is no images for you to validate"); } } catch (Exception ex) { master.messageError(ex.Message); } }
public void LoadDDLCustomers() { SqlCommand cmd = new SqlCommand("Customers_Get_All", new SqlConnection(cnnString)); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); try { if (dt.Rows.Count != 0) { customers.DataSource = dt; customers.DataTextField = "username"; customers.DataValueField = "ID_Cust"; customers.DataBind(); customers.SelectedValue = Request.QueryString["IDCust"]; } else { master.messageError("Customers not found!"); } } catch (Exception ex) { master.messageError(ex.Message); } }
protected void btnLogin_Click(object sender, EventArgs e) { try { DataTable dt = LoginTry(txtEmail.Text.Trim(), txtPassword.Text.Trim()); Session.Add("IsAdmin", "1"); Session.Add("ID_Adm", dt.Rows[0]["ID_Adm"].ToString()); Session.Add("Email", dt.Rows[0]["Email"].ToString()); //master.messageError(Session.Count.ToString()); //master.setSession("IsAdmin", "1"); //master.setSession("ID_Adm", dt.Rows[0]["ID_Adm"].ToString()); //master.setSession("Email", dt.Rows[0]["Email"].ToString()); Response.Redirect("AdminSection.aspx"); } catch (Exception ex) { master.messageError(ex.Message); } }
protected void btnConfirm_Click(object sender, EventArgs e) { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@ID_Order", 0, 20, SqlDbType.Int, ParameterDirection.Output)); parms.Add(new SqlJacknife.ParmStruct("@ID_Cart", Session["ID_Cart"], 8, System.Data.SqlDbType.Int, System.Data.ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@ShippingAddress", Request.Cookies["address"].Value, 300, System.Data.SqlDbType.NVarChar, System.Data.ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@PaymentType", Session["Payment"].ToString(), 20, System.Data.SqlDbType.NVarChar, System.Data.ParameterDirection.Input)); try { String OrderId = SqlJacknife.SendCommandGetString("PlaceOrderOutput", parms); sendEmail(OrderId); Response.Cookies.Clear(); Response.Cookies["ID_Cart"].Expires = DateTime.Now.AddDays(-1); String ordered = Session["ID_Cart"].ToString(); Session["ID_Cart"] = ""; Response.Redirect("Ordered.aspx?ordered=" + ordered + "&messageSuccess=Your ideas are on the way!"); } catch (Exception ex) { master.messageError(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(); }
private void getCategories() { Label lblMsg = this.Page.Master.FindControl("lblMessage") as Label; SqlCommand cmd = new SqlCommand("Categ_Get_All", new SqlConnection(cnnString)); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); try { if (dt.Rows.Count != 0) { ddlCategories.DataSource = dt; ddlCategories.DataTextField = "cat_name"; ddlCategories.DataValueField = "ID_Cat"; ddlCategories.DataBind(); ddlCategories.SelectedValue = Request.QueryString["categoryId"]; for (int a = 0; a < dt.Rows.Count; a++) { String key = dt.Rows[a]["ID_Cat"].ToString(); String value = dt.Rows[a]["description"].ToString(); descriptions[key] = value; } ddlCategories_TextChanged(null, null); } else { master.messageError("No Categories Found!"); } } catch (Exception ex) { master.messageError(ex.Message); } }
protected void btnContinue_Click(object sender, EventArgs e) { if (ddlPayment.SelectedIndex <= 0) { master.messageError("Please select a payment type!"); return; } Session["Payment"] = ddlPayment.Text; Response.Redirect("Confirmation.aspx"); return; List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@ID_Cart", Session["ID_Cart"], 8, System.Data.SqlDbType.Int, System.Data.ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@ShippingAddress", Request.Cookies["address"].Value, 300, System.Data.SqlDbType.NVarChar, System.Data.ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@PaymentType", ddlPayment.Text, 20, System.Data.SqlDbType.NVarChar, System.Data.ParameterDirection.Input)); try { if (SqlJacknife.SendCommand("PlaceOrder", parms) == 0) { throw new Exception("Order Failed!"); } sendEmail(); } catch (Exception ex) { master.messageError(ex.Message); } Response.Cookies.Clear(); Response.Cookies["ID_Cart"].Expires = DateTime.Now.AddDays(-1); String ordered = Session["ID_Cart"].ToString(); Session["ID_Cart"] = ""; master.messageError(ddlPayment.Text); Response.Redirect("Ordered.aspx?ordered=" + ordered); }
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 btnUpload_Click(object sender, EventArgs e) { try { DeleteAllInTrueTemp(); int intSizeLimit = 1048576; //1 mb // does the file upload control have a file ? if (imgUploader.HasFile) { //the postedFile object represnets the file that was posted //you can use its contentLength property to determine //the size of the posted file if (imgUploader.PostedFile.ContentLength <= intSizeLimit) { //file size is ok, lets continue //server.mappath returns an absolute path from the relative path provided.. string strPath = Server.MapPath("~/imagesTrueTemp") + "\\" + imgUploader.FileName; ViewState["extension"] = strPath.Substring(strPath.Length - 4); // we can use contentType to help figure out what type of file this is if needed string strgContentType = imgUploader.PostedFile.ContentType; // creates an image from the specified data stream System.Drawing.Image img = System.Drawing.Image.FromStream(imgUploader.PostedFile.InputStream); bool imgSaved = false; if (ImageFormat.Jpeg.Equals(img.RawFormat)) { //then it is a jpg imgSaved = SaveToTrueTempForPreview(strPath); } else if (ImageFormat.Bmp.Equals(img.RawFormat)) { //then its a bmp imgSaved = SaveToTrueTempForPreview(strPath); } else if (ImageFormat.Png.Equals(img.RawFormat)) { //then its a png imgSaved = SaveToTrueTempForPreview(strPath); } else if (ImageFormat.Tiff.Equals(img.RawFormat)) { //then its a tiff imgSaved = SaveToTrueTempForPreview(strPath); } else { master.messageError("NOT A VALID IMAGE"); } } else { master.messageError("File is too big - please try again"); } } } catch (Exception x) { if (x.Message.ToLower() == "parameter is not valid.") { master.messageError("That is not a valid image"); } else { master.messageError(x.Message); } } }