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);
}
private void activateUser(User user)
{
string username = user.getUsername();
var ds = new DataSetUsersTableAdapters.UsersTableAdapter();
ds.ActivateUser(username);
}
private bool validateUser(User user)
{
string username = user.getUsername();
string password = user.getPassword();
var ds = new DataSetUsersTableAdapters.UsersTableAdapter();
return(ds.ValidateUser(username, password) == 1 ? true : false);
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
refreshLabels();
checkAllFields();
if (allFieldsFilled && passwordsMatch && usernameValidate)
{
var ds = new DataSetUsersTableAdapters.UsersTableAdapter();
ds.Insert(
TextBoxUsername.Text,
ComputeHash(TextBoxPassword.Text),
false
);
refreshTextBox();
LabelSuccessful.Text = SUCCESFULL_INPUT_INFORMATION;
}
}
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 bool validateUsernameIsAvailable()
{
var ds = new DataSetUsersTableAdapters.UsersTableAdapter();
return(ds.IsUsernameAvailable(TextBoxUsername.Text).Value == 0 ? true : false);
}
