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