void service_GetMembersDataCompleted(object sender, Ranet.AgOlap.OlapWebService.GetMembersDataCompletedEventArgs e)
{
InvokeResultDescriptor result = XmlSerializationUtility.XmlStr2Obj <InvokeResultDescriptor>(e.Result);
if (result != null)
{
//if (result.IsArchive)
//{
// result.Content = ZipCompressor.DecompressFromBase64String(result.Content);
// result.IsArchive = false;
//}
Raise_DataLoaded(new DataLoaderEventArgs(result, e.Error, e.UserState));
}
}
String PerformStorageAction(String schema)
{
InvokeResultDescriptor result = new InvokeResultDescriptor();
String res = String.Empty;
try
{
StorageActionArgs args = XmlSerializationUtility.XmlStr2Obj <StorageActionArgs>(schema);
if (args != null)
{
FileStorageProvider storageProvider = new FileStorageProvider();
switch (args.ActionType)
{
case StorageActionTypes.Save:
args.FileDescription.ContentFileName = args.FileDescription.Description.Name + ".content." + FileStorageProvider.GetFilteExtension(args.ContentType);
storageProvider.Save(HttpContext.Current.User, args.FileDescription.Description.Name + "." + FileStorageProvider.GetFilteExtension(args.ContentType), XmlSerializationUtility.Obj2XmlStr(args.FileDescription));
storageProvider.Save(HttpContext.Current.User, args.FileDescription.ContentFileName, args.Content);
break;
case StorageActionTypes.Load:
res = storageProvider.Load(HttpContext.Current.User, args.FileDescription.ContentFileName);
break;
case StorageActionTypes.GetList:
res = XmlSerializationUtility.Obj2XmlStr(storageProvider.GetList(HttpContext.Current.User, "*." + FileStorageProvider.GetFilteExtension(args.ContentType)), Common.Namespace);
break;
case StorageActionTypes.Clear:
res = XmlSerializationUtility.Obj2XmlStr(storageProvider.Clear(HttpContext.Current.User, "*." + FileStorageProvider.GetFilteExtension(args.ContentType)));
break;
case StorageActionTypes.Delete:
storageProvider.Delete(HttpContext.Current.User, args.FileDescription.Description.Name + "." + FileStorageProvider.GetFilteExtension(args.ContentType));
storageProvider.Delete(HttpContext.Current.User, args.FileDescription.ContentFileName);
res = XmlSerializationUtility.Obj2XmlStr(storageProvider.GetList(HttpContext.Current.User, "*." + FileStorageProvider.GetFilteExtension(args.ContentType)), Common.Namespace);
break;
}
}
result.Content = res;
}
catch (Exception)
{
throw;
}
return(InvokeResultDescriptor.Serialize(result));
}
public virtual String PerformOlapServiceAction(String schemaType, String schema)
{
DateTime start = DateTime.Now;
try
{
System.Diagnostics.Trace.TraceInformation("{0} PerformOlapServiceAction \r\n SCHEMA_TYPE: {1} \r\n SCHEMA: {2} \r\n",
DateTime.Now.ToString(), schemaType, schema);
object type = OlapActionTypes.Parse(typeof(OlapActionTypes), schemaType, true);
if (type != null)
{
OlapActionTypes actionType = (OlapActionTypes)type;
switch (actionType)
{
case OlapActionTypes.GetMetadata:
return(GetMetaData(schema));
case OlapActionTypes.StorageAction:
return(PerformStorageAction(schema));
case OlapActionTypes.ExportToExcel:
return(ExportToExcel(schema));
case OlapActionTypes.ExecuteQuery:
return(ExecuteQuery(schema));
}
}
InvokeResultDescriptor result = new InvokeResultDescriptor();
return(InvokeResultDescriptor.Serialize(result));
}
catch (Exception ex)
{
InvokeResultDescriptor result = new InvokeResultDescriptor();
result.Content = ex.ToString();
result.ContentType = InvokeContentType.Error;
System.Diagnostics.Trace.TraceError("{0} PerformOlapServiceAction ERROR: {1}\r\n",
DateTime.Now.ToString(), ex.ToString());
return(InvokeResultDescriptor.Serialize(result));
}
finally {
System.Diagnostics.Trace.TraceInformation("{0} PerformOlapServiceAction: {1} completed \r\n time: {2} \r\n",
DateTime.Now.ToString(), schemaType, (DateTime.Now - start).ToString());
}
}
//void ModifyEndPoint(OlapWebService.OlapWebServiceSoapClient service)
//{
// if (service != null)
// {
// if (!String.IsNullOrEmpty(URL))
// {
// service.Endpoint.Address = new System.ServiceModel.EndpointAddress(new Uri(URL));
// }
// else
// {
// service.Endpoint.Address = new System.ServiceModel.EndpointAddress(new Uri(Application.Current.Host.Source, "/OlapWebService.asmx"));
// }
// }
//}
#region IStorageManager Members
void service_PerformStorageActionCompleted(object sender, Ranet.AgOlap.OlapWebService.PerformOlapServiceActionCompletedEventArgs e)
{
InvokeResultDescriptor result = null;
if (e.Error == null)
{
result = InvokeResultDescriptor.Deserialize(e.Result);
}
if (result != null)
{
if (result.IsArchive)
{
result.Content = ZipCompressor.DecompressFromBase64String(result.Content);
result.IsArchive = false;
}
Raise_InvokeCompleted(new DataLoaderEventArgs(result, e.Error, e.UserState));
}
}
private String ExportToExcel(String schema)
{
InvokeResultDescriptor result = new InvokeResultDescriptor();
String res = String.Empty;
try
{
String sessionId = String.Empty;
String connection = String.Empty;
try
{
MdxQueryArgs args = XmlSerializationUtility.XmlStr2Obj <MdxQueryArgs>(schema);
if (args != null)
{
sessionId = args.SessionId;
connection = args.Connection;
DefaultQueryExecuter queryExecuter = new DefaultQueryExecuter(GetConnection(args.Connection));
if (args.Queries.Count > 0)
{
res = queryExecuter.GetCellSetDescription(args.Queries[0], ref sessionId);
}
}
}
catch (AdomdConnectionException connection_ex)
{
result.Content = connection_ex.Message;
result.ContentType = InvokeContentType.Error;
}
catch (AdomdErrorResponseException response_ex)
{
result.Content = response_ex.Message;
result.ContentType = InvokeContentType.Error;
}
catch (AdomdUnknownResponseException unknown_ex)
{
result.Content = unknown_ex.Message;
result.ContentType = InvokeContentType.Error;
}
catch (InvalidOperationException invalid_ex)
{
result.Content = invalid_ex.Message;
result.ContentType = InvokeContentType.Error;
}
if (!String.IsNullOrEmpty(res))
{
CellSetData cs = CellSetData.Deserialize(res);
PivotDataProvider pivotProvider = new PivotDataProvider(new CellSetDataProvider(cs));
res = ExportHelper.ExportToExcel(pivotProvider);
}
result.Content = res;
if (UseCompress)
{
// Архивация строки
String compesed = ZipCompressor.CompressAndConvertToBase64String(res);
result.Content = compesed;
result.IsArchive = true;
}
result.ContentType = InvokeContentType.MultidimData;
result.Headers.Add(new Header(InvokeResultDescriptor.SESSION_ID, sessionId));
result.Headers.Add(new Header(InvokeResultDescriptor.CONNECTION_ID, connection));
}
catch (Exception)
{
throw;
}
return(InvokeResultDescriptor.Serialize(result));
}
String ExecuteQuery(String schema)
{
InvokeResultDescriptor result = new InvokeResultDescriptor();
String res = String.Empty;
try
{
String sessionId = String.Empty;
MdxQueryArgs args = XmlSerializationUtility.XmlStr2Obj <MdxQueryArgs>(schema);
if (args != null)
{
sessionId = args.SessionId;
DefaultQueryExecuter queryExecuter = new DefaultQueryExecuter(GetConnection(args.Connection));
if (args.Queries.Count > 0)
{
result.ContentType = InvokeContentType.MultidimData;
switch (args.Type)
{
case QueryTypes.Update:
case QueryTypes.CommitTransaction:
case QueryTypes.RollbackTransaction:
List <String> results = new List <String>();
result.ContentType = InvokeContentType.UpdateResult;
foreach (var query in args.Queries)
{
try
{
// Method return a value of one (1).
queryExecuter.ExecuteNonQuery(query, ref sessionId);
results.Add(String.Empty);
}
catch (AdomdConnectionException connection_ex)
{
results.Add(connection_ex.Message);
}
catch (AdomdErrorResponseException response_ex)
{
results.Add(response_ex.Message);
}
catch (AdomdUnknownResponseException unknown_ex)
{
results.Add(unknown_ex.Message);
}
catch (InvalidOperationException invalid_ex)
{
results.Add(invalid_ex.Message);
}
}
res = XmlSerializationUtility.Obj2XmlStr(results, Common.Namespace);
break;
case QueryTypes.Select:
try
{
res = queryExecuter.GetCellSetDescription(args.Queries[0], ref sessionId);
}
catch (AdomdConnectionException connection_ex)
{
res = connection_ex.Message;
result.ContentType = InvokeContentType.Error;
}
catch (AdomdErrorResponseException response_ex)
{
res = response_ex.Message;
result.ContentType = InvokeContentType.Error;
}
catch (AdomdUnknownResponseException unknown_ex)
{
res = unknown_ex.Message;
result.ContentType = InvokeContentType.Error;
}
catch (InvalidOperationException invalid_ex)
{
res = invalid_ex.Message;
result.ContentType = InvokeContentType.Error;
}
break;
case QueryTypes.DrillThrough:
try
{
var table = queryExecuter.ExecuteReader(args.Queries[0], ref sessionId);
if (table != null)
{
res = XmlSerializationUtility.Obj2XmlStr(DataTableHelper.Create(table));
}
}
catch (AdomdConnectionException connection_ex)
{
res = connection_ex.Message;
result.ContentType = InvokeContentType.Error;
}
catch (AdomdErrorResponseException response_ex)
{
res = response_ex.Message;
result.ContentType = InvokeContentType.Error;
}
catch (AdomdUnknownResponseException unknown_ex)
{
res = unknown_ex.Message;
result.ContentType = InvokeContentType.Error;
}
catch (InvalidOperationException invalid_ex)
{
res = invalid_ex.Message;
result.ContentType = InvokeContentType.Error;
}
break;
}
}
}
result.Content = res;
System.Diagnostics.Debug.WriteLine("CellSetData size: " + res.Length);
if (UseCompress)
{
DateTime start = DateTime.Now;
// Архивация строки
String compesed = ZipCompressor.CompressAndConvertToBase64String(res);
System.Diagnostics.Debug.WriteLine("CellSetData compression time: " + (DateTime.Now - start).ToString());
System.Diagnostics.Debug.WriteLine("CellSetData compressed size: " + compesed.Length);
result.Content = compesed;
result.IsArchive = true;
}
result.Headers.Add(new Header(InvokeResultDescriptor.SESSION_ID, sessionId));
result.Headers.Add(new Header(InvokeResultDescriptor.CONNECTION_ID, args.Connection));
}
catch (Exception ex)
{
throw;
}
return(InvokeResultDescriptor.Serialize(result));
}
String GetMetaData(String schema)
{
InvokeResultDescriptor result = new InvokeResultDescriptor();
String res = null;
try
{
MetadataQuery args = XmlSerializationUtility.XmlStr2Obj <MetadataQuery>(schema);
if (args != null)
{
switch (args.QueryType)
{
case MetadataQueryType.GetCubes:
res = GetCubes(args);
break;
case MetadataQueryType.GetMeasures:
res = GetMeasures(args);
break;
case MetadataQueryType.GetKPIs:
res = GetKPIs(args);
break;
case MetadataQueryType.GetLevels:
res = GetLevels(args);
break;
case MetadataQueryType.GetDimensions:
res = GetDimensions(args);
break;
case MetadataQueryType.GetHierarchies:
res = GetHierarchies(args);
break;
case MetadataQueryType.GetDimension:
res = GetDimension(args);
break;
case MetadataQueryType.GetHierarchy:
res = GetHierarchy(args);
break;
case MetadataQueryType.GetMeasureGroups:
res = GetMeasureGroups(args);
break;
case MetadataQueryType.GetLevelProperties:
res = GetLevelProperties(args);
break;
case MetadataQueryType.GetCubeMetadata:
case MetadataQueryType.GetCubeMetadata_AllMembers:
res = GetCubeMetadata(args);
break;
}
}
result.Content = res;
if (UseCompress)
{
// Архивация строки
String compesed = ZipCompressor.CompressAndConvertToBase64String(res);
result.Content = compesed;
result.IsArchive = true;
}
result.ContentType = InvokeContentType.MultidimData;
}
catch (AdomdConnectionException connection_ex)
{
result.Content = connection_ex.Message;
result.ContentType = InvokeContentType.Error;
}
catch (AdomdErrorResponseException response_ex)
{
result.Content = response_ex.Message;
result.ContentType = InvokeContentType.Error;
}
catch (OlapMetadataResponseException metadata_ex)
{
result.Content = metadata_ex.Message;
result.ContentType = InvokeContentType.Error;
}
catch (Exception)
{
throw;
}
return(InvokeResultDescriptor.Serialize(result));
}
public DataLoaderEventArgs(InvokeResultDescriptor result, Exception error, object state)
{
Error = error;
m_Result = result;
UserState = state;
}
