IEnumerable <TrueAnnouncement> GetAllAnnouncements() { using (var db = new TrueDBModel()) { return(db.TrueAnnouncements.Include(a => a.Author).ToList()); } }
public ActionResult Delete(int id) { try { using (TrueDBModel db = new TrueDBModel()) { TrueAnnouncement anno = db.TrueAnnouncements.Where(x => x.AnnoID == id).FirstOrDefault <TrueAnnouncement>(); db.TrueAnnouncements.Remove(anno); db.SaveChanges(); } return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllAnnouncements()), message = "Delete Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult DeleteAuthor(int id) { try { using (var db = new TrueDBModel()) { var author = db.Authors.Where(x => x.AuthorID == id).FirstOrDefault <Author>(); db.Authors.Remove(author); db.SaveChanges(); } return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAllAuthors", GetAllAuthors()), message = "Delete Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddorEditAuthors(Author author) { try { using (var db = new TrueDBModel()) { if (author.AuthorID == 0) { db.Authors.Add(author); db.SaveChanges(); } else { db.Entry(author).State = EntityState.Modified; db.SaveChanges(); } } //return RedirectToAction("ViewAllAuthors"); return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAllAuthors", GetAllAuthors()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Authorize(Author userModel) { using (var db = new TrueDBModel()) { var userDetails = db.Authors.Where(x => x.AuthorCode == userModel.AuthorCode).FirstOrDefault(); // Incorrect input if (userDetails == null) { userModel.LoginErrorMessage = "Wrong Admin Code!"; return(View("Login", userModel)); } // Correct input Session["userID"] = userDetails.AuthorID; Session["userCode"] = userDetails.AuthorCode; Session["userLevel"] = userDetails.AuthorLevel; Session["userName"] = userDetails.AuthorFLName; if (userDetails.Remember) { Response.Cookies["userCode"].Value = userDetails.AuthorCode; Response.Cookies["userCode"].Expires = DateTime.Now.AddMinutes(1); } else { Response.Cookies["userCode"].Expires = DateTime.Now.AddMinutes(-1); } return(RedirectToAction("Index", "Announce")); } }
public ActionResult AddorEditAuthors(int id = 0) { var author = new Author(); if (id != 0) { using (var db = new TrueDBModel()) { author = db.Authors.Where(i => i.AuthorID == id).FirstOrDefault <Author>(); } } return(View(author)); }
public ActionResult AddOrEdit(int id = 0) { var anno = new TrueAnnouncement(); if (id != 0) { using (TrueDBModel db = new TrueDBModel()) { anno = db.TrueAnnouncements.Where(x => x.AnnoID == id).FirstOrDefault <TrueAnnouncement>(); } } return(View(anno)); }
public ActionResult AddOrEdit(TrueAnnouncement anno) { try { if (anno.ImageUpload != null) { string fileName = Path.GetFileNameWithoutExtension(anno.ImageUpload.FileName); string extension = Path.GetExtension(anno.ImageUpload.FileName); fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; //确保每个图片文件名唯一,避免上传相同文件 anno.ImgPath = "App_Files/Images/" + fileName; anno.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/App_Files/Images/"), fileName)); } using (TrueDBModel db = new TrueDBModel()) { if (anno.AnnoID == 0) { db.TrueAnnouncements.Add(anno); db.SaveChanges(); } else { db.Entry(anno).State = EntityState.Modified; db.SaveChanges(); } } //return RedirectToAction("ViewAll"); return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllAnnouncements()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }