Пример #1
0
        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);
        }
Пример #2
0
        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);
        }