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;
}
