public string Like(int? id) { CheckUser(); Article a = null; int Uid = Autorizacija.Autorizacija.GetCurrentUser(this.HttpContext).UserID; string likes = ""; if (id.HasValue) { using (DBBL Baza = new DBBL()) { ArticlesLike al = new ArticlesLike() { ArticleID = id.Value, UserID = Uid, GUID = Guid.NewGuid(), DateLike = DateTime.Now, CreatorIP = this.Request.GetIpAdresa() }; try { Baza.IncetrementLikes(al); } catch (Exception) { return "False"; } a = Baza.GetWikiByID(id.Value); likes = a.ArticlesLikes.Count.ToString(); } } return likes; }
public void IncetrementLikes(ArticlesLike al) { context.Database.ExecuteSqlCommand(String.Format("EXEC dbo.usp_ArticlesLikesInsert {0},{1},'{2}','{3}','{4}'", al.ArticleID, al.UserID, al.DateLike.Value.ToString("MM/dd/yyyy HH:mm:ss", CultureInfo.InvariantCulture), al.CreatorIP, al.GUID)); }