private void button3_Click(object sender, EventArgs e) => Close(); //Exit private void button2_Click(object sender, EventArgs e) // Pay { if (dataGridView1.RowCount > 0) { while (true) { PaymentWindow source = new PaymentWindow(); source.UpdateTotal(String.Format("{0:0.00}", new Calculator().UpdatePayment(label6, label4))); source.ShowDialog(); if (source.getPayment() != "0.00") { label4.Text = new Calculator().AddPrevPayment(Convert.ToDouble(label4.Text), Convert.ToDouble(source.getPayment())); label6.Text = source.getDiscountedPrice(); } if (source.discountMode() == false) { Show(); break; } else { Hide(); DiscountPicker discPick = new DiscountPicker(); discPick.ShowDialog(); Show(); } } double change = new Calculator().ChangeCalculation(Convert.ToDouble(label4.Text), Convert.ToDouble(label6.Text)); label8.Text = String.Format("{0:0.00}", change); if (change >= 0.00) { string ORNOgenerated = new ORNOGEN().ORNOGENstring(); string Salesperson = new MainDatabase().InteractDB_getCurrentSalesPerson(); inventorySub(); logSales(ORNOgenerated); ReceiptWindow rw = new ReceiptWindow(); rw.setContents(dataGridView1); string VATpercent = Convert.ToString(Convert.ToDouble(getVatPercentage()) * 100); string DiscountPercent = getDiscPercentage(); double[] PriceList = getUpdatedValues(); rw.setTransactionDetails(ORNOgenerated, Salesperson, label4, label8, VATpercent, DiscountPercent, PriceList[0], PriceList[1], PriceList[2]); Hide(); rw.ShowDialog(); Show(); ClearAll(); } } }
private void logSales(SqlConnection con, int ID, string Name, int quantity, double priceTotal, string ORNO) { DateTime saletimeParsed = new ORNOGEN().ORNOstringToDT(ORNO); string Salesperson = getCurrentSalesPerson(con); SqlCommand com = new SqlCommand("INSERT INTO TABLE_SALES(ORnumber,ID,Name,Sold,TotalSales,Salesperson,SaleTime) VALUES (@ORN,@ID,@Name,@Sold,@TotalSales,@SalesPerson,@SaleTime)", con); com.Parameters.Add(new SqlParameter("ORN", ORNO)); com.Parameters.Add(new SqlParameter("ID", ID)); com.Parameters.Add(new SqlParameter("Name", Name)); com.Parameters.Add(new SqlParameter("Sold", quantity)); com.Parameters.Add(new SqlParameter("TotalSales", priceTotal)); com.Parameters.Add(new SqlParameter("Salesperson", Salesperson)); com.Parameters.Add(new SqlParameter("SaleTime", saletimeParsed)); com.ExecuteNonQuery(); }