public int Add(InsurancePlanAddRequest model, int userId)
{
int id = 0;
string procName = "dbo.InsurancePlans_Insert_V2";
_data.ExecuteNonQuery(procName,
delegate(SqlParameterCollection col)
{
col.AddWithValue("@InsuranceProviderId", model.InsuranceProviderId);
col.AddWithValue("@Name", model.Name);
col.AddWithValue("@PlanTypeId", model.PlanTypeId);
col.AddWithValue("@PlanLevelId", model.PlanLevelId);
col.AddWithValue("@Code", model.Code);
col.AddWithValue("@PlanStatusId", model.PlanStatusId);
col.AddWithValue("@MinAge", model.MinAge);
col.AddWithValue("@MaxAge", model.MaxAge);
col.AddWithValue("@CreatedBy", userId);
SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int);
idOut.Direction = ParameterDirection.Output;
col.Add(idOut);
}, delegate(SqlParameterCollection returnCollection)
{
object returnId = returnCollection["@Id"].Value;
Int32.TryParse(returnId.ToString(), out id);
});
return(id);
}
public ActionResult <ItemResponse <int> > Create(InsurancePlanAddRequest model)
{
ObjectResult result = null;
try
{
int userId = _authService.GetCurrentUserId();
int id = _service.Add(model, userId);
ItemResponse <int> response = new ItemResponse <int>();
response.Item = id;
result = Created201(response);
}
catch (Exception ex)
{
Logger.LogError(ex.ToString());
ErrorResponse response = new ErrorResponse(ex.Message);
result = StatusCode(500, response);
}
return(result);
}