public int PostMeal(UserMealAddRequest model)
{
int result = 0;
using (SqlConnection conn = new SqlConnection(connectionString))
{
string cmdText = "Meal_Insert";
using (SqlCommand cmd = new SqlCommand(cmdText, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter parm = new SqlParameter();
parm.ParameterName = "@Id";
parm.SqlDbType = System.Data.SqlDbType.Int;
parm.Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(parm);
cmd.Parameters.AddWithValue("@AccountId", model.AccountId);
cmd.Parameters.AddWithValue("@Meal", model.Meal);
cmd.Parameters.AddWithValue("@Quantity", model.Quantity);
conn.Open();
cmd.ExecuteNonQuery();
result = (int)cmd.Parameters["@Id"].Value;
conn.Close();
}
}
return(result);
}
public HttpResponseMessage PostMeal(UserMealAddRequest model)
{
try
{
if (ModelState.IsValid)
{
UserService svc = new UserService();
ItemResponse <int> response = new ItemResponse <int>();
response.Item = svc.PostMeal(model);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
