Beispiel #1
0
        private void Button_ImportCSV_Click(object sender, RoutedEventArgs e)
        {
            OpenFileDialog openFileDialog = new OpenFileDialog();

            //openFileDialog.Filter = "ImageCSV (*.csv;)";

            if (openFileDialog.ShowDialog() == true)
            {
                CsvImporter csvIMporter = new CsvImporter();
                Dictionary <string, List <string> > import = csvIMporter.ReadCsv(openFileDialog.FileName);
                string tableName = Path.GetFileNameWithoutExtension(openFileDialog.FileName);

                var columns = new List <string>();
                foreach (string column in import.Keys)
                {
                    columns.Add(column);
                }

                databaseController.CreateEmptyTable(tableName, columns);
                ReloadTableNames();
                TableNamesComboBox.SelectedIndex = TableNamesComboBox.Items.IndexOf(tableName);
                databaseController.AddEntries(SelectedTableName, import);
                DisplayTable(uiDataGrid, databaseController.ImportedDatabaseModel.GetTable(SelectedTableName));
            }
        }
Beispiel #2
0
        public void AddEntriesTest()
        {
            string tableName = "table";
            Dictionary <string, List <string> > dict = new Dictionary <string, List <string> >();

            dict.Add("key1", new List <string>());
            dict.Add("key2", new List <string>());
            dict.Add("key3", new List <string>());
            dict.Add("key4", new List <string>());

            TBDatabaseKeeper  keeper = new Mock <TBDatabaseKeeper>().Object;
            Mock <DataKeeper> dkMock = new Mock <DataKeeper>(keeper);

            foreach (var column in dict.Keys)
            {
                dkMock.Setup(mock => mock.AddEntries(tableName, column, dict[column]));
            }

            Mock <DatabaseController> databaseControllerMock = new Mock <DatabaseController>(keeper, dkMock.Object);
            DatabaseController        databaseController     = databaseControllerMock.Object;

            databaseController.AddEntries(tableName, dict);

            foreach (var column in dict.Keys)
            {
                dkMock.Verify(mock => mock.AddEntries(tableName, column, dict[column]), Times.Once());
            }
        }