public IHttpActionResult PostNewComment(tComment comment)
{
retryId:
string commentID = new Utilities().GenerateCoupon(5);
if (db.tComments.Any(a => a.CommentId == commentID))
{
goto retryId;
}
comment.DateCreated = DateTime.Now;
comment.DateUpdated = DateTime.Now;
comment.CommentId = commentID;
var newComment = db.tComments.Add(comment);
db.SaveChanges();
var newCommentObj = db.tComments.Where(w => w.recNo == newComment.recNo).Select(ss => new
{
ss.CommentId,
ss.DateCreated,
ss.DateUpdated,
ss.Comment,
ss.PostId,
ss.UserId,
Name = db.tBusinessEntities.Any(b => b.UserId == ss.UserId) ? db.tBusinessEntities.FirstOrDefault(f => f.UserId == ss.UserId).BusinessEntityName : db.tPersonInfoes.Where(p => p.UserId == ss.UserId).Select(sss => new { Name = sss.Firstname + " " + (sss.Middlename != null ? sss.Middlename.Substring(0, 1) + ". " : "") + sss.Lastname }).FirstOrDefault().Name,
UserType = db.tBusinessEntities.Any(b => b.UserId == ss.UserId) ? 1 : 0
}).FirstOrDefault();
context.Clients.All.newComment(newCommentObj);
return(Json(newComment));
}
public ActionResult DeleteConfirmed(int id)
{
tComment tcomment = db.tComment.Find(id);
db.tComment.Remove(tcomment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /c/Details/5
public ActionResult Details(int id = 0)
{
tComment tcomment = db.tComment.Find(id);
if (tcomment == null)
{
return(HttpNotFound());
}
return(View(tcomment));
}
public ActionResult Edit(tComment tcomment)
{
if (ModelState.IsValid)
{
db.Entry(tcomment).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.news_ids = new SelectList(db.tNews, "news_id", "title", tcomment.news_ids);
return(View(tcomment));
}
public ActionResult Edit(int id = 0)
{
tComment tcomment = db.tComment.Find(id);
if (tcomment == null)
{
return(HttpNotFound());
}
ViewBag.news_ids = new SelectList(db.tNews, "news_id", "title", tcomment.news_ids);
return(View(tcomment));
}
public PartialViewResult comm(int id)
{
tComment c = new tComment();
c.news_ids = id;
//db.tComment.Add(tcomment);
//db.SaveChanges();
//}
return(PartialView("_comm", c));
// return View(quess.ToPagedList(pageNumber, pageSize));
}
/// <summary>
/// Saves the new comment.
/// </summary>
/// <param name="commentDto">The comment dto.</param>
/// <returns></returns>
public CommentDTO SaveNewComment(CommentDTO commentDto)
{
commentDto.CreatedAt = DateTime.Now;
tComment comment = Mapper.Map <tComment>(commentDto);
using (DMSDataBaseEntities context = new DMSDataBaseEntities())
{
context.tComments.Add(comment);
context.SaveChanges();
}
return(commentDto);
}
//<---------------------------------新增留言---------------------------->
public JsonResult CreateComment(int MemberID, string Main, int ArticleID)
{
tComment list = new tComment()
{
MemberID = MemberID,
Main = Main,
ArticleID = ArticleID,
UpTime = DateTime.Now,
};
tc.create(list);
return(Json(tc.getAll().LastOrDefault(t => t.No > 0).No, JsonRequestBehavior.AllowGet));
}
public ActionResult r回覆(C回覆 y, tComment p)
{
send(y);
//ViewBag.kk = "傳送成功";
dbJoutaEntities db = new dbJoutaEntities();
tComment A = db.tComment.FirstOrDefault(m => m.fID == p.fID);
if (A != null)
{
A.f意見狀態 = "已回覆";
db.SaveChanges();
}
return(RedirectToAction("List"));
}
public ActionResult r回覆(int?id)
{
if (id == null)
{
RedirectToAction("List");
}
dbJoutaEntities db = new dbJoutaEntities();
tComment x = new tComment();
x = db.tComment.FirstOrDefault(m => m.fID == id);
return(View(x));
}
public ActionResult Create(tComment tcomment, int?id)
{
if (ModelState.IsValid)
{
string ip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"] ?? Request.ServerVariables["REMOTE_ADDR"];
tcomment.http_posted = ip;
tcomment.addedcomment = DateTime.Now;
db.tComment.Add(tcomment);
db.SaveChanges();
return(RedirectToAction("post", "n", new { id = tcomment.news_ids }));
}
ViewBag.news_ids = new SelectList(db.tNews, "news_id", "title", tcomment.news_ids == id);
return(View(tcomment));
}
public ActionResult d刪除(int?id)
{
if (id == null)
{
RedirectToAction("List");
}
tComment x = new tComment();
dbJoutaEntities db = new dbJoutaEntities();
x = db.tComment.FirstOrDefault(m => m.fID == id);
db.tComment.Remove(x);
db.SaveChanges();
return(RedirectToAction("List"));
}
public ActionResult New(C回覆 y)
{
dbJoutaEntities db = new dbJoutaEntities();
tComment x = new tComment();
x.f標題 = Request.Form["f標題"];
x.f意見 = Request.Form["f意見"];
x.f性別 = Request.Form["f性別"];
x.f意見類型 = Request.Form["f意見類型"];
x.f聯絡人 = Request.Form["f聯絡人"];
x.f電子郵件 = Request.Form["f電子郵件"];
x.f電話 = Request.Form["f電話"];
x.f意見時間 = DateTime.Now.ToString();
x.f意見狀態 = "未回覆";
db.tComment.Add(x);
db.SaveChanges();
string message = "傳送成功";
ViewBag.ll = message;
return(View());
}
public ActionResult Contact(tComment comment, HttpPostedFileBase file)
{
if (file != null)
{
if (file.ContentLength > 0)
{
fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/images"), fileName);
file.SaveAs(path);
}
}
else
{
fileName = "cc4.png";
}
comment.CommentDate = DateTime.Now;
comment.Image = fileName;
db.tComments.Add(comment);
db.SaveChanges();
var latestComment = db.tComments.OrderByDescending(m => m.CommentDate).FirstOrDefault();
return(View(latestComment));
}
