public async Task <List <LienRelasegetmemberDTO> > Getlienreleasefd(string Membercode, string BranchName, string connectionstring)
{
var _Lienrelasefd = new List <LienRelasegetmemberDTO>();
await Task.Run(() =>
{
try
{
NpgsqlDataReader dr;
using (dr = NPGSqlHelper.ExecuteReader(connectionstring, CommandType.Text, "select distinct tl.fdaccountno from tbltranslienentry tl join tbltransfdcreation tf on tl.fdaccountno=tf.fdaccountno and tf.statusid=" + Convert.ToInt32(Status.Active) + " where tl.membercode = '" + Membercode + "' and lienstatus = 'N' and tf.chitbranchname='" + BranchName + "' and tl.statusid = " + Convert.ToInt32(Status.Active) + ""))
{
while (dr.Read())
{
var _Lienrelasefd1 = new LienRelasegetmemberDTO
{
pFdaccountno = dr["fdaccountno"]
};
_Lienrelasefd.Add(_Lienrelasefd1);
}
}
}
catch (Exception)
{
throw;
}
});
return(_Lienrelasefd);
}
public List <LienRelasegetmemberDTO> LienReleasemembercode(string Branchname, string connectionstring)
{
List <LienRelasegetmemberDTO> lstlienreleasemember = new List <LienRelasegetmemberDTO>();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(connectionstring, CommandType.Text, "select distinct tm.memberid,tl.membercode,tm.membername,businessentitycontactno as contactnumber from tbltranslienentry tl join tbltransfdcreation tf on tl.fdaccountno=tf.fdaccountno join tblmstmembers tm on tl.membercode=tm.membercode join tblmstcontact tc on tc.contactid = tm.contactid where tl.lienstatus = 'N' and tl.statusid=" + Convert.ToInt32(Status.Active) + " and tf.statusid=" + Convert.ToInt32(Status.Active) + " and tf.chitbranchname='" + Branchname + "'; "))
{
while (dr.Read())
{
LienRelasegetmemberDTO objlienrelasemember = new LienRelasegetmemberDTO()
{
pMemberid = dr["memberid"],
pMembercode = dr["membercode"],
pMembername = dr["membername"],
pContactnumber = dr["contactnumber"]
};
lstlienreleasemember.Add(objlienrelasemember);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lstlienreleasemember);
}
