protected override void okButton_Click(object sender, EventArgs e) { if (listView1.Items.Count == 0) { MessageBox.Show("Nie wybrano żadnych produktów"); } else { string price = priceTextBox.Text.Substring(0, priceTextBox.Text.IndexOf(' ')); int noOfOrder = (int)PostgreSQL.executeScalar("INSERT INTO zamowienie_dostawy(kod_dost, koszt, status) values(" + getSupplierId() + ",'" + price + "','" + statusComboBox.Text + "') " + "RETURNING nr_zamowienia" ); foreach (ListViewItem item in listView1.Items) { PostgreSQL.executeCommand("INSERT INTO zamowienie_dostawy_zawiera_produkt values(" + item.SubItems[0].Text + "," + noOfOrder + "," + item.SubItems[2].Text + ")" ); PostgreSQL.executeScalar("UPDATE dostawca_dostarcza_produkt SET " + "max_ilosc=max_ilosc-" + item.SubItems[2].Text + " " + "WHERE kod_dost=" + getSupplierId() + " " + "AND kod_prod=" + item.SubItems[0].Text ); } } this.Close(); }
protected override void okButton_Click(object sender, EventArgs e) { string newStatus = statusComboBox.Text; if (newStatus == "Opłacone") { newStatus = "Oplacone"; } else if (newStatus == "Wysłane") { newStatus = "Wyslane"; } if (newStatus == "Skompletowane" || newStatus == "Wyslane") { if (haveEnoughProducts()) { foreach (ListViewItem i in listView1.Items) { PostgreSQL.executeCommand("UPDATE produkt SET ilosc=ilosc-" + i.SubItems[2].Text + " WHERE kod_prod=" + i.SubItems[0].Text); } PostgreSQL.executeCommand("UPDATE zamowienie_detaliczne SET status='" + newStatus + "' WHERE nr_zamowienia=" + orderId); this.Close(); } else { MessageBox.Show("W magazynie nie ma wystarczającej ilości produktów"); } } else { PostgreSQL.executeCommand("UPDATE zamowienie_detaliczne SET status='" + newStatus + "' WHERE nr_zamowienia=" + orderId); this.Close(); } }
private void removeProductButton_Click(object sender, EventArgs e) { if (listView1.SelectedItems.Count > 0) { PostgreSQL.executeCommand("DELETE FROM produkt WHERE kod_prod=" + listView1.SelectedItems[0].Text); updateListView1(); } }
private void loginButton_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(loginTextBox.Text) || string.IsNullOrWhiteSpace(loginTextBox.Text) || string.IsNullOrEmpty(passwordTextBox.Text) || string.IsNullOrWhiteSpace(passwordTextBox.Text)) { MessageBox.Show("Login i hasło nie mogą być puste!"); } else { try { int.Parse(loginTextBox.Text); NpgsqlDataReader reader = PostgreSQL.executeCommand("SELECT haslo, typuzytkownika FROM uzytkownik WHERE kod_uz=" + loginTextBox.Text); reader.Read(); byte[] password = (byte[])reader[0]; string userType = reader[1].ToString(); HashAlgorithm alg = SHA1.Create(); byte[] passwordHash = alg.ComputeHash(Encoding.UTF8.GetBytes(passwordTextBox.Text)); reader.Close(); if (!passwordIsGood(password, passwordHash)) { MessageBox.Show("Błąd logowania, zły login lub hasło"); } else { this.Hide(); if (userType == "Admin") { AdminWindow window = new AdminWindow(); window.ShowDialog(); } else if (userType == "Uzytkownik") { UserWindow window = new UserWindow(int.Parse(loginTextBox.Text)); window.ShowDialog(); } else { EmployeeWindow window = new EmployeeWindow(); window.ShowDialog(); } this.Close(); } } catch (FormatException ex) { MessageBox.Show("Zabronione znaki w polu ID (" + ex.Message + ")"); } catch (InvalidOperationException ex) { MessageBox.Show("Nie ma w bazie użytkownika o podanym numerze ID (" + ex.Message + ")"); } } }
public ClientOrderDetails(ListViewItem item) { orderId = int.Parse(item.SubItems[0].Text); oldStatus = item.SubItems[3].Text; InitializeComponent(); NpgsqlDataReader reader = PostgreSQL.executeCommand("SELECT * FROM uzytkownik WHERE kod_uz=" + item.SubItems[1].Text); while (reader.Read()) { clientComboBox.Items.Add(reader[0] + ". " + reader[1] + " " + reader[2]); } clientComboBox.SelectedIndex = 0; clientComboBox.Enabled = false; priceTextBox.Text = item.SubItems[2].Text; string status = item.SubItems[3].Text; if (status == "Nowe") { statusComboBox.Items.Add("Nowe"); statusComboBox.Items.Add("Oplacone"); statusComboBox.Items.Add("Skompletowane"); statusComboBox.Items.Add("Wyslane"); } else if (status == "Oplacone") { statusComboBox.Items.Add("Oplacone"); statusComboBox.Items.Add("Skompletowane"); statusComboBox.Items.Add("Wyslane"); } else if (status == "Skompletowane") { statusComboBox.Items.Add("Skompletowane"); statusComboBox.Items.Add("Wyslane"); } else { statusComboBox.Items.Add("Wyslane"); } statusComboBox.SelectedIndex = 0; reader = PostgreSQL.executeCommand("SELECT p.kod_prod, p.nazwa, z.ilosc, p.cena FROM zamowienie_detaliczne_zawiera_produkt z " + "JOIN produkt p USING(kod_prod) " + "WHERE nr_zamowienia=" + orderId ); while (reader.Read()) { ListViewItem i = listView1.Items.Add(new ListViewItem(reader[0].ToString())); i.SubItems.Add(reader[1].ToString()); i.SubItems.Add(reader[2].ToString()); i.SubItems.Add(((int)reader[2] * (double)reader[3]).ToString()); } addButton.Hide(); }
private void saveChangesButton_Click(object sender, EventArgs e) { PostgreSQL.executeCommand("UPDATE dostawca SET " + "nazwa='" + supplierNameTextBox.Text + "'," + "nr_konta=" + supplierAccountTextBox.Text + "WHERE kod_dost=" + supplierIdTextBox.Text ); this.Close(); }
private void removeProductButton_Click(object sender, EventArgs e) { if (listView1.SelectedItems.Count > 0) { ListViewItem item = listView1.SelectedItems[0]; PostgreSQL.executeCommand("DELETE FROM dostawca_dostarcza_produkt WHERE " + "kod_dost=" + supplierIdTextBox.Text + " AND kod_prod=" + item.SubItems[0].Text); updateListView(); } }
public UserWindow(int id) { InitializeComponent(); userId = id; chosenProducts = new Dictionary <int, int>(); NpgsqlDataReader reader = PostgreSQL.executeCommand("SELECT * FROM uzytkownik WHERE kod_uz=" + userId); reader.Read(); titleLabel.Text = reader[1] + " " + reader[2] + " "; reader.Close(); }
private void ClientOrdersWindow_Load(object sender, EventArgs e) { NpgsqlDataReader reader = PostgreSQL.executeCommand("SELECT * FROM zamowienie_detaliczne WHERE kod_uz=" + userId); while (reader.Read()) { ListViewItem item = listView1.Items.Add(new ListViewItem(reader[0].ToString())); item.SubItems.Add(reader[2].ToString()); item.SubItems.Add(reader[3].ToString()); item.SubItems.Add(reader[4].ToString()); } }
private void updateListView() { NpgsqlDataReader reader = PostgreSQL.executeCommand("SELECT * FROM produkt"); while (reader.Read()) { ListViewItem item = listView1.Items.Add(new ListViewItem(reader[0].ToString())); item.SubItems.Add(reader[3].ToString()); item.SubItems.Add(reader[2].ToString()); item.SubItems.Add(reader[1].ToString()); item.SubItems.Add(reader[4].ToString()); } }
private void updateListView1() { listView1.Items.Clear(); NpgsqlDataReader reader = PostgreSQL.executeCommand("SELECT * FROM produkt"); while (reader.Read()) { ListViewItem item = listView1.Items.Add(reader[0].ToString()); for (int i = 1; i < reader.FieldCount; ++i) { item.SubItems.Add(reader[i].ToString()); } } }
public DeliveryOrder_Details(ListViewItem order) { orderId = int.Parse(order.SubItems[0].Text); oldStatus = order.SubItems[3].Text; supplierComboBox.Items.Add(order.SubItems[1].Text + ". " + PostgreSQL.executeScalar("SELECT nazwa FROM dostawca WHERE kod_dost=" + order.SubItems[1].Text)); supplierComboBox.Enabled = false; supplierComboBox.SelectedIndex = 0; priceTextBox.Text = order.SubItems[2].Text; priceTextBox.Enabled = false; string status = order.SubItems[3].Text; if (status == "Nowe") { statusComboBox.Items.Add("Nowe"); statusComboBox.Items.Add("Opłacone"); statusComboBox.Items.Add("Otrzymane"); } else if (status == "Oplacone") { statusComboBox.Items.Add("Opłacone"); statusComboBox.Items.Add("Otrzymane"); } else { statusComboBox.Items.Add("Otrzymane"); } statusComboBox.SelectedIndex = 0; NpgsqlDataReader reader = PostgreSQL.executeCommand("SELECT kod_prod, nazwa, z.ilosc, d.cena_hurt " + "FROM zamowienie_dostawy_zawiera_produkt z " + "JOIN produkt p USING(kod_prod) " + "JOIN dostawca_dostarcza_produkt d USING(kod_prod) " + "WHERE nr_zamowienia=" + order.SubItems[0].Text + " " + "AND kod_dost=" + order.SubItems[1].Text ); while (reader.Read()) { ListViewItem item = listView1.Items.Add(new ListViewItem(reader[0].ToString())); item.SubItems.Add(reader[1].ToString()); item.SubItems.Add(reader[2].ToString()); item.SubItems.Add(((int)reader[2] * (double)reader[3]).ToString()); } addButton.Hide(); }
private void updateListView4() { listView4.Items.Clear(); NpgsqlDataReader reader = PostgreSQL.executeCommand("SELECT * FROM zamowienie_detaliczne"); while (reader.Read()) { ListViewItem item = listView4.Items.Add(reader[0].ToString()); for (int i = 1; i < reader.FieldCount; ++i) { item.SubItems.Add(reader[i].ToString().Replace(',', '.')); } } }
private void CartWindow_Load(object sender, EventArgs e) { foreach (var product in chosenProducts) { NpgsqlDataReader reader = PostgreSQL.executeCommand("SELECT kod_prod, nazwa, cena FROM produkt WHERE kod_prod=" + product.Key); while (reader.Read()) { ListViewItem item = listView1.Items.Add(reader[0].ToString()); item.SubItems.Add(reader[1].ToString()); item.SubItems.Add(product.Value.ToString()); item.SubItems.Add(reader[2].ToString()); updateTotalPrice(); } } }
private void updateListView() { listView1.Items.Clear(); NpgsqlDataReader reader = PostgreSQL.executeCommand("SELECT p.kod_prod, p.nazwa, d.max_ilosc, d.cena_hurt FROM produkt p join dostawca_dostarcza_produkt d using(kod_prod) WHERE kod_dost=" + supplierIdTextBox.Text); while (reader.Read()) { ListViewItem item = listView1.Items.Add(reader[0].ToString()); for (int j = 1; j < reader.FieldCount; ++j) { item.SubItems.Add(reader[j].ToString().Replace(',', '.')); } } listView1.Refresh(); }
public override void updateProductButton_MouseClick(object sender, MouseEventArgs e) { try { PostgreSQL.executeCommand("INSERT INTO produkt(cena, opis, nazwa, ilosc) VALUES (" + float.Parse(priceBox.Text.Replace(',', '.')) + "," + "'" + describeBox.Text + "'," + "'" + nameBox.Text + "'," + int.Parse(countBox.Text) + ")" ); this.Close(); } catch (FormatException ex) { MessageBox.Show(ex.Message + "\n"); } }
public SupplierProductForm(string id) { supplierId = id; InitializeComponent(); NpgsqlDataReader reader = PostgreSQL.executeCommand("(SELECT kod_prod, nazwa FROM produkt) " + "EXCEPT (SELECT kod_prod, nazwa FROM dostawca_dostarcza_produkt NATURAL JOIN produkt WHERE kod_dost=" + id + ")"); while (reader.Read()) { productComboBox.Items.Add(reader[0] + ". " + reader[1]); } if (productComboBox.Items.Count > 0) { productComboBox.SelectedIndex = 0; } }
public override void updateProductButton_MouseClick(object sender, MouseEventArgs e) { try { PostgreSQL.executeCommand("UPDATE produkt SET " + "cena=" + float.Parse(priceBox.Text.Replace(',', '.')) + "," + "opis='" + describeBox.Text + "'," + "nazwa='" + nameBox.Text + "'," + "ilosc=" + int.Parse(countBox.Text) + " " + "WHERE kod_prod=" + item.SubItems[0].Text ); this.Close(); } catch (FormatException ex) { MessageBox.Show(ex.Message + "\n"); } }
private void okButton_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(supplierNameTextBox.Text)) { MessageBox.Show("Pole 'Nazwa' nie może być puste!"); } else if (string.IsNullOrWhiteSpace(supplierAccountTextBox.Text)) { MessageBox.Show("Pole 'Numer konta' nie może byc puste!"); } else { PostgreSQL.executeCommand("INSERT INTO dostawca(nazwa, nr_konta) VALUES (" + "'" + supplierNameTextBox.Text + "'," + "'" + supplierAccountTextBox.Text + "')" ); this.Close(); } }
private void AddSupplierOrder_Load(object sender, EventArgs e) { NpgsqlDataReader reader = PostgreSQL.executeCommand("SELECT * FROM produkt NATURAL JOIN dostawca_dostarcza_produkt WHERE kod_dost=" + supplierId); while (reader.Read()) { if (!forbiddenProducts.Contains((int)reader[0])) { productComboBox.Items.Add(reader[0] + ". " + reader[3]); } } if (productComboBox.Items.Count > 0) { productComboBox.SelectedItem = productComboBox.Items[0]; } else { MessageBox.Show("Ten dostawca nie dostarcza żadnych produktów"); } }
private void okButton_Click(object sender, EventArgs e) { try { string product = productComboBox.Items[productComboBox.SelectedIndex].ToString(); product = product.Substring(0, product.IndexOf('.')); PostgreSQL.executeCommand("INSERT INTO dostawca_dostarcza_produkt values(" + supplierId + "," + product + "," + float.Parse(priceTextBox.Text) + "," + int.Parse(countTextBox.Text) + ")" ); this.Close(); } catch (FormatException ex) { MessageBox.Show(ex.Message); } }
public DeliveryOrder_Add() { InitializeComponent(); alreadySelectedProducts = new List <int>(); NpgsqlDataReader reader = PostgreSQL.executeCommand("SELECT kod_dost, nazwa FROM dostawca"); while (reader.Read()) { supplierComboBox.Items.Add(reader[0] + ". " + reader[1]); } if (supplierComboBox.Items.Count > 0) { supplierComboBox.SelectedIndex = 0; } statusComboBox.Enabled = false; statusComboBox.Items.Add("Nowe"); statusComboBox.SelectedIndex = 0; }
private void removeOrderButton_Click(object sender, EventArgs e) { if (listView3.SelectedItems.Count > 0) { string orderId = listView3.SelectedItems[0].SubItems[0].Text; string supplierId = listView3.SelectedItems[0].SubItems[1].Text; if (listView3.SelectedItems[0].SubItems[3].Text == "Nowe") { Dictionary <string, string> numberToAdd = new Dictionary <string, string>(); NpgsqlDataReader reader = PostgreSQL.executeCommand("SELECT * FROM zamowienie_dostawy_zawiera_produkt WHERE nr_zamowienia=" + orderId); while (reader.Read()) { numberToAdd[reader[0].ToString()] = reader[2].ToString(); } foreach (var pair in numberToAdd) { PostgreSQL.executeCommand("UPDATE dostawca_dostarcza_produkt " + "SET max_ilosc=max_ilosc+" + pair.Value + " " + "WHERE kod_dost=" + supplierId + " " + "AND kod_prod=" + pair.Key ); } PostgreSQL.executeCommand("DELETE FROM zamowienie_dostawy_zawiera_produkt WHERE nr_zamowienia=" + orderId); PostgreSQL.executeCommand("DELETE FROM zamowienie_dostawy WHERE nr_zamowienia=" + orderId); updateListView3(); } else { MessageBox.Show("Nie można usunąć zamówienia, które zostało opłacone lub dostarczone"); } } }
private void cartButton_Click(object sender, EventArgs e) { CartWindow window = new CartWindow(chosenProducts); if (window.ShowDialog() == DialogResult.OK) { int orderId = (int)PostgreSQL.executeScalar("INSERT INTO zamowienie_detaliczne(kod_uz, koszt, status) values (" + userId + "," + window.totalPrice + "," + "'Nowe') RETURNING nr_zamowienia"); foreach (var product in chosenProducts) { PostgreSQL.executeCommand("INSERT INTO zamowienie_detaliczne_zawiera_produkt values(" + product.Key + "," + orderId + "," + product.Value + ")" ); } chosenProducts.Clear(); cartButton.Text = "Koszyk"; } }
protected override void okButton_Click(object sender, EventArgs e) { string newStatus; if (statusComboBox.Text == "Opłacone") { newStatus = "Oplacone"; } else { newStatus = statusComboBox.Text; } PostgreSQL.executeCommand("UPDATE zamowienie_dostawy SET status='" + newStatus + "' WHERE nr_zamowienia=" + orderId); if (newStatus == "Otrzymane" && oldStatus != "Otrzymane") { foreach (ListViewItem item in listView1.Items) { PostgreSQL.executeCommand("UPDATE produkt SET ilosc=ilosc+" + item.SubItems[2].Text + " WHERE kod_prod=" + item.SubItems[0].Text); } } this.Close(); }