private DataTable GetUserRecords()
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] {
new DataColumn("Total Active Users", typeof(int)),
new DataColumn("Total Users", typeof(int)),
new DataColumn("Total Active Files", typeof(int))
});
var dsUsers = new DataSetUsersTableAdapters.UsersTableAdapter();
var totalActiveUsers = dsUsers.GetNumberOfActiveUsers() as int?;
var totalUsers = dsUsers.GetNumberOfTotalUsers() as int?;
int?totalActiveFiles = 0;
foreach (var u in dsUsers.GetAllActiveUsers())
{
var dsFiles = new DataSetUsersTableAdapters.FilesTableAdapter();
totalActiveFiles += dsFiles.GetNumberOfFilesByUsername(u.Username);
//DirectoryInfo d = new DirectoryInfo(@u.File_Path);
//try
//{
// FileInfo[] Files = d.GetFiles();
// totalActiveFiles += Files.Length;
//}
//catch
//{
//}
}
dt.Rows.Add(totalActiveUsers, totalUsers, totalActiveFiles);
return(dt);
}
