public HttpResponseMessage Update(CharacterSceneRequest model) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState)); } CharacterSceneService.Update(model); SuccessResponse response = new SuccessResponse(); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
private static void MapCharacterScene(CharacterSceneRequest model, SqlCommand cmd) { cmd.Parameters.AddWithValue("@CharacterId", model.CharacterId); cmd.Parameters.AddWithValue("@SceneId", model.SceneId); cmd.Parameters.AddWithValue("@CharacterSceneExitTypeId", model.CharacterSceneExitTypeId); cmd.Parameters.AddWithValue("@Start", model.Start ?? String.Empty); cmd.Parameters.AddWithValue("@End", model.End ?? String.Empty); cmd.Parameters.AddWithValue("@Notes", model.Notes ?? String.Empty); cmd.Parameters.AddWithValue("@PhysicalGoal", model.PhysicalGoal ?? String.Empty); cmd.Parameters.AddWithValue("@EmotionalGoal", model.EmotionalGoal ?? String.Empty); cmd.Parameters.AddWithValue("@Obstacle", model.Obstacle ?? String.Empty); }
public static void Update(CharacterSceneRequest model) { using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "dbo.CharacterScene_Update"; MapCharacterScene(model, cmd); cmd.ExecuteNonQuery(); } conn.Close(); } return; }