public void OnGet()
{
using (ComProxy proxy = new ComProxy())
{
// query database(s)
DatabaseResponse dbResponse = proxy.GetDatabases();
foreach (KeyAndValueItem item in dbResponse.Items)
{
_logger.LogInformation($"DbId: {item.Id}, Name: {item.Name}");
// query each db details
SPDatabaseDetailsResponse dbDetails = proxy.GetDatabaseDetails(new SPDatabaseDetailsRequest()
{
DatabaseId = item.Id
});
_logger.LogInformation($"Currency: {dbDetails.Currency}");
_logger.LogInformation($"Population: {dbDetails.Population.ToString()}");
_logger.LogInformation($"Sample: {dbDetails.Sample.ToString()}");
_logger.LogInformation("Languages:");
foreach (KeyAndValueItem langItem in dbDetails.Languages)
{
_logger.LogInformation($"{langItem.Id}, name: {langItem.Name}");
}
_logger.LogInformation("-----------");
}
}
}
public ActionResult Index()
{
ComProxy proxy = (ComProxy)Session[Consts.SESSION_COMPROXY];
// query database(s)
DatabaseResponse dbResponse = proxy.GetDatabases();
foreach (KeyAndValueItem item in dbResponse.Items)
{
LOGGER.Info($"DbId: {item.Id}, Name: {item.Name}");
// query each db details
SPDatabaseDetailsResponse dbDetails = proxy.GetDatabaseDetails(new SPDatabaseDetailsRequest()
{
DatabaseId = item.Id
});
LOGGER.Info($"Currency: {dbDetails.Currency}");
LOGGER.Info($"Population: {dbDetails.Population.ToString()}");
LOGGER.Info($"Sample: {dbDetails.Sample.ToString()}");
LOGGER.Info("Languages:");
foreach (KeyAndValueItem langItem in dbDetails.Languages)
{
LOGGER.Info($"{langItem.Id}, name: {langItem.Name}");
}
LOGGER.Info("-----------");
}
return(View());
}
