/// <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");
}
}
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 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();
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
ImageAccess db = new ImageAccess();
if (db.Update_Image(Convert.ToInt32(ViewState["ID_Img"]), txtName.Text, txtAltText.Text, imgPreview.ImageUrl, chkActive.Checked))
{
master.messageSuccess("Image Info Updated!");
}
}catch (Exception x)
{
master.messageError(x.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
ImageAccess imgDB = new ImageAccess();
if (File.Exists(Server.MapPath("~/imagesTemp") + "\\" + txtName.Text + ViewState["extension"]))
{
master.messageError("File Already Exists... try again");
}
else
{
File.Move(Server.MapPath(imgPreview.ImageUrl), Server.MapPath("~/imagesTemp") + "\\" + txtName.Text + ViewState["extension"]);
if (imgDB.Save_Image(txtName.Text, txtAltText.Text, "~/imagesTemp/" + txtName.Text + ViewState["extension"], Convert.ToInt32(Session["ID_Adm"])))
{
master.messageSuccess("Images has successfully been uploaded");
}
imgPreview.Visible = false;
}
}
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);
}
}
public void FindMe(Object sender, CommandEventArgs e)
{
master.messageSuccess(FindInRepeater(rptProducts, "btnFindMe", sender).ToString());
}
