private void LoadCart() { if (String.IsNullOrEmpty(Request.QueryString["ordered"])) { return; } DataTable dt; List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); int cartID = 0; cartID = Convert.ToInt32(Request.QueryString["ordered"]); parms.Add(new SqlJacknife.ParmStruct("@ID_Cart", cartID, 0, SqlDbType.Int, ParameterDirection.Input)); dt = SqlJacknife.GetDS("spLoadOrderedItems", 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(row.Cells[4].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("$","")); DataTable deets = SqlJacknife.GetDataTable("Get_OrderHistory_Details", parms); lblAddress.Text = deets.Rows[0]["ShippingAddress"].ToString(); lblPayment.Text = deets.Rows[0]["PaymentType"].ToString(); } else { master.messageNormal("You don't have any Item on order"); } }
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 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); } }
protected void btnCancel_Click(object sender, EventArgs e) { btnCancel.Visible = false; btnConfirm.Visible = false; btnNew.Visible = true; btnSave.Visible = true; btnDelete.Visible = true; ddlCategories.Visible = true; Label lblMasterMessage = this.Page.Master.FindControl("lblMessage") as Label; master.messageNormal("Modify Category Canceled"); }
private void LoadCart() { DataTable dt; List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); int cartID = 0; cartID = master.getCartId(); 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(row.Cells[4].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; } lblAddress.Text = Request.Cookies["address"].Value; lblPayment.Text = Session["Payment"].ToString(); 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 { master.messageNormal("You don't have any Item on order"); } }
private bool SaveToTrueTempForPreview(string strPath) { if (File.Exists(strPath)) { master.messageNormal("File Already Exists... try again!"); imgPreview.Visible = false; return(false); } else { imgUploader.SaveAs(strPath); imgPreview.Visible = false; imgPreview.ImageUrl = "~/imagesTrueTemp\\" + imgUploader.FileName; txtName.Text = Path.GetFileNameWithoutExtension(strPath).Length > 15 ? Path.GetFileNameWithoutExtension(strPath).Substring(0, 15) : Path.GetFileNameWithoutExtension(strPath); imgPreview.Visible = true; master.messageClear(); } return(true); }