public ActionResult Edit(FormCollection collection, int id) { string title = collection["title"].ToString(); string summary = collection["summary"].ToString(); string content = collection["content"].ToString(); DateTime dateposted = DateTime.Parse(collection["dateposted"].ToString()); int authorid = int.Parse(collection["authorid"].ToString()); int posterid = int.Parse(collection["posterid"].ToString()); string avatar = collection["avatar"].ToString(); int categoryid = int.Parse(collection["categoryid"].ToString()); string trangthai = collection["trangthai"].ToString(); using (Web_NEWS_MVCEntities db = new Web_NEWS_MVCEntities()) { News news = db.News.SingleOrDefault(n => n.Id == id); news.Title = title; news.Summary = summary; news.Content = content; news.Dateposted = dateposted; news.AuthorId = authorid; news.PosterId = posterid; news.Avatar = avatar; news.CategoryId = categoryid; news.TrangThai = trangthai; ViewBag.PosterId = new SelectList(db.Accounts.ToList(), "Id", "Fullname", news.PosterId); ViewBag.AuthorId = new SelectList(db.Authors.ToList(), "Id", "Name", news.AuthorId); ViewBag.CategoryId = new SelectList(db.Categories.Where(n => !(n.Url == "" && n.ParentId == null)).ToList(), "Id", "Name", news.CategoryId); db.SaveChanges(); return(RedirectToAction("Create")); } }
public ActionResult Signup(FormCollection collection) { string fullname = collection["fullname"].ToString(); string email = collection["email"].ToString(); string password = collection["password"].ToString(); string confpassword = collection["confpassword"].ToString(); string avatar = collection["avatar"].ToString(); string trangthai = "Hoạt động"; string quyen = "User"; using (Web_NEWS_MVCEntities db = new Web_NEWS_MVCEntities()) { Account acc = new Account(); var checkEmail = db.Accounts.SingleOrDefault(n => n.Email.Equals(email)); if (checkEmail == null) { acc.Fullname = fullname; acc.Email = email; acc.Password = password; acc.Confirmpassword = confpassword; acc.Avatar = avatar; acc.TrangThai = trangthai; acc.Quyen = quyen; db.Accounts.Add(acc); db.SaveChanges(); ViewBag.tbDangKy = acc.Fullname + " đăng ký thành công!"; } else { ViewBag.tbDangKyLoi = email + " đã tồn tại!"; } return(View()); } }
public ActionResult Edit(FormCollection collection, int id) { using (Web_NEWS_MVCEntities db = new Web_NEWS_MVCEntities()) { string nameCategory = collection["namecategory"].ToString(); string urlCategory = collection["urlcategory"].ToString(); string parentIdCategory = collection["ParentId"].ToString(); Category cate = db.Categories.SingleOrDefault(n => n.Id == id); ViewBag.ParentId = new SelectList(db.Categories.Where(n => n.ParentId == null), "Id", "Name", cate.ParentId).ToList(); cate.Name = nameCategory; if (parentIdCategory == "NULL") { cate.ParentId = null; } else { cate.ParentId = Convert.ToInt32(parentIdCategory); } cate.Url = urlCategory; db.SaveChanges(); return(RedirectToAction("Create")); } }
public ActionResult Detail(int id = 0) { News news = db.News.SingleOrDefault(n => n.Id == id); news.View = news.View + 1; db.SaveChanges(); if (news == null) { Response.StatusCode = 404; return(null); } return(View(news)); }
public ActionResult Delete(int id) { using (Web_NEWS_MVCEntities db = new Web_NEWS_MVCEntities()) { News news = db.News.SingleOrDefault(n => n.Id == id); db.News.Remove(news); db.SaveChanges(); return(RedirectToAction("Create")); } }
public ActionResult Edit(FormCollection collection, int id) { using (Web_NEWS_MVCEntities db = new Web_NEWS_MVCEntities()) { string authorName = collection["authorname"].ToString(); string authorAddress = collection["authoraddress"].ToString(); Author aut = db.Authors.SingleOrDefault(n => n.Id == id); aut.Name = authorName; aut.Address = authorAddress; db.SaveChanges(); return(RedirectToAction("Create")); } }
public ActionResult Delete(int id) { using (Web_NEWS_MVCEntities db = new Web_NEWS_MVCEntities()) { //lay doi tuong can xoa Author aut = db.Authors.SingleOrDefault(n => n.Id == id); // thuc hien xoa doi tuong db.Authors.Remove(aut); //Thay doi trong csdl db.SaveChanges(); return(RedirectToAction("Create")); } }
// POST: //Account/DelAccount/ public int DelAccount(int id) { using (Web_NEWS_MVCEntities db = new Web_NEWS_MVCEntities()) { Account delaccount = db.Accounts.SingleOrDefault(n => n.Id == id); if (delaccount != null) { db.Accounts.Remove(delaccount); db.SaveChanges(); return(id); } else { return(-1); } } }
public string ChangeImage(int id, string avatar) { using (Web_NEWS_MVCEntities db = new Web_NEWS_MVCEntities()) { if (id == 0) { return("Mã không tồn tại"); } News news = db.News.Find(id); if (news == null) { return("Mã không tồn tại"); } news.Avatar = avatar; db.SaveChanges(); return(""); } }
public ActionResult Create(FormCollection collection) { using (Web_NEWS_MVCEntities db = new Web_NEWS_MVCEntities()) { string authorName = collection["authorname"].ToString(); string authorAddress = collection["authoraddress"].ToString(); Author aut = new Author(); aut.Name = authorName; aut.Address = authorAddress; db.Authors.Add(aut); db.SaveChanges(); List <Author> lstAuthor = db.Authors.ToList(); return(View(lstAuthor)); } }
public ActionResult Create(FormCollection collection, int?page) { int pageSize = 3; int pageNumber = (page ?? 1); string title = collection["title"].ToString(); string summary = collection["summary"].ToString(); string content = collection["content"].ToString(); DateTime dateposted = DateTime.Parse(collection["dateposted"].ToString()); int authorid = int.Parse(collection["authorid"].ToString()); int posterid = int.Parse(collection["posterid"].ToString()); string avatar = collection["avatar"].ToString(); string trangthai = collection["trangthai"].ToString(); int view = 0; int categoryid = int.Parse(collection["categoryid"].ToString()); using (Web_NEWS_MVCEntities db = new Web_NEWS_MVCEntities()) { ViewBag.PosterId = new SelectList(db.Accounts.ToList(), "Id", "Fullname"); ViewBag.AuthorId = new SelectList(db.Authors.ToList(), "Id", "Name"); ViewBag.CategoryId = new SelectList(db.Categories.Where(n => !(n.Url == "" && n.ParentId == null)).ToList().ToList(), "Id", "Name"); News news = new News(); news.Title = title; news.Summary = summary; news.Content = content; news.Dateposted = dateposted; news.AuthorId = authorid; news.PosterId = posterid; news.Avatar = avatar; news.CategoryId = categoryid; news.TrangThai = trangthai; news.View = view; db.News.Add(news); db.SaveChanges(); return(View(db.News.ToList().ToPagedList(pageNumber, pageSize))); } }
public ActionResult Create(FormCollection collection) { using (Web_NEWS_MVCEntities db = new Web_NEWS_MVCEntities()) { string nameCategory = collection["namecategory"].ToString(); string urlCategory = collection["urlcategory"].ToString(); string parentIdCategory = collection["ParentId"].ToString(); Category cate = new Category(); cate.Name = nameCategory; if (urlCategory == null) { cate.Url = null; } else { cate.Url = urlCategory; } if (parentIdCategory == "NULL") { cate.ParentId = null; } else { cate.ParentId = Convert.ToInt32(parentIdCategory); } //Them doi tuong vao csdl db.Categories.Add(cate); //Thuc hien ghi vao csdl db.SaveChanges(); ViewBag.ParentId = new SelectList(db.Categories.Where(n => n.ParentId == null), "Id", "Name").ToList(); //Lay danh sach chuyen muc trong csdl tra ve view List <Category> lstCategory = db.Categories.ToList(); return(View(lstCategory)); } }
public ActionResult Delete(int id) { using (Web_NEWS_MVCEntities db = new Web_NEWS_MVCEntities()) { try { //Lấy đối tượng cần xóa Category cate = db.Categories.SingleOrDefault(x => x.Id == id); //Thực hiện xóa đối tượng db.Categories.Remove(cate); //Thực hiện thay đổi trong csdl db.SaveChanges(); //Lay danh sach chuyen muc trong csdl tra ve view return(RedirectToAction("Create")); } catch { return(RedirectToAction("Create")); } } }