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