private void BtnSaveDB_Click(object sender, RoutedEventArgs e)
{
DataBaseType db = DataBaseType.None;
if ((bool)rbtDB.IsChecked)
{
db = DataBaseType.Principal;
}
else if ((bool)rbtTest.IsChecked)
{
db = DataBaseType.Test;
}
if (db == DataBaseType.None)
{
new MessageBoxCustom("Please select a DB", MessageType.Warning, MessageButtons.Ok).ShowDialog();
}
else
{
if (SqlDal_MasterDB.UpdateSelectedDB(db))
{
new MessageBoxCustom("Saved !!", MessageType.Success, MessageButtons.Ok).ShowDialog();
}
else
{
new MessageBoxCustom("Error during saving DB Info", MessageType.Error, MessageButtons.Ok).ShowDialog();
}
}
}
private void BtnLogin_Click(object sender, RoutedEventArgs e)
{
if (!_connectionAvailable)
{
new MessageBoxCustom("Unavailable DB Connection", MessageType.Error, MessageButtons.Ok).ShowDialog();
return;
}
if (txtBoxUsername.Text == "")
{
new MessageBoxCustom("User Name cannot be empty", MessageType.Warning, MessageButtons.Ok).ShowDialog();
}
else if (txtBoxPassword.Password == "")
{
new MessageBoxCustom("Password cannot be empty", MessageType.Warning, MessageButtons.Ok).ShowDialog();
}
else
{
StringBuilder sb = EncryptionHelper.GetEncryptedPassword(txtBoxPassword.Password);
var currentUser = SqlDal_MasterDB.CheckLogin(txtBoxUsername.Text);
if (currentUser == null)
{
new MessageBoxCustom("Username not valid", MessageType.Error, MessageButtons.Ok).ShowDialog();
}
else if (sb.ToString().ToUpper() != currentUser.Password)
{
new MessageBoxCustom("Uncorrect Password", MessageType.Error, MessageButtons.Ok).ShowDialog();
}
else if (!currentUser.IsEnabled)
{
new MessageBoxCustom("The user '" + txtBoxUsername.Text + "' is not active", MessageType.Warning, MessageButtons.Ok).ShowDialog();
}
else if (currentUser.Type == ProfileType.None)
{
new MessageBoxCustom("The user '" + txtBoxUsername.Text + "' is not allowed due its privileges", MessageType.Warning, MessageButtons.Ok).ShowDialog();
}
else
{
var main = new MainWindow(currentUser);
main.Show();
this.Close();
}
}
}
private void LoadSelectedDatabase()
{
DataBaseType db = SqlDal_MasterDB.GetSelectedDB();
switch (db)
{
case DataBaseType.Principal:
rbtDB.IsChecked = true;
break;
case DataBaseType.Test:
rbtTest.IsChecked = true;
break;
default:
break;
}
}
private void BtnSaveAccount_Click(object sender, RoutedEventArgs e)
{
if (txtUserName.Text == "")
{
new MessageBoxCustom("User Name cannot be empty", MessageType.Warning, MessageButtons.Ok).ShowDialog();
}
else if (txtPassword.Password == "")
{
new MessageBoxCustom("Password cannot be empty", MessageType.Warning, MessageButtons.Ok).ShowDialog();
}
else if ((ProfileType)cmbAccountType.SelectedValue == ProfileType.None)
{
new MessageBoxCustom("Choose a valid Account Type", MessageType.Warning, MessageButtons.Ok).ShowDialog();
}
else
{
if (SqlDal_MasterDB.CheckIfAccountExist(txtUserName.Text) > 0)
{
new MessageBoxCustom("User name already exist", MessageType.Warning, MessageButtons.Ok).ShowDialog();
}
else
{
StringBuilder sb = EncryptionHelper.GetEncryptedPassword(txtPassword.Password);
var newId = SqlDal_MasterDB.AddNewAccount(txtUserName.Text, sb.ToString(), (ProfileType)cmbAccountType.SelectedValue);
if (newId < 0)
{
new MessageBoxCustom("Account not created", MessageType.Error, MessageButtons.Ok).ShowDialog();
}
else
{
txtUserName.Text = "";
txtPassword.Password = "";
cmbAccountType.SelectedValue = ProfileType.None;
//referesh user lsit
LoadUsersList();
new MessageBoxCustom("Account correctly created", MessageType.Success, MessageButtons.Ok).ShowDialog();
}
}
}
}
private void BtnDeleteAccount_Click(object sender, RoutedEventArgs e)
{
LoginUser userToDelete = ((FrameworkElement)sender).DataContext as LoginUser;
if (System.Windows.Forms.MessageBox.Show("Are you sure you want to delete '" + userToDelete.UserName + "' user account?",
"Warning",
System.Windows.Forms.MessageBoxButtons.OKCancel,
System.Windows.Forms.MessageBoxIcon.Warning) == System.Windows.Forms.DialogResult.OK)
{
if (SqlDal_MasterDB.DeleteUserAccount(userToDelete.UserName))
{
LoadUsersList();
new MessageBoxCustom("User " + userToDelete.UserName + " deleted ", MessageType.Success, MessageButtons.Ok).ShowDialog();
}
else
{
new MessageBoxCustom("ERROR occurred: no User deleted", MessageType.Error, MessageButtons.Ok).ShowDialog();
}
}
}
private void LoadUsersList()
{
var accountList = SqlDal_MasterDB.GetAccountList();
dataGridAccount.ItemsSource = accountList;
}
