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