private void button1_Click(object sender, EventArgs e) { newCon Add_Brewery = new newCon(Logon.Log, Logon.Password); Add_Brewery.Add_Brew(B_name, B_location, B_address, B_postal_code, B_Telephone, B_Email, B_WWW); this.Close(); }
private void Add_Click(object sender, EventArgs e) { try { newCon Check_P_Brewery = new newCon(Logon.Log, Logon.Password); Check_brewery = Check_P_Brewery.Chceck_Brewery(ref P_brewery); if (Check_brewery == "0") { MessageBox.Show("We don't have this brewery in our database. First of all, you have to add it to database."); this.Close(); } newCon Check_Product_type = new newCon(Logon.Log, Logon.Password); Check_P_type = Check_Product_type.Chceck_P_type(ref P_type); if (Check_P_type == "0") { newCon Add_Product_type = new newCon(Logon.Log, Logon.Password); Add_Product_type.Add_P_type(P_type); } newCon Add_product = new newCon(Logon.Log, Logon.Password); Add_product.INTO_PRODUCTS(Product_price, Product_amount, P_name, P_brewery, P_distributor, P_price, P_type, P_unit_of_measurement, P_bar_code); this.Close(); newCon Add_exp_date = new newCon(Logon.Log, Logon.Password); Add_exp_date.INTO_EXP_DATE(P_name, serial_number, P_Exp_date); } catch { MessageBox.Show("You have to fill all the text boxes."); } }
private void button1_Click(object sender, EventArgs e) { string check_product_name; newCon Check_p_name = new newCon(Logon.Log, Logon.Password); check_product_name = Check_p_name.Check_Product_Name(ref p_name); if (p_name == check_product_name) { int final_amount; newCon Check_amount = new newCon(Logon.Log, Logon.Password); check_p_amount = Check_amount.Check_Amount(ref p_name); final_amount = check_p_amount + p_amount; newCon Update_amount = new newCon(Logon.Log, Logon.Password); Update_amount.Amount_Update(final_amount, p_name); try { newCon Add_expiration_date = new newCon(Logon.Log, Logon.Password); Add_expiration_date.INTO_EXP_DATE(p_name, Serial_num, Expiration_date); } catch { MessageBox.Show("Error data format."); } } else { MessageBox.Show("Add this product to database."); } MessageBox.Show("Delivery Success"); }
private void button1_Click(object sender, EventArgs e) { newCon Add_Dis = new newCon(Logon.Log, Logon.Password); Add_Dis.Add_Distrib(d_name, d_location, d_address, d_postal_code, d_tel, d_email, d_www); this.Close(); }
private void Add_Click(object sender, EventArgs e) { newCon Add_Cus = new newCon(Logon.Log, Logon.Password); Add_Cus.Add_Cust(Cus_name, C_NIP, C_City, C_Address, C_Postal_code, C_Tel, C_Email, C_WWW, C_Cus_type); this.Close(); }
private void NIP_number_Click(object sender, EventArgs e) { newCon Get_NIP = new newCon(Logon.Log, Logon.Password); NIP = Get_NIP.Check_NIP(ref Cus_name); NIP_number.Text = NIP; }
private void Bar_code_TextChanged(object sender, EventArgs e) { P_bar_code = long.Parse(Bar_code.Text); newCon Check_P_name = new newCon(Logon.Log, Logon.Password); Product_name.Text = Check_P_name.Chceck_P_name(ref P_bar_code); }
private void Info_Invoices_Click(object sender, EventArgs e) { DataTable DT = null; if (DT != null) { DT.Clear(); } newCon baza_win = new newCon(Logon.Log, Logon.Password); dataGridView1.DataSource = baza_win.pobierz_dane("Select * FROM Invoice_headers"); }
private void button1_Click(object sender, EventArgs e) { DataTable DT = null; if (DT != null) { DT.Clear(); } newCon baza_win = new newCon(Logon.Log, Logon.Password); dataGridView1.DataSource = baza_win.pobierz_dane("Select * FROM Distributors"); }
private void End_Sale_Click(object sender, EventArgs e) { int Cus_ID, Invoice_ID; newCon Check_Cus_ID = new newCon(Logon.Log, Logon.Password); Cus_ID = Check_Cus_ID.GetID(ref Cus_name); newCon Check_Invoice_ID = new newCon(Logon.Log, Logon.Password); Invoice_ID = Check_Invoice_ID.Get_Invoice_ID(); Invoice_ID += 1; newCon Check_Discount = new newCon(Logon.Log, Logon.Password); Discount = Check_Discount.Get_Discount(ref Cus_name); newCon Check_Employee_ID = new newCon(Logon.Log, Logon.Password); Employee_ID = Check_Employee_ID.Get_Employee_ID(ref Logon.Log); sum_with_discount = sum - (sum * (Discount / 100)); newCon Add2 = new newCon(Logon.Log, Logon.Password); Add2.INTO_INV_HEAD(Cus_ID, sum_with_discount, payment, Discount); newCon Add1 = new newCon(Logon.Log, Logon.Password); Add1.INTO_SALE(Employee_ID, Cus_name, Invoice_ID); foreach (ListViewItem lvi in listView1.Items) { P_name = lvi.SubItems[1].Text; P_amount = lvi.SubItems[2].Text; P_price = Convert.ToInt32(lvi.SubItems[3].Text); unit_of_measurement = lvi.SubItems[4].Text; serial_number = lvi.SubItems[5].Text; exp_date = lvi.SubItems[6].Text; newCon Add3 = new newCon(Logon.Log, Logon.Password); Add3.INTO_INV_ITEMS(P_name, Invoice_ID, Convert.ToInt32(P_amount), unit_of_measurement, P_price, P_bar_code); newCon GetAmount = new newCon(Logon.Log, Logon.Password); Amount_base = GetAmount.Check_Amount(ref P_name); residual = Amount_base - Convert.ToInt32(P_amount); newCon Update1 = new newCon(Logon.Log, Logon.Password); Update1.Amount_Update(residual, P_name); } this.Close(); }
private void Prod_name_TextChanged(object sender, EventArgs e) { string check_p_name; P_name = Prod_name.Text; newCon Check_prod_name = new newCon(Logon.Log, Logon.Password); check_p_name = Check_prod_name.Check_Product_Name(ref P_name); if (P_name == check_p_name) { MessageBox.Show("This product is in database."); } }
public void Login_Click(object sender, EventArgs e) { try { var user = new Employee(Log, Password); newCon baza = new newCon(Log, Password); this.Hide(); Form1 form1 = new Form1(); form1.Visible = true; form1.TopMost = true; form1.Closed += (s, args) => this.Close(); form1.Show(); } catch (Exception exception) { MessageBox.Show(exception.Message); } }
private void dataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e) { cell_text = dataGridView1.CurrentCell.Value.ToString(); switch (dataGridView1.CurrentCell.OwningColumn.HeaderText.ToString()) { case "Invoice_ID": DataTable DT = null; if (DT != null) { DT.Clear(); } newCon baza_win = new newCon(Logon.Log, Logon.Password); dataGridView1.DataSource = baza_win.pobierz_dane("Select * FROM Invoice_items WHERE Invoice_ID =" + cell_text + ";"); break; case "Customer_name": DataTable DT1 = null; if (DT1 != null) { DT1.Clear(); } newCon baza_win1 = new newCon(Logon.Log, Logon.Password); dataGridView1.DataSource = baza_win1.pobierz_dane("SELECT IH.Customer_ID, IH.Invoice_ID, IH.Invoice_value, IH.Discount, IH.Date_time, IH.Payment FROM Customers AS C JOIN Invoice_headers AS IH ON C.Customer_ID=IH.Customer_ID WHERE Customer_name ='" + cell_text + "';"); break; case "Br_name": DataTable DT2 = null; if (DT2 != null) { DT2.Clear(); } newCon baza_win2 = new newCon(Logon.Log, Logon.Password); dataGridView1.DataSource = baza_win2.pobierz_dane("SELECT * FROM Products WHERE Brewery ='" + cell_text + "';"); break; case "Dis_name": DataTable DT3 = null; if (DT3 != null) { DT3.Clear(); } newCon baza_win3 = new newCon(Logon.Log, Logon.Password); dataGridView1.DataSource = baza_win3.pobierz_dane("SELECT * FROM Products WHERE Distributor ='" + cell_text + "';"); break; case "P_type": DataTable DT4 = null; if (DT4 != null) { DT4.Clear(); } newCon baza_win4 = new newCon(Logon.Log, Logon.Password); dataGridView1.DataSource = baza_win4.pobierz_dane("SELECT * FROM Products WHERE P_type ='" + cell_text + "';"); break; case "Product_name": DataTable DT5 = null; if (DT5 != null) { DT5.Clear(); } newCon baza_win5 = new newCon(Logon.Log, Logon.Password); dataGridView1.DataSource = baza_win5.pobierz_dane("SELECT * FROM Expiration_dates WHERE Product_name ='" + cell_text + "';"); break; } }
private void Products_Click(object sender, EventArgs e) { newCon Check_amount = new newCon(Logon.Log, Logon.Password); check_amount = Check_amount.Check_Amount(ref P_name); int P_amount_test = Convert.ToInt32(P_amount); if (P_amount_test <= check_amount) { ListViewItem itm; IDatabaseConnection _databaseConnection = new DatabaseConnection(); _databaseConnection.OpenNewConnection(user); GetterPriceOfBeer getterPriceOfBeer = new GetterPriceOfBeer() int price = 0; newCon a = new newCon(Logon.Log, Logon.Password); price = a.GetPrice(ref P_name); string[] arr = new string[7]; if (price != 0) { if (serial_number != "0") { if (exp_date != "0") { newCon Check_Unit_of_measurement = new newCon(Logon.Log, Logon.Password); unit_of_measurement = Check_Unit_of_measurement.Get_unit_of_measurement(ref P_name); arr[0] = Convert.ToString(x); arr[1] = P_name; arr[2] = P_amount; arr[3] = Convert.ToString(price); arr[4] = unit_of_measurement; arr[5] = serial_number; arr[6] = exp_date; arr[7] = Convert.ToString(P_bar_code); itm = new ListViewItem(arr); listView1.Items.Add(itm); x++; } else { MessageBox.Show("Enter a expiration date."); } } else { MessageBox.Show("Enter a serial number."); } } else { MessageBox.Show("Incorrect name of beer"); } try { string Product_Name = P_name; newCon b = new newCon(Logon.Log, Logon.Password); Unit_price = b.GetPrice(ref Product_Name); sum += Unit_price * int.Parse(Amount.Text); amount_sum += int.Parse(Amount.Text); } catch { MessageBox.Show("Incorrect name of beer"); } Quantity_TextBox.Text = Convert.ToString(amount_sum); Invoice_value.Text = Convert.ToString(sum); } else { MessageBox.Show("Too much bottles."); } }