public ActionResult TableData(string tableName)
{
_connectionString = TenantOperations.GetTenantConnectionString(User.Identity.Name);
ViewBag.TableName = tableName;
ViewBag.TableData = MainDataModel.TableData(tableName, _connectionString);
return(View());
}
public ActionResult TableDescription(string tableName)
{
_connectionString = TenantOperations.GetTenantConnectionString(User.Identity.Name);
ViewBag.TableName = tableName;
List <ColumnInformation> columnsCustomSchema;
var sharedColumns = MainDataModel.TableDescription(tableName, _connectionString, out columnsCustomSchema);
ViewBag.CustomColumns = columnsCustomSchema;
List <string> fieldTypesString = new List <string>()
{
"Sütun tipi", "char",
"bit",
"datetime",
"decimal",
"float",
"int",
"nchar",
"nvarchar",
"ntext",
"timestamp"
};
var fieldTypes = fieldTypesString.Select(fieldType => new SelectListItem()
{
Text = fieldType, Value = fieldType
}).ToList();
ViewBag.FieldTypes = fieldTypes;
return(View(sharedColumns));
}
public ActionResult Tables()
{
_connectionString = TenantOperations.GetTenantConnectionString(User.Identity.Name);
var tables = MainDataModel.TablesList(_connectionString);
return(View(tables));
}
public ActionResult DatabaseSchemaCustomization(string receivedTable, string senderTable, string sentColumn)
{
sentColumn = sentColumn.Trim();
_connectionString = TenantOperations.GetTenantConnectionString(User.Identity.Name);
Session["ErrorMessage"] = MainDataModel.DatabaseSchemaCustomizationPostRequest(receivedTable, senderTable,
sentColumn, _connectionString);
return(RedirectToAction("DatabaseSchemaCustomization", "DatabaseOperations"));
}
public ActionResult DatabaseSchemaCustomization()
{
//Session["ErrorMessage"] = null;
_connectionString = TenantOperations.GetTenantConnectionString(User.Identity.Name);
var entities = MainDataModel.DatabaseSchemaCustomizationGetRequest(_connectionString);
return(View(entities));
}
/// <summary>
/// Initializes a new instance of the <see cref="ArmClient"/> class.
/// </summary>
/// <param name="defaultSubscriptionId"> The id of the default Azure subscription. </param>
/// <param name="baseUri"> The base URI of the service. </param>
/// <param name="credential"> A credential used to authenticate to an Azure Service. </param>
/// <param name="options"> The client parameters to use in these operations. </param>
public ArmClient(
string defaultSubscriptionId,
Uri baseUri,
TokenCredential credential,
ArmClientOptions options = default)
{
if (credential is null)
{
throw new ArgumentNullException(nameof(credential));
}
Credential = credential;
BaseUri = baseUri ?? new Uri(DefaultUri);
ClientOptions = options?.Clone() ?? new ArmClientOptions();
Pipeline = ManagementPipelineBuilder.Build(Credential, options.Scope, options ?? ClientOptions);
_tenant = new TenantOperations(ClientOptions, Credential, BaseUri, Pipeline);
DefaultSubscription = string.IsNullOrWhiteSpace(defaultSubscriptionId)
? GetDefaultSubscription()
: GetSubscriptions().GetIfExists(defaultSubscriptionId);
ClientOptions.ApiVersions.SetProviderClient(this);
}
/// <summary>
/// Initializes a new instance of the <see cref="ManagementGroupContainer"/> class.
/// </summary>
/// <param name="tenant"> The parent tenant. </param>
internal ManagementGroupContainer(TenantOperations tenant)
: base(tenant)
{
_clientDiagnostics = new ClientDiagnostics(ClientOptions);
_restClient = new ManagementGroupsRestOperations(_clientDiagnostics, Pipeline, BaseUri);
}
public ActionResult RemoveColumn(string columnName, string tableName)
{
_connectionString = TenantOperations.GetTenantConnectionString(User.Identity.Name);
MainDataModel.RemoveColumn(columnName, tableName, _connectionString);
return(RedirectToAction("TableDescription", new { tableName }));
}
public ActionResult AddNewField(NewField newField)
{
_connectionString = TenantOperations.GetTenantConnectionString(User.Identity.Name);
MainDataModel.AddNewField(newField.tablename, newField.fieldname, newField.fieldtypes, newField.fieldsize, newField.defaultvalue, newField.allownull, _connectionString);
return(RedirectToAction("TableDescription", new { @tableName = newField.tablename }));
}
