PAWA.Classes.AdminReports.CreateTableForDailyUsage C# (CSharp) Method

CreateTableForDailyUsage() public method

public CreateTableForDailyUsage ( string tableId = "", string headerClass = "" ) : string
tableId string
headerClass string
return string
        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);
        }