protected void Page_Load(object sender, EventArgs e) { //SqlCommand cmd = new SqlCommand("select * from Product where Id="+ Convert.ToInt32(Request.QueryString["id"])); //DataTable dt = DBLayers.select(cmd); if (Session["id"] != null) { int id = Convert.ToInt32(Request.QueryString["id"]); DataTable dt = ProductLayer.GetProduct(id); for (int i = 0; i < dt.Rows.Count; i++) { lbl_price.Text = "Price Per Unit: <br/>$ " + dt.Rows[i]["Price"].ToString(); lbl_title.Text = dt.Rows[i]["Name"].ToString(); lbl_desc.Text = dt.Rows[i]["Description"].ToString(); lbl_item.Text = id.ToString(); img_product.ImageUrl = dt.Rows[i]["Image"].ToString(); int[] amount = Enumerable.Range(1, 20).ToArray(); ddl_amount.DataSource = amount; ddl_amount.AppendDataBoundItems = true; ddl_amount.DataBind(); } } else { Response.Redirect("~/login.aspx"); } }
protected void btn_add_Click(object sender, EventArgs e) { string path = "~/attach/" + fup_image.FileName; fup_image.SaveAs(Server.MapPath(path)); int Type = int.Parse(ddl_type.SelectedValue); int price = int.Parse(txt_price.Text); ProductLayer.InsertProduct(Type, txt_productName.Text, price, txt_desc.Text, path); lbl_status.Text = "Product Added Successfuly!"; Response.Redirect("~/homepage.aspx"); }
protected void Page_Load(object sender, EventArgs e) { //SqlCommand cmd = new SqlCommand("select * from Product"); //DataTable dt = DBLayers.select(cmd); DataTable dt = ProductLayer.GetAllProducts(); for (int i = 0; i < dt.Rows.Count; i++) { Panel productPanel = new Panel(); ImageButton imageButton = new ImageButton(); Label lblName = new Label(); Label lblPrice = new Label(); imageButton.ImageUrl = dt.Rows[i]["Image"].ToString(); imageButton.CssClass = "productImage"; //imageButton.PostBackUrl = "~/cart.aspx?id="+dt.Rows[i]["Id"]; Button btn = new Button(); btn.CssClass = "cardButton"; btn.Text = "Add To Cart"; btn.PostBackUrl = "~/cart.aspx?id=" + dt.Rows[i]["Id"]; lblName.Text = dt.Rows[i]["Name"].ToString(); lblName.CssClass = "productName"; lblPrice.Text = dt.Rows[i]["Price"].ToString() + " $"; lblPrice.CssClass = "productPrice"; productPanel.Controls.Add(imageButton); productPanel.Controls.Add(new Literal { Text = "<br/>" }); productPanel.Controls.Add(lblName); productPanel.Controls.Add(new Literal { Text = "<br/>" }); productPanel.Controls.Add(lblPrice); productPanel.Controls.Add(btn); productPanel.Controls.Add(new Literal { Text = "<br/>" }); pnl_products.Controls.Add(productPanel); } }
protected void btnAddCategory_Click(object sender, EventArgs e) { ProductDbContext productDbContext = new ProductDbContext(); ProductLayer productLayer = new ProductLayer(); Product product = new Product(); productLayer.CategoryID = Convert.ToInt64(txtCategoryID.Text); productLayer.Name = txtProductName.Text; productLayer.Price = Convert.ToDouble(txtPrice.Text); productLayer.Details = txtProductDetails.Text; productLayer.Brand = txtBrandName.Text; productLayer.StockQuantity = Convert.ToDouble(txtStockQuentity.Text); productLayer.IsFavorite = chkIsFavourite.Checked; productLayer.IsActive = chkIsActive.Checked; product.CategoryID = productLayer.CategoryID; product.Name = productLayer.Name; product.Price = productLayer.Price; product.Details = productLayer.Details; product.Brand = productLayer.Brand; product.StockQuantity = productLayer.StockQuantity; product.IsFavorite = productLayer.IsFavorite; product.IsActive = productLayer.IsActive; productDbContext.Products.Add(product); productDbContext.SaveChanges(); long ProductID = product.ID; ProductImg productImg = new ProductImg(); ProductImgLayer productImgLayer = new ProductImgLayer(); int displayOrder = 1; string activePictureName = uploadActivePicture.FileName; foreach (var a in uploadProductPicture.PostedFiles) { string fileExtension = Path.GetExtension(a.FileName); if (fileExtension.ToLower() == ".jpg" || fileExtension.ToLower() == ".png") { Random random = new Random(); int randomNum = random.Next(0, 100000000); a.SaveAs(Server.MapPath("~/Photos/Products/" + randomNum + a.FileName)); string imagePath = "~/Photos/Products/" + randomNum + a.FileName; if (activePictureName == a.FileName) { productImgLayer.IsDefaultImg = true; } else { productImgLayer.IsDefaultImg = false; } productImgLayer.ProductID = ProductID; productImgLayer.ImgPath = imagePath; productImgLayer.DisplayOrder = displayOrder; productImg.ProductID = productImgLayer.ProductID; productImg.ImgPath = productImgLayer.ImgPath; productImg.DisplayOrder = productImgLayer.DisplayOrder; productImg.IsDefaultImg = productImgLayer.IsDefaultImg; productDbContext.ProductImgs.Add(productImg); productDbContext.SaveChanges(); displayOrder += 1; } } GridView1.DataBind(); ClearProductInputField(); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { if (Request.QueryString["id"] != null) { int id = Convert.ToInt32(Request.QueryString["id"]); ProductLayer.DeleteProduct(id); } } if (Session["id"] != null) { SqlCommand cmd = new SqlCommand("select * from Cart c, Product p where c.ProductId = p.Id and c.UserId=@id"); cmd.Parameters.AddWithValue("id", int.Parse(Request.Cookies["user"].Values["id"])); DataTable dt = DBLayers.select(cmd); //DataTable dt = ProductLayer.GetAllProducts(); for (int i = 0; i < dt.Rows.Count; i++) { Panel productPanel = new Panel(); ImageButton imageButton = new ImageButton(); Label lblName = new Label(); Label lblPrice = new Label(); Label lblDate = new Label(); Label lblQuantity = new Label(); imageButton.ImageUrl = dt.Rows[i]["Image"].ToString(); imageButton.CssClass = "productImage"; //imageButton.PostBackUrl = "~/cart.aspx?id="+dt.Rows[i]["Id"]; Button btn = new Button(); btn.CssClass = "cardButton"; btn.Text = "Delete Order"; btn.PostBackUrl = "~/purchasedHistory.aspx?id=" + dt.Rows[i]["Id"]; lblName.Text = "Name: " + dt.Rows[i]["Name"].ToString(); lblName.CssClass = "productName"; lblDate.Text = "Purchased " + dt.Rows[i]["DatePurchased"].ToString(); lblDate.CssClass = "productPrice"; lblPrice.Text = "Price: " + dt.Rows[i]["Price"].ToString() + " $"; lblPrice.CssClass = "productPrice"; lblQuantity.Text = "Quantity: " + dt.Rows[i]["Amount"].ToString(); lblQuantity.CssClass = "productPrice"; productPanel.Controls.Add(imageButton); productPanel.Controls.Add(new Literal { Text = "<br/>" }); productPanel.Controls.Add(lblName); productPanel.Controls.Add(new Literal { Text = "<br/>" }); productPanel.Controls.Add(lblDate); productPanel.Controls.Add(new Literal { Text = "<br/>" }); productPanel.Controls.Add(lblQuantity); productPanel.Controls.Add(new Literal { Text = "<br/>" }); productPanel.Controls.Add(lblPrice); productPanel.Controls.Add(new Literal { Text = "<br/>" }); productPanel.Controls.Add(btn); productPanel.Controls.Add(new Literal { Text = "<br/>" }); pnl_products.Controls.Add(productPanel); } } else { Response.Redirect("~/login.aspx"); } }