public HttpResponseMessage AddUsers(UserSectionAddRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <int> response = new ItemResponse <int>();
string userId = UserService.GetCurrentUserId();
response.Item = _sectionService.AddUserSection(model, userId);
return(Request.CreateResponse(response));
}
public int AddUserSection(UserSectionAddRequest model, string userId)
{
var id = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.UserSections_Insert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@UserId", userId);
paramCollection.AddWithValue("@SectionId", model.SectionId);
paramCollection.AddWithValue("@EnrollmentStatusId", model.EnrollmentStatusId);
SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
paramCollection.Add(p);
},
returnParameters : delegate(SqlParameterCollection para)
{
int.TryParse(para["@Id"].Value.ToString(), out id);
}
);
return(id);
}
