private void DashboardControl_DashboardLoaded(object sender, DevExpress.DashboardWpf.DashboardLoadedEventArgs e)
{
var excelDataSource = e.Dashboard.DataSources.FindFirst(i => i.ComponentName == "dashboardExcelDataSource1") as DashboardExcelDataSource;
if (excelDataSource != null)
{
excelDataSource.FileName = dashboardExcelDataFileName;
ExcelWorksheetSettings worksheetSettings = new ExcelWorksheetSettings("Bike Data");
excelDataSource.SourceOptions = new ExcelSourceOptions(worksheetSettings);
excelDataSource.Fill();
}
}
private void dashboardControl_DashboardLoaded(object sender, DevExpress.DashboardWpf.DashboardLoadedEventArgs e)
{
XElement data = e.Dashboard.UserData;
if (data != null)
{
if (data.Element("DashboardState") != null)
{
XDocument dStateDocument = XDocument.Parse(data.Element("DashboardState").Value);
dState.LoadFromXml(XDocument.Parse(data.Element("DashboardState").Value));
}
}
}
private void dashboardControl_DashboardLoaded(object sender, DevExpress.DashboardWpf.DashboardLoadedEventArgs e)
{
}
private void DashboardViewerUniconta_DashboardLoaded(object sender, DevExpress.DashboardWpf.DashboardLoadedEventArgs e)
{
Dashboard dasdboard = e.Dashboard;
foreach (var item in dasdboard?.Items)
{
var name = dasdboard?.CustomProperties.GetValue(item.ComponentName);
if (name != null)
{
if (name[0] == '&')
{
item.Name = Uniconta.ClientTools.Localization.lookup(name.Substring(1));
}
;
}
}
if (!dasdboard.Title.ShowMasterFilterState)
{
rowFilter.Visibility = Visibility.Collapsed;
}
XElement data = e.Dashboard.UserData;
if (data != null)
{
var state = data.Element("DashboardState");
if (state != null)
{
dState.LoadFromXml(XDocument.Parse(state.Value));
}
var fixedComps = data.Element("FixedCompanies");
if (fixedComps != null)
{
fixedCompanies = null;
var rootelement = XElement.Parse(fixedComps.ToString());
foreach (var el in rootelement.Elements())
{
var fxdComps = XDocument.Parse(el.ToString()).Elements("FixedCompany")
.Select(p => new FixedCompany
{
CompanyId = int.Parse(p.Element("CompanyId").Value),
DatasourceName = p.Element("DatasourceName").Value
}).ToList();
if (fixedCompanies != null)
{
fixedCompanies.AddRange(fxdComps);
}
else
{
fixedCompanies = fxdComps;
}
}
if (fixedCompanies != null)
{
for (int i = 0; i < fixedCompanies.Count; i++)
{
var comp = CWDefaultCompany.loadedCompanies.FirstOrDefault(x => x.CompanyId == fixedCompanies[i].CompanyId) as Company;
var openComp = OpenFixedCompany(comp).GetAwaiter().GetResult();
if (openComp != null)
{
openComp.GenerateUserType();
LoadListOfTableTypes(openComp);
}
else
{
UnicontaMessageBox.Show(Uniconta.ClientTools.Localization.lookup("UserNoAccessToCompany"), Uniconta.ClientTools.Localization.lookup("Information"));
}
}
}
}
var ldOnOpn = data.Element("LoadOnOpen");
if (ldOnOpn != null)
{
LoadOnOpen = bool.Parse(ldOnOpn.Value);
}
var userId = data.Element("LogedInUserIdFilter");
if (userId != null)
{
UserIdPropName = userId.Value;
}
var filters = data.Element("Filters");
if (filters != null)
{
var filtersBytes = Convert.FromBase64String(filters.Value);
var r = StreamingManagerReuse.Create(filtersBytes);
int version = r.readByte();
if (version != 0)
{
if (version < 3 && r.readBoolean())
{
int filterCount = (int)StreamingManager.readNum(r);
for (int i = 0; i < filterCount; i++)
{
var key = r.readString();
List <PropValuePair> propVal = new List <PropValuePair>();
var arrpropval = (PropValuePair[])r.ToArray(typeof(PropValuePair));
propVal = arrpropval.ToList();
lstOfFilters.Add(key, arrpropval);
}
}
else
{
int filterCount = (int)StreamingManager.readNum(r);
for (int i = 0; i < filterCount; i++)
{
var key = r.readString();
var arrFilter = (FilterProperties[])r.ToArray(typeof(FilterProperties));
lstOfNewFilters.Add(key, arrFilter.ToList());
}
}
}
if (r.readBoolean())
{
if (version < 3)
{
int sortCount = (int)r.readNum();
for (int i = 0; i < sortCount; i++)
{
var key = r.readString();
var arrSort = (SortingProperties[])r.ToArray(typeof(SortingProperties));
FilterSorter propSort = new FilterSorter(arrSort);
lstOfSorters.Add(key, propSort);
}
}
}
r.Release();
}
}
else
{
LoadOnOpen = true; // for old saved dashboards
}
if (LoadOnOpen)
{
foreach (var ds in e.Dashboard.DataSources)
{
dataSourceLoadingParams.Add(ds.ComponentName);
}
}
}
private void DashboardViewerUniconta_DashboardLoaded(object sender, DevExpress.DashboardWpf.DashboardLoadedEventArgs e)
{
Dashboard dasdboard = e.Dashboard;
foreach (var item in dasdboard?.Items)
{
var name = dasdboard?.CustomProperties.GetValue(item.ComponentName);
if (name != null)
{
if (name[0] == '&')
{
item.Name = Uniconta.ClientTools.Localization.lookup(name.Substring(1));
}
;
}
}
if (!dasdboard.Title.ShowMasterFilterState)
{
rowFilter.Visibility = Visibility.Collapsed;
}
XElement data = e.Dashboard.UserData;
if (data != null)
{
var state = data.Element("DashboardState");
if (state != null)
{
dState.LoadFromXml(XDocument.Parse(state.Value));
}
var fixedComps = data.Element("FixedCompanies");
if (fixedComps != null)
{
fixedCompanies = null;
var rootelement = XElement.Parse(fixedComps.ToString());
foreach (var el in rootelement.Elements())
{
var fxdComps = XDocument.Parse(el.ToString()).Elements("FixedCompany")
.Select(p => new FixedCompany
{
CompanyId = int.Parse(p.Element("CompanyId").Value),
DatasourceName = p.Element("DatasourceName").Value
}).ToList();
if (fixedCompanies != null)
{
fixedCompanies.AddRange(fxdComps);
}
else
{
fixedCompanies = fxdComps;
}
}
if (fixedCompanies != null)
{
for (int i = 0; i < fixedCompanies.Count; i++)
{
var comp = CWDefaultCompany.loadedCompanies.FirstOrDefault(x => x.CompanyId == fixedCompanies[i].CompanyId) as Company;
var openComp = OpenFixedCompany(comp).GetAwaiter().GetResult();
if (openComp != null)
{
LoadListOfTableTypes(openComp);
}
else
{
UnicontaMessageBox.Show(Uniconta.ClientTools.Localization.lookup("UserNoAccessToCompany"), Uniconta.ClientTools.Localization.lookup("Information"));
}
}
}
}
var ldOnOpn = data.Element("LoadOnOpen");
if (ldOnOpn != null)
{
LoadOnOpen = bool.Parse(ldOnOpn.Value);
}
var userId = data.Element("LogedInUserIdFilter");
if (userId != null)
{
UserIdPropName = userId.Value;
}
#region Dashboard user fields
var dshbdUserFls = data.Element("DashboardUserFields");
if (dshbdUserFls != null)
{
var nodes = dshbdUserFls.Nodes();
dashboardUserFields = new Dictionary <string, List <DashboardUserField> >();
foreach (var node in nodes)
{
if (node is XElement)
{
var name = ((XElement)node).Name;
var rt = XElement.Parse(node.ToString());
var userLst = new List <DashboardUserField>();
foreach (var el in rt.Elements())
{
var xml = el.ToString();
var fxdComps = XDocument.Parse(xml).Elements("DashboardUserField")
.Select(p => new DashboardUserField
{
FieldName = p.Element("FieldName").Value,
Value = p.Element("Value").Value,
DataType = (byte)(p.Element("DataType") != null ? Convert.ToByte(p.Element("DataType").Value) : 0)
}).ToList();
userLst.AddRange(fxdComps);
}
dashboardUserFields.Add(name.ToString(), userLst);
}
}
}
#endregion
}
else
{
LoadOnOpen = true; // for old saved dashboards
}
if (LoadOnOpen)
{
foreach (var ds in e.Dashboard.DataSources)
{
dataSourceLoadingParams.Add(ds.ComponentName);
}
}
}