//SoFConnStr Data = new SoFConnStr();
public IEnumerable<dynamic> GetAllBadges()
{
dynamic table = new Badge();
var badges = table.All();
return badges;
}
public IEnumerable<dynamic> GetBadgesByUserID(int userid)
{
dynamic table = new Badge();
object[] queryargs = { userid };
var badges = table.All(where: "userid = @0", args: queryargs);
return badges;
}
public IEnumerable<dynamic> GetAllBadgeCounts()
{
var table = new Badge();
object[] queryargs = { 91254 };
var counts = table.Query("select name as badgename, count(0) as badgecount from badges where userid = @0 group by badgename", args: queryargs);
return counts;
}
