/// <summary>
/// Refresh the ICAL Event data of a event
/// </summary>
/// <param name="dbEvent">The event</param>
/// <param name="description">The New desciption of the event</param>
/// <param name="updateUid">True, when a new UID sould be set. Only recommenten, with a new (unsaved) event</param>
public static void UpdateCalendarData(TableEvent dbEvent, string description, bool updateUid)
{
TokenNode calendarNode = calendarNode = ReadTokenNode(dbEvent);
var icalEvent = calendarNode.Childs.Single().Childs.First(o => o.Name == "VEVENT");
UpdateStringToken(icalEvent, "SUMMARY", dbEvent.Title);
UpdateStringToken(icalEvent, "DESCRIPTION", description);
UpdateDateToken(icalEvent, "DTSTART", dbEvent.From, dbEvent.IsFullDayEvent);
UpdateDateToken(icalEvent, "DTEND", dbEvent.To, dbEvent.IsFullDayEvent);
//The uid helps the CalDav Server to uniquie identify the event and is required for events.
if (updateUid)
{
UpdateStringToken(icalEvent, "UID", Guid.NewGuid().ToString());
}
using (var tmpStream = new MemoryStream())
{
TokenWriter.WriteTokenNode(calendarNode.Childs.Single(), tmpStream);
tmpStream.Seek(0, SeekOrigin.Begin);
var reader = new StreamReader(tmpStream);
dbEvent.CalendarData = reader.ReadToEnd();
}
}
private async Task <FacebookPostStatus> GetFacebookPostStatusForSqlTable(TableEvent tableEvent)
{
if (tableEvent is null)
{
return(null);
}
FacebookPostStatus facebookPostStatus = null;
switch (tableEvent.TableName)
{
case SourceSystems.Engagements:
var engagement = await _engagementManager.GetAsync(tableEvent.PartitionKey.To <int>());
facebookPostStatus = GetFacebookPostStatusForEngagement(engagement);
break;
case SourceSystems.Talks:
var talk = await _engagementManager.GetTalkAsync(tableEvent.PartitionKey.To <int>());
facebookPostStatus = GetFacebookPostStatusForTalk(talk);
break;
}
return(facebookPostStatus);
}
/// <summary>
/// Aktualisiert die Metadaten eines in der Datenbank gespeicherten Events
/// </summary>
public static void UpdateEventMetadata(TableEvent eEvent)
{
using (var stream = new MemoryStream())
{
var writer = new StreamWriter(stream);
writer.Write(eEvent.CalendarData);
writer.Flush();
stream.Seek(0, SeekOrigin.Begin);
var parsedCalendar = CalPaser.Parse(stream);
var parsedEvent = parsedCalendar.Events.FirstOrDefault();
if (parsedEvent == null)
{
return;
}
eEvent.From = parsedEvent.From;
eEvent.To = parsedEvent.To;
eEvent.Title = parsedEvent.Title;
eEvent.IsFullDayEvent = parsedEvent.IsFullDayEvent;
}
}
private void dispatchEvent(TableEvent te, Bean obj)
{
if (listeners [(int)te] != null)
{
listeners [(int)te] (obj);
}
}
private void SaveTableEvent(TableEvent dbEvent)
{
dbEvent.From = (DpFrom.Value ?? DateTime.Now).CombineWithTime(TpFrom.Value ?? DateTime.Now);
dbEvent.To = (DpTo.Value ?? DateTime.Now).CombineWithTime(TpTo.Value ?? DateTime.Now);
dbEvent.Title = TbTitle.Text;
dbEvent.IsFullDayEvent = CbFullDayEvent.IsChecked ?? false;
if (dbEvent.IsFullDayEvent)
{
dbEvent.From = dbEvent.From.Date;
dbEvent.To = dbEvent.To.Date.AddDays(1);
}
if (dbEvent.To < dbEvent.From)
{
MessageBox.Show(Resource.Localization.AppResources.AppointmentPage_WrongDate);
UnlockPage();
return;
}
CalendarDataUpdater.UpdateCalendarData(dbEvent, TbDescription.Text, false);
var ocCLient = LoadOcCalendarClient();
ocCLient.SaveEventComplete += ocCLient_SaveEventComplete;
ocCLient.SaveEvent(dbEvent);
Context.SubmitChanges();
}
private async Task <string> GetTweetForSqlTable(TableEvent tableEvent)
{
if (tableEvent is null)
{
return(null);
}
string tweetText = null;
switch (tableEvent.TableName)
{
case SourceSystems.Engagements:
var engagement = await _engagementManager.GetAsync(tableEvent.PartitionKey.To <int>());
tweetText = GetTweetForEngagement(engagement);
break;
case SourceSystems.Talks:
var talk = await _engagementManager.GetTalkAsync(tableEvent.PartitionKey.To <int>());
tweetText = GetTweetForTalk(talk);
break;
}
return(tweetText);
}
/// <summary>
/// Aktualisiert die Termine für den Kalendar im angegebenen Monat
/// </summary>
public void RefreshAppointments()
{
var calendarEvents = Context.Calendars.Where(o => o._accountId == AccountID).Select(o => o.Events.Where(q => q.To > _firstDayOfCalendarMonth && q.From < _lastDayOfCalendarMonth));
//merge all calendar events
IEnumerable <TableEvent> events = new TableEvent[0];
foreach (var calendar in calendarEvents)
{
events = events.Concat(calendar);
}
events = events
.OrderByDescending(o => o.To - o.From) //Längere Event sollen oben angezeigt werden
.ToArray();
//Refresh events to get the changes, if a sync was completed
// ReSharper disable CoVariantArrayConversion
Context.Refresh(RefreshMode.OverwriteCurrentValues, events);
// ReSharper restore CoVariantArrayConversion
//Delete displayed events
GrdAppointments.Children.Clear();
_dayPanels.Clear();
//INsert new events
PutEvent(events);
}
/// <summary>
/// Refresh the ICAL Event data of a event
/// </summary>
/// <param name="dbEvent">The event</param>
/// <param name="description">The New desciption of the event</param>
/// <param name="updateUid">True, when a new UID sould be set. Only recommenten, with a new (unsaved) event</param>
public static void UpdateCalendarData(TableEvent dbEvent, string description,bool updateUid)
{
TokenNode calendarNode = calendarNode = ReadTokenNode(dbEvent);
var icalEvent = calendarNode.Childs.Single().Childs.First(o => o.Name == "VEVENT");
UpdateStringToken(icalEvent, "SUMMARY", dbEvent.Title);
UpdateStringToken(icalEvent, "DESCRIPTION", description);
UpdateDateToken(icalEvent, "DTSTART", dbEvent.From, dbEvent.IsFullDayEvent);
UpdateDateToken(icalEvent, "DTEND", dbEvent.To, dbEvent.IsFullDayEvent);
//The uid helps the CalDav Server to uniquie identify the event and is required for events.
if(updateUid)
UpdateStringToken(icalEvent,"UID",Guid.NewGuid().ToString());
using (var tmpStream = new MemoryStream())
{
TokenWriter.WriteTokenNode(calendarNode.Childs.Single(), tmpStream);
tmpStream.Seek(0, SeekOrigin.Begin);
var reader = new StreamReader(tmpStream);
dbEvent.CalendarData = reader.ReadToEnd();
}
}
public void SaveEvent(TableEvent eventToSave)
{
this.BeginHttpRequest(Address.CombineServerAddress(eventToSave.Url));
ContentTypeCalendar();
SetMethod("PUT");
Request.BeginGetRequestStream(SaveEventWriteRequest, eventToSave);
}
public void FireTriggers(IRequest context, TableEvent tableEvent)
{
Session.Context.FireTriggers(context, tableEvent);
var manager = Session.Transaction.GetTriggerManager();
if (manager == null)
{
return;
}
manager.FireTriggers(context, tableEvent);
}
private static TokenNode ReadTokenNode(TableEvent dbEvent)
{
var nodeParser = new ParserNodeToken();
TokenNode calendarNode;
using (var stream = new MemoryStream())
{
var writer = new StreamWriter(stream);
writer.Write(dbEvent.CalendarData);
writer.Flush();
stream.Seek(0, SeekOrigin.Begin);
calendarNode = nodeParser.Parse(stream);
}
return calendarNode;
}
private static TokenNode ReadTokenNode(TableEvent dbEvent)
{
var nodeParser = new ParserNodeToken();
TokenNode calendarNode;
using (var stream = new MemoryStream())
{
var writer = new StreamWriter(stream);
writer.Write(dbEvent.CalendarData);
writer.Flush();
stream.Seek(0, SeekOrigin.Begin);
calendarNode = nodeParser.Parse(stream);
}
return(calendarNode);
}
private async Task <FacebookPostStatus> GetFacebookPostStatusForSourceData(TableEvent tableEvent)
{
if (tableEvent is null)
{
return(null);
}
var statusText = "ICYMI: ";
var sourceData = await _sourceDataRepository.GetAsync(tableEvent.PartitionKey, tableEvent.RowKey);
if (sourceData is null)
{
_logger.LogWarning($"Record for '{tableEvent.PartitionKey}', '{tableEvent.RowKey}' was not found.");
return(null);
}
statusText = sourceData.SourceSystem switch
{
SourceSystems.SyndicationFeed => "Blog Post: ",
SourceSystems.YouTube => "Video: ",
_ => statusText
};
var url = sourceData.ShortenedUrl ?? sourceData.Url;
var postTitle = sourceData.Title;
var hashTagList = HashTagList(sourceData.Tags);
if (statusText.Length + url.Length + postTitle.Length + 3 + hashTagList.Length >= MaxFacebookStatusText)
{
var newLength = MaxFacebookStatusText - statusText.Length - url.Length - hashTagList.Length - 1;
postTitle = postTitle.Substring(0, newLength - 4) + "...";
}
var facebookPostStatus = new FacebookPostStatus
{
StatusText = $"{statusText} {postTitle} {hashTagList}",
LinkUri = url
};
_logger.LogDebug(
"Composed Facebook Status: StatusText='{facebookPostStatus.StatusText}', LinkUrl='{facebookPostStatus.LinkUri}'",
facebookPostStatus.StatusText, facebookPostStatus.LinkUri);
return(facebookPostStatus);
}
public void GetLobbyList()
{
WebClient wc = new WebClient();
try
{
string sResponse = wc.DownloadString(Globals.LobbyDataURL);
Console.WriteLine(sResponse);
ParseJSON(sResponse);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
DataTable dt = DataTableTools.ConvertToDatatable(Entries);
TableEvent te = new TableEvent(dt);
MMessageBus.LobbyLoaded(this, te);
}
private async Task CallbackTable(Nuid id, string table_name, TableEvent table_event, NList args)
{
string entity_type = Global.NULL_STRING;
Entity entity = EntityManager.Get(id);
if (entity != null)
{
entity_type = entity.Type;
}
else
{
entity_type = await GetCacheType(id);
}
EntityPrefab entity_prefab = Prefabs.GetEntity(entity_type);
if (entity_prefab == null)
{
return;
}
if (entity_prefab.ancestors != null && entity_prefab.ancestors.Count > 0)
{
for (int i = entity_prefab.ancestors.Count - 1; i >= 0; i--)
{
string parent_type = entity_prefab.ancestors[i];
await NModule.CallbackTable(this, id, parent_type, table_name, table_event, args);
}
}
await NModule.CallbackTable(this, id, entity_type, table_name, table_event, args);
TablePrefab table_prefab = entity_prefab.tables[table_name];
if (table_prefab != null && table_prefab.sync)
{
NList msg = NList.New().Add(id).Add(table_name).Add((int)table_event).Append(args);
await SyncTable(id, msg);
}
}
private async Task <string> GetTweetForSourceData(TableEvent tableEvent)
{
if (tableEvent is null)
{
return(null);
}
var statusText = "ICYMI: ";
var sourceData = await _sourceDataRepository.GetAsync(tableEvent.PartitionKey, tableEvent.RowKey);
if (sourceData is null)
{
_logger.LogWarning($"Record for '{tableEvent.PartitionKey}', '{tableEvent.RowKey}' was not found.");
return(null);
}
statusText = sourceData.SourceSystem switch
{
SourceSystems.SyndicationFeed => "Blog Post: ",
SourceSystems.YouTube => "Video: ",
_ => statusText
};
var url = sourceData.ShortenedUrl ?? sourceData.Url;
var postTitle = sourceData.Title;
var hashTagList = HashTagList(sourceData.Tags);
if (statusText.Length + url.Length + postTitle.Length + 3 + hashTagList.Length >= MaxTweetLength)
{
var newLength = MaxTweetLength - statusText.Length - url.Length - hashTagList.Length - 1;
postTitle = string.Concat(postTitle.AsSpan(0, newLength - 4), "...");
}
var tweet = $"{statusText} {postTitle} {url} {hashTagList}";
_logger.LogDebug("Composed tweet '{tweet}'", tweet);
return(statusText);
}
private IEnumerator PlayEvent(Data.events newEvent)
{
tableEvent = DatabaseHandler.GetFromDatabaseEvents(newEvent);
displayManager.SetDisplayContainer(tableEvent.intro.imagePath);
textManager.SetTextArray(tableEvent.intro.text);
textManager.Next();
while (true)
{
if (InputHandler.GetInput().accept)
{
if (textManager.textLength <= 0)
{
break;
}
else
{
textManager.Next();
}
}
yield return(null);
}
while (textManager.isPrinting || !InputHandler.GetInput().acceptKeyDown)
{
yield return(null);
}
textManager.SetTextArray(new string[1] {
"To which guardian would you like to make the offering?"
});
textManager.Next();
displayManager.gameObject.SetActive(false);
choiceManager.gameObject.SetActive(true);
choiceManager.Reset();
}
/// <summary>
/// Aktualisiert die Metadaten eines in der Datenbank gespeicherten Events
/// </summary>
public static void UpdateEventMetadata(TableEvent eEvent)
{
using (var stream = new MemoryStream())
{
var writer = new StreamWriter(stream);
writer.Write(eEvent.CalendarData);
writer.Flush();
stream.Seek(0, SeekOrigin.Begin);
var parsedCalendar = CalPaser.Parse(stream);
var parsedEvent = parsedCalendar.Events.FirstOrDefault();
if (parsedEvent == null) return;
eEvent.From = parsedEvent.From;
eEvent.To = parsedEvent.To;
eEvent.Title = parsedEvent.Title;
eEvent.IsFullDayEvent = parsedEvent.IsFullDayEvent;
}
}
public static void LobbyLoaded(object sender, TableEvent e)
{
GUIEvent(LobbyLoadedHandler, sender, new TableEvent(e.Table));
}
/// <summary>
/// Creates new ruler object.
/// </summary>
public Ruler()
{
InitializeComponent();
this.ControlAdded += new ControlEventHandler(this.OnControlAdded);
this.ControlRemoved += new ControlEventHandler(this.OnControlRemoved);
_horizontalScale = new Scale(this, Orientation.Horizontal);
_horizontalScale.Dock = DockStyle.Fill;
_horizontalScale.MouseUp += new MouseEventHandler(OnMouseUp);
_panelHorizontal.Controls.Add(_horizontalScale);
_verticalScale = new Scale(this, Orientation.Vertical);
_verticalScale.Dock = DockStyle.Fill;
_verticalScale.MouseUp += new MouseEventHandler(OnMouseUp);
_panelVertical.Controls.Add(_verticalScale);
_contextMenu = null;
_document = null;
_prevDocParent = null;
_prevDocDock = DockStyle.None;
_prevDocBounds = Rectangle.Empty;
_handlerPaint = new PaintEventHandler(OnDocumentPaint);
_handlerBoxActivated = new BoxEvent(OnDocumentBoxActivated);
_handlerBoxDeactivated = new BoxEvent(OnDocumentBoxDeactivated);
_handlerBoxDeleted = new BoxEvent(OnDocumentBoxDeleted);
_handlerTableActivated = new TableEvent(OnDocumentTableActivated);
_handlerTableDeactivated = new TableEvent(OnDocumentTableDeactivated);
_handlerTableDeleted = new TableEvent(OnDocumentTableDeleted);
_handlerHostActivated = new ControlHostEvent(OnDocumentHostActivated);
_handlerHostDeactivated = new ControlHostEvent(OnDocumentHostDeactivated);
_handlerHostDeleted = new ControlHostEvent(OnDocumentHostDeleted);
_handlerScrollChanged = new EventHandler(OnDocumentScrollChanged);
_handlerZoomFactorChanged = new EventHandler(OnDocumentZoomFactorChanged);
_handlerDocExtentsChanged = new EventHandler(OnDocumentDocExtentsChanged);
_handlerMeasureUnitChanged = new EventHandler(OnDocumentMeasureUnitChanged);
_handlerDocMouseEnter = new EventHandler(OnDocumentMouseEnter);
_handlerDocMouseMove = new MouseEventHandler(OnDocumentMouseMove);
_handlerDocMouseLeave = new EventHandler(OnDocumentMouseLeave);
_timer = new Timer();
_timer.Interval = 400;
_timer.Tick += new EventHandler(OnTimer);
_timer.Start();
}
protected void ButtonTransferRecordings_Click(object sender, EventArgs e)
{
using (CascadeEdgeCaptureDataContext LoadedLocalEvents = new CascadeEdgeCaptureDataContext())
{
LabelRecordings.Text = "Transferring Recordings - Please Wait";
var LocalRecordings = LoadedLocalEvents.TableLocalEvents.Where(TableLocalEvents => TableLocalEvents.LocalEventStatus == 1);
foreach (TableLocalEvent RecordingsToOutput in LocalRecordings)
{
string fileName = RecordingsToOutput.LocalAssetFileName;
string sourcePath = @"C:\Users\Mark C Strathdee\Documents\Visual Studio 2013\Projects\BrittishCouncil\BrittishCouncil\Uploads\Source\";
string targetPath = @"M:\bc\";
string sourceFile = System.IO.Path.Combine(sourcePath, fileName);
string destFile = System.IO.Path.Combine(targetPath, fileName);
System.IO.File.Copy(sourceFile, destFile, true);
using (CascadeCoreDataContext NewEventEntry = new CascadeCoreDataContext())
{
TableEvent NewEvent = new TableEvent();
NewEvent.CustomerID = RecordingsToOutput.LocalCustomerID;
NewEvent.EventID = RecordingsToOutput.LocalEventID;
NewEvent.EventName = RecordingsToOutput.LocalEventName;
NewEvent.EventDescription = RecordingsToOutput.LocalEventDescription;
NewEvent.EventSite = RecordingsToOutput.LocalEventSite;
NewEvent.AssetFileName = RecordingsToOutput.LocalAssetFileName;
NewEvent.EventStatus = "2";
NewEvent.EventReleaseDate = RecordingsToOutput.LocalEventReleaseDate;
NewEvent.EventDateCreated = DateTime.Now;
NewEventEntry.TableEvents.InsertOnSubmit(NewEvent);
NewEventEntry.SubmitChanges();
}
using (CascadeCoreDataContext NewAssetEntry = new CascadeCoreDataContext())
{
TableAsset NewAsset = new TableAsset();
NewAsset.CustomerID = RecordingsToOutput.LocalCustomerID;
NewAsset.EventID = RecordingsToOutput.LocalEventID;
NewAsset.AssetID = RecordingsToOutput.LocalAssetID;
NewAsset.AssetName = RecordingsToOutput.LocalEventName;
NewAsset.AssetDescription = RecordingsToOutput.LocalEventDescription;
NewAsset.AssetFileName = RecordingsToOutput.LocalAssetFileName;
NewAsset.AssetDateCreated = RecordingsToOutput.LocalEventDateCreated;
NewAssetEntry.TableAssets.InsertOnSubmit(NewAsset);
NewAssetEntry.SubmitChanges();
}
using (CascadeEdgeCaptureDataContext UpdateEventStatus = new CascadeEdgeCaptureDataContext())
{
TableLocalEvent CheckEvent = UpdateEventStatus.TableLocalEvents.SingleOrDefault(TableLocalEvent => TableLocalEvent.LocalEventID == RecordingsToOutput.LocalEventID);
CheckEvent.LocalEventStatus = 2;
CheckEvent.LocalEventDateModified = DateTime.Now;
UpdateEventStatus.SubmitChanges();
}
LabelRecordings.Text = "Transferring Recordings - Please Wait";
}
LabelRecordings.Text = "The following recordings have been transferred to the central archive.";
}
}
public void Table(IList <IList <Token> > columns, LineInFile lineInFile)
{
events.Enqueue(new TableEvent(columns, e => TableEvent.Invoke(this, new EventArgs <IList <IList <Token> > >(columns))));
}
private IEnumerator ActionComplete(Data.succesRate succesRate)
{
Data.actionsTaken++;
if (offer == Data.offers.boar)
{
Data.killsCommited++;
}
TableActions table = DatabaseHandler.GetFromDatabaseActions((Data.actions)offer);
int randomNumber = Random.Range(0, table.rows.Length - 1);
switch (succesRate)
{
case Data.succesRate.positive:
textManager.SetTextArray(table.rows [randomNumber].positive);
Data.towerStage++;
break;
case Data.succesRate.neutral:
textManager.SetTextArray(table.rows[randomNumber].neutral);
break;
case Data.succesRate.negative:
textManager.SetTextArray(table.rows [randomNumber].negative);
Data.destroyedStructures++;
break;
}
textManager.Next();
while (true)
{
if (InputHandler.GetInput().accept)
{
if (textManager.textLength <= 0)
{
break;
}
else
{
textManager.Next();
}
}
yield return(null);
}
while (textManager.isPrinting || !InputHandler.GetInput().acceptKeyDown)
{
yield return(null);
}
actionManager.gameObject.SetActive(false);
RowEvent row = tableEvent.result((int)guardian, (int)succesRate);
displayManager.gameObject.SetActive(true);
displayManager.SetDisplayContainer(row.imagePath);
textManager.SetTextArray(row.text);
textManager.Next();
while (true)
{
if (InputHandler.GetInput().accept)
{
if (textManager.textLength <= 0)
{
break;
}
else
{
textManager.Next();
}
}
yield return(null);
}
while (textManager.isPrinting || !InputHandler.GetInput().acceptKeyDown)
{
yield return(null);
}
if (Data.towerStage >= Data.winningCount)
{
if (Data.killsCommited / Data.actionsTaken < Data.neutralThreshold)
{
StartCoroutine(PlayEpilogue(Data.succesRate.positive));
}
else
{
StartCoroutine(PlayEpilogue(Data.succesRate.neutral));
}
}
else if (Data.destroyedStructures >= Data.losingCount)
{
StartCoroutine(PlayEpilogue(Data.succesRate.negative));
}
else if (row.nextEvent != -1)
{
tableEvent = DatabaseHandler.GetFromDatabaseEvents((Data.events)row.nextEvent);
textManager.SetTextArray(new string[1] {
"To which guardian would you like to make the offering?"
});
textManager.Next();
displayManager.gameObject.SetActive(false);
choiceManager.gameObject.SetActive(true);
choiceManager.Reset();
}
else
{
NewEventDeck();
Data.events eventCur = eventDeck[0];
eventDeck.RemoveAt(0);
StartCoroutine(PlayEvent(eventCur));
}
}
protected void RCTable(string entity_type, string table_name, TableEvent table_event, NEventCallback handler, int priority = 1)
{
_TableEvents.Register(new Tuple <string, string, TableEvent>(entity_type, table_name, table_event), handler, priority);
}
public static async Task CallbackTable(INode node, Nuid id, string entity_type, string table_name, TableEvent table_event, NList args)
{
await _TableEvents.Callback(new Tuple <string, string, TableEvent>(entity_type, table_name, table_event), node, id, args);
}
public void addListener(TableEvent te, Callback callback)
{
listeners [(int)te] += callback;
}
public void removeListener(TableEvent te, Callback callback)
{
listeners [(int)te] -= callback;
DelegateFactory.RemoveDelegate(callback);
}
private void MMessageBus_LobbyLoadedHandler(object sender, TableEvent e)
{
SetupDatagrid(e.Table);
}
private void Network_TableHandler(object sender, TableEvent e)
{
GUIEvent(TableHandler, sender, new TableEvent(e.Table));
}
