public ActionResult Edit(Mcategory mcategory)
{
if (ModelState.IsValid)
{
string slug = Mystring.ToSlug(mcategory.name.ToString());
mcategory.slug = slug;
mcategory.updated_at = DateTime.Now;
mcategory.updated_by = int.Parse(Session["Admin_id"].ToString());
db.Entry(mcategory).State = EntityState.Modified;
try
{
var thisLink = db.Link.Where(m => m.tableId == 1 && m.parentId == mcategory.ID).First();
link tt_link = db.Link.Find(thisLink.ID);
tt_link.slug = slug;
tt_link.tableId = 1;
tt_link.parentId = mcategory.ID;
db.Entry(tt_link).State = EntityState.Modified;
}
catch (Exception)
{
//no runing
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
Message.set_flash("Sửa thất bại", "success");
return(View(mcategory));
}
public ActionResult DeleteConfirmed(int id)
{
Mcategory mcategory = db.Categories.Find(id);
db.Categories.Remove(mcategory);
db.SaveChanges();
return(RedirectToAction("Trash"));
}
public ActionResult Retrash(int id)
{
Mcategory mcategory = db.Categories.Find(id);
mcategory.Status = 2;
db.Entry(mcategory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Trash", "Category"));
}
public ActionResult deleteTrash(int id)
{
Mcategory mcategory = db.Categorys.Find(id);
db.Categorys.Remove(mcategory);
db.SaveChanges();
Message.set_flash("Đã xóa vĩnh viễn 1 sản phẩm", "success");
return(RedirectToAction("trash"));
}
public ActionResult Retrash(int id)
{
Mcategory mcategory = db.Categorys.Find(id);
mcategory.status = 2;
mcategory.updated_at = DateTime.Now;
mcategory.updated_by = int.Parse(Session["Admin_id"].ToString());
db.Entry(mcategory).State = EntityState.Modified;
db.SaveChanges();
Message.set_flash("khôi phục thành công", "success");
return(RedirectToAction("trash"));
}
//status
public ActionResult Status(int id)
{
Mcategory mcategory = db.Categorys.Find(id);
mcategory.status = (mcategory.status == 1) ? 2 : 1;
mcategory.updated_at = DateTime.Now;
mcategory.updated_by = int.Parse(Session["Admin_id"].ToString());
db.Entry(mcategory).State = EntityState.Modified;
db.SaveChanges();
Message.set_flash("Thay đổi trang thái thành công", "success");
return(RedirectToAction("Index"));
}
// GET: Admin/Category/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Mcategory mcategory = db.Categories.Find(id);
if (mcategory == null)
{
return(HttpNotFound());
}
return(View(mcategory));
}
//code tu go
public string ShowStatus(int id)
{
string strStatus = "";
Mcategory mcategory = db.Categories.Find(id);
if (mcategory.Status == 1)
{
strStatus = "<span class='btn btn-info btn-sm' ><i class='fas fa-toggle-on'></i>TT</span>";
}
else
{
strStatus = "<span class='btn btn-danger btn-sm' ><i class=' fas fa-toggle-off'></i>TT</span>";
}
return(strStatus);
}
// GET: Admin/Category/Edit/5
public ActionResult Edit(int?id)
{
ViewBag.listCate = db.Categorys.Where(m => m.status != 0).ToList();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Mcategory mcategory = db.Categorys.Find(id);
if (mcategory == null)
{
return(HttpNotFound());
}
return(View(mcategory));
}
// GET: Admin/Category/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Mcategory mcategory = db.Categories.Find(id);
if (mcategory == null)
{
return(HttpNotFound());
}
ViewBag.ListCat = new SelectList(db.Categories, "id", "Name");
return(View(mcategory));
}
public ActionResult Edit(Mcategory mcategory)
{
if (ModelState.IsValid)
{
string slug = Mystring.ToSlug(mcategory.name.ToString());
mcategory.slug = slug;
mcategory.updated_at = DateTime.Now;
mcategory.updated_by = int.Parse(Session["Admin_id"].ToString());
db.Entry(mcategory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
Message.set_flash("Sửa thất bại", "success");
return(View(mcategory));
}
public ActionResult status(int id)
{
Mcategory mcategory = db.Categories.Find(id);
if (mcategory.Status == 1)
{
mcategory.Status = 2;
}
else
{
mcategory.Status = 1;
}
db.Entry(mcategory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(Mcategory mcategory)
{
int user_id = (!Session["user_id"].Equals("")) ? Convert.ToInt32(Session["user_id"].ToString()) : 1;
XString mystr = new XString();
if (ModelState.IsValid)
{
mcategory.Slug = mystr.ToAscii(mcategory.Name);
mcategory.Created_at = DateTime.Now;
mcategory.Created_by = user_id;
mcategory.Updated_at = DateTime.Now;
mcategory.Updated_by = user_id;
db.Entry(mcategory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mcategory));
}
private ActionResult productOfCategory(string slug, int?page)
{
if (page == null)
{
page = 1;
}
int pageSize = 8;
int pageNumber = (page ?? 1);
Mcategory single = db.Categorys.Where(m => m.status == 1 && m.slug == slug).First();
ViewBag.url = single.slug + "";
ViewBag.blace = single.name;
ViewBag.category = db.Categorys.Where(m => m.status == 1).ToList();
var list = db.Products
.Where(m => m.status == 1 && m.catid == single.ID)
.ToList();
return(View("allProduct", list.ToPagedList(pageNumber, pageSize)));
}
public ActionResult deleteTrash(int id)
{
Mcategory mcategory = db.Categorys.Find(id);
try
{
var thisLink = db.Link.Where(m => m.tableId == 1 && m.parentId == mcategory.ID).First();
link tt_link1 = db.Link.Find(thisLink.ID);
db.Link.Remove(tt_link1);
}
catch (Exception)
{
//no runing
}
db.Categorys.Remove(mcategory);
db.SaveChanges();
Message.set_flash("Đã xóa vĩnh viễn 1 sản phẩm", "success");
return(RedirectToAction("trash"));
}
public ActionResult Create(FormCollection collection, Mcategory model)
{
int user_id = (!Session["user_id"].Equals("")) ? Convert.ToInt32(Session["user_id"].ToString()) : 1;
XString mystr = new XString();
if (ModelState.IsValid)
{
model.ParentId = Convert.ToInt32(collection["Listcat"]);
model.Slug = mystr.ToAscii(model.Name);
model.Created_at = DateTime.Now;
model.Created_by = user_id;
model.Updated_at = DateTime.Now;
model.Updated_by = user_id;
db.Categories.Add(model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Listcat = new SelectList(db.Categories, "id", "Name");
return(View(model));
}
public ActionResult Create(Mcategory mcategory)
{
if (ModelState.IsValid)
{
//category
string slug = Mystring.ToSlug(mcategory.name.ToString());
if (db.Categorys.Where(m => m.slug == slug).Count() > 0)
{
Message.set_flash("Loại sản phẩm đã tồn tại trong bảng Category", "danger");
return(View(mcategory));
}
//topic
if (db.Products.Where(m => m.slug == slug).Count() > 0)
{
Message.set_flash("Loại sản phẩm đã tồn tại trong bảng Product", "danger");
return(View(mcategory));
}
mcategory.slug = slug;
mcategory.created_at = DateTime.Now;
mcategory.updated_at = DateTime.Now;
mcategory.created_by = int.Parse(Session["Admin_id"].ToString());
mcategory.updated_by = int.Parse(Session["Admin_id"].ToString());
db.Categorys.Add(mcategory);
db.SaveChanges();
//create Link
link tt_link = new link();
tt_link.slug = slug;
tt_link.tableId = 2;
tt_link.type = "category";
tt_link.parentId = mcategory.ID;
db.Link.Add(tt_link);
db.SaveChanges();
Message.set_flash("Thêm thành công", "success");
return(RedirectToAction("index"));
}
Message.set_flash("Thêm Thất Bại", "danger");
ViewBag.listCate = db.Categorys.Where(m => m.status != 0).ToList();
return(View(mcategory));
}
public ActionResult Index(FormCollection data)
{
if (!string.IsNullOrEmpty(data["ADDPAGE"]))
{
var itemcatt = data["itempage"];
if (itemcatt == null)
{
Message.set_flash("Bạn chưa chọn Mà", "danger");
return(RedirectToAction("index"));
}
var arrcat = itemcatt.Split(',');
foreach (var rcat in arrcat)
{
int id = int.Parse(rcat);
Mpost post = db.posts.Find(id);
Mmenu menu = new Mmenu();
menu.name = post.title;
menu.link = post.slug;
menu.position = data["position"];
menu.type = "menu";
menu.tableid = 2;
menu.parentid = 0;
menu.orders = 1;
menu.created_at = DateTime.Now;
menu.updated_at = DateTime.Now;
menu.created_by = int.Parse(Session["Admin_id"].ToString());
menu.updated_by = int.Parse(Session["Admin_id"].ToString());
menu.status = 1;
db.Menus.Add(menu);
db.SaveChanges();
Message.set_flash("Thêm thành công", "success");
}
}
if (!string.IsNullOrEmpty(data["THEMCATE"]))
{
var itemcatt = data["itemCat"];
if (itemcatt == null)
{
Message.set_flash("Bạn chưa chọn Mà", "danger");
return(RedirectToAction("index"));
}
var arrcat = itemcatt.Split(',');
foreach (var rcat in arrcat)
{
int id = int.Parse(rcat);
Mcategory mcategory = db.Categorys.Find(id);
Mmenu menu = new Mmenu();
menu.name = mcategory.name;
menu.link = "loaiSP/" + mcategory.slug;
menu.position = data["position"];
menu.type = "menu";
menu.tableid = 2;
menu.parentid = 0;
menu.orders = 1;
menu.created_at = DateTime.Now;
menu.updated_at = DateTime.Now;
menu.created_by = int.Parse(Session["Admin_id"].ToString());
menu.updated_by = int.Parse(Session["Admin_id"].ToString());
menu.status = 1;
db.Menus.Add(menu);
db.SaveChanges();
Message.set_flash("Thêm thành công", "success");
}
}
if (!string.IsNullOrEmpty(data["THEMTOPIC"]))
{
var itemcatt = data["itemtopic"];
if (itemcatt == null)
{
Message.set_flash("Bạn chưa chọn", "danger");
return(RedirectToAction("index"));
}
var arrcat = itemcatt.Split(',');
foreach (var rcat in arrcat)
{
int id = int.Parse(rcat);
Mtopic mtopic = db.topics.Find(id);
Mmenu menu = new Mmenu();
menu.name = mtopic.name;
menu.link = mtopic.slug;
menu.position = data["position"];
menu.type = "menu";
menu.tableid = 2;
menu.parentid = 0;
menu.orders = 1;
menu.created_at = DateTime.Now;
menu.updated_at = DateTime.Now;
menu.created_by = int.Parse(Session["Admin_id"].ToString());
menu.updated_by = int.Parse(Session["Admin_id"].ToString());
menu.status = 1;
db.Menus.Add(menu);
db.SaveChanges();
Message.set_flash("Thêm thành công", "success");
}
}
if (!string.IsNullOrEmpty(data["THEMCUSS"]))
{
Mmenu menu = new Mmenu();
menu.position = data["position"];
menu.name = data["name"];
menu.link = data["link"];
menu.type = "menu";
menu.tableid = 2;
menu.parentid = 0;
menu.orders = 1;
menu.created_at = DateTime.Now;
menu.updated_at = DateTime.Now;
menu.created_by = int.Parse(Session["Admin_id"].ToString());
menu.updated_by = int.Parse(Session["Admin_id"].ToString());
menu.status = 1;
db.Menus.Add(menu);
db.SaveChanges();
Message.set_flash("Thêm thành công", "success");
}
ViewBag.listCate = db.Categorys.Where(m => m.status == 1).ToList();
ViewBag.listTopic = db.topics.Where(m => m.status == 1).ToList();
ViewBag.listPage = db.posts.Where(m => m.status == 1 && m.type == "post").ToList();
var list = db.Menus.Where(m => m.status > 0).ToList();
return(View(list));
}