public ActionResult Create(tMessageCode mescode, tForumTitle title, tForumMessage message) { if (Request.Cookies["account"] == null) { return(RedirectToAction("Index", "ForumHome")); } string epid = Request.Cookies["account"].Value; var EP_ID = db.tEmployee.Where(p => p.fEp_Code == epid).Single().fEp_ID; db.tMessageCode.Add(mescode); db.SaveChanges(); title.fMC_ID = db.tMessageCode.AsEnumerable().Last().fMC_ID; title.fEp_ID = EP_ID; title.fFT_Date = DateTime.Now; message.fEp_ID = EP_ID; message.fFM_Date = DateTime.Now; message.fMC_ID = db.tMessageCode.AsEnumerable().Last().fMC_ID; db.tForumTitle.Add(title); db.tForumMessage.Add(message); db.SaveChanges(); return(RedirectToAction("Index", "ForumHome")); }
public ActionResult EditMessage(tForumMessage message, int id = 10) { var MC_ID = db.tForumMessage.Where(p => p.fFM_ID == id).Single().fMC_ID; tForumMessage updateMessage = db.tForumMessage.Find(id); updateMessage.fFM_Content = message.fFM_Content; updateMessage.fFM_Date = DateTime.Now; db.Entry(updateMessage).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("EditDetail", "ForumMyself", new { id = MC_ID })); }
//聊天室系統 public ActionResult Comment(tForumMessage _Comment, int id, string _content = "") { if (_content != "") { string epCode = Request.Cookies["account"].Value; int epID = db.tEmployee.Where(a => a.fEp_Code == epCode).Single().fEp_ID; _Comment.fFM_Date = DateTime.Now; _Comment.fFM_Content = _content; _Comment.fMC_ID = id; _Comment.fEp_ID = epID; db.tForumMessage.Add(_Comment); db.SaveChanges(); } return(PartialView(db.tForumMessage.Where(t => t.fMC_ID == id).OrderBy(t => t.fFM_Date).ToList())); }
public ActionResult PhotoMessage(int id, string content = "") { if (content != "") { string epCode = Request.Cookies["account"].Value; int epID = db.tEmployee.Where(a => a.fEp_Code == epCode).Single().fEp_ID; tForumMessage newMess = new tForumMessage(); newMess.fFM_Date = DateTime.Now; newMess.fMC_ID = id; newMess.fFM_Content = content; newMess.fEp_ID = epID; db.tForumMessage.Add(newMess); db.SaveChanges(); } return(PartialView(db.tForumMessage.Where(a => a.fMC_ID == id).OrderBy(a => a.fFM_Date).ToList())); }
//刪除文章 public ActionResult Delete(int?id) { var FTid = db.tForumTitle.Where(p => p.fMC_ID == id).Single().fFT_ID; var FMid = db.tForumMessage.Where(p => p.fMC_ID == id).Single().fFM_ID; tMessageCode deleCode = db.tMessageCode.Find(id); tForumTitle deleTitle = db.tForumTitle.Find(FTid); tForumMessage deleMessage = db.tForumMessage.Find(FMid); db.tMessageCode.Remove(deleCode); db.tForumTitle.Remove(deleTitle); db.tForumMessage.Remove(deleMessage); db.SaveChanges(); return(RedirectToAction("Index", "ForumMyself")); }
public ActionResult Message(tForumMessage message, int id = 10) { if (Request.Cookies["account"] == null) { return(RedirectToAction("Index", "ForumHome")); } string epid = Request.Cookies["account"].Value; var EP_ID = db.tEmployee.Where(p => p.fEp_Code == epid).Single().fEp_ID; message.fEp_ID = EP_ID; message.fFM_Date = DateTime.Now; message.fMC_ID = id; db.tForumMessage.Add(message); db.SaveChanges(); return(RedirectToAction("Detail", "ForumHome", new { id = id })); }
public ActionResult partial_twitter(tForumMessage message, int?id = 1) { var MC_ID = db.tForumMessage.Where(p => p.fFM_ID == id).Single().fMC_ID; if (Request.Cookies["account"] == null) { return(RedirectToAction("Detail", "ForumHome", new { id = MC_ID })); } string epid = Request.Cookies["account"].Value; var EP_ID = db.tEmployee.Where(p => p.fEp_Code == epid).Single().fEp_ID; message.fEp_ID = EP_ID; message.fFM_Dad = id; message.fFM_Date = DateTime.Now; message.fMC_ID = MC_ID; db.tForumMessage.Add(message); db.SaveChanges(); //return PartialView(); return(RedirectToAction("Detail", "ForumHome", new { id = MC_ID })); }