protected void ASPxPivotGrid1_CustomCallback(object sender, PivotGridCustomCallbackEventArgs e)
{
ASPxPivotGrid pivot = (ASPxPivotGrid)sender;
pivot.JSProperties["cpAlertMessage"] = null;
string[] parameters = e.Parameters.Split(new char[] { '|' });
if (parameters.Length == 5 && parameters[0] == "MenuItemClick")
{
if (parameters[1] == "hideValue")
{
bool isColumn = parameters[4] == "ColumnArea";
PivotFieldValueEventArgs fieldValueInfo = pivot.GetFieldValueInfo(isColumn, Convert.ToInt32(parameters[3]));
if (isColumn)
{
pivot.JSProperties["cpAlertMessage"] = string.Format("Cannot hide the {0} column", fieldValueInfo.Value);
}
else
{
if (fieldValueInfo.Field != null)
{
fieldValueInfo.Field.FilterValues.Add(fieldValueInfo.Value);
}
}
}
}
}
protected void ASPxPivotGrid1_CustomCallback(object sender, PivotGridCustomCallbackEventArgs e)
{
string[] args = e.Parameters.Split('|');
if (args[0] == "SC")
{
HandleSortByColumnClick((ASPxPivotGrid)sender, args);
}
}
void PivotGrid_CustomCallback(object sender, PivotGridCustomCallbackEventArgs e)
{
string[] parameters = e.Parameters.Split(",".ToCharArray());
var field = PivotGrid.Fields.GetFieldByName(parameters[0]);
var selectedValueStr = parameters.Skip(1).OrderBy(v => v).ToArray();
object[] uniqueValues = field.GetUniqueValues();
object[] valuesExcluded = uniqueValues.Where(v => !ContainItem(selectedValueStr, Convert.ToString(v))).ToArray();
field.FilterValues.ValuesExcluded = valuesExcluded;
}
void PivotGridControlOnCustomCallback(object sender, PivotGridCustomCallbackEventArgs pivotGridCustomCallbackEventArgs) {
var args = pivotGridCustomCallbackEventArgs.Parameters.Split('|');
var columnIndex = Convert.ToInt32(args[0]);
var rowIndex = Convert.ToInt32(args[1]);
var value = Convert.ToDouble(args[2]);
var asPxPivotGrid = ((ASPxPivotGrid)sender);
var pivotDrillDownDataSource = asPxPivotGrid.CreateDrillDownDataSource(columnIndex, rowIndex);
for (int i = 0; i < pivotDrillDownDataSource.RowCount; i++) {
pivotDrillDownDataSource[i]["Amount"] = Convert.ToDouble(value);
}
}
void PivotGridControlOnCustomCallback(object sender, PivotGridCustomCallbackEventArgs pivotGridCustomCallbackEventArgs)
{
var args = pivotGridCustomCallbackEventArgs.Parameters.Split('|');
var columnIndex = Convert.ToInt32(args[0]);
var rowIndex = Convert.ToInt32(args[1]);
var value = Convert.ToDouble(args[2]);
var asPxPivotGrid = ((ASPxPivotGrid)sender);
var pivotDrillDownDataSource = asPxPivotGrid.CreateDrillDownDataSource(columnIndex, rowIndex);
for (int i = 0; i < pivotDrillDownDataSource.RowCount; i++)
{
pivotDrillDownDataSource[i]["Amount"] = Convert.ToDouble(value);
}
}
protected void OnPivotCustomCallback(object sender, PivotGridCustomCallbackEventArgs e)
{
ASPxPivotGrid pivot = (ASPxPivotGrid)sender;
string[] args = e.Parameters.Split('|');
int colIndex = int.Parse(args[1]);
int rowIndex = int.Parse(args[2]);
ChangeCellValue(
pivot.CreateDrillDownDataSource(colIndex, rowIndex),
(decimal)pivot.GetCellValue(colIndex, rowIndex),
decimal.Parse(args[3], NumberStyles.Currency)
);
}
protected void ASPxPivotGrid1_CustomCallback(object sender, PivotGridCustomCallbackEventArgs e)
{
if (String.IsNullOrEmpty(e.Parameters))
{
return;
}
String[] args = e.Parameters.Split('|');
if (args[0] == "MenuItemClick")
{
switch (args[1])
{
case "Filter":
PivotGridField field = ASPxPivotGrid1.Fields[args[2]];
int itemIndex = Int32.Parse(args[3]);
Object filterValue = ASPxPivotGrid1.GetFieldValueByIndex(field, itemIndex);
field.FilterValues.ValuesIncluded = new Object[] { filterValue };
break;
}
}
}
protected void OnASPxPivotGridCustomCallback(object sender, PivotGridCustomCallbackEventArgs e)
{
string[] args = e.Parameters.Split('|');
if ("SL" == args[0])
{
if (null == Session["SelectedValue"])
{
Session.Add("SelectedValue", args[1]);
}
else
{
Session["SelectedValue"] = args[1];
}
if (null == Session["SelectedArea"])
{
Session.Add("SelectedArea", Enum.Parse(typeof(PivotArea), args[2]));
}
else
{
Session["SelectedArea"] = Enum.Parse(typeof(PivotArea), args[2]);
}
}
}
