Esempio n. 1
0
        private void Save()
        {
            // We have to remove all the existing data and insert the new data to save properly

            #region Fields
            _formSchema.schema_name                     = txtSchemaName.Text;
            _formSchema.data_type                       = (DataMappingConnectionTypes)cmbDataType.SelectedItem;
            _formSchema.sqlstatement                    = txtSQL.Text;
            _formSchema.server_name                     = txtServerName.Text;
            _formSchema.database_name                   = txtDatabaseName.Text;
            _formSchema.user_name                       = txtUserName.Text;
            _formSchema.allow_password_save             = chkAllowSavePassword.Checked;
            _formSchema.claim_id_column                 = txtClaimIDColumn.Text;
            _formSchema.company_namecolumn              = txtCompanyNameColumn.Text;
            _formSchema.date_column                     = txtDateColumn.Text;
            _formSchema.sqlstatementsecondaries         = txtSQLSecondary.Text;
            _formSchema.sqlstatementpredeterms          = txtSQLPredeterm.Text;
            _formSchema.claim_db_column                 = txtClaimDBColumn.Text;
            _formSchema.sqlstatementsecondarypredeterms = txtSQLSecondaryPredeterm.Text;

            if (chkAllowSavePassword.Checked)
            {
                _formSchema.pw = txtPassword.Text;
            }
            else
            {
                _formSchema.pw = "";
            }

            #endregion
            _formSchema.Save();

            _formSchema.ExecuteNonQuery("DELETE FROM data_mapping_schema_data WHERE schema_id = " +
                                        _formSchema.id);

            data_mapping_schema_data saveSchemaData;
            foreach (DataGridViewRow aRow in dgvMappings.Rows)
            {
                if (CommonFunctions.DBNullToString(aRow.Cells["colLinkedField"].Value) != "")
                {
                    // Save this
                    saveSchemaData = new data_mapping_schema_data();
                    saveSchemaData.mapping_field_id = ((data_mapping_field)aRow.Cells["colFieldData"].Value).id;
                    saveSchemaData.mapped_to_text   = aRow.Cells["colLinkedField"].Value.ToString();
                    saveSchemaData.schema_id        = _formSchema.id;

                    saveSchemaData.Save();
                }
            }
            _dataChanged = false;
        }