private DataTable GetFilesRecords()
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] {
new DataColumn("File Name", typeof(string)),
new DataColumn("File Size", typeof(int)),
new DataColumn("User Name", typeof(string))
});
var dsUsers = new DataSetUsersTableAdapters.UsersTableAdapter();
foreach (var u in dsUsers.GetAllActiveUsers())
{
var dsFiles = new DataSetUsersTableAdapters.FilesTableAdapter();
foreach (var f in dsFiles.GetFilesByUsername(u.Username))
{
dt.Rows.Add(f.Name as string, f.Size as int?, u.Username as string);
}
//DirectoryInfo d = new DirectoryInfo(@u.File_Path);
//try
//{
// FileInfo[] Files = d.GetFiles();
// foreach (var f in Files)
// {
// dt.Rows.Add(f.Name as string, u.Username as string);
// }
//}
//catch { }
}
return(dt);
}
public string GetNameByFilename(string filename)
{
var ds = new DataSetUsersTableAdapters.FilesTableAdapter();
var rows = ds.GetNameByFile(filename);
return(rows[0].Username);
}
private bool fileExists(User user)
{
var ds = new DataSetUsersTableAdapters.FilesTableAdapter();
string fileName = user.getFilesList()[0].getFileName();
var filesFound = ds.GetFilesByName(fileName, user.getUsername());
return(filesFound.Count == 0 ? false : true);
}
public void updateFiles(User user)
{
string username = user.getUsername();
List <User.File> files = user.getFilesList();
var ds = new DataSetUsersTableAdapters.FilesTableAdapter();
foreach (User.File file in files)
{
ds.Insert(username, file.getFileName(), file.getFileSize().ToString());
}
}
private string requestedFiles(User user)
{
var ds = new DataSetUsersTableAdapters.FilesTableAdapter();
string fileName = user.getFilesList()[0].getFileName();
var filesFound = ds.GetFilesByName(fileName, user.getUsername());
List <User.File> requestedFiles = new List <User.File>();
foreach (var file in filesFound)
{
User.File f = new User.File(file.Name, long.Parse(file.Size), ds.GetFileNumberOfActiveUsers(file.Name, user.getUsername()).Value);
requestedFiles.Add(f);
}
User userWithRequestedFiles = new User(requestedFiles);
return(userWithRequestedFiles.getXMLFormatToString());
}
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);
}
private void deleteUserFiles(User user)
{
var ds = new DataSetUsersTableAdapters.FilesTableAdapter();
ds.DeleteUserFiles(user.getUsername());
}
