// REV 1 - COMPLETE 10.19.15 @ 12:26AM
static void Main(string[] args)
{
events _events = new events();
twitter _twitter = new twitter();
templates _templates = new templates();
terminals _terminals = new terminals();
Console.WriteLine("######### BEGIN FNSIGN UPDATER v.1.0 #########");
Console.WriteLine("");
Console.WriteLine("######### GETTING EVENTS THAT NEED TO BE UPDATED #########");
Console.WriteLine("");
List <Event> evs = _events.need_updating();
Console.WriteLine(evs.Count.ToString() + " need updating....");
Console.WriteLine("");
sessions _sessions = new sessions();
foreach (Event e in evs)
{
Console.WriteLine("Finding Sessions for " + e.title);
Console.WriteLine("");
if (!string.IsNullOrEmpty(e.url))
{
List <Session> sess = _sessions.all(e.url, e.api_key);
Console.WriteLine(sess.Count.ToString() + " Sessions Found...");
Console.WriteLine("");
// look for deletions
List <Session> dbsess = _sessions.by_event(e.id);
foreach (Session d in dbsess)
{
List <Session> found = sess.Where(x => x.event_key == d.event_key).ToList();
if (found.Count == 0)
{
// remove the session
Console.WriteLine("Session ID: " + d.id + " NOT FOUND");
Console.WriteLine("Removing Session: " + d.name + "...");
_sessions.delete(d.internal_id);
}
else
{
Console.WriteLine("Session ID: " + d.id + " FOUND");
}
}
foreach (Session s in sess)
{
// now we loop through the sessions and insert or update them
if (s.event_type != "Japanese Language")
{
_sessions.add(s, e.id);
}
}
_sessions.clean_summit();
}
Console.WriteLine("");
Console.WriteLine("Finding Tweets for Global Event Tag...");
Console.WriteLine("");
if (!string.IsNullOrEmpty(e.t_username))
{
Console.WriteLine("Finding Tweets for @" + e.t_username);
Console.WriteLine("");
_twitter.fetch(e.t_username, 50, true, e.id, 0);
}
if (e.hashtags != null)
{
foreach (string h in e.hashtags)
{
Console.WriteLine("Finding Tweets for #" + h);
Console.WriteLine("");
_twitter.fetch(h, 50, e.id, 0);
}
}
Console.WriteLine("Now let's check for the templates associated with " + e.title);
Console.WriteLine("");
foreach (Template t in _templates.all_by_event(e.id))
{
if (!string.IsNullOrEmpty(t.t_username))
{
Console.WriteLine("Fetching Twitter records for @" + t.t_username);
Console.WriteLine("");
_twitter.fetch(t.t_username, 50, true, e.id, t.id);
}
if (t.hashtags != null)
{
Console.WriteLine("Fetching Records for Hashtags...");
Console.WriteLine("");
foreach (string h in t.hashtags)
{
Console.WriteLine("Fetching tweets for #" + h);
Console.WriteLine("");
_twitter.fetch(h, 50, e.id, t.id);
}
}
}
Console.WriteLine("");
Console.WriteLine("Updating Event Last Updated Time...");
_events.update(e);
Console.WriteLine("Complete...");
Console.WriteLine("Moving to next event...");
Console.WriteLine("");
// here we need to update the last update time
}
Console.WriteLine("Check for Offline Terminals...");
Console.WriteLine("");
List <Terminal> terms = _terminals.offline_terminals();
if (terms.Count() > 0)
{
Console.WriteLine(terms.Count() + " Offline, updating their status...");
Console.WriteLine("");
foreach (Terminal t in terms)
{
Console.WriteLine("Taking " + t.title + " Offline");
Console.WriteLine("");
_terminals.offline(t.id);
}
}
else
{
Console.WriteLine("All Terminals are Online...");
Console.WriteLine("");
}
Console.WriteLine("######### FNSIGN v.1.0 UPDATER COMPLETE #########");
}
static void Main(string[] args)
{
schedInterface.auth _auth = new auth();
schedInterface.openstackEvents _events = new openstackEvents();
schedInterface.osettings _settings = new osettings();
schedInterface.events _eventsDB = new events();
functions _functions = new functions();
olocations _olocations = new olocations();
locations _locations = new locations();
osessions _osessions = new osessions();
sessions _sessions = new sessions();
speakers _speakers = new speakers();
event_types _types = new event_types();
Console.WriteLine("Begin Process...");
//Console.WriteLine("Getting Authorization...");
//Console.WriteLine(_auth.auth_justin(_settings.client_id(), _settings.client_secret()));
//Console.ReadLine();
List <OpenStackEvent> evs = _events.push_events();
Console.WriteLine("Event Count:" + evs.Count.ToString());
foreach (OpenStackEvent ev in evs)
{
Console.WriteLine(ev.name);
if (ev.active)
{
schedInterface.Event e = new Event();
e.event_end = _functions.ConvertUnixTimeStamp(ev.end_date.ToString());
e.event_start = _functions.ConvertUnixTimeStamp(ev.start_date.ToString());
e.interval = 5;
e.last_update = DateTime.Now;
e.openstack_id = ev.id;
e.title = ev.name;
if (e.event_start != null)
{
if (Convert.ToDateTime(e.event_end) > DateTime.Now)
{
e.offset = ev.time_zone.offset != null?Convert.ToInt32(ev.time_zone.offset) : 0;
// check to see if it exists
if (_eventsDB.find_by_openstack_id(Convert.ToInt32(e.openstack_id)).id > 0)
{
e.id = _eventsDB.find_by_openstack_id(Convert.ToInt32(e.openstack_id)).id;
e = _eventsDB.appupdate(e);
Console.WriteLine(" Updated...");
}
else
{
e = _eventsDB.add(e);
Console.WriteLine(" Added...");
}
// Get Event TYpes and push them
Console.WriteLine("Updating Event Types...");
Console.WriteLine("");
List <OpenStackEventType> oTypes = _events.push_event_types(Convert.ToInt32(e.openstack_id));
Console.WriteLine(oTypes.Count + " Types Found...");
Int32 tcnt = 0;
foreach (OpenStackEventType oty in oTypes)
{
EventType ety = new EventType();
ety.title = oty.name;
ety.event_type_id = oty.id;
ety.event_id = e.id;
//Console.WriteLine(ety.title + "...");
_types.addUpdate(ety);
tcnt++;
drawTextProgressBar(tcnt, oTypes.Count);
}
List <EventType> etypes = _types.by_event(e.id);
// get locations and push them
List <OpenStackLocation> locs = _olocations.get_by_event(Convert.ToInt32(e.openstack_id));
Console.WriteLine("");
Console.WriteLine("");
Console.WriteLine(locs.Count + " Locations Found....");
Int32 lcnt = 0;
foreach (OpenStackLocation l in locs)
{
Location lo = new Location();
//Console.WriteLine("Processing " + l.name);
lo.title = l.name;
lo.sched_id = l.id.ToString();
lo.event_id = e.id;
_locations.add(lo);
lcnt++;
drawTextProgressBar(lcnt, locs.Count);
}
// now get the speakers
Console.WriteLine("");
Console.WriteLine("Getting Speakers... (Processing Pages...)");
Console.WriteLine("");
OpenSpeaker openspeaker = new OpenSpeaker();
openspeaker = _speakers.refresh(Convert.ToInt32(e.openstack_id), "1");
drawTextProgressBar(0, openspeaker.last_page);
foreach (Speaker speak in openspeaker.data)
{
speak.event_id = e.id;
_speakers.add(speak);
}
Int32 cursp = 0;
while (cursp <= openspeaker.last_page)
{
cursp++;
drawTextProgressBar(cursp, openspeaker.last_page);
openspeaker = _speakers.refresh(Convert.ToInt32(e.openstack_id), cursp.ToString());
foreach (Speaker speak in openspeaker.data)
{
speak.event_id = e.id;
_speakers.add(speak);
}
}
// now get the sessions
Console.WriteLine("");
Console.WriteLine("");
Console.WriteLine("Getting Sessions....");
Console.WriteLine("");
OpenStack op = new OpenStack();
Int32 total_count = 0;
op = _osessions.refresh(Convert.ToInt32(e.openstack_id), "1");
Console.WriteLine("Processing Pages from API");
List <Session> fromAPI = new List <Session>();
List <OpenStackSession> allsessions = new List <OpenStackSession>();
allsessions.AddRange(op.data);
drawTextProgressBar(0, op.last_page);
Int32 cur = 1;
while (cur <= op.last_page)
{
drawTextProgressBar(cur, op.last_page);
// get the next records
cur++;
op = _osessions.refresh(Convert.ToInt32(e.openstack_id), cur.ToString());
allsessions.AddRange(op.data);
}
Int32 cursess = 0;
Console.WriteLine("");
Console.WriteLine("");
Console.WriteLine("Session Count:" + op.total.ToString());
Console.WriteLine("Processing Session Records...");
drawTextProgressBar(cursess, allsessions.Count);
foreach (OpenStackSession sess in allsessions)
{
if (!string.IsNullOrEmpty(sess.title))
{
fromAPI.Add(_sessions.add(_osessions.parse(sess, e, etypes), e.id));
}
cursess++;
drawTextProgressBar(cursess, allsessions.Count);
}
//Console.WriteLine("");
//Console.WriteLine("");
//Console.WriteLine("Finding Sessions to Remove...");
//// find sessions that have been removed and delete them from the database
//List<Session> fromDB = _sessions.by_event(e.id);
//Int32 dcnt = 0;
//var result = fromDB.Where(p => !fromAPI.Any(p2 => p2.id == p.event_key));
//// iterate through them and delete them
//foreach (var item in result)
//{
// Console.WriteLine("Removing Session: " + item.event_key + " " + item.name);
// //if (_sessions.remove(item.event_key))
// //{
// // drawTextProgressBar(dcnt, result.Count());
// //}
// //dcnt++;
//}
}
}
}
}
}
private static void Main(string[] args)
{
events events = new events();
twitter twitter = new twitter();
templates templates = new templates();
terminals terminals = new terminals();
Console.WriteLine("######### BEGIN FNSIGN UPDATER v.1.0 #########");
Console.WriteLine("");
Console.WriteLine("######### GETTING EVENTS THAT NEED TO BE UPDATED #########");
Console.WriteLine("");
List <Event> eventList = events.need_updating()
.Where <Event>((Func <Event, bool>)(x => !string.IsNullOrEmpty(x.api_key) && !string.IsNullOrEmpty(x.url)))
.ToList <Event>();
Console.WriteLine(eventList.Count.ToString() + " need updating....");
Console.WriteLine("");
sessions sessions = new sessions();
foreach (Event ev in eventList)
{
Console.WriteLine("Finding Sessions for " + ev.title);
Console.WriteLine("");
List <Session> sessionList = sessions.getSessionsFromAPI(ev.url, ev.api_key, ev.api_type);
Console.WriteLine(sessionList.Count.ToString() + " Sessions Found...");
Console.WriteLine("");
foreach (Session s in sessionList)
{
sessions.add(s, ev.id);
}
//Remove those sessions which stopped coming from api
IList <string> incomingSessionIds = sessionList.Select(x => x.event_key).ToList();
List <Session> notComingAnymoreSessions = sessions.by_event(ev.id).Where(x => !incomingSessionIds.Contains(x.event_key)).ToList <Session>();
foreach (var item in notComingAnymoreSessions)
{
sessions.delete(int.Parse(item.id));
}
Console.WriteLine("");
Console.WriteLine("Finding Tweets for Global Event Tag...");
Console.WriteLine("");
if (!string.IsNullOrEmpty(ev.t_username))
{
Console.WriteLine("Finding Tweets for @" + ev.t_username);
Console.WriteLine("");
twitter.fetch(ev.t_username, 50, true, ev.id, 0);
}
if (ev.hashtags != null)
{
foreach (string hashtag in ev.hashtags)
{
Console.WriteLine("Finding Tweets for #" + hashtag);
Console.WriteLine("");
twitter.fetch(hashtag, 50, ev.id, 0);
}
}
Console.WriteLine("Now let's check for the templates associated with " + ev.title);
Console.WriteLine("");
foreach (Template template in templates.all_by_event(ev.id))
{
if (!string.IsNullOrEmpty(template.t_username))
{
Console.WriteLine("Fetching Twitter records for @" + template.t_username);
Console.WriteLine("");
twitter.fetch(template.t_username, 50, true, ev.id, template.id);
}
if (template.hashtags != null)
{
Console.WriteLine("Fetching Records for Hashtags...");
Console.WriteLine("");
foreach (string hashtag in template.hashtags)
{
Console.WriteLine("Fetching tweets for #" + hashtag);
Console.WriteLine("");
twitter.fetch(hashtag, 50, ev.id, template.id);
}
}
}
Console.WriteLine("");
Console.WriteLine("Updating Event Last Updated Time...");
events.update(ev);
Console.WriteLine("Complete...");
Console.WriteLine("Moving to next event...");
Console.WriteLine("");
}
Console.WriteLine("Check for Offline Terminals...");
Console.WriteLine("");
List <Terminal> source = terminals.offline_terminals();
if (source.Count <Terminal>() > 0)
{
Console.WriteLine(source.Count <Terminal>().ToString() + " Offline, updating their status...");
Console.WriteLine("");
foreach (Terminal terminal in source)
{
Console.WriteLine("Taking " + terminal.title + " Offline");
Console.WriteLine("");
terminals.offline(terminal.id);
}
}
else
{
Console.WriteLine("All Terminals are Online...");
Console.WriteLine("");
}
Console.WriteLine("######### FNSIGN v.1.0 UPDATER COMPLETE #########");
}