private void getList()
{
try
{
dgvCollectionList.Rows.Clear();
foreach (DataRow _dr in loLoanApplicationDetail.getUploadCollectionList(dtpDate.Value, cboCollector.SelectedValue.ToString()).Rows)
{
int i = dgvCollectionList.Rows.Add();
dgvCollectionList.Rows[i].Cells["SeqNo"].Value = i + 1;
dgvCollectionList.Rows[i].Cells["LoanApplicationDetailId"].Value = _dr["Detail Id"].ToString();
dgvCollectionList.Rows[i].Cells["Zone"].Value = _dr["Zone"].ToString();
dgvCollectionList.Rows[i].Cells["LoanApplicationNo"].Value = _dr["Loan Application No."].ToString();
dgvCollectionList.Rows[i].Cells["ClientName"].Value = _dr["Client Name"].ToString();
dgvCollectionList.Rows[i].Cells["LoanAmount"].Value = string.Format("{0:n}", decimal.Parse(_dr["Loan Amount"].ToString()));
dgvCollectionList.Rows[i].Cells["AmountDue"].Value = string.Format("{0:n}", decimal.Parse(_dr["Amount Due"].ToString()));
dgvCollectionList.Rows[i].Cells["RunningBalance"].Value = string.Format("{0:n}", decimal.Parse(_dr["Running Balance"].ToString()));
dgvCollectionList.Rows[i].Cells["InstallmentAmount"].Value = string.Format("{0:n}", decimal.Parse(_dr["Installment Amount"].ToString()));
dgvCollectionList.Rows[i].Cells["Payment"].Value = string.Format("{0:n}", decimal.Parse(_dr["Payment Amount"].ToString()));
dgvCollectionList.Rows[i].Cells["NewBalance"].Value = string.Format("{0:n}", decimal.Parse(_dr["New Balance"].ToString()));
dgvCollectionList.Rows[i].Cells["Variance"].Value = string.Format("{0:n}", decimal.Parse(_dr["Variance"].ToString()));
dgvCollectionList.Rows[i].Cells["PastDueReason"].Value = _dr["Past Due Reason"].ToString();
dgvCollectionList.Rows[i].Cells["Remarks"].Value = _dr["Remarks"].ToString();
}
}
catch
{
dgvCollectionList.Rows.Clear();
}
}
public DataTable getUploadCollectionList(DateTime pCollectionDate, string pCollectorId)
{
return(loLoanApplicationDetail.getUploadCollectionList(pCollectionDate, pCollectorId));
}
