public GetmemberfddetailsDTO Getmemberfddetails(long Memberid, string Fdraccountno, string connectionstring)
{
GetmemberfddetailsDTO _Memberfdrdata1 = new GetmemberfddetailsDTO();
try
{
NpgsqlDataReader dr;
using (dr = NPGSqlHelper.ExecuteReader(connectionstring, CommandType.Text, "SELECT membername,depositamount,tenor,transdate,tf.fdaccountno,tf.tenortype,sum(COALESCE(lienamount,0))lienamount, ((depositamount-(depositamount*5/100))-COALESCE(sum(lienamount),0)) as Balance FROM tbltransfdcreation tf left join tbltranslienentry te on tf.fdaccountno=te.fdaccountno and te.statusid = " + Convert.ToInt32(Status.Active) + " and lienstatus='N' where memberid = " + Memberid + " and tf.fdaccountno ='" + Fdraccountno + "' and tf.statusid = " + Convert.ToInt32(Status.Active) + " group by membername,depositamount,tenor,transdate,tf.fdaccountno,tf.tenortype"))
{
if (dr.Read())
{
_Memberfdrdata1 = new GetmemberfddetailsDTO
{
pMembername = dr["membername"],
pDepositamount = dr["depositamount"],
pTenor = dr["tenor"],
pTransdate = dr["transdate"],
pFdaccountno = dr["fdaccountno"],
pTenortype = dr["tenortype"],
pBalance = dr["Balance"]
};
}
}
}
catch (Exception)
{
throw;
}
return(_Memberfdrdata1);
}
public IActionResult Getmemberfddetails(Int64 Memberid, string Fdraccountno)
{
GetmemberfddetailsDTO lstgetmemberfddetails = new GetmemberfddetailsDTO();
try
{
lstgetmemberfddetails = Objlienentry.Getmemberfddetails(Memberid, Fdraccountno, Con);
}
catch (Exception ex)
{
throw new FinstaAppException(ex.ToString());
}
return(Ok(lstgetmemberfddetails));
}
