public ViewUniqueKeysDictionary GetUKey(ViewUniqueKeysDictionary UKey, DataRow _DR)
 {
     return(UKey = new ViewUniqueKeysDictionary
     {
         dt_available = _DR.Field <DateTime?>("dt_available"),
         dt_created = _DR.Field <DateTime>("dt_Created"),
         dt_end = _DR.Field <DateTime?>("dt_end"),
         enabled = _DR.Field <string>("enabled"),
         er_unique_keys_id = _DR.Field <long?>("er_unique_keys_id"),
         key_name = _DR.Field <string>("key_name"),
         table_name = _DR.Field <string>("table_name")
     });
 }
Exemple #2
0
        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);
        }