public HttpResponseMessage CreateMood(CreateMoodModel 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();
int id = moodBoardService.CreateMood(model);
return(Request.CreateResponse(HttpStatusCode.Created, id));
}
public int CreateMood(CreateMoodModel req)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand("MoodBoard_Create", 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.Add("@id", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int id = (int)cmd.Parameters["@id"].Value;
return(id);
}
}
