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