Canvas.Controllers.ApiController.GetMacroProperty C# (CSharp) Method

        public JsonResult GetMacroProperty(int id)
        {

            using (var db = DatabaseContext.Database)
            {
                var properties = db.Fetch<CanvasMacroProperty>("SELECT * FROM cmsMacroProperty where macro = @0 ORDER BY macroPropertySortOrder", id);

                if (CanvasHelper.GetUmbracoVersion() == 6)
                {

                    var macroPropertyTypes = db.Fetch<dynamic>("SELECT * FROM cmsMacroPropertyType");

                    foreach (var p in properties)
                    {

                        var type = macroPropertyTypes.FirstOrDefault(x => x.id == p.macroPropertyType);

                        if (type != null)
                        {
                            p.editorAlias = type.macroPropertyTypeRenderType;
                        }

                    }

                }

                return Json(new { success = true, properties = properties });
            }
        }