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