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));
}
}
