public async Task <AccountStatementDTO> GetAccountstatementReport(string ConnectionString, string VchapplicationID)
{
await Task.Run(() =>
{
try
{
VchapplicationID = ManageQuote(VchapplicationID).Trim().ToUpper();
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select applicationid, fathername,contactnumber,emailid,contactaddress,loanaccountno,applicantname,loanstatus,approvedloanamount,installmentstartdate,loantype,loanname,tenureofloan,loanpayin,rateofinterest,lastinstalmentdate,installmentamount,disbursementdate,aadharno,panno ,titlename,contactimagepath,loaninstalmentpaymentmode,loancloseddate from VWACCOUNTSTATEMENT_LOAN_CONTACT_DETAILS where upper(loanaccountno)='" + VchapplicationID + "';"))
{
while (dr.Read())
{
_AccountStatementDTO = new AccountStatementDTO
{
pApplicationid = Convert.ToInt64(dr["applicationid"]),
pFathername = Convert.ToString(dr["fathername"]),
pMobileno = Convert.ToString(dr["contactnumber"]),
pEmailid = Convert.ToString(dr["emailid"]),
pAddress = Convert.ToString(dr["contactaddress"]),
pVchapplicationid = Convert.ToString(dr["loanaccountno"]),
pName = Convert.ToString(dr["applicantname"]),
pCurrentStatus = Convert.ToString(dr["loanstatus"]),
pLoanamount = dr["approvedloanamount"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["approvedloanamount"]),
pFirstinstalmentdate = dr["installmentstartdate"] == DBNull.Value ? null : Convert.ToDateTime(dr["installmentstartdate"]).ToString("dd/MM/yyyy"),
pLoantype = Convert.ToString(dr["loantype"]),
pLoanname = Convert.ToString(dr["loanname"]),
pTenure = Convert.ToString(dr["tenureofloan"]),
pLoanpayin = Convert.ToString(dr["loanpayin"]),
pInterest = Convert.ToString(dr["rateofinterest"]),
pLastinstalmentdate = dr["lastinstalmentdate"] == DBNull.Value ? null : Convert.ToDateTime(dr["lastinstalmentdate"]).ToString("dd/MM/yyyy"),
pInstalmentamount = Convert.ToDecimal(dr["installmentamount"]),
pDisbursedDate = dr["disbursementdate"] == DBNull.Value ? null : Convert.ToDateTime(dr["disbursementdate"]).ToString("dd/MM/yyyy"),
pAadharno = Convert.ToString(dr["aadharno"]),
pPanNo = Convert.ToString(dr["panno"]),
pTitlename = Convert.ToString(dr["titlename"]),
pContactImagePath = Convert.ToString(dr["contactimagepath"]),
ploaninstalmentpaymentmode = Convert.ToString(dr["loaninstalmentpaymentmode"]),
pLoanclosedDate = dr["loancloseddate"] == DBNull.Value ? null : Convert.ToDateTime(dr["loancloseddate"]).ToString("dd/MM/yyyy"),
pDocumentstoredetails = getDocumentstoreDetails(ConnectionString, 0, VchapplicationID),
pTransactionListDetails = GetaccountstatementtransactionDetails(ConnectionString, VchapplicationID)
};
}
}
}
catch (Exception ex)
{
throw ex;
}
});
return(_AccountStatementDTO);
}
public async Task <IActionResult> GetAccountstatementReport(string VchapplicationID)
{
_AccountStatementDTO = new AccountStatementDTO();
try
{
if (!string.IsNullOrEmpty(VchapplicationID))
{
_AccountStatementDTO = await _AccountstmntreportDAL.GetAccountstatementReport(Con, VchapplicationID);
return(_AccountStatementDTO != null?Ok(_AccountStatementDTO) : (IActionResult)StatusCode(StatusCodes.Status204NoContent));
}
else
{
return(StatusCode(StatusCodes.Status406NotAcceptable));
}
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
