private void btnSalesOk_Click(object sender, EventArgs e) { db.DBConnect = db.DBConnection(); for (int i = 0; i < GridPurchase.Rows.Count - 1; i++) { /* * MessageBox.Show("Your value are " + txtPurBillno.Text+" " + purDate.Text + " " + txtSuppName.Text + " " +txtSupplierAdd.Text + * " "+ GridPurchase.Rows[i].Cells[0].Value + * " " + GridPurchase.Rows[i].Cells[1].Value + " " + GridPurchase.Rows[i].Cells[2].Value + " " + GridPurchase.Rows[i].Cells[3].Value + * " " + txtAmount.Text + " " + txtDiscount.Text + " " + txtTaxable.Text + " " + txtTax.Text + " " + txtGrand.Text + "."); */ String billdate = purDate.Text; string suppName = txtSuppName.Text; string add = txtSupplierAdd.Text; string totalAmount = txtAmount.Text; string discount = txtDiscount.Text; string taxable = txtTaxable.Text; string tax = txtTax.Text; String grandTotal = txtGrand.Text; String particulars = GridPurchase.Rows[i].Cells[0].Value.ToString(); String unit = GridPurchase.Rows[i].Cells[1].Value.ToString(); String qty = GridPurchase.Rows[i].Cells[2].Value.ToString(); String rate = GridPurchase.Rows[i].Cells[3].Value.ToString(); String amount = GridPurchase.Rows[i].Cells[4].Value.ToString(); if (String.IsNullOrEmpty(billdate) || String.IsNullOrEmpty(suppName) || String.IsNullOrEmpty(add) || String.IsNullOrEmpty(totalAmount) || String.IsNullOrEmpty(tax) || String.IsNullOrEmpty(grandTotal)) { MessageBox.Show("All the fields should be filled", "Message", MessageBoxButtons.OK, MessageBoxIcon.Hand); } else { string purInsert = "insert into Purchase(Bill_Date,Supplier_Name,Address,Particulars,Unit,Quantity,Rate,Amount,Total_Amount,Discount_Percentage,Taxable_Amount,Tax_Percentage,Grand_Total)" + "values('" + billdate + "','" + suppName + "','" + add + "','" + particulars + "','" + unit + "','" + qty + "','" + rate + "','" + amount + "','" + totalAmount + "','" + discount + "','" + taxable + "','" + tax + "','" + grandTotal + "');"; // MessageBox.Show("Your values are " + purInsert); db.DBConnect = db.DBConnection(); MySqlCommand myProduct = new MySqlCommand(purInsert, db.DBConnect); try { //MySqlDataReader inscmd = cmd.ExecuteReader(); int num = myProduct.ExecuteNonQuery(); if (num > 0) { MessageBox.Show("Bill has been prepared."); this.Close(); ProductPurchase pb = new ProductPurchase(); pb.Show(); } else { MessageBox.Show("Data not inserted."); } } catch (MySqlException er) { MessageBox.Show(er.Message, "An error has occured: "); } } } }
private void btnPurchase_Click(object sender, EventArgs e) { ProductPurchase pb = new ProductPurchase(); pb.Show(); }