public async Task <List <LienReleasememberfdDTO> > GetLienrelasedata(string Membercode, string Fdraccountno, string LienDate, string connectionstring)
{
List <LienReleasememberfdDTO> _Lienreleaselist = new List <LienReleasememberfdDTO>();
await Task.Run(() =>
{
try
{
NpgsqlDataReader dr;
using (dr = NPGSqlHelper.ExecuteReader(connectionstring, CommandType.Text, "select to_char(b.liendate,'dd/Mon/yyyy')liendate,a.membername,a.tenor,a.depositamount,lienamount,b.companybranch,b.lienadjuestto,b.lienid from tbltransfdcreation a,tbltranslienentry b where a.MEMBERCODE=b.MEMBERCODE AND a.fdaccountno = b.fdaccountno and a.MEMBERCODE = '" + Membercode + "' and a.fdaccountno = '" + Fdraccountno + "' and b.liendate<='" + FormatDate(LienDate) + "' and b.lienid not in(select lienid from tbltranslienrealse c where c.lienid=b.lienid and c.statusid=1 ) and b.lienstatus = 'N' and b.statusid = " + Convert.ToInt32(Status.Active) + ""))
{
while (dr.Read())
{
LienReleasememberfdDTO _Lienreleasedata = new LienReleasememberfdDTO
{
pLiendate = dr["liendate"],
pMembername = dr["membername"],
pTenor = dr["tenor"],
pDepositamount = dr["depositamount"],
pLienamount = dr["lienamount"],
pCompanybranch = dr["companybranch"],
pLienadjuestto = dr["lienadjuestto"],
pLienid = dr["lienid"]
};
_Lienreleaselist.Add(_Lienreleasedata);
}
}
}
catch (Exception)
{
throw;
}
});
return(_Lienreleaselist);
}
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);
}
