public static CurrencyParticipant FindTwitch(string TwitchName)
{
List <Tuple <string, object> > Params = new List <Tuple <string, object> > {
new Tuple <string, object>("@0", TwitchName)
};
List <object[]> Data = SQL.pubInstance.Read("SELECT * FROM currency_participants WHERE currency_participants.twitch_name = @0", Params);
if (Data.Count == 0)
{
return(null);
}
CurrencyParticipant u = new CurrencyParticipant();
u.SetValues(Data[0]);
return(u);
}
public static CurrencyParticipant FindDiscord(string GuildID)
{
List <Tuple <string, object> > Params = new List <Tuple <string, object> > {
new Tuple <string, object>("@0", GuildID)
};
List <object[]> Data = SQL.pubInstance.Read("SELECT * FROM currency_participants WHERE currency_participants.discord_guild = @0", Params);
if (Data.Count == 0)
{
return(null);
}
CurrencyParticipant u = new CurrencyParticipant();
u.SetValues(Data[0]);
return(u);
}
