public static int AddGradebookEntry(GradebookEntryAddRequest model) { int id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.AddGradebookEntry" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { if (model != null) { //@UserId should be obtained via a get paramCollection.AddWithValue("@AssignmentId", model.AssignmentId); paramCollection.AddWithValue("@PointsEarned", model.PointsEarned); paramCollection.AddWithValue("@InstructorComments", model.InstructorComments); paramCollection.AddWithValue("@UserId", model.UserId); } 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 AddEntryToGradebook(GradebookEntryAddRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } ItemResponse <int> response = new ItemResponse <int>(); response.Item = GradebookService.AddGradebookEntry(model); return(Request.CreateResponse(response)); }