public IActionResult Lienreleaseviewdata()
{
LienReleaseviewDTO lstlienreleaseView = new LienReleaseviewDTO();
try
{
lstlienreleaseView = Objlienrelease.Lienreleaseviewdata(Con);
return(lstlienreleaseView != null?Ok(lstlienreleaseView) : (IActionResult)StatusCode(StatusCodes.Status204NoContent));
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
throw;
}
}
public LienReleaseviewDTO Lienreleaseviewdata(string connectionstring)
{
List <LienReleasememberfdDTO> lstleinreleaseview = new List <LienReleasememberfdDTO>();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(connectionstring, CommandType.Text, "select a.fdaccountno, a.membername,a.tenor,a.depositamount,lienamount,b.companybranch,b.lienadjuestto,b.lienid,to_char(b.liendate, 'dd/Mon/yyyy')liendate,c.lienrealsedate from tbltransfdcreation a,tbltranslienentry b,tbltranslienrealse c where a.MEMBERCODE = b.membercode and a.fdaccountno = b.fdaccountno and b.lienstatus = 'Y' and b.lienid = c.lienid and c.statusid = " + Convert.ToInt32(Status.Active) + " order by c.recordid desc;"))
{
while (dr.Read())
{
LienReleasememberfdDTO objlienrelaseview = new LienReleasememberfdDTO();
objlienrelaseview.pFdaccountno = dr["fdaccountno"];
objlienrelaseview.pMembername = dr["membername"];
objlienrelaseview.pTenor = dr["tenor"];
objlienrelaseview.pDepositamount = dr["depositamount"];
objlienrelaseview.pLienamount = dr["lienamount"];
objlienrelaseview.pCompanybranch = dr["companybranch"];
objlienrelaseview.pLienadjuestto = dr["lienadjuestto"];
objlienrelaseview.pLienid = dr["lienid"];
objlienrelaseview.pLiendate = dr["liendate"];
objlienrelaseview.pLienrealsedate = dr["lienrealsedate"];
lstleinreleaseview.Add(objlienrelaseview);
}
}
}
catch (Exception ex)
{
throw ex;
}
LienReleaseviewDTO listlienrelease = new LienReleaseviewDTO();
listlienrelease.LienReleaselist = lstleinreleaseview;
return(listlienrelease);
}
