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());
}
public Task <KeyAndValueItem[]> GetDatabasesAsync()
{
using (ComProxy proxy = new ComProxy())
{
// query database(s)
return(Task.FromResult(proxy.GetDatabases().Items.ToArray()));
}
}
public Task <SPDatabaseDetailsResponse> GetDatabaseDetailsAsync(string databaseId)
{
using (ComProxy proxy = new ComProxy())
{
return(Task.FromResult(proxy.GetDatabaseDetails(new SPDatabaseDetailsRequest()
{
DatabaseId = databaseId
})));
}
}
protected void Session_Start(object sender, EventArgs e)
{
if (LOGGER.IsInfoEnabled)
{
LOGGER.Info(string.Format("GLOBAL_ASAX, starting new user session. SessionId: {0}", Session.SessionID));
}
// initialize session to keep the same id and session object
ComProxy proxy = null;
HttpSessionState session = GetSession();
session[Consts.SESSION_COMPROXY] = proxy = new ComProxy();
}
public static object ProxyValue(object val)
{
ComProxy proxy = ComProxy.GetProxy(val);
if (proxy != null)
{
return(proxy.Provider);
}
else if (val != null && ProxyProvider.IsProxyable(val.GetType()))
{
return(new ProxyProvider(val));
}
return(val);
}
public static object DeproxyValue(object val)
{
var pp = val as IProxyProvider;
if (pp != null)
{
if (val is ProxyProvider)
{
return(pp.Instance);
}
else
{
return(ComProxy.GetProxy(pp));
}
}
return(val);
}
public void CleanUpManagedData(object ManagedObj)
{
ComProxy proxy = (ComProxy)RemotingServices.GetRealProxy(ManagedObj);
proxy.Dispose();
}
