public Int64 AddUnwriterReviewDetail(UnderWriterReview detail)
{
try
{
using (IDbConnection db = new SqlConnection(ConnectionString))
{
string sql = "EXEC uspInsertReviewDetail @TempPolicyNo,@IsAadharNoVerified,@IsPanNoVerified,@IsMedicalCheckupVerified,@CreatedBy,@PolicyStatus";
var returnId = db.ExecuteScalar <int>(sql, new
{
TempPolicyNo = detail.TempPolicyNo,
IsAadharNoVerified = detail.IsAadharNoVerified,
IsPanNoVerified = detail.IsPanNoVerified,
IsMedicalCheckupVerified = detail.IsMedicalCheckupVerified,
CreatedBy = detail.CreatedBy,
PolicyStatus = detail.PolicyStatus
});
return(returnId);
}
}
catch (Exception ex)
{
return(0);
}
}
public long AddUnwriterReviewDetail([FromBody] UnderWriterReview detail)
{
long result = 0;
try
{
result = repository.AddUnwriterReviewDetail(detail);
PolicyDetailViewModel policydetail = repository.GetPolicyAllDetail(detail.TempPolicyNo);
SendApproveMail(policydetail);
}
catch (Exception dbEx)
{
return(result);
}
return(result);
}
