// singleton pattern
public void OnSystemRestart()
{
CleanupTempDir();
FI.Common.DataAccess.IOlapSystemDA dac = DataAccessFactory.Instance.GetOlapSystemDA();
dac.ResetOlapSystem();
}
public XmlElement GetMemberGrandParent(string HierUniqueName, string MemUniqueName)
{
FI.Common.DataAccess.IOlapSystemDA dacObj = DataAccessFactory.Instance.GetOlapSystemDA();
string xml = dacObj.GetMemberGrandParent(Server, Database, Cube, HierUniqueName, MemUniqueName);
XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);
return((XmlElement)doc.FirstChild);
}
public XmlElement GetMemberChildren(string UniqueName, bool IfLeafAddItself)
{
FI.Common.DataAccess.IOlapSystemDA dacObj = DataAccessFactory.Instance.GetOlapSystemDA();
string xml = dacObj.GetMemberChildren(Server, Database, Cube, UniqueName, IfLeafAddItself);
XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);
return((XmlElement)doc.FirstChild);
}
public XmlElement GetSchemaMembers(string[] UniqueNames)
{
FI.Common.DataAccess.IOlapSystemDA dacObj = DataAccessFactory.Instance.GetOlapSystemDA();
string xml = dacObj.GetSchemaMembers(Server, Database, Cube, UniqueNames);
XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);
return((XmlElement)doc.FirstChild);
}
// singleton pattern
public void OnSystemRestart()
{
System.Diagnostics.StackTrace stack = new System.Diagnostics.StackTrace();
Common.LogWriter.Instance.WriteEventLogEntry("DistributionManager OnSystemRestart\r\n" + stack.ToString(),
System.Diagnostics.EventLogEntryType.Warning);
CleanupTempDir();
FI.Common.DataAccess.IOlapSystemDA dac = DataAccessFactory.Instance.GetOlapSystemDA();
dac.ResetOlapSystem();
}
protected internal override void _CancelExecute()
{
if (_asyncResult == null || _asyncResult.IsCompleted == true)
{
return; // nothing to cancel
}
if (_olapTaskGuid == Guid.Empty)
{
return;
}
FI.Common.DataAccess.IOlapSystemDA dacOlapSystem = DataAccessFactory.Instance.GetOlapSystemDA();
dacOlapSystem.CancelOlapCommand(_olapTaskGuid.ToString());
_asyncResult = null;
_olapTaskGuid = Guid.Empty;
}
protected internal override void _BeginExecute()
{
if (_mdx == "")
{
BuildMdx();
}
if (_olapTaskGuid == Guid.Empty)
{
_olapTaskGuid = System.Guid.NewGuid();
}
string taskTag = string.Format("User: {0} ({1}), OlapReport: {2} ({3})",
this._owner.Name, this._owner.ID, this.Name, this.ID);
FI.Common.DataAccess.IOlapSystemDA dacOlapSystem = DataAccessFactory.Instance.GetOlapSystemDA();
_asyncDelegate = new ExecuteDelegate(dacOlapSystem.BuildCellset);
_asyncResult = _asyncDelegate.BeginInvoke(Schema.Server, Schema.Database, _mdx, _olapTaskGuid.ToString(), taskTag, null, null);
}
override protected internal void _Execute()
{
try
{
string taskGuid = Guid.NewGuid().ToString();
string taskDescription = string.Format("User: {0} ({1}), CustomMdxReport: {2} ({3})",
this._owner.Name, this._owner.ID, this.Name, this.ID);
FI.Common.DataAccess.IOlapSystemDA dacOlapSystem = DataAccessFactory.Instance.GetOlapSystemDA();
string data = dacOlapSystem.BuildCellset(this.SchemaServer, this.SchemaDatabase, null, this.Mdx, taskGuid, taskDescription, "CustomMdx", this.ID);
this._cellset.LoadCellset(data);
_error = "";
}
catch (Exception exc)
{
_error = exc.Message;
throw exc;
}
}
public void PingOlapSystem(string Mdx, string MailTo)
{
bool failure = false;
System.IO.StringWriter sw = new System.IO.StringWriter();
// get all companies
FI.Common.DataAccess.IUsersDA usersDac = DataAccessFactory.Instance.GetUsersDA();
System.Data.DataTable table = usersDac.ReadCompanies();
if (table == null || table.Rows.Count == 0)
{
return;
}
sw.WriteLine("<html>");
sw.WriteLine("Failed Ping Queries (" + System.DateTime.Today.ToShortDateString() + " " + System.DateTime.Now.ToShortTimeString() + ")");
sw.WriteLine("<br><br>");
sw.WriteLine("<table border=1 width=100%>");
try
{
foreach (System.Data.DataRow row in table.Rows)
{
if ((bool)row["Ping"] == true)
{
string company = row["ShortName"].ToString();
string server = row["OlapServer"].ToString();
string database = row["OlapDatabase"].ToString();
try
{
string taskGuid = Guid.NewGuid().ToString();
string taskTag = string.Format("Ping");
FI.Common.DataAccess.IOlapSystemDA olapDac = DataAccessFactory.Instance.GetOlapSystemDA();
olapDac.BuildCellset(Mdx, server, database, taskGuid, taskTag);
}
catch (Exception exc)
{
failure = true;
sw.Write("<tr>");
sw.Write("<td>");
sw.Write(company);
sw.Write("</td><td>");
sw.Write(exc.Message);
sw.Write("</td>");
sw.WriteLine("</tr>");
Common.LogWriter.Instance.WriteEventLogEntry(exc);
}
}
}
}
catch (Exception exc) //more common exception
{
failure = true;
sw.Write("<tr>");
sw.Write(exc.Message);
sw.Write("</td>");
sw.WriteLine("</tr>");
Common.LogWriter.Instance.WriteEventLogEntry(exc);
}
sw.WriteLine("</table></html>");
//send via email
if (failure)
{
try
{
// message
OpenSmtp.Mail.MailMessage msg = new OpenSmtp.Mail.MailMessage();
msg.From = new OpenSmtp.Mail.EmailAddress(FI.Common.AppConfig.SmtpSender);
msg.To.Add(new OpenSmtp.Mail.EmailAddress(MailTo));
msg.Subject = "Failed Ping Queries";
msg.Priority = "High";
msg.HtmlBody = sw.ToString();
// smtp host
OpenSmtp.Mail.Smtp smtp = new OpenSmtp.Mail.Smtp();
smtp.Host = FI.Common.AppConfig.SmtpServer;
if (FI.Common.AppConfig.SmtpUserName != null && FI.Common.AppConfig.SmtpUserName != "")
{
smtp.Username = FI.Common.AppConfig.SmtpUserName;
smtp.Password = FI.Common.AppConfig.SmtpPassword;
}
smtp.SendMail(msg);
}
catch (Exception exc)
{
// because real exception is inside:
while (exc.InnerException != null)
{
exc = exc.InnerException;
}
throw exc;
}
}
}
// singleton pattern
public FI.Common.Data.FIDataTable GetOlapProcessorInfo()
{
FI.Common.DataAccess.IOlapSystemDA olapDao = DataAccessFactory.Instance.GetOlapSystemDA();
return(olapDao.GetOlapProcessorInfo());
}
