public static string GetUserGauges(XmlElement cmdEl)
{
decimal userId = decimal.Parse(cmdEl.GetAttribute("USERID"));
IDashboardSystemDA dacObj = DataAccessFactory.Instance.GetDashboardSystemDA();
FIDataTable dt = dacObj.GetUserGauges(userId);
XmlDocument doc = new XmlDocument();
XmlElement rootEl = (XmlElement)doc.AppendChild(doc.CreateElement("GAUGES"));
if (dt != null && dt.Rows.Count != 0)
{
foreach (DataRow dr in dt.Rows)
{
XmlElement el = (XmlElement)rootEl.AppendChild(doc.CreateElement("GAUGE"));
el.SetAttribute("ID", dr["id"].ToString());
el.SetAttribute("USERID", dr["user_id"].ToString());
el.SetAttribute("NAME", dr["name"].ToString());
el.SetAttribute("TYPE", dr["type"].ToString());
el.SetAttribute("X", dr["x"].ToString());
el.SetAttribute("Y", dr["y"].ToString());
el.SetAttribute("WIDTH", dr["width"].ToString());
el.SetAttribute("HEIGHT", dr["height"].ToString());
el.SetAttribute("VISIBLE", dr["visible"].ToString());
}
}
return(doc.OuterXml);
}
public static void DeleteUserGaugeConfig(XmlElement cmdEl)
{
IDashboardSystemDA dacObj = DataAccessFactory.Instance.GetDashboardSystemDA();
decimal userId = decimal.Parse(cmdEl.GetAttribute("USERID"));
foreach (XmlElement el in cmdEl.SelectNodes("GAUGE"))
{
dacObj.DeleteUserGaugeConfig(
new Guid(el.GetAttribute("ID")),
userId
);
}
}
public static string GetUserGaugeConfig(XmlElement cmdEl)
{
decimal userId = decimal.Parse(cmdEl.GetAttribute("USERID"));
IDashboardSystemDA dacObj = DataAccessFactory.Instance.GetDashboardSystemDA();
XmlDocument doc = new XmlDocument();
XmlElement rootEl = (XmlElement)doc.AppendChild(doc.CreateElement("GAUGES"));
foreach (XmlElement reqEl in cmdEl.SelectNodes("GAUGE"))
{
Guid gaugeId = new Guid(reqEl.GetAttribute("ID"));
bool queryDef = (reqEl.GetAttribute("QUERYDEF") == "1");
bool execQueries = (reqEl.GetAttribute("QUERYRESULT") == "1");
FIDataTable dt = dacObj.GetUserGaugeConfig(userId, gaugeId);
XmlElement el = (XmlElement)rootEl.AppendChild(doc.CreateElement("GAUGE"));
if (dt != null && dt.Rows.Count != 0)
{
DataRow dr = dt.Rows[0];
el.SetAttribute("ID", dr["id"].ToString());
el.SetAttribute("USERID", dr["user_id"].ToString());
el.SetAttribute("NAME", dr["name"].ToString());
el.SetAttribute("TYPE", dr["type"].ToString());
el.SetAttribute("X", dr["x"].ToString());
el.SetAttribute("Y", dr["y"].ToString());
el.SetAttribute("WIDTH", dr["width"].ToString());
el.SetAttribute("HEIGHT", dr["height"].ToString());
el.SetAttribute("VISIBLE", dr["visible"].ToString());
el.SetAttribute("REFRESH", dr["refresh"].ToString());
// config, parse and execute if needed
el.InnerXml = dr["config"].ToString();
if (execQueries)
{
foreach (XmlElement queryEl in el.SelectNodes("VAL[@TYPE='QUERY']"))
{
ExecuteQueries(queryEl, queryDef);
}
}
}
}
return(doc.OuterXml);
}
public static void SaveUserGaugeConfig(XmlElement cmdEl)
{
IDashboardSystemDA dacObj = DataAccessFactory.Instance.GetDashboardSystemDA();
decimal userId = decimal.Parse(cmdEl.GetAttribute("USERID"));
foreach (XmlElement el in cmdEl.SelectNodes("GAUGE"))
{
dacObj.SaveUserGaugeConfig(
new Guid(el.GetAttribute("ID")),
userId,
(!el.HasAttribute("NAME") ? null : el.GetAttribute("NAME")),
(!el.HasAttribute("TYPE") ? null : el.GetAttribute("TYPE")),
(!el.HasAttribute("X") ? -1 : int.Parse(el.GetAttribute("X"))),
(!el.HasAttribute("Y") ? -1 : int.Parse(el.GetAttribute("Y"))),
(!el.HasAttribute("WIDTH") ? -1 : int.Parse(el.GetAttribute("WIDTH"))),
(!el.HasAttribute("HEIGHT") ? -1 : int.Parse(el.GetAttribute("HEIGHT"))),
(!el.HasAttribute("VISIBLE") ? -1 : int.Parse(el.GetAttribute("WIDTH"))),
(!el.HasAttribute("REFRESH") ? -1 : int.Parse(el.GetAttribute("REFRESH"))),
(el.InnerXml == "" ? null : el.InnerXml)
);
}
}
