private void modifyAccountButton_Click(object sender, EventArgs e)
{
IFormatter formatter = new BinaryFormatter();
Stream stream = new FileStream("conf.bin", FileMode.Open, FileAccess.Read);
DBDataSerialization dbds = (DBDataSerialization)formatter.Deserialize(stream);
DBConnection dBConnection = new DBConnection(dbds.dbhost, dbds.dbname, dbds.dblogin, dbds.dbpassword);
string firstName = firstNameTextBox.Text;
string lastName = lastNameTextBox.Text;
string login = loginTextBox.Text;
string emailAddress = emailAddressTextBox.Text;
string birthday = birthdayTextBox.Text;
string employmentMonth = employmentTextBox.Text;
PwdEncryption pwde = new PwdEncryption();
string password = pwde.GenerateHash(passwordTextBox.Text);
string pwdhash = File.ReadAllText("salt.txt");
File.Delete("salt.txt");
dBConnection.Update(firstName, lastName, birthday, login, employmentMonth, emailAddress, password, pwdhash, id);
logWriting logWriting = new logWriting("Użytkownik zmodyfikował konto.");
existingAccountsListBox.Items.Clear();
List <string>[] list = dBConnection.CheckLogin();
var index = 0;
foreach (var item in list[3])
{
existingAccountsListBox.Items.Add(list[3].ElementAt(index).ToString() + " " + list[4].ElementAt(index).ToString());
index++;
}
}
private void installButton_Click(object sender, EventArgs e)
{
string adminLogin = adminLoginTextBox.Text;
string adminFirstName = adminFirstNameTextBox.Text;
string adminLastName = adminLastNameTextBox.Text;
string adminEmail = adminEmailTextBox.Text;
string databaseHost = databaseHostTextBox.Text;
string databasePassword = databasePasswordTextBox.Text;
string databaseName = databaseNameTextBox.Text;
string databaseLogin = databaseLoginTextBox.Text;
var dayOfBirth = adminBirthdayDatePicker.Value.Day.ToString();
var monthOfBirth = adminBirthdayDatePicker.Value.Month.ToString();
var yearOfBirth = adminBirthdayDatePicker.Value.Year.ToString();
var adminBirthday = dayOfBirth + "/" + monthOfBirth + "/" + yearOfBirth;
var workgroup = "administrator";
var monthOfEmployment = employmentMonthDatePicker.Value.Month.ToString();
progressBar.Visible = true;
progressBar.Value = 0;
DBConnection dBConnection = new DBConnection(databaseHost, databaseName, databaseLogin, databasePassword);
if (!dBConnection.ConnectionTest())
{
databaseHostTextBox.Text = null;
databasePasswordTextBox.Text = null;
databaseNameTextBox.Text = null;
databaseLoginTextBox.Text = null;
progressBar.Value = 0;
}
else if (string.IsNullOrWhiteSpace(adminLoginTextBox.Text))
{
MessageBox.Show("Login administratora nie może być pusty!", "Pusty login administratora", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(adminPasswordTextBox.Text))
{
MessageBox.Show("Hasło administratora nie może być puste!", "Puste hasło administratora", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(adminFirstNameTextBox.Text))
{
MessageBox.Show("Imię administratora nie może być puste!", "Puste imię administratora", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(adminLastNameTextBox.Text))
{
MessageBox.Show("Nazwisko administratora nie może być puste!", "Puste nazwisko administratora", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(adminEmailTextBox.Text))
{
MessageBox.Show("Adres e-mail administratora nie może być pusty!", "Pusty adres e-mail administratora", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(databaseHostTextBox.Text))
{
MessageBox.Show("Host bazy danych nie może być pusty!", "Pusty host bazy danych", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(databasePasswordTextBox.Text))
{
MessageBox.Show("Hasło do bazy danych nie może być puste!", "Puste hasło do bazy danych", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(databaseNameTextBox.Text))
{
MessageBox.Show("Nazwa bazy danych nie może być pusta!", "Pusta nazwa bazy danych", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(databaseLoginTextBox.Text))
{
MessageBox.Show("Login do bazy danych nie może być pusty!", "Pusty login do bazy danych", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(companyNameTextBox.Text))
{
MessageBox.Show("Nazwa firmy nie może być pusta!", "Pusta nazwa firmy", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(companyNIPTextBox.Text))
{
MessageBox.Show("NIP nie może być pusty!", "Pusty NIP", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(companyREGONTextBox.Text))
{
MessageBox.Show("REGON nie może być pusty!", "Pusty REGON", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(companyKRSTextBox.Text))
{
MessageBox.Show("KRS nie może być pusty!", "Pusty KRS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
createTable();
dBConnection.CreateTable();
PwdEncryption pwde = new PwdEncryption();
string adminPassword = pwde.GenerateHash(adminPasswordTextBox.Text);
string adminPwdSalt = File.ReadAllText("salt.txt");
File.Delete("salt.txt");
insertDataIntoSQLFiles(adminLogin, adminPassword, adminPwdSalt, adminFirstName, adminLastName, adminEmail, adminBirthday, workgroup, monthOfEmployment);
dBConnection.CreateAdmin();
progressBar.Value = 20;
var companyName = companyNameTextBox.Text;
var companyNIP = long.Parse(companyNIPTextBox.Text);
var companyREGON = long.Parse(companyREGONTextBox.Text);
var companyKRS = long.Parse(companyKRSTextBox.Text);
dBConnection.InsertNewCompany(companyName, companyNIP, companyREGON, companyKRS);
progressBar.Value = 75;
DBDataSerialization bwr = new DBDataSerialization();
bwr.SerializeIt(databaseHostTextBox.Text, databaseNameTextBox.Text, databaseLoginTextBox.Text, databasePasswordTextBox.Text, path);
progressBar.Value = 100;
MessageBox.Show("Wszystko w porządku. Można używać programu.", "OK");
loginForm loginForm = new loginForm();
loginForm.Show();
loginForm.Activate();
this.Hide();
}
}
private void loginButton_Click(object sender, EventArgs e)
{
IFormatter formatter = new BinaryFormatter();
Stream stream = new FileStream("conf.bin", FileMode.Open, FileAccess.Read);
DBDataSerialization dbds = (DBDataSerialization)formatter.Deserialize(stream);
stream.Close();
DBConnection dBConnection = new DBConnection(dbds.dbhost, dbds.dbname, dbds.dblogin, dbds.dbpassword);
loginForLogs = loginTextBox.Text;
string login = loginTextBox.Text;
PwdEncryption pwde = new PwdEncryption();
if (string.IsNullOrWhiteSpace(loginTextBox.Text))
{
MessageBox.Show("Login nie może być pusty!", "Pusty login", MessageBoxButtons.OK, MessageBoxIcon.Error);
loginTextBox.Clear();
}
else if (string.IsNullOrWhiteSpace(passwordTextBox.Text))
{
MessageBox.Show("Hasło nie może być puste!", "Puste hasło", MessageBoxButtons.OK, MessageBoxIcon.Error);
loginTextBox.Clear();
}
else if (dBConnection.ConnectionTest())
{
List <string>[] list = dBConnection.CheckLogin();
var indexOfLogin = 0;
bool loginSuccessfull = false;
foreach (string loginInList in list[0])
{
if (loginInList == login)
{
loginSuccessfull = true;
break;
}
indexOfLogin++;
}
if (loginSuccessfull)
{
string pwdhash = dBConnection.GetPwdHash(login);
byte[] salt = Convert.FromBase64String(pwdhash);
string adminPassword = pwde.GenerateHashOnLogin(passwordTextBox.Text, salt);
logWriting logWriting = new logWriting("Użytkownik się zalogował.");
var passwordFromDb = list[1].ElementAt(indexOfLogin);
var workgroupFromDb = list[2].ElementAt(indexOfLogin);
if (passwordFromDb == adminPassword)
{
switch (workgroupFromDb)
{
case "owner":
{
ownerForm ownerForm = new ownerForm();
ownerForm.Show();
this.Hide();
break;
}
case "hr":
{
hrForm hrForm = new hrForm();
hrForm.Show();
this.Hide();
break;
}
case "finances":
{
financesForm financesForm = new financesForm();
financesForm.Show();
this.Hide();
break;
}
case "logistics":
{
logisticsForm logisticsForm = new logisticsForm();
logisticsForm.Show();
this.Hide();
break;
}
case "production":
{
productionForm productionForm = new productionForm();
productionForm.Show();
this.Hide();
break;
}
case "administrator":
{
configurationForm configurationForm = new configurationForm();
configurationForm.Show();
this.Hide();
break;
}
}
}
else
{
MessageBox.Show("Wprowadź poprawne hasło!", "Złe hasło", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Wprowadź poprawny login!", "Niepoprawny login", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void registerNewAccountButton_Click(object sender, EventArgs e)
{
IFormatter formatter = new BinaryFormatter();
Stream stream = new FileStream("conf.bin", FileMode.Open, FileAccess.Read);
DBDataSerialization dbds = (DBDataSerialization)formatter.Deserialize(stream);
DBConnection dBConnection = new DBConnection(dbds.dbhost, dbds.dbname, dbds.dblogin, dbds.dbpassword);
string checkLogin = loginTextBox.Text;
bool isLoginUsed = false;
if (dBConnection.ConnectionTest())
{
List <string>[] list = dBConnection.CheckLogin();
string workgroup = "";
foreach (var item in list[0])
{
if (item == checkLogin)
{
MessageBox.Show("Login jest już w użyciu! Proszę wprowadzić inny login.", "Błąd dodawania użytkownika.");
isLoginUsed = true;
}
else
{
if (workgroupListBox.SelectedItems.Count > 0)
{
switch (workgroupListBox.SelectedItem.ToString())
{
case "Finanse i rachunkowość":
{
workgroup = "finances";
break;
}
case "Logistyka i magazyny":
{
workgroup = "logistics";
break;
}
case "Produkcja":
{
workgroup = "production";
break;
}
case "Właściciel":
{
workgroup = "owner";
break;
}
case "Zasoby ludzkie":
{
workgroup = "hr";
break;
}
default:
{
workgroup = "";
MessageBox.Show("Zła grupa robocza. Spróbuj jeszcze raz.");
break;
}
}
}
}
}
var dayOfBirth = birthdayDateTimePicker.Value.Day.ToString();
var monthOfBirth = birthdayDateTimePicker.Value.Month.ToString();
var yearOfBirth = birthdayDateTimePicker.Value.Year.ToString();
var firstName = firstNameTextBox.Text;
var lastName = lastNameTextBox.Text;
var birthday = dayOfBirth + "/" + monthOfBirth + "/" + yearOfBirth;
var login = loginTextBox.Text;
var employmentMonth = employmentMonthDatePicker.Value.Month.ToString();
var emailAddress = emailAddressTextBox.Text;
PwdEncryption pwde = new PwdEncryption();
string password = pwde.GenerateHash(passwordTextBox.Text);
string pwdhash = File.ReadAllText("salt.txt");
File.Delete("salt.txt");
if (string.IsNullOrWhiteSpace(firstNameTextBox.Text))
{
MessageBox.Show("Imię nie może być puste!", "Puste imię", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(lastNameTextBox.Text))
{
MessageBox.Show("Nazwisko nie może być puste!", "Puste nazwisko", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(loginTextBox.Text))
{
MessageBox.Show("Login nie może być pusty!", "Puste imię administratora", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(passwordTextBox.Text))
{
MessageBox.Show("Hasło nie może być puste!", "Puste hasło administratora", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (string.IsNullOrWhiteSpace(emailAddressTextBox.Text))
{
MessageBox.Show("Adres e-mail nie może być pusty!", "Pusty adres e-mail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (!isLoginUsed)
{
dBConnection.InsertNewAccount(firstName, lastName, birthday, workgroup, login, password, pwdhash, employmentMonth, emailAddress);
MessageBox.Show("Konto utworzone poprawnie.", "Tworzenie konta", MessageBoxButtons.OK, MessageBoxIcon.Information);
logWriting logWriting = new logWriting("Użytkownik dodał nowe konto - " + login);
firstNameTextBox.Text = "";
lastNameTextBox.Text = "";
loginTextBox.Text = "";
passwordTextBox.Text = "";
emailAddressTextBox.Text = "";
workgroupListBox.ClearSelected();
}
}
}
