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