private void btnSearch_Click(object sender, EventArgs e)
{
using (GlossaryAdminModel dbConnection = new GlossaryAdminModel())
{
var usernameSearch = (from u in dbConnection.User
where u.Username.Equals(txtUserID.Text.ToString())
select u).FirstOrDefault();
if (usernameSearch != null)
{
UserId = usernameSearch.Id;
lblUsernametxt.Text = usernameSearch.Username;
lblFirstnametxt.Text = usernameSearch.Firstname;
lblLastnametxt.Text = usernameSearch.Lastname;
lblEmailtxt.Text = usernameSearch.Email;
lblNoSuchUser.Visible = false;
panel1.Visible = true;
}
else
{
lblNoSuchUser.Visible = true;
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//Save things to DB and give a success message!
var hashedPassword = Hash.sha256(txtPassword.Text);
try
{
using (GlossaryAdminModel dbConnection = new GlossaryAdminModel())
{
var newUser = new User();
newUser.Username = txtUsername.Text.ToString();
newUser.Password = hashedPassword;
newUser.RoleId = cmbRole.SelectedIndex;
newUser.Firstname = txtFirstname.Text.ToString();
newUser.Lastname = txtLastname.Text.ToString();
newUser.Email = txtEmail.Text.ToString();
dbConnection.User.Add(newUser);
dbConnection.SaveChanges();
}
}
catch (EntityException ex)
{
MessageBox.Show("Could not populate the dropdown list." + ex.Message);
}
catch (Exception ex)
{
MessageBox.Show("General error when populating the dropdown list." + ex.Message + ex.InnerException);
}
finally
{
Close();
}
}
//Populates the main window with data from the database.
private void getNumbers()
{
try
{
using (GlossaryAdminModel dbConnection = new GlossaryAdminModel())
{
// Get number of users here
int countUsers = (from u in dbConnection.User
select u).Count();
lblNumberOfUserstxt.Text = countUsers.ToString();
//Get numbers of admins
int countAdmins = (from u in dbConnection.User
where u.RoleId == 1
select u).Count();
lblNumberOfAdminstxt.Text = countAdmins.ToString();
//Get number of tests
int countTests = (from u in dbConnection.Test
select u).Count();
lblNumberOfTeststxt.Text = countTests.ToString();
}
}
catch (EntityException ex)
{
MessageBox.Show("Could not load data from database." + ex.Message);
}
catch (Exception ex)
{
MessageBox.Show("Error when loading from Database." + ex.Message + ex.InnerException);
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
//Disables the login button to prevent several requests.
btnLogin.Enabled = false;
var hashedPassword = Hash.sha256(txtPassword.Text);
try
{
using (GlossaryAdminModel dbConnection = new GlossaryAdminModel())
{
//Selecting the user with the given credentials.
var user = (from u in dbConnection.User
where u.Username == txtUsername.Text.ToString() &&
u.RoleId.Equals(1) &&
u.Password == hashedPassword
select u).FirstOrDefault();
//If the user is an Admin (Role no. 1) and the right credentials are given.
//Saves the users Id for usage further more.
if (user != null)
{
DialogResult = DialogResult.OK;
LoggedInUser.UserId = user.Id;
}
//If the user is a regular user (Role no. 0) and the right credentials are given.
if (user != null && user.RoleId.Equals(0))
{
lblNotAdmin.Visible = true;
lblWrongCredentials.Visible = false;
clearAllFields();
}
//If there's not an user with the given credentials.
else
{
lblNotAdmin.Visible = false;
lblWrongCredentials.Visible = true;
clearAllFields();
}
}
}
catch (EntityException ex)
{
MessageBox.Show("Could not load userinfo from database." + ex.Message);
}
catch (Exception ex)
{
MessageBox.Show("Error when loading from database." + ex.Message + ex.InnerException);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
using (GlossaryAdminModel dbConnection = new GlossaryAdminModel())
{
var selectedUser = (from u in dbConnection.User
where u.Id == UserId
select u).FirstOrDefault();
if (selectedUser != null)
{
dbConnection.User.Remove(selectedUser);
dbConnection.SaveChanges();
}
}
panel1.Visible = false;
}
public void btnSearch_Click(object sender, EventArgs e)
{
try
{
using (GlossaryAdminModel dbConnection = new GlossaryAdminModel())
{
var usernameSearch = (from u in dbConnection.User
where u.Username.Equals(txtSearchUsername.Text.ToString())
select u).FirstOrDefault();
if (usernameSearch != null)
{
UserId = usernameSearch.Id;
txtUsername.Text = usernameSearch.Username;
txtFirstname.Text = usernameSearch.Firstname;
txtLastname.Text = usernameSearch.Lastname;
txtEmail.Text = usernameSearch.Email;
cbRole.SelectedIndex = usernameSearch.RoleId;
lblNoSuchUsername.Visible = false;
panel1.Visible = true;
}
if (usernameSearch == null)
{
lblNoSuchUsername.Visible = true;
txtSearchUsername.Text = "";
}
}
}
catch (EntityException ex)
{
MessageBox.Show("Could not search the database for the requested username." + ex.Message);
}
catch (Exception ex)
{
MessageBox.Show("Error when searching database." + ex.Message + ex.InnerException);
}
}
public void btnSave_Click(object sender, EventArgs e)
{
try
{
using (GlossaryAdminModel dbConnection = new GlossaryAdminModel())
{
var selectedUser = (from u in dbConnection.User
where u.Id == UserId
select u).FirstOrDefault();
if (selectedUser != null)
{
selectedUser.Username = txtUsername.Text;
selectedUser.Firstname = txtFirstname.Text;
selectedUser.Lastname = txtLastname.Text;
selectedUser.Email = txtEmail.Text;
selectedUser.RoleId = cbRole.SelectedIndex;
dbConnection.SaveChanges();
}
}
}
catch (EntityException ex)
{
MessageBox.Show("Could not save the user to database." + ex.Message);
}
catch (Exception ex)
{
MessageBox.Show("Error when saving to Database." + ex.Message + ex.InnerException);
}
finally
{
showFirstPage();
}
}
