public ActionResult AddKoment(string Komenatar, int? aid)
{
User user = Autorizacija.Autorizacija.GetCurrentUser(this.HttpContext);
if (!aid.HasValue && string.IsNullOrEmpty(Komenatar))
return RedirectToAction("Index", "Wellcome");
int ArticlesID = aid.Value;
try
{
Comment c = new Comment();
c.CreatorName = user.FirstName + " " + user.LastName;
c.CreatorUserAgent = this.Request.UserAgent;
c.CreatorIP = this.Request.GetIpAdresa();
c.GUID = Guid.NewGuid();
c.IsActive = true;
c.IsSpam = false;
c.CreatorEmail = user.Email;
c.Created = DateTime.Now;
c.CreatedByUserID = user.UserID;
c.Body = Komenatar;
c.ArticleID = ArticlesID;
using (DBBL Baza = new DBBL())
{
Baza.AddKomentar(c);
}
}
catch (Exception) { }
return RedirectToRoute("GetWikiRoute", new { id = ArticlesID });
}
public ActionResult CommentAnswer(string Komentar, int id)
{
Comment comment = new Comment();
comment.AnswerID = id;
comment.Body = Server.HtmlDecode(Komentar).Replace("'", "'");
comment.GUID = Guid.NewGuid();
comment.Created = DateTime.Now;
comment.CreatorUserAgent = this.HttpContext.Request.UserAgent;
comment.CreatorIP = this.HttpContext.Request.GetIpAdresa();
comment.CreatorName = Autorizacija.Autorizacija.GetCurrentUser(this.HttpContext).FirstName;
comment.CreatorEmail = Autorizacija.Autorizacija.GetCurrentUser(this.HttpContext).Email;
comment.CreatedByUserID = Autorizacija.Autorizacija.GetCurrentUser(this.HttpContext).UserID;
comment.IsActive = true;
comment.IsSpam = false;
var Url = Request.UrlReferrer;
_db.Add_Comment(comment);
TempData["KomentSuccess"] = true;
return Redirect(Url.ToString());
}
public void AddKomentar(Comment c)
{
context.Comments.Add(c);
context.SaveChanges();
}
public void Add_Comment(Comment c)
{
context.Database.ExecuteSqlCommand("EXEC [dbo].[usp_CommentInsert] {0},{1},{2},{3},{4},null,{5},{6},{7},{8},{9},null,null,null,{10}", c.GUID, c.CreatorIP, c.CreatorUserAgent, c.CreatorEmail, c.CreatorName, c.Body, c.IsActive, c.IsSpam, c.Created, c.CreatedByUserID, c.AnswerID);
}
