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 <GripModels> GetGrips(IConnectToDB _Connect, StageModels Stage, Boolean _GetObjectSets, Boolean _GetPropertySets, Boolean _GetOptionProperties) { List <GripModels> GripModels = new List <GripModels>(); DataTable _DT = FindbyColumnID(_Connect, "stages_id", Stage.StageView.stages_id.ToString()); foreach (DataRow AppStageRow in _DT.Rows) { GripModels GripModel1 = new GripModels(); GripModel1 = SingleGripView(new ViewGripModel(), AppStageRow); if (_GetObjectSets) { ObjectSetsHelper OSH = new ObjectSetsHelper(); GripModel1.ObjectSets = OSH.GetSets(_Connect, GripModel1, _GetPropertySets, _GetOptionProperties); } GripModels.Add(GripModel1); } return(GripModels); }
public List <ViewObjectSetModel> GetObjectSetsViaGrip(IConnectToDB _Connect, string grips_id) { ObjectSetsHelper objectsets = new ObjectSetsHelper(); Fetcher fetch = new Fetcher(); DataTable objectsetsdt; if (grips_id.ToLower() == "all") { objectsetsdt = objectsets.FindAll(_Connect); } else { objectsetsdt = objectsets.FindbyColumnID(_Connect, "grips_id", grips_id); } List <ViewObjectSetModel> ObjectSetsList = new List <ViewObjectSetModel>(); ViewObjectSetModel[] ObjectSets = new ViewObjectSetModel[objectsetsdt.Rows.Count]; for (int i = 0; i < objectsetsdt.Rows.Count; i++) { string thisObjectSet = new JObject(objectsetsdt.Columns.Cast <DataColumn>() .Select(c => new JProperty(c.ColumnName, JToken.FromObject(objectsetsdt.Rows[i][c]))) ).ToString(Formatting.None); ObjectSets[i] = JsonConvert.DeserializeObject <ViewObjectSetModel>(thisObjectSet); ObjectSets[i].ObjectPropSets = objectsets.GetObjectPropSetsViaObjectSet(_Connect, ObjectSets[i].object_sets_id.ToString()); ObjectSetsList.Add(ObjectSets[i]); } return(ObjectSetsList); }
public object FindbyColumnIDs(IConnectToDB _Connect, string objectlayer, string _column, List <string> _ids) { DataTable dt = new DataTable(); DictionaryHelper dictionary; switch (objectlayer.ToLower()) { case "object": case "objects": ObjectsHelper objects = new ObjectsHelper(); dt = objects.FindbyColumnIDs(_Connect, _column, _ids); break; case "identity": case "identities": case "id": IdentityHelper identity = new IdentityHelper(); dt = identity.FindbyColumnIDs(_Connect, _column, _ids); break; case "core": case "cores": CoreHelper core = new CoreHelper(); dt = core.FindbyColumnIDs(_Connect, _column, _ids); break; case "application": case "applications": AppHelper application = new AppHelper(); dt = application.FindbyColumnIDs(_Connect, _column, _ids); break; case "stage": case "stages": StagesHelper stages = new StagesHelper(); dt = stages.FindbyColumnIDs(_Connect, _column, _ids); break; case "grip": case "grips": GripsHelper grips = new GripsHelper(); dt = grips.FindbyColumnIDs(_Connect, _column, _ids); break; case "objectset": case "objectsets": ObjectSetsHelper objectsets = new ObjectSetsHelper(); dt = objectsets.FindbyColumnIDs(_Connect, _column, _ids); break; case "objectpropset": case "objectpropsets": ObjectPropSetsHelper objectpropsets = new ObjectPropSetsHelper(); dt = objectpropsets.FindbyColumnIDs(_Connect, _column, _ids); break; case "tables": case "table": dictionary = new DictionaryHelper(); dt = dictionary.FindbyColumnIDs(_Connect, "tables", _column, _ids); break; case "views": case "view": dictionary = new DictionaryHelper(); dt = dictionary.FindbyColumnIDs(_Connect, "views", _column, _ids); break; case "primary": case "primary keys": case "primary key": case "pk": case "pkey": case "pkeys": dictionary = new DictionaryHelper(); dt = dictionary.FindbyColumnIDs(_Connect, "pkeys", _column, _ids); break; case "foreign": case "foreign keys": case "foreign key": case "fk": case "fkey": case "fkeys": dictionary = new DictionaryHelper(); dt = dictionary.FindbyColumnIDs(_Connect, "fkeys", _column, _ids); break; case "unqiue": case "unqiue keys": case "unqiue key": case "uk": case "ukey": case "ukeys": dictionary = new DictionaryHelper(); dt = dictionary.FindbyColumnIDs(_Connect, "ukeys", _column, _ids); break; } ConvertData jsonstring = new ConvertData(); var json = jsonstring.ConvertDataTabletoString(dt); var myojb = new object(); object myObjs = new object(); switch (objectlayer) { case "object": case "objects": myojb = new ViewObjectModel(); List <ViewObjectModel> myObjsObjects = new List <ViewObjectModel>(); myObjsObjects = JsonConvert.DeserializeObject <List <ViewObjectModel> >(json); myObjs = myObjsObjects; break; case "identity": case "identities": case "id": myojb = new ViewIdentityModel(); List <ViewIdentityModel> myID = new List <ViewIdentityModel>(); myID = JsonConvert.DeserializeObject <List <ViewIdentityModel> >(json); myObjs = myID; break; case "core": case "cores": myojb = new ViewCoreModel(); List <ViewCoreModel> myObjsCore = new List <ViewCoreModel>(); myObjsCore = JsonConvert.DeserializeObject <List <ViewCoreModel> >(json); myObjs = myObjsCore; break; case "application": case "applications": myojb = new ViewApplicationModel(); List <ViewApplicationModel> myObjsApplication = new List <ViewApplicationModel>(); myObjsApplication = JsonConvert.DeserializeObject <List <ViewApplicationModel> >(json); myObjs = myObjsApplication; break; case "stage": case "stages": myojb = new ViewStageModel(); List <ViewStageModel> myObjsStage = new List <ViewStageModel>(); myObjsStage = JsonConvert.DeserializeObject <List <ViewStageModel> >(json); myObjs = myObjsStage; break; case "grip": case "grips": myojb = new ViewGripModel(); List <ViewGripModel> myObjsGrip = new List <ViewGripModel>(); myObjsGrip = JsonConvert.DeserializeObject <List <ViewGripModel> >(json); myObjs = myObjsGrip; break; case "objectset": case "objectsets": myojb = new ViewObjectSetModel(); List <ViewObjectSetModel> myObjsObjectSets = new List <ViewObjectSetModel>(); myObjsObjectSets = JsonConvert.DeserializeObject <List <ViewObjectSetModel> >(json); myObjs = myObjsObjectSets; break; case "objectpropset": case "objectpropsets": myojb = new ViewObjectPropSetsModel(); List <ViewObjectPropSetsModel> myObjsObjectPropSets = new List <ViewObjectPropSetsModel>(); myObjsObjectPropSets = JsonConvert.DeserializeObject <List <ViewObjectPropSetsModel> >(json); myObjs = myObjsObjectPropSets; break; case "tables": case "table": myojb = new ViewTablesDictionary(); List <ViewTablesDictionary> myTableDictionary = new List <ViewTablesDictionary>(); myTableDictionary = JsonConvert.DeserializeObject <List <ViewTablesDictionary> >(json); myObjs = myTableDictionary; break; case "views": case "view": myojb = new ViewViewsDictionary(); List <ViewViewsDictionary> myViewDictionary = new List <ViewViewsDictionary>(); myViewDictionary = JsonConvert.DeserializeObject <List <ViewViewsDictionary> >(json); myObjs = myViewDictionary; break; case "primary": case "primary keys": case "primary key": case "pk": case "pkey": case "pkeys": myojb = new ViewPrimaryKeysDictionary(); List <ViewPrimaryKeysDictionary> myPKDictionary = new List <ViewPrimaryKeysDictionary>(); myPKDictionary = JsonConvert.DeserializeObject <List <ViewPrimaryKeysDictionary> >(json); myObjs = myPKDictionary; break; case "foreign": case "foreign keys": case "foreign key": case "fk": case "fkey": case "fkeys": myojb = new ViewForeignKeysDictionary(); List <ViewForeignKeysDictionary> myFKDictionary = new List <ViewForeignKeysDictionary>(); myFKDictionary = JsonConvert.DeserializeObject <List <ViewForeignKeysDictionary> >(json); myObjs = myFKDictionary; break; case "unqiue": case "unqiue keys": case "unqiue key": case "uk": case "ukey": case "ukeys": myojb = new ViewUniqueKeysDictionary(); List <ViewUniqueKeysDictionary> myUKDictionary = new List <ViewUniqueKeysDictionary>(); myUKDictionary = JsonConvert.DeserializeObject <List <ViewUniqueKeysDictionary> >(json); myObjs = myUKDictionary; break; default: List <object> defaultlist = new List <object>(); defaultlist = null; myObjs = defaultlist; break; } return(myObjs); }