public HttpResponseMessage Create(Troll_UserAddRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <int> response = new ItemResponse <int>();
response.Item = _service.Insert(model);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
public int Insert(Troll_UserAddRequest model)
{
int id = 0;
string procName = "[dbo].[Trolli_User_Insert]";
_dataProvider.ExecuteNonQuery(procName
, inputParamMapper : delegate(SqlParameterCollection sqlParams)
{
sqlParams.AddWithValue("@Password", model.Password);
sqlParams.AddWithValue("@UserName", model.UserName);
SqlParameter idParameter = new SqlParameter("@Id", System.Data.SqlDbType.Int);
idParameter.Direction = System.Data.ParameterDirection.Output;
sqlParams.Add(idParameter);
}, returnParameters : delegate(SqlParameterCollection sqlParams)
{
Int32.TryParse(sqlParams["@Id"].Value.ToString(), out id);
}
);
return(id);
}
