public InsurenceNameAndCodeDTO GetInsurenceNameAndCodeDetails(string InsurenceName, string InsurenceNameCode, string ConnectionString)
{
InsurenceNameAndCodeDTO objInsurenceNameAndCode = new InsurenceNameAndCodeDTO();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select insuranceschemeconfigid,insuranceschemename,insuranceschemecode,companycode,branchcode,series,serieslength,insuranceschemenamecode,statusid from tblmstinsuranceconfig where upper(insuranceschemename) = '" + ManageQuote(InsurenceName.ToUpper()) + "' and upper(insuranceschemenamecode) ='" + ManageQuote(InsurenceNameCode.ToUpper()) + "' and statusid = " + Convert.ToInt32(Status.Active) + ";"))
{
while (dr.Read())
{
objInsurenceNameAndCode.pInsurenceconfigid = Convert.ToInt64(dr["insuranceschemeconfigid"]);
objInsurenceNameAndCode.pInsurencename = dr["insuranceschemename"].ToString();
objInsurenceNameAndCode.pInsurencecode = dr["insuranceschemecode"].ToString();
objInsurenceNameAndCode.pCompanycode = dr["companycode"].ToString();
objInsurenceNameAndCode.pBranchcode = dr["branchcode"].ToString();
objInsurenceNameAndCode.pSeries = dr["series"].ToString();
objInsurenceNameAndCode.pSerieslength = Convert.ToInt64(dr["serieslength"]);
objInsurenceNameAndCode.pInsurencenamecode = dr["insuranceschemenamecode"].ToString();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(objInsurenceNameAndCode);
}
public IActionResult GetInsurenceNameAndCodeDetails(string InsurenceName, string InsurenceNameCode)
{
InsurenceNameAndCodeDTO objInsurenceNameAndCode = new InsurenceNameAndCodeDTO();
try
{
objInsurenceNameAndCode = objInsurenceconfig.GetInsurenceNameAndCodeDetails(InsurenceName, InsurenceNameCode, Con);
return(objInsurenceNameAndCode != null?Ok(objInsurenceNameAndCode) : (IActionResult)StatusCode(StatusCodes.Status204NoContent));
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
throw;
}
}
public string SaveInsurenceNameAndCode(InsurenceNameAndCodeDTO InsurenceNameAndCode, string ConnectionString, out long insurenceconfigid)
{
StringBuilder Sbinsert = new StringBuilder();
try
{
con = new NpgsqlConnection(ConnectionString);
if (con.State != ConnectionState.Open)
{
con.Open();
}
trans = con.BeginTransaction();
if (!string.IsNullOrEmpty(InsurenceNameAndCode.ptypeofoperation) && InsurenceNameAndCode.ptypeofoperation.Trim().ToUpper() == "CREATE")
{
InsurenceNameAndCode.pInsurenceconfigid = Convert.ToInt64(NPGSqlHelper.ExecuteScalar(trans, CommandType.Text, "insert into tblmstinsuranceconfig (InsuranceSchemeName,InsuranceSchemecode,companycode,branchcode,series,serieslength,InsuranceSchemenamecode,statusid,createdby,createddate)values('" + ManageQuote(InsurenceNameAndCode.pInsurencename) + "','" + ManageQuote(InsurenceNameAndCode.pInsurencecode) + "','" + ManageQuote(InsurenceNameAndCode.pCompanycode) + "','" + ManageQuote(InsurenceNameAndCode.pBranchcode) + "','" + ManageQuote(InsurenceNameAndCode.pSeries) + "'," + InsurenceNameAndCode.pSerieslength + ",'" + ManageQuote(InsurenceNameAndCode.pInsurencenamecode) + "'," + Convert.ToInt32(Status.Active) + "," + InsurenceNameAndCode.pCreatedby + ",current_timestamp) returning InsuranceSchemeconfigid;"));
}
else if (!string.IsNullOrEmpty(InsurenceNameAndCode.ptypeofoperation) && InsurenceNameAndCode.ptypeofoperation.Trim().ToUpper() == "UPDATE")
{
Sbinsert.Append("update tblmstinsuranceconfig set InsuranceSchemeName='" + ManageQuote(InsurenceNameAndCode.pInsurencename) + "',InsuranceSchemecode='" + ManageQuote(InsurenceNameAndCode.pInsurencecode) + "',companycode='" + ManageQuote(InsurenceNameAndCode.pCompanycode) + "',branchcode='" + ManageQuote(InsurenceNameAndCode.pBranchcode) + "',series='" + ManageQuote(InsurenceNameAndCode.pSeries) + "',serieslength=" + InsurenceNameAndCode.pSerieslength + ",InsuranceSchemenamecode='" + ManageQuote(InsurenceNameAndCode.pInsurencenamecode) + "',statusid=" + Convert.ToInt32(Status.Active) + ",modifiedby=" + InsurenceNameAndCode.pCreatedby + ",modifieddate=current_timestamp where InsuranceSchemeconfigid=" + InsurenceNameAndCode.pInsurenceconfigid + ";");
}
if (!string.IsNullOrEmpty(Sbinsert.ToString()))
{
NPGSqlHelper.ExecuteNonQuery(trans, CommandType.Text, Sbinsert.ToString());
}
trans.Commit();
insurenceconfigid = InsurenceNameAndCode.pInsurenceconfigid;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Dispose();
con.Close();
con.ClearPool();
trans.Dispose();
}
}
return(InsurenceNameAndCode.pInsurencename);
}
public IActionResult SaveInsurenceNameAndCode([FromBody] InsurenceNameAndCodeDTO InsurenceNameAndCode)
{
InsurenceNameAndCodeDTO Insurencenamecode = new InsurenceNameAndCodeDTO();
try
{
long insurenceconfigid = 0;
string isurencename = objInsurenceconfig.SaveInsurenceNameAndCode(InsurenceNameAndCode, Con, out insurenceconfigid);
if (!string.IsNullOrEmpty(isurencename))
{
Insurencenamecode.pInsurencename = isurencename;
Insurencenamecode.pInsurenceconfigid = insurenceconfigid;
return(Ok(Insurencenamecode));
}
else
{
return(StatusCode(StatusCodes.Status304NotModified));
}
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
