private void btnIssueInvoice_Click(object sender, EventArgs e)
{
grpRepairsDone.Visible = false;
//Gets current date
string d = DateTime.Now.ToString("d-MMM-yyyy");
//Adds a payment to payments table
Payments p = new Payments(Int32.Parse(txtPaymentID.Text), Int32.Parse(lblTotalCostFill.Text), d, Int32.Parse(lblCustomerID.Text));
p.addPayment();
//Confirmation msg
MessageBox.Show("PAYMENT RECIEVED\n-------------------\nBALANCE UPDATED", "SUCCESS!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//stores status value
string status = "'PAID'";
//Getting repair and customer ID
int cno = Convert.ToInt32(grdAllCustomer.Rows[grdAllCustomer.CurrentCell.RowIndex].Cells[0].Value);
int rno = Convert.ToInt32(grdRepairs.Rows[grdRepairs.CurrentCell.RowIndex].Cells[0].Value);
//Updates customer balance and repair status
Repair rep = new Repair();
Repair.updateCustomerBalance(Convert.ToInt32(lblCostFill.Text), Convert.ToInt32(lblCustomerID.Text));
rep.updateRepairStatusPAYMENT(Convert.ToInt32(cno), Convert.ToInt32(rno), status);
DataSet DataSet = new DataSet();
grdAllCustomer.DataSource = Customer.getAllCustomers(DataSet).Tables["ss"];
string status2 = "'ISSUE INVOICE'";
DataSet ds = new DataSet();
grdRepairs.DataSource = Repair.getCustomerRepair(ds, Convert.ToInt32(grdAllCustomer.Rows[grdAllCustomer.CurrentCell.RowIndex].Cells[0].Value), status2).Tables["ss"];
txtPaymentID.Text = Payments.nextPaymentID().ToString("0000");
}