public ActionResult Comment(FormCollection coll)
{
using (TransactionScope scope = new TransactionScope())
{
comment cmt = new comment
{
comment_datetime = DateTime.Now,
comment_text = coll["comment_text"],
user_id = Int32.Parse(coll["user_id"])
};
db.comments.Add(cmt);
db.SaveChanges();
story_comments phComment = new story_comments
{
comment = cmt,
story_id = Int32.Parse(coll["story_id"])
};
db.story_comments.Add(phComment);
db.SaveChanges();
ViewBag.User = db.users.Where(u => u.id == cmt.user_id).SingleOrDefault();
scope.Complete();
return View(cmt);
}
}
public ActionResult Comment(FormCollection coll)
{
comment cmt = null;
try
{
//we need to add entries to comments and photo_comments table
// so lets start transaction
using (TransactionScope scope = new TransactionScope())
{
//first add to comment
//INSERT INTO comment (comment_datetime, comment_text, user_id) VALUES (?,?,?)
cmt = new comment
{
comment_datetime = DateTime.Now,
comment_text = coll["comment_text"],
user_id = Int32.Parse(coll["user_id"])
};
db.comments.Add(cmt);
db.SaveChanges();
//now take the reference of comment and add to photo_comment
photo_comments phComment = new photo_comments
{
comment = cmt,
photo_id = Int32.Parse(coll["photo_id"])
};
db.photo_comments.Add(phComment);
db.SaveChanges();
ViewBag.User = db.users.Include(m => m.membership).Where(u => u.id == cmt.user_id).SingleOrDefault();
scope.Complete();
return View(cmt);
}
}
catch
{
return View(cmt);
}
}