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 TableData(string tableName)
{
_connectionString = TenantOperations.GetTenantConnectionString(User.Identity.Name);
ViewBag.TableName = tableName;
ViewBag.TableData = MainDataModel.TableData(tableName, _connectionString);
return(View());
}
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));
}
protected void Page_Load(object sender, EventArgs e)
{
form1.InnerHtml += "<br/>" + DateTime.Now.ToString(@"MM\/dd\/yyyy HH:mm:ss");
try
{
using (MainDataModel db = new MainDataModel())
{
if (db.Exercises.Count() >= 0)
{
form1.InnerHtml += "<br/>DB connection OK.";
}
}
}
catch (Exception ex)
{
form1.InnerHtml += String.Format("<br/>Failed to create instance of MainDataModel: {0}", ex.ToString());
}
}
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 }));
}
public static void DoProvisioning(TenantProfile tenantprofile)
{
var connectionString = ConfigurationManager.ConnectionStrings["Administration"].ConnectionString;
MainDataModel.TenantProvisioning(tenantprofile.TenantDatabaseName, tenantprofile.TenantDatabaseUsername, tenantprofile.TenantDatabasePassword, connectionString);
}
public BusinessLogic()
{
MainDataModel = new MainDataModel();
ReadSettings();
}
