public async Task <IActionResult> GetBondsPreviewDetails(string fdaccountnos)
{
try
{
BondspreviewMain BondsPreviewDetails = await objBondprview.GetBondsPreviewDetails(fdaccountnos, Con);
return(BondsPreviewDetails != null?Ok(BondsPreviewDetails) : (IActionResult)StatusCode(StatusCodes.Status204NoContent));
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
public async Task <BondspreviewMain> GetBondsPreviewDetails(string fdaccountnos, string ConnectionString)
{
BondspreviewMain _BondspreviewMain = new BondspreviewMain();
List <BondsPreviewDTO> lstBondsPreviewDetails = new List <BondsPreviewDTO>();
_BondspreviewMain._BondsPreviewDTOLst = new List <BondsPreviewDTO>();
await Task.Run(() =>
{
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select tf.contactid,fdaccountid,fdaccountno,membername,depositamount,interestrate,maturityamount,interestpayable,depositdate,maturitydate,interestpayout,tenor,tenortype,case when tc.fathername='' then tc.spousename else tc.fathername end as fathername ,tca.address1 || ',' || tca.address2 || ',' || tca.city || ',' || tca.district || ',' || tca.state || '-' || tca.pincode as address,tf.squareyard from tbltransfdcreation tf left join tblmstcontact tc on tf.contactid = tc.contactid left join tblmstcontactaddressdetails tca on tf.contactid = tca.contactid where bondprintstatus = 'N' and fdaccountno in(" + fdaccountnos + ");"))
{
while (dr.Read())
{
BondsPreviewDTO objBondsPreviewDetails = new BondsPreviewDTO();
objBondsPreviewDetails.pFdaccountid = dr["fdaccountid"];
objBondsPreviewDetails.pFdaccountno = dr["fdaccountno"];
objBondsPreviewDetails.pDepositamount = dr["depositamount"];
objBondsPreviewDetails.pInterestrate = dr["interestrate"];
objBondsPreviewDetails.pMaturityamount = dr["maturityamount"];
objBondsPreviewDetails.pInterestpayable = dr["interestpayable"];
objBondsPreviewDetails.pDepositdate = Convert.ToDateTime(dr["depositdate"]).ToString("dd/MMM/yyyy");
objBondsPreviewDetails.pMaturitydate = Convert.ToDateTime(dr["maturitydate"]).ToString("dd/MMM/yyyy");
objBondsPreviewDetails.pInterestpayout = dr["interestpayout"];
objBondsPreviewDetails.pFathername = dr["fathername"];
objBondsPreviewDetails.pMembername = dr["membername"];
objBondsPreviewDetails.pAddress = dr["address"];
objBondsPreviewDetails.pTenor = dr["tenor"];
objBondsPreviewDetails.pTenortype = dr["tenortype"];
objBondsPreviewDetails.pSquareyard = dr["squareyard"];
objBondsPreviewDetails.plstNomieeDetails = new List <NomieeDetailsDTO>();
using (NpgsqlDataReader dr1 = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select nomineename,relationship,percentage from tabapplicationpersonalnomineedetails where vchapplicationid='" + objBondsPreviewDetails.pFdaccountno + "' and percentage>0; "))
{
while (dr1.Read())
{
NomieeDetailsDTO objNomieeDetails = new NomieeDetailsDTO();
objNomieeDetails.pNomieename = dr1["nomineename"];
objNomieeDetails.pReletaion = dr1["relationship"];
objNomieeDetails.pProportion = dr1["percentage"];
objBondsPreviewDetails.plstNomieeDetails.Add(objNomieeDetails);
}
}
objBondsPreviewDetails.plstLienDetails = new List <LienDetailsDTO>();
using (NpgsqlDataReader dr2 = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select lienadjuestto,companybranch,companyname from tbltranslienentry where lienstatus='N' and fdaccountno='" + objBondsPreviewDetails.pFdaccountno + "'; "))
{
while (dr2.Read())
{
LienDetailsDTO objliendetails = new LienDetailsDTO();
objliendetails.pLiento = dr2["lienadjuestto"];
objliendetails.pCompanybranch = dr2["companybranch"];
objliendetails.pCompanyname = dr2["companyname"];
objBondsPreviewDetails.plstLienDetails.Add(objliendetails);
}
}
_BondspreviewMain._BondsPreviewDTOLst.Add(objBondsPreviewDetails);
}
}
}
catch (Exception ex)
{
throw ex;
}
});
return(_BondspreviewMain);
}
