public void InsertProductImage(int productId, string image) { ProductImagesDAO dao = new ProductImagesDAO(); ProductImage newProductImage = new ProductImage(); newProductImage.productId = productId; newProductImage.image = image; dao.CreateProductImage(newProductImage); }
private void LoadOtherProducts(int productId) { ProductsDAO productsDAO = new ProductsDAO(); ProductImagesDAO productImagesDAO = new ProductImagesDAO(); List <Product> allProductsList = productsDAO.GetAllProducts(); List <ProductImage> productImageList = productImagesDAO.GetAllProductImages(); List <Product> productsList = new List <Product>(); //Random 4 products for (int i = 0; i < Int32.MaxValue; i++) { Random random = new Random(); int randomNumber = random.Next(0, allProductsList.Count); Product product = allProductsList[randomNumber]; if ((!productsList.Contains(product)) && (product.id != productId)) { productsList.Add(product); } if (productsList.Count == 4) { break; } } ProductImage productImage = productImagesDAO.GetAllProductImages() .FindAll(pi => pi.productId.Equals(productsList[0].id)) .FirstOrDefault(); //P1 LoadProductInfo(hlOtherProduct1, imgOtherProduct1, productsList[0], productImage, lblPriceOtherProduct1, hlOtherProductZoom1, hlBuyOtherProduct1); productImage = productImagesDAO.GetAllProductImages() .FindAll(pi => pi.productId.Equals(productsList[1].id)) .FirstOrDefault(); //P2 LoadProductInfo(hlOtherProduct2, imgOtherProduct2, productsList[1], productImage, lblPriceOtherProduct2, hlOtherProductZoom2, hlBuyOtherProduct2); productImage = productImagesDAO.GetAllProductImages() .FindAll(pi => pi.productId.Equals(productsList[2].id)) .FirstOrDefault(); //P3 LoadProductInfo(hlOtherProduct3, imgOtherProduct3, productsList[2], productImage, lblPriceOtherProduct3, hlOtherProductZoom3, hlBuyOtherProduct3); productImage = productImagesDAO.GetAllProductImages() .FindAll(pi => pi.productId.Equals(productsList[3].id)) .FirstOrDefault(); //P4 LoadProductInfo(hlOtherProduct4, imgOtherProduct4, productsList[3], productImage, lblPriceOtherProduct4, hlOtherProductZoom4, hlBuyOtherProduct4); }
public List <ProductImage> GetAllProductImages(int productId) { List <ProductImage> productImagesList = new List <ProductImage>(); ProductImagesDAO dao = new ProductImagesDAO(); productImagesList = dao.GetAllProductImages(); //Filter by productID productImagesList = productImagesList.FindAll(pi => pi.productId.Equals(productId)); return(productImagesList); }
private void EnviarEmail() { List <ShoppingCartProduct> listProducts = (List <ShoppingCartProduct>)Session["ssSHOPPINGCARD"]; Dictionary <string, string> attachments = new Dictionary <string, string>(); string asunto = "Compra MARIAC STORE"; //string destinatario = "*****@*****.**"; //string destinatario = "*****@*****.**"; string destinatario = "*****@*****.**"; string mensaje = GetLocalResourceObject("mailTemplate").ToString(); ProductImagesDAO productImagesDAO = new ProductImagesDAO(); List <ProductImage> listProductImages = productImagesDAO.GetAllProductImages(); double total = 0; total = listProducts.Sum(p => Double.Parse(p.product.price) * p.total); string rowsProduct = ""; foreach (ShoppingCartProduct shoppingCartproduct in listProducts) { ProductImage productImage = listProductImages.Find(pi => pi.productId.Equals(shoppingCartproduct.product.id)); string productImageUrl = ""; if (productImage != null) { productImageUrl = productImage.image; } string productImageGUID = "[" + shoppingCartproduct.product.id + Guid.NewGuid().ToString().Substring(0, 3) + "]"; string rowProducto = GetLocalResourceObject("mailTemplateRow").ToString(); rowProducto = rowProducto.Replace("@@productName@@", shoppingCartproduct.product.name); rowProducto = rowProducto.Replace("@@productDescription@@", shoppingCartproduct.product.longDescription); rowProducto = rowProducto.Replace("@@productPrice@@", String.Format("{0:C}", Double.Parse(shoppingCartproduct.product.price))); rowProducto = rowProducto.Replace("@@productImage@@", productImageGUID); rowProducto = rowProducto.Replace("@@productTotal@@", shoppingCartproduct.total.ToString()); rowsProduct = rowsProduct + rowProducto; attachments.Add(productImageGUID, string.Format("{0}Images\\{1}", "C:\\Ecommerce\\Ecommerce\\", productImage.image)); } mensaje = mensaje.Replace("@@productsTotal@@", String.Format("{0:C}", total)); mensaje = mensaje.Replace("@@products@@", rowsProduct); attachments.Add("@@brandLogo@@", string.Format("{0}Images\\Email\\{1}", "C:\\Ecommerce\\Ecommerce\\", "logo-mc-p.png")); attachments.Add("@@twitterLogo@@", string.Format("{0}Images\\Email\\{1}", "C:\\Ecommerce\\Ecommerce\\", "social-icon-twitter.png")); attachments.Add("@@facebookLogo@@", string.Format("{0}Images\\Email\\{1}", "C:\\Ecommerce\\Ecommerce\\", "social-icon-fb.png")); EnviarEmailConAdjuntos(destinatario, asunto, mensaje, true, attachments); }
private void LoadProduct(int productId) { try { ProductsDAO productsDAO = new ProductsDAO(); Product product = productsDAO.GetProduct(productId); lblProductName.Focus(); lblProductName.InnerText = product.name; lblProductPrice.InnerText = string.Concat("$", " ", product.price); lblProductDescrition.InnerText = product.shortDescription; lblColors.InnerText = product.colors; ProductImagesDAO productImagesDAO = new ProductImagesDAO(); List <ProductImage> ProductImageList = productImagesDAO.GetAllProductImages(); ProductImageList = ProductImageList.FindAll(pi => pi.productId.Equals(product.id)); ProductImage productImage = ProductImageList.FirstOrDefault(); string url = "http://localhost:6742/Images/"; imgProductMain.Src = url + productImage.image; hlProductZoom.HRef = imgProductMain.Src; string[] sizes = product.sizes.Split(','); foreach (string size in sizes) { ddlProductSizes.Items.Add(size); } imgProduct1.Src = url + ProductImageList[0].image; imgProduct2.Src = url + ProductImageList[1].image; imgProduct3.Src = url + ProductImageList[2].image; imgProduct4.Src = url + ProductImageList[3].image; } catch (Exception) { } }
public void DeleteProductImage(int id) { ProductImagesDAO dao = new ProductImagesDAO(); dao.DeleteProductImage(id); }
private void LoadMainProducts(int order, int productypeId = 0) { CategoriesDAO categoriesDAO = new CategoriesDAO(); List <Category> allCategoriesList = categoriesDAO.GetAllCategories(); Category manCategory = allCategoriesList.Find(c => c.name.ToUpper().Equals("MUJER")); ProductTypesDAO productTypesDAO = new ProductTypesDAO(); List <ProductType> productTypesList = productTypesDAO.GetAllProductTypes(); productTypesList = productTypesList.FindAll(pt => pt.categoryId.Equals(manCategory.id)).ToList(); ulProductTypesMan.Controls.Clear(); HtmlGenericControl liAll = new HtmlGenericControl("li"); HtmlGenericControl ianchorAll = new HtmlGenericControl("a"); liAll = new HtmlGenericControl("li"); ianchorAll = new HtmlGenericControl("a"); ianchorAll.Attributes.Add("href", "?productTypeId=-1#main"); ianchorAll.Attributes.Add("class", "active"); ianchorAll.InnerText = "Todas"; liAll.Controls.Add(ianchorAll); ulProductTypesMan.Controls.Add(liAll); foreach (ProductType productType in productTypesList) { HtmlGenericControl li = new HtmlGenericControl("li"); HtmlGenericControl ianchor = new HtmlGenericControl("a"); li = new HtmlGenericControl("li"); ianchor = new HtmlGenericControl("a"); ianchor.Attributes.Add("href", "?productTypeId=" + productType.id + "#main"); ianchor.Attributes.Add("class", "active"); ianchor.InnerText = productType.name; li.Controls.Add(ianchor); ulProductTypesMan.Controls.Add(li); } ProductsDAO productsDAO = new ProductsDAO(); ProductImagesDAO productImagesDAO = new ProductImagesDAO(); List <Product> allProductsList = productsDAO.GetAllProducts(); List <ProductImage> productImageList = productImagesDAO.GetAllProductImages(); List <Product> productsList = allProductsList.Where(p => productTypesList.Any(pl => pl.id.Equals(p.productTypeId))).ToList(); if (productypeId > 0) { productsList = allProductsList.FindAll(p => p.productTypeId.Equals(productypeId)); } //default order productsList = productsList.OrderBy(p => p.name).ToList(); switch (order) { //NOMBRE (A -Z) case 0: productsList = productsList.OrderBy(p => p.name).ToList(); break; //NOMBRE (Z -A) case 1: productsList = productsList.OrderByDescending(p => p.name).ToList(); break; //MENOR PRECIO case 2: productsList = productsList.OrderBy(p => Double.Parse(p.price)).ToList(); break; //MAYOR PRECIO case 3: productsList = productsList.OrderByDescending(p => Double.Parse(p.price)).ToList(); break; default: productsList = productsList.OrderBy(p => p.name).ToList(); break; } pnlProducts.Controls.Clear(); if (productsList.Count > 0) { foreach (Product product in productsList) { //P1 ProductImage productImage = productImagesDAO.GetAllProductImages() .FindAll(pi => pi.productId.Equals(product.id)).FirstOrDefault(); string url = "http://*****:*****@"<div class=""col-xs-12 col-sm-4""> <div class=""product-display product-description""> <figure class=""product-image""> <img id=""imgProduct1"" src=""" + ImageSrc + @""" alt=""image"" /> <div class=""overlay""> <div class=""product-view-block""> <div class=""product-view clearfix""> <a id=""hlProductZoom1"" href=""" + ImageSrc + @""" class=""zoom icon_zoom-in_alt single_image""></a> </div> <a id=""hlBuyProduct1"" href=""/Products.aspx?productId=" + product.id + @"#main"" class=""btn add-cart"">COMPRAR</a> </div> </div> </figure> <div class=""about-product""> <h4><a id=""hlProduct1"" href=""/Products.aspx?productId=" + product.id + @"#main"" class=""item-name"">" + product.name + @"</a></h4> <span class=""price""> <span id=""lblPrice1"">$ " + product.price + @"</span></span> </div> </div> </div>"; HtmlGenericControl div = new HtmlGenericControl("div"); div.InnerHtml = productDescription; pnlProducts.Controls.Add(div); } ////P8 //LoadProductInfo(hlProduct8, imgProduct8, productsList[7], productImage, lblPrice8, hlProductZoom8, hlBuyProduct8); //productImage = productImagesDAO.GetAllProductImages() // .FindAll(pi => pi.productId.Equals(productsList[8].id)) // .FirstOrDefault(); ////P9 //LoadProductInfo(hlProduct9, imgProduct9, productsList[8], productImage, lblPrice9, hlProductZoom9, hlBuyProduct9); } }
private void LoadShoppingCard() { double total = 0; if (Session["ssSHOPPINGCARD"] != null) { List <ShoppingCartProduct> listProducts = (List <ShoppingCartProduct>)Session["ssSHOPPINGCARD"]; total = listProducts.Sum(p => Double.Parse(p.product.price) * p.total); if (total <= 0) { btnConfirmShopping.Visible = false; } else { btnConfirmShopping.Visible = true; string innerHtml = "<h3>Tu Carro de compras</h3><table class=\"table custom-table\"><thead><tr>" + "<th colspan = \"1\">Descripción Producto</th><th>Precio</th><th>Cantidad</th>" + "<th colspan = \"2\"> total </th></tr></thead><tbody>"; ProductImagesDAO productImagesDAO = new ProductImagesDAO(); List <ProductImage> listProductImages = productImagesDAO.GetAllProductImages(); foreach (ShoppingCartProduct shoppingCartProduct in listProducts) { string productImageURL = "assets/images/cart-1.jpg"; ProductImage productImage = listProductImages.Find(pi => pi.productId.Equals(shoppingCartProduct.product.id)); if (productImage != null) { productImageURL = "http://*****:*****@"<tr><td data-product=""descripción producto"" class=""cart-fig""> <figure> <img src=""" + productImageURL + @""" alt=""""/> </figure> <div class=""cart-description""> <h4>" + shoppingCartProduct.product.name + @"</h4> <span>Color : <strong>" + shoppingCartProduct.product.colors + @"</strong></span> <span>Talla : <strong>" + shoppingCartProduct.product.sizes[0] + @"</strong></span> </div> </td> <td data-price=""precio"" class=""cart-price-head""><span class=""cart-price"">" + String.Format("{0:C}", Double.Parse(shoppingCartProduct.product.price)) + @"</span></td> <td data-quantity=""cantidad"" class=""cart-quantity""> <input type = ""text"" placeholder=" + shoppingCartProduct.total + @" disabled/> </td> <td data-total=""total"" class=""cart-total""><span class=""cart-price"">" + String.Format("{0:C}", Double.Parse(shoppingCartProduct.product.price)) + @"</span></td> <td class=""cart-btn""><a href = ""#"" class=""trash"" onclick=""javascript: DeleteProduct('" + shoppingCartProduct.product.id + @"')""><i class=""fa fa-trash""></i></a></td> </tr>"; innerHtml += productDescription; } innerHtml = innerHtml + "</tbody></table>"; divCartItems.InnerHtml = innerHtml; } } else { btnConfirmShopping.Visible = false; } ltlSubtotal.Text = String.Format("{0:C}", total); ltlTotal.Text = String.Format("{0:C}", total); }
private void LoadProducts() { ProductsDAO productsDAO = new ProductsDAO(); ProductImagesDAO productImagesDAO = new ProductImagesDAO(); List <Product> productsList = productsDAO.GetAllProducts(); List <ProductImage> productImageList = productImagesDAO.GetAllProductImages(); ProductImage productImage = productImagesDAO.GetAllProductImages() .FindAll(pi => pi.productId.Equals(productsList[0].id)) .FirstOrDefault(); //P1 LoadProductInfo(hlProduct1, imgProduct1, productsList[0], productImage, lblPrice1, hlProductZoom1, hlBuyProduct1); productImage = productImagesDAO.GetAllProductImages() .FindAll(pi => pi.productId.Equals(productsList[1].id)) .FirstOrDefault(); //P2 LoadProductInfo(hlProduct2, imgProduct2, productsList[1], productImage, lblPrice2, hlProductZoom2, hlBuyProduct2); productImage = productImagesDAO.GetAllProductImages() .FindAll(pi => pi.productId.Equals(productsList[2].id)) .FirstOrDefault(); //P3 LoadProductInfo(hlProduct3, imgProduct3, productsList[2], productImage, lblPrice3, hlProductZoom3, hlBuyProduct3); productImage = productImagesDAO.GetAllProductImages() .FindAll(pi => pi.productId.Equals(productsList[3].id)) .FirstOrDefault(); //P4 LoadProductInfo(hlProduct4, imgProduct4, productsList[3], productImage, lblPrice4, hlProductZoom4, hlBuyProduct4); productImage = productImagesDAO.GetAllProductImages() .FindAll(pi => pi.productId.Equals(productsList[4].id)) .FirstOrDefault(); //P5 LoadProductInfo(hlProduct5, imgProduct5, productsList[4], productImage, lblPrice5, hlProductZoom5, hlBuyProduct5); productImage = productImagesDAO.GetAllProductImages() .FindAll(pi => pi.productId.Equals(productsList[5].id)) .FirstOrDefault(); //P6 LoadProductInfo(hlProduct6, imgProduct6, productsList[5], productImage, lblPrice6, hlProductZoom6, hlBuyProduct6); productImage = productImagesDAO.GetAllProductImages() .FindAll(pi => pi.productId.Equals(productsList[6].id)) .FirstOrDefault(); //P7 LoadProductInfo(hlProduct7, imgProduct7, productsList[6], productImage, lblPrice7, hlProductZoom7, hlBuyProduct7); productImage = productImagesDAO.GetAllProductImages() .FindAll(pi => pi.productId.Equals(productsList[7].id)) .FirstOrDefault(); //P7 LoadProductInfo(hlProduct8, imgProduct8, productsList[7], productImage, lblPrice8, hlProductZoom8, hlBuyProduct8); }