public ActionResult ListNews(int?page, string id, string tag)
{
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());
tblGroupNew groupnew = db.tblGroupNews.Find(idMenu);
var ListNew = db.tblNews.Where(p => p.Active == true && p.idCate == idMenu).OrderByDescending(p => p.Ord).ToList();
ViewBag.Name = groupnew.Name;
ViewBag.Title = "<title>" + groupnew.Title + "</title>";
ViewBag.Description = "<meta name=\"description\" content=\"" + groupnew.Description + "\"/>";
ViewBag.Keyword = "<meta name=\"keywords\" content=\"" + groupnew.Keyword + "\" /> ";
ViewBag.nUrl = "<a href=\"/\" title=\"Trang chu\" rel=\"nofollow\"><span class=\"iCon\"></span>Trang chủ</a> /" + UrlNews(idMenu);
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(ListNew.ToPagedList(pageNumber, pageSize)));
}
public ActionResult ListNews(string tag, int?page)
{
tblGroupNew groupnews = db.tblGroupNews.First(p => p.Tag == tag);
ViewBag.Title = "<title>" + groupnews.Title + "</title>";
ViewBag.Description = "<meta name=\"description\" content=\"" + groupnews.Description + "\"/>";
ViewBag.Keyword = "<meta name=\"keywords\" content=\"" + groupnews.Keyword + "\" /> ";
int idcate = int.Parse(groupnews.id.ToString());
ViewBag.Name = groupnews.Name;
var Listnews = db.tblNews.Where(p => p.idCate == 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 = groupnews.Name;
ViewBag.nUrl = "<ol itemscope itemtype=\"http://schema.org/BreadcrumbList\"> <li itemprop=\"itemListElement\" itemscope itemtype=\"http://schema.org/ListItem\"> <a itemprop=\"item\" href=\"http://Thayloilocnuoc.com\"> <span itemprop=\"name\">Trang chủ</span></a> <meta itemprop=\"position\" content=\"1\" /> </li> ›" + UrlNews(idcate) + "</ol> ";
ViewBag.favicon = " <link href=\"" + db.tblConfigs.First().Favicon + "\" rel=\"icon\" type=\"image/x-icon\" />";
return(View(Listnews.ToPagedList(pageNumber, pageSize)));
}
public ActionResult Create(tblGroupNew tblgroupnews, FormCollection collection)
{
if ((Request.Cookies["Username"] == null))
{
return(RedirectToAction("LoginIndex", "Login"));
}
string drMenu = collection["drMenu"];
string nLevel;
if (drMenu == "")
{
tblgroupnews.ParentID = null;
}
else
{
var dbLeve = db.tblGroupNews.Find(int.Parse(drMenu));
tblgroupnews.ParentID = dbLeve.id;
}
tblgroupnews.DateCreate = DateTime.Now;
string idUser = Request.Cookies["Username"].Values["UserID"];
tblgroupnews.idUser = int.Parse(idUser);
tblgroupnews.Tag = StringClass.NameToTag(tblgroupnews.Name);
db.tblGroupNews.Add(tblgroupnews);
db.SaveChanges();
Updatehistoty.UpdateHistory("Add Group Product", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
var Groups = db.tblGroupNews.Where(p => p.Active == true).OrderByDescending(p => p.id).Take(1).ToList();
string id = Groups[0].id.ToString();
clsSitemap.CreateSitemap(StringClass.NameToTag(tblgroupnews.Name), id, "GroupNews");
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("/GroupNews/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 mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/GroupNews/Create?id=" + drMenu + ""));
}
return(Redirect("/GroupNews/Index?idCate=" + drMenu));
}
public ActionResult DeleteGroupNews(int id)
{
if (ClsCheckRole.CheckQuyen(5, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
tblGroupNew tblgroupnews = db.tblGroupNews.Find(id);
clsSitemap.DeteleSitemap(id.ToString(), "GroupNews");
var result = string.Empty;
db.tblGroupNews.Remove(tblgroupnews);
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 }));
}
}
// 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 Edit(int id)
{
if ((Request.Cookies["Username"] == null))
{
return(RedirectToAction("LoginIndex", "Login"));
}
if (ClsCheckRole.CheckQuyen(5, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
tblGroupNew tblgroupnews = db.tblGroupNews.First(p => p.id == id);
if (tblgroupnews == null)
{
return(HttpNotFound());
}
ViewBag.id = id;
var menuName = db.tblGroupNews.ToList();
var pro = db.tblGroupNews.OrderByDescending(p => p.Ord).Take(1).ToList();
var menuModel = db.tblGroupNews.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.DropDownListNews(item.id, carlist, strReturn);
strReturn = "---";
}
ViewBag.drMenu = new SelectList(carlist, "Value", "Text", id);
return(View(tblgroupnews));
}
else
{
return(Redirect("/Users/Erro"));
}
}
public ActionResult Edit(tblGroupNew tblgroupnews, FormCollection collection, int id)
{
string drMenu = collection["drMenu"];
string nLevel = "";
if (drMenu == "")
{
tblgroupnews.ParentID = null;
var counts = db.tblGroupNews.Where(p => p.ParentID == null).OrderByDescending(p => p.Ord).Take(1).ToList();
}
else
{
if (drMenu != id.ToString())
{
var dbLeve = db.tblGroupNews.Find(int.Parse(drMenu));
tblgroupnews.ParentID = dbLeve.id;
}
}
string idUser = Request.Cookies["Username"].Values["UserID"];
tblgroupnews.idUser = int.Parse(idUser);
bool URL = (collection["URL"] == "false") ? false : true;
if (URL == true)
{
tblgroupnews.Tag = StringClass.NameToTag(tblgroupnews.Name);
}
else
{
tblgroupnews.Tag = collection["NameURL"];
}
clsSitemap.CreateSitemap(tblgroupnews.Tag, id.ToString(), "GroupNews");
tblgroupnews.DateCreate = DateTime.Now;
db.Entry(tblgroupnews).State = EntityState.Modified;
db.SaveChanges();
#region [Updatehistory]
Updatehistoty.UpdateHistory("Edit tblgroupnews", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
#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("/GroupNews/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>";
var checkgroup = db.tblGroupNews.Where(p => p.id == int.Parse(drMenu)).ToList();
if (checkgroup.Count > 0)
{
return(Redirect("/GroupNews/Index?idCate=" + checkgroup[0].id));
}
}
}
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 mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/GroupNews/Create?id=" + drMenu + ""));
}
return(Redirect("/GroupNews/"));
}
public ActionResult Index(string idCate, FormCollection collection)
{
if ((Request.Cookies["Username"] == null))
{
return(RedirectToAction("LoginIndex", "Login"));
}
if (ClsCheckRole.CheckQuyen(5, 0, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
var menuModel = db.tblGroupNews.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.DropDownListNews(item.id, carlist, strReturn);
strReturn = "---";
}
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(5, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
int id = Convert.ToInt32(key.Remove(0, 4));
tblGroupNew tblgroupnews = db.tblGroupNews.Find(id);
db.tblGroupNews.Remove(tblgroupnews);
db.SaveChanges();
var listnews = db.tblNews.Where(p => p.idCate == id).ToList();
for (int i = 0; i < listnews.Count; i++)
{
db.tblNews.Remove(listnews[i]);
db.SaveChanges();
}
}
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"));
}
}
public ActionResult newsDetail(string tag)
{
tblNew tblnews = db.tblNews.First(p => p.Tag == tag);
int id = tblnews.id;
int idmenu = int.Parse(tblnews.idCate.ToString());
tblGroupNew groupNews = db.tblGroupNews.First(p => p.id == idmenu);
ViewBag.menuName = groupNews.Name;
ViewBag.tagMenuName = groupNews.Tag;
var listId = db.tblConnectManuToNews.Where(p => p.idNews == id).Select(p => p.idManu).Take(1).ToList();
Session["idManu"] = "";
int idManu = int.Parse(listId[0].Value.ToString());
var manufactures = db.SelectListItem.Find(idManu);
ViewBag.manuName = manufactures.Name;
ViewBag.color = manufactures.Color;
Session["idManu"] = idManu;
if (tblnews.Style == true)
{
ViewBag.style = "width:100% !important; margin:0px";
ViewBag.style1 = "display:none";
}
ViewBag.Title = "<title>" + tblnews.Title + "</title>";
ViewBag.Description = "<meta name=\"description\" content=\"" + tblnews.Description + "\"/>";
ViewBag.Keyword = "<meta name=\"keywords\" content=\"" + tblnews.Keyword + "\" /> ";
ViewBag.dcTitle = "<meta name=\"DC.title\" content=\"" + tblnews.Title + "\" />";
if (tblnews.Meta != null && tblnews.Meta != "")
{
int phut = DateTime.Now.Minute * 2;
ViewBag.refresh = "<meta http-equiv=\"refresh\" content=\"" + phut + "; url=" + tblnews.Meta + "\">";
}
ViewBag.dcDescription = "<meta name=\"DC.description\" content=\"" + tblnews.Description + "\" />";
string meta = "";
ViewBag.canonical = "<link rel=\"canonical\" href=\"http://Kangaroochinhhang.com/3/" + StringClass.NameToTag(tag) + "\" />";
meta += "<meta itemprop=\"name\" content=\"" + tblnews.Name + "\" />";
meta += "<meta itemprop=\"url\" content=\"" + Request.Url.ToString() + "\" />";
meta += "<meta itemprop=\"description\" content=\"" + tblnews.Description + "\" />";
meta += "<meta itemprop=\"image\" content=\"http://Kangaroochinhhang.com" + tblnews.Images + "\" />";
meta += "<meta property=\"og:title\" content=\"" + tblnews.Title + "\" />";
meta += "<meta property=\"og:type\" content=\"product\" />";
meta += "<meta property=\"og:url\" content=\"" + Request.Url.ToString() + "\" />";
meta += "<meta property=\"og:image\" content=\"http://Kangaroochinhhang.com" + tblnews.Images + "\" />";
meta += "<meta property=\"og:site_name\" content=\"http://Kangaroochinhhang.com\" />";
meta += "<meta property=\"og:description\" content=\"" + tblnews.Description + "\" />";
meta += "<meta property=\"fb:admins\" content=\"\" />";
ViewBag.Meta = meta;
StringBuilder schame = new StringBuilder();
schame.Append("<script type=\"application/ld+json\">");
schame.Append("{");
schame.Append("\"@context\": \"http://schema.org\",");
schame.Append("\"@type\": \"NewsArticle\",");
schame.Append("\"headline\": \"" + tblnews.Description + "\",");
schame.Append(" \"datePublished\": \"" + tblnews.DateCreate + "\",");
schame.Append("\"image\": [");
schame.Append(" \"" + tblnews.Images + "\"");
schame.Append(" ]");
schame.Append("}");
schame.Append("</script> ");
ViewBag.schame = schame.ToString();
int iduser = int.Parse(tblnews.idUser.ToString());
ViewBag.user = db.tblUsers.First(p => p.id == iduser).UserName;
string tab = tblnews.Tabs;
string Tabsnews = "";
if (tab != null)
{
string[] mang = tab.Split(',');
for (int i = 0; i < mang.Length; i++)
{
Tabsnews += " <a href=\"/TagNews/" + StringClass.NameToTag(mang[i]) + "\" title=\"" + mang[i] + "\">" + mang[i] + "</a>";
}
ViewBag.tags = Tabsnews;
}
StringBuilder result = new StringBuilder();
var listIdNews = db.tblConnectManuToNews.Where(p => listId.Contains(p.idManu)).Select(p => p.idNews).ToList();
var listnews = db.tblNews.Where(p => listIdNews.Contains(p.id) && p.Active == true && p.id != id).OrderByDescending(p => p.DateCreate).Take(5).ToList();
if (listnews.Count > 0)
{
for (int j = 0; j < listnews.Count; j++)
{
result.Append(" <li><a href=\"/3/" + listnews[j].Tag + "\" title=\"" + listnews[j].Name + "\"><i class=\"fa fa-angle-right\" aria-hidden=\"true\"></i> " + listnews[j].Name + "</a><span>");
result.Append(" <i class=\"fa fa-clock-o\" aria-hidden=\"true\"></i> Viết ngày : " + listnews[j].DateCreate + " </span><li>");
}
}
ViewBag.result = result.ToString();
ViewBag.favicon = " <link href=\"" + manufactures.Favicon + "\" rel=\"icon\" type=\"image/x-icon\" />";
ViewBag.nUrl = "<ol itemscope itemtype=\"http://schema.org/BreadcrumbList\"> <li itemprop=\"itemListElement\" itemscope itemtype=\"http://schema.org/ListItem\"> <a itemprop=\"item\" href=\"http://Kangaroochinhhang.com\"> <span itemprop=\"name\">Trang chủ</span></a> <meta itemprop=\"position\" content=\"1\" /> </li> ›" + Urlnews(idmenu) + "</ol>";
int visit = int.Parse(tblnews.Visit.ToString());
if (visit > 0)
{
tblnews.Visit = tblnews.Visit + 1;
db.SaveChanges();
}
else
{
tblnews.Visit = tblnews.Visit + 1;
db.SaveChanges();
}
return(View(tblnews));
}
public ActionResult ListNews(string tag, int?page)
{
tblGroupNew groupnew = db.tblGroupNews.First(p => p.Tag == tag);
int idCate = groupnew.id;
var listNews = db.tblNews.Where(p => p.idCate == idCate && p.Active == true).OrderByDescending(p => p.Ord).ToList();
var Countlistnew = db.tblGroupNews.Where(p => p.ParentID == idCate && p.Active == true).OrderBy(p => p.Ord).ToList();
if (Countlistnew.Count > 1)
{
for (int i = 0; i < Countlistnew.Count; i++)
{
int idMenus = int.Parse(Countlistnew[i].id.ToString());
listNews = db.tblNews.Where(p => p.idCate == idMenus && p.Active == true).OrderByDescending(p => p.Ord).ToList();
}
}
ViewBag.Name = groupnew.Name;
ViewBag.Title = "<title>" + groupnew.Title + "</title>";
ViewBag.Description = "<meta name=\"description\" content=\"" + groupnew.Description + "\"/>";
ViewBag.Keyword = "<meta name=\"keywords\" content=\"" + groupnew.Keyword + "\" /> ";
ViewBag.nUrl = "<a href=\"http://BinhnuocnonglanhAriston.vn\" title=\"Trang chu\" rel=\"nofollow\"><span class=\"iCon\"></span>Trang chủ</a> /" + UrlNews(idCate);
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;
string coppy = "";
var tblconfig = db.tblConfigs.First();
if (tblconfig.Coppy == true)
{
coppy += "<script src=\"/Scripts/disable-copyright.js\"></script>";
coppy += "<link href=\"/Content/Display/Css/Coppy.css\" rel=\"stylesheet\" />";
}
ViewBag.coppy = coppy;
return(View(listNews.ToPagedList(pageNumber, pageSize)));
}