public void UpdateMood(MoodBoardUpdateRequestModel req) { using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("MoodBoard_Update", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mood", req.Mood); cmd.Parameters.AddWithValue("@soundByteURL", req.SoundByteUrl); cmd.Parameters.AddWithValue("@icon", req.Icon); cmd.Parameters.AddWithValue("@id", req.Id); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } }
public HttpResponseMessage UpdateMood(MoodBoardUpdateRequestModel model) { if (model == null) { ModelState.AddModelError("", "You did not send any mood data!"); } if (!ModelState.IsValid) { return(Request.CreateErrorResponse( HttpStatusCode.BadRequest, ModelState )); } IMoodBoardService moodBoardService = new MoodBoardService(); moodBoardService.UpdateMood(model); return(Request.CreateResponse(HttpStatusCode.OK)); }