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