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();
}