public int Insert(StrengthProfileInsertRequest req) { int id = 0; using (SqlConnection con = new SqlConnection(connString)) { SqlCommand cmd = new SqlCommand("dbo.StrengthProfile_Insert", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter outputParam = cmd.Parameters.Add("@Id", SqlDbType.Int); outputParam.Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@UserId", req.UserId); cmd.Parameters.AddWithValue("@Weight", req.Weight); cmd.Parameters.AddWithValue("@BenchMax", req.BenchMax); cmd.Parameters.AddWithValue("@DeadliftMax", req.DeadliftMax); cmd.Parameters.AddWithValue("@SquatMax", req.SquatMax); cmd.Parameters.AddWithValue("@ShoulderPressMax", req.ShoulderPressMax); con.Open(); cmd.ExecuteNonQuery(); id = int.Parse(outputParam.Value.ToString()); con.Close(); } return(id); }
public ActionResult <ItemResponse <int> > Insert(StrengthProfileInsertRequest req) { ItemResponse <int> response = null; ActionResult result = null; try { int id = _strengthProfileService.Insert(req); if (id > 0) { response = new ItemResponse <int>(); response.Item = id; result = Created201(response); } } catch (Exception ex) { Logger.LogError(ex.ToString()); result = StatusCode(500, new ErrorResponse(ex.Message.ToString())); } return(result); }