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();
}
private void productComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
int max = (int)PostgreSQL.executeScalar("SELECT max_ilosc FROM dostawca_dostarcza_produkt WHERE kod_prod=" + getProductId() + " AND kod_dost=" + supplierId);
currentPrice = (double)PostgreSQL.executeScalar("SELECT cena_hurt FROM dostawca_dostarcza_produkt WHERE kod_prod=" + getProductId() + " AND kod_dost=" + supplierId);
countUpDown.Maximum = max;
priceTextBox.Text = (currentPrice * (float)countUpDown.Value).ToString() + " zl";
}
private bool haveEnoughProducts()
{
foreach (ListViewItem item in listView1.Items)
{
int noOfProducts = (int)PostgreSQL.executeScalar("SELECT ilosc FROM produkt WHERE kod_prod=" + item.SubItems[0].Text);
if (noOfProducts < int.Parse(item.SubItems[2].Text))
{
return(false);
}
}
return(true);
}
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 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";
}
}