private string _userId = "user"; // dummy username for google stuff
public GoogleCalendarSyncService(
IConfigurationRoot config,
InteractiveService interactiveService,
ScheduleService scheduleService,
DatabaseServers datbaseServers)
{
_config = config;
_interactiveService = interactiveService;
_scheduleService = scheduleService;
_databaseServers = datbaseServers;
}
public TimeSpan _timerInterval = TimeSpan.FromMinutes(5); // how often the timer will run, in minutes
public RaidEventsService(
DiscordSocketClient discord,
GoogleCalendarSyncService googleCalendarSyncService,
ScheduleService scheduleService,
DatabaseServers databaseServers)
{
_discord = discord;
_googleCalendarSyncService = googleCalendarSyncService;
_scheduleService = scheduleService;
_databaseServers = databaseServers;
}
public async Task ToggleRemindersAsync()
{
var server = DbDiscordServers.ServerList.Find(x => x.DiscordServerObject == Context.Guild);
if (server.RemindersEnabled)
{
server.RemindersEnabled = false;
}
else if (server.RemindersEnabled == false)
{
server.RemindersEnabled = true;
}
await ReplyAsync($"Toggled reminders to: {server.RemindersEnabled}.");
await DatabaseServers.EditServerInfo(server.ServerId, "reminders_enabled", server.RemindersEnabled);
}
/// <summary>
/// Gets the database manager to execute T-SQL statements against it
/// </summary>
/// <returns></returns>
protected void SetContainer(DatabaseServers dBServer = DatabaseServers.DB_DEMO)
{
var configurationName = this.Configuration["ENVIRONMENT"];
var keyName = $"{configurationName}:{dBServer.ToString()}";
var connection = this.Configuration[keyName];
var commandTimeout = this.Configuration["FRAMEWORK.COMMAND.TIMEOUT"].ToInt();
var connectionTimeout = this.Configuration["FRAMEWORK.CONNECTION.TIMEOUT"].ToInt();
var traceEnabled = this.Configuration["FRAMEWORK.TRACE.ENABLED"].ToBool();
var traceFilePath = this.Configuration["FRAMEWORK.TRACE.PATH"];
if (!traceEnabled)
{
traceFilePath = string.Empty;
}
connection = Cryptography.DecryptUsingTripleDES(connection);
var databaseContext = new SQLDatabaseContext(connection, commandTimeout, connectionTimeout);
var databaseRepository = new SQLDatabaseRepository(false, traceFilePath);
container = new ContainerDI(databaseContext, databaseRepository);
}
public async Task ConfigureServerAsync()
{
ulong configChannelId;
ulong reminderChannelId;
// config channel
await ReplyAndDeleteAsync($"Tag the channel you want **configuration** messages sent to (for example, {MentionUtils.MentionChannel(Context.Channel.Id)}).", false, null, TimeSpan.FromMinutes(1));
var response = await NextMessageAsync(true, true, TimeSpan.FromSeconds(30));
if (response != null)
{
if (response.MentionedChannels.FirstOrDefault() != null)
{
configChannelId = MentionUtils.ParseChannel(response.Content);
}
else
{
await ReplyAsync("You didn't correctly tag a channel. Follow the instructions, dingus.");
return;
}
}
else
{
await ReplyAsync("I didn't get a response in time. Try again.");
return;
}
// reminder channel
await ReplyAndDeleteAsync($"Tag the channel you want **reminders & the schedule** sent to (for example, {MentionUtils.MentionChannel(Context.Channel.Id)}).", false, null, TimeSpan.FromMinutes(1));
response = await NextMessageAsync(true, true, TimeSpan.FromSeconds(30));
if (response != null)
{
if (response.MentionedChannels.FirstOrDefault() != null)
{
reminderChannelId = MentionUtils.ParseChannel(response.Content);
}
else
{
await ReplyAsync("You didn't correctly tag a channel. Follow the instructions, dingus.");
return;
}
}
else
{
await ReplyAsync("I didn't get a response in time. Try again.");
return;
}
// build our new server object
var newServer = new DbDiscordServer()
{
ConfigChannelId = configChannelId.ToString(),
ReminderChannelId = reminderChannelId.ToString(),
ServerId = Context.Guild.Id.ToString(),
ServerName = Context.Guild.Name,
RemindersEnabled = true
};
// add this server's data to the database
await DatabaseServers.AddServerInfo(newServer);
// initialize this server
RaidEventsService.SetServerDiscordObjects(newServer);
// update the ServerList with the new server
DbDiscordServers.ServerList.Add(newServer);
// set up google api authentication
await AuthAsync();
}
private string GetDataStoreForDatabaseServer(DatabaseServers server)
{
return(string.Format(_connectionStrings.CookieDBConnectionTemplate, server.DatabaseServer, server.DatabaseName));
}
internal ServerManager(Session session)
{
_session = session;
Groups = new Groups(_session, Caching.Enabled);
Projects = new Projects(_session, Caching.Enabled);
DatabaseServers = new DatabaseServers(_session, Caching.Enabled);
Users = new Users(_session, Caching.Enabled);
Modules = new IndexedRDList<ModuleType, IModule>(GetModules, x => x.Type, Caching.Enabled);
AsynchronousProcesses = new RDList<IAsynchronousProcess>(GetAsynchronousProcesses, Caching.Disabled);
ApplicationServers = new ApplicationServers(_session, Caching.Enabled);
}
