public PartitionDataProvider(TableDetailsModel dataModel, OracleObjectIdentifier objectIdentifier, Version oracleVersion) { var hasInMemorySupport = InMemoryHelper.HasInMemorySupport(oracleVersion); PartitionDetailDataProvider = new PartitionDetailDataProviderInternal(dataModel, objectIdentifier, hasInMemorySupport); SubPartitionDetailDataProvider = new SubPartitionDetailDataProviderInternal(dataModel, objectIdentifier, hasInMemorySupport); }
public void Output(CreateTableOutput output) { var tasks = new List <TableTaskModel>(); foreach (var item in output.Table.GetTasks()) { tasks.Add(new TableTaskModel(item.Id.ToGuid(), item.Text.ToString(), (int)item.State)); } var table = new TableDetailsModel( output.Table.Name.ToString(), output.Table.Id.ToGuid(), (int)output.Table.State, tasks); var res = new CreateTableResponse(table); ViewModel = new OkObjectResult(res); }
public void Output(GetTableDetailsOutput output) { var tasks = new List <TableTaskModel>(); foreach (var task in output.Table.GetTasks()) { tasks.Add(new TableTaskModel( task.Id.ToGuid(), task.Text.ToString(), (int)task.State)); } var tableDetails = new TableDetailsModel( output.Table.Name.ToString(), output.Table.Id.ToGuid(), (int)output.Table.State, tasks); var res = new GetTableDetailsResponse(tableDetails); ViewModel = new OkObjectResult(res); }
public ActionResult Index() { var model = new TableDetailsModel(); List <TableDetailsModel> TableDetails = new List <TableDetailsModel>(); using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("select * from TableDetails order by [Table]", con)) { cmd.CommandType = CommandType.Text; using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); List <Columndetails> x = new List <Columndetails>(); //List<string> y = new List<string>(); //List<string> z = new List<string>(); TableDetailsModel Table = new TableDetailsModel(); for (int i = 0; i < dt.Rows.Count; i++) { //var x = new List<string>; if (Table.TableName != dt.Rows[i]["table"].ToString()) { if (Table.TableName != null) { TableDetails.Add(Table); } Table = new TableDetailsModel(); x = new List <Columndetails>(); //y = new List<string>(); //z = new List<string>(); Table.TableName = dt.Rows[i]["table"].ToString(); Table.TableDisplayName = dt.Rows[i]["TableDisplayName"].ToString(); Table.TableKeyColumnName = dt.Rows[i]["pk_column_name"].ToString(); } x.Add(new Columndetails { column_name = dt.Rows[i]["column_name"].ToString(), Displaycolumnname = dt.Rows[i]["Displaycolumn_name"].ToString(), DataTypeName = dt.Rows[i]["DataTypeName"].ToString() }); Table.Columndetail = x; //Table.ColumName.Add(newNode); } TableDetails.Add(Table); //------------------------------- } } } } return(View(TableDetails)); }
public override async Task UpdateTableDetailsAsync(OracleObjectIdentifier objectIdentifier, TableDetailsModel dataModel, CancellationToken cancellationToken) { var tableDetailDataProvider = new TableDetailDataProvider(dataModel, objectIdentifier); var spaceAllocationDataProvider = new TableSpaceAllocationDataProvider(dataModel, objectIdentifier, String.Empty); var tableCommentDataProvider = new CommentDataProvider(dataModel, objectIdentifier, null); var tableInMemorySpaceAllocationDataProvider = new TableInMemorySpaceAllocationDataProvider(dataModel, objectIdentifier, Version); var indexDetailDataProvider = new IndexDetailDataProvider(dataModel, objectIdentifier, null); var indexColumnDataProvider = new IndexColumnDataProvider(dataModel, objectIdentifier, null); var partitionDataProvider = new PartitionDataProvider(dataModel, objectIdentifier, Version); var tablespaceDetailDataProvider = new TablespaceDetailDataProvider(dataModel.TablespaceDataModel); var datafileDataProvider = new TablespaceFilesDataProvider(dataModel.TablespaceDataModel); await UpdateModelAsync(true, cancellationToken, tableDetailDataProvider, tableCommentDataProvider, spaceAllocationDataProvider, tableInMemorySpaceAllocationDataProvider, indexDetailDataProvider, indexColumnDataProvider, partitionDataProvider.PartitionDetailDataProvider, partitionDataProvider.SubPartitionDetailDataProvider, tablespaceDetailDataProvider, datafileDataProvider); }
public CreateTableResponse(TableDetailsModel tableModel) { TableModel = tableModel; }
public GetTableDetailsResponse(TableDetailsModel tableDetails) { TableDetails = tableDetails; }
public IActionResult Details(int tableId) { TableDetailsModel model = tableService.GetById(tableId).ToTableDetailsModel(); return(View(model)); }
public abstract Task UpdateTableDetailsAsync(OracleObjectIdentifier schemaObject, TableDetailsModel dataModel, CancellationToken cancellationToken);