private void frmRepairLog_Load(object sender, EventArgs e)
        {
            //Fills grid with customer repair details
            DataSet ds = new DataSet();

            grdgetRepairDetails.DataSource         = Repair.getRepairDetails(ds).Tables["ss"];
            grdgetRepairDetails.AllowUserToAddRows = false;
            txtRepairID.Text = Repair.nextRepairID().ToString("0000");

            //if grid is empty, close
            if (grdgetRepairDetails.RowCount == 0)
            {
                DialogResult result = MessageBox.Show("* * * WARNING * * * \n\n--------------------------------------------------------------\n\nNo Customers have been ADDED to allow REPAIR...\n\n--------------------------------------------------------------\n\nWould you like to ADD a Customer?", "Warning",
                                                      MessageBoxButtons.YesNo, MessageBoxIcon.Warning);


                if (result == DialogResult.Yes)
                {
                    frmCustomerAdd ca = new frmCustomerAdd();
                    this.Close();
                    ca.Show();
                }
                else if (result == DialogResult.No)
                {
                    frmMainMenu mm = new frmMainMenu();
                    this.Close();
                    mm.Show();
                }
            }
        }
        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            //find repair details
            Repair rep = new Repair();

            rep.getRepairDetails(Convert.ToInt32(grdgetRepairDetails.Rows[grdgetRepairDetails.CurrentCell.RowIndex].Cells[0].Value));

            //If no repair, display appropriate message
            if (rep.getRepairID().Equals(0))
            {
                MessageBox.Show("No details found", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);

                return;
            }

            //Get string status value
            string status = grdgetRepairDetails.Rows[grdgetRepairDetails.CurrentCell.RowIndex].Cells[2].Value.ToString();


            //if status d, do not procede with repair
            if (status == "D")
            {
                grpRepairDetails.Visible = false;
                lblCustomerName.Text     = "Select a Customer...";
                txtCustomerID.Text       = "";
                MessageBox.Show("Member NOT ACTIVE \n-----------------------\nPlease activate " + grdgetRepairDetails.Rows[grdgetRepairDetails.CurrentCell.RowIndex].Cells[1].Value + " to Log a Repair...", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);


                return;
            }

            //display Repair details
            txtCustomerID.Text   = rep.getCustomerID().ToString();
            lblCustomerName.Text = rep.getCustomerName();


            grpRepairDetails.Visible = true;
            btnSubmit.Visible        = true;
        }