public ViewObjectPropSetFile PropFile(ViewObjectPropSetFile PropSet, DataRow _DR)
        {
            DataTable thisAppDT = new DataRow[] { _DR }.CopyToDataTable();
            string    thisAppRow = new JObject(thisAppDT.Columns.Cast <DataColumn>()
                                               .Select(c => new JProperty(c.ColumnName, JToken.FromObject(thisAppDT.Rows[0][c])))
                                               ).ToString(Formatting.None);

            PropSet = JsonConvert.DeserializeObject <ViewObjectPropSetFile>(thisAppRow);

            return(PropSet);
        }
        public ObjectPropSetModels FindExtras(IConnectToDB _Connect, ObjectPropSetModels PropSet, Guid?_id)
        {
            _DynamicOutputProcedures DynamicOutput = new _DynamicOutputProcedures();

            List <DynamicModels.RootReportFilter> Filters = new List <DynamicModels.RootReportFilter>();

            Filters.Add(new DynamicModels.RootReportFilter {
                FilterName = "OBJ_PROP_SETS_UUID_", DBType = SqlDbType.UniqueIdentifier, ParamValue = _id
            });

            DataTable TempDataTable = DynamicOutput.DynoProcSearch(_Connect, "Custom Query", "SP_S_VW__OBJ_PROP_SETS_DAT_FILE_SEARCH",
                                                                   new DataTableDotNetModelMetaData {
                length = -1, order = "1 asc", start = 0, verify = "T"
            },
                                                                   Filters);

            PropSet = PopulatePropertyFiles(PropSet, TempDataTable);

            ViewObjectPropSetFile OPS = new ViewObjectPropSetFile();

            return(PropSet);
        }