public IActionResult SaveInsuranceMemberData([FromBody] InsuranceMembersave _InsuranceMembersave) { try { if (_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave.Count > 0) { string OldFolder = "Upload"; string NewFolder = "Original"; string webRootPath = _hostingEnvironment.ContentRootPath; string OldPath = Path.Combine(webRootPath, OldFolder); string newPath = Path.Combine(webRootPath, NewFolder); if (!Directory.Exists(newPath)) { Directory.CreateDirectory(newPath); } foreach (InsuranceMemberNomineeDetails kycDoc in _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave) { if (!string.IsNullOrEmpty(kycDoc.Idproofpath)) { string OldFullPath = Path.Combine(OldPath, kycDoc.Idproofpath); string NewFullPath = Path.Combine(newPath, kycDoc.Idproofpath); kycDoc.Idproofpath = NewFullPath; if (System.IO.File.Exists(OldFullPath)) { System.IO.File.Move(OldFullPath, NewFullPath); } } } } if (_InsuranceMember.SaveInsuranceMemberData(_InsuranceMembersave, Con)) { return(Ok(true)); } else { return(StatusCode(StatusCodes.Status304NotModified)); } } catch (Exception) { return(StatusCode(StatusCodes.Status500InternalServerError)); } }
public bool SaveInsuranceMemberData(InsuranceMembersave _InsuranceMembersave, string ConnectionString) { StringBuilder sbSaveInsuranceMember = new StringBuilder(); StringBuilder sbupdate = new StringBuilder(); bool IsSaved = false; try { con = new NpgsqlConnection(ConnectionString); if (con.State != ConnectionState.Open) { con.Open(); } trans = con.BeginTransaction(); if (string.IsNullOrEmpty(_InsuranceMembersave.pTransdate)) { _InsuranceMembersave.pTransdate = "null"; } else { _InsuranceMembersave.pTransdate = "'" + FormatDate(_InsuranceMembersave.pTransdate) + "'"; } if (string.IsNullOrEmpty(_InsuranceMembersave.pPolicystartdate)) { _InsuranceMembersave.pPolicystartdate = "null"; } else { _InsuranceMembersave.pPolicystartdate = "'" + FormatDate(_InsuranceMembersave.pPolicystartdate) + "'"; } if (string.IsNullOrEmpty(_InsuranceMembersave.pPolicyenddate)) { _InsuranceMembersave.pPolicyenddate = "null"; } else { _InsuranceMembersave.pPolicyenddate = "'" + FormatDate(_InsuranceMembersave.pPolicyenddate) + "'"; } if (Convert.ToString(_InsuranceMembersave.pPremiumamount) == string.Empty) { _InsuranceMembersave.pPremiumamount = 0; } if (!string.IsNullOrEmpty(_InsuranceMembersave.ptypeofoperation)) { if (ManageQuote(_InsuranceMembersave.ptypeofoperation).ToUpper() == "CREATE") { sbSaveInsuranceMember.AppendLine("INSERT INTO tbltransinsurancemember(transdate, insurancetype, membertypeid, membertype,membercode, membername, insuranceschemeconfigid, insuranceschemename,policystartdate, policyenddate, policycoverageperiod, statusid,createdby, createddate,premiumamount,applicanttype) VALUES (" + _InsuranceMembersave.pTransdate + ",'" + _InsuranceMembersave.pInsuranceType + "'," + _InsuranceMembersave.pMembertypeId + ",'" + _InsuranceMembersave.pMembertype + "','" + _InsuranceMembersave.pMemberCodeandName.Split('_')[0] + "','" + _InsuranceMembersave.pMemberCodeandName.Split('_')[1] + "'," + _InsuranceMembersave.pSchemeId + " ,'" + _InsuranceMembersave.pSchemeName + "'," + _InsuranceMembersave.pPolicystartdate + "," + _InsuranceMembersave.pPolicyenddate + ",'" + _InsuranceMembersave.pPolicycoveragePeriod + "'," + Convert.ToInt32(Status.Active) + "," + _InsuranceMembersave.pCreatedby + ",current_timestamp," + _InsuranceMembersave.pPremiumamount + " ,'" + ManageQuote(_InsuranceMembersave.pApplicanttype) + "');"); } else if (ManageQuote(_InsuranceMembersave.ptypeofoperation).ToUpper() == "UPDATE") { sbSaveInsuranceMember.AppendLine("UPDATE tbltransinsurancemember SET transdate=" + _InsuranceMembersave.pTransdate + ", insurancetype='" + _InsuranceMembersave.pInsuranceType + "', membertypeid=" + _InsuranceMembersave.pMembertypeId + ", membertype='" + _InsuranceMembersave.pMembertype + "',insuranceschemeconfigid=" + _InsuranceMembersave.pSchemeId + ", insuranceschemename='" + _InsuranceMembersave.pSchemeName + "', policystartdate=" + _InsuranceMembersave.pPolicystartdate + ", policyenddate=" + _InsuranceMembersave.pPolicyenddate + ", policycoverageperiod='" + _InsuranceMembersave.pPolicycoveragePeriod + "', modifiedby=" + _InsuranceMembersave.pCreatedby + ", modifieddate=current_timestamp,premiumamount=" + _InsuranceMembersave.pPremiumamount + ",applicanttype='" + ManageQuote(_InsuranceMembersave.pApplicanttype) + "' WHERE membercode='" + _InsuranceMembersave.pMemberCodeandName.Split('_')[0] + "' and insurancetype='" + _InsuranceMembersave.pInsuranceType + "';"); } } string Recordid = string.Empty; if (_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave != null && _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave.Count > 0) { for (int i = 0; i < _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave.Count; i++) { if (!string.IsNullOrEmpty(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].ptypeofoperation) && _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].ptypeofoperation.Trim().ToUpper() != "CREATE" ) { if (string.IsNullOrEmpty(Recordid)) { Recordid = _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].pRecordid.ToString(); } else { Recordid = Recordid + "," + _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].pRecordid.ToString(); } } if (!string.IsNullOrEmpty(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].ptypeofoperation)) { _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].ptypeofoperation = _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].ptypeofoperation.ToUpper(); } if (string.IsNullOrEmpty(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].Dateofbirth)) { _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].Dateofbirth = "null"; } else { _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].Dateofbirth = "'" + FormatDate(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].Dateofbirth) + "'"; } if (_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].ptypeofoperation == "CREATE") { sbSaveInsuranceMember.AppendLine("insert into tabapplicationpersonalnomineedetails(applicationid, vchapplicationid, contactid, contactreferenceid, nomineename, relationship, dateofbirth, contactno, idprooftype, idproofname, referencenumber, docidproofpath, statusid, createdby, createddate,applicantype,isprimarynominee) values ('" + _InsuranceMembersave.pMemberId + "', '" + ManageQuote(_InsuranceMembersave.pMemberCodeandName.Split('_')[0]) + "', '" + _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].Contactid + "', '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].pContactrefid) + "', '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].pNomineeName) + "', '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].pNomimneeRelation) + "', " + _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].Dateofbirth + ", '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].ContactNo) + "', '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].IdproofType) + "', '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].IdProofname) + "', '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].IdproofReferenceNo) + "', '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].Idproofpath) + "', " + Convert.ToInt32(Status.Active) + ", '" + _InsuranceMembersave.pCreatedby + "', current_timestamp,'INSURANCE'," + _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].Isprimarynominee + ");"); } if (_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].ptypeofoperation != "CREATE") { sbSaveInsuranceMember.AppendLine("update tabapplicationpersonalnomineedetails set contactid = '" + _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].Contactid + "', contactreferenceid = '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].pContactrefid) + "', nomineename = '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].pNomineeName) + "', relationship = '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].pNomimneeRelation) + "', dateofbirth = " + _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].Dateofbirth + ", contactno = '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].ContactNo) + "', idprooftype = '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].IdproofType) + "', idproofname = '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].IdProofname) + "', referencenumber = '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].IdproofReferenceNo) + "', docidproofpath = '" + ManageQuote(_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].Idproofpath) + "', statusid = " + Convert.ToInt32(Status.Active) + ", modifiedby = '" + _InsuranceMembersave.pCreatedby + "', modifieddate = current_timestamp,isprimarynominee=" + _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].Isprimarynominee + " where vchapplicationid = '" + ManageQuote(_InsuranceMembersave.pMemberCodeandName.Split('_')[0]) + "' and applicationid = " + _InsuranceMembersave.pMemberId + " and recordid = " + _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave[i].pRecordid + ";"); } } } if (!string.IsNullOrEmpty(Recordid)) { sbupdate.AppendLine("UPDATE tabapplicationpersonalnomineedetails SET STATUSID=" + Convert.ToInt32(Status.Inactive) + ", modifiedby = " + _InsuranceMembersave.pCreatedby + ", modifieddate = CURRENT_TIMESTAMP WHERE applicationid=" + _InsuranceMembersave.pMemberId + " and vchapplicationid='" + ManageQuote(_InsuranceMembersave.pMemberCodeandName.Split('_')[0]) + "' AND RECORDID not in(" + Recordid + ") and upper(applicantype)='INSURANCE'; "); } else { if (_InsuranceMembersave._InsuranceMemberNomineeDetailsListSave == null || _InsuranceMembersave._InsuranceMemberNomineeDetailsListSave.Count == 0) { sbupdate.AppendLine("UPDATE tabapplicationpersonalnomineedetails SET STATUSID=" + Convert.ToInt32(Status.Inactive) + ", modifiedby = " + _InsuranceMembersave.pCreatedby + ", modifieddate = CURRENT_TIMESTAMP WHERE applicationid=" + _InsuranceMembersave.pMemberId + " and vchapplicationid='" + ManageQuote(_InsuranceMembersave.pMemberCodeandName.Split('_')[0]) + "' and upper(applicantype)='INSURANCE'; "); } } if (Convert.ToString(sbSaveInsuranceMember) != string.Empty) { NPGSqlHelper.ExecuteNonQuery(trans, CommandType.Text, sbupdate.ToString() + " " + sbSaveInsuranceMember.ToString()); trans.Commit(); IsSaved = true; } } catch (Exception Ex) { trans.Rollback(); throw Ex; } finally { if (con.State == ConnectionState.Open) { con.Dispose(); con.Close(); con.ClearPool(); trans.Dispose(); } } return(IsSaved); }