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);
}
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 CurrencyConfig FindCurrency(string Source, Source source)
{
CurrencyParticipant _participant = Find(_currencyParticipantCache, x => (x.discord_guild == Source && source == Generics.Source.Discord) || (x.twitch_name == Source && source == Generics.Source.Twitch));
if (_participant == null)
{
if (source == Generics.Source.Discord)
{
_participant = CurrencyParticipant.FindDiscord(Source);
}
else
{
_participant = CurrencyParticipant.FindTwitch(Source);
}
if (_participant != null)
{
_currencyParticipantCache.Add(_participant, DateTime.Now);
}
}
return(FindCurrency(_participant.currencyid));
}
