public List <GripModels> GetgripsforStage(IConnectToDB _Connect, List <GripModels> Grips, StageModels Stage, int identity_id) { GripsHelper griphelper = new GripsHelper(); DataTable StageGrips = griphelper.FindbyColumnID(_Connect, "Stages_ID", Stage.Stage.stages_id.ToString()); foreach (DataRow GripRows in StageGrips.Rows) { GripModels grip = new GripModels(); grip.gripinfo = new GripModel(); grip.gripinfo.grips_id = GripRows.Field <long?>("grips_id"); grip.gripinfo.grip_name = GripRows.Field <string>("grip_name"); grip.gripinfo.grip_type = GripRows.Field <string>("grip_type"); grip.gripinfo.stages_id = GripRows.Field <long?>("stages_id"); grip.gripinfo.stage_name = GripRows.Field <string>("stage_name"); grip.gripinfo.stage_type = GripRows.Field <string>("stage_type"); grip.gripinfo.identities_id = GripRows.Field <long?>("identities_id"); grip.gripinfo.enabled = GripRows.Field <string>("enabled"); grip.gripinfo.dt_created = GripRows.Field <DateTime>("dt_created"); grip.gripinfo.dt_available = GripRows.Field <DateTime?>("dt_available"); grip.ObjectSets = GetSetsbyGripNID(_Connect, new List <ObjectSetModels>(), grip, identity_id); Grips.Add(grip); } return(Grips); }
public object FindbyColumnID(IConnectToDB _Connect, string objectlayer, string _column, string _id) { DataTable dt = new DataTable(); DictionaryHelper dictionary; switch (objectlayer.ToLower()) { case "object": case "objects": ObjectsHelper objects = new ObjectsHelper(); dt = objects.FindbyColumnID(_Connect, _column, _id); break; case "identity": case "identities": case "id": IdentityHelper identity = new IdentityHelper(); dt = identity.FindbyColumnID(_Connect, _column, _id); break; case "core": case "cores": CoreHelper core = new CoreHelper(); dt = core.FindbyColumnID(_Connect, _column, _id); break; case "application": case "applications": AppHelper application = new AppHelper(); dt = application.FindbyColumnID(_Connect, _column, _id); break; case "stage": case "stages": StagesHelper stages = new StagesHelper(); dt = stages.FindbyColumnID(_Connect, _column, _id); break; case "grip": case "grips": GripsHelper grips = new GripsHelper(); dt = grips.FindbyColumnID(_Connect, _column, _id); break; case "objectset": case "objectsets": ObjectSetsHelper objectsets = new ObjectSetsHelper(); dt = objectsets.FindbyColumnID(_Connect, _column, _id); break; case "objectpropset": case "objectpropsets": ObjectPropSetsHelper objectpropsets = new ObjectPropSetsHelper(); dt = objectpropsets.FindbyColumnID(_Connect, _column, _id); break; case "tables": case "table": dictionary = new DictionaryHelper(); dt = dictionary.FindbyColumnID(_Connect, "tables", _column, _id); break; case "views": case "view": dictionary = new DictionaryHelper(); dt = dictionary.FindbyColumnID(_Connect, "views", _column, _id); break; case "primary": case "primary keys": case "primary key": case "pk": case "pkey": case "pkeys": dictionary = new DictionaryHelper(); dt = dictionary.FindbyColumnID(_Connect, "pkeys", _column, _id); break; case "foreign": case "foreign keys": case "foreign key": case "fk": case "fkey": case "fkeys": dictionary = new DictionaryHelper(); dt = dictionary.FindbyColumnID(_Connect, "fkeys", _column, _id); break; case "unqiue": case "unqiue keys": case "unqiue key": case "uk": case "ukey": case "ukeys": dictionary = new DictionaryHelper(); dt = dictionary.FindbyColumnID(_Connect, "ukeys", _column, _id); 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); }