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