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