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