internal void PopulateParentData(IEnumerable <DataEntity> dataEntities)
{
if (!this.HasChildren)
{
return;
}
foreach (var de in dataEntities)
{
de.Children = new Core.ConnectorApi.Query.EntityChildren();
if (this.ChildNames.Any(x => x.Equals(Constants.Event_Name)))
{
var ds = DataServicesClient.ListEvents(this.Connection);
var table = ds.Tables["ResultSet"];
var filteredRows = table.Select($"{Constants.Event_PK} = '{de.Properties[Constants.Event_PK]}'");
List <DataEntity> children = new List <DataEntity>();
var parent = filteredRows.FirstDataEntity(Constants.Event_Name);
if (parent != null)
{
children.Add(parent);
de.Children.Add(Constants.Event_Name, children);
}
}
}
}
internal void PopulateChildData(IEnumerable <DataEntity> dataEntities)
{
if (!this.HasChildren)
{
return;
}
foreach (var de in dataEntities)
{
de.Children = new Core.ConnectorApi.Query.EntityChildren();
//Events Children => Speaker, Session, Meeting
if (this.ChildNames.Any(x => x.Equals(Constants.Speaker_Name)))
{
var ds = DataServicesClient.ListSpeakers(Connection);
var table = ds.Tables["ResultSet"];
var filteredRows = table.Select($"{Constants.Event_PK} = {de.Properties[Constants.Event_PK]}");
List <DataEntity> children = new List <DataEntity>();
foreach (var c in filteredRows.ToDataEntities(Constants.Speaker_Name, this.PropertyDefinitions))
{
children.Add(c);
}
de.Children.Add(Constants.Speaker_Name, children);
}
if (this.ChildNames.Any(x => x.Equals(Constants.Session_Name)))
{
var ds = DataServicesClient.ListSessions(Connection);
var table = ds.Tables["ResultSet"];
var filteredRows = table.Select($"{Constants.Event_PK} = {de.Properties[Constants.Event_PK]}");
List <DataEntity> children = new List <DataEntity>();
foreach (var c in filteredRows.ToDataEntities(Constants.Session_Name, this.PropertyDefinitions))
{
children.Add(c);
}
de.Children.Add(Constants.Session_Name, children);
}
if (this.ChildNames.Any(x => x.Equals(Constants.Meeting_Name)))
{
var ds = DataServicesClient.ListMeetings(Connection);
var table = ds.Tables["ResultSet"];
var filteredRows = table.Select($"{Constants.Event_PK} = {de.Properties[Constants.Event_PK]}");
List <DataEntity> children = new List <DataEntity>();
foreach (var c in filteredRows.ToDataEntities(Constants.Meeting_Name, this.PropertyDefinitions))
{
children.Add(c);
}
de.Children.Add(Constants.Meeting_Name, children);
}
if (this.ChildNames.Any(x => x.Equals(Constants.FinancialTranstion_Name)))
{
var ds = DataServicesClient.ListFinancialTransactions(Connection);
var table = ds.Tables["ResultSet"];
var filteredRows = table.Select($"{Constants.Event_PK} = {de.Properties[Constants.Event_PK]}");
List <DataEntity> children = new List <DataEntity>();
foreach (var c in filteredRows.ToDataEntities(Constants.FinancialTranstion_Name, this.PropertyDefinitions))
{
children.Add(c);
}
de.Children.Add(Constants.FinancialTranstion_Name, children);
}
}
}
private MethodResult updateEvent(int eventId, DataEntity entity)
{
var name = entity.GetProperty("eventname");
var code = entity.GetProperty("code");
var startDate = entity.GetDateProperty("starttime");
var endDate = entity.GetDateProperty("enddate");
var locationName = entity.GetProperty("locationname");
var programManager = entity.GetProperty("programmanager");
var max_reg = entity.GetProperty("max_reg");
var status = entity.GetProperty("eventstatus");
var result = DataServicesClient.UpdateEvent(Connection, eventId, name, code, startDate,
endDate, locationName, programManager, status, max_reg);
if (result.HasError)
{
return new MethodResult()
{
Success = false,
ErrorInfo = new ErrorResult()
{
Description = result.Error.ToString()
}
}
}
;
return(new MethodResult()
{
Success = !result.HasError
});
}
internal IEnumerable <DataEntity> ExecuteQuery(Core.ConnectorApi.Query.Query query)
{
this.SetQuery(query);
var ds = DataServicesClient.ListRegSessions(Connection, this.KeyPairs);
var dataEntities = GetDataEntites(ds, query);
PopulateParentData(dataEntities);
return(dataEntities);
}
internal IEnumerable <DataEntity> ExecuteQuery(Core.ConnectorApi.Query.Query query)
{
this.SetQuery(query);
var ds = DataServicesClient.ListAttendees(this.Connection, this.ModifiedAfterDate, null, this.KeyPairs);
var dataEntities = GetDataEntites(ds, query);
PopulateChildData(dataEntities);
return(dataEntities);
}
internal MethodResult Create(DataEntity dataEntity, ScribeConnection v2Connection)
{
if (!dataEntity.Properties.ContainsKey(Constants.Event_NameProperty))
{
throw new System.Exception("The data enitity is missing the name property");
}
var name = dataEntity.Properties[Constants.Event_NameProperty].ToString();
var result = DataServicesClient.CreateEvent(v2Connection, name);
if (result.HasError)
{
return new MethodResult()
{
Success = false, ErrorInfo = new ErrorResult()
{
Description = result.Error.ToString()
}
}
}
;
return(updateEvent(result.EventId, dataEntity));
}
private void setPropertyDefinitions()
{
var data = DataServicesClient.GetRegSessionMetaData(Connection);
base.SetPropertyDefinitions(data);
}
private void setPropertyDefinitions()
{
var data = DataServicesClient.GetFinancialTransactionMetaData(Connection);
base.SetPropertyDefinitions(data);
}
