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);
}
