public async Task <IActionResult> GetMemberDetailsforEdit(string MemberReferenceID, long Recordid)
{
_GetInsuranceMemberDataforEdit = new GetInsuranceMemberDataforEdit();
try
{
_GetInsuranceMemberDataforEdit = await _InsuranceMember.GetMemberDetailsforEdit(Recordid, Con);
_GetInsuranceMemberDataforEdit._InsuranceMemberNomineeDetailsEditList = await _InsuranceMember.GetInsuranceMemberNomineeDetails(MemberReferenceID, Con);
_GetInsuranceMemberDataforEdit._InsuranceschemeDetailsEdit = await _InsuranceMember.GetInsuranceSchemeDetails(_GetInsuranceMemberDataforEdit.pSchemeId, Con);
if (_GetInsuranceMemberDataforEdit != null)
{
return(Ok(_GetInsuranceMemberDataforEdit));
}
else
{
return(StatusCode(StatusCodes.Status204NoContent));
}
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
public async Task <GetInsuranceMemberDataforEdit> GetMemberDetailsforEdit(long Recordid, string ConnectionString)
{
await Task.Run(() =>
{
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select ti.recordid, coalesce(ti.applicanttype,'') as applicanttype, to_char(ti.transdate,'DD/MM/YYYY')transdate,insurancetype,tm.membertypeid,tm.membertype, memberid, ti.membername, ti.membercode,ti.membercode || '_' || ti.membername as membercodeandname,ti.insuranceschemeconfigid,ti.insuranceschemename,to_char(policystartdate,'DD/MM/YYYY') policystartdate, to_char(policyenddate,'DD/MM/YYYY') policyenddate, policycoverageperiod,tm.contactid,tm.contactreferenceid from tbltransinsurancemember ti join tblmstmembers tm on tm.membercode = ti.membercode where ti.recordid=" + Recordid + " and ti.statusid=" + Convert.ToInt32(Status.Active) + ";"))
{
while (dr.Read())
{
_GetInsuranceMemberDataforEdit = new GetInsuranceMemberDataforEdit()
{
pRecordid = Convert.ToInt64(dr["recordid"]),
pMemberId = Convert.ToInt64(dr["memberid"]),
pMemberCodeandName = Convert.ToString(dr["membercodeandname"]),
pInsuranceType = Convert.ToString(dr["insurancetype"]),
pTransdate = Convert.ToString(dr["transdate"]),
pMembertype = Convert.ToString(dr["membertype"]),
pMembertypeId = Convert.ToInt64(dr["membertypeid"]),
pSchemeId = Convert.ToInt64(dr["insuranceschemeconfigid"]),
pSchemeName = Convert.ToString(dr["insuranceschemename"]),
pPolicystartdate = dr["policystartdate"] == DBNull.Value ? null : Convert.ToString(dr["policystartdate"]),
pPolicyenddate = dr["policyenddate"] == DBNull.Value ? null : Convert.ToString(dr["policyenddate"]),
pPolicycoveragePeriod = Convert.ToString(dr["policycoverageperiod"]),
pApplicanttype = Convert.ToString(dr["applicanttype"]),
Contactid = Convert.ToInt64(dr["contactid"]),
pContactrefid = Convert.ToString(dr["contactreferenceid"])
};
}
}
}
catch (Exception)
{
throw;
}
});
return(_GetInsuranceMemberDataforEdit);
}
