// method to sort applicants by county descending private void SortApplicantsByCountyDesc() { try { BLLApplicantManager BLLMngr = new BLLApplicantManager(); List<Applicant> ApplicantList = BLLMngr.CallGetListOfApplicants(); ApplicantList = ApplicantList.OrderByDescending((applicant) => applicant.County).ToList(); dgvMainFormLoans.Visible = false; dgvMainFormApplicant.Visible = true; dgvMainFormApplicant.DataSource = ApplicantList; ApplicantsInDGV = ApplicantList; } catch (Exception ex) { MessageBox.Show(ex.Message); throw; } }
// method to find applicant by phone number private void SearchPhone(string phone) { try { BLLApplicantManager BLLMngr = new BLLApplicantManager(); List<Applicant> ApplicantList = BLLMngr.CallGetListOfApplicants(); ApplicantList = ApplicantList.Where((applicant) => applicant.Phone == phone).ToList(); dgvMainFormLoans.Visible = false; dgvMainFormApplicant.Visible = true; dgvMainFormApplicant.DataSource = ApplicantList; ApplicantsInDGV = ApplicantList; } catch (Exception ex) { MessageBox.Show(ex.Message); throw; } }
// button click to edit selected loan on datagridview private void editLoanToolStripMenuItem_Click(object sender, EventArgs e) { Loan loan = GetSelectedLoan(); int crn; Applicant app = null; if (dgvMainFormLoans.Visible == true && loan != null) { try { crn = loan.CRN; BLLApplicantManager BLLMngr = new BLLApplicantManager(); List<Applicant> ApplicantList = BLLMngr.CallGetListOfApplicants(); foreach (Applicant a in ApplicantList) { if(a.CRN == crn) { app = a; } } using (EditLoanDetails frmEditLoanDetails = new EditLoanDetails(app, loan)) { frmEditLoanDetails.OnLoanAdded += LoanAdded; frmEditLoanDetails.ShowDialog(); } } catch(Exception ex) { MessageBox.Show(ex.Message); throw; } } }
// method to find applicant by lrn private void SearchLRNNumber(int lrn) { try { BLLApplicantManager BLLMngrApp = new BLLApplicantManager(); List<Applicant> ApplicantList = BLLMngrApp.CallGetListOfApplicants(); BLLLoanManager BLLMngrLoan = new BLLLoanManager(); List<Loan> LoanList = BLLMngrLoan.CallGetListOfLoans(); Loan getLoan = null; foreach (Loan loan in LoanList) { if (loan.LRN == lrn) { getLoan = loan; } } int crn = getLoan.CRN; ApplicantList = ApplicantList.Where((applicant) => applicant.CRN == crn).ToList(); dgvMainFormLoans.Visible = false; dgvMainFormApplicant.Visible = true; dgvMainFormApplicant.DataSource = ApplicantList; ApplicantsInDGV = ApplicantList; } catch (Exception ex) { MessageBox.Show(ex.Message); throw; } }
// returns selected applicant object on datagridview private Applicant GetSelectedApplicant() { Applicant SelectApplicant = null; int crn = 0; int ColumnIndex = 0; int RowIndex = 0; try { if (dgvMainFormApplicant.SelectedRows.Count > 0) { BLLApplicantManager BLLMngr = new BLLApplicantManager(); List<Applicant> ApplicantList = BLLMngr.CallGetListOfApplicants(); RowIndex = dgvMainFormApplicant.SelectedRows[0].Index; crn = (int)dgvMainFormApplicant.Rows[RowIndex].Cells[ColumnIndex].Value; for (int i = 0; i < ApplicantList.Count; i++) { if (ApplicantList[i].CRN == crn) { SelectApplicant = ApplicantList[i]; break; } } } } catch(Exception ex) { MessageBox.Show(ex.Message); throw; } return SelectApplicant; }
//int crn, string firstName, string surname, string phone, EmploymentStatus empStatus, decimal weeklyNetPay, decimal weeklyOutgoings, string cr private void newLoanToolStripMenuItem1_Click(object sender, EventArgs e) { Applicant applicant = null; List<Applicant> appList = null; BLLApplicantManager BLLMngr = new BLLApplicantManager(); if (dgvMainFormApplicant.Visible == true) { applicant = GetSelectedApplicant(); } else if (dgvMainFormLoans.Visible == true) { Loan newLoan = GetSelectedLoan(); appList = BLLMngr.CallGetListOfApplicants(); foreach (Applicant a in appList) { if (a.CRN == newLoan.CRN) { applicant = a; } } } if (applicant != null) { using (NewLoanDetails frmNewLoan = new NewLoanDetails(applicant)) { frmNewLoan.OnLoanAdded += LoanAdded; frmNewLoan.ShowDialog(); } } }
// method which gets list of applicants from database and populates a datagridview with them private void PrimeApplicantListDGV() { try { BLLApplicantManager BLLMngr = new BLLApplicantManager(); List<Applicant> ApplicantList = BLLMngr.CallGetListOfApplicants(); dgvMainFormLoans.Visible = false; dgvMainFormApplicant.Visible = true; dgvMainFormApplicant.DataSource = ApplicantList; ApplicantsInDGV = ApplicantList; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
// method to filter applicants by employment status private void FilterApplicantsByEmploymentStatus(EmploymentStatus status) { try { BLLApplicantManager BLLMngr = new BLLApplicantManager(); List<Applicant> ApplicantList = BLLMngr.CallGetListOfApplicants(); ApplicantList = ApplicantList.Where((applicant) => applicant.EmploymentStatus == status).ToList(); dgvMainFormLoans.Visible = false; dgvMainFormApplicant.Visible = true; dgvMainFormApplicant.DataSource = ApplicantList; ApplicantsInDGV = ApplicantList; } catch (Exception ex) { MessageBox.Show(ex.Message); throw; } }