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