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