public ListLoanResponse Repaid(DateTime?StartDate, DateTime?EndDate)
{
ListLoanResponse response = new ListLoanResponse();
try
{
using (IDbConnection conn = GetConnection())
{
if (StartDate.HasValue && EndDate.HasValue)
{
response.loans = conn.GetList <Loans>("where LoanStatusID = 8 and convert(loandate, date) between convert(?StartDate, date) and convert(?EndDate, date)", new { StartDate, EndDate }).ToList();
}
else
{
response.loans = conn.GetList <Loans>("where LoanStatusID = 8").ToList();
}
response.Status = true;
response.Description = "Successful";
}
}
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);
}
public ListLoanResponse GetByBank(long bankId, DateTime?StartDate = null, DateTime?EndDate = null)
{
ListLoanResponse response = new ListLoanResponse();
try
{
using (IDbConnection conn = GetConnection())
{
if (StartDate.HasValue && EndDate.HasValue)
{
response.loans = conn.GetList <Loans>("where MortgageBankID = ?bankId, convert(loandate, date) between convert(?StartDate, date) and convert(?EndDate, date)", new { bankId, StartDate, EndDate }).ToList();
}
else
{
response.loans = conn.GetList <Loans>("where MortgageBankID = ?bankId", new { bankId }).ToList();
}
if (response.loans.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);
}
