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

CreateApplicationOtherUsageReport() public method

public CreateApplicationOtherUsageReport ( string leftColumnClass = "", string rightColumnClass = "" ) : string
leftColumnClass string
rightColumnClass string
return string
        public string CreateApplicationOtherUsageReport(string leftColumnClass="", string rightColumnClass="")
        {
            string report;
            int mostMBUsedInOneAccount = 0;
            int count;

            report = "<span class=\"" + leftColumnClass + "\" id=\"row-background-color\">Total Uploads</span><span class=\"" + rightColumnClass + "\" id=\"row-background-color\">" +
                dbContext.Files.Count() + "</span>";
            report += "<br><span class=\"" + leftColumnClass + "\">Average Folders Per User</span><span class=\"" + rightColumnClass + "\">" +
                dbContext.Folders.Count() / dbContext.Users.Count() + "</span>";

            var users = dbContext.Users.Select(s => s.UserID);

            foreach (var user in users)
            {
                var c = from f in dbContext.Files
                        where f.UserID == user
                        select f.SizeMB;

                // check if any results returned
                if (c.Count() != 0)
                {
                    count = c.Sum();
                }
                else
                {
                    count = 0;
                }

                if (mostMBUsedInOneAccount < count)
                {
                    mostMBUsedInOneAccount = count;
                }
            }
            report += "<br><span class=\"" + leftColumnClass + "\" id=\"row-background-color\">Most MB Used In One Account</span><span class=\"" + rightColumnClass + "\" id=\"row-background-color\">" +
                Math.Round(((double)mostMBUsedInOneAccount / 1000.0), 2) + "</span>";

            return report;
        }