private HomeModel GetHomeModel(FormCollection formCollection = null)
{
var model = new Models.HomeModel();
model.StretchTableName = Constants.StretchTableName;
string remoteDatabaseName = StretchDbService.GetDatabaseName(Constants.StretchDBAzureConnectionString);
string remoteTableName = StretchDbService.GetRemoteTableName(Constants.StretchTableName, Constants.StretchDbOnPremiseConnectionString, remoteDatabaseName);
model.StretchEnabled = !string.IsNullOrWhiteSpace(remoteTableName);
model.IsDatabaseOnline = SqlAlwaysOnService.IsServerConnected(Constants.SQLAlwaysOnConnectionString);
if (SqlAlwaysOnService.IsPrimaryDatabase(Constants.SqlAlwaysOnPrimaryConnectionString))
{
model.AlwaysOnPrimaryDatabaseServer = SqlAlwaysOnService.GetServerName(Constants.SqlAlwaysOnPrimaryConnectionString);
model.AlwaysOnSecondaryDatabaseServer = SqlAlwaysOnService.GetServerName(Constants.SqlAlwaysOnSecondaryConnectionString);;
}
else
{
model.AlwaysOnPrimaryDatabaseServer = SqlAlwaysOnService.GetServerName(Constants.SqlAlwaysOnSecondaryConnectionString);
model.AlwaysOnSecondaryDatabaseServer = SqlAlwaysOnService.GetServerName(Constants.SqlAlwaysOnPrimaryConnectionString);;
}
model.TotalSpaceUsed = StretchDbService.GetUsedSpace(Constants.StretchTableName, Constants.StretchDbOnPremiseConnectionString, StorageMode.ALL);
model.RemoteSpaceUsed = StretchDbService.GetUsedSpace(Constants.StretchTableName, Constants.StretchDbOnPremiseConnectionString, StorageMode.REMOTE_ONLY);
model.LocalSpaceUsed = StretchDbService.GetUsedSpace(Constants.StretchTableName, Constants.StretchDbOnPremiseConnectionString, StorageMode.LOCAL_ONLY);
return(model);
}
public JsonResult GetTableData(string location)
{
int totalRecords;
string tableName = Constants.StretchTableName;
string connectionString = !string.IsNullOrEmpty(location) && location.Trim() == "Azure" ? Constants.StretchDBAzureConnectionString : Constants.StretchDbOnPremiseConnectionString;
if (!string.IsNullOrEmpty(location) && location.Trim() == "Azure")
{
string remoteDatabaseName = StretchDbService.GetDatabaseName(Constants.StretchDBAzureConnectionString);
tableName = StretchDbService.GetRemoteTableName(tableName, Constants.StretchDbOnPremiseConnectionString, remoteDatabaseName);
}
var dataset = StretchDbService.GetTableData(tableName, connectionString);
string rowData = "[]";
if (dataset != null && dataset.Tables.Count > 0)
{
rowData = dataset.Tables[0].ToJson();
}
return(Json(rowData, "application/json", JsonRequestBehavior.AllowGet));
}
