public string CreateTableForDailyUsage(string tableId = "", string headerClass = "")
{
string[] columnHeaders = { "Activity Type", "Date", "Increases", "Losses", "Total Movement" };
List<List<string>> rows = new List<List<string>>();
List<string> columns;
int added, lost;
var dailyStats = from d in dbContext.DailyStatistics
orderby d.Date ascending
select d;
foreach (var stat in dailyStats)
{
columns = new List<string>();
columns.Add("users");
columns.Add(stat.Date.ToString("yyyy-MM-dd"));
added = (int)((stat.UsersAddedCount == null) ? 0 : stat.UsersAddedCount);
columns.Add(added.ToString());
lost = (int)((stat.UsersLostCount == null) ? 0 : stat.UsersLostCount);
columns.Add(lost.ToString());
columns.Add((added - lost).ToString());
rows.Add(columns);
columns = new List<string>();
columns.Add("images");
columns.Add(stat.Date.ToString("yyyy-MM-dd"));
added = (int)((stat.ImagesAddedCount == null) ? 0 : stat.ImagesAddedCount);
columns.Add(added.ToString());
lost = (int)((stat.ImagesLostCount == null) ? 0 : stat.ImagesLostCount);
columns.Add(lost.ToString());
columns.Add((added - lost).ToString());
rows.Add(columns);
columns = new List<string>();
columns.Add("videos");
columns.Add(stat.Date.ToString("yyyy-MM-dd"));
added = (int)((stat.VideosAddedCount == null) ? 0 : stat.VideosAddedCount);
columns.Add(added.ToString());
lost = (int)((stat.VideosLostCount == null) ? 0 : stat.VideosLostCount);
columns.Add(lost.ToString());
columns.Add((added - lost).ToString());
rows.Add(columns);
}
return CreateTable(5, columnHeaders, rows, tableId, headerClass);
}