public ListRepaymentHistoryResponse List(long LoanId) { ListRepaymentHistoryResponse response = new ListRepaymentHistoryResponse(); try { using (IDbConnection conn = GetConnection()) { response.repayments = conn.GetList <RepaymentHistory>("where loanid = ?LoanId", new { LoanId }).ToList(); if (response.repayments.Count > 0) { response.Status = true; response.Description = "Successful"; } else { response.Status = false; response.Description = "No data"; } } } catch (Exception ex) { response.Status = false; response.Description = ex.Message; } return(response); }
public ListRepaymentHistoryResponse RecentRepayments() { ListRepaymentHistoryResponse response = new ListRepaymentHistoryResponse(); try { using (IDbConnection conn = GetConnection()) { response.repayments = conn.GetListPaged <RepaymentHistory>(1, 5, null, "TransactionDate desc").ToList(); if (response.repayments.Count > 0) { response.Status = true; response.Description = "Successful"; } else { response.Status = false; response.Description = "No data"; } } } catch (Exception ex) { response.Status = false; response.Description = ex.Message; } return(response); }
public ListLoanResponse RecentLoanRepayments(DateTime?StartDate, DateTime?EndDate) { ListLoanResponse response = new ListLoanResponse(); ListRepaymentHistoryResponse list = new ListRepaymentHistoryResponse(); try { using (IDbConnection conn = GetConnection()) { string condition = StartDate.HasValue && EndDate.HasValue ? "where convert(loandate, date) between convert(?StartDate, date) and convert(?EndDate, date)" : null; list.repayments = conn.GetListPaged <RepaymentHistory>(1, 5, condition, "TransactionDate desc", new { StartDate, EndDate }).ToList(); List <Loans> loans = new List <Loans>(); list.repayments.ForEach(item => { Loans loan = new Loans(); loan = conn.Get <Loans>(item.LoanID); if (loan != null) { loans.Add(loan); } }); if (loans.Count > 0) { response.Status = true; response.Description = "Successful"; response.loans = loans; } else { response.Status = false; response.Description = "No data"; } } } catch (Exception ex) { response.Status = false; response.Description = ex.Message; } return(response); }