//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; }