public HttpResponseMessage Put(ProposalUpdateRequest model) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState)); } ItemResponse <int?> response = new ItemResponse <int?>(); response.Item = ProposalService.Update(model); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public static int?Update(ProposalUpdateRequest model) { int?projectId = null; DataProvider.ExecuteNonQuery(GetConnection, "dbo.Proposal_Update", inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Id", model.Id); paramCollection.AddWithValue("@Description", model.Description); paramCollection.AddWithValue("@Budget", model.Budget); paramCollection.AddWithValue("@Deadline", model.Deadline); paramCollection.AddWithValue("@ProjectType", model.ProjectType); paramCollection.AddWithValue("@FirstName", model.FirstName); paramCollection.AddWithValue("@LastName", model.LastName); paramCollection.AddWithValue("@Company", model.Company); paramCollection.AddWithValue("@PhoneNumber", model.PhoneNumber); paramCollection.AddWithValue("@Email", model.Email); paramCollection.AddWithValue("@Notes", model.Notes); paramCollection.AddWithValue("@Status", model.Status.Id); paramCollection.AddWithValue("@UserIdCreated", UserService.GetCurrentUserId()); SqlParameter p = new SqlParameter("@ProjectId", SqlDbType.Int); p.Direction = ParameterDirection.Output; paramCollection.Add(p); }, returnParameters : delegate(SqlParameterCollection param) { var projectIdParam = param["@ProjectId"].Value; if (projectIdParam is DBNull) { projectId = null; } else { projectId = (int)projectIdParam; } }); return(projectId); }