private void btnSave_Click(object sender, EventArgs e) { int er = 0; ep.Clear(); if (txtNumber.Text == "") { er++; ep.SetError(txtNumber, " Number Required"); } if (cmbLedger.SelectedValue == null || cmbLedger.SelectedValue.ToString() == "") { er++; ep.SetError(cmbLedger, " Ledger Required"); } if (cmbEmployee.SelectedValue == null || cmbEmployee.SelectedValue.ToString() == "") { er++; ep.SetError(cmbEmployee, " Employee Required"); } if (dtpDateTime.Text == "") { er++; ep.SetError(dtpDateTime, " Date Required"); } if (er > 0) { return; } Purchase purchase = new Purchase(); purchase.Number = txtNumber.Text; purchase.DateTime = Convert.ToDateTime(dtpDateTime.Value); purchase.EmployeeId = Convert.ToInt32(cmbEmployee.SelectedValue); purchase.LedgerId = Convert.ToInt32(cmbLedger.SelectedValue); purchase.Total = Convert.ToDouble(txtTotal.Text); purchase.Vat = Convert.ToDouble(txtVat.Text); purchase.Discount = Convert.ToDouble(txtDiscount.Text); if (purchase.Insert()) { for (int i = 0; i < dgvPurchaseNew.Rows.Count - 1; i++) { PurchaseDetails purchaseDetails = new PurchaseDetails(); purchaseDetails.PurchaseId = purchase.LastId; purchaseDetails.ProductId = Convert.ToInt32(dgvPurchaseNew.Rows[i].Cells["colProduct"].Value); purchaseDetails.Qty = Convert.ToInt32(dgvPurchaseNew.Rows[i].Cells["colQty"].Value); purchaseDetails.Rate = Convert.ToDouble(dgvPurchaseNew.Rows[i].Cells["colRate"].Value); purchaseDetails.Insert(); } MessageBox.Show(@"Purchase Saved"); dgvPurchaseNew.Rows.Clear(); } else { MessageBox.Show(purchase.Error); } }