public IActionResult createNavip([FromBody] npf_NavipContribution value)
{
try
{
if (navipservice.checksvc(value.PersonID).Result != null)
{
navipservice.updateNavip(value);
//var getnavip2 = navipservice.checksvc(value.PersonID).Result;
using (SqlConnection sqls = new SqlConnection(_connectionstring))
{
using (SqlCommand cmd = new SqlCommand("npf_calculate_navip", sqls))
{
cmd.CommandTimeout = 1200;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@globaluser", User.Identity.Name));
cmd.Parameters.Add(new SqlParameter("@perid", value.PersonID));
sqls.Open();
cmd.ExecuteNonQuery();
return(Ok(new { responseCode = 200, responseDescription = "Calculation Successfully" }));
}
}
//return Ok(new { responseCode = 400, responseDescription = "Navip Claim Has Been Added" });
}
else
{
navipservice.AddNavip(value);
}
var getnavip = navipservice.checksvc(value.PersonID).Result;
if (getnavip != null)
{
using (SqlConnection sqls = new SqlConnection(_connectionstring))
{
using (SqlCommand cmd = new SqlCommand("npf_calculate_navip", sqls))
{
cmd.CommandTimeout = 1200;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@globaluser", User.Identity.Name));
cmd.Parameters.Add(new SqlParameter("@perid", getnavip.PersonID));
sqls.Open();
cmd.ExecuteNonQuery();
return(Ok(new { responseCode = 200, responseDescription = "Calculation Successfully" }));
}
}
}
else
{
return(Ok(new { responseCode = 400, responseDescription = "Navip Claim Has Not Been Added" }));
}
}
catch (Exception ex)
{
return(Ok(new { responseCode = 500, responseDescription = "Failed" }));
}
}
public async Task <bool> updateNavip(npf_NavipContribution navips)
{
unitOfWork.navip.Update(navips);
return(await unitOfWork.Done());
}
