Пример #1
0
        private void btnAddTable_Click(object sender, EventArgs e)
        {
            InsertTableCommand cmd = new InsertTableCommand(this.txtBody);

            cmd.Execute();
        }
Пример #2
0
        /// <summary>
        /// Adds the given data table to the context
        /// </summary>
        private async Task InsertTable(DataTable table)
        {
            // Skip any table that the importer is ignoring
            if (table.ExtendedProperties["Ignore"] is true)
            {
                return;
            }

            OnNextItem("Importing table");

            var type = table.ExtendedProperties["Type"] as Type;

            IRequest <Unit> command;

            //Change the insertion process depending on the table being added
            switch (table.TableName)
            {
            case "Design":
                await Handler.Query(new InsertDesignsCommand { Table = table });

                command = new InsertPlotsCommand
                {
                    Table     = table,
                    Progress  = Progress,
                    Confirmer = Handler
                };
                break;

            case "Experiments":
                command = new InsertExperimentsTableCommand
                {
                    Table    = table,
                    Progress = Progress
                };
                break;

            case "HarvestData":
            case "PlotData":
                command = new InsertPlotDataTableCommand
                {
                    Table    = table,
                    Skip     = 4,
                    Type     = "Crop",
                    Progress = Progress
                };
                break;

            case "MetData":
                command = new InsertMetDataTableCommand
                {
                    Table    = table,
                    Skip     = 2,
                    Type     = "Climate",
                    Progress = Progress
                };
                break;

            case "SoilLayerData":
                command = new InsertSoilLayerTableCommand
                {
                    Table    = table,
                    Skip     = 5,
                    Type     = "SoilLayer",
                    Progress = Progress
                };
                break;

            case "Irrigation":
            case "Fertilization":
            case "Tillage":
                command = new InsertOperationsTableCommand
                {
                    Confirmer = Handler,
                    Table     = table,
                    Type      = type,
                    Progress  = Progress
                };
                break;

            case "SoilData":
                command = new InsertSoilDataTableCommand
                {
                    Table    = table,
                    Skip     = 3,
                    Type     = "Soil",
                    Progress = Progress
                };
                break;

            case "Soils":
                command = new InsertSoilTableCommand
                {
                    Table    = table,
                    Type     = type,
                    Progress = Progress
                };
                break;

            case "SoilLayer":
            case "SoilLayers":
                command = new InsertSoilLayerTraitsCommand
                {
                    Table    = table,
                    Type     = type,
                    Progress = Progress
                };
                break;

            default:
                command = new InsertTableCommand
                {
                    Table    = table,
                    Type     = type,
                    Progress = Progress
                };
                break;
            }

            await Handler.Query(command);
        }