/// <summary> /// Notice the plural, this takes the keyword property and the inclusive to factor in as many keywords ad possible. /// </summary> /// <param name="keywordRaw"></param> /// <param name="inclusive"></param> public void DisplaySearchByKeywords(string keywordRaw, string inclusive) { String[] keywords = keywordRaw.Split(' '); //Create an array of keywords if (keywords.Length == 0) //If there are no keywords don't even bother. { lblNoResults.Visible = true; lblNoResults.Text = "No results :("; return; } List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@mustALL", inclusive, 1, SqlDbType.Char, ParameterDirection.Input)); //Must all means all must be included. for (int a = 0; a < Math.Min(keywords.Length, 5); a++) //Don't exceed 5 keywords { String myName = "@daWord" + (a + 1).ToString(); parms.Add(new SqlJacknife.ParmStruct(myName, keywords[a], 50, SqlDbType.VarChar, ParameterDirection.Input)); } //The rest is the same Display Search by Keyword DataTable dt = SqlJacknife.GetDS("Prods_by_Keywords", parms, CommandType.StoredProcedure).Tables[0]; rptProducts.DataSource = dt; rptProducts.DataBind(); if (dt.Rows.Count == 0) { lblNoResults.Visible = true; lblNoResults.Text = "No results :("; } }
private void LoadCartOld() { if (Request.Cookies["ID_Cart"] == null) { return; } DataTable dt; List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); int cartID = 0; cartID = 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); } }
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"); } }
private DataRow getCategory(string id) { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@ID_Cat", id, 4, SqlDbType.Char, ParameterDirection.Input)); DataSet toSend = SqlJacknife.GetDS("Categ_Get_One", parms); return(toSend.Tables[0].Rows[0]); }
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"); } }
public void DisplaySearchByKeyword(string keyword) { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@daWord1", keyword, 50, SqlDbType.VarChar, ParameterDirection.Input)); DataTable dt = SqlJacknife.GetDS("Prods_by_Keyword", parms, CommandType.StoredProcedure).Tables[0]; rptProducts.DataSource = dt; rptProducts.DataBind(); if (dt.Rows.Count == 0) { lblNoResults.Visible = true; lblNoResults.Text = "No results :("; } }
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); } }
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 LoginTry(object sender, EventArgs e) { try { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@UserName", txtLogin.Text, 20, SqlDbType.NVarChar, ParameterDirection.Input)); parms.Add(new SqlJacknife.ParmStruct("@Password", txtPassword.Text, 15, SqlDbType.NVarChar, ParameterDirection.Input)); DataTable dt = SqlJacknife.GetDS("Get_User_For_Session", parms).Tables[0]; setSession("UserName", dt.Rows[0]["UserName"].ToString()); setSession("ID_Cart", dt.Rows[0]["ID_Cart"].ToString()); setSession("ID_Cust", dt.Rows[0]["ID_Cust"].ToString()); setSession("Email", dt.Rows[0]["Email"].ToString()); setSession("Validated", dt.Rows[0]["Validated"].ToString()); setSession("IsAdmin", "0"); setSession("Payment", ""); if (dt.Rows[0]["Validated"].ToString() != "1") { messageError("Please validate your account to make purchases!"); } if (Request.Cookies["ID_Cart"] != null) { try { List <SqlJacknife.ParmStruct> parms2 = new List <SqlJacknife.ParmStruct>(); if (string.IsNullOrEmpty(Session["ID_Cart"].ToString()))//User doesn't have a cart, give them the current one. { parms2.Add(new SqlJacknife.ParmStruct("@ID_Cart", Request.Cookies["ID_Cart"].Value.ToString(), 20, SqlDbType.Int, ParameterDirection.Input)); parms2.Add(new SqlJacknife.ParmStruct("@ID_Cust", dt.Rows[0]["ID_Cust"].ToString(), 20, SqlDbType.Int, ParameterDirection.Input)); SqlJacknife.SendCommand("Own_Cart", parms2); setCartId(Convert.ToInt32(Request.Cookies["ID_Cart"].Value.ToString())); } else if (Request.Cookies["ID_Cart"] != null) { parms2.Add(new SqlJacknife.ParmStruct("@FeedMe", Convert.ToInt32(Session["ID_Cart"]), 20, SqlDbType.Int, ParameterDirection.Input)); parms2.Add(new SqlJacknife.ParmStruct("@EatMe", Convert.ToInt32(Request.Cookies["ID_Cart"].Value.ToString()), 20, SqlDbType.Int, ParameterDirection.Input)); SqlJacknife.SendCommand("MergeCarts", parms2); } Response.Cookies["ID_Cart"].Value = null; Response.Cookies["ID_Cart"].Expires = DateTime.Now.AddDays(-1); } catch (Exception ex) { messageError(ex.Message); } /* * List<SqlJacknife.ParmStruct> parms2 = new List<SqlJacknife.ParmStruct>(); * parms2.Add(new SqlJacknife.ParmStruct("@ID_Cart",Request.Cookies["ID_Cart"].Value.ToString(),20,SqlDbType.Int,ParameterDirection.Input)); * parms2.Add(new SqlJacknife.ParmStruct("@ID_Cust", dt.Rows[0]["ID_Cust"].ToString(), 20, SqlDbType.Int, ParameterDirection.Input)); * SqlJacknife.SendCommand("Own_Cart",parms2); */ } lblUsername.Text = dt.Rows[0]["UserName"].ToString(); txtLogin.Text = txtPassword.Text = ""; loggedInVisible(); Response.Redirect("default.aspx"); } catch (Exception ex) { messageError(ex.Message); } }