internal void HandleGuildCreate(GatewayGuild data) { if (!_guilds.TryGetValue(data.Id.RawValue, out var guild)) { guild = new CachedGuild { Id = data.Id }; guild.Update(data); _guilds[data.Id.RawValue] = guild; Created?.Invoke(guild); guild.Unavailable = data.Unavailable; if (guild.Unavailable != true) { Available?.Invoke(guild); } } else { if (data.Unavailable == false && guild.Unavailable != false) { guild.Unavailable = false; Available?.Invoke(guild); } else if (data.Unavailable == true && guild.Unavailable != true) { guild.Unavailable = true; Unavailable?.Invoke(guild); } guild.Update(data); } }
private void OnUnavailable() { try { Unavailable?.Invoke(this, EventArgs.Empty); } catch { } }
internal void HandleSessionLost() { foreach (var guild in this) { if (guild.Unavailable != true) { guild.Unavailable = true; Unavailable?.Invoke(guild); } } _guilds.Clear(); }
private void btnAdd_Click(object sender, EventArgs e) { if (txtRoom.Text == String.Empty) { txtRoom.Focus(); errorProvider1.SetError(txtRoom, " Select Building"); } else if (comboBoxDay.Text == String.Empty) { comboBoxDay.Focus(); errorProvider1.SetError(comboBoxDay, " Enter Subject Code"); } else if (txtStartTime.Text == String.Empty) { txtStartTime.Focus(); errorProvider1.SetError(txtStartTime, " Enter Subject Code"); } else if (txtEndTime.Text == String.Empty) { txtEndTime.Focus(); errorProvider1.SetError(txtEndTime, " Enter Subject Code"); } else { Unavailable unavailable = new Unavailable(); IUnavailableService unavailableService = new UnavailableService(); // Set Data unavailable.Room = txtRoom.Text.Trim(); unavailable.Day = comboBoxDay.Text.Trim(); unavailable.Start_time = txtStartTime.Text.Trim(); unavailable.End_time = txtEndTime.Text.Trim(); //Insert Data if (unavailableService.addUnavailable(unavailable)) { //MessageBox.Show(tag.Tag); SuccessMessage sc = new SuccessMessage("Unavailable Locations Added Successfully !"); sc.Show(); } else { ErrorMessage ec = new ErrorMessage("there is somethin wrong when WUnavailable Locations adding"); ec.Show(); } } }
private void tryLoadConfig() { try { Configuration = JsonConvert.DeserializeObject <T>(File.ReadAllText(_configPath)); Changed?.Invoke(); _lastUpdateSuccessful = true; _recentlyUpdated = true; } catch (Exception ex) { Unavailable?.Invoke(); } }
public bool addUnavailable(Unavailable unavailable) { Boolean result = false; SQLiteConnection conn = new SQLiteConnection("Data Source=database.db;Version=3;"); try { //string query = "SELECT * FROM people WHERE username= @user AND password= @pass"; string query = "INSERT INTO locationunavailable (room, day, start_time,end_time) VALUES (@room, @day, @start_time,@end_time)"; conn.Open(); SQLiteCommand cmd = new SQLiteCommand(query, conn); cmd.Parameters.AddWithValue("@room", unavailable.Room); cmd.Parameters.AddWithValue("@day", unavailable.Day); cmd.Parameters.AddWithValue("@start_time", unavailable.Start_time); cmd.Parameters.AddWithValue("@end_time", unavailable.End_time); cmd.Prepare(); //Console.WriteLine(cmd); if (cmd.ExecuteNonQuery() == 1) { result = true; } else { result = false; } } catch (Exception e) { Console.WriteLine(e.Message); } finally { conn.Close(); } return(result); }
public bool addUnavailable(Unavailable unavailable) { Boolean result = false; string connectionString = @"Server=us-cdbr-east-03.cleardb.com;Database=heroku_e9719c4a59b4c8f;Uid=b9ff0a805dbcc5;Pwd=25d16e4a;"; MySqlConnection conn = new MySqlConnection(connectionString); try { string query = "INSERT INTO locationunavailable (room, day, start_time,end_time) VALUES (@room, @day, @start_time,@end_time)"; conn.Open(); MySqlCommand cmd = new MySqlCommand(query, conn); cmd.Parameters.AddWithValue("@room", unavailable.Room); cmd.Parameters.AddWithValue("@day", unavailable.Day); cmd.Parameters.AddWithValue("@start_time", unavailable.Start_time); cmd.Parameters.AddWithValue("@end_time", unavailable.End_time); cmd.Prepare(); //Console.WriteLine(cmd); if (cmd.ExecuteNonQuery() == 1) { result = true; } else { result = false; } } catch (Exception e) { Console.WriteLine(e.Message); } finally { conn.Close(); } return(result); }
public List <Unavailable> getAllUnavailable() { string connectionString = @"Server=us-cdbr-east-03.cleardb.com;Database=heroku_e9719c4a59b4c8f;Uid=b9ff0a805dbcc5;Pwd=25d16e4a;"; MySqlConnection conn = new MySqlConnection(connectionString); List <Unavailable> arrayUnavailable = null; try { string query = "SELECT * FROM locationunavailable"; conn.Open(); MySqlCommand cmd = new MySqlCommand(query, conn); MySqlDataReader rdr = cmd.ExecuteReader(); arrayUnavailable = new List <Unavailable>(); while (rdr.Read()) { Unavailable unavailable = new Unavailable(); unavailable.Id = rdr.GetInt32(0); unavailable.Room = rdr.GetString(1); unavailable.Day = rdr.GetString(2); unavailable.Start_time = rdr.GetString(3); unavailable.End_time = rdr.GetString(4); arrayUnavailable.Add(unavailable); } } catch (Exception e) { Console.WriteLine(e.Message); } finally { conn.Close(); } return(arrayUnavailable); }
public List <Unavailable> getAllUnavailable() { SQLiteConnection conn = new SQLiteConnection("Data Source=database.db;Version=3;"); List <Unavailable> arrayUnavailable = null; try { string query = "SELECT * FROM locationunavailable"; conn.Open(); SQLiteCommand cmd = new SQLiteCommand(query, conn); SQLiteDataReader rdr = cmd.ExecuteReader(); arrayUnavailable = new List <Unavailable>(); while (rdr.Read()) { Unavailable unavailable = new Unavailable(); unavailable.Id = rdr.GetInt32(0); unavailable.Room = rdr.GetString(1); unavailable.Day = rdr.GetString(2); unavailable.Start_time = rdr.GetString(3); unavailable.End_time = rdr.GetString(4); arrayUnavailable.Add(unavailable); } } catch (Exception e) { Console.WriteLine(e.Message); } finally { conn.Close(); } return(arrayUnavailable); }
public LiveConfig(string filePath) { if (filePath == null) { throw new ArgumentNullException(nameof(filePath)); } if (!Path.IsPathRooted(filePath)) { filePath = Path.Combine(Environment.CurrentDirectory, filePath); } _configPath = filePath; if (!File.Exists(_configPath)) { throw new FileNotFoundException(_configPath); } _timer = new Timer(); _timer.Elapsed += (s, e) => { _recentlyUpdated = false; _timer.Stop(); }; _timer.Interval = 500; var dir = Path.GetDirectoryName(_configPath); _watcher = new FileSystemWatcher(dir); _watcher.NotifyFilter = _watcher.NotifyFilter = NotifyFilters.CreationTime | NotifyFilters.LastAccess | NotifyFilters.LastWrite | NotifyFilters.Size | NotifyFilters.FileName; _watcher.Filter = Path.GetFileName(_configPath); _watcher.Deleted += (s, e) => Unavailable?.Invoke(); _watcher.Created += (s, e) => tryLoadConfig(); _watcher.Changed += (s, e) => tryLoadConfig(); _watcher.Renamed += (s, e) => tryLoadConfig(); }
internal void HandleGuildDelete(UnavailableGuild data) { if (!_guilds.TryGetValue(data.Id.RawValue, out var guild)) { _logger.Warning($"Failed to process GuildDelete, unknown guild {data.Id}"); return; } if (data.Unavailable == true) { data.Unavailable = true; Unavailable?.Invoke(guild); } else { if (guild.Unavailable != true) { guild.Unavailable = true; Unavailable?.Invoke(guild); } _guilds.TryRemove(data.Id.RawValue, out _); Deleted?.Invoke(guild); } }
public bool updateUnavailable(int id, Unavailable unavailable) { throw new NotImplementedException(); }
public Platform GetUnavailablePlatformFor(Platform platform) => Unavailable?.GetPlatform(platform.Name);