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); } }