public async Task <InsuranceschemeDetails> GetInsuranceSchemeDetails(long InsuranceSchemeId, string ConnectionString) { await Task.Run(() => { try { using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select distinct insuranceschemecode,tii.insuranceschemeconfigid,tii.insuranceschemename,insuranceduration,coalesce( premiumamountpayable,0)as premiumamountpayable ,premiumpayin,insuranceclaimpayoutevent,coalesce( insuranceclaimamount,0) as insuranceclaimamount,coalesce( premiumrefund,false) as premiumrefund from tblmstinsuranceconfigdetails ti join tblmstinsuranceconfig tii on ti.insuranceschemeconfigid=tii.insuranceschemeconfigid where tii.insuranceschemeconfigid=" + InsuranceSchemeId + " and tii.statusid=" + Convert.ToInt32(Status.Active) + "; ")) { while (dr.Read()) { _InsuranceschemeDetails = new InsuranceschemeDetails { InsuranceschemeId = Convert.ToInt64(dr["insuranceschemeconfigid"]), InsuranceschemeCode = Convert.ToString(dr["insuranceschemecode"]), Claimamount = Convert.ToDecimal(dr["insuranceclaimamount"]), ClaimType = Convert.ToString(dr["insuranceclaimpayoutevent"]), Premiumamount = Convert.ToDecimal(dr["premiumamountpayable"]), PremiumPayin = Convert.ToString(dr["premiumpayin"]), InsuranceschemeDuration = Convert.ToString(dr["insuranceduration"]), IspremiumRefund = Convert.ToBoolean(dr["premiumrefund"]), }; } } } catch (Exception) { throw; } }); return(_InsuranceschemeDetails); }
public async Task <IActionResult> GetInsuranceSchemeDetails(long InsuranceSchemeId) { try { InsuranceschemeDetails _InsuranceschemeDetails = await _InsuranceMember.GetInsuranceSchemeDetails(InsuranceSchemeId, Con); if (_InsuranceschemeDetails != null) { return(Ok(_InsuranceschemeDetails)); } else { return(StatusCode(StatusCodes.Status204NoContent)); } } catch (Exception) { return(StatusCode(StatusCodes.Status500InternalServerError)); } }