public void Update(UserMealUpdateRequest model)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
string cmdText = "Meal_Update";
using (SqlCommand cmd = new SqlCommand(cmdText, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", model.Id);
cmd.Parameters.AddWithValue("@AccountId", model.AccountId);
cmd.Parameters.AddWithValue("@Meal", model.Meal);
cmd.Parameters.AddWithValue("@Quantity", model.Quantity);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
public HttpResponseMessage UpdateMeal(UserMealUpdateRequest model)
{
try
{
if (ModelState.IsValid)
{
UserService svc = new UserService();
SuccessResponse response = new SuccessResponse();
svc.Update(model);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
