private void addInvoiceButton_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); try { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); openFileDialog.Title = "Wybierz plik PDF z fakturą"; openFileDialog.ShowDialog(); File.Copy(openFileDialog.FileName, dbds.path + "\\" + openFileDialog.SafeFileName); invoicesListBox.Items.Clear(); string[] filePaths = Directory.GetFiles(dbds.path + "\\"); foreach (string asd in filePaths) { invoicesListBox.Items.Add(asd); } logWriting logWriting = new logWriting("Użytkownik dodał fakturę."); } catch (IOException ioex) { MessageBox.Show("Plik o danej nazwie już istnieje!", "Plik nie został dodany!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void modifyOrderButton_Click(object sender, EventArgs e) { if (ordersListBox.SelectedItems.Count < 1) { MessageBox.Show("Aby móc zmodyfikować pozycję, najpierw musisz jakąś wybrać.", "Nie wybrano pozycji", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var client = clientTextBox.Text; var itemname = itemNameTextBox.Text; var amount = int.Parse(amountTextBox.Text); var date = dateTextBox.Text; 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); dBConnection.UpdateOrders(id, client, itemname, amount, date); ordersListBox.Items.Clear(); List <string>[] list = dBConnection.CheckOrders(); var index = 0; foreach (var item in list[0]) { ordersListBox.Items.Add(list[1].ElementAt(index).ToString() + " | " + list[2].ElementAt(index).ToString() + " | " + list[3].ElementAt(index).ToString() + " | " + list[4].ElementAt(index).ToString()); index++; } logWriting logWriting = new logWriting("Użytkownik zmodyfikował istniejące zamówienie."); } }
private void modifyEmployeeButton_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 fathersName = fathersNameTextBox.Text; string mothersName = mothersNameTextBox.Text; string birthday = birthdayTextBox.Text; string placeOfResidence = placeOfResidenceTextBox.Text; string correspondenceAddress = correspondenceAddressTextBox.Text; string education = educationTextBox.Text; string historyOfEmployment = historyOfEmploymentTextBox.Text; int pesel = int.Parse(peselTextBox.Text); string childrensNames = childrensNamesTextBox.Text; string childrensBirthdays = childrensBirthdaysTextBox.Text; dBConnection.UpdateEmployee(firstName, lastName, fathersName, mothersName, birthday, placeOfResidence, correspondenceAddress, education, historyOfEmployment, pesel, childrensNames, childrensBirthdays, id); logWriting logWriting = new logWriting("Użytkownik zmodyfikował pracownika."); employeesListBox.Items.Clear(); List <string>[] list = dBConnection.EmployeesList(); var index = 0; foreach (var item in list[3]) { employeesListBox.Items.Add(list[0].ElementAt(index).ToString() + " " + list[1].ElementAt(index).ToString()); index++; } }
private void modifyExistingItemButton_Click(object sender, EventArgs e) { if (inventoryListBox.SelectedItems.Count < 1) { MessageBox.Show("Musisz wybrać jedną pozycję, aby móc ją edytować.", "Nie wybrano żadnej pozycji", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var inventoryCode = inventoryCodeTextBox.Text; var name = nameTextBox.Text; var amount = int.Parse(amountTextBox.Text); 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); dBConnection.UpdateInventory(id, inventoryCode, name, amount); inventoryListBox.Items.Clear(); List <string>[] list = dBConnection.CheckInventory(); var index = 0; foreach (var item in list[0]) { inventoryListBox.Items.Add(list[1].ElementAt(index).ToString() + " | " + list[2].ElementAt(index).ToString() + " | " + list[3].ElementAt(index).ToString()); index++; } logWriting logWriting = new logWriting("Użytkownik zmodyfikował przedmiot w magazynie."); } }
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 modifyProductionButton_Click(object sender, EventArgs e) { var item = itemTextBox.Text; var amount = int.Parse(amountTextBox.Text); var position = positionTextBox.Text; var date = dateTextBox.Text; 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); dBConnection.UpdateProductionPlan(id, item, amount, position, date); planListBox.Items.Clear(); List <string>[] list = dBConnection.CheckProductionPlan(); var index = 0; foreach (var i in list[0]) { planListBox.Items.Add(list[1].ElementAt(index).ToString() + " | " + list[2].ElementAt(index).ToString() + " | " + list[3].ElementAt(index).ToString() + " | " + list[4].ElementAt(index).ToString()); index++; } logWriting logWriting = new logWriting("Użytkownik zmodyfikował istniejącą produkcję."); }
private void removeItemButton_Click(object sender, EventArgs e) { if (inventoryListBox.SelectedItems.Count < 1) { MessageBox.Show("Musisz wybrać jedną pozycję, aby móc ją usunąć.", "Nie wybrano żadnej pozycji", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { DialogResult dialogResult = MessageBox.Show("Czy na pewno chcesz usunąć wybraną pozycję?", "Usunięcie pozycji", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (dialogResult == DialogResult.Yes) { 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); dBConnection.DeleteInventoryPosition(id); inventoryListBox.Items.Clear(); List <string>[] list = dBConnection.CheckInventory(); var index = 0; foreach (var item in list[0]) { inventoryListBox.Items.Add(list[1].ElementAt(index).ToString() + " | " + list[2].ElementAt(index).ToString() + " | " + list[3].ElementAt(index).ToString()); index++; } logWriting logWriting = new logWriting("Użytkownik usunął przedmiot z magazynu."); } } }
private void existingAccountsListBox_SelectedIndexChanged(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); List <string>[] list = dBConnection.CheckLogin(); id = list[8].ElementAt(existingAccountsListBox.SelectedIndex).ToString(); }
private void financialOperationsListBox_SelectedIndexChanged(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); List <string>[] list = dBConnection.CheckFinancialOperations(); receiverTextBox.Text = list[0].ElementAt(financialOperationsListBox.SelectedIndex).ToString(); amountTextBox.Text = list[1].ElementAt(financialOperationsListBox.SelectedIndex).ToString(); categoryTextBox.Text = list[2].ElementAt(financialOperationsListBox.SelectedIndex).ToString(); id = list[3].ElementAt(financialOperationsListBox.SelectedIndex).ToString(); }
public invoicesForm() { InitializeComponent(); IFormatter formatter = new BinaryFormatter(); Stream stream = new FileStream("conf.bin", FileMode.Open, FileAccess.Read); DBDataSerialization dbds = (DBDataSerialization)formatter.Deserialize(stream); string[] filePaths = Directory.GetFiles(dbds.path + "\\"); foreach (string asd in filePaths) { invoicesListBox.Items.Add(asd); } }
private void inventoryListBox_SelectedIndexChanged(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); List <string>[] list = dBConnection.CheckInventory(); id = int.Parse(list[0].ElementAt(inventoryListBox.SelectedIndex)); inventoryCodeTextBox.Text = list[1].ElementAt(inventoryListBox.SelectedIndex).ToString(); nameTextBox.Text = list[2].ElementAt(inventoryListBox.SelectedIndex).ToString(); amountTextBox.Text = list[3].ElementAt(inventoryListBox.SelectedIndex).ToString(); }
public editCompanyDetailsForm() { InitializeComponent(); 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); List <string>[] list = dBConnection.CheckCompany(); companyNameTextBox.Text = list[1].ElementAt(0); companyNIPTextBox.Text = list[2].ElementAt(0); companyREGONTextBox.Text = list[3].ElementAt(0); companyKRSTextBox.Text = list[4].ElementAt(0); }
private void removeInvoiceButton_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); File.Delete(invoicesListBox.SelectedItem.ToString()); invoicesListBox.Items.Clear(); string[] filePaths = Directory.GetFiles(dbds.path + "\\"); foreach (string asd in filePaths) { invoicesListBox.Items.Add(asd); } logWriting logWriting = new logWriting("Użytkownik usunął fakturę."); }
private void modifyButton_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 companyName = companyNameTextBox.Text; int companyNIP = int.Parse(companyNIPTextBox.Text); int companyREGON = int.Parse(companyREGONTextBox.Text); int companyKRS = int.Parse(companyKRSTextBox.Text); dBConnection.UpdateCompanyDetails(1, companyName, companyNIP, companyREGON, companyKRS); logWriting logWriting = new logWriting("Użytkownik zmodyfikował dane firmy."); }
public void SerializeIt(string host, string name, string login, string password, string path) { DBDataSerialization dbds = new DBDataSerialization(); dbds.dbhost = host; dbds.dbname = name; dbds.dblogin = login; dbds.dbpassword = password; dbds.path = path; IFormatter formatter = new BinaryFormatter(); Stream stream = new FileStream("conf.bin", FileMode.Create, FileAccess.Write); formatter.Serialize(stream, dbds); stream.Close(); }
private void modifyFilesServerLocalisationButton_Click(object sender, EventArgs e) { folderBrowserDialog1.ShowDialog(); var path = folderBrowserDialog1.SelectedPath; IFormatter formatter = new BinaryFormatter(); Stream stream = new FileStream("conf.bin", FileMode.Open, FileAccess.Read); DBDataSerialization dbds = (DBDataSerialization)formatter.Deserialize(stream); var dbhost = dbds.dbhost; var dbname = dbds.dbname; var dblogin = dbds.dblogin; var dbpwd = dbds.dbpassword; stream.Close(); DBDataSerialization bwr = new DBDataSerialization(); bwr.SerializeIt(dbhost, dbname, dblogin, dbpwd, path); }
private void existingAccountsListBox_SelectedIndexChanged(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); List <string>[] list = dBConnection.CheckLogin(); firstNameTextBox.Text = list[3].ElementAt(existingAccountsListBox.SelectedIndex).ToString(); lastNameTextBox.Text = list[4].ElementAt(existingAccountsListBox.SelectedIndex).ToString(); loginTextBox.Text = list[0].ElementAt(existingAccountsListBox.SelectedIndex).ToString(); passwordTextBox.Text = list[1].ElementAt(existingAccountsListBox.SelectedIndex).ToString(); emailAddressTextBox.Text = list[5].ElementAt(existingAccountsListBox.SelectedIndex).ToString(); birthdayTextBox.Text = list[7].ElementAt(existingAccountsListBox.SelectedIndex).ToString(); employmentTextBox.Text = list[6].ElementAt(existingAccountsListBox.SelectedIndex).ToString(); id = list[8].ElementAt(existingAccountsListBox.SelectedIndex).ToString(); }
public deleteAccountForm() { 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); InitializeComponent(); 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 financialOperationsForm_Activated(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); financialOperationsListBox.Items.Clear(); List <string>[] list = dBConnection.CheckFinancialOperations(); var index = 0; foreach (var item in list[0]) { financialOperationsListBox.Items.Add(list[0].ElementAt(index).ToString()); index++; } }
public generateFilesSingleForm() { 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); InitializeComponent(); List <string>[] list = dBConnection.EmployeesList(); var index = 0; foreach (var item in list[0]) { employeesListBox.Items.Add(list[0].ElementAt(index).ToString() + " " + list[1].ElementAt(index).ToString()); index++; } }
private void addNewOrderButton_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(clientTextBox.Text)) { MessageBox.Show("Pole klient nie może być puste. Proszę o poprawienie.", "Puste pole klient", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (string.IsNullOrWhiteSpace(itemNameTextBox.Text)) { MessageBox.Show("Pole nazwa nie może być puste. Proszę o poprawienie.", "Puste pole nazwa", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (string.IsNullOrWhiteSpace(amountTextBox.Text)) { MessageBox.Show("Pole ilość nie może być puste. Proszę o poprawienie.", "Puste pole ilość", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (string.IsNullOrWhiteSpace(dateTextBox.Text)) { MessageBox.Show("Pole data nie może być puste. Proszę o poprawienie.", "Puste pole data", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (!int.TryParse(amountTextBox.Text, out var test)) { var client = clientTextBox.Text; var itemname = itemNameTextBox.Text; var amount = int.Parse(amountTextBox.Text); var date = dateTextBox.Text; 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); dBConnection.InsertNewOrder(client, itemname, amount, date); ordersListBox.Items.Clear(); List <string>[] list = dBConnection.CheckOrders(); var index = 0; foreach (var item in list[0]) { ordersListBox.Items.Add(list[1].ElementAt(index).ToString() + " | " + list[2].ElementAt(index).ToString() + " | " + list[3].ElementAt(index).ToString() + " | " + list[4].ElementAt(index).ToString()); index++; } logWriting logWriting = new logWriting("Użytkownik dodał nowe zamówienie."); } }
private void addNewProductionButton_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(itemTextBox.Text)) { MessageBox.Show("Pole przedmiot nie może być puste. Proszę o poprawienie.", "Puste pole przedmiot", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (string.IsNullOrWhiteSpace(amountTextBox.Text)) { MessageBox.Show("Pole ilość nie może być puste. Proszę o poprawienie.", "Puste pole ilość", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (string.IsNullOrWhiteSpace(positionTextBox.Text)) { MessageBox.Show("Pole gdzie nie może być puste. Proszę o poprawienie.", "Puste pole gdzie", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (string.IsNullOrWhiteSpace(dateTextBox.Text)) { MessageBox.Show("Pole kiedy nie może być puste. Proszę o poprawienie.", "Puste pole kiedy", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (!int.TryParse(amountTextBox.Text, out var test)) { var item = itemTextBox.Text; var amount = int.Parse(amountTextBox.Text); var position = positionTextBox.Text; var date = dateTextBox.Text; 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); dBConnection.InsertNewProduction(item, amount, position, date); planListBox.Items.Clear(); List <string>[] list = dBConnection.CheckProductionPlan(); var index = 0; foreach (var i in list[0]) { planListBox.Items.Add(list[1].ElementAt(index).ToString() + " | " + list[2].ElementAt(index).ToString() + " | " + list[3].ElementAt(index).ToString() + " | " + list[4].ElementAt(index).ToString()); index++; } logWriting logWriting = new logWriting("Użytkownik dodał nową produkcję."); } }
private void addOperationButton_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); if (string.IsNullOrWhiteSpace(receiverTextBox.Text)) { MessageBox.Show("Pole odbiorca nie może być puste. Proszę o uzupełnienie.", "Puste pole odbiorca", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (string.IsNullOrWhiteSpace(amountTextBox.Text)) { MessageBox.Show("Pole wartość nie może być puste. Proszę o uzupełnienie.", "Puste pole wartość", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (string.IsNullOrWhiteSpace(categoryTextBox.Text)) { MessageBox.Show("Pole kategoria nie może być puste. Proszę o uzupełnienie.", "Puste pole kategoria", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (!int.TryParse(amountTextBox.Text, out var test)) { MessageBox.Show("Pole wartość musi być liczbą. Proszę o poprawienie.", "Błędna zawartość pola wartość", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (dBConnection.ConnectionTest()) { //List<string>[] list = dBConnection.CheckFinancialOperations(); var receiver = receiverTextBox.Text; var amount = amountTextBox.Text; var category = categoryTextBox.Text; dBConnection.InsertNewFinancialOperation(receiver, amount, category); logWriting logWriting = new logWriting("Użytkownik dodał nową operację finansową."); financialOperationsListBox.Items.Clear(); List <string>[] list = dBConnection.CheckFinancialOperations(); var index = 0; foreach (var item in list[0]) { financialOperationsListBox.Items.Add(list[0].ElementAt(index).ToString()); index++; } } }
private void deleteProductionButton_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); dBConnection.DeleteProduction(id); planListBox.Items.Clear(); List <string>[] list = dBConnection.CheckProductionPlan(); var index = 0; foreach (var item in list[0]) { planListBox.Items.Add(list[1].ElementAt(index).ToString() + " | " + list[2].ElementAt(index).ToString() + " | " + list[3].ElementAt(index).ToString() + " | " + list[4].ElementAt(index).ToString()); index++; } logWriting logWriting = new logWriting("Użytkownik usunął produkcję."); }
private void removeOperationButton_Click(object sender, EventArgs e) { var isSure = false; if (MessageBox.Show("Czy napewno chcesz usunąć wpis?", "Usuwanie wpisu", MessageBoxButtons.YesNo) == DialogResult.Yes) { 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); dBConnection.DeleteFinancialOperation(id); financialOperationsListBox.Items.Clear(); List <string>[] list = dBConnection.CheckFinancialOperations(); var index = 0; foreach (var item in list[3]) { financialOperationsListBox.Items.Add(list[0].ElementAt(index).ToString()); index++; } logWriting logWriting = new logWriting("Użytkownik usunął operację finansową."); } }
private void employeesListBox_SelectedIndexChanged(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); List <string>[] list = dBConnection.EmployeesList(); firstNameTextBox.Text = list[0].ElementAt(employeesListBox.SelectedIndex).ToString(); lastNameTextBox.Text = list[1].ElementAt(employeesListBox.SelectedIndex).ToString(); fathersNameTextBox.Text = list[2].ElementAt(employeesListBox.SelectedIndex).ToString(); mothersNameTextBox.Text = list[3].ElementAt(employeesListBox.SelectedIndex).ToString(); birthdayTextBox.Text = list[4].ElementAt(employeesListBox.SelectedIndex).ToString(); placeOfResidenceTextBox.Text = list[5].ElementAt(employeesListBox.SelectedIndex).ToString(); correspondenceAddressTextBox.Text = list[6].ElementAt(employeesListBox.SelectedIndex).ToString(); educationTextBox.Text = list[7].ElementAt(employeesListBox.SelectedIndex).ToString(); historyOfEmploymentTextBox.Text = list[8].ElementAt(employeesListBox.SelectedIndex).ToString(); peselTextBox.Text = list[9].ElementAt(employeesListBox.SelectedIndex).ToString(); childrensNamesTextBox.Text = list[10].ElementAt(employeesListBox.SelectedIndex).ToString(); childrensBirthdaysTextBox.Text = list[11].ElementAt(employeesListBox.SelectedIndex).ToString(); id = int.Parse(list[12].ElementAt(employeesListBox.SelectedIndex).ToString()); }
private void deleteAccountButton_Click(object sender, EventArgs e) { var isSure = false; if (MessageBox.Show("Czy napewno chcesz usunąć konto?", "Usuwanie konta", MessageBoxButtons.YesNo) == DialogResult.Yes) { 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); List <string>[] list2 = dBConnection.CheckLogin(); logWriting logWriting = new logWriting("Użytkownik usunął konto - " + list2[0].ElementAt(existingAccountsListBox.SelectedIndex).ToString()); dBConnection.Delete(id); 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 restoreEmployeeButton_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); dBConnection.InsertNewEmployee(firstName, lastName, fathersName, mothersName, birthday, placeOfResidence, correspondenceAddress, education, historyOfEmployment, pesel, childrensNames, childrensBirthdays); List <string>[] list2 = dBConnection.DeletedEmployeesList(); logWriting logWriting = new logWriting("Użytkownik przywrócił pracownika - " + list2[0].ElementAt(employeesListBox.SelectedIndex)); dBConnection.DeleteFromDeletedEmployees(id); employeesListBox.Items.Clear(); List <string>[] list = dBConnection.DeletedEmployeesList(); var index = 0; foreach (var item in list[0]) { employeesListBox.Items.Add(list[0].ElementAt(index).ToString() + " " + list[1].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); } } }