public List <TableForeignKeyDesignerInfo> GetForeignKeys() { List <TableForeignKeyDesignerInfo> keyDesingerInfos = new List <TableForeignKeyDesignerInfo>(); foreach (DataGridViewRow row in this.dgvForeignKeys.Rows) { TableForeignKeyDesignerInfo key = new TableForeignKeyDesignerInfo(); string keyName = row.Cells[this.colKeyName.Name].Value?.ToString(); if (!string.IsNullOrEmpty(keyName)) { TableForeignKeyDesignerInfo tag = row.Tag as TableForeignKeyDesignerInfo; key.OldName = tag?.OldName; key.Name = keyName; key.Columns = tag?.Columns; key.ReferencedTableName = DataGridViewHelper.GetCellStringValue(row, this.colReferenceTable.Name); key.UpdateCascade = DataGridViewHelper.GetCellBoolValue(row, this.colUpdateCascade.Name); key.DeleteCascade = DataGridViewHelper.GetCellBoolValue(row, this.colDeleteCascade.Name); key.Comment = DataGridViewHelper.GetCellStringValue(row, this.colComment.Name); row.Tag = key; keyDesingerInfos.Add(key); } } return(keyDesingerInfos); }
public List <TableColumnDesingerInfo> GetColumns() { List <TableColumnDesingerInfo> columnDesingerInfos = new List <TableColumnDesingerInfo>(); int order = 1; foreach (DataGridViewRow row in this.dgvColumns.Rows) { TableColumnDesingerInfo col = new TableColumnDesingerInfo() { Order = order }; string colName = row.Cells[this.colColumnName.Name].Value?.ToString(); if (!string.IsNullOrEmpty(colName)) { TableColumnDesingerInfo tag = row.Tag as TableColumnDesingerInfo; string dataType = DataGridViewHelper.GetCellStringValue(row, this.colDataType.Name); col.OldName = tag?.OldName; col.Name = colName; col.DataType = dataType; col.Length = DataGridViewHelper.GetCellStringValue(row, this.colLength.Name); col.IsNullable = DataGridViewHelper.GetCellBoolValue(row, this.colNullable.Name); col.IsPrimary = DataGridViewHelper.GetCellBoolValue(row, this.colPrimary.Name); col.IsIdentity = DataGridViewHelper.GetCellBoolValue(row, this.colIdentity.Name); col.DefaultValue = DataGridViewHelper.GetCellStringValue(row, this.colDefaultValue.Name); col.Comment = DataGridViewHelper.GetCellStringValue(row, this.colComment.Name); col.ExtraPropertyInfo = tag?.ExtraPropertyInfo; UserDefinedType userDefinedType = this.GetUserDefinedType(dataType); if (userDefinedType != null) { col.IsUserDefined = true; col.TypeOwner = userDefinedType.Owner; } row.Tag = col; columnDesingerInfos.Add(col); order++; } } return(columnDesingerInfos); }
private List <BackupSetting> GetSettings() { List <BackupSetting> settings = new List <BackupSetting>(); foreach (DataGridViewRow row in this.dgvSettings.Rows) { BackupSetting setting = new BackupSetting(); setting.DatabaseType = DataGridViewHelper.GetCellStringValue(row, this.colDatabaseType.Name); setting.ClientToolFilePath = DataGridViewHelper.GetCellStringValue(row, this.colClientToolFilePath.Name); setting.SaveFolder = DataGridViewHelper.GetCellStringValue(row, this.colSaveFolder.Name); setting.ZipFile = DataGridViewHelper.GetCellBoolValue(row, this.colZipBackupFile.Name); settings.Add(setting); } return(settings); }