public dynamic FindRecentAttraction()
{
var sqlQuery = @"SELECT TOP 1 *
from c
ORDER BY c.createdAt DESC";
var documents = DocumentDBManagement.GetItemsAsync("attractionswaittime", sqlQuery);
return(documents.FirstOrDefault());
}
public List <dynamic> FindAttractions()
{
var document = this.FindRecentAttraction();
dynamic parameters = new ExpandoObject();
parameters.date = document.createdAt;
var sqlQueryAttractions = @"SELECT
c.attractionId,
c.name,
c.id,
c.waitTime,
c.type,
c.createdAt
FROM c WHERE c.createdAt = @date";
var documents = DocumentDBManagement.GetItemsAsync("attractionswaittime", sqlQueryAttractions, parameters);
return(documents);
}
public List <dynamic> FindAttractionsAggregate(string attractionId, DateTime startDate, DateTime endDate)
{
var sqlQuery = @"SELECT
c.attractionId,
c.name,
c.id,
c.waitTimeAvg,
c.date,
c.total
FROM c WHERE c.date >= @startDate
and c.date <= @endDate
and STARTSWITH(c.attractionId,@attractionId)";
dynamic parameters = new ExpandoObject();
parameters.attractionId = attractionId;
parameters.startDate = String.Format("{0:yyyy-MM-dd HH:mm:ss}", startDate);
parameters.endDate = String.Format("{0:yyyy-MM-dd HH:mm:ss}", endDate);
var documents = DocumentDBManagement.GetItemsAsync("attractionswaittimeaggregation", sqlQuery, parameters);
return(documents);
}