public async Task <ActionResult <ResponseModel> > AddUpdateInsuranceContract(ContractModel model)
{
var result = new ResponseModel();
// Calculate the age.
var age = DateTime.Today.Year - model.DateofBirth.Year;
var objCoverageResponse = _dataContext.GetCoveragePlan(model.CustomerCountry, model.CustomerGender, model.SaleDate, age).ToList();
if (objCoverageResponse != null && objCoverageResponse.Any())
{
var contract = new ContractEntityModel()
{
Id = model.Id,
CustomerName = model.CustomerName,
CustomerAddress = model.CustomerAddress,
CustomerGender = model.CustomerGender,
CustomerCountry = model.CustomerCountry,
DateofBirth = model.DateofBirth,
SaleDate = model.SaleDate,
CoveragePlan = objCoverageResponse.FirstOrDefault()?.CoveragePlan,
NetPrice = objCoverageResponse.FirstOrDefault()?.NetPrice ?? 0
};
var data = new DbStatusResult();
if (model.Id > 0)
{
data = await _dataContext.UpdateInsuranseContractDetail(contract);
}
else
{
data = await _dataContext.AddInsuranseContractDetail(contract);
}
if (!data.Status)
{
result.StatusCode = 404;
result.Message = result.Message;
}
else
{
result.StatusCode = 200;
result.Message = "success";
}
}
else
{
result.StatusCode = 404;
result.Message = "Coverage plan or Net Price not found according criteria so operation has been rollback";
}
return(result);
}
public async Task <DbStatusResult> UpdateInsuranseContractDetail(ContractEntityModel entity)
{
var cmd = new DbStatusCommand();
await ExecuteSQLWithParams("[dbo].[spUpdateContractInfo]",
GetJsonParam("@contractInfo", entity),
cmd.IdParam,
cmd.StatusParam,
cmd.MessageParam);
return(cmd.StatusResult);
}
