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