public PugEvent(LimitBreakPugsDataSet.EventsRow e)
{
this.ID = e.ID;
this.Scheduled_Date = e.Scheduled_Date;
this.Created_On = e.Created_On;
this.Discord_Message_ID = e.Discord_Message_ID;
}
private async Task OnReactionAdded(MessageReactionAddEventArgs e)
{
if (e.User.IsBot || e.Channel.Id.ToString() != pugAnnouncementsChannel_ID)
{
return;
}
if (e.Emoji.Name == "YEA")
{
LimitBreakPugsDataSet.PlayersDataTable pdt = Data.playersTableAdapter.GetData();
LimitBreakPugsDataSet.EventsDataTable edt = Data.eventsTableAdapter.GetData();
if (pdt.Count > 0)
{
LimitBreakPugsDataSet.PlayersRow p_row = (LimitBreakPugsDataSet.PlayersRow)pdt.Select($"Discord_Tag = '{e.User.Username}#{e.User.Discriminator}'").First();
LimitBreakPugsDataSet.EventsRow e_row = (LimitBreakPugsDataSet.EventsRow)edt.Select($"Discord_Message_ID={edt.Discord_Message_IDColumn}").First();
Data.registrationsTableAdapter.InsertQuery(e_row.ID, p_row.ID);
await LogChannel($"Discord user {p_row.Discord_Tag} just registered for the pugs being held on {e_row.Scheduled_Date.ToShortDateString()} - {e_row.Scheduled_Date.ToShortTimeString()}");
await e.Guild.GetMemberAsync(e.User.Id).Result
.SendMessageAsync($"You have registered yourself for the pug occuring on {e_row.Scheduled_Date.ToShortDateString()} at {e_row.Scheduled_Date.ToShortTimeString()}. See you there!");
}
else
{
await e.Message.DeleteReactionAsync(e.Emoji, e.User);
await e.Guild.GetMemberAsync(e.User.Id).Result.SendMessageAsync($"You need to share some information before I can sign you up for pugs! Please use the command '?help register' in the bot commands channel for more information.");
}
}
if (e.Emoji.Name == "NAY")
{
await e.Message.DeleteReactionAsync(DiscordEmoji.FromName(e.Client, ":YEA:"), e.User).ConfigureAwait(false);
await e.Message.DeleteReactionAsync(DiscordEmoji.FromName(e.Client, ":DamageLogo:"), e.User).ConfigureAwait(false);
await e.Message.DeleteReactionAsync(DiscordEmoji.FromName(e.Client, ":TankLogo:"), e.User).ConfigureAwait(false);
await e.Message.DeleteReactionAsync(DiscordEmoji.FromName(e.Client, ":SupportLogo:"), e.User).ConfigureAwait(false);
await e.Message.DeleteReactionAsync(DiscordEmoji.FromName(e.Client, ":ZzZz:"), e.User).ConfigureAwait(false);
}
await Task.CompletedTask;
}
private async Task OnReactionRemoved(MessageReactionRemoveEventArgs e)
{
if (e.Channel.Id.ToString() == pugAnnouncementsChannel_ID && e.Emoji.Name == "YEA" && e.User.IsBot == false)
{
LimitBreakPugsDataSet.PlayersDataTable pdt = Data.playersTableAdapter.GetData();
LimitBreakPugsDataSet.EventsDataTable edt = Data.eventsTableAdapter.GetData();
if (pdt.Count > 0)
{
LimitBreakPugsDataSet.PlayersRow p_row = (LimitBreakPugsDataSet.PlayersRow)pdt.Select($"Discord_Tag = '{e.User.Username}#{e.User.Discriminator}'").First();
LimitBreakPugsDataSet.EventsRow e_row = (LimitBreakPugsDataSet.EventsRow)edt.Select($"Discord_Message_ID={edt.Discord_Message_IDColumn}").First();
Data.registrationsTableAdapter.UpdateByEventByPlayer(e_row.ID, p_row.ID, true);
await LogChannel($"Discord user {p_row.Discord_Tag} just **unregistered** for the pugs being held on {e_row.Scheduled_Date.ToShortDateString()} - {e_row.Scheduled_Date.ToShortTimeString()}");
await e.Guild.GetMemberAsync(e.User.Id).Result
.SendMessageAsync($"You have removed yourself from the pug occuring on {e_row.Scheduled_Date.ToShortDateString()} at {e_row.Scheduled_Date.ToShortTimeString()}. See you next time :(.");
}
}
await Task.CompletedTask;
}
public void Insert(LimitBreakPugsDataSet.EventsRow e)
{
Data.eventsTableAdapter.InsertQuery(e.Scheduled_Date, e.Discord_Message_ID);
Fill();
}
