public DataFeedResult GetDataFeedResult(string alias, string key, IDictionary <object, object> parameters = null)
{
var feed = Session.Query <DataFeed>().FirstOrDefault(x => x.FeedAlias == alias);
DataFeedResult result = null;
if (feed != null)
{
result = new DataFeedResult
{
ID = feed.FeedID,
GUID = feed.FeedGUID,
Alias = feed.FeedAlias,
Name = feed.FeedName,
Description = feed.FeedDescription,
Private = feed.Private,
Active = feed.Active,
Deleted = feed.Deleted,
Data = null
};
if (result.Deleted)
{
return(result);
}
if (parameters == null)
{
parameters = new Dictionary <object, object>();
}
feed.ApplyDefaultParameters(parameters);
DataSet ds = ExecuteQuery(feed, ScriptParameters.Create(parameters));
result.Name = ds.DataSetName;
result.Data = new DataFeedResultSet();
IList <DataTable> tables = GetTables(ds, key);
foreach (DataTable dt in tables)
{
var items = new DataFeedResultItemCollection();
foreach (DataRow dr in dt.Rows)
{
var item = new DataFeedResultItem();
foreach (DataColumn dc in dt.Columns)
{
item[dc.ColumnName] = dr[dc.ColumnName].ToString();
}
items.Add(item);
}
result.Data[dt.TableName] = items;
}
}
return(result);
}
public ExpiringCard Convert(DataFeedResultItem item)
{
return(new ExpiringCard
{
BadgeExpireDate = System.Convert.ToDateTime(item["BadgeExpireDate"]),
CardExpireDate = System.Convert.ToDateTime(item["CardExpireDate"]),
CardNumber = item["CardNumber"],
CardStatus = item["CardStatus"],
Email = item["Email"],
FName = item["FName"],
LabUser = System.Convert.ToBoolean(item["LabUser"]),
LName = item["LName"],
PhysicalAccess = System.Convert.ToBoolean(item["PhysicalAccess"]),
Staff = System.Convert.ToBoolean(item["Staff"]),
ClientID = System.Convert.ToInt32(item["ClientID"])
});
}
