/// <summary>
/// Grid Settings for better look and feel
/// </summary>
private void InitializePivotGrid()
{
LocalizationProvider.Provider = new Localizer();
pivotGridControl1.ItemSource = ProductSalesData.GetSalesData();
pivotGridControl1.PivotRows.Add(new PivotItem {
FieldMappingName = "Product", FieldCaption = "Product", TotalHeader = "Total"
});
pivotGridControl1.PivotRows.Add(new PivotItem {
FieldMappingName = "Date", TotalHeader = "Total"
});
pivotGridControl1.PivotColumns.Add(new PivotItem {
FieldMappingName = "Country", FieldCaption = "Country", TotalHeader = "Total"
});
pivotGridControl1.PivotColumns.Add(new PivotItem {
FieldMappingName = "State", TotalHeader = "Total"
});
pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "Amount", FieldCaption = "Amount", Format = "C", SummaryType = SummaryType.DoubleTotalSum
});
pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "Quantity", FieldCaption = "Quantity", Format = "#,##0"
});
pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "UnitPrice", FieldCaption = "UnitPrice"
});
pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "TotalPrice", FieldCaption = "TotalPrice"
});
pivotGridControl1.GridVisualStyles = GridVisualStyles.Metro;
pivotGridControl1.ShowPivotTableFieldList = true;
//tab key navigation set as false to move the next control
pivotGridControl1.TableControl.WantTabKey = false;
pivotGridControl1.TableControl.PivotTableFieldList.WantTabKey = false;
pivotGridControl1.TableControl.GridColumnList.WantTabKey = false;
pivotGridControl1.TableControl.GridFilterList.WantTabKey = false;
pivotGridControl1.TableControl.GridRowList.WantTabKey = false;
pivotGridControl1.TableControl.GridValueList.WantTabKey = false;
pivotGridControl1.PivotSchemaDesigner.TabStop = false;
pivotGridControl1.TabStop = false;
LocalizationProvider.Provider = new Localizer();
Localizer loc = new Localizer();
LocalizationProvider.Provider = loc;
}
/// <summary>
/// Grid Settings for better look and feel
/// </summary>
private void InitializePivotGrid()
{
LocalizationProvider.Provider = new Localizer();
pivotGridControl1.ItemSource = ProductSalesData.GetSalesData();
pivotGridControl1.PivotRows.Add(new PivotItem {
FieldMappingName = "Product", FieldCaption = "Product", TotalHeader = "Total"
});
pivotGridControl1.PivotRows.Add(new PivotItem {
FieldMappingName = "Date", TotalHeader = "Total"
});
pivotGridControl1.PivotColumns.Add(new PivotItem {
FieldMappingName = "Country", FieldCaption = "Country", TotalHeader = "Total"
});
pivotGridControl1.PivotColumns.Add(new PivotItem {
FieldMappingName = "State", TotalHeader = "Total"
});
pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "Amount", FieldCaption = "Amount", Format = "C", SummaryType = SummaryType.DoubleTotalSum
});
pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "Quantity", FieldCaption = "Quantity", Format = "#,##0"
});
pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "UnitPrice", FieldCaption = "UnitPrice"
});
pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "TotalPrice", FieldCaption = "TotalPrice"
});
pivotGridControl1.GridVisualStyles = GridVisualStyles.Metro;
pivotGridControl1.ShowPivotTableFieldList = true;
//tab key navigation set as false to move the next control
pivotGridControl1.TableControl.WantTabKey = false;
pivotGridControl1.TableControl.PivotTableFieldList.WantTabKey = false;
pivotGridControl1.TableControl.GridColumnList.WantTabKey = false;
pivotGridControl1.TableControl.GridFilterList.WantTabKey = false;
pivotGridControl1.TableControl.GridRowList.WantTabKey = false;
pivotGridControl1.TableControl.GridValueList.WantTabKey = false;
pivotGridControl1.PivotSchemaDesigner.TabStop = false;
pivotGridControl1.TabStop = false;
string targetPath = Application.StartupPath + "\\" + "de-DE";
#if NETCORE
string sourceFile = Application.StartupPath.Split("\\bin")[0] + "\\de-DE\\Syncfusion.PivotAnalysis.Windows.resources.dll";
#else
string sourceFile = Path.GetFullPath("..\\..\\de-DE\\Syncfusion.PivotAnalysis.Windows.resources.dll");
#endif
if (!Directory.Exists(targetPath))
{
Directory.CreateDirectory(targetPath);
File.Copy(sourceFile, targetPath + "\\Syncfusion.PivotAnalysis.Windows.resources.dll");
#if NETCORE
sourceFile = Application.StartupPath.Split("\\bin")[0] + "\\de-DE\\run.bat";
#else
sourceFile = Path.GetFullPath("..\\..\\de-DE\\run.bat");
#endif
File.Copy(sourceFile, targetPath + "\\run.bat");
}
LocalizationProvider.Provider = new Localizer();
Localizer loc = new Localizer();
LocalizationProvider.Provider = loc;
}