PERMWebSolution.Models.TolerancesTolerancesModel.GetTolerances C# (CSharp) Méthode

        public List<TolerancesTolerancesModel> GetTolerances(int id)
        {
            string sql = "SELECT [Tolerance_Id],[Name],[Value] FROM [TOLERANCE] WHERE [PROJECT_RISK_Id] = @PROJECT_RISK_Id";

            var param = new Dictionary<string, object>();
            param.Add("@PROJECT_RISK_Id", id);

            var result = DBContext.ExecuteQueryTable(sql, param);

            if (result != null)
            {
                List<TolerancesTolerancesModel> ret = new List<TolerancesTolerancesModel>();
                foreach (DataRow row in result.Rows)
                {
                    ret.Add(new TolerancesTolerancesModel()
                    {
                        ToleranceID = Convert.ToInt32(row["Tolerance_Id"]),
                        ToleranceName = (row["Name"]).ToString(),
                        ToleranceValue = (row["Value"]).ToString(),
                    });
                }

                return ret;
            }
            else
            {
                return null;
            }
        }

        public IHttpActionResult GetTolerances(int id)
        {
            IHttpActionResult ret = null;
            List<TolerancesTolerancesModel> list = new List<TolerancesTolerancesModel>();
            TolerancesTolerancesModel table = new TolerancesTolerancesModel();
            list = table.GetTolerances(id);

            if(list.Count > 0)
            {
                ret = Ok(list);
            }
            else
            {
                ret = Ok(list);
            }
            return ret;
        }