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