public ActionResult Create(tblNew tblnews, FormCollection Collection, string id, int[] MutilMenu) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } string nidCate = Collection["drMenu"]; if (nidCate != "") { tblnews.idCate = int.Parse(nidCate); int idcate = int.Parse(nidCate); tblnews.DateCreate = DateTime.Now; tblnews.Tag = StringClass.NameToTag(tblnews.Name); tblnews.DateCreate = DateTime.Now; string idUser = Request.Cookies["Username"].Values["UserID"]; tblnews.idUser = int.Parse(idUser); StringClass.NewsCreateTag(tblnews.id, tblnews.Keyword); db.tblNews.Add(tblnews); db.SaveChanges(); var listprro = db.tblNews.OrderByDescending(p => p.id).Take(1).ToList(); clsSitemap.CreateSitemap("tin-tuc/" + tblnews.Tag, listprro[0].id.ToString(), "News"); #region [Updatehistory] Updatehistoty.UpdateHistory("Create News", Request.Cookies["Username"].Values["Username"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString()); #endregion var ListNews = db.tblNews.OrderByDescending(p => p.id).Take(1).ToList(); int idNews = int.Parse(ListNews[0].id.ToString()); if (MutilMenu != null) { foreach (var idCate in MutilMenu) { tblConnectNew tblconnectnews = new tblConnectNew(); tblconnectnews.idCate = idCate; tblconnectnews.idNew = idNews; db.tblConnectNews.Add(tblconnectnews); db.SaveChanges(); } } if (Collection["btnSave"] != null) { Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã thêm tinthành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/Newsad/index?idCate=" + nidCate + "")); } if (Collection["btnSaveCreate"] != null) { Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm tin thành công, mời bạn thêm tin mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/Newsad/Create?id=" + nidCate + "")); } } return(View()); }
public ActionResult Edit(tblNew tblnews, FormCollection collection, int?id, int[] MutilMenu) { if (ModelState.IsValid) { if (collection["drMenu"] != "" || collection["drMenu"] != null) { string idUser = Request.Cookies["Username"].Values["UserID"]; tblnews.idUser = int.Parse(idUser); bool URL = (collection["URL"] == "false") ? false : true; if (URL == true) { tblnews.Tag = StringClass.NameToTag(tblnews.Name); } else { tblnews.Tag = collection["NameURL"]; } clsSitemap.CreateSitemap(tblnews.Tag + ".html", id.ToString(), "Newsad"); tblnews.idCate = int.Parse(collection["drMenu"]); StringClass.NewsCreateTag(tblnews.id, tblnews.Keyword); tblnews.DateCreate = DateTime.Now; db.Entry(tblnews).State = EntityState.Modified; db.SaveChanges(); if (URL == true) { tblnews.Tag = StringClass.NameToTag(tblnews.Name); clsSitemap.UpdateSitemap("tin-tuc/" + StringClass.NameToTag(tblnews.Name), id.ToString(), "News"); } else { tblnews.Tag = collection["NameURL"]; clsSitemap.UpdateSitemap("tin-tuc/" + StringClass.NameToTag(tblnews.Name), id.ToString(), "News"); } int Ord = int.Parse(tblnews.Ord.ToString()); int idCate = int.Parse(collection["drMenu"]); var Kiemtra = db.tblNews.Where(p => p.Ord == Ord && p.idCate == idCate && p.id != id).ToList(); if (Kiemtra.Count > 0) { var ListNewss = db.tblNews.Where(p => p.Ord >= Ord && p.idCate == idCate).ToList(); for (int i = 0; i < ListNewss.Count; i++) { int idp = int.Parse(ListNewss[i].id.ToString()); var NewUpdate = db.tblNews.Find(idp); NewUpdate.Ord = NewUpdate.Ord + 1; db.SaveChanges(); } } db.SaveChanges(); var ListNews = db.tblConnectNews.Where(p => p.idNew == id).ToList(); for (int i = 0; i < ListNews.Count; i++) { db.tblConnectNews.Remove(ListNews[i]); db.SaveChanges(); } if (MutilMenu != null) { foreach (var idCates in MutilMenu) { tblConnectNew tblconnectnews = new tblConnectNew(); tblconnectnews.idCate = idCates; tblconnectnews.idNew = id; db.tblConnectNews.Add(tblconnectnews); db.SaveChanges(); } } } if (collection["btnSave"] != null) { Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã sửa tin thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/Newsad/Index?idCate=" + int.Parse(collection["drMenu"]))); } if (collection["btnSaveCreate"] != null) { Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm tin thành công, mời bạn thêm tin mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/Newsad/Create?id=" + +int.Parse(collection["drMenu"]) + "")); } #region [Updatehistory] Updatehistoty.UpdateHistory("Update News", Request.Cookies["Username"].Values["Username"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString()); #endregion } return(View(tblnews)); }