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;
}