public ActionResult DeleteGroupProduct(int id) { if (ClsCheckRole.CheckQuyen(4, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { TblGroupProduct TblProduct = db.TblGroupProduct.Find(id); clsSitemap.DeteleSitemap(id.ToString(), "GroupProduct"); var result = string.Empty; db.TblGroupProduct.Remove(TblProduct); db.SaveChanges(); var listProduct = db.TblProduct.Where(p => p.IdCate == id).ToList(); for (int i = 0; i < listProduct.Count; i++) { db.TblProduct.Remove(listProduct[i]); db.SaveChanges(); } result = "Bạn đã xóa thành công."; return(Json(new { result = result })); } else { var result = string.Empty; result = "Bạn không có quyền thay đổi tính năng này"; return(Json(new { result = result })); } }
public ActionResult Create(TblGroupProduct TblGroupProduct, int[] MutilMenuGroup, FormCollection collection) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } string drMenu = collection["drMenu"]; if (drMenu == "") { TblGroupProduct.ParentId = null; } else { var dbLeve = db.TblGroupProduct.Find(int.Parse(drMenu)); TblGroupProduct.ParentId = dbLeve.Id; } TblGroupProduct.DateCreate = DateTime.Now; string IdUser = Request.Cookies["Username"].Values["UserID"]; TblGroupProduct.IdUser = int.Parse(IdUser); TblGroupProduct.Tag = StringClass.NameToTag(TblGroupProduct.Name); db.TblGroupProduct.Add(TblGroupProduct); db.SaveChanges(); var Groups = db.TblGroupProduct.Where(p => p.Active == true).OrderByDescending(p => p.Id).Take(1).ToList(); string id = Groups[0].Id.ToString(); clsSitemap.CreateSitemap(StringClass.NameToTag(TblGroupProduct.Name), id, "GroupProduct"); if (MutilMenuGroup != null) { foreach (var item in MutilMenuGroup) { TblConnectGroupProduct conntect = new TblConnectGroupProduct(); conntect.Idg = int.Parse(id); conntect.Idc = item; db.TblConnectGroupProduct.Add(conntect); db.SaveChanges(); } } if (collection["btnSave"] != null) { Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã thêm danh mục thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/GroupProduct/Index?idCate=" + drMenu)); } if (collection["btnSaveCreate"] != null) { Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm danh mục thành công, mời bạn thêm danh mục sản phẩm mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/GroupProduct/Create?id=" + drMenu + "")); } return(Redirect("/GroupProduct/Index?idCate=" + drMenu)); }
void UpdateOrder(int idCate, int Ord1, int Ord2) { if (Ord1 != Ord2) { var Kiemtra = db.TblGroupProduct.Where(p => p.Active == true && p.ParentId == idCate && p.Ord == Ord2).ToList(); if (Kiemtra.Count > 0) { var listGroup = db.TblGroupProduct.Where(p => p.Active == true && p.ParentId == idCate && p.Ord >= Ord2).ToList(); if (Ord2 < Ord1) { listGroup = db.TblGroupProduct.Where(p => p.Active == true && p.ParentId == idCate && p.Ord >= Ord2 && p.Ord < Ord1).ToList(); for (int i = 0; i < listGroup.Count; i++) { int idMenu = listGroup[i].Id; TblGroupProduct tblgroup = db.TblGroupProduct.Find(idMenu); tblgroup.Ord = tblgroup.Ord + 1; db.SaveChanges(); } } else { listGroup = db.TblGroupProduct.Where(p => p.Active == true && p.ParentId == idCate && p.Ord > Ord1 && p.Ord <= Ord2).ToList(); for (int i = 0; i < listGroup.Count; i++) { int idMenu = listGroup[i].Id; TblGroupProduct tblgroup = db.TblGroupProduct.Find(idMenu); tblgroup.Ord = tblgroup.Ord - 1; db.SaveChanges(); } } } } }
public ActionResult productDetail(string tag) { TblProduct ProductDetail = db.TblProduct.First(p => p.Tag == tag); int id = ProductDetail.Id; TblGroupProduct tblgroupProduct = db.TblGroupProduct.FirstOrDefault(p => p.Id == ProductDetail.IdCate.Value); var tblconfig = db.TblConfig.FirstOrDefault(); ViewBag.color = tblconfig.Color; int idmanu = int.Parse(db.TblConnectManuProduct.FirstOrDefault(p => p.IdCate == tblgroupProduct.Id).IdManu.ToString()); ViewBag.manuName = db.TblManufactures.FirstOrDefault(p => p.Id == idmanu).Name; ViewBag.Manu = "<li><span>Thương hiệu : Tân Á Đại Thành</span></li>"; ViewBag.favicon = " <link href=\"" + tblconfig.Favicon + "\" rel=\"icon\" type=\"image/x-icon\" />"; ViewBag.Title = "<title>" + ProductDetail.Title + "</title>"; ViewBag.Description = "<meta name=\"description\" content=\"" + ProductDetail.Description + "\"/>"; ViewBag.Keyword = "<meta name=\"keywords\" content=\"" + ProductDetail.Keyword + "\" /> "; ViewBag.imageog = "<meta property=\"og:image\" content=\"http://Bontana.vn" + ProductDetail.ImageLinkThumb + "\"/>"; ViewBag.titleog = "<meta property=\"og:title\" content=\"" + ProductDetail.Title + "\"/> "; ViewBag.site_nameog = "<meta property=\"og:site_name\" content=\"" + ProductDetail.Name + "\"/> "; ViewBag.urlog = "<meta property=\"og:url\" content=\"" + Request.Url.ToString() + "\"/> "; ViewBag.descriptionog = "<meta property=\"og:description\" content=\"" + ProductDetail.Description + "\" />"; ViewBag.nUrl = "<ol itemscope itemtype=\"http://schema.org/BreadcrumbList\"> <li itemprop=\"itemListElement\" itemscope itemtype=\"http://schema.org/ListItem\"> <a itemprop=\"item\" href=\"http://Bontana.vn\"> <span itemprop=\"name\">Trang chủ</span></a> <meta itemprop=\"position\" content=\"1\" /> </li> ›" + UrlProduct(tblgroupProduct.Id) + "</ol> "; ViewBag.canonical = "<link rel=\"canonical\" href=\"http://Bontana.vn/san-pham/" + ProductDetail.Tag + "\" />"; StringBuilder schame = new StringBuilder(); schame.Append("<script type=\"application/ld+json\">"); schame.Append("{"); schame.Append("\"@context\": \"http://schema.org\","); schame.Append("\"@type\": \"ProductArticle\","); schame.Append("\"headline\": \"" + ProductDetail.Description + "\","); schame.Append(" \"datePublished\": \"" + ProductDetail.DateCreate + "\","); schame.Append("\"image\": ["); schame.Append(" \"" + ProductDetail.ImageLinkThumb + "\""); schame.Append(" ]"); schame.Append("}"); schame.Append("</script> "); ViewBag.schame = schame.ToString(); var ListGroupCri = db.TblGroupCriteria.Where(p => p.IdCate == tblgroupProduct.Id).Select(p => p.IdCri).ToList(); var ListCri = db.TblCriteria.Where(p => ListGroupCri.Contains(p.Id) && p.Active == true).OrderBy(p => p.Ord).ToList(); StringBuilder chuoi = new StringBuilder(); #region [Lọc thuộc tính] for (int i = 0; i < ListCri.Count; i++) { int idCre = int.Parse(ListCri[i].Id.ToString()); var ListCr = (from a in db.TblConnectCriteria join b in db.TblInfoCriteria on a.IdCre equals b.Id where a.Idpd == id && b.IdCri == idCre && b.Active == true select new { b.Name, b.Url, b.Ord }).OrderBy(p => p.Ord).ToList(); if (ListCr.Count > 0) { chuoi.Append("<tr>"); chuoi.Append("<td>" + ListCri[i].Name + "</td>"); chuoi.Append("<td>"); int dem = 0; string num = ""; if (ListCr.Count > 1) { num = "⊹ "; } foreach (var item in ListCr) { if (item.Url != null && item.Url != "") { chuoi.Append("<a href=\"" + item.Url + "\" title=\"" + item.Name + "\">"); if (dem == 1) { chuoi.Append(num + item.Name); } else { chuoi.Append(num + item.Name); } dem = 1; chuoi.Append("</a>"); } else { if (dem == 1) { chuoi.Append(num + item.Name + "</br> "); } else { chuoi.Append(num + item.Name + "</br> "); } dem = 1; } } chuoi.Append("</td>"); chuoi.Append(" </tr>"); } } ViewBag.chuoi = chuoi.ToString(); int visit = int.Parse(ProductDetail.Visit.ToString()); if (visit > 0) { ProductDetail.Visit = ProductDetail.Visit + 1; db.SaveChanges(); } else { ProductDetail.Visit = ProductDetail.Visit + 1; db.SaveChanges(); } var listImages = db.TblImageProduct.Where(p => p.IdProduct == id).ToList(); StringBuilder chuoiimages = new StringBuilder(); if (listImages.Count > 0) { chuoiimages.Append("<li class=\"getImg" + ProductDetail.Id + "\"><a href=\"javascript:;\" onclick=\"javascript:return getImage('" + ProductDetail.ImageLinkDetail + "', 'getImg" + ProductDetail.Id + "')\" title=\"" + ProductDetail.Name + "\"><img src=\"" + ProductDetail.ImageLinkDetail + "\" alt=\"" + ProductDetail.Name + "\" /></a></li>"); for (int i = 0; i < listImages.Count; i++) { chuoiimages.Append("<li class=\"getImg" + listImages[i].Id + "\"><a href=\"javascript:;\" onclick=\"javascript:return getImage('" + listImages[i].Images + "', 'getImg" + listImages[i].Id + "')\" title=\"" + ProductDetail.Name + "\"><img src=\"" + listImages[i].Images + "\" alt=\"" + ProductDetail.Name + "\" /></a></li>"); } } ViewBag.chuoiimages = chuoiimages; ViewBag.hotline = db.TblConfig.First().HotlineIn; //load root StringBuilder chuoitag = new StringBuilder(); if (ProductDetail.Tabs != null) { string Chuoi = ProductDetail.Tabs; string[] Mang = Chuoi.Split(','); List <int> araylist = new List <int>(); for (int i = 0; i < Mang.Length; i++) { string tagsp = StringClass.NameToTag(Mang[i]); chuoitag.Append("<a href=\"/tag/" + tagsp + "\" title=\"" + Mang[i] + "\">" + Mang[i] + "</a>"); } } ViewBag.chuoitag = chuoitag; StringBuilder result = new StringBuilder(); result.Append("<div class=\"tearListProduct\">"); result.Append("<div class=\"contentListProductContent\">"); var listProduct = db.TblProduct.Where(p => p.Active == true && p.IdCate == tblgroupProduct.Id && p.Tag != tag).Take(6).OrderBy(p => p.Ord).ToList(); for (int j = 0; j < listProduct.Count; j++) { result.Append("<div class=\"tear\">"); result.Append("<div class=\"contentTear\">"); float price = float.Parse(listProduct[j].Price.ToString()); float pricesale = float.Parse(listProduct[j].PriceSale.ToString()); float phantram = 100 - ((pricesale * 100) / price); result.Append(" <div class=\"sale\">" + Convert.ToInt32(phantram) + "%</div>"); if (listProduct[j].Note != null && listProduct[j].Note != "") { result.Append("<div class=\"noteTear\">" + listProduct[j].Note + "</div>"); } result.Append("<div class=\"img\">"); result.Append("<a href=\"/san-pham/" + listProduct[j].Tag + "\" title=\"" + listProduct[j].Name + "\"><img src=\"" + listProduct[j].ImageLinkThumb + "\" alt=\"" + listProduct[j].Name + "\" /></a>"); result.Append(" </div>"); result.Append("<a href=\"/san-pham/" + listProduct[j].Tag + "\" title=\"" + listProduct[j].Name + "\" class=\"name\">" + listProduct[j].Name + "</a>"); result.Append("<div class=\"boxItem\">"); result.Append("<div class=\"boxPrice\">"); result.Append("<span class=\"priceSale\">" + string.Format("{0:#,#}", listProduct[j].PriceSale) + "đ</span>"); result.Append("<span class=\"price\">" + string.Format("{0:#,#}", listProduct[j].Price) + "đ</span>"); result.Append("</div>"); result.Append("<div class=\"boxSale\">"); result.Append("<a href=\"\" title=\"\"></a>"); result.Append("</div>"); result.Append("</div>"); result.Append(" </div>"); result.Append("</div>"); } result.Append("</div>"); result.Append("</div>"); ViewBag.resultLienquan = result.ToString(); #endregion return(View(ProductDetail)); }
public ActionResult productList(string tag) { //try //{ TblGroupProduct groupProduct = db.TblGroupProduct.First(p => p.Tag == tag); ViewBag.name = groupProduct.Name; ViewBag.headshord = groupProduct.Content; int idCate = groupProduct.Id; ViewBag.check = true; var tblconfig = db.TblConfig.FirstOrDefault(); ViewBag.color = tblconfig.Color; ViewBag.favicon = " <link href=\"" + tblconfig.Favicon + "\" rel=\"icon\" type=\"image/x-icon\" />"; ViewBag.Title = "<title>" + groupProduct.Title + "</title>"; ViewBag.Description = "<meta name=\"description\" content=\"" + groupProduct.Description + "\"/>"; ViewBag.Keyword = "<meta name=\"keywords\" content=\"" + groupProduct.Keyword + "\" /> "; ViewBag.imageog = "<meta property=\"og:image\" content=\"" + groupProduct.Images + "\"/>"; ViewBag.titleog = "<meta property=\"og:title\" content=\"" + groupProduct.Title + "\"/> "; ViewBag.site_nameog = "<meta property=\"og:site_name\" content=\"" + groupProduct.Name + "\"/> "; ViewBag.urlog = "<meta property=\"og:url\" content=\"" + Request.Url.ToString() + "\"/> "; ViewBag.descriptionog = "<meta property=\"og:description\" content=\"" + groupProduct.Description + "\" />"; ViewBag.nUrl = "<ol itemscope itemtype=\"http://schema.org/BreadcrumbList\"> <li itemprop=\"itemListElement\" itemscope itemtype=\"http://schema.org/ListItem\"> <a itemprop=\"item\" href=\"http://Bontana.vn\"> <span itemprop=\"name\">Trang chủ</span></a> <meta itemprop=\"position\" content=\"1\" /> </li> ›" + UrlProduct(groupProduct.Id) + "</ol> "; ViewBag.canonical = "<link rel=\"canonical\" href=\"http://Bontana.vn/" + groupProduct.Tag + ".html\" />"; StringBuilder result = new StringBuilder(); var listGroupProduct = db.TblGroupProduct.Where(p => p.ParentId == idCate && p.Active == true).OrderBy(p => p.Ord).ToList(); if (listGroupProduct.Count > 0) { result.Append("<div class=\"saleProduct\">"); int idmanu = groupProduct.Id; var listIdImages = db.TblConnectImages.Where(p => p.IdCate == idmanu).Select(p => p.IdImg).ToList(); var listImage = db.TblImage.Where(p => p.Active == true && p.IdCate == 4 && listIdImages.Contains(p.Id)).OrderBy(p => p.Ord).ToList(); for (int j = 0; j < listImage.Count; j++) { result.Append("<a href=\"" + listImage[j].Url + "\" title=\"" + listImage[j].Name + "\"><img src=\"" + listImage[j].Images + "\" alt=\"" + listImage[j].Name + "\" /></a>"); } result.Append("</div>"); for (int i = 0; i < listGroupProduct.Count; i++) { int idMenu = listGroupProduct[i].Id; result.Append("<div class=\"tearListProduct\">"); result.Append("<div class=\"filter\">"); result.Append("<h2 class=\"name\"><a href=\"/" + listGroupProduct[i].Tag + ".html\" title=\"" + listGroupProduct[i].Name + "\" style=\"color:#088ec1\">" + listGroupProduct[i].Name + " </a> </h2>"); result.Append("</div>"); result.Append("<div class=\"contentListProductContent\">"); var listProduct = db.TblProduct.Where(p => p.Active == true && p.IdCate == idMenu).OrderBy(p => p.Ord).Take(12).ToList(); for (int j = 0; j < listProduct.Count; j++) { result.Append("<div class=\"tear\">"); result.Append("<div class=\"contentTear\">"); float price = float.Parse(listProduct[j].Price.ToString()); float pricesale = float.Parse(listProduct[j].PriceSale.ToString()); float phantram = 100 - ((pricesale * 100) / price); if (listProduct[j].New == true) { result.Append(" <div class=\"sale\"> Mới 2018</div>"); } else { result.Append(" <div class=\"sale\">" + Convert.ToInt32(phantram) + "%</div>"); } if (listProduct[j].Note != null && listProduct[j].Note != "") { result.Append("<div class=\"noteTear\">" + listProduct[j].Note + "</div>"); } result.Append("<div class=\"img\">"); result.Append("<a href=\"/san-pham/" + listProduct[j].Tag + "\" title=\"" + listProduct[j].Name + "\"><img src=\"" + listProduct[j].ImageLinkThumb + "\" alt=\"" + listProduct[j].Name + "\" /></a>"); result.Append(" </div>"); result.Append("<a href=\"/san-pham/" + listProduct[j].Tag + "\" title=\"" + listProduct[j].Name + "\" class=\"name\">" + listProduct[j].Name + "</a>"); result.Append("<div class=\"boxItem\">"); result.Append("<div class=\"boxPrice\">"); result.Append("<span class=\"priceSale\">" + string.Format("{0:#,#}", listProduct[j].PriceSale) + "đ</span>"); result.Append("<span class=\"price\">" + string.Format("{0:#,#}", listProduct[j].Price) + "đ</span>"); result.Append("</div>"); result.Append("<div class=\"boxSale\">"); result.Append("<a href=\"\" title=\"\"></a>"); result.Append("</div>"); result.Append("</div>"); result.Append(" </div>"); result.Append("</div>"); } var listId = db.TblConnectProductToGroup.Where(p => p.Idg == idMenu).Select(p => p.Idp).ToList(); var listProducts = db.TblProduct.Where(p => p.Active == true && listId.Contains(p.Id)).OrderBy(p => p.Ord).ToList(); for (int j = 0; j < listProducts.Count; j++) { result.Append("<div class=\"tear\">"); result.Append("<div class=\"contentTear\">"); float price = float.Parse(listProducts[j].Price.ToString()); float pricesale = float.Parse(listProducts[j].PriceSale.ToString()); float phantram = 100 - ((pricesale * 100) / price); if (listProducts[j].New == true) { result.Append(" <div class=\"sale\"> Mới 2018</div>"); } else { result.Append(" <div class=\"sale\">" + Convert.ToInt32(phantram) + "%</div>"); } if (listProducts[j].Note != null && listProducts[j].Note != "") { result.Append("<div class=\"noteTear\">" + listProducts[j].Note + "</div>"); } result.Append("<div class=\"img\">"); result.Append("<a href=\"/" + listProducts[j].Tag + ".html\" title=\"" + listProducts[j].Name + "\"><img src=\"" + listProducts[j].ImageLinkThumb + "\" alt=\"" + listProducts[j].Name + "\" /></a>"); result.Append(" </div>"); result.Append("<a href=\"/" + listProducts[j].Tag + ".html\" title=\"" + listProducts[j].Name + "\" class=\"name\">" + listProducts[j].Name + "</a>"); result.Append("<div class=\"boxItem\">"); result.Append("<div class=\"boxPrice\">"); result.Append("<span class=\"priceSale\">" + string.Format("{0:#,#}", listProducts[j].PriceSale) + "đ</span>"); if (listProduct[j].PriceNote != null && listProduct[j].PriceNote != "") { result.Append("<span class=\"priceNotes\">" + listProduct[j].PriceNote + "</span>"); } result.Append("<span class=\"price\">" + string.Format("{0:#,#}", listProducts[j].Price) + "đ</span>"); result.Append("</div>"); result.Append("<div class=\"boxSale\">"); result.Append("<a href=\"\" title=\"\"></a>"); result.Append("</div>"); result.Append("</div>"); result.Append(" </div>"); result.Append("</div>"); } result.Append("</div>"); result.Append("</div>"); } } else { result.Append("<div class=\"tearListProduct\">"); result.Append("<div class=\"saleProduct\">"); int idmanu = groupProduct.Id; var listIdImages = db.TblConnectImages.Where(p => p.IdCate == idmanu).Select(p => p.IdImg).ToList(); var listImage = db.TblImage.Where(p => p.Active == true && p.IdCate == 4 && listIdImages.Contains(p.Id)).OrderBy(p => p.Ord).ToList(); for (int j = 0; j < listImage.Count; j++) { result.Append("<a href=\"" + listImage[j].Url + "\" title=\"" + listImage[j].Name + "\"><img src=\"" + listImage[j].Images + "\" alt=\"" + listImage[j].Name + "\" /></a>"); } result.Append("</div>"); result.Append("<div class=\"filter\">"); result.Append("<span class=\"name\" style=\"color:#088ec1\">Danh sách sản phẩm " + groupProduct.Name + " : </span>"); result.Append("</div>"); result.Append("<div class=\"contentListProductContent\">"); var listProduct = db.TblProduct.Where(p => p.Active == true && p.IdCate == idmanu).OrderBy(p => p.Ord).ToList(); for (int j = 0; j < listProduct.Count; j++) { result.Append("<div class=\"tear\">"); result.Append("<div class=\"contentTear\">"); float price = float.Parse(listProduct[j].Price.ToString()); float pricesale = float.Parse(listProduct[j].PriceSale.ToString()); float phantram = 100 - ((pricesale * 100) / price); if (listProduct[j].New == true) { result.Append(" <div class=\"sale\"> Mới 2018</div>"); } else { result.Append(" <div class=\"sale\">" + Convert.ToInt32(phantram) + "%</div>"); } if (listProduct[j].Note != null && listProduct[j].Note != "") { result.Append("<div class=\"noteTear\">" + listProduct[j].Note + "</div>"); } result.Append("<div class=\"img\">"); result.Append("<a href=\"/san-pham/" + listProduct[j].Tag + "\" title=\"" + listProduct[j].Name + "\"><img src=\"" + listProduct[j].ImageLinkThumb + "\" alt=\"" + listProduct[j].Name + "\" /></a>"); result.Append(" </div>"); result.Append("<a href=\"/san-pham/" + listProduct[j].Tag + "\" title=\"" + listProduct[j].Name + "\" class=\"name\">" + listProduct[j].Name + "</a>"); result.Append("<div class=\"boxItem\">"); result.Append("<div class=\"boxPrice\">"); result.Append("<span class=\"priceSale\">" + string.Format("{0:#,#}", listProduct[j].PriceSale) + "đ</span>"); if (listProduct[j].PriceNote != null && listProduct[j].PriceNote != "") { result.Append("<span class=\"priceNotes\">" + listProduct[j].PriceNote + "</span>"); } result.Append("<span class=\"price\">" + string.Format("{0:#,#}", listProduct[j].Price) + "đ</span>"); result.Append("</div>"); result.Append("<div class=\"boxSale\">"); result.Append("<a href=\"\" title=\"\"></a>"); result.Append("</div>"); result.Append("</div>"); result.Append(" </div>"); result.Append("</div>"); } var listId = db.TblConnectProductToGroup.Where(p => p.Idg == idmanu).Select(p => p.Idp).ToList(); var listProducts = db.TblProduct.Where(p => p.Active == true && listId.Contains(p.Id)).OrderBy(p => p.Ord).ToList(); for (int j = 0; j < listProducts.Count; j++) { result.Append("<div class=\"tear\">"); result.Append("<div class=\"contentTear\">"); float price = float.Parse(listProducts[j].Price.ToString()); float pricesale = float.Parse(listProducts[j].PriceSale.ToString()); float phantram = 100 - ((pricesale * 100) / price); if (listProducts[j].New == true) { result.Append(" <div class=\"sale\"> Mới 2018</div>"); } else { result.Append(" <div class=\"sale\">" + Convert.ToInt32(phantram) + "%</div>"); } if (listProducts[j].Note != null && listProducts[j].Note != "") { result.Append("<div class=\"noteTear\">" + listProducts[j].Note + "</div>"); } result.Append("<div class=\"img\">"); result.Append("<a href=\"/" + listProducts[j].Tag + ".html\" title=\"" + listProducts[j].Name + "\"><img src=\"" + listProducts[j].ImageLinkThumb + "\" alt=\"" + listProducts[j].Name + "\" /></a>"); result.Append(" </div>"); result.Append("<a href=\"/" + listProducts[j].Tag + ".html\" title=\"" + listProducts[j].Name + "\" class=\"name\">" + listProducts[j].Name + "</a>"); result.Append("<div class=\"boxItem\">"); result.Append("<div class=\"boxPrice\">"); result.Append("<span class=\"priceSale\">" + string.Format("{0:#,#}", listProducts[j].PriceSale) + "đ</span>"); if (listProduct[j].PriceNote != null && listProduct[j].PriceNote != "") { result.Append("<span class=\"priceNotes\">" + listProduct[j].PriceNote + "</span>"); } result.Append("<span class=\"price\">" + string.Format("{0:#,#}", listProducts[j].Price) + "đ</span>"); result.Append("</div>"); result.Append("<div class=\"boxSale\">"); result.Append("<a href=\"\" title=\"\"></a>"); result.Append("</div>"); result.Append("</div>"); result.Append(" </div>"); result.Append("</div>"); } result.Append("</div>"); result.Append("</div>"); } var listIdGroup = db.TblConnectGroupProduct.Where(p => p.Idg == idCate).Select(p => p.Idc).ToList(); if (listIdGroup.Count > 0) { var listGroupProductChild = db.TblGroupProduct.Where(p => p.Active == true && listIdGroup.Contains(p.Id)).OrderBy(p => p.Ord).ToList(); for (int i = 0; i < listGroupProductChild.Count; i++) { int idMenu = listGroupProductChild[i].Id; result.Append("<div class=\"tearListProduct\">"); result.Append("<div class=\"filter\">"); result.Append("<h2 class=\"name\"><a href=\"/" + listGroupProductChild[i].Tag + "\" title=\"\">" + listGroupProductChild[i].Name + " </a> </h2>"); result.Append("</div>"); result.Append("<div class=\"contentListProductContent\">"); var listProduct = db.TblProduct.Where(p => p.Active == true && p.IdCate == idMenu).OrderBy(p => p.Ord).Take(12).ToList(); for (int j = 0; j < listProduct.Count; j++) { result.Append("<div class=\"tear\">"); result.Append("<div class=\"contentTear\">"); float price = float.Parse(listProduct[j].Price.ToString()); float pricesale = float.Parse(listProduct[j].PriceSale.ToString()); float phantram = 100 - ((pricesale * 100) / price); if (listProduct[j].New == true) { result.Append(" <div class=\"sale\"> Mới 2018</div>"); } else { result.Append(" <div class=\"sale\">" + Convert.ToInt32(phantram) + "%</div>"); } if (listProduct[j].Note != null && listProduct[j].Note != "") { result.Append("<div class=\"noteTear\">" + listProduct[j].Note + "</div>"); } result.Append("<div class=\"img\">"); result.Append("<a href=\"/san-pham/" + listProduct[j].Tag + "\" title=\"" + listProduct[j].Name + "\"><img src=\"" + listProduct[j].ImageLinkThumb + "\" alt=\"" + listProduct[j].Name + "\" /></a>"); result.Append(" </div>"); result.Append("<a href=\"/san-pham/" + listProduct[j].Tag + "\" title=\"" + listProduct[j].Name + "\" class=\"name\">" + listProduct[j].Name + "</a>"); result.Append("<div class=\"boxItem\">"); result.Append("<div class=\"boxPrice\">"); result.Append("<span class=\"priceSale\">" + string.Format("{0:#,#}", listProduct[j].PriceSale) + "đ</span>"); if (listProduct[j].PriceNote != null && listProduct[j].PriceNote != "") { result.Append("<span class=\"priceNotes\">" + listProduct[j].PriceNote + "</span>"); } result.Append("<span class=\"price\">" + string.Format("{0:#,#}", listProduct[j].Price) + "đ</span>"); result.Append("</div>"); result.Append("<div class=\"boxSale\">"); result.Append("<a href=\"\" title=\"\"></a>"); result.Append("</div>"); result.Append("</div>"); result.Append(" </div>"); result.Append("</div>"); } var listId = db.TblConnectProductToGroup.Where(p => p.Idg == idMenu).Select(p => p.Idp).ToList(); var listProducts = db.TblProduct.Where(p => p.Active == true && listId.Contains(p.Id)).OrderBy(p => p.Ord).ToList(); for (int j = 0; j < listProducts.Count; j++) { result.Append("<div class=\"tear\">"); result.Append("<div class=\"contentTear\">"); float price = float.Parse(listProducts[j].Price.ToString()); float pricesale = float.Parse(listProducts[j].PriceSale.ToString()); float phantram = 100 - ((pricesale * 100) / price); if (listProducts[j].New == true) { result.Append(" <div class=\"sale\"> Mới 2018</div>"); } else { result.Append(" <div class=\"sale\">" + Convert.ToInt32(phantram) + "%</div>"); } if (listProducts[j].Note != null && listProducts[j].Note != "") { result.Append("<div class=\"noteTear\">" + listProducts[j].Note + "</div>"); } result.Append("<div class=\"img\">"); result.Append("<a href=\"/" + listProducts[j].Tag + ".html\" title=\"" + listProducts[j].Name + "\"><img src=\"" + listProducts[j].ImageLinkThumb + "\" alt=\"" + listProducts[j].Name + "\" /></a>"); result.Append(" </div>"); result.Append("<a href=\"/" + listProducts[j].Tag + ".html\" title=\"" + listProducts[j].Name + "\" class=\"name\">" + listProducts[j].Name + "</a>"); result.Append("<div class=\"boxItem\">"); result.Append("<div class=\"boxPrice\">"); result.Append("<span class=\"priceSale\">" + string.Format("{0:#,#}", listProducts[j].PriceSale) + "đ</span>"); if (listProduct[j].PriceNote != null && listProduct[j].PriceNote != "") { result.Append("<span class=\"priceNotes\">" + listProduct[j].PriceNote + "</span>"); } result.Append("<span class=\"price\">" + string.Format("{0:#,#}", listProducts[j].Price) + "đ</span>"); result.Append("</div>"); result.Append("<div class=\"boxSale\">"); result.Append("<a href=\"\" title=\"\"></a>"); result.Append("</div>"); result.Append("</div>"); result.Append(" </div>"); result.Append("</div>"); } result.Append("</div>"); result.Append("</div>"); } } ViewBag.result = result.ToString(); //} //catch (Exception ex) //{ // //return Redirect("/error"); //} return(View()); }
public ActionResult Edit(TblGroupProduct TblGroupProduct, FormCollection collection, int id, int[] MutilMenuGroup) { if (ModelState.IsValid) { ////id = int.Parse(collection["idProduct"]); ////TblGroupProduct.Id = id; ////TblGroupProduct = db.TblGroupProduct.Find(id); string drMenu = collection["drMenu"]; string levelhiden = collection["Level"]; if (drMenu == "") { TblGroupProduct.ParentId = null; } else { if (drMenu != id.ToString()) { var dbLeve = db.TblGroupProduct.Find(int.Parse(drMenu)); TblGroupProduct.ParentId = dbLeve.Id; } } string IdUser = Request.Cookies["Username"].Values["UserID"]; TblGroupProduct.IdUser = int.Parse(IdUser); bool URL = (collection["URL"] == "false") ? false : true; if (URL == true) { TblGroupProduct.Tag = StringClass.NameToTag(TblGroupProduct.Name); } else { TblGroupProduct.Tag = collection["NameURL"]; } clsSitemap.UpdateSitemap(TblGroupProduct.Tag, id.ToString(), "GroupProduct"); TblGroupProduct.DateCreate = DateTime.Now; db.Entry(TblGroupProduct).State = EntityState.Modified; db.SaveChanges(); var listId = db.TblConnectGroupProduct.Where(p => p.Idg == id).ToList(); for (int i = 0; i < listId.Count; i++) { db.TblConnectGroupProduct.Remove(listId[i]); db.SaveChanges(); } if (MutilMenuGroup != null) { foreach (var item in MutilMenuGroup) { TblConnectGroupProduct conntect = new TblConnectGroupProduct(); conntect.Idg = id; conntect.Idc = item; db.TblConnectGroupProduct.Add(conntect); db.SaveChanges(); } } #region [Updatehistory] #endregion if (collection["btnSave"] != null) { if (drMenu == "") { Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã sửa danh mục thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/GroupProduct/Index?id=" + drMenu + "")); } else { Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã sửa danh mục thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/GroupProduct/Index?idCate=" + drMenu)); } } if (collection["btnSaveCreate"] != null) { Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã sửa danh mục thành công, mời bạn thêm danh mục sản phẩm mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/GroupProduct/Create?id=" + drMenu + "")); } } return(Redirect("/GroupProduct/")); }
public ActionResult Edit(int id) { carlist.Clear(); if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (ClsCheckRole.CheckQuyen(4, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { TblGroupProduct TblGroupProduct = db.TblGroupProduct.First(p => p.Id == id); if (TblGroupProduct == null) { return(HttpNotFound()); } ViewBag.Id = id; var menuName = db.TblGroupProduct.ToList(); var pro = db.TblGroupProduct.OrderByDescending(p => p.Ord).Take(1).ToList(); var menuModel = db.TblGroupProduct.Where(m => m.ParentId == null).OrderBy(m => m.Id).ToList(); string strReturn = "---"; carlist.Clear(); foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); StringClass.DropDownListFor(item.Id, carlist, strReturn); strReturn = "---"; } int idParent = 0; string kiemtra = TblGroupProduct.ParentId.ToString(); if (kiemtra != null && kiemtra != "") { idParent = int.Parse(TblGroupProduct.ParentId.ToString()); ViewBag.drMenu = new SelectList(carlist, "Value", "Text", idParent); } else { ViewBag.drMenu = carlist; } var MenuGroup = db.TblGroupProduct.Where(m => m.ParentId == null).OrderBy(m => m.Id).ToList(); carlistGroup.Clear(); var listIdGroup = db.TblConnectGroupProduct.Where(p => p.Idg == id).Select(p => p.Idg).ToList(); List <int> mang = new List <int>(); for (int i = 0; i < listIdGroup.Count; i++) { mang.Add(listIdGroup[i].Value); } string strReturnGrup = "---"; foreach (var item in MenuGroup) { carlistGroup.Add(new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); StringClass.DropDownListFor(item.Id, carlistGroup, strReturnGrup); strReturnGrup = "---"; } ViewBag.MutilMenuGroup = new MultiSelectList(carlistGroup, "Value", "Text", mang); return(View(TblGroupProduct)); } else { return(Redirect("/Users/Erro")); } }
public ActionResult Index(string idCate, FormCollection collection) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (ClsCheckRole.CheckQuyen(4, 0, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { var menuModel = db.TblGroupProduct.Where(m => m.ParentId == null).OrderBy(m => m.Id).ToList(); carlist.Clear(); string strReturn = "---"; foreach (var item in menuModel) { carlist.Add(new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); StringClass.DropDownListFor(item.Id, carlist, strReturn); strReturn = "---"; } //ViewBag.drMenu = carlist; ViewBag.drMenu = new SelectList(carlist, "Value", "Text", 8); if (idCate != "") { ViewBag.drMenu = new SelectList(carlist, "Value", "Text", idCate); ViewBag.IdCate = idCate; ViewBag.IdMenu = idCate; } else { ViewBag.drMenu = carlist; } if (collection["btnDelete"] != null) { foreach (string key in Request.Form.Keys) { var checkbox = ""; if (key.StartsWith("chk_")) { checkbox = Request.Form["" + key]; if (checkbox != "false") { if (ClsCheckRole.CheckQuyen(4, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { int id = Convert.ToInt32(key.Remove(0, 4)); TblGroupProduct TblProduct = db.TblGroupProduct.Find(id); db.TblGroupProduct.Remove(TblProduct); db.SaveChanges(); var listProduct = db.TblProduct.Where(p => p.IdCate == id).ToList(); for (int i = 0; i < listProduct.Count; i++) { db.TblProduct.Remove(listProduct[i]); db.SaveChanges(); } clsSitemap.DeteleSitemap(id.ToString(), "GroupProduct"); } else { return(Redirect("/Users/Erro")); } } } } //dsd } if (Session["Thongbao"] != null && Session["Thongbao"] != "") { ViewBag.thongbao = Session["Thongbao"].ToString(); Session["Thongbao"] = ""; } return(View()); } else { return(Redirect("/Users/Erro")); } }