private void grdAllCustomer_CellClick(object sender, DataGridViewCellEventArgs e) { //Gets all customer details and displays them Customer cust = new Customer(); cust.getCustomerInvoice(Convert.ToInt32(grdAllCustomer.Rows[grdAllCustomer.CurrentCell.RowIndex].Cells[0].Value)); lblCustomerID.Text = cust.getCustomerID().ToString(); lblSurname.Text = cust.getCustomerSurname(); lblCustomerBalance.Text = cust.getCustomerBalance().ToString(); lblPhoneNumber.Text = cust.getCustomerPhoneNumberD(); //sets a string status value to ISSUE INVOICE string status1 = "'COMPLETED'"; Repair rep = new Repair(); DataSet ds = new DataSet(); //Get repair details grdRepairs.DataSource = Repair.getCustomerRepair(ds, Convert.ToInt32(grdAllCustomer.Rows[grdAllCustomer.CurrentCell.RowIndex].Cells[0].Value), status1).Tables["ss"]; //if repair grid is empty, givve warning message if (grdRepairs.RowCount == 0) { grpRepairsDone.Visible = false; MessageBox.Show("* * * WARNING * * * \n--------------------------------------------------------------\nCustomer has No COMPLETED Repairs, awaiting INVOICE...", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } //display a group box else { grpRepairsDone.Visible = true; } //hide some ui lblTotalCostFill.Text = ""; grpRepairInfo.Visible = false; btnIssueInvoice.Visible = false; lblTotalCost.Visible = false; lblTotalCostFill.Visible = false; //Set column size in grid DataGridViewColumn column0 = grdRepairs.Columns[0]; column0.Width = 60; DataGridViewColumn column1 = grdRepairs.Columns[1]; column1.Width = 365; DataGridViewColumn column2 = grdRepairs.Columns[2]; column2.Width = 50; }
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"); }