public PendingLoanResponse TransmittedLoans()
{
PendingLoanResponse response = new PendingLoanResponse();
try
{
using (IDbConnection conn = GetConnection())
{
response.NumberOfPending = conn.RecordCount <long>("where LoanStatusID = 2");
response.Status = true;
response.Description = "Successful";
}
}
catch (Exception ex)
{
response.Status = false;
response.Description = ex.Message;
}
return(response);
}
public PendingLoanResponse PendingByBank(long BankID)
{
PendingLoanResponse response = new PendingLoanResponse();
try
{
using (IDbConnection conn = GetConnection())
{
response.NumberOfPending = conn.RecordCount <long>("where LoanStatusID = 1 and MortgageBankID = ?BankID", BankID);
response.Status = true;
response.Description = "Successful";
}
}
catch (Exception ex)
{
response.Status = false;
response.Description = ex.Message;
}
return(response);
}