public static int AddAssignment(AssignmentAddRequest model) { int id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.AddAssignment" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { if (model != null) { //@UserId should be obtained via a get paramCollection.AddWithValue("@AssignmentName", model.AssignmentName); paramCollection.AddWithValue("@AssignmentTypeId", model.AssignmentTypeId); paramCollection.AddWithValue("@TotalPoints", model.TotalPoints); paramCollection.AddWithValue("@Period", model.Period); } SqlParameter p = new SqlParameter("@Id", SqlDbType.Int); p.Direction = ParameterDirection.Output; paramCollection.Add(p); }, returnParameters : delegate(SqlParameterCollection param) { int.TryParse(param["@Id"].Value.ToString(), out id); } ); return(id); }
public HttpResponseMessage AddAssignment(AssignmentAddRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } ItemResponse <int> response = new ItemResponse <int>(); response.Item = AssignmentService.AddAssignment(model); return(Request.CreateResponse(response)); }