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