public List <ObjectPropSetModels> GetProps(IConnectToDB _Connect, ObjectSetModels Set, Boolean _GetOptionProperties) { List <ObjectPropSetModels> PropSetModels = new List <ObjectPropSetModels>(); ObjectPropSetModels PropSet = new ObjectPropSetModels(); //Set = new ObjectSetModels(); DataTable _DT = FindbyColumnID(_Connect, "object_sets_id", Set.SetView.object_sets_id.ToString()); foreach (DataRow PropSetRow in _DT.Rows) { PropSet = SinglePropSetView(PropSet.PropSetView, PropSetRow); if (_GetOptionProperties) { //ObjectSetsHelper OSH = new ObjectSetsHelper(); //GripModel1.ObjectSets = OSH.GetSets(GripModel1, _GetPropertySets, _GetOptionProperties); } PropSetModels.Add(PropSet); } return(PropSetModels); }
public ObjectSetModels SingleSetView(ViewObjectSetModel SetView, DataRow _DR) { DataTable thisObjectSetDT = new DataRow[] { _DR }.CopyToDataTable(); string thisAppRow = new JObject(thisObjectSetDT.Columns.Cast <DataColumn>() .Select(c => new JProperty(c.ColumnName, JToken.FromObject(thisObjectSetDT.Rows[0][c]))) ).ToString(Formatting.None); ViewObjectSetModel SetModel = JsonConvert.DeserializeObject <ViewObjectSetModel>(thisAppRow); ObjectSetModels OSM = new ObjectSetModels { SetView = SetModel }; return(OSM); }
public List <ObjectSetModels> GetSets(IConnectToDB _Connect, GripModels Grip, Boolean _GetPropertySets, Boolean _GetOptionProperties) { List <ObjectSetModels> Sets = new List <ObjectSetModels>(); DataTable _DT = FindbyColumnID(_Connect, "grips_id", Grip.GripView.grips_id.ToString()); foreach (DataRow GripSetRow in _DT.Rows) { ObjectSetModels Set = new ObjectSetModels(); Set.SetView = new ViewObjectSetModel(); Set = SingleSetView(Set.SetView, GripSetRow); if (_GetPropertySets) { ObjectPropSetsHelper PSH = new ObjectPropSetsHelper(); Set.ObjectPropSets = PSH.GetProps(_Connect, Set, _GetOptionProperties); } Sets.Add(Set); } return(Sets); }
public List <ObjectSetModels> GetSetsbyGripNID(IConnectToDB _Connect, List <ObjectSetModels> Sets, GripModels Grip, int identity_id) { ObjectSetsHelper SetsHelper = new ObjectSetsHelper(); DataTable ObjectSetsDT = SetsHelper.FindbyColumnID(_Connect, "Grips_ID", Grip.gripinfo.grips_id.ToString()); foreach (DataRow SetRows in ObjectSetsDT.Rows) { ObjectSetModels Set = new ObjectSetModels(); Set.SetView = new ViewObjectSetModel(); Set.SetView.object_sets_id = SetRows.Field <long?>("object_sets_id"); Set.SetView.dt_created = SetRows.Field <DateTime>("dt_created"); Set.SetView.dt_available = SetRows.Field <DateTime?>("dt_available"); Set.SetView.dt_end = SetRows.Field <DateTime?>("dt_end"); Set.ObjectPropSets = GetPropSetsbySetNID(_Connect, new List <ObjectPropSetModels>(), Set, identity_id); Sets.Add(Set); } return(Sets); }
public List <ObjectPropSetModels> GetPropSetsbySetNID(IConnectToDB _Connect, List <ObjectPropSetModels> PropSets, ObjectSetModels ObjSet, int identity_id) { ObjectPropSetsHelper PropSetHelper = new ObjectPropSetsHelper(); DataTable PropSetDT = PropSetHelper.FindbyColumnID(_Connect, "Object_Sets_ID", ObjSet.SetView.object_sets_id.ToString()); foreach (DataRow PropRows in PropSetDT.Rows) { ObjectPropSetModels PropSet = new ObjectPropSetModels(); PropSet.PropSetView = new PropSetView(); PropSet.PropSetView.obj_prop_sets_id = PropRows.Field <long?>("obj_prop_sets_id"); PropSet.PropSetView.object_prop_type = PropRows.Field <string>("object_prop_type"); PropSet.PropSetView.property_name = PropRows.Field <string>("property_name"); PropSet.PropSetView.property_value = PropRows.Field <string>("property_value"); PropSet.PropSetView.value_datatype = PropRows.Field <string>("value_datatype"); PropSet.PropSetView.has_parent = PropRows.Field <string>("has_parent"); PropSet.PropSetView.has_child = PropRows.Field <string>("has_child"); PropSet.PropSetView.parent_obj_prop_sets_id = PropRows.Field <long?>("parent_obj_prop_sets_id"); PropSet.ObjectPropOptSets = GetPropOptSetsbyPropSetNID(_Connect, new List <ObjectPropOptSetModels>(), PropSet, identity_id); PropSets.Add(PropSet); } return(PropSets); }