Esempio n. 1
0
        public IList <object> CreateInsert(IList <object> list, IDictionary <string, string> dynamicParameters)
        {
            IList <SampleSQLData> convertedList = list.Cast <SampleSQLData>().ToList();
            IList <object>        insertList    = new List <object>();

            foreach (SampleSQLData sample in convertedList)
            {
                foreach (var fk in sample.FK_References)
                {
                    SampleSQLData sampleDataFiltered = convertedList.Where(l => !_tablesLoaded.ContainsKey(fk.Table) && l.Table == fk.Table).SingleOrDefault();

                    if (sampleDataFiltered != null)
                    {
                        TSQLProcessor.Execute(new CreateInsertSQL(), sampleDataFiltered, insertList, dynamicParameters);

                        _tablesLoaded.Add(fk.Table, true);
                    }
                }

                if (!_tablesLoaded.ContainsKey(sample.Table))
                {
                    TSQLProcessor.Execute(new CreateInsertSQL(), sample, insertList, dynamicParameters);

                    _tablesLoaded.Add(sample.Table, true);
                }
            }

            return(insertList);
        }
Esempio n. 2
0
        private void CreateInsertCommand(SampleSQLData sample, IList <object> insertList, IList <SampleSQLData> convertedList)
        {
            foreach (var fk in sample.FK_References)
            {
                SampleSQLData sampleDataFiltered = convertedList.SingleOrDefault(l => !_tablesLoaded.ContainsKey(fk.Table) && l.Table == fk.Table);

                if (sampleDataFiltered != null)
                {
                    CreateInsertCommand(sampleDataFiltered, insertList, convertedList);
                }
            }

            if (!_tablesLoaded.ContainsKey(sample.Table))
            {
                TSQLProcessor.Execute(new CreateInsertSQL(), sample, insertList);
                _tablesLoaded.Add(sample.Table, true);
            }
        }
Esempio n. 3
0
        public IList <object> CreateDelete(IList <object> list, IDictionary <string, string> dynamicParameters)
        {
            IList <SampleSQLData> convertedList = list.Cast <SampleSQLData>().ToList();
            IList <object>        deleteList    = new List <object>();

            IList <SampleSQLData> childData = SetDeletionPriority(convertedList.Where(l => l.FK_References.Count > 0).ToList());

            IList <SampleSQLData> parentData = convertedList.Where(l => l.FK_References.Count == 0).ToList();

            foreach (var child in childData)
            {
                TSQLProcessor.Execute(new CreateDeleteSQL(), child, deleteList, dynamicParameters);
            }

            foreach (var parent in parentData)
            {
                TSQLProcessor.Execute(new CreateDeleteSQL(), parent, deleteList, dynamicParameters);
            }

            return(deleteList);
        }