protected void btnCheckout_Click(object sender, EventArgs e)
{
if (grdCartItems.Rows.Count != 0)
{
if (Session["UserName"] != null)
{
if (Session["Validated"].ToString() != "True")//Don't let the unvalidated buy anything.
{
master.messageError("Please validate your account to continue this transaction!");
}
else
{
Response.Redirect("AccountEditor.aspx?mode=cart");
}
}
else
{
master.messageError("Please log in or create an account to continue.");
}
}
else
{
master.messageError("Please add a product to the cart to proceed.");
}
}
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);
}
}
public void LoadDDLCustomers()
{
SqlCommand cmd = new SqlCommand("Customers_Get_All", new SqlConnection(cnnString));
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
try
{
if (dt.Rows.Count != 0)
{
customers.DataSource = dt;
customers.DataTextField = "username";
customers.DataValueField = "ID_Cust";
customers.DataBind();
customers.SelectedValue = Request.QueryString["IDCust"];
}
else
{
master.messageError("Customers not found!");
}
}
catch (Exception ex)
{
master.messageError(ex.Message);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
DataTable dt = LoginTry(txtEmail.Text.Trim(), txtPassword.Text.Trim());
Session.Add("IsAdmin", "1");
Session.Add("ID_Adm", dt.Rows[0]["ID_Adm"].ToString());
Session.Add("Email", dt.Rows[0]["Email"].ToString());
//master.messageError(Session.Count.ToString());
//master.setSession("IsAdmin", "1");
//master.setSession("ID_Adm", dt.Rows[0]["ID_Adm"].ToString());
//master.setSession("Email", dt.Rows[0]["Email"].ToString());
Response.Redirect("AdminSection.aspx");
}
catch (Exception ex)
{
master.messageError(ex.Message);
}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>();
parms.Add(new SqlJacknife.ParmStruct("@ID_Order", 0, 20, SqlDbType.Int, ParameterDirection.Output));
parms.Add(new SqlJacknife.ParmStruct("@ID_Cart", Session["ID_Cart"], 8, System.Data.SqlDbType.Int, System.Data.ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@ShippingAddress", Request.Cookies["address"].Value, 300, System.Data.SqlDbType.NVarChar, System.Data.ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@PaymentType", Session["Payment"].ToString(), 20, System.Data.SqlDbType.NVarChar, System.Data.ParameterDirection.Input));
try
{
String OrderId = SqlJacknife.SendCommandGetString("PlaceOrderOutput", parms);
sendEmail(OrderId);
Response.Cookies.Clear();
Response.Cookies["ID_Cart"].Expires = DateTime.Now.AddDays(-1);
String ordered = Session["ID_Cart"].ToString();
Session["ID_Cart"] = "";
Response.Redirect("Ordered.aspx?ordered=" + ordered + "&messageSuccess=Your ideas are on the way!");
}
catch (Exception ex)
{
master.messageError(ex.Message);
}
}
/// <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");
}
}
/// <summary>
/// Saves or updates the category
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
// Check if the name is null or empty
if (string.IsNullOrEmpty(cat_name.Text.Trim()))
{
IdeaHeaderAndSide leMaster = (IdeaHeaderAndSide)this.Master;
leMaster.messageError("Please enter a title!");
}
Label lblMasterMessage = this.Page.Master.FindControl("lblMessage") as Label;
String idOutput = "";
if (ddlCategories.Visible == false)
{
List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>();
parms.Add(new SqlJacknife.ParmStruct("@ID_Cat", idOutput, 4, SqlDbType.Char, ParameterDirection.Output));
parms.Add(new SqlJacknife.ParmStruct("@cat_name", cat_name.Text, 30, SqlDbType.VarChar, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@description", description.Text, 200, SqlDbType.VarChar, ParameterDirection.Input));
SqlJacknife.SendCommand("Categ_Add", parms, CommandType.StoredProcedure);
this.master.messageSuccess("Category Added");
}
else if (ddlCategories.Visible == true)
{
List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>();
parms.Add(new SqlJacknife.ParmStruct("@ID_Cat", ddlCategories.SelectedValue, 30, SqlDbType.Int, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@cat_name", cat_name.Text, 30, SqlDbType.VarChar, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@description", description.Text, 200, SqlDbType.VarChar, ParameterDirection.Input));
SqlJacknife.SendCommand("Categ_Update", parms, CommandType.StoredProcedure);
this.master.messageSuccess("Category Updated");
}
getCategories();
//IdeaHeaderAndSide master = (IdeaHeaderAndSide)this.Master;
master.getCategories();
}
private void getCategories()
{
Label lblMsg = this.Page.Master.FindControl("lblMessage") as Label;
SqlCommand cmd = new SqlCommand("Categ_Get_All", new SqlConnection(cnnString));
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
try
{
if (dt.Rows.Count != 0)
{
ddlCategories.DataSource = dt;
ddlCategories.DataTextField = "cat_name";
ddlCategories.DataValueField = "ID_Cat";
ddlCategories.DataBind();
ddlCategories.SelectedValue = Request.QueryString["categoryId"];
for (int a = 0; a < dt.Rows.Count; a++)
{
String key = dt.Rows[a]["ID_Cat"].ToString();
String value = dt.Rows[a]["description"].ToString();
descriptions[key] = value;
}
ddlCategories_TextChanged(null, null);
}
else
{
master.messageError("No Categories Found!");
}
}
catch (Exception ex)
{
master.messageError(ex.Message);
}
}
protected void btnContinue_Click(object sender, EventArgs e)
{
if (ddlPayment.SelectedIndex <= 0)
{
master.messageError("Please select a payment type!");
return;
}
Session["Payment"] = ddlPayment.Text;
Response.Redirect("Confirmation.aspx");
return;
List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>();
parms.Add(new SqlJacknife.ParmStruct("@ID_Cart", Session["ID_Cart"], 8, System.Data.SqlDbType.Int, System.Data.ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@ShippingAddress", Request.Cookies["address"].Value, 300, System.Data.SqlDbType.NVarChar, System.Data.ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@PaymentType", ddlPayment.Text, 20, System.Data.SqlDbType.NVarChar, System.Data.ParameterDirection.Input));
try
{
if (SqlJacknife.SendCommand("PlaceOrder", parms) == 0)
{
throw new Exception("Order Failed!");
}
sendEmail();
}
catch (Exception ex)
{
master.messageError(ex.Message);
}
Response.Cookies.Clear();
Response.Cookies["ID_Cart"].Expires = DateTime.Now.AddDays(-1);
String ordered = Session["ID_Cart"].ToString();
Session["ID_Cart"] = "";
master.messageError(ddlPayment.Text);
Response.Redirect("Ordered.aspx?ordered=" + ordered);
}
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);
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
try
{
DeleteAllInTrueTemp();
int intSizeLimit = 1048576;
//1 mb
// does the file upload control have a file ?
if (imgUploader.HasFile)
{
//the postedFile object represnets the file that was posted
//you can use its contentLength property to determine
//the size of the posted file
if (imgUploader.PostedFile.ContentLength <= intSizeLimit)
{
//file size is ok, lets continue
//server.mappath returns an absolute path from the relative path provided..
string strPath = Server.MapPath("~/imagesTrueTemp") + "\\" + imgUploader.FileName;
ViewState["extension"] = strPath.Substring(strPath.Length - 4);
// we can use contentType to help figure out what type of file this is if needed
string strgContentType = imgUploader.PostedFile.ContentType;
// creates an image from the specified data stream
System.Drawing.Image img = System.Drawing.Image.FromStream(imgUploader.PostedFile.InputStream);
bool imgSaved = false;
if (ImageFormat.Jpeg.Equals(img.RawFormat))
{
//then it is a jpg
imgSaved = SaveToTrueTempForPreview(strPath);
}
else if (ImageFormat.Bmp.Equals(img.RawFormat))
{
//then its a bmp
imgSaved = SaveToTrueTempForPreview(strPath);
}
else if (ImageFormat.Png.Equals(img.RawFormat))
{
//then its a png
imgSaved = SaveToTrueTempForPreview(strPath);
}
else if (ImageFormat.Tiff.Equals(img.RawFormat))
{
//then its a tiff
imgSaved = SaveToTrueTempForPreview(strPath);
}
else
{
master.messageError("NOT A VALID IMAGE");
}
}
else
{
master.messageError("File is too big - please try again");
}
}
}
catch (Exception x)
{
if (x.Message.ToLower() == "parameter is not valid.")
{
master.messageError("That is not a valid image");
}
else
{
master.messageError(x.Message);
}
}
}
