Esempio n. 1
0
        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: ");
                    }
                }
            }
        }
Esempio n. 2
0
        private void btnPurchase_Click(object sender, EventArgs e)
        {
            ProductPurchase pb = new ProductPurchase();

            pb.Show();
        }