public List <ViewIdentityModel> GetIdentityViaID(IConnectToDB _Connect, string _id, string connownername) { //ViewIdentityModel appObjects = new ViewIdentityModel(); IdentityHelper identity = new IdentityHelper(); DataTable identitydt; if (_id.ToLower() == "all") { identitydt = identity.FindAll(_Connect); } else { identitydt = identity.FindbyColumnID(_Connect, "identities_id", _id); } List <ViewIdentityModel> IdentitiesList = new List <ViewIdentityModel>(); ViewIdentityModel[] Identities = new ViewIdentityModel[identitydt.Rows.Count]; int i = 0; foreach (DataRow datarowdc in identitydt.Rows) { Identities[i] = new ViewIdentityModel { identities_id = datarowdc.Field <long?>("identities_id"), enabled = datarowdc.Field <string>("enabled"), dt_created = datarowdc.Field <DateTime>("dt_created"), dt_available = datarowdc.Field <DateTime?>("dt_available"), dt_end = datarowdc.Field <DateTime?>("dt_end"), object_type = datarowdc.Field <string>("object_type"), object_layer = datarowdc.Field <string>("object_layer"), chardata = new List <ViewIdentityCharDataModel>(), //Still need to build out Helpers datedata = new List <ViewIdentityDateDataModel>(), //Still need to build out Helpers numbdata = new List <ViewIdentityNumbDataModel>() //Still need to build out Helpers }; //Grips[i].stage_name = datarowdc["stage_name"].ToString(); IdentitiesList.Add(Identities[i]); i++; } return(IdentitiesList); }
//TODO: Delete All References to This public object ListALL(IConnectToDB _Connect, string objectlayer) { DataTable dt = new DataTable(); DictionaryHelper dictionary; switch (objectlayer.ToLower()) { case "object": case "objects": ObjectsHelper objects = new ObjectsHelper(); dt = objects.FindAll(_Connect); break; case "identity": case "identities": case "id": IdentityHelper identity = new IdentityHelper(); dt = identity.FindAll(_Connect); break; case "core": case "cores": CoreHelper core = new CoreHelper(); dt = core.FindAll(_Connect); break; case "application": case "applications": AppHelper application = new AppHelper(); dt = application.FindAll(_Connect); break; case "stage": case "stages": StagesHelper stages = new StagesHelper(); dt = stages.FindAll(_Connect); break; case "grip": case "grips": GripsHelper grips = new GripsHelper(); dt = grips.FindAll(_Connect); break; case "objectset": case "objectsets": ObjectSetsHelper objectsets = new ObjectSetsHelper(); dt = objectsets.FindAll(_Connect); break; case "objectpropset": case "objectpropsets": ObjectPropSetsHelper objectpropsets = new ObjectPropSetsHelper(); dt = objectpropsets.FindAll(_Connect); break; case "tables": case "table": dictionary = new DictionaryHelper(); dt = dictionary.FindAll(_Connect, "tables"); break; case "views": case "view": dictionary = new DictionaryHelper(); dt = dictionary.FindAll(_Connect, "views"); break; case "primary": case "primary keys": case "primary key": case "pk": case "pkey": case "pkeys": dictionary = new DictionaryHelper(); dt = dictionary.FindAll(_Connect, "pkeys"); break; case "foreign": case "foreign keys": case "foreign key": case "fk": case "fkey": case "fkeys": dictionary = new DictionaryHelper(); dt = dictionary.FindAll(_Connect, "fkeys"); break; case "unqiue": case "unqiue keys": case "unqiue key": case "uk": case "ukey": case "ukeys": dictionary = new DictionaryHelper(); dt = dictionary.FindAll(_Connect, "ukeys"); break; } ConvertData jsonstring = new ConvertData(); var json = jsonstring.ConvertDataTabletoString(dt); var myojb = new object(); object myObjs = new object(); switch (objectlayer.ToLower()) { case "object": case "objects": myojb = new ViewObjectModel(); List <ViewObjectModel> myObjsObjects = new List <ViewObjectModel>(); myObjsObjects = JsonConvert.DeserializeObject <List <ViewObjectModel> >(json); myObjs = myObjsObjects; break; case "inditities": case "identity": 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); }