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