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");
}
}
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 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);
}
}
protected void btnCancel_Click(object sender, EventArgs e)
{
btnCancel.Visible = false;
btnConfirm.Visible = false;
btnNew.Visible = true;
btnSave.Visible = true;
btnDelete.Visible = true;
ddlCategories.Visible = true;
Label lblMasterMessage = this.Page.Master.FindControl("lblMessage") as Label;
master.messageNormal("Modify Category Canceled");
}
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");
}
}
private bool SaveToTrueTempForPreview(string strPath)
{
if (File.Exists(strPath))
{
master.messageNormal("File Already Exists... try again!");
imgPreview.Visible = false;
return(false);
}
else
{
imgUploader.SaveAs(strPath);
imgPreview.Visible = false;
imgPreview.ImageUrl = "~/imagesTrueTemp\\" + imgUploader.FileName;
txtName.Text = Path.GetFileNameWithoutExtension(strPath).Length > 15 ? Path.GetFileNameWithoutExtension(strPath).Substring(0, 15) : Path.GetFileNameWithoutExtension(strPath);
imgPreview.Visible = true;
master.messageClear();
}
return(true);
}
