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);
