private void btnDebtorList_Click(object sender, EventArgs e) { hideAllPanels(); panelDebtorsList.Visible = true; DebtorListLbl.Show(); btnDebtorList.BackColor = Color.DarkCyan; btnDebtorList.ForeColor = Color.White; cmbBoxSearchBy.SelectedIndex = 0; String[] colArray = { "First_Name", "Last_Name", "NIC_", "Current_Debt", "BorrowedDate", "LastPayment" }; String query = "SELECT debtors.FName,debtors.LName,debtors.NIC,(loan.Amount - Sum(installment.amount)),loan.BorrowedDate,installment.amount FROM debtors,loan,installment WHERE debtors.DebtorID = loan.DebtorsID AND installment.RefNo = loan.RefNo GROUP By loan.RefNo"; fillTable fillTableObj = new fillTable(); fillTableObj.DrawTable(dataGridView1, colArray, query); }
private void hideAllPanels() { AddDebtorLbl.Hide(); AddloanLbl.Hide(); DebtorListLbl.Hide(); ReportLbl.Hide(); btnReports.BackColor = DefaultBackColor; btnReports.ForeColor = DefaultForeColor; btnDebtorList.BackColor = DefaultBackColor; btnDebtorList.ForeColor = DefaultForeColor; btnAddNewDebtor.BackColor = DefaultBackColor; btnAddNewDebtor.ForeColor = DefaultForeColor; panelDebtorsList.Visible = false; panelAddNewDebtor.Visible = false; panelHome.Visible = false; panelReport.Visible = false; panelAddLoanDetails.Visible = false; }