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);
}
public ViewObjectPropFile getFileBytesFromPropID(IConnectToDB _Connect, string objectpropsetid)
{
byte[] bytes = new byte[0];
ViewObjectPropFile _File = new ViewObjectPropFile();
int n;
bool isNumeric = int.TryParse(objectpropsetid, out n);
if (isNumeric)
{
ER_Query er_query = new ER_Query();
ObjectPropSetModels opsm = new ObjectPropSetModels();
ObjectPropSetsHelper opsHelper = new ObjectPropSetsHelper();
List <ViewObjectPropFile> _FilesList = opsHelper.FindFiles(_Connect, new List <ViewObjectPropFile>(), objectpropsetid, "object_prop_set");
foreach (ViewObjectPropFile e in _FilesList)
{
if (e != null)
{
_File.file_name = e.file_name;
_File.value = e.value;
_File.content_type = e.content_type;
//bytes = (byte[])e.file_data;
}
}
}
return(_File);
}
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 ObjectPropSetModels SinglePropSetView(PropSetView SinglePropSetView, DataRow _DR)
{
SinglePropSetView = new PropSetView
{
containers_id = _DR.Field <long?>("containers_id"),
dt_available = _DR.Field <DateTime?>("dt_available"),
dt_created = _DR.Field <DateTime>("dt_created"),
dt_end = _DR.Field <DateTime?>("dt_end"),
stage_name = _DR.Field <string>("stage_name"),
stage_type = _DR.Field <string>("stage_type"),
grip_name = _DR.Field <string>("grip_name"),
grip_type = _DR.Field <string>("grip_type"),
identities_id = _DR.Field <long?>("identities_id"),
object_type = _DR.Field <string>("object_type"),
enabled = _DR.Field <string>("enabled"),
object_layer = _DR.Field <string>("object_layer"),
object_sets_id = _DR.Field <long?>("object_sets_id"),
has_child = _DR.Field <string>("has_child"),
has_parent = _DR.Field <string>("has_parent"),
obj_prop_sets_id = _DR.Field <long?>("obj_prop_sets_id"),
object_prop_type = _DR.Field <string>("object_prop_type"),
property_name = _DR.Field <string>("property_name"),
parent_obj_prop_sets_id = _DR.Field <long?>("parent_obj_prop_sets_id"),
property_value = _DR.Field <string>("property_value"),
value_datatype = _DR.Field <string>("value_datatype"),
grips_id = _DR.Field <long?>("grips_id"),
};
ObjectPropSetModels Set = new ObjectPropSetModels {
PropSetView = SinglePropSetView
};
return(Set);
}
private ObjectPropSetModels PopulatePropertyFiles(ObjectPropSetModels PropSet, DataTable TempDataTable)
{
PropSet.PropSetView = new PropSetView();
PropSet.PropSetView.PropFiles = new List <ViewObjectPropSetFile>();
foreach (DataRow PropFileRow in TempDataTable.Rows)
{
PropSet.PropSetView.PropFiles.Add(PropFile(new ViewObjectPropSetFile(), PropFileRow));
}
return(PropSet);
}
public string getFilesFromBytes(IConnectToDB _Connect, string object_id, string object_type)
{
ER_Query er_query = new ER_Query();
ObjectPropSetModels opsm = new ObjectPropSetModels();
ObjectPropSetsHelper opsHelper = new ObjectPropSetsHelper();
List <ViewObjectPropFile> _FilesList = opsHelper.FindFiles(_Connect, new List <ViewObjectPropFile>(), object_id, object_type);
char[] chars = new char[0];
foreach (ViewObjectPropFile e in _FilesList)
{
if (e != null)
{
byte[] bytes = e.value;
chars = new char[bytes.Length / sizeof(char)];
System.Buffer.BlockCopy(bytes, 0, chars, 0, bytes.Length);
}
}
return(new string(chars));
}
public string getStringFromBytesViaObjectProSetid(IConnectToDB _Connect, Guid?objectpropsetid)
{
ER_Query er_query = new ER_Query();
ObjectPropSetModels opsm = new ObjectPropSetModels();
ObjectPropSetsHelper opsHelper = new ObjectPropSetsHelper();
opsm = opsHelper.FindExtras(_Connect, opsm, objectpropsetid);
char[] chars = new char[0];
foreach (ViewObjectPropSetFile e in opsm.PropSetView.PropFiles)
{
if (e != null)
{
byte[] bytes = e.value;
chars = new char[bytes.Length / sizeof(char)];
System.Buffer.BlockCopy(bytes, 0, chars, 0, bytes.Length);
}
}
return(new string(chars));
}
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);
}
public List <ObjectPropOptSetModels> GetPropOptSetsbyPropSetNID(IConnectToDB _Connect, List <ObjectPropOptSetModels> PropOptSets, ObjectPropSetModels PropSet, int identity_id)
{
ObjectPropOptSets PropOptHelper = new ObjectPropOptSets();
DataTable PropOpt = PropOptHelper.FindbyColumnID(_Connect, "obj_prop_sets_id", PropSet.PropSetView.obj_prop_sets_id.ToString());
foreach (DataRow PropOptRows in PropOpt.Rows)
{
ObjectPropOptSetModels PropOptSet = new ObjectPropOptSetModels();
PropOptSet.obj_prop_opt_sets_id = PropOptRows.Field <long?>("obj_prop_opt_sets_id");
PropOptSet.option_value = PropOptRows.Field <string>("option_value");
PropOptSet.enabled = PropOptRows.Field <string>("enabled");
PropOptSets.Add(PropOptSet);
}
return(PropOptSets);
}
