// 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;
}
}
