public static int SaveRating(int icerikid, int rate)
{
int result = 0;
using (Proje.DataAccess.WebProjeEntities dc = new Proje.DataAccess.WebProjeEntities())
{
dc.ArticleScore.Add(new Proje.DataAccess.ArticleScore
{
icerikid = icerikid,
Scoreid = 0,
Score = rate,
CreateDate = DateTime.Now
}) ;
dc.SaveChanges();
var newScore = (from a in dc.ArticleScore
where a.icerikid.Equals(icerikid)
group a by a.icerikid into aa
select new
{
Score = aa.Sum(a => a.Score) / aa.Count()
}).FirstOrDefault();
result = newScore.Score;
}
return result;
}
