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