public static TwitchChannelPointScale[] ForChannel(TwitchChannel channel)
{
List<object[]> results = _table.Select(null, null, "ChannelUserId=?a", new object[] { channel.user.id }, "UnitValue", 0);
if(results != null && results.Count > 0) {
TwitchChannelPointScale[] points = new TwitchChannelPointScale[results.Count];
for(int i = 0; i < results.Count; i++) {
points[i] = new SqlTwitchChannelPointScale(channel, results[i][1].FromSql<ulong>(), results[i][2].FromSql<string>(), results[i][3].FromSql<string>());
}
return points;
}
return null;
}
public static TwitchChannelPointScale[] ForChannel(TwitchChannel channel)
{
List <object[]> results = _table.Select(null, null, "ChannelUserId=?a", new object[] { channel.user.id }, "UnitValue", 0);
if (results != null && results.Count > 0)
{
TwitchChannelPointScale[] points = new TwitchChannelPointScale[results.Count];
for (int i = 0; i < results.Count; i++)
{
points[i] = new SqlTwitchChannelPointScale(channel, results[i][1].FromSql <ulong>(), results[i][2].FromSql <string>(), results[i][3].FromSql <string>());
}
return(points);
}
return(null);
}
public TwitchChannelPointScale[] GetChannelPointScale(TwitchChannel channel)
{
return(SqlTwitchChannelPointScale.ForChannel(channel));
}
