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;
}
private void PopulateArticle()
{
using (Proje.DataAccess.WebProjeEntities dc = new Proje.DataAccess.WebProjeEntities())
{
var v = (from a in dc.icerik
join b in dc.ArticleScore on a.icerikid equals b.icerikid into bb
from b in bb.DefaultIfEmpty()
group new { a, b } by new { a.icerikid, a.icerikYazisi } into AA
select new
{
AA.Key.icerikid,
AA.Key.icerikYazisi,
Score = AA.Sum(a => a.b.Score) != 0 ? 0 : AA.Sum(a => a.b.Score),
Count = AA.Count()
});
List<ArticleWithScore> AWS = new List<ArticleWithScore>();
foreach (var i in v)
{
AWS.Add(new ArticleWithScore
{
icerikid = i.icerikid,
icerikYazisi = i.icerikYazisi,
Score = i.Score / i.Count
});
GridView1.DataSource = AWS;
GridView1.DataBind();
}
}
}
