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); }