public ActionResult Create(string id)
{
if ((Request.Cookies["Username"] == null))
{
return(RedirectToAction("LoginIndex", "Login"));
}
if (ClsCheckRole.CheckQuyen(5, 1, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
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);
ViewBag.Ord = pro[0].Ord + 1;
if (Session["Thongbao"] != null && Session["Thongbao"] != "")
{
ViewBag.thongbao = Session["Thongbao"].ToString();
Session["Thongbao"] = "";
}
return(View());
}
else
{
return(Redirect("/Users/Erro"));
}
}
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)
{
Session["id"] = id.ToString();
Int32 ids = Int32.Parse(id.ToString());
tblNew tblnews = db.tblNews.Find(ids);
if (tblnews == null)
{
return(HttpNotFound());
}
var menuModel = db.tblGroupNews.Where(m => m.ParentID == null).OrderBy(m => m.id).ToList();
carlist.Clear();
string strReturns = "---";
foreach (var item in menuModel)
{
carlist.Add(new SelectListItem {
Text = item.Name, Value = item.id.ToString()
});
StringClass.DropDownListNews(item.id, carlist, strReturns);
strReturns = "---";
}
int idGroups = 0;
if (tblnews.idCate != null)
{
idGroups = int.Parse(tblnews.idCate.ToString());
}
ViewBag.drMenu = new SelectList(carlist, "Value", "Text", idGroups);
var menuModelProduct = db.tblGroupProducts.Where(m => m.ParentID == null).OrderBy(m => m.id).ToList();
carlistProduct.Clear();
string strReturn = "---";
foreach (var item in menuModelProduct)
{
carlistProduct.Add(new SelectListItem {
Text = item.Name, Value = item.id.ToString()
});
StringClass.DropDownListFor(item.id, carlistProduct, strReturn);
strReturn = "---";
}
var ListNews = db.tblConnectNews.Where(p => p.idNew == id).ToList();
List <int> mang = new List <int>();
for (int i = 0; i < ListNews.Count; i++)
{
mang.Add(int.Parse(ListNews[i].idCate.ToString()));
}
ViewBag.MutilMenu = new MultiSelectList(carlistProduct, "Value", "Text", mang);
return(View(tblnews));
}
else
{
return(Redirect("/Users/Erro"));
}
}
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)
{
Session["id"] = id.ToString();
Int32 ids = Int32.Parse(id.ToString());
TblNews TblNews = db.TblNews.Find(ids);
if (TblNews == null)
{
return(HttpNotFound());
}
var menuModel = db.TblGroupNews.Where(m => m.ParentId == null).OrderBy(m => m.Id).ToList();
carlist.Clear();
string strReturns = "---";
foreach (var item in menuModel)
{
carlist.Add(new SelectListItem {
Text = item.Name, Value = item.Id.ToString()
});
StringClass.DropDownListNews(item.Id, carlist, strReturns);
strReturns = "---";
}
int idGroups = 0;
if (TblNews.IdCate != null)
{
idGroups = int.Parse(TblNews.IdCate.ToString());
}
ViewBag.drMenu = new SelectList(carlist, "Value", "Text", idGroups);
var Manufacture = db.TblManufactures.Where(m => m.Active == true).OrderBy(m => m.Ord).ToList();
var listIdManu = db.TblConnectManuToNews.Where(p => p.IdNews == id).Select(p => p.IdManu).ToList();
var lstmanu = new List <SelectListItem>();
foreach (var item in Manufacture)
{
lstmanu.Add(new SelectListItem {
Text = item.Name, Value = item.Id.ToString()
});
}
ViewBag.mutilManu = new MultiSelectList(lstmanu, "Value", "Text", listIdManu);
return(View(TblNews));
}
else
{
return(Redirect("/Users/Erro"));
}
}
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 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 Index(int?page, string text, string idCate, string pageSizes, FormCollection collection)
{
if ((Request.Cookies["Username"] == null))
{
return(RedirectToAction("LoginIndex", "Login"));
}
if (ClsCheckRole.CheckQuyen(5, 0, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
#region [Load Menu]
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 = "---";
}
if (idCate != "")
{
ViewBag.drMenu = new SelectList(carlist, "Value", "Text", idCate);
ViewBag.idCate = idCate;
ViewBag.idMenu = idCate;
}
else
{
ViewBag.drMenu = carlist;
}
#endregion
if (Session["Thongbao"] != null && Session["Thongbao"] != "")
{
ViewBag.thongbao = Session["Thongbao"].ToString();
Session["Thongbao"] = "";
}
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));
tblNew tblnews = db.tblNews.Find(id);
int ord = int.Parse(tblnews.Ord.ToString());
int idCates = int.Parse(tblnews.idCate.ToString());
var kiemtra = db.tblNews.Where(p => p.Ord > ord && p.idCate == idCates).ToList();
if (kiemtra.Count > 0)
{
var ListNews = db.tblNews.Where(p => p.Ord > ord && p.idCate == idCates).ToList();
for (int i = 0; i < ListNews.Count; i++)
{
int idp = int.Parse(ListNews[i].id.ToString());
var NewsUpdate = db.tblNews.Find(idp);
NewsUpdate.Ord = NewsUpdate.Ord - 1;
db.SaveChanges();
}
}
db.tblNews.Remove(tblnews);
db.SaveChanges();
clsSitemap.DeteleSitemap(id.ToString(), "News");
}
else
{
return(Redirect("/Users/Erro"));
}
}
}
}
//dsd
}
return(View());
}
else
{
return(Redirect("/Users/Erro"));
}
}
public PartialViewResult PartialNews(int?page, string text, string idCate, string pageSizes)
{
var ListNews = db.tblNews.OrderByDescending(p => p.DateCreate).ToList();
int pageSize = 20;
var pageNumber = (page ?? 1);
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;
if (Request.IsAjaxRequest())
{
int idCatelogy;
if (pageSizes != null)
{
ViewBag.pageSizes = pageSizes;
pageSize = int.Parse(pageSizes.ToString());
ViewBag.chuoicout = "<span style='color: #A52A2A;'>" + pageSize + "</span> / <span style='color: #333;'>" + ListNews.Count.ToString() + "</span>";
return(PartialView("PartialNews", ListNews.ToPagedList(pageNumber, pageSize)));
}
if (text != null && text != "")
{
ListNews = db.tblNews.Where(p => p.Name.ToUpper().Contains(text.ToUpper()) && p.Active == true).OrderByDescending(p => p.DateCreate).ToList();
ViewBag.chuoicout = "<span style='color: #A52A2A;'>" + ListNews.Count + "</span> ";
return(PartialView("PartialNews", ListNews.ToPagedList(pageNumber, pageSize)));
}
if (idCate != null && idCate != "")
{
idCatelogy = int.Parse(idCate);
ListNews = db.tblNews.Where(p => p.idCate == idCatelogy).OrderByDescending(p => p.DateCreate).ToList();
ViewBag.chuoicout = "<span style='color: #A52A2A;'>" + ListNews.Count + "</span> ";
ViewBag.idMenu = idCate;
return(PartialView("PartialNews", ListNews.ToPagedList(pageNumber, pageSize)));
}
if (text != null && text != "" && idCate != null && idCate != "")
{
idCatelogy = int.Parse(idCate);
ViewBag.idMenu = idCate;
ViewBag.chuoicout = "<span style='color: #A52A2A;'>" + ListNews.Count + "</span> ";
ListNews = db.tblNews.Where(p => p.Name.ToUpper().Contains(text.ToUpper()) && p.idCate == (int.Parse(idCate)) && p.Active == true).OrderByDescending(p => p.Ord).ToList();
return(PartialView("PartialNews", ListNews));
}
else
{
ListNews = db.tblNews.OrderByDescending(p => p.Ord).ToList();
}
}
if (pageSizes != null)
{
ViewBag.pageSizes = pageSizes;
pageSize = int.Parse(pageSizes.ToString());
}
ViewBag.chuoicout = "<span style='color: #A52A2A;'>" + pageSize + "</span> / <span style='color: #333;'>" + ListNews.Count.ToString() + "</span>";
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 != null)
{
int idcates = int.Parse(idCate);
ListNews = db.tblNews.Where(p => p.idCate == idcates && p.Active == true).OrderByDescending(p => p.DateCreate).ToList();
ViewBag.idMenu = idCate;
ViewBag.idcate = idCate;
ViewBag.ddlMenu = carlist;
return(PartialView(ListNews.ToPagedList(pageNumber, pageSize)));
}
else
{
ViewBag.ddlMenu = carlist;
}
return(PartialView(ListNews.ToPagedList(pageNumber, pageSize)));
}
public ActionResult Create(string id)
{
if ((Request.Cookies["Username"] == null))
{
return(RedirectToAction("LoginIndex", "Login"));
}
if (Session["Thongbao"] != null && Session["Thongbao"] != "")
{
ViewBag.thongbao = Session["Thongbao"].ToString();
Session["Thongbao"] = "";
}
if (ClsCheckRole.CheckQuyen(5, 1, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
var menuModel = db.TblGroupNews.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.DropDownListNews(item.Id, carlist, strReturn);
strReturn = "---";
}
if (id != "")
{
int ids = int.Parse(id);
var pro = db.TblNews.Where(p => p.IdCate == ids).OrderByDescending(p => p.Ord).Take(1).ToList();
ViewBag.drMenu = new SelectList(carlist, "Value", "Text", id);
int idcate = int.Parse(id.ToString());
if (pro.Count > 0)
{
ViewBag.Ord = pro[0].Ord + 1;
}
else
{
ViewBag.Ord = "1";
}
}
else
{
ViewBag.drMenu = carlist;
var pro = db.TblNews.OrderByDescending(p => p.Ord).Take(1).ToList();
if (pro.Count > 0)
{
ViewBag.Ord = pro[0].Ord + 1;
}
}
var Manufacture = db.TblManufactures.Where(m => m.Active == true).OrderBy(m => m.Ord).ToList();
var lstmanu = new List <SelectListItem>();
foreach (var item in Manufacture)
{
lstmanu.Add(new SelectListItem {
Text = item.Name, Value = item.Id.ToString()
});
}
ViewBag.mutilManu = new SelectList(lstmanu, "Value", "Text");
return(View());
}
else
{
return(Redirect("/Users/Erro"));
}
}
