public ActionResult ListMenufacturers(int?page, string tag) { var ListManFacturers = db.tblAgencies.Where(p => p.Active == true).OrderByDescending(p => p.Ord).ToList(); ViewBag.Name = "Hệ thống phân phối"; ViewBag.Title = "<title>Hệ thống phân phối Viglacera</title>"; ViewBag.Description = "<meta name=\"description\" content=\"Hệ thống phân phối chính hãng sản phẩm thiết bị vệ sinh Viglacera trên toàn quốc. Địa chỉ : 391 - Nguyễn Xiển - Thanh Xuân - HN\"/>"; ViewBag.Keyword = "<meta name=\"keywords\" content=\"Hệ thống phân phối thiết bị vệ sinh Viglacera\" /> "; if (tag != "" && tag != null) { int idMenu; string Chuoi = tag; string[] Mang = Chuoi.Split('-'); int one = int.Parse(Mang.Length.ToString()); string chuoi1 = Mang[one - 1].ToString(); string[] Mang1 = chuoi1.Split('.'); idMenu = int.Parse(Mang1[0].ToString()); tblGroupAgency groupnew = db.tblGroupAgencies.Find(idMenu); ViewBag.Name = groupnew.Name; ViewBag.Title = "<title>" + groupnew.Name + "</title>"; ViewBag.Description = "<meta name=\"description\" content=\"" + groupnew.Description + "\"/>"; ViewBag.Keyword = "<meta name=\"keywords\" content=\"" + groupnew.Name + "\" /> "; ListManFacturers = db.tblAgencies.Where(p => p.Active == true && p.idMenu == idMenu).OrderByDescending(p => p.Ord).ToList(); } const int pageSize = 10; var pageNumber = (page ?? 1); // Thiết lập phân trang var ship = new PagedListRenderOptions { DisplayLinkToFirstPage = PagedListDisplayMode.Always, DisplayLinkToLastPage = PagedListDisplayMode.Always, DisplayLinkToPreviousPage = PagedListDisplayMode.Always, DisplayLinkToNextPage = PagedListDisplayMode.Always, DisplayLinkToIndividualPages = true, DisplayPageCountAndCurrentLocation = false, MaximumPageNumbersToDisplay = 5, DisplayEllipsesWhenNotShowingAllPageNumbers = true, EllipsesFormat = "…", LinkToFirstPageFormat = "Trang đầu", LinkToPreviousPageFormat = "«", LinkToIndividualPageFormat = "{0}", LinkToNextPageFormat = "»", LinkToLastPageFormat = "Trang cuối", PageCountAndCurrentLocationFormat = "Page {0} of {1}.", ItemSliceAndTotalFormat = "Showing items {0} through {1} of {2}.", FunctionToDisplayEachPageNumber = null, ClassToApplyToFirstListItemInPager = null, ClassToApplyToLastListItemInPager = null, ContainerDivClasses = new[] { "pagination-container" }, UlElementClasses = new[] { "pagination" }, LiElementClasses = Enumerable.Empty <string>() }; ViewBag.ship = ship; return(View(ListManFacturers.ToPagedList(pageNumber, pageSize))); }
public ActionResult AgencyList(string tag, int?page) { int idMenu; string Chuoi = tag; string[] Mang = Chuoi.Split('-'); int one = int.Parse(Mang.Length.ToString()); string chuoi1 = Mang[one - 1].ToString(); string[] Mang1 = chuoi1.Split('.'); idMenu = int.Parse(Mang1[0].ToString()); tblGroupAgency groupagency = db.tblGroupAgencies.Find(idMenu); int idCate = groupagency.id; var LisstAgency = db.tblAgencies.Where(p => p.Active == true).OrderByDescending(p => p.Ord).ToList(); ViewBag.Name = groupagency.Name; ViewBag.Title = "<title>" + groupagency.Name + "</title>"; ViewBag.Description = "<meta name=\"description\" content=\"" + groupagency.Description + "\"/>"; ViewBag.Keyword = "<meta name=\"keywords\" content=\"" + groupagency.Name + "\" /> "; ViewBag.nUrl = "<a href=\"/\" title=\"Trang chu\" rel=\"nofollow\"><span class=\"iCon\"></span>Trang chủ</a> /" + groupagency.Name; const int pageSize = 12; var pageNumber = (page ?? 1); // Thiết lập phân trang var ship = new PagedListRenderOptions { DisplayLinkToFirstPage = PagedListDisplayMode.Always, DisplayLinkToLastPage = PagedListDisplayMode.Always, DisplayLinkToPreviousPage = PagedListDisplayMode.Always, DisplayLinkToNextPage = PagedListDisplayMode.Always, DisplayLinkToIndividualPages = true, DisplayPageCountAndCurrentLocation = false, MaximumPageNumbersToDisplay = 5, DisplayEllipsesWhenNotShowingAllPageNumbers = true, EllipsesFormat = "…", LinkToFirstPageFormat = "Trang đầu", LinkToPreviousPageFormat = "«", LinkToIndividualPageFormat = "{0}", LinkToNextPageFormat = "»", LinkToLastPageFormat = "Trang cuối", PageCountAndCurrentLocationFormat = "Page {0} of {1}.", ItemSliceAndTotalFormat = "Showing items {0} through {1} of {2}.", FunctionToDisplayEachPageNumber = null, ClassToApplyToFirstListItemInPager = null, ClassToApplyToLastListItemInPager = null, ContainerDivClasses = new[] { "pagination-container" }, UlElementClasses = new[] { "pagination" }, LiElementClasses = Enumerable.Empty <string>() }; ViewBag.ship = ship; return(View(LisstAgency.ToPagedList(pageNumber, pageSize))); }
// GET: Convert public ActionResult Index() { var listProduct = db.tblNews.ToList(); foreach (var item in listProduct) { int id = item.id; tblNew tblproduct = db.tblNews.Find(id); tblproduct.Tag = StringClass.NameToTag(tblproduct.Name); db.SaveChanges(); } var listProducts = db.tblGroupNews.ToList(); foreach (var item in listProducts) { int id = item.id; tblGroupNew tblproduct = db.tblGroupNews.Find(id); tblproduct.Tag = StringClass.NameToTag(tblproduct.Name); db.SaveChanges(); } var listProductss = db.tblAgencies.ToList(); foreach (var item in listProductss) { int id = item.id; tblAgency tblproduct = db.tblAgencies.Find(id); tblproduct.Tag = StringClass.NameToTag(tblproduct.Name); db.SaveChanges(); } var listProducstsss = db.tblGroupAgencies.ToList(); foreach (var item in listProducstsss) { int id = item.id; tblGroupAgency tblproduct = db.tblGroupAgencies.Find(id); tblproduct.Tag = StringClass.NameToTag(tblproduct.Name); db.SaveChanges(); } return(View()); }
public ActionResult AgencyList(string tag, int?page) { if (tag != null) { tblGroupAgency groupagency = db.tblGroupAgencies.First(p => p.Tag == tag); ViewBag.Title = "<title>Dịch vụ thay lõi lọc nước của VINCOM tại " + groupagency.Name + "</title>"; ViewBag.Description = "<meta name=\"description\" content=\"" + groupagency.Description + "\"/>"; ViewBag.Keyword = "<meta name=\"keywords\" content=\"Đại lý của VINCOM tại " + groupagency.Name + "\" /> "; int idcate = int.Parse(groupagency.id.ToString()); ViewBag.Name = groupagency.Name; var ListAgency = db.tblAgencies.Where(p => p.idMenu == idcate && p.Active == true).OrderByDescending(p => p.DateCreate).ToList(); const int pageSize = 20; var pageNumber = (page ?? 1); // Thiết lập phân trang var ship = new PagedListRenderOptions { DisplayLinkToFirstPage = PagedListDisplayMode.Always, DisplayLinkToLastPage = PagedListDisplayMode.Always, DisplayLinkToPreviousPage = PagedListDisplayMode.Always, DisplayLinkToNextPage = PagedListDisplayMode.Always, DisplayLinkToIndividualPages = true, DisplayPageCountAndCurrentLocation = false, MaximumPageNumbersToDisplay = 5, DisplayEllipsesWhenNotShowingAllPageNumbers = true, EllipsesFormat = "…", LinkToFirstPageFormat = "Trang đầu", LinkToPreviousPageFormat = "«", LinkToIndividualPageFormat = "{0}", LinkToNextPageFormat = "»", LinkToLastPageFormat = "Trang cuối", PageCountAndCurrentLocationFormat = "Page {0} of {1}.", ItemSliceAndTotalFormat = "Showing items {0} through {1} of {2}.", FunctionToDisplayEachPageNumber = null, ClassToApplyToFirstListItemInPager = null, ClassToApplyToLastListItemInPager = null, ContainerDivClasses = new[] { "pagination-container" }, UlElementClasses = new[] { "pagination" }, LiElementClasses = Enumerable.Empty <string>() }; ViewBag.ship = ship; ViewBag.name = groupagency.Name; int dodai = groupagency.Level.Length / 5; string nUrl = ""; for (int i = 0; i < dodai; i++) { int leht = groupagency.Level.Substring(0, (i + 1) * 5).Length; var NameGroups = db.tblGroupAgencies.First(p => p.Level.Substring(0, (i + 1) * 5) == groupagency.Level.Substring(0, (i + 1) * 5) && p.Level.Length == (i + 1) * 5); nUrl = nUrl + " <a href=\"/4/" + NameGroups.Tag + "\" title=\"" + NameGroups.Name + "\"> " + " " + NameGroups.Name + " /</a> "; } ViewBag.nUrl = " <a href=\"/\" title=\"Trang chu\" rel=\"nofollow\"><span class=\"icon_Homes\"></span>Trang chủ /</a> " + nUrl + " "; ViewBag.favicon = " <link href=\"" + db.tblConfigs.First().Favicon + "\" rel=\"icon\" type=\"image/x-icon\" />"; var listGroupAgency = db.tblGroupAgencies.Where(p => p.Active == true).OrderByDescending(p => p.Ord).ToList(); string chuoi = ""; for (int i = 0; i < listGroupAgency.Count; i++) { chuoi += "<a href=\"/4/" + listGroupAgency[i].Tag + "\" title=\"" + listGroupAgency[i].Name + "\">› " + listGroupAgency[i].Name + "</a>"; } ViewBag.chuoi = chuoi; string chuoilienquan = ""; int idMenu = int.Parse(groupagency.id.ToString()); var listAgebcys = db.tblAgencies.Where(p => p.Active == true && p.idMenu != idMenu).OrderByDescending(p => p.DateCreate).Take(10).ToList(); for (int i = 0; i < listAgebcys.Count; i++) { chuoilienquan += "<a href=\"/5/" + listAgebcys[i].Tag + "\" title=\"" + listAgebcys[i].Name + "\">› " + listAgebcys[i].Name + "</a>"; } ViewBag.chuoilienquan = chuoilienquan; return(View(ListAgency.ToPagedList(pageNumber, pageSize))); } else { //tblGroupAgency groupagency = db.tblGroupAgencies.First(p => p.Tag == tag); ViewBag.Title = "<title>Dịch vụ thay lõi lọc nước của VINCOM</title>"; ViewBag.Description = "<meta name=\"description\" content=\"Tổng hợp danh sách đại lý phân phối thiết bị lọc nước, máy lọc nước, lõi lọc nước của VINCOM tại các tỉnh thành trên cả nước\"/>"; ViewBag.Keyword = "<meta name=\"keywords\" content=\"Đại lý của VINCOM, máy lọc nước tại VINCOM, cửa hàng của VINCOM\" /> "; ViewBag.Name = "Danh sách đại lý phân phối của VINCOM"; var ListAgency = db.tblAgencies.Where(p => p.Active == true).OrderByDescending(p => p.DateCreate).ToList(); const int pageSize = 20; var pageNumber = (page ?? 1); // Thiết lập phân trang var ship = new PagedListRenderOptions { DisplayLinkToFirstPage = PagedListDisplayMode.Always, DisplayLinkToLastPage = PagedListDisplayMode.Always, DisplayLinkToPreviousPage = PagedListDisplayMode.Always, DisplayLinkToNextPage = PagedListDisplayMode.Always, DisplayLinkToIndividualPages = true, DisplayPageCountAndCurrentLocation = false, MaximumPageNumbersToDisplay = 5, DisplayEllipsesWhenNotShowingAllPageNumbers = true, EllipsesFormat = "…", LinkToFirstPageFormat = "Trang đầu", LinkToPreviousPageFormat = "«", LinkToIndividualPageFormat = "{0}", LinkToNextPageFormat = "»", LinkToLastPageFormat = "Trang cuối", PageCountAndCurrentLocationFormat = "Page {0} of {1}.", ItemSliceAndTotalFormat = "Showing items {0} through {1} of {2}.", FunctionToDisplayEachPageNumber = null, ClassToApplyToFirstListItemInPager = null, ClassToApplyToLastListItemInPager = null, ContainerDivClasses = new[] { "pagination-container" }, UlElementClasses = new[] { "pagination" }, LiElementClasses = Enumerable.Empty <string>() }; ViewBag.ship = ship; ViewBag.nUrl = " <a href=\"/\" title=\"Trang chu\" rel=\"nofollow\"><span class=\"icon_Homes\"></span>Trang chủ /</a> "; ViewBag.favicon = " <link href=\"" + db.tblConfigs.First().Favicon + "\" rel=\"icon\" type=\"image/x-icon\" />"; var listGroupAgency = db.tblGroupAgencies.Where(p => p.Active == true).OrderByDescending(p => p.Ord).ToList(); string chuoi = ""; for (int i = 0; i < listGroupAgency.Count; i++) { chuoi += "<a href=\"/4/" + listGroupAgency[i].Tag + "\" title=\"" + listGroupAgency[i].Name + "\">› " + listGroupAgency[i].Name + "</a>"; } ViewBag.chuoi = chuoi; string chuoilienquan = ""; var listAgebcys = db.tblAgencies.Where(p => p.Active == true).OrderByDescending(p => p.DateCreate).Take(10).ToList(); for (int i = 0; i < listAgebcys.Count; i++) { chuoilienquan += "<a href=\"/5/" + listAgebcys[i].Tag + "\" title=\"" + listAgebcys[i].Name + "\">› " + listAgebcys[i].Name + "</a>"; } ViewBag.chuoilienquan = chuoilienquan; return(View(ListAgency.ToPagedList(pageNumber, pageSize))); } }